08/01/2025 00:11:24.4866 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 00:14:23.4668 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 00:20:55.3787 1584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 00:36:19.5895 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 00:46:31.4225 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:00:18.5223 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:01:23.1067 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:02:45.7152 1304 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:05:38.2595 1213 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:05:59.6568 1571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:07:03.5715 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:28:32.2583 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:42:41.9090 1993 ms. EXEC: update payReceipt set recCreation = '2025-01-08 01:42:39',recModify = '2025-01-08 01:42:39',recUseId=0,recStatus='V' where recId = 340141 08/01/2025 01:45:51.0183 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 01:56:51.8041 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 02:31:50.7218 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 03:21:35.4315 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 03:34:14.9095 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 03:39:45.0406 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 03:41:16.3013 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 03:47:29.1858 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 03:53:04.6523 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 03:54:11.4129 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 04:13:33.6357 1112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 04:27:21.4697 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 04:27:32.0348 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 04:36:51.8768 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 04:37:32.6201 1768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 04:45:29.1830 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 04:50:24.3762 1019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 05:05:42.1781 1314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 05:06:25.2026 1312 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 05:13:57.8972 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 05:14:56.0211 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 05:41:40.8689 668 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-01-08 05:41:40','V',4951318005658010,2025,'2025-01-08 05:41:38','456631696800327001012999',2,2,2,'O','',0,'2025-01-08 05:41:40',1,'','',0) 08/01/2025 05:46:12.7256 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 06:06:18.9478 1440 ms. EXEC: update tabTerminalReceipt set trcProgressive = 261, trcLastPrinted = '2500400261', trcLastDate = '2025-01-08 06:06:17' where trcStatus='V' and trcTerId = 4 08/01/2025 06:06:59.8121 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 06:07:25.2961 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 06:08:33.7599 1154 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 06:10:19.6197 623 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/01/2025 06:13:45.9486 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 06:18:47.8426 1001 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 06:20:30.8028 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 06:37:06.5971 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 06:41:41.0546 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 06:42:20.6301 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 06:57:05.6870 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 07:06:56.9624 1199 ms. EXEC: update payReceipt set recCreation = '2025-01-08 07:06:55',recModify = '2025-01-08 07:06:55',recUseId=0,recStatus='V' where recId = 340148 08/01/2025 07:07:56.7340 1177 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 08/01/2025 07:07:57.6236 1873 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/01/2025 07:07:58.7403 981 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 07:11:10.7022 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 07:29:02.2060 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 07:34:00.0791 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 07:45:41.7358 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:00:01.6817 763 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/01/2025 08:02:35.0132 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:03:17.6006 1110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:03:28.6660 1996 ms. EXEC: update paycash set casCreation = '2025-01-08 08:03:26',casModify = '2025-01-08 08:03:26',casUseId=0,casStatus='V' where casId = 203792 08/01/2025 08:03:29.4346 768 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 08:03:26',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'; 08/01/2025 08:05:19.7453 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 08:05:25.4321 1672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:09:54.7011 821 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-01-08 08:09:57',6,'V',5201789396095620,5625000517609460,2025,'2025-01-08 08:09:57',4,1,0,4,'2025-01-08 08:24:57','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/01/2025 08:10:29.2872 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:13:03.5623 763 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 08:27:10.6154 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:28:42.6830 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:30:13.7528 2249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:34:23.7700 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:38:21.9872 583 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 08:38:44.6403 949 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-01-08 08:38:41',0,'V',4769371159084770,5418073770293150,2025,'2025-01-08 08:38:41',3,1,0,4,'2025-01-08 08:53:41','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 08/01/2025 08:43:48.2983 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:44:35.7250 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:45:40.2361 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:56:45.0851 1226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 08:57:28.6072 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 09:02:58.6608 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 09:26:03.5156 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 09:27:24.1805 749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 09:31:52.6311 939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 09:33:51.2954 1865 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 09:33:49',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'; 08/01/2025 09:35:07.4113 744 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 09:36:52.6787 1740 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 09:36:54.3128 1599 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 09:36:52' where payTraUID = 5740855712364510 and payStatus='V' and payEnabled=1 08/01/2025 09:37:00.1107 1891 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 09:53:59.4693 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 09:55:11.4264 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 09:56:02.8407 704 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5661686143740400,5535470055604420,2025,'2025-01-08 09:56:02','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/8/2025 9:48:26 AM Date : 1/8/2025 9:56:00 AM Code : 456633530600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 08/01/2025 09:57:12.8395 859 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 09:58:59.8661 1061 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 08/01/2025 09:59:02.0095 1620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 09:59:13.6943 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 09:59:39.1894 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:02:45.2577 1606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:05:16.6319 1361 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:06:28.8922 695 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 10:08:17.9531 1051 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-08 10:08:16',4,6,'2025-01-08 10:08:16','456632376400327005012999','Payed (Credit Card ) Ticket ') 08/01/2025 10:10:58.2623 547 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/01/2025 10:10:59.2049 1230 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-01-08 10:10:57','V',4685208881661200,2025,'2025-01-08 10:10:57','456632376400327005012999',2,2,2,'O','',0,'2025-01-08 10:10:57',1,'','',0) 08/01/2025 10:12:17.5042 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:12:20.2191 701 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 10:12:50.6364 698 ms. EXEC: update tabTerminalReceipt set trcProgressive = 270, trcLastPrinted = '2500400270', trcLastDate = '2025-01-08 10:12:49' where trcStatus='V' and trcTerId = 4 08/01/2025 10:12:58.5517 685 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',5,3,42101,0,50,-5,-250,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',5,3,42101,0,50,5,250,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',5,3,42101,0,100,-37,-3700,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',5,3,42101,0,100,37,3700,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',5,3,42101,0,200,-3,-600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',5,3,42101,0,200,3,600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',5,3,42101,0,500,-4,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',5,3,42101,0,500,4,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:33',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-01-08 10:12:33',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-01-08 10:12:33',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 08/01/2025 10:13:01.1374 1207 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:52',5,3,42101,0,50,-14,-700,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:52',5,3,42101,0,100,-39,-3900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:52',5,3,42101,0,200,-4,-800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:52',5,3,42101,0,500,-4,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:12:52',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-01-08 10:12:52',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 08/01/2025 10:16:43.0394 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:17:58.0432 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:17:58.2163 689 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-08 10:17:57','V',5128789806846960,2025,'2025-01-08 10:17:56','456633707600327005012999',1,2,16,'I','',1,0,1,'','0810007086215',125,0) 08/01/2025 10:19:32.9866 682 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 10:19:27',5,3,42101,0,50,14,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+14,5),curAmount=round(curAmount+700,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 ('2025-01-08 10:19:27',5,3,42101,0,100,3,300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+3,5),curAmount=round(curAmount+300,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; 08/01/2025 10:20:30.6002 1096 ms. EXEC: update payReceipt set recCreation = '2025-01-08 10:20:29',recModify = '2025-01-08 10:20:29',recUseId=0,recStatus='V' where recId = 340180 08/01/2025 10:21:20.5746 836 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/01/2025 10:21:53.7658 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:27:04.6696 2029 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 10:27:35.7762 1904 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 10:27:44.2389 529 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4910750789279290,5259821544073710,2025,'2025-01-08 10:27:43',' Date: 1/8/2025 10:27:43 AM Code: 456633429300327005012999 Entry Date: 1/8/2025 9:31:33 AM 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 # 2500701063 ',0) 08/01/2025 10:28:35.5169 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:29:08.5990 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 10:29:24.1975 553 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-08 10:29:23',4,6,'2025-01-08 10:29:23','456633638700327005012999','Payed (Credit Card ) Ticket ') 08/01/2025 10:29:59.4830 533 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 10:30:31.2523 1070 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 10:30:30' where payTraUID = 5205392344995130 and payStatus='V' and payEnabled=1 08/01/2025 10:33:46.4220 1265 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:34:13.2512 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 10:34:13.9537 673 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 10:38:02.1863 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 10:38:11.8517 952 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 10:52:49.1741 608 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 08/01/2025 10:59:49.7853 1280 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 11:02:46.6135 629 ms. EXEC: update payReceipt set recCreation = '2025-01-08 11:02:45',recModify = '2025-01-08 11:02:45',recUseId=0,recStatus='V' where recId = 340194 08/01/2025 11:05:07.4646 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 11:07:34.5439 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 11:11:53.0427 1258 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 11:14:07.3678 3706 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 08/01/2025 11:14:07.4108 3804 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 11:16:41.3807 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 11:16:59.3888 1448 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 11:19:47.4924 731 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5337120681746680,4993031764028250,2025,'2025-01-08 11:19:46',' Data: 1/8/2025 11:16:42 AM Codice: 456633733000327005012999 Ingresso: 1/8/2025 10:22:10 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 # 2500600147 ',0) 08/01/2025 11:21:11.0913 754 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 11:22:32.8379 749 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-08 11:22:32',0,16,'2025-01-08 11:22:32','','Unauthorized Transit Entry 2') 08/01/2025 11:24:56.9241 1127 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 11:28:14.9034 736 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 11:28:24.0866 964 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/01/2025 11:35:01.4465 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 11:35:30.3568 1575 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 11:35:31.0352 618 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 11:35:30' where payTraUID = 4726587134907810 and payStatus='V' and payEnabled=1 08/01/2025 11:42:47.6711 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 11:42:48.1414 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 11:43:13.0771 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 11:43:35.6812 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 11:46:51.1648 1112 ms. EXEC: update payReceipt set recCreation = '2025-01-08 11:46:49',recModify = '2025-01-08 11:46:49',recUseId=0,recStatus='V' where recId = 340212 (WAIT TIME 199 ms.) 08/01/2025 11:50:10.8843 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 11:50:39.5745 583 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 11:58:49.5117 1029 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-01-08 11:58:48',0,'V',4979328460656720,5364041379178520,2025,'2025-01-08 11:58:48',18,1,0,4,'2025-01-08 12:13:48','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/01/2025 11:59:25.5778 1782 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 11:59:23',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 11:59:23',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 08/01/2025 12:01:35.4927 540 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 12:02:16.1729 1043 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 12:02:14' where traUID = 5379613888315650 and traStatus='V' and traEnabled=1 08/01/2025 12:02:16.1899 726 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/01/2025 12:04:02.2998 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 12:07:32.8238 772 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/01/2025 12:08:52.3179 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 12:10:47.9923 710 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 12:11:05.6040 765 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 12:11:06.2345 626 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 12:11:07.1881 946 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 12:11:06' where payTraUID = 5005856697495850 and payStatus='V' and payEnabled=1 08/01/2025 12:11:07.7685 578 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 12:11:06' where traUID = 5005856697495850 and traStatus='V' and traEnabled=1 08/01/2025 12:11:13.7575 1268 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 12:14:05.0455 1649 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-01-08 12:13:58',0,'V',5359553516615140,5340167610849010,2025,'2025-01-08 12:13:58',3,1,0,4,'2025-01-08 12:28:58','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 08/01/2025 12:15:38.9502 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 12:22:53.2745 563 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 12:22:58.4490 810 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 12:23:43.3200 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,'2025-01-08 12:23:42','V',4636513402633570,2025,'2025-01-08 12:23:40','456634462000327005012999',1,2,16,'I','',1,0,1,'','',4) 08/01/2025 12:29:49.4527 858 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 12:29:48' where traUID = 4876037274089900 and traStatus='V' and traEnabled=1 08/01/2025 12:29:59.3143 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 12:30:17.5985 781 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-01-08 12:30:16','V',5088215779429370,2025,'2025-01-08 12:30:15','456634501500327005012999',1,2,16,'I','',1,0,1,'','',4) 08/01/2025 12:32:36.4433 526 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 12:32:35',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'; 08/01/2025 12:43:28.8544 543 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 12:43:28' where traUID = 5026010028021720 and traStatus='V' and traEnabled=1 08/01/2025 12:43:32.2937 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 12:47:46.6376 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 12:53:39.3414 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 12:54:21.2224 516 ms. OPEN: show columns from tabParameters where Field = 'parForce24Hours' 08/01/2025 12:55:05.7622 1496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 12:59:00.9274 1040 ms. EXEC: update payReceipt set recCreation = '2025-01-08 12:58:59',recModify = '2025-01-08 12:58:59',recUseId=0,recStatus='V' where recId = 340248 08/01/2025 12:59:48.8593 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:00:11.4704 811 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 13:00:20.3884 1875 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 13:05:26.1968 1234 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/01/2025 13:05:42.5867 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:07:34.1760 1596 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/01/2025 13:08:38.7895 933 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 13:10:13.4440 2114 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:10:33.9878 985 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:12:31.7528 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 13:18:06.7819 1306 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:18:09.1285 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:21:03.6101 687 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 ('2025-01-08 13:21:02',0,'V',5444890274646330,4943160755893650,2025,'2025-01-08 13:21:02',2,1,0,-1,'2025-01-08 14:21:02','S','KES',0,0,0,'','','',3,0,0) 08/01/2025 13:21:08.1542 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 13:21:30.3190 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:23:44.3295 598 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-01-08 13:23:43',0,'V',4820790105364700,5557564845849970,2025,'2025-01-08 13:23:43',18,1,0,4,'2025-01-08 13:38:43','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/01/2025 13:23:45.8446 1201 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5557564845849970,4820790105364700,2025,'2025-01-08 13:23:44',' Date: 1/8/2025 1:23:43 PM Code: 456633780100327005012999 Entry Date: 1/8/2025 10:30:01 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500701097 ',0) 08/01/2025 13:24:50.0565 1121 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 1 ms.) 08/01/2025 13:24:50.6289 502 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 13:24:50' where payTraUID = 5557564845849970 and payStatus='V' and payEnabled=1 08/01/2025 13:25:16.3691 532 ms. EXEC: update tabTerminalReceipt set trcProgressive = 153, trcLastPrinted = '2500600153', trcLastDate = '2025-01-08 13:25:15' where trcStatus='V' and trcTerId = 17 08/01/2025 13:26:03.9569 1634 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 13:26:02' where traUID = 4944624843570650 and traStatus='V' and traEnabled=1 08/01/2025 13:26:28.7334 885 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:33:27.0190 998 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 13:33:53.6338 723 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-01-08 13:33:52','V',4799630979809800,2025,'2025-01-08 13:33:50','456634483100327005012999',2,2,2,'O','',0,'2025-01-08 13:33:52',1,'','',0) 08/01/2025 13:33:54.6915 916 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 13:38:25.0435 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:44:58.4322 540 ms. EXEC: update abbCards set carLastDate = '2025-01-08 13:44:57',carLastDirection='O' where carStatus='V' and carId = 44 08/01/2025 13:44:58.6543 632 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 08/01/2025 13:46:25.2438 697 ms. EXEC: update payReceipt set recCreation = '2025-01-08 13:46:24',recModify = '2025-01-08 13:46:24',recUseId=0,recStatus='V' where recId = 340267 08/01/2025 13:51:07.4999 655 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 13:56:12.4328 974 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/01/2025 13:58:05.9613 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 13:59:02.4653 821 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:00:10.1085 773 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:02:33.8145 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:02:44.4916 531 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-08 14:02:43',0,0,'V',4656356393524870,4795684039782260,2025,'2025-01-08 14:02:43',3,'KES',1,50,50,'N',''); 08/01/2025 14:03:08.6199 548 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/01/2025 14:04:47.1458 646 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 14:05:03.9480 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:05:58.2884 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 14:14:15.1404 515 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-08 14:14:14',0,16,'2025-01-08 14:14:14','','Unauthorized Transit Entry 2') 08/01/2025 14:15:08.6484 810 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-01-08 14:15:07',0,'V',5255574599085060,5224293549737110,2025,'2025-01-08 14:15:07',18,1,0,4,'2025-01-08 14:30:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/01/2025 14:15:23.4093 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 14:15:25.0034 1348 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 14:16:01.5718 1682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 14:17:45.5988 697 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:17:47.8063 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 14:17:52.4344 896 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:18:23.6028 698 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-01-08 14:18:22','V',4868140642425610,2025,'2025-01-08 14:18:21','456634132700327001012999',2,2,2,'O','',0,'2025-01-08 14:18:22',1,'','',0) 08/01/2025 14:18:24.7165 749 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 14:18:23' where traUID = 5278563817233240 and traStatus='V' and traEnabled=1 08/01/2025 14:19:50.6463 818 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:23:19.6278 519 ms. EXEC: update abbCards set carLastDate = '2025-01-08 14:23:19',carLastDirection='O' where carStatus='V' and carId = 17 08/01/2025 14:28:49.9486 1056 ms. EXEC: update payReceipt set recCreation = '2025-01-08 14:28:48',recModify = '2025-01-08 14:28:48',recUseId=0,recStatus='V' where recId = 340292 08/01/2025 14:29:37.2982 508 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 14:30:00.2686 1572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:31:54.5200 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:32:19.8319 808 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 14:32:20.5694 630 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 14:32:19' where payTraUID = 4748528739277840 and payStatus='V' and payEnabled=1 (WAIT TIME 4 ms.) 08/01/2025 14:33:27.1168 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:34:51.5613 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 14:35:49.6851 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 14:41:54.3929 768 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 14:41:53' where traUID = 4869704928423170 and traStatus='V' and traEnabled=1 08/01/2025 14:42:12.1237 514 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 14:42:12.8282 596 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 14:42:49.8339 1019 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-01-08 14:42:48',0,'V',4702360905794260,5741081297053310,2025,'2025-01-08 14:42:48',18,1,0,4,'2025-01-08 14:57:48','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/01/2025 14:46:27.7176 599 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-08 14:46:27','V',4904505037307830,2025,'2025-01-08 14:46:25','456635318500327005012999',1,2,16,'I','',1,0,1,'','0230004098588',183,0) 08/01/2025 14:46:28.8053 606 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 14:49:55.7927 1030 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 14:49:56.4171 601 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 14:49:55' where payTraUID = 4692336554613740 and payStatus='V' and payEnabled=1 08/01/2025 15:00:42.7410 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:00:45.2597 639 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 15:00:44',5,3,0,3,0,0,0,0,'3','') 08/01/2025 15:00:46.0152 577 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 15:00:39',5,3,42101,0,50,-21,-1050,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 15:00:39',5,3,42101,0,100,-10,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 15:00:39',5,3,42101,0,200,-5,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 15:00:39',5,3,42101,0,500,-1,-500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-08 15:00:39',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 08/01/2025 15:01:38.5493 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 15:02:42.1208 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:10:23.6844 736 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:11:21.7262 586 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 15:11:28.8569 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:12:58.2967 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:13:31.1267 2352 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 15:13:28',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 15:13:28',3,42101,0,100,-1,-100,1,'O','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'; 08/01/2025 15:14:57.5684 753 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4724594872979030,5025888672406130,2025,'2025-01-08 15:14:56',' Date: 1/8/2025 3:14:56 PM Code: 456635060800327005012999 Entry Date: 1/8/2025 2:03:28 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 # 2500701130 ',0) 08/01/2025 15:16:59.5972 675 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:17:32.4112 1089 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4811886990812080,5225093798859610,2025,'2025-01-08 15:17:31',' Date: 1/8/2025 3:17:26 PM Code: 456635231000327005012999 Entry Date: 1/8/2025 2:31:50 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500400293 ',0) 08/01/2025 15:17:51.5389 2641 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 15:17:48',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'; 08/01/2025 15:20:10.2313 564 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4904505037307830,4944051232435360,2025,'2025-01-08 15:20:09',' Date: 1/8/2025 3:20:09 PM Code: 456635318500327005012999 Entry Date: 1/8/2025 2:46: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 # 2500701131 ',0) 08/01/2025 15:25:13.7514 785 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:30:22.0064 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:32:08.2034 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:32:29.0663 530 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 15:32:28' where payTraUID = 5604262938884470 and payStatus='V' and payEnabled=1 08/01/2025 15:32:33.2762 798 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 15:32:33.8335 629 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/01/2025 15:32:37.5110 600 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-01-08 15:32:36',0,'V',5541108519154540,5077105098567460,2025,'2025-01-08 15:32:36',18,1,0,4,'2025-01-08 15:47:36','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/01/2025 15:32:57.4453 1039 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 15:32: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'; 08/01/2025 15:34:32.4308 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:36:57.7810 3146 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/01/2025 15:37:13.4166 1536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 15:38:39.6366 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:43:07.9719 760 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/01/2025 15:43:49.7229 1079 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 15:44:51.9264 913 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-01-08 15:44:51','V',4921579418577310,2025,'2025-01-08 15:44:49','456635668900327005012999',1,2,16,'I','',1,0,1,'','',4) 08/01/2025 15:45:11.7537 1584 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-01-08 15:45:10','V',5724641320878730,2025,'2025-01-08 15:45:08','456635033600327005012999',2,2,2,'O','',0,'2025-01-08 15:45:10',1,'','',0) 08/01/2025 15:45:12.5782 582 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 15:45:14.7477 1772 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 15:45:12' where traUID = 5306718092500860 and traStatus='V' and traEnabled=1 08/01/2025 15:45:54.5233 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 15:48:47.7471 756 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/01/2025 15:48:48.7047 696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:49:46.6274 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 15:50:58.9157 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:51:38.8965 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 15:52:36.5620 740 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:09:32.7276 626 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-01-08 16:09:32','V',4657631687467720,2025,'2025-01-08 16:09:30','456635817000327005012999',1,2,16,'I','',1,0,1,'','',4) 08/01/2025 16:11:30.3713 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:12:18.2343 611 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 16:13:43.9896 777 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 16:13:43' where payTraUID = 5645609593888210 and payStatus='V' and payEnabled=1 08/01/2025 16:13:49.2001 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:28:02.3909 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 16:28:07.6284 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:31:04.8789 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:40:04.0412 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:40:46.1673 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 16:41:24.3779 1908 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:44:12.2000 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:44:25.0496 525 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/01/2025 16:44:27.0290 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 16:45:06.5234 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 16:45:10.2879 2277 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/01/2025 16:48:43.9727 1200 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-01-08 16:48:42','V',5226343553589880,2025,'2025-01-08 16:48:40','456635982200327005012999',2,2,2,'O','',0,'2025-01-08 16:48:42',1,'','',0) 08/01/2025 16:49:30.2236 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 16:49:45.3788 530 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 16:49:44' where traUID = 5076960106805050 and traStatus='V' and traEnabled=1 08/01/2025 16:49:59.5082 762 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/01/2025 16:56:59.3912 521 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-08 16:56:58','V',5571645835736220,2025,'2025-01-08 16:56:56','456633957900327005012999',2,2,2,'O','',0,'2025-01-08 16:56:58',1,'','0750009372622',112,0) 08/01/2025 17:02:19.7990 1505 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 17:02:25.0125 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:02:25.4768 1077 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 17:02:45.6053 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 17:03:56.3816 538 ms. EXECSCALAR: select count(*) from tabTerminalReceipt where trcStatus='V' and trcTerId = 18 and trcProgressive<>0 nr: 1 08/01/2025 17:05:21.1162 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:06:03.0593 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 17:06:44.7622 830 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:07:05.5881 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 17:07:39.1195 1293 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 17:07:45.5708 917 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:08:14.2820 914 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:12:59.5427 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:14:01.6333 1509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/01/2025 17:16:37.8773 553 ms. EXEC: update payReceipt set recCreation = '2025-01-08 17:16:37',recModify = '2025-01-08 17:16:37',recUseId=0,recStatus='V' where recId = 340399 08/01/2025 17:17:02.6448 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 17:18:15.3199 959 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:22:41.8181 1312 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:23:49.8192 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:23:50.9219 1072 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 17:28:00.3265 675 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 17:28:02.2808 1644 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 17:28:00' where traUID = 4657631687467720 and traStatus='V' and traEnabled=1 08/01/2025 17:31:07.5391 1111 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/01/2025 17:33:23.0797 1347 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 17:39:40.0658 1197 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-08 17:39:38','V',4962413067239680,2025,'2025-01-08 17:39:36','456632915300327005012999',2,2,2,'O','',0,'2025-01-08 17:39:38',1,'','0560008512164',186,0) 08/01/2025 17:40:54.8360 528 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 17:40:54' where payTraUID = 4730093797402520 and payStatus='V' and payEnabled=1 08/01/2025 17:48:33.2183 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 17:50:33.1628 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 17:51:18.6169 614 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/01/2025 17:51:20.3261 554 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-08 17:51:19' where subId = 43 08/01/2025 17:55:25.9571 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:03:18.3608 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 18:03:31.7578 634 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-08 18:03:31' where subId = 83 08/01/2025 18:03:32.3722 607 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-08 18:03:31','0810007103066',0,0,4764003933381980,82,'0000-00-00 00:00:00','0000-00-00 00:00:00') 08/01/2025 18:03:38.8656 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:07:52.6024 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 18:11:30.0798 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:31:06.1652 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:31:07.5381 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:31:20.2836 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:32:11.8791 566 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 18:35:16.3833 1392 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:36:49.4245 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 18:42:18.8238 621 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 18:42:26.1356 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 18:42:27.1874 1003 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 18:45:17.7092 709 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/01/2025 18:46:02.7303 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:48:18.3129 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:48:20.2612 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 18:52:45.5382 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 19:02:05.8517 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 19:07:44.8683 899 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 19:07:43',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'; 08/01/2025 19:10:38.1281 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 19:13:34.8522 1389 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 19:17:36.0669 534 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 19:17:37.9111 1151 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-08 19:17:36' where payTraUID = 5328570147386140 and payStatus='V' and payEnabled=1 08/01/2025 19:23:43.8029 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 19:27:24.6615 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 19:28:44.2267 885 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/01/2025 19:29:21.3355 922 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 19:31:29.5102 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 19:32:07.7958 911 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 19:32:12.7100 542 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5261194266454740,5447240083559320,2025,'2025-01-08 19:32:12','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/8/2025 6:47:09 PM Date : 1/8/2025 7:32:10 PM Code : 456636762900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 08/01/2025 19:32:13.9519 908 ms. EXEC: update paycash set casCreation = '2025-01-08 19:32:13',casModify = '2025-01-08 19:32:13',casUseId=0,casStatus='V' where casId = 203898 08/01/2025 19:48:35.3571 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 19:52:16.2477 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 20:02:41.7352 543 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5231926111001060,4881306757146390,2025,'2025-01-08 20:02:41',' Data: 1/8/2025 7:59:37 PM Codice: 456637087200327005012999 Ingresso: 1/8/2025 7:41:12 PM 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 # 2500600164 ',0) 08/01/2025 20:17:32.0616 657 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/01/2025 20:20:01.2293 1193 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/01/2025 20:20:31.3074 919 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-08 20:20:30' where subId = 43 08/01/2025 20:20:36.5189 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 20:20:37.5786 1017 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 20:20:37.7967 522 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/01/2025 20:23:37.5679 1031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 20:28:45.4180 798 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 20:28:50.2372 621 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/01/2025 20:28:50.2602 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 20:47:33.3247 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 20:53:55.6963 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 20:57:02.5572 833 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 21:03:49.2540 980 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 21:11:19.7088 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 21:11:20.2321 912 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/01/2025 21:14:47.0610 1260 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/01/2025 21:15:26.0501 823 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 21:40:48.9968 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 21:43:49.7958 1172 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 21:44:19.2906 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 21:56:47.4937 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 21:59:50.6252 567 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 08/01/2025 22:00:16.0727 565 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-08 22:00:15',0,0,'V',5436326124119230,5505559870272130,2025,'2025-01-08 22:00:15',3,'KES',1,500,500,'N',''); 08/01/2025 22:00:19.4814 1613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:04:03.8862 1285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:06:58.5932 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 22:07:11.0806 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:08:20.3899 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:13:54.9205 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 22:13:55.8841 925 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/01/2025 22:15:28.9053 549 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 08/01/2025 22:18:51.1383 909 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-08 22:18:50',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'; 08/01/2025 22:19:02.9021 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:19:45.0699 1729 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/01/2025 22:21:31.2298 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 22:25:48.0100 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 22:26:56.3734 674 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/01/2025 22:28:15.6310 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-01-08 22:28:14','V',5492322932857420,2025,'2025-01-08 22:28:14','456638089400327005012999',1,2,16,'I','',1,0,1,'','',4) 08/01/2025 22:29:57.9591 606 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/01/2025 22:29:58.7316 526 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 22:29:58' where traUID = 5125525419996140 and traStatus='V' and traEnabled=1 08/01/2025 22:34:06.1084 585 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-08 22:34:05' where subId = 43 08/01/2025 22:34:08.0897 669 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-08 22:34:07' where traUID = 5669592913245490 and traStatus='V' and traEnabled=1 08/01/2025 22:36:36.8792 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:40:09.1711 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:44:14.6141 505 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-08 22:44:14','V',4957813879713100,2025,'2025-01-08 22:44:12','456638185200327001012999',1,2,1,'I','',1,0,1,'','0230003943530',44,0) 08/01/2025 22:46:15.0671 1944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:46:43.6540 1175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 22:58:01.3641 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 23:00:23.1777 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 23:03:17.1044 553 ms. OPEN: select * from abbAreaGroup left join abbGroupSlots on grsArgId = argId where argStatus='V' and argAbgId = 99999 and (grsDate='1970-01-01' or (grsDate = '2025-01-08' and grsRecurrency=0) or (month(grsDate) = 1 and day(grsDate)=8 and grsRecurrency=1)) order by grsDOW,grsRecurrency,grsDate,grsTimeFrom 08/01/2025 23:03:23.2735 2002 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/01/2025 23:03:29.1804 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 23:42:57.2652 884 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 23:46:26.0901 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/01/2025 23:48:26.3979 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1