26/07/2025 03:31:56.3646   640 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-07-26 03:31:55','V',5448462044724640,2025,'2025-07-26 03:31:54','458621271400327005012999',1,2,16,'I','',1,0,1,'','',4)
26/07/2025 10:48:40.7550   546 ms.           EXEC: update abbCards set carLastDate = '2025-07-26 10:48:40',carLastDirection='O' where carStatus='V' and carId = 20
26/07/2025 11:59:28.3084   921 ms.           OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1  ORDER BY traId DESC LIMIT 100
26/07/2025 12:24:31.3709   609 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-07-26 12:23:30',12,'V',5394365693516870,4838665553591680,2025,'2025-07-26 12:23:30',17,1,0,4,'2025-07-26 12:38:30','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
26/07/2025 12:33:54.0465   625 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
26/07/2025 13:55:10.3658   953 ms.           EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 463179 else acvFstPayId end),acvLstPayId = 463179 where acvSftId = 1145 and acvCodeId = 3
26/07/2025 15:29:05.8038  1235 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-07-26 15:29:04','V',5614431337939280,2025,'2025-07-26 15:29:03','458625574300327005012999',1,2,16,'I','',1,0,1,'','',4)
26/07/2025 15:29:06.7570   609 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
26/07/2025 16:35:46.5169  1203 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-07-26 16:35:45',0,'V',4619608284848670,5395695229516880,2025,'2025-07-26 16:35:45',18,1,0,4,'2025-07-26 16:50:45','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
26/07/2025 16:44:08.5628   828 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-07-26 16:44:07',0,'V',5013959035825500,5075228723745860,2025,'2025-07-26 16:44:07',3,1,0,4,'2025-07-26 16:59:07','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0)
26/07/2025 19:22:17.6163  1328 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
26/07/2025 22:03:04.8676   531 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-07-26 22:03:04' where traUID = 5104295785943460 and traStatus='V' and traEnabled=1