10/03/2025 09:24:12.5937   522 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-03-10 09:24:12',0,'V',5596866157764020,5612189731342370,2025,'2025-03-10 09:24:12',18,1,0,4,'2025-03-10 09:39:12','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
10/03/2025 10:25:25.8004  1367 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 (WAIT TIME 1 ms.)
10/03/2025 11:28:36.2895   510 ms.           EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-03-10 11:28:35',0,16,'2025-03-10 11:28:35','','Unauthorized Transit  Entry 2') (WAIT TIME 19 ms.)
10/03/2025 12:54:50.3380   569 ms.           EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-03-10 12:54:49','0810007103066',0,0,5369807367998710,82,'0000-00-00 00:00:00','0000-00-00 00:00:00')
10/03/2025 13:22:26.2341   564 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-03-10 13:21:13',1,'V',5180823690500130,4656887648668160,2025,'2025-03-10 13:21:13',17,1,0,4,'2025-03-10 13:36:13','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
10/03/2025 13:29:54.4666   807 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4793174494560090,5724637996557540,2025,'2025-03-10 13:29:53','
Date:     3/10/2025 1:29:53 PM

Code:  457244743200327005012999
Entry Date:  3/10/2025 1:10:32 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:               50.00 KES
______________________________
Paid:                50.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2500709958
',0)