17/09/2024 03:35:44.0825 524 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2024-09-17 03:34:28' nr: 0 17/09/2024 03:52:56.3209 562 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-09-17 03:52:55' where traUID = 4870936761853960 and traStatus='V' and traEnabled=1 17/09/2024 07:24:43.2869 639 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 151 order by traDateTime desc,traId desc 17/09/2024 07:42:16.5826 587 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 17/09/2024 07:44:35.7775 930 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 17/09/2024 07:53:42.6186 1073 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/09/2024 07:59:43.0348 563 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/09/2024 08:06:37.2667 588 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 17/09/2024 08:36:50.9402 524 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 17/09/2024 09:59:16.6042 1201 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/09/2024 09:59:17.6269 617 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-09-17 09:59:17','V',5406345289033430,2024,'2024-09-17 09:59:15','455503595500327005012999',1,2,16,'I','',1,0,1,'','0230004101223',11,0) 17/09/2024 10:02:53.7768 1408 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/09/2024 10:19:24.2018 843 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/09/2024 10:53:48.1083 672 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 17/09/2024 11:02:13.2599 7429 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 17/09/2024 11:19:08.4411 901 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 17/09/2024 11:45:15.8327 1095 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/09/2024 12:13:27.5551 655 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0230003944081' order by traId desc limit 1 17/09/2024 13:49:29.8897 992 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-09-17 13:49:28',0,1,'2024-09-17 13:49:28','','Unauthorized Transit Entry 1') 17/09/2024 15:36:47.4290 536 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-09-17 15:36:46',0,'V',4765923819508330,5347001660317340,2024,'2024-09-17 15:36:46',3,1,0,4,'2024-09-17 15:51:46','C','KES',50,1000,950,'',' ',' ',1,50,0,0,'',0,0) 17/09/2024 18:46:36.4989 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-09-17 18:46:35' where traUID = 5283157943546830 and traStatus='V' and traEnabled=1 17/09/2024 18:49:40.2640 536 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-17 18:49:39' where payTraUID = 5414449562588680 and payStatus='V' and payEnabled=1 17/09/2024 19:18:07.6677 559 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-09-17 19:18:07',0,16,'2024-09-17 19:18:07','','Unauthorized Transit Entry 2') 17/09/2024 19:25:53.7513 614 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-17 19:25:53' where payTraUID = 5740799579080400 and payStatus='V' and payEnabled=1 17/09/2024 22:02:15.7458 1365 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/09/2024 22:02:30.4661 596 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-17 22:02:29' where payTraUID = 4969930763983310 and payStatus='V' and payEnabled=1 17/09/2024 22:16:31.1306 981 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