17/02/2025 16:39:41.2165 1875 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 17/02/2025 16:39:42.1334 914 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/02/2025 16:39:42.7897 656 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); 17/02/2025 16:41:22.3860 1082 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 17/02/2025 16:42:30.0959 532 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-02-17 16:42:29','V',5171920689301220,2025,'2025-02-16 22:36:15','457020000100327001029999',2,1,2,'O','',1,0,1,'','0532370834528',10,0) 17/02/2025 16:43:49.8842 612 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 17/02/2025 16:43:50.4262 520 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 = '456858552000327005029999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 17/02/2025 16:43:50.9497 521 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 = '456858552000327005029999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 17/02/2025 16:45:14.4975 537 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-17 16:45:13','V',4928401302733730,2025,'2025-02-17 16:45:13','457036008300327001012999',2,2,2,'O','',0,'2025-02-17 16:45:13',1,'','',0) 17/02/2025 16:49:28.4717 516 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-02-17 16:49:27','V',5458942967324170,2025,'2025-02-16 20:19:19','457010003200327005029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 17/02/2025 16:55:11.6266 579 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-02-17 16:55:11','V',4684101694148410,2025,'2025-02-16 13:33:40','457010003200327005029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 17/02/2025 17:02:34.4863 520 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-02-17 17:02:33','V',4778175516179060,2025,'2025-02-16 22:12:56','457010003200327005029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 17/02/2025 17:09:05.4108 16470 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 17/02/2025 17:09:05.4478 6413 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 17/02/2025 17:09:05.4498 5910 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 17/02/2025 17:09:11.2838 5164 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 17/02/2025 17:09:13.2755 5756 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457036150100327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 17/02/2025 17:09:14.7934 3212 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 17/02/2025 17:09:15.2857 866 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-17 17:09:14','V',4810418407215200,2025,'2025-02-17 17:05:01','457036150100327005031999',1,2,16,'I','',1,0,1,'','',4) 17/02/2025 17:09:16.2446 947 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 17/02/2025 17:09:16.6328 1839 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); 17/02/2025 17:10:22.8223 707 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 = '457035962000327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 17/02/2025 17:10:49.2464 590 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-17 17:10:48',0,16,'2025-02-17 17:10:48','','Unauthorized Transit Entry 2') 17/02/2025 17:12:00.7861 2154 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 11 order by traDateTime desc,traId desc 17/02/2025 17:17:52.6358 3017 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 17/02/2025 17:17:53.5461 586 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 = '457010003200327005029999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 17/02/2025 17:17:54.2929 696 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 = '457010003200327005029999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 17/02/2025 17:17:55.4035 866 ms. EXEC: update movtransit set traEnabled = 0,traDisableTime = '2025-02-16 09:00:09' where traCarId = 15 and traEnabled=1 17/02/2025 17:29:18.6545 1306 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 17/02/2025 17:33:19.2544 1610 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 17/02/2025 17:33:30.7924 1285 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 17/02/2025 17:36:49.6424 716 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 17/02/2025 18:27:35.4774 512 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 17/02/2025 18:39:24.4760 733 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 111 order by traDateTime desc,traId desc 17/02/2025 19:23:17.0348 652 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 17/02/2025 20:29:04.7571 574 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-17 20:29:04' where traUID = 4907078313144670 and traStatus='V' and traEnabled=1 17/02/2025 20:51:01.6776 676 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 17/02/2025 21:53:37.4281 4295 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 17/02/2025 22:04:49.3100 2348 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType