24/02/2025 14:54:12.3797 13374 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 24/02/2025 14:54:12.4167 16390 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 24/02/2025 14:54:14.2466 556 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-02-24 14:54:13',extBarrier = 0, extTerId = 1 24/02/2025 14:54:14.2476 831 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 24/02/2025 14:54:14.2476 556 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-02-24 14:54:13',extLoop1 = 1, extTerId = 2, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' 24/02/2025 14:54:14.2526 560 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-02-24 14:54:13',extLoop2 = 0, extTerId = 16 24/02/2025 14:54:14.2536 560 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-02-24 14:54:13',extLoop1 = 0, extTerId = 16, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '', extCode = '' 24/02/2025 14:54:14.3848 662 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 24/02/2025 14:54:14.5149 1155 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 24/02/2025 14:54:14.7770 523 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-02-24 13:54:14') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-24 14:54:13' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-24 14:54:13' and (resAreId = 1 or resAreId <= 0) nr: 0 24/02/2025 14:54:14.7800 522 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-02-24 13:54:14') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-24 14:54:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-24 14:54:14' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 2 ms.) 24/02/2025 14:54:27.5137 13123 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 24/02/2025 14:54:28.3963 2069 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457105350000327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 24/02/2025 14:54:28.3973 12795 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457105350000327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 24/02/2025 14:54:28.5024 735 ms. OPEN: select traCode from movTransit where traCode ='457105366600327005012999' 24/02/2025 14:54:30.2064 948 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 24/02/2025 14:54:30.2074 948 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 24/02/2025 14:54:31.9901 2674 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-24 14:54:29','V',5665595978228930,2025,'2025-02-24 14:54:26','457105366600327005012999',1,2,16,'I','',1,0,1,'','',4) 24/02/2025 14:54:31.9911 1768 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-24 14:54:30','V',5601276515089720,2025,'2025-02-24 14:51:40','457105350000327005031999',1,2,16,'I','',1,0,1,'','',4) 24/02/2025 14:54:31.9911 1771 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-24 14:54:30','V',5174696220176560,2025,'2025-02-24 14:51:40','457105350000327005031999',1,2,16,'I','',1,0,1,'','',4) 24/02/2025 14:54:33.7824 1668 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/02/2025 14:54:33.8735 1866 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/02/2025 14:54:33.8735 1868 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/02/2025 14:54:34.8036 6965 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/02/2025 14:54:37.8427 3835 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '457105366600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 24/02/2025 14:54:38.8106 4005 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 24/02/2025 14:55:00.4905 1959 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-24 14:54:58','V',5256424976053750,2025,'2025-02-24 14:54:45','457105368400327005031999',1,2,16,'I','',1,0,1,'','',4)