14/03/2024 08:22:57.5620 660 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-14 08:22:52',5,3,42101,0,50,24,1200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+24,5),curAmount=round(curAmount+1200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-14 08:22:52',5,3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-03-14 08:22:52',5,3,42101,0,100,11,1100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+11,5),curAmount=round(curAmount+1100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 14/03/2024 09:53:28.6995 658 ms. EXEC: update payReceipt set recCreation = '2024-03-14 09:53:28',recModify = '2024-03-14 09:53:28',recUseId=0,recStatus='V' where recId = 238969 14/03/2024 10:19:04.6840 525 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-03-14 10:19:04',0,0,'V',4658829425841140,4635549660973470,2024,'2024-03-14 10:19:04',3,'KES',-1,50,-50,'N',''); 14/03/2024 11:53:04.4513 533 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-03-14 11:53:03' where traUID = 5296306242774600 and traStatus='V' and traEnabled=1 14/03/2024 12:11:56.6928 671 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-03-14 12:11:56' where payTraUID = 5763942476101810 and payStatus='V' and payEnabled=1 14/03/2024 12:28:56.8104 583 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-03-14 12:29:50',1,'V',5595808364124170,4716884651693280,2024,'2024-03-14 12:29:50',4,1,0,4,'2024-03-14 12:44:50','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/03/2024 13:29:15.6582 563 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-03-14 13:29:15' where subId = 48 14/03/2024 13:59:01.8787 566 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-03-14 13:59:01' where traUID = 5657525066450040 and traStatus='V' and traEnabled=1 14/03/2024 14:32:06.6107 510 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/03/2024 15:16:22.5353 527 ms. EXEC: update tabTerminalReceipt set trcProgressive = 11354, trcLastPrinted = '2400711354', trcLastDate = '2024-03-14 15:16:22' where trcStatus='V' and trcTerId = 18 14/03/2024 15:16:23.0705 550 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-03-14 15:16:22',0,2,'2024-03-14 15:16:22','','Unauthorized Transit Exit 1') 14/03/2024 15:16:23.1235 586 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5133973701592740,5321056317104620,2024,'2024-03-14 15:16:22',' Date: 3/14/2024 3:16:21 PM Code: 453635135900327005012999 Entry Date: 3/14/2024 2:15:59 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 # 2400711354 ',0) 14/03/2024 15:47:54.1475 596 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-03-14 15:47:53' where payTraUID = 5509496298276850 and payStatus='V' and payEnabled=1 14/03/2024 15:56:11.4973 714 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-03-14 15:56:10',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 14/03/2024 16:32:10.8966 513 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/03/2024 20:08:17.5558 5322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/03/2024 20:08:22.2994 4654 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/03/2024 20:08:53.1113 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/03/2024 20:09:12.2064 4776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/03/2024 20:10:19.8242 4640 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '580877' and traDirection='I' order by traId DESC LIMIT 1 14/03/2024 20:11:01.5226 7956 ms. EXEC: update payInventory set invCreation = '2024-03-14 20:10:53',invModify = '2024-03-14 20:10:53',invUseId=0,invStatus='V' where invId = 171220 (WAIT TIME 104 ms.) 14/03/2024 20:11:38.1714 18906 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/03/2024 20:11:42.9209 4512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/03/2024 20:11:43.1290 4724 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/03/2024 20:12:09.4305 11225 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 257 ms.) 14/03/2024 20:12:13.9629 4032 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-03-14 20:12:09','V',5600238849620120,2024,'2024-03-14 20:11:41','453637270100327005031999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 124 ms.) 14/03/2024 20:12:37.5685 4437 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 39 ms.) 14/03/2024 20:12:53.0455 4406 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/03/2024 20:12:54.2009 998 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 14/03/2024 20:12:54.4310 1226 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-03-14 19:12:53') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-03-14 20:12:53' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-03-14 20:12:53' and (resAreId = 1 or resAreId <= 0) nr: 0 14/03/2024 20:13:02.4556 7782 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '453637029700327005012999' 14/03/2024 20:13:22.0719 3819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/03/2024 20:13:58.8717 4650 ms. OPEN: select * from movtransit where trastatus='V' and traCode = '453637172600327005012999' order by traId desc limit 1 14/03/2024 20:14:08.5118 36855 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '453637029700327005012999' OR useBadId = '453637029700327005012999') 14/03/2024 20:14:13.2964 9456 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/03/2024 20:14:22.6434 9346 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/03/2024 20:15:30.2801 4514 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-03-14 20:15:25' where subId = 156 14/03/2024 20:16:56.4279 21156 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/03/2024 20:30:20.5258 541 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/03/2024 20:30:29.6707 2570 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/03/2024 20:30:46.3901 3439 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 ('2024-03-14 20:25:59',12,'V',4900582424465740,4872823797636470,2024,'2024-03-14 20:25:59',4,1,0,-1,'2024-03-14 21:25:59','C','KES',0,0,0,'','','',1,0,0) 14/03/2024 20:31:03.6857 1576 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 274520 else acvFstPayId end),acvLstPayId = 274520 where acvSftId = 677 and acvCodeId = 3 14/03/2024 20:31:27.4163 4391 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/03/2024 20:32:00.0898 57897 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 66 ms.) 14/03/2024 20:32:00.0998 41656 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 69 ms.) 14/03/2024 20:32:13.9723 69295 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 130 ms.) 14/03/2024 20:32:33.9317 19759 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 86 ms.) 14/03/2024 20:32:33.9517 19764 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 101 ms.) 14/03/2024 20:33:05.3208 120695 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 76 ms.) 14/03/2024 20:34:01.9411 22263 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 125 ms.) 14/03/2024 20:34:20.9582 18156 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 138 ms.)