19/08/2025 05:38:09.1686 525 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc 19/08/2025 06:11:30.0264 795 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-08-19 06.11.29' where payTraUID = 5579367782734150 and payStatus='V' and payEnabled=1 19/08/2025 06:38:56.0787 957 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 19/08/2025 06:50:19.7898 574 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 19/08/2025 07:11:51.6334 606 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 19/08/2025 07:34:24.7702 1734 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 19/08/2025 07:51:35.5312 688 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 19/08/2025 08:01:34.1627 602 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 19/08/2025 08:08:02.2701 558 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 19/08/2025 08:27:13.1177 732 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 19/08/2025 08:45:39.7114 625 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 19/08/2025 09:01:19.1364 547 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-08-19 09.01.18','V',4822996525430000,2025,'2025-08-19 09.01.18','458863151500327005012999',2,2,2,'O','',0,'2025-08-19 09.01.18',1,'','',0) 19/08/2025 09:09:12.9676 534 ms. OPEN: SELECT * FROM tabterminal LEFT JOIN movtransit ON movtransit.traIdTerminal = tabterminal.terId LEFT JOIN tabtariff ON tabtariff.tarId = movtransit.traTarId LEFT JOIN tabterminalinout ON tabterminalinout.tioin = tabterminal.terId WHERE tabterminal.terStatus ='V' AND tabterminalinout.tioOut = 2 AND movtransit.traStatus ='V' AND tabterminal.terDirection = 'I' AND movtransit.traCode = '458863201300327001012999' 19/08/2025 09:14:15.2754 673 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/08/2025 09:57:01.3257 619 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-08-19 09.57.00' where traUID = 5114142926232250 and traStatus='V' and traEnabled=1 19/08/2025 10:44:39.6126 664 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-08-19 10.44.38',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-08-19 10.44.38',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 19/08/2025 10:54:28.7117 832 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 = 6 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 19/08/2025 11:00:19.2413 578 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-08-19 11.00.18','V',5741730541883920,2025,'2025-08-19 11.00.17','458863961700327005012999',1,2,16,'I','',1,0,1,'','0230004098589',197,0) 19/08/2025 11:15:13.6220 1364 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/08/2025 11:15:29.4687 5960 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/08/2025 11:24:36.0831 554 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/08/2025 11:44:08.5140 1577 ms. OPEN: select * from tabCustomer inner join abbSubscriptions on subCusId = cusId left join tabAbbGroups on cusAbgId = abgId where subId = 0 and cusStatus='V' (WAIT TIME 1 ms.) 19/08/2025 11:49:09.7967 2721 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 19/08/2025 11:51:40.7423 726 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc 19/08/2025 11:51:57.6835 1733 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 190 order by traDateTime desc,traId desc 19/08/2025 11:54:39.8862 563 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/08/2025 11:56:47.5652 1561 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 19/08/2025 11:58:28.0161 557 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6256, trcLastPrinted = '2500606256', trcLastDate = '2025-08-19 11.58.27' where trcStatus='V' and trcTerId = 17 19/08/2025 12:05:19.3685 673 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-08-19 12.05.18' where payTraUID = 5331536433060820 and payStatus='V' and payEnabled=1 19/08/2025 12:19:05.1988 1934 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 19/08/2025 12:32:05.8356 663 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 41 order by traDateTime desc,traId desc 19/08/2025 12:51:58.4691 526 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-08-19 12.51.57',17,6,'2025-08-19 12.51.57','458864328500327005012999','Pagato (Contanti ) Biglietto ') 19/08/2025 13:18:19.9871 3096 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 19/08/2025 15:01:24.2646 567 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 471727 else acvFstPayId end),acvLstPayId = 471727 where acvSftId = 1196 and acvCodeId = 3 19/08/2025 15:10:04.8296 621 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 ('2025-08-19 15.10.04',0,'V',5447158341413390,4732241252799680,2025,'2025-08-19 15.10.04',18,1,0,4,'2025-08-19 15.25.04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/08/2025 15:33:09.6561 539 ms. OPEN: select * from movtransit where traUID = 5022235264441170 and traStatus='V' 19/08/2025 15:33:10.5294 868 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 ('2025-08-19 15.33.08',0,'V',5443377197633290,5022235264441170,2025,'2025-08-19 15.33.08',3,1,0,4,'2025-08-19 15.48.08','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 19/08/2025 15:33:11.9882 1439 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5022235264441170,5443377197633290,2025,'2025-08-19 15.33.10','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/19/2025 2:35:41 PM Date : 8/19/2025 3:33:08 PM Code : 458865254100327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 19/08/2025 15:33:13.0119 1023 ms. EXEC: update payReceipt set recCreation = '2025-08-19 15.33.11',recModify = '2025-08-19 15.33.11',recUseId=0,recStatus='V' where recId = 407832 19/08/2025 16:26:33.8679 2052 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 = 6 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 19/08/2025 18:49:31.8332 724 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 19/08/2025 19:07:10.2575 8641 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 = 12 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 19/08/2025 19:15:19.0808 537 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 163 order by traDateTime desc,traId desc 19/08/2025 19:28:50.6187 3417 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 19/08/2025 19:30:15.1241 993 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 19/08/2025 19:56:51.5272 693 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