12/11/2023 06:08:05.6039   562 ms.           EXEC: update abbCards set carLastDate = '2023-11-12 06:08:05',carLastDirection='O' where carStatus='V' and carId = 88
12/11/2023 11:21:09.1694   812 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
12/11/2023 12:56:34.4540   562 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,payVatPercent,payVatAmount) VALUES ('2023-11-12 12:56:33',0,'V',5198555558547480,4693663154148280,2023,'2023-11-12 12:56:33',2,1,0,-1,'2023-11-12 13:56:33','S','KES',0,0,0,'','','',3,0,0)
12/11/2023 13:47:37.2713   563 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 52681, trcLastPrinted = '2300752681', trcLastDate = '2023-11-12 13:47:36' where trcStatus='V' and trcTerId = 18
12/11/2023 15:56:42.6532   546 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-11-12 15:56:41' where traUID = 5125654654734590 and traStatus='V' and traEnabled=1
12/11/2023 16:52:23.5361   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 ('2023-11-12 16:53:06',1,'V',5196691670089660,5090493630315530,2023,'2023-11-12 16:53:06',17,1,0,4,'2023-11-12 17:08:06','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)