11/01/2025 08:51:14.1229 1111 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 11/01/2025 09:24:20.5410 1587 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 11/01/2025 09:41:35.3706 869 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 11/01/2025 10:00:13.6267 926 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 11/01/2025 10:17:24.7917 518 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 183 order by traDateTime desc,traId desc 11/01/2025 10:23:10.2291 12152 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 11/01/2025 10:31:27.4004 1005 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 11/01/2025 10:37:07.4254 569 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-11 10:37:06' where payTraUID = 5686622805612190 and payStatus='V' and payEnabled=1 11/01/2025 11:06:37.5722 509 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-11 11:06:37' where traUID = 5092095998198410 and traStatus='V' and traEnabled=1 11/01/2025 11:33:04.0464 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-11 11:33:03' where traUID = 5588263150394190 and traStatus='V' and traEnabled=1 11/01/2025 11:47:06.6240 646 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 11/01/2025 12:48:22.8006 1069 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 11/01/2025 12:49:10.5414 2120 ms. OPEN: select traCode,traDateTime,traEnabled from movTransit where traStatus='V' and traDirection = 'I' and traCarId = 0 and traEnabled = 1 and right(concat('00000',right(cast(traId as char),5)),5) = '00000' order by traId desc limit 100 11/01/2025 12:58:20.1798 620 ms. OPEN: select traCode,traDateTime,traEnabled from movTransit where traStatus='V' and traDirection = 'I' and traCarId = 0 and traEnabled = 1 and right(concat('00000',right(cast(traId as char),5)),5) = '00000' order by traId desc limit 100 11/01/2025 12:59:58.6626 532 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-11 12:59:58',0,0,'V',5249915493324690,5200769146059520,2025,'2025-01-11 12:59:58',3,'KES',-1,50,-50,'N',''); 11/01/2025 13:56:53.2735 601 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-11 13:56:52',0,16,'2025-01-11 13:56:52','','Unauthorized Transit Entry 2') 11/01/2025 14:09:47.3523 501 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/01/2025 14:22:51.2808 525 ms. EXEC: update payInventory set invCreation = '2025-01-11 14:22:50',invModify = '2025-01-11 14:22:50',invUseId=0,invStatus='V' where invId = 230665 11/01/2025 15:01:52.1591 606 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 11/01/2025 16:09:15.8204 1948 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 11/01/2025 20:01:33.0296 1849 ms. OPEN: select traCode,traDateTime,traEnabled from movTransit where traStatus='V' and traDirection = 'I' and traCarId = 0 and traEnabled = 1 and right(concat('00000',right(cast(traId as char),5)),5) = '00000' order by traId desc limit 100 11/01/2025 20:43:44.0947 1440 ms. OPEN: select traCode,traDateTime,traEnabled from movTransit where traStatus='V' and traDirection = 'I' and traCarId = 0 and traEnabled = 1 and right(concat('00000',right(cast(traId as char),5)),5) = '00000' order by traId desc limit 100