26/04/2025 00:12:12.1468 728 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/04/2025 00:16:13.2497 1432 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 00:20:44.4058 1362 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 00:26:55.6994 684 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 00:30:37.9348 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 00:30:55.5786 769 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-26 00:30:54',0,16,'2025-04-26 00:30:54','','Unauthorized Transit Entry 2') 26/04/2025 00:34:59.6526 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 00:35:56.7917 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 00:48:14.9427 785 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-04-26 00:47:56',9,'V',5151017761795050,4702588628455280,2025,'2025-04-26 00:47:56',4,1,0,4,'2025-04-26 01:02:56','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/04/2025 00:49:29.1273 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 00:55:41.5329 1326 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:02:45.2228 1018 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5200, trcLastPrinted = '2500405200', trcLastDate = '2025-04-26 01:02:44' where trcStatus='V' and trcTerId = 4 26/04/2025 01:03:31.9530 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:03:37.0284 730 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 01:03:37.0974 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:05:37.3968 961 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-04-26 01:05:36','V',4868156002346700,2025,'2025-04-26 01:05:34','457708147500327005012999',2,2,2,'O','',0,'2025-04-26 01:05:36',1,'','',0) 26/04/2025 01:05:38.9858 773 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-26 01:05:37' where traUID = 5646445298204440 and traStatus='V' and traEnabled=1 26/04/2025 01:05:39.2420 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:06:01.2347 1352 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:06:05.0512 929 ms. EXECSCALAR: select count(rulId) from tabTicketRules where rulStatus='V' and rulTerId = 18 and rulDevId = 17 and rulTicId = 1 nr: 0 26/04/2025 01:08:20.6037 1513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:08:47.5607 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:14:02.1868 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:16:32.2020 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:16:33.8100 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:21:43.8597 652 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5323285925010640,5756827559145600,2025,'2025-04-26 01:21:43',' Date: 4/26/2025 1:21:42 AM Code: 457708638300327005012999 Entry Date: 4/25/2025 11:59:43 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 0.00 KES ______________________________ Paid: 0.00 KES __________ Change: 0.00 KES Type: Other Dispozitiv: Exit 1 ',1) 26/04/2025 01:28:51.7283 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 01:28:53.8928 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:29:12.2190 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:29:24.8444 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:30:00.5443 596 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-04-26 01:29:59',0,'V',5741767580373970,5050728159140710,2025,'2025-04-26 01:29:59',18,1,0,4,'2025-04-26 01:44:59','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 26/04/2025 01:39:24.4548 1031 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 01:39:40.7006 902 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-04-26 01:39:39','V',5521010910093490,2025,'2025-04-26 01:39:38','457710597800327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 01:43:24.3770 639 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/04/2025 01:43:27.9324 850 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 01:43:40.9250 1040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:43:40.9871 1173 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 01:52:56.6592 584 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-04-26 01:52:55',0,'V',4964395737527400,5714338455394980,2025,'2025-04-26 01:52:55',18,1,0,4,'2025-04-26 02:07:55','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/04/2025 01:53:39.1446 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:53:57.1256 768 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 01:58:35.4394 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:59:21.9375 1345 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:59:36.9785 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 01:59:36.9835 971 ms. EXEC: update payReceipt set recCreation = '2025-04-26 01:59:36',recModify = '2025-04-26 01:59:36',recUseId=0,recStatus='V' where recId = 373676 26/04/2025 02:03:00.8646 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 02:04:08.8290 952 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-04-26 02:04:07','V',4791610261027620,2025,'2025-04-26 02:04:05','457710072500327005012999',2,2,2,'O','',0,'2025-04-26 02:04:07',1,'','',0) 26/04/2025 02:05:24.3224 842 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 02:05:33.3915 1158 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/04/2025 02:05:33.4885 1265 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 02:15:17.5191 505 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 02:17:35.6153 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 02:20:57.7563 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 02:21:13.3757 922 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 02:23:46.0006 989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 02:27:19.6113 1337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 02:34:46.8069 669 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16538, trcLastPrinted = '2500716538', trcLastDate = '2025-04-26 02:34:46' where trcStatus='V' and trcTerId = 18 26/04/2025 02:41:42.3431 519 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-04-26 02:41:41','V',5113227026111220,2025,'2025-04-26 02:41:41','457710970100327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 02:41:43.9141 1240 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/04/2025 02:42:02.5766 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 02:43:54.3022 1615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 02:44:08.4026 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 02:47:21.2644 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 02:51:44.9845 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 03:09:04.2983 1907 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 03:11:03.7911 590 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 431270 else acvFstPayId end),acvLstPayId = 431270 where acvSftId = 989 and acvCodeId = 3 26/04/2025 03:12:07.6267 5389 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 03:12:46.5557 1496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 03:19:41.6808 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 03:22:15.5537 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 03:23:16.5104 2037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 03:27:09.4599 503 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 03:34:49.4922 1405 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-26 03:34:48' where payTraUID = 4735934442332560 and payStatus='V' and payEnabled=1 26/04/2025 03:35:06.7858 793 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 03:38:43.6856 1533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 03:40:33.7591 1060 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 03:43:15.0408 1871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 03:48:12.7348 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:05:40.9323 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:07:44.8100 5169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:07:49.5482 2859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:08:00.1072 2642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:08:09.3634 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:08:13.0739 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:13:34.7727 618 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-04-26 04:13:34',0,'V',5360475061643450,5015712310507310,2025,'2025-04-26 04:13:34',18,1,0,4,'2025-04-26 04:28:34','C','KES',400,400,0,'','','',1,400,0,0,'',0,0) 26/04/2025 04:13:35.3661 545 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16542, trcLastPrinted = '2500716542', trcLastDate = '2025-04-26 04:13:34' where trcStatus='V' and trcTerId = 18 26/04/2025 04:24:42.2784 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:28:37.8837 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 04:32:31.4606 940 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 04:32:47.7725 728 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 04:42:02.8371 1041 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-26 04:42:01' where payTraUID = 5168752836870340 and payStatus='V' and payEnabled=1 26/04/2025 04:42:05.4299 742 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/04/2025 04:49:13.5507 1936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 04:52:22.1356 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 05:01:55.7156 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 05:09:50.0933 1544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 05:15:35.4890 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 05:18:14.3911 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 05:20:56.4493 1549 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16546, trcLastPrinted = '2500716546', trcLastDate = '2025-04-26 05:20:54' where trcStatus='V' and trcTerId = 18 26/04/2025 05:29:45.0762 837 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 05:33:57.5848 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 05:44:24.1913 2157 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-26 05:44:22',0,16,'2025-04-26 05:44:22','','Unauthorized Transit Entry 2') 26/04/2025 05:47:54.6468 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 05:47:54.6478 652 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 06:05:45.7900 2642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 06:09:29.5053 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 06:09:33.6611 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 06:16:24.7496 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 06:28:08.6976 1715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 06:29:27.7154 810 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 06:37:07.8676 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 06:51:17.0638 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 06:52:25.8837 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 06:59:34.5518 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:02:27.1470 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:07:32.7822 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:08:22.6826 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:14:25.9101 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:16:05.5326 1764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:16:11.6087 955 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 07:19:35.3627 613 ms. EXEC: update payReceipt set recCreation = '2025-04-26 07:19:34',recModify = '2025-04-26 07:19:34',recUseId=0,recStatus='V' where recId = 373707 26/04/2025 07:25:07.7726 637 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/04/2025 07:25:13.2673 532 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 07:31:19.1426 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:36:35.9942 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:38:35.9983 2414 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-26 07:38:33',0,16,'2025-04-26 07:38:33','','Unauthorized Transit Entry 2') 26/04/2025 07:40:19.8756 913 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:45:05.0901 1923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:45:42.7632 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:53:59.3388 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 07:58:14.6983 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:00:15.9262 641 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/04/2025 08:05:42.2381 558 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 08:15:19.9438 1332 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:16:15.3698 609 ms. EXEC: update payCurInventory set curQuantity=round(curQuantity+11,8),curAmount=round(curAmount+2200,8) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N' 26/04/2025 08:16:15.8742 504 ms. EXEC: update payCurInventory set curQuantity=round(curQuantity+1,8),curAmount=round(curAmount+500,8) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 500 and curType = 'N' 26/04/2025 08:16:17.1861 896 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,50,-13,-650,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,50,13,650,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,100,-38,-3800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,100,38,3800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,200,-11,-2200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,200,11,2200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:15:49',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 26/04/2025 08:16:19.3875 1076 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:16:11',5,3,42101,0,50,-22,-1100,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:16:11',5,3,42101,0,100,-49,-4900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:16:11',5,3,42101,0,200,-12,-2400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:16:11',5,3,42101,0,500,-2,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:16:11',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:16:11',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 26/04/2025 08:16:23.2341 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:16:59.8626 1316 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-26 08:16:58',5,3,0,2,0,0,0,0,'2','') 26/04/2025 08:25:38.8891 995 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-04-26 08:25:37','V',4664921198908800,2025,'2025-04-26 08:25:37','457710000200327003229999',22,22,3,'I','',1,0,1,'','',2) 26/04/2025 08:25:40.2340 1179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:34:05.6014 1214 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:35:56.4234 3540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:36:05.3134 1604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:36:15.9605 3628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:36:16.0525 2366 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 08:38:30.9266 2666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:38:35.7898 2836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:38:38.6908 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:38:41.7818 2484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:38:48.7115 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:38:54.6164 1685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:38:56.9920 1660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:38:59.8559 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:02.4166 1954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:14.9250 1071 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:18.0210 1516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:21.4213 2793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:28.3419 1296 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 08:39:36.2292 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:37.6982 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:39.7635 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:42.4713 1275 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:46.5060 2545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:39:51.3613 2958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:40:27.7336 1471 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/04/2025 08:44:16.5942 597 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-26 08:44:15' where traUID = 4880813492914960 and traStatus='V' and traEnabled=1 26/04/2025 08:45:05.7117 945 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 08:47:56.3094 3710 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/04/2025 08:48:18.7704 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:53:23.0836 1997 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-04-26 08:53:21','V',5716528976759670,2025,'2025-04-26 08:53:20','457713200000327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 08:53:41.9562 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 08:55:03.3966 604 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/04/2025 08:55:55.1672 4834 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 677 ms.) 26/04/2025 09:05:49.2129 593 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 26/04/2025 09:07:57.2654 1451 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/04/2025 09:09:37.7475 2708 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 09:10:58.9407 1630 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 09:16:34.4017 2684 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 09:18:59.2054 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 09:19:26.4696 972 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 09:19:51.1290 1490 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5221, trcLastPrinted = '2500405221', trcLastDate = '2025-04-26 09:19:49' where trcStatus='V' and trcTerId = 4 26/04/2025 09:19:54.9876 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 09:20:58.9764 1511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 09:22:32.0476 640 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-04-26 09:22:31','V',5183485696986120,2025,'2025-04-26 09:22:31','457712962600327005012999',2,2,2,'O','',0,'2025-04-26 09:22:31',1,'','',0) 26/04/2025 09:22:32.6580 608 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 09:22:43.9175 2209 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/04/2025 09:22:56.3808 1065 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 09:31:40.2989 1172 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 09:39:02.0359 1410 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 09:40:38.8125 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 09:43:46.4544 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 09:58:12.0052 593 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-04-26 09:58:11','V',5459851977130190,2025,'2025-04-26 09:58:10','457713589000327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 10:06:44.3689 1317 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 10:07:04.6165 1246 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/04/2025 10:10:00.3598 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:11:49.5927 586 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 26/04/2025 10:11:58.2915 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 10:11:59.0421 719 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/04/2025 10:16:02.0563 1508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:16:07.7821 4179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:19:15.2043 1425 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 26/04/2025 10:19:16.7903 1582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 10:19:45.9338 861 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 10:26:29.9035 5401 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:26:33.4759 1806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:26:48.7241 2094 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:28:44.6225 562 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/04/2025 10:28:55.2816 501 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 10:28:56.1191 621 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-26 10:28:55' where traUID = 4735242588831440 and traStatus='V' and traEnabled=1 26/04/2025 10:30:05.3864 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:30:07.2296 800 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 10:30:08.0131 727 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-26 10:30:07' where payTraUID = 5184773202767790 and payStatus='V' and payEnabled=1 26/04/2025 10:32:12.8485 1501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:33:56.3196 875 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 10:39:41.2749 968 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 10:39:50.3520 1121 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 10:43:33.8622 901 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 = 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)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/04/2025 10:45:22.6809 541 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-04-26 10:45:22','V',5386060867949250,2025,'2025-04-26 10:45:21','457713872100327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 10:45:32.9017 687 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 26/04/2025 10:51:13.1310 540 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 10:56:18.6861 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 10:59:26.3073 557 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/04/2025 10:59:48.2880 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:03:20.7640 1008 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-26 11:03:19',0,0,'V',5466194142572840,5135941623881770,2025,'2025-04-26 11:03:19',3,'KES',1,200,200,'N',''); 26/04/2025 11:04:43.7001 968 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-26 11:04:42',0,0,'V',5280895382880770,5225721973211220,2025,'2025-04-26 11:04:42',3,'KES',1,100,100,'N',''); 26/04/2025 11:05:26.7558 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 11:05:28.3549 1113 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-26 11:05:27',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 26/04/2025 11:09:58.4086 744 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 11:09:58.4096 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:10:23.9437 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:12:17.7707 916 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/04/2025 11:16:40.7533 3580 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/04/2025 11:16:43.8984 1376 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 11:18:04.7924 554 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4921120350611340,5008757450534600,2025,'2025-04-26 11:18:04','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/26/2025 11:07:20 AM Date : 4/26/2025 11:18:02 AM Code : 457714004000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 26/04/2025 11:18:05.4578 631 ms. OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 3 26/04/2025 11:18:06.8718 771 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-26 11:18:06',3,42101,0,50,-1,-50,1,'O','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'; 26/04/2025 11:19:38.7902 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:21:47.6872 533 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-04-26 11:21:47','V',4945038201128490,2025,'2025-04-26 11:21:45','457713730400327005012999',2,2,2,'O','',0,'2025-04-26 11:21:47',1,'','',0) 26/04/2025 11:23:25.3895 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:25:39.4374 719 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 26/04/2025 11:26:57.3495 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:29:03.5087 887 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-26 11:29:02',3,42101,0,500,1,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 26/04/2025 11:32:35.8795 891 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '457714062400327005012999' 26/04/2025 11:32:42.1237 621 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 26/04/2025 11:36:57.0879 851 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 11:41:42.3714 4654 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-04-26 11.41.37','V',5753424566775540,2025,'2025-04-26 11.41.36','457714131500327005012999',2,2,2,'O','',0,'2025-04-26 11.41.37',1,'','',0) 26/04/2025 11:41:43.2150 735 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/04/2025 11:41:52.0338 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:41:57.6936 1293 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:42:33.0082 1099 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 11:42:41.2627 792 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5096296998981000,4701329560181330,2025,'2025-04-26 11:42:40',' Data: 4/26/2025 11:40:50 AM Codice: 457714056900327005012999 Ingresso: 4/26/2025 11:16:09 AM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500602893 ',0) 26/04/2025 11:43:27.8928 1796 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 11:45:53.3269 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:53:13.0754 533 ms. EXEC: update payReceipt set recCreation = '2025-04-26 11:53:12',recModify = '2025-04-26 11:53:12',recUseId=0,recStatus='V' where recId = 373770 26/04/2025 11:54:43.1910 501 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/04/2025 11:54:55.5683 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 11:58:06.9070 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:00:09.7210 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 12:11:16.8455 1239 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-26 12.11.15',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'; 26/04/2025 12:11:47.6120 558 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-04-26 12:11:45',0,'V',4805701232032150,5380180117035970,2025,'2025-04-26 12:11:45',3,1,0,4,'2025-04-26 12:26:45','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 26/04/2025 12:11:48.6427 649 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-26 12:11:47',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 26/04/2025 12:17:06.8431 704 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-04-26 12:17:06','V',5739083794581690,2025,'2025-04-26 12:17:05','457714327700327005012999',2,2,2,'O','',0,'2025-04-26 12:17:06',1,'','',0) 26/04/2025 12:18:50.8205 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:18:51.4980 1419 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 26/04/2025 12:20:15.1358 1469 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/04/2025 12:22:41.9628 3542 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/04/2025 12:24:26.5547 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:26:14.5068 1884 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:26:20.8980 1593 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-04-26 12:26:19','V',4997040961779580,2025,'2025-04-26 12:26:19','457714477900327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 12:26:27.5815 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 12:27:35.7630 1038 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 26/04/2025 12:27:47.6780 1281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:27:51.1063 1306 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:27:56.6039 501 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/04/2025 12:29:37.8195 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:31:04.2997 1629 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-04-26 12:31:02','V',5593174722061540,2025,'2025-04-26 12:31:01','457714506100327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 12:31:12.7083 650 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/04/2025 12:37:01.9296 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:38:39.5628 1765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:40:27.0756 601 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-04-26 12:38:38',12,'V',4919344964864290,5454238932989900,2025,'2025-04-26 12:38:38',17,1,0,4,'2025-04-26 12:53:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/04/2025 12:40:46.7487 539 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 12:40:56.8535 1497 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/04/2025 12:42:13.7448 2018 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-04-26 12:42:11','V',5506629290815230,2025,'2025-04-26 12:42:11','457714479300327005012999',2,2,2,'O','',0,'2025-04-26 12:42:11',1,'','',0) 26/04/2025 12:42:38.5974 601 ms. EXECSCALAR: select count(*) from tabTables where tabId = 30 and tabTxtValue='22' and tabTable = 'devAction' nr: 0 26/04/2025 12:44:14.5135 3297 ms. EXEC: update payReceipt set recCreation = '2025-04-26 12:44:11',recModify = '2025-04-26 12:44:11',recUseId=0,recStatus='V' where recId = 373787 26/04/2025 12:44:15.5522 2122 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:44:30.4321 1426 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:45:46.1417 947 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-04-26 12:45:45','V',5080859987063930,2025,'2025-04-26 12:45:43','457714594300327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 12:45:47.8698 1728 ms. OPEN: select last_insert_id() as vLast 26/04/2025 12:46:03.5713 1356 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:46:03.5853 1270 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 12:46:17.1524 1782 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 12:46:18.5243 1362 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/04/2025 12:46:22.3268 1819 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/04/2025 12:46:23.9099 792 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16584, trcLastPrinted = '2500716584', trcLastDate = '2025-04-26 12:46:23' where trcStatus='V' and trcTerId = 18 26/04/2025 12:46:24.5283 614 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5574043629934830,5474730821869950,2025,'2025-04-26 12:46:23',' Date: 4/26/2025 12:46:22 PM Code: 457714436500327005012999 Entry Date: 4/26/2025 12:19:25 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 # 2500716584 ',0) 26/04/2025 12:49:46.9484 632 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 12:49:47.3797 1130 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/04/2025 12:51:15.1914 728 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 12:51:21.2794 969 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:51:36.1584 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 12:55:07.7536 693 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/04/2025 12:55:21.6099 1852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 12:55:23.7053 1114 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-04-26 12:55:22','V',5689285416229290,2025,'2025-04-26 12:55:22','457714652200327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 12:55:33.0885 621 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 12:57:06.9252 612 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-26 12:57:06' where traUID = 4882996171834010 and traStatus='V' and traEnabled=1 26/04/2025 13:02:20.9208 1167 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-04-26 13:02:19','V',5048779929823360,2025,'2025-04-26 13:02:17','457713898800327005012999',2,2,2,'O','',0,'2025-04-26 13:02:19',1,'','',0) 26/04/2025 13:02:22.3738 641 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-26 13:02:21' where traUID = 5607708435980310 and traStatus='V' and traEnabled=1 26/04/2025 13:05:46.8121 531 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/04/2025 13:05:46.9542 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 13:09:42.4129 3662 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2898, trcLastPrinted = '2500602898', trcLastDate = '2025-04-26 13:09:38' where trcStatus='V' and trcTerId = 17 26/04/2025 13:09:45.0657 1887 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-04-26 13:09:43','V',4816987915966060,2025,'2025-04-26 13:09:42','457714411200327005012999',2,2,2,'O','',0,'2025-04-26 13:09:43',1,'','',0) 26/04/2025 13:11:46.8260 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 13:14:19.5890 590 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/04/2025 13:28:00.1426 605 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 13:28:07.5395 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 13:29:56.1991 614 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-26 13:29:55' where traUID = 4968190843255060 and traStatus='V' and traEnabled=1 26/04/2025 13:33:53.3384 1738 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 113 ms.) 26/04/2025 13:44:25.0048 1916 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 13:44:31.0568 603 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/04/2025 13:46:21.6206 1472 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-04-26 13.46.20',0,'V',5633933532559590,4690862036425710,2025,'2025-04-26 13.46.20',18,1,0,4,'2025-04-26 14.01.20','C','EUR',100,100,0,'','','',1,100,0,0,'',0,0) 26/04/2025 13:46:22.9345 562 ms. EXEC: update payReceipt set recCreation = '2025-04-26 13.46.22',recModify = '2025-04-26 13.46.22',recUseId=0,recStatus='V' where recId = 373824 26/04/2025 13:51:50.7634 622 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-26 13.51.49',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 26/04/2025 13:51:51.8841 656 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 13:55:56.3674 1465 ms. EXEC: update payInventory set invCreation = '2025-04-26 13:55:54',invModify = '2025-04-26 13:55:54',invUseId=0,invStatus='V' where invId = 248579 26/04/2025 13:55:57.7833 1120 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-26 13:55:56',3,42101,0,50,-1,-50,1,'O','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'; 26/04/2025 13:59:10.0467 576 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/04/2025 13:59:11.7859 1738 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '457714858100327005012999' 26/04/2025 14:01:14.3887 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:01:23.7530 1149 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 14:04:49.1581 771 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 = 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)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/04/2025 14:10:06.3779 675 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-26 14:10:05',0,0,'V',5205844347226060,5549824144585450,2025,'2025-04-26 14:10:05',3,'KES',1,500,500,'N',''); 26/04/2025 14:10:20.9076 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:10:30.9804 2407 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 14:12:10.2716 2421 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 14:12:40.8100 1447 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:19:44.7616 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 14:21:04.5759 702 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5689319580509020,5015201705852830,2025,'2025-04-26 14:21:03','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/26/2025 1:51:41 PM Date : 4/26/2025 2:21:01 PM Code : 457714990100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 26/04/2025 14:21:04.8621 644 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-04-26 14:21:04','V',5206224236288830,2025,'2025-04-26 14:21:02','457715055000327005012999',2,2,2,'O','',0,'2025-04-26 14:21:04',1,'','',0) 26/04/2025 14:25:15.7946 1133 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/04/2025 14:30:18.5187 1628 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/04/2025 14:32:11.7203 794 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-04-26 14:32:10','V',4895679389614100,2025,'2025-04-26 14:32:10','457714477900327005012999',2,2,2,'O','',0,'2025-04-26 14:32:10',1,'','',0) 26/04/2025 14:35:48.7072 749 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 14:37:42.9435 839 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/04/2025 14:38:00.9995 509 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 26/04/2025 14:39:49.3479 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:40:13.8833 1115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:43:33.7797 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:43:40.4452 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 14:43:43.6393 1323 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:48:44.1680 1101 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:54:11.4215 1522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 14:58:02.5178 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:01:23.8782 513 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-04-26 15:01:23','V',5012535478032280,2025,'2025-04-26 15:01:22','457715062400327005012999',2,2,2,'O','',0,'2025-04-26 15:01:23',1,'','',0) 26/04/2025 15:07:02.0240 1914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:07:06.2188 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:08:50.5465 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:12:50.6858 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:14:27.0181 1198 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:19:45.3190 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:19:57.0989 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 15:21:35.3835 545 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 15:21:36.2351 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:23:46.4520 1561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 15:29:08.7933 768 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 15:29:16.5004 1218 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/04/2025 15:34:23.7836 712 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 15:36:31.2787 661 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/04/2025 15:36:36.2940 670 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/04/2025 15:49:24.0407 1622 ms. OPEN: show columns from tabParameters where Field = 'parLostTicketNoArea' 26/04/2025 16:09:18.3263 949 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 16:11:04.6593 508 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 16 26/04/2025 16:11:26.5580 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 16:31:28.1186 2325 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/04/2025 16:40:41.5953 779 ms. EXEC: update payReceipt set recCreation = '2025-04-26 16.40.40',recModify = '2025-04-26 16.40.40',recUseId=0,recStatus='V' where recId = 373906 26/04/2025 16:42:22.2815 765 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 16:42:47.3602 623 ms. EXEC: update payReceipt set recCreation = '2025-04-26 16.42.46',recModify = '2025-04-26 16.42.46',recUseId=0,recStatus='V' where recId = 373907 26/04/2025 17:09:44.2259 521 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-04-26 17.09.43' where subId = 16 26/04/2025 17:09:56.5401 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 17:09:57.9391 1379 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 26/04/2025 17:16:48.4762 611 ms. EXEC: update payReceipt set recCreation = '2025-04-26 17:16:47',recModify = '2025-04-26 17:16:47',recUseId=0,recStatus='V' where recId = 373915 26/04/2025 17:19:13.9923 593 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/04/2025 17:19:16.6461 706 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/04/2025 17:19:16.8572 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 17:33:46.2295 1624 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 26/04/2025 17:46:33.1613 511 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/04/2025 17:51:54.6459 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 17:59:14.5316 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 17:59:16.5770 536 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-04-26 17:59:14',0,'V',5511493742159860,5499382167213430,2025,'2025-04-26 17:59:14',3,1,0,4,'2025-04-26 18:14:14','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 26/04/2025 17:59:17.7067 1120 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5499382167213430,5511493742159860,2025,'2025-04-26 17:59:16','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/26/2025 5:43:09 PM Date : 4/26/2025 5:59:14 PM Code : 457716378900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 26/04/2025 17:59:17.8008 1171 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-26 17:59:16',0,16,'2025-04-26 17:59:16','','Unauthorized Transit Entry 2') 26/04/2025 17:59:23.4766 1567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 143 ms.) 26/04/2025 17:59:25.0066 838 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 273 ms.) 26/04/2025 18:21:18.1511 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 18:33:55.5657 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/04/2025 18:52:25.6024 2027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/04/2025 19:29:05.6303 571 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-26 19.29.05',0,16,'2025-04-26 19.29.05','','Unauthorized Transit Entry 2') 26/04/2025 19:40:04.4593 849 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/04/2025 19:45:36.0027 673 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5457575689626550,5041375204598230,2025,'2025-04-26 19:45:35',' Date: 4/26/2025 7:45:34 PM Code: 457715604300327005012999 Entry Date: 4/26/2025 3:34:03 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 300.00 KES ______________________________ Paid: 300.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500716672 ',0) 26/04/2025 19:47:58.0485 811 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-26 19:47:57' where payTraUID = 5021428254604730 and payStatus='V' and payEnabled=1 26/04/2025 19:52:18.5835 506 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-04-26 19:52:18','V',4652602206635980,2025,'2025-04-26 19:52:17','457714120300327005012999',2,2,2,'O','',0,'2025-04-26 19:52:18',1,'','',0) 26/04/2025 19:52:55.1419 950 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/04/2025 20:16:52.5878 1473 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-04-26 20:16:51','V',4696122762108360,2025,'2025-04-26 20:16:48','457717300800327005012999',1,2,16,'I','',1,0,1,'','',4) 26/04/2025 21:59:30.5185 607 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/04/2025 22:52:39.5877 713 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-04-26 22.52.38','V',5068100278203170,2025,'2025-04-26 22.52.38','457718043100327005012999',2,2,2,'O','',0,'2025-04-26 22.52.38',1,'','',0) 26/04/2025 23:01:56.4755 1342 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-04-26 23.01.55',0,'V',4788253180562370,4994620385459440,2025,'2025-04-26 23.01.55',18,1,0,4,'2025-04-26 23.16.55','C','EUR',100,100,0,'','','',1,100,0,0,'',0,0)