23/01/2025 06:17:36.5610 765 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 23/01/2025 08:29:45.1798 8080 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/01/2025 08:29:45.1838 8082 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 13 ms.) 23/01/2025 08:29:45.1848 8084 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 11 ms.) 23/01/2025 08:29:45.1848 8085 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 11 ms.) 23/01/2025 08:29:45.1868 8085 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 14 ms.) 23/01/2025 08:29:45.1968 8108 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 23/01/2025 08:29:45.2098 8089 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 32 ms.) 23/01/2025 08:29:45.2108 8135 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 23/01/2025 08:29:47.7755 1237 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 23/01/2025 08:29:47.9066 1239 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 23/01/2025 08:29:54.9525 6265 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788205230' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2025 08:29:54.9665 4957 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456783036000327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2025 08:29:57.4091 9153 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 23/01/2025 08:29:58.2176 1211 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-01-23 08:29:57','V',5717951239671080,2025,'2025-01-23 08:26:00','456783036000327005031999',1,2,16,'I','',1,0,1,'','',4) 23/01/2025 08:29:58.2727 1838 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-23 08:29:56','V',4650533049885000,2025,'2025-01-23 08:28:41','456782695100327002029999',2,1,2,'O','',1,0,1,'','0532370690734',29,0) 23/01/2025 08:29:59.6556 1405 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 08:29:59.6566 1380 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 08:30:02.5135 4668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 08:30:05.1589 2645 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); 23/01/2025 08:30:15.4061 809 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 = '456782895700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/01/2025 08:30:16.9592 760 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 23/01/2025 10:33:41.7869 4113 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 23/01/2025 10:33:42.5504 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:33:45.9697 1303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 11:05:43.3315 1551 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/01/2025 11:05:43.3475 1553 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 21 ms.) 23/01/2025 11:05:43.3536 1559 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 22 ms.) 23/01/2025 11:05:43.3566 1562 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 22 ms.) 23/01/2025 11:05:43.3566 1552 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 28 ms.) 23/01/2025 11:05:43.3616 1554 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/01/2025 11:05:43.3626 1552 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/01/2025 11:05:43.3786 1551 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 23/01/2025 11:05:43.4716 1715 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 23/01/2025 11:09:59.8018 31144 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 23/01/2025 11:09:59.8128 28181 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 23/01/2025 11:09:59.8148 28182 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 2 ms.) 23/01/2025 11:10:02.2210 798 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 23/01/2025 11:10:10.5251 8308 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '830801' and traDirection='I' order by traId DESC LIMIT 1 23/01/2025 11:10:10.5251 8253 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191889' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2025 11:10:11.8107 638 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370677393' and traDirection='I' order by traId desc limit 1 23/01/2025 11:10:12.7231 11372 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 23/01/2025 11:10:13.5355 1363 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-23 11:10:12','V',4958437033061290,2025,'2025-01-23 11:03:27','456783762900327002029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 23/01/2025 11:10:13.7907 1184 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456783873100327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 23/01/2025 11:10:14.6201 1071 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 11:10:16.4539 3659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 11:10:16.6030 2810 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 = '456783873100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/01/2025 11:10:19.0666 2610 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);