23/01/2024 17:26:52.7466 3592 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 23/01/2024 17:26:54.6129 4402 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '453094495200327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2024 17:26:56.0195 3076 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2024 17:26:56.1485 608 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,'2024-01-23 17.26.55','V',4997104388963760,2024,'2024-01-20 12.29.12','453094495200327001031999',1,2,1,'I','',1,0,1,'','',4) 23/01/2024 17:26:56.7284 708 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/2024 17:27:03.4653 1567 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 = '0810007103341' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/01/2024 17:27:13.1599 538 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370676842' and traDirection='I' order by traId desc limit 1 23/01/2024 17:27:28.5363 619 ms. OPEN: show columns from abbPayment where Field = 'payCarId' 23/01/2024 17:27:31.4975 631 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,'2024-01-23 17.27.30','V',5310669540254220,2024,'2024-01-21 13.01.55','453104691500327005031999',1,2,16,'I','',1,0,1,'','',4) 23/01/2024 17:27:42.3395 513 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,'2024-01-23 17.27.41','V',5245676128858530,2024,'2024-01-21 15.45.31','453105673100327005031999',1,2,16,'I','',1,0,1,'','',4) 23/01/2024 17:27:48.1783 914 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,'2024-01-23 17.27.47','V',5717257502856070,2024,'2024-01-21 17.24.56','453094400500327005029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 23/01/2024 17:33:35.4363 560 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 23/01/2024 17:33:40.3790 4422 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 23/01/2024 17:33:43.7680 3142 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2024 17:33:45.4538 1685 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/2024 17:33:46.3954 3083 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '453106556900327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2024 17:33:46.3954 3083 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/2024 17:33:47.5341 536 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,'2024-01-23 17:33:46','V',5277374464157240,2024,'2024-01-21 18:14:20','453106566000327005031999',1,2,16,'I','',1,0,1,'','',4) 23/01/2024 17:33:47.5551 820 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,'2024-01-23 17:33:46','V',4763604456640910,2024,'2024-01-20 15:39:15','453094400500327005029999',2,2,2,'O','',1,0,1,'','0532370677393',15,0) 23/01/2024 17:34:08.6442 652 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,'2024-01-23 17:34:07','V',5666097590868720,2024,'2024-01-22 10:25:01','453113750100327005031999',1,2,16,'I','',1,0,1,'','',4) 23/01/2024 17:34:09.6889 975 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,'2024-01-23 17:34:08','V',5060009131848080,2024,'2024-01-22 11:46:13','453110001100327002029999',2,1,2,'O','',1,0,1,'','1742679427739',49,0) 23/01/2024 21:48:50.3420 514 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,'2024-01-23 21:48:49','V',4675579189748210,2024,'2024-01-23 21:02:40','453126845000327005029999',2,1,2,'O','',1,0,1,'','1742685127576',92,0) 23/01/2024 22:15:16.3154 1147 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 23/01/2024 22:16:27.8562 574 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-01-23 22:15:17' where traUID = 5350760419072270 and traStatus='V' and traEnabled=1