25/12/2023 08:49:23.5866   954 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
25/12/2023 13:29:46.7816   593 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-12-25 13:29:46',0,0,'V',5760711806445800,5145608527831430,2023,'2023-12-25 13:29:46',3,'KES',-1,50,-50,'N','');
insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-12-25 13:29:46',0,0,'V',5760711806445800,5145608527831430,2023,'2023-12-25 13:29:46',3,'KES',-1,100,-100,'N','');

25/12/2023 15:16:41.0136   578 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-12-25 15:16:40' where payTraUID = 5523882320589810 and payStatus='V' and payEnabled=1