28/09/2024 09:27:21.8875 522 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 28/09/2024 09:58:28.3126 526 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,'2024-09-28 09:58:27','V',5244889298521450,2024,'2024-09-28 09:58:27','455613590700327005012999',1,2,16,'I','',1,0,1,'','',4) 28/09/2024 10:23:26.4683 661 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0230003944059' order by traId desc limit 1 28/09/2024 10:31:41.6038 577 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-09-28 10:31:41',0,16,'2024-09-28 10:31:41','','Unauthorized Transit Entry 2') 28/09/2024 10:58:05.5857 997 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 = 10 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 28/09/2024 11:27:00.9113 602 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-09-28 11:27:00',0,1,'2024-09-28 11:27:00','','Unauthorized Transit Entry 1') 28/09/2024 11:31:32.3045 515 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,'2024-09-28 11:31:31','V',5089805417229980,2024,'2024-09-28 11:31:31','455614149100327005012999',1,2,16,'I','',1,0,1,'','',4) 28/09/2024 11:31:54.4524 582 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,'2024-09-28 11:31:53','V',5210730311157490,2024,'2024-09-28 11:31:53','455614105400327001012999',2,2,2,'O','',0,'2024-09-28 11:31:53',1,'','',0) 28/09/2024 11:51:39.4989 530 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,'2024-09-28 11:51:38','V',5268255931091350,2024,'2024-09-28 11:51:37','455614269700327005012999',1,2,16,'I','',1,0,1,'','',4) 28/09/2024 12:47:22.6293 523 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,'2024-09-28 12:47:22','V',5764358358792130,2024,'2024-09-28 12:47:21','455614111800327005012999',2,2,2,'O','',0,'2024-09-28 12:47:22',1,'','',0) 28/09/2024 13:58:04.9149 604 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/09/2024 14:29:38.1713 648 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4613793076670020,5329123876512720,2024,'2024-09-28 14:29:37','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 9/28/2024 1:24:06 PM Date : 9/28/2024 2:29:36 PM Code : 455614824600327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 28/09/2024 16:25:58.7762 1086 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 ('2024-09-28 16:25:57',0,'V',4688519961517330,5222833137355440,2024,'2024-09-28 16:25:57',18,1,0,4,'2024-09-28 16:40:57','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/09/2024 16:27:18.7873 752 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 ('2024-09-28 16:27:17',0,'V',5110952191845510,5118814498055250,2024,'2024-09-28 16:27:17',3,1,0,4,'2024-09-28 16:42:17','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0) 28/09/2024 17:37:21.8374 614 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5418388845306970,5402496033784910,2024,'2024-09-28 17:37:21',' Date: 9/28/2024 5:37:21 PM Code: 455615799900327005012999 Entry Date: 9/28/2024 4:06:39 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 # 2400743115 ',0)