06/03/2025 10:58:06.7675   601 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-06 10:58:06' where traUID = 4954204253033810 and traStatus='V' and traEnabled=1
06/03/2025 11:32:32.5921   563 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
06/03/2025 11:32:34.2972   607 ms.           EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-03-06 11:32:33' where subId = 113
06/03/2025 11:50:36.6883   572 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5618326922758010,5688288866586290,2025,'2025-03-06 11:50:36','
Date:     3/6/2025 11:50:35 AM

Code:  457203465100327005012999
Entry Date:  3/6/2025 9:37:31 AM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:              100.00 KES
______________________________
Paid:               100.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2500709341
',0)
06/03/2025 13:08:49.1494   669 ms.           OPEN: select * from movTransit where traStatus = 'V' and traCode='457195094900327005012999' and traBadge = '0230003950896' order by traId desc limit 1
06/03/2025 15:16:59.1914   555 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4923588049361440,5714260519537250,2025,'2025-03-06 15:16:58','
Date:      3/6/2025 3:16:58 PM

Code:  457204869600327005012999
Entry Date:  3/6/2025 1:31:36 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:              100.00 KES
______________________________
Paid:               100.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2500709389
',0)
06/03/2025 17:03:16.0448   535 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-03-06 17:03:15','V',5208109904782930,2025,'2025-03-06 17:03:15','457206139500327005012999',1,2,16,'I','',1,0,1,'','',4)
06/03/2025 22:08:20.8401  1281 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
06/03/2025 22:08:58.1734  1327 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc