19/02/2025 00:04:43.1941 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:04:46.2392 1458 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:04:48.6730 1724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:04:55.7080 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:07:40.0867 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:09:21.6024 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:15:34.3443 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:15:34.3463 1027 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 00:17:36.8710 683 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 19/02/2025 00:22:11.0604 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:23:22.9038 1047 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/02/2025 00:32:49.0253 1119 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:39:05.7811 683 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 00:43:33.8507 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 00:49:15.7361 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 01:21:01.2989 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 01:22:04.2940 998 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 19/02/2025 02:00:07.3407 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 02:06:04.9598 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 02:06:24.9551 1153 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 02:41:05.0237 1679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 02:41:15.6173 3496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 02:41:59.0304 1059 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 02:53:28.7780 885 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 19/02/2025 02:57:45.4709 789 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/02/2025 03:00:42.3295 1639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 03:00:47.4572 1518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 03:03:18.6171 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 03:13:17.8212 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 03:23:57.6216 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 03:47:52.9970 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 04:00:17.4556 1112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 04:01:07.6365 815 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 19/02/2025 04:20:39.8293 1656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 04:32:09.4441 656 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 05:03:57.3065 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 05:16:11.4134 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 05:42:08.6361 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 05:43:22.3900 613 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 05:44:08.0887 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 05:57:51.8186 589 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 406878 else acvFstPayId end),acvLstPayId = 406878 where acvSftId = 901 and acvCodeId = 3 19/02/2025 06:19:52.2577 1116 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 06:25:37.6801 545 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 06:28:40.8277 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 06:33:36.6222 601 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 06:33:35' where traUID = 5007436225401240 and traStatus='V' and traEnabled=1 19/02/2025 06:33:37.5379 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 06:37:29.0607 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 06:43:34.8717 1157 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-02-19 06:43:33','V',4897861256206770,2025,'2025-02-19 06:43:32','457052277600327005012999',2,2,2,'O','',0,'2025-02-19 06:43:33',1,'','',0) 19/02/2025 06:43:36.5749 1404 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 06:43:35' where payTraUID = 4909297182297780 and payStatus='V' and payEnabled=1 19/02/2025 06:44:44.3744 1850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 06:46:13.7595 758 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4982591221767820,5753202840978550,2025,'2025-02-19 06:46:12','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/19/2025 6:25:36 AM Date : 2/19/2025 6:46:11 AM Code : 457052313600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 19/02/2025 06:46:14.5560 792 ms. EXEC: update payReceipt set recCreation = '2025-02-19 06:46:13',recModify = '2025-02-19 06:46:13',recUseId=0,recStatus='V' where recId = 353018 19/02/2025 06:48:03.7012 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 06:48:14.0246 720 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/02/2025 06:52:51.9776 743 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 06:58:08.0072 1347 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 07:09:16.8244 521 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-02-19 06:09:16') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-19 07:09:16' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-19 07:09:16' and (resAreId = 1 or resAreId <= 0) nr: 0 19/02/2025 07:20:03.7765 606 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 07:20:03.7845 596 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 07:30:25.6769 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 07:31:09.7434 1071 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 07:34:49.4327 1455 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 07:38:09.5200 710 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 07:39:42.6647 1178 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 07:43:22.1239 665 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 07:43:21',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-02-19 07:43:21',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'; 19/02/2025 07:50:22.0051 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 07:56:05.2924 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 07:56:53.8132 730 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-19 07:56:53','0230003944081',0,0,5106715494219310,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 19/02/2025 07:56:59.5293 1806 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 08:00:29.0363 695 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 186 19/02/2025 08:00:54.7157 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 08:01:14.1626 510 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/02/2025 08:01:17.8993 1876 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/02/2025 08:01:41.6964 2030 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-19 08:01:39',0,0,'V',5592653212128800,5424412563861770,2025,'2025-02-19 08:01:39',3,'KES',1,100,100,'N',''); 19/02/2025 08:03:28.4888 1187 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 08:04:31.4659 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 08:10:24.0326 866 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 19/02/2025 08:10:24.0426 1089 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 08:40:09.3733 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 08:44:46.5849 867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 08:47:12.1821 545 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 08:47:17.5600 593 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 08:47:35.9982 802 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/02/2025 08:49:31.5269 965 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 19/02/2025 08:49:37.6283 727 ms. OPEN: select * from paypayment where payUID = 5261323752257400 and payStatus='V' 19/02/2025 08:52:09.4560 891 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-02-19 08:52:08','V',5662229904244770,2025,'2025-02-19 08:52:07','457053192700327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 08:54:29.4073 538 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-02-19 08:54:28','V',4730861724013140,2025,'2025-02-19 08:54:28','457053206800327001012999',1,2,1,'I','',1,0,1,'','',4) 19/02/2025 08:58:16.4328 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:02:24.1993 621 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-02-19 09:02:22',0,'V',5662291445929050,5120379506697180,2025,'2025-02-19 09:02:22',3,1,0,4,'2025-02-19 09:17:22','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 19/02/2025 09:07:46.9590 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:08:01.1351 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:13:08.4375 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:21:35.8149 732 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 09:21:44.8163 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:24:22.6774 1314 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 09:26:41.9194 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:27:33.7045 754 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-02-19 09:27:31',0,'V',4619168506582040,4645912195390220,2025,'2025-02-19 09:27:31',3,1,0,2,'2025-02-19 09:42:31','C','KES',500,0,0,'',' ',' ',98,500,0,0,'',0,0) 19/02/2025 09:29:18.6096 556 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/02/2025 09:30:47.0529 971 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 09:34:20.9942 1132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:37:41.8420 596 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 09:41:09.8960 1801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:42:10.5360 693 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 09:45:44.0493 818 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/02/2025 09:45:50.2637 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:47:22.5398 1232 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 09:48:25.4008 680 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '457052526500327005012999' 19/02/2025 09:48:26.4626 957 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '457052526500327005012999' 19/02/2025 09:51:34.2191 850 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 09:57:03.7941 1625 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-19 09:56:57',5,3,42101,0,50,-19,-950,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-19 09:56:57',5,3,42101,0,100,-38,-3800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-19 09:56:57',5,3,42101,0,200,-13,-2600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-19 09:56:57',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-02-19 09:56:57',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-02-19 09:56:57',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 19/02/2025 09:57:48.2299 688 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-19 09:57:47',0,3,'2025-02-19 09:57:47','0230003944086','POF - User Transit Supervisor Supervisor') 19/02/2025 10:07:18.2127 1311 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 10:16:26.2177 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:16:26.2317 674 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 10:19:27.6076 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:19:40.9341 1383 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-02-19 10:19:39','V',4648784885523590,2025,'2025-02-19 10:19:37','457053717700327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 10:20:33.7099 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:20:47.1716 655 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 19/02/2025 10:22:34.0821 1207 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 10:22:44.2094 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:25:39.1557 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:28:12.1262 527 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-19 10:28:11',0,2,'2025-02-19 10:28:11','','Manual Open Barrier Exit 1') 19/02/2025 10:28:22.2685 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:29:51.1471 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:31:17.0527 1245 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:33:31.2148 1381 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:33:35.5248 1299 ms. EXEC: update payReceipt set recCreation = '2025-02-19 10:33:34',recModify = '2025-02-19 10:33:34',recUseId=0,recStatus='V' where recId = 353054 19/02/2025 10:36:26.5886 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:36:26.6086 626 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/02/2025 10:40:56.6980 677 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-02-19 10:40:53',0,'V',5203584411665910,5639637811797200,2025,'2025-02-19 10:40:53',3,1,0,4,'2025-02-19 10:55:53','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 19/02/2025 10:44:03.9891 668 ms. EXEC: update payInventory set invCreation = '2025-02-19 10:44:03',invModify = '2025-02-19 10:44:03',invUseId=0,invStatus='V' where invId = 237178 19/02/2025 10:45:48.9563 810 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-02-19 10:45:48','V',5679487109380460,2025,'2025-02-19 10:45:47','457053366700327005012999',2,2,2,'O','',0,'2025-02-19 10:45:48',1,'','',0) 19/02/2025 10:45:53.0573 948 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); 19/02/2025 10:45:54.3962 1324 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 10:46:08.6654 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:46:41.3839 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 10:46:56.7018 926 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 10:55:04.9185 853 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 11:01:44.2655 741 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 11:03:03.1140 1087 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-02-19 11:03:02','V',5628932387414380,2025,'2025-02-19 11:03:01','457053978100327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 11:05:44.8658 670 ms. EXEC: update payReceipt set recCreation = '2025-02-19 11:05:44',recModify = '2025-02-19 11:05:44',recUseId=0,recStatus='V' where recId = 353068 19/02/2025 11:06:12.0903 679 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 11:06:11' where payTraUID = 5092274935001110 and payStatus='V' and payEnabled=1 19/02/2025 11:07:16.3103 1131 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:08:21.7792 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:08:22.9871 806 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-02-19 11:08:22','V',5634763909781810,2025,'2025-02-19 11:08:20','457053795300327005012999',2,2,2,'O','',0,'2025-02-19 11:08:22',1,'','',0) 19/02/2025 11:14:39.9811 518 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 11:14:39' where payTraUID = 5628932387414380 and payStatus='V' and payEnabled=1 19/02/2025 11:15:03.7271 1082 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 19/02/2025 11:15:15.2453 537 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/02/2025 11:15:35.0985 2869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:15:48.9374 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:16:56.9442 2890 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-02-19 11:15:57',9,'V',4914343320549980,5457562397240210,2025,'2025-02-19 11:15:57',4,1,0,4,'2025-02-19 11:30:57','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 11:18:53.3195 2458 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:19:14.5307 1431 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:21:21.9405 1138 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 11:22:23.0322 1017 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-19 11:22:22' where subId = 198 19/02/2025 11:22:33.2916 1967 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 11:23:47.7989 1415 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-02-19 11:23:46','V',4668679666658040,2025,'2025-02-19 11:23:45','457054102500327001012999',1,2,1,'I','',1,0,1,'','',4) 19/02/2025 11:24:22.6729 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:24:22.8380 817 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/02/2025 11:24:27.0610 864 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2170, trcLastPrinted = '2500402170', trcLastDate = '2025-02-19 11:24:26' where trcStatus='V' and trcTerId = 4 19/02/2025 11:33:04.9182 1165 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 11:33:03',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'; 19/02/2025 11:33:05.4877 516 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-19 11:33:04',0,0,'V',5323862704222320,4733226998263600,2025,'2025-02-19 11:33:04',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-19 11:33:04',0,0,'V',5323862704222320,4733226998263600,2025,'2025-02-19 11:33:04',3,'KES',-1,100,-100,'N',''); 19/02/2025 11:34:14.4090 1126 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 11:34:21.1428 2310 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:34:30.4495 1729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:34:53.2788 1167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:35:07.2098 2689 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 11:35:54.4627 1113 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:36:40.3105 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 11:37:01.9680 3567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:37:38.7093 574 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 19/02/2025 11:37:44.6466 612 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-02-19 11:37:44','V',4991567478443020,2025,'2025-02-19 11:37:41','457053545000327005012999',2,2,2,'O','',0,'2025-02-19 11:37:44',1,'','0230003944059',13,0) 19/02/2025 11:38:22.5497 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 11:38:24.9244 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:38:41.9816 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:40:10.0437 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:40:13.9215 1670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:41:31.1658 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 11:41:42.2267 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:41:51.5604 1916 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 11:41:49' where traUID = 5434980818251330 and traStatus='V' and traEnabled=1 19/02/2025 11:42:27.3190 3285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:42:36.4696 523 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-02-19 11:42:35',0,'V',5160270329003110,5003289053143830,2025,'2025-02-19 11:42:35',18,1,0,4,'2025-02-19 11:57:35','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 11:44:34.3770 960 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 11:45:29.7256 1117 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/02/2025 11:45:32.9369 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:45:38.4969 637 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-02-19 11:45:37','V',5764219726010980,2025,'2025-02-19 11:45:37','457054233700327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 11:47:46.7598 653 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-02-19 11:47:19',1,'V',5329345170077760,5733351426001820,2025,'2025-02-19 11:47:19',17,1,0,4,'2025-02-19 12:02:19','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 11:48:30.2709 835 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 11:54:03.7947 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:56:31.5885 813 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 11:56:35.1070 1814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 11:57:37.9020 780 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 12:01:01.6119 823 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-19 12:01:00',4,9,'2025-02-19 12:01:00','457054170600327005012999','Payed (Credit Card ) Ticket ') 19/02/2025 12:02:07.6352 554 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-02-19 12:02:07','V',5663659090665720,2025,'2025-02-19 12:02:05','457054332500327005012999',1,2,16,'I','',1,0,1,'','0560008419314',195,0) 19/02/2025 12:03:17.3051 1087 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 12:08:29.5497 933 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-02-19 12:08:28','V',5313032871311570,2025,'2025-02-19 12:08:26','457054370600327005012999',1,2,16,'I','',1,0,1,'','0810007086215',125,0) 19/02/2025 12:08:38.7473 2094 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:08:41.8375 2256 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-19 12:08:39',0,16,'2025-02-19 12:08:39','','Unauthorized Transit Entry 2') 19/02/2025 12:08:51.0961 607 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 12:08:50' where traUID = 5302389915411580 and traStatus='V' and traEnabled=1 19/02/2025 12:09:12.8977 664 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 12:10:09.5163 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:11:17.7461 666 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-02-19 12:11:17','V',5593838739423170,2025,'2025-02-19 12:11:16','457054387600327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 12:11:18.2825 533 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 12:13:42.6439 867 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/02/2025 12:13:42.6879 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:15:31.8561 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 12:16:01.9967 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:17:34.1857 781 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5091511691239320,4673503398159930,2025,'2025-02-19 12:17:33',' Date: 2/19/2025 12:17:33 PM Code: 457054084500327005012999 Entry Date: 2/19/2025 11:20:45 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 # 2500706937 ',0) 19/02/2025 12:19:09.7502 758 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 19/02/2025 12:19:09.9593 968 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/02/2025 12:19:32.2213 649 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 366 ms.) 19/02/2025 12:24:13.8600 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:24:39.3062 736 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 12:25:17.5406 958 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-02-19 12:25:16','V',4925421296820120,2025,'2025-02-19 12:25:15','457054471500327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 12:28:28.7695 609 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 12:28:29.5951 800 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 12:28:28' where payTraUID = 5459917072484780 and payStatus='V' and payEnabled=1 19/02/2025 12:28:36.0387 1997 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 12:28:56.2782 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:32:43.4949 554 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 19/02/2025 12:32:47.5599 579 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 12:33:33.6158 1028 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-19 12:33:32',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-02-19 12:33:32',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'; 19/02/2025 12:34:16.1743 1451 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '457054327400327005012999' 19/02/2025 12:34:58.8479 739 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6940, trcLastPrinted = '2500706940', trcLastDate = '2025-02-19 12:34:58' where trcStatus='V' and trcTerId = 18 19/02/2025 12:35:13.2782 954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:36:19.2585 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:36:51.9719 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 12:37:48.6255 2227 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 12:37:49.2399 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 12:49:03.0904 847 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 19/02/2025 12:50:59.2796 699 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/02/2025 12:55:03.3834 892 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 12:55:02' where payTraUID = 5392235502665800 and payStatus='V' and payEnabled=1 19/02/2025 12:55:43.1679 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 13:00:31.8987 767 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 13:01:16.9959 542 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 13:02:13.3153 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:02:20.0321 572 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-02-19 13:02:19',0,'V',5729138926356120,4924396363468120,2025,'2025-02-19 13:02:19',2,1,0,-1,'2025-02-19 14:02:19','S','KES',0,0,0,'','','',3,0,0) 19/02/2025 13:12:09.7194 914 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6946, trcLastPrinted = '2500706946', trcLastDate = '2025-02-19 13:12:08' where trcStatus='V' and trcTerId = 18 19/02/2025 13:12:11.2765 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:12:24.6941 1126 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 19/02/2025 13:12:42.3348 609 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 13:12:49.1266 648 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 13:14:17.0106 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:14:18.8579 747 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 13:14:17' where traUID = 4648784885523590 and traStatus='V' and traEnabled=1 19/02/2025 13:14:20.6522 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:19:17.1771 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:21:10.4006 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:21:45.9351 786 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/02/2025 13:22:36.1160 762 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 13:23:48.3498 593 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/02/2025 13:24:24.9710 547 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 13:24:56.2364 1092 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 13:24:58.3309 896 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 19/02/2025 13:25:14.8537 1152 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 13:25:49.0442 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:26:02.8281 956 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 13:26:01' where payTraUID = 5727024639521070 and payStatus='V' and payEnabled=1 19/02/2025 13:26:06.1424 1577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 13:26:36.9075 1845 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-100,5),subLastDebit = '2025-02-19 13:26:35' where subId = 210 19/02/2025 13:27:57.6773 2792 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 19/02/2025 13:28:26.6341 2920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:29:20.2565 1644 ms. EXEC: update payInventory set invCreation = '2025-02-19 13:29:18',invModify = '2025-02-19 13:29:18',invUseId=0,invStatus='V' where invId = 237225 19/02/2025 13:29:31.3774 5515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:29:31.3784 4705 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 19/02/2025 13:29:40.1057 585 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-19 13:29:39',17,1,'2025-02-19 13:29:39','457054732100327005012999','Pagato (Contanti ) Biglietto ') 19/02/2025 13:29:42.2952 1594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:29:58.0465 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 13:29:58.7790 715 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 19/02/2025 13:30:03.3563 501 ms. EXECSCALAR: select sftId from opeShifts where sftStatus='V' and sftUID = 202200100177 nr: 900 19/02/2025 13:30:04.1809 588 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1230, trcLastPrinted = '2500601230', trcLastDate = '2025-02-19 13:30:03' where trcStatus='V' and trcTerId = 17 19/02/2025 13:30:07.5923 2913 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 19/02/2025 13:30:07.6964 2256 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:30:46.5412 575 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 13:30:45' where payTraUID = 5571069441969420 and payStatus='V' and payEnabled=1 19/02/2025 13:31:01.3058 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:31:03.7326 906 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 19/02/2025 13:32:42.9586 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:33:10.2922 2232 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 19/02/2025 13:33:15.6320 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:33:26.9511 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:35:54.8530 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:37:17.6584 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:37:48.0491 503 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 19/02/2025 13:41:41.7294 797 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 13:41:54.5886 1720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:45:45.5710 626 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 19/02/2025 13:50:04.7756 722 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/02/2025 13:55:30.7531 822 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-02-19 13:55:28',0,'V',4998800254188610,5115988737078990,2025,'2025-02-19 13:55:28',3,1,0,4,'2025-02-19 14:10:28','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 19/02/2025 13:55:32.0940 591 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 13:55:31',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'; 19/02/2025 13:55:32.9967 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:56:13.4487 553 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 13:56:12' where payTraUID = 4844792806342680 and payStatus='V' and payEnabled=1 19/02/2025 13:56:34.3496 724 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1234, trcLastPrinted = '2500601234', trcLastDate = '2025-02-19 13:56:33' where trcStatus='V' and trcTerId = 17 19/02/2025 13:56:53.7095 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:57:20.8980 573 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 13:57:21.7776 553 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 13:57:20' where traUID = 4685050110921550 and traStatus='V' and traEnabled=1 19/02/2025 13:58:08.1308 1179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 13:59:00.2811 665 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 13:59:01.2828 669 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 13:59:00' where traUID = 4747376841476190 and traStatus='V' and traEnabled=1 19/02/2025 14:00:10.7856 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:00:32.7173 723 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-02-19 14:00:31',0,'V',5605118570082490,4861568573076140,2025,'2025-02-19 14:00:31',3,1,0,4,'2025-02-19 14:15:31','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 19/02/2025 14:01:52.5275 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:02:00.8725 1032 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-02-19 14:01:59','V',4697814241738430,2025,'2025-02-19 14:01:58','457054840600327005012999',2,2,2,'O','',0,'2025-02-19 14:01:59',1,'','',0) 19/02/2025 14:02:12.1696 929 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:03:36.5650 834 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extCode' 19/02/2025 14:04:08.3317 1749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:04:19.1305 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 14:04:39.4500 987 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 19/02/2025 14:04:39.8613 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:04:40.3337 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 14:04:43.6791 1021 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-02-19 14:04:42',0,'V',4613967558311160,5355621925886020,2025,'2025-02-19 14:04:42',18,1,0,4,'2025-02-19 14:19:42','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 14:04:51.5657 1027 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-02-19 14:04:50','V',4631152266851230,2025,'2025-02-19 14:04:49','457055068900327001012999',1,2,1,'I','',1,0,1,'','',4) 19/02/2025 14:04:52.6575 801 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 14:11:06.4345 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:13:29.1457 958 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-19 14:13:28',0,16,'2025-02-19 14:13:28','','Unauthorized Transit Entry 2') 19/02/2025 14:14:11.2569 561 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-19 14:14:10',0,0,'V',4699122398004700,4929842168934880,2025,'2025-02-19 14:14:10',3,'KES',-1,50,-50,'N',''); 19/02/2025 14:14:11.8313 554 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 14:14:10',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'; 19/02/2025 14:16:59.9967 582 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4802744321594210,5755748339311110,2025,'2025-02-19 14:16:59','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/19/2025 12:38:15 PM Date : 2/19/2025 2:16:58 PM Code : 457054549500327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 19/02/2025 14:17:01.5859 1239 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 14:17:00',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'; 19/02/2025 14:19:26.1174 1162 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-02-19 14:19:24','V',5440487071870400,2025,'2025-02-19 14:19:24','457055156400327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 14:20:03.9995 1856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:20:56.9504 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:21:09.5745 637 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 19/02/2025 14:24:38.0648 710 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/02/2025 14:24:40.6366 891 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-02-19 14:24:39',0,'V',5743117243249450,4680519988132180,2025,'2025-02-19 14:24:39',18,1,0,4,'2025-02-19 14:39:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 14:25:41.0769 1297 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-02-19 14:25:39',0,'V',5424340836503570,4631152266851230,2025,'2025-02-19 14:25:39',18,1,0,4,'2025-02-19 14:40:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 14:27:00.0525 502 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 14:26:59' where traUID = 4631152266851230 and traStatus='V' and traEnabled=1 19/02/2025 14:27:12.8886 912 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/02/2025 14:27:12.8926 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:27:30.2131 765 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 14:27:45.9243 510 ms. EXEC: update payInventory set invCreation = '2025-02-19 14:27:45',invModify = '2025-02-19 14:27:45',invUseId=0,invStatus='V' where invId = 237237 19/02/2025 14:30:45.4692 566 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 14:31:03.5641 719 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-02-19 14:31:02','V',4893437159737230,2025,'2025-02-19 14:31:01','457055111100327005012999',2,2,2,'O','',0,'2025-02-19 14:31:02',1,'','',0) 19/02/2025 14:31:04.4227 727 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 14:31:33.1270 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 14:31:55.0787 717 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 14:32:13.6610 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:35:58.5994 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:36:48.5461 800 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 14:39:39.7838 663 ms. EXEC: update payInventory set invCreation = '2025-02-19 14:39:39',invModify = '2025-02-19 14:39:39',invUseId=0,invStatus='V' where invId = 237239 19/02/2025 14:43:09.5460 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:43:55.9372 847 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 14:47:42.5535 613 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 19/02/2025 14:48:39.6454 601 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 14:49:21.9357 522 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-02-19 14:49:21','V',4906295699965600,2025,'2025-02-19 14:49:20','457055336000327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 14:50:04.0959 589 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-02-19 14:50:03',0,'V',4793424993098170,5713639201314290,2025,'2025-02-19 14:50:03',18,1,0,4,'2025-02-19 15:05:03','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 14:50:04.9275 668 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5713639201314290,4793424993098170,2025,'2025-02-19 14:50:04',' Date: 2/19/2025 2:50:03 PM Code: 457055097800327005012999 Entry Date: 2/19/2025 2:09:38 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 # 2500706973 ',0) 19/02/2025 14:51:23.0474 1180 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-02-19 14:51:21','V',4990430104834560,2025,'2025-02-19 14:51:21','457054694700327005012999',2,2,2,'O','',0,'2025-02-19 14:51:21',1,'','',0) 19/02/2025 14:51:32.2980 749 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 407067 else acvFstPayId end),acvLstPayId = 407067 where acvSftId = 900 and acvCodeId = 3 19/02/2025 14:51:51.7850 1091 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-02-19 14:51:50','V',5700836586264020,2025,'2025-02-19 14:51:49','457052867000327005012999',2,2,2,'O','',0,'2025-02-19 14:51:50',1,'','0560008421774',187,0) 19/02/2025 14:51:52.9518 940 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 14:51:53.5172 545 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 14:51:52' where payTraUID = 4812935056199030 and payStatus='V' and payEnabled=1 19/02/2025 14:53:09.4466 594 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-02-19 14:53:08','V',5659712824770180,2025,'2025-02-19 14:53:07','457055122700327005012999',2,2,2,'O','',0,'2025-02-19 14:53:08',1,'','',0) 19/02/2025 14:57:03.6373 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 14:58:53.8943 530 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-02-19 14:57:55',9,'V',5706323065369140,4906295699965600,2025,'2025-02-19 14:57:55',4,1,0,4,'2025-02-19 15:12:55','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 14:59:17.8384 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:00:01.0954 701 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-02-19 15:00:00','V',4999825559524240,2025,'2025-02-19 14:59:59','457055399900327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 15:00:02.4244 638 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 15:00:18.3808 619 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 19/02/2025 15:01:09.1322 609 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4768336326276490,5077884599578300,2025,'2025-02-19 15:01:08',' Date: 2/19/2025 3:01:08 PM Code: 457055063600327005012999 Entry Date: 2/19/2025 2:03:56 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 # 2500706976 ',0) 19/02/2025 15:01:20.8185 3363 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 407073 else acvFstPayId end),acvLstPayId = 407073 where acvSftId = 901 and acvCodeId = 3 19/02/2025 15:03:26.7087 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:08:19.8416 604 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 15:08:19' where traUID = 5732353666341800 and traStatus='V' and traEnabled=1 19/02/2025 15:09:20.8753 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-02-19 15:09:20','V',4852594905162240,2025,'2025-02-19 15:09:19','457055265000327005012999',2,2,2,'O','',0,'2025-02-19 15:09:20',1,'','',0) 19/02/2025 15:11:17.0415 1140 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-02-19 15:11:15','V',5008472309446920,2025,'2025-02-19 15:11:13','457055382900327005012999',2,2,2,'O','',0,'2025-02-19 15:11:15',1,'','',0) 19/02/2025 15:11:17.5509 506 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 15:13:01.6406 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:13:01.6416 921 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 19/02/2025 15:13:04.8549 1420 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:13:14.1886 2979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:13:31.1277 1891 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 15:13:28',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'; 19/02/2025 15:13:31.9763 847 ms. EXEC: update payInventory set invCreation = '2025-02-19 15:13:31',invModify = '2025-02-19 15:13:31',invUseId=0,invStatus='V' where invId = 237242 19/02/2025 15:13:36.0202 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-02-19 15:13:35',0,'V',4673990674486250,4801181019041990,2025,'2025-02-19 15:13:35',18,1,0,4,'2025-02-19 15:28:35','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 15:14:07.2896 572 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-19 15:14:06','0230004098567',0,0,4619946572776210,165,'0000-00-00 00:00:00','0000-00-00 00:00:00') 19/02/2025 15:14:08.7787 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 15:14:26.7225 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:16:55.9204 1010 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 15:17:36.5745 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:18:21.9140 1674 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6980, trcLastPrinted = '2500706980', trcLastDate = '2025-02-19 15:18:20' where trcStatus='V' and trcTerId = 18 19/02/2025 15:26:05.9187 542 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 15:26:14.9982 858 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 407092 else acvFstPayId end),acvLstPayId = 407092 where acvSftId = 901 and acvCodeId = 3 19/02/2025 15:35:58.8176 1932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:35:59.7693 599 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 15:36:09.8235 2340 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 15:37:24.4419 698 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 15:39:31.5770 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:42:16.7723 2082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:42:44.4251 901 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 15:43:28.6868 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:43:35.1154 960 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5645858958684530,5469104865194940,2025,'2025-02-19 15:43:34','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/19/2025 3:31:11 PM Date : 2/19/2025 3:43:32 PM Code : 457055587100327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 19/02/2025 15:43:37.7583 2639 ms. EXEC: update payReceipt set recCreation = '2025-02-19 15:43:35',recModify = '2025-02-19 15:43:35',recUseId=0,recStatus='V' where recId = 353221 19/02/2025 15:46:02.5680 990 ms. EXEC: update payInventory set invCreation = '2025-02-19 15:46:01',invModify = '2025-02-19 15:46:01',invUseId=0,invStatus='V' where invId = 237252 19/02/2025 15:46:02.7111 946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 15:46:11.9837 1279 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-19 15:46:10' where subId = 122 19/02/2025 15:46:12.6983 706 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-19 15:46:11','0810007127724',0,0,5050625747641140,111,'0000-00-00 00:00:00','0000-00-00 00:00:00') 19/02/2025 15:46:14.7597 2049 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-02-19 15:46:12',0,'V',5050625747641140,5314900647894450,2025,'2025-02-19 15:46:12',2,1,0,-1,'2025-02-19 16:46:12','S','KES',0,0,0,'','','',3,0,0) 19/02/2025 15:46:17.2966 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 15:50:53.6735 920 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 865056 19/02/2025 15:55:19.6312 560 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 15:56:08.6794 615 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 19/02/2025 15:58:52.7613 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 16:03:31.9497 532 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 16:05:22.6360 528 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5681618071949430,5041108902504320,2025,'2025-02-19 16:05:22','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/19/2025 3:32:53 PM Date : 2/19/2025 4:05:21 PM Code : 457055597300327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 100.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 50.00 KES',0) 19/02/2025 16:07:58.4846 1164 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 16:09:23.3208 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 16:09:54.6102 668 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 16:09:53' where payTraUID = 5681618071949430 and payStatus='V' and payEnabled=1 19/02/2025 16:11:06.6268 1065 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-02-19 16:11:05','V',5133430489240710,2025,'2025-02-19 16:11:04','457055826400327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 16:11:58.8852 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 16:12:20.0824 1096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 16:14:16.9531 748 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/02/2025 16:14:52.2804 922 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-02-19 16:14:51','V',4892650289620890,2025,'2025-02-19 16:14:50','457055675700327001012999',2,2,2,'O','',0,'2025-02-19 16:14:51',1,'','',0) 19/02/2025 16:21:43.4419 548 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 16:21:42' where traUID = 5262083939781750 and traStatus='V' and traEnabled=1 19/02/2025 16:22:51.6187 757 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 16:22:50' where traUID = 4894741732535400 and traStatus='V' and traEnabled=1 19/02/2025 16:22:59.6164 518 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-02-19 16:22:59',0,'V',4706546186533470,4669585436880700,2025,'2025-02-19 16:22:59',18,1,0,4,'2025-02-19 16:37:59','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 19/02/2025 16:23:13.5284 578 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 16:28:07.4558 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 16:28:17.5340 1466 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 16:28:25.0514 1637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 16:28:42.4428 779 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-02-19 16:28:40',0,'V',4847323859222860,4996136008048770,2025,'2025-02-19 16:28:40',3,1,0,4,'2025-02-19 16:43:40','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 19/02/2025 16:32:01.8807 556 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-02-19 16:32:00',0,'V',5758738864477060,5382907610589510,2025,'2025-02-19 16:32:00',3,1,0,4,'2025-02-19 16:47:00','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 19/02/2025 16:32:58.1760 526 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 19/02/2025 16:36:32.0261 588 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-02-19 16:36:31','V',5017019781364680,2025,'2025-02-19 16:36:30','457055821000327005012999',2,2,2,'O','',0,'2025-02-19 16:36:31',1,'','',0) 19/02/2025 16:36:32.9708 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 16:38:14.0282 1026 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 16:38:18.0551 660 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 16:42:13.4196 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 16:42:52.6367 1131 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7018, trcLastPrinted = '2500707018', trcLastDate = '2025-02-19 16:42:51' where trcStatus='V' and trcTerId = 18 19/02/2025 16:49:43.1154 578 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 16:49:54.2884 880 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 16:49:57.6508 1604 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 16:51:20.7353 587 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-02-19 16:51:20',0,'V',4940251566347520,5417631677988210,2025,'2025-02-19 16:51:20',18,1,0,4,'2025-02-19 17:06:20','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 19/02/2025 16:51:44.4263 882 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-02-19 16:51:43','V',5420291594440110,2025,'2025-02-19 16:51:42','457055616600327005012999',2,2,2,'O','',0,'2025-02-19 16:51:43',1,'','',0) 19/02/2025 16:57:32.3104 832 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 16:57:31',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-02-19 16:57:31',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 19/02/2025 16:58:34.5560 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-02-19 16:58:34','V',5609601988216250,2025,'2025-02-19 16:58:31','457056111100327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 16:58:35.3896 830 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 16:58:49.7469 2411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:02:26.0718 1333 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:04:03.8408 518 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 19/02/2025 17:04:30.6950 1042 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-02-19 17:03:32',9,'V',5001156910334980,4945106013621370,2025,'2025-02-19 17:03:32',4,1,0,4,'2025-02-19 17:18:32','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 19/02/2025 17:04:40.3750 1281 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 17:04:38',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'; 19/02/2025 17:04:41.6269 1251 ms. EXEC: update payInventory set invCreation = '2025-02-19 17:04:40',invModify = '2025-02-19 17:04:40',invUseId=0,invStatus='V' where invId = 237263 19/02/2025 17:07:03.3073 841 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 17:07:57.3300 1933 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 17:09:17.1452 661 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 17:09:16' where traUID = 5157190895929070 and traStatus='V' and traEnabled=1 19/02/2025 17:11:04.4037 1178 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 17:11:03' where traUID = 4849813615120250 and traStatus='V' and traEnabled=1 19/02/2025 17:11:32.8000 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 17:11:50.2365 557 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-19 17:11:49','0230004101223',0,0,4738569021163150,11,'0000-00-00 00:00:00','0000-00-00 00:00:00') 19/02/2025 17:13:17.3295 573 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 17:15:47.7355 578 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-19 17:15:47',4,9,'2025-02-19 17:15:47','457056083600327005012999','Payed (Credit Card ) Ticket ') 19/02/2025 17:16:15.0421 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:18:21.6898 719 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-02-19 17:18:20',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','') 19/02/2025 17:21:22.6302 615 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 17:21:22' where payTraUID = 4830952471112380 and payStatus='V' and payEnabled=1 19/02/2025 17:23:00.6584 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:27:12.0517 586 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2198, trcLastPrinted = '2500402198', trcLastDate = '2025-02-19 17:27:11' where trcStatus='V' and trcTerId = 4 19/02/2025 17:27:29.5563 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:29:38.6197 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 17:29:43.8124 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:30:32.1300 4025 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 17:30: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-02-19 17:30: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'; 19/02/2025 17:33:31.5208 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:33:59.4178 3573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:35:22.2661 684 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-02-19 17:35:21','V',5298229837387730,2025,'2025-02-19 17:35:18','457056331800327005012999',1,2,16,'I','',1,0,1,'','0230003944059',13,0) 19/02/2025 17:36:00.8338 658 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-02-19 17:36:00',0,'V',4992550757437830,5172166554242180,2025,'2025-02-19 17:36:00',18,1,0,4,'2025-02-19 17:51:00','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 19/02/2025 17:40:31.1627 1325 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 17:52:29.1615 1244 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCarId = 103 19/02/2025 17:52:50.7740 1269 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 19/02/2025 17:58:33.0701 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:00:25.5667 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-02-19 18:00:24','V',4832963388819040,2025,'2025-02-19 18:00:23','457056263200327005012999',2,2,2,'O','',0,'2025-02-19 18:00:24',1,'','',0) 19/02/2025 18:01:08.1132 1510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:01:24.7911 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:03:40.7705 1797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:05:08.2982 1484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:05:22.7876 611 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 18:11:38.8829 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:13:15.0878 2083 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:16:32.1179 1007 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 18:18:26.7210 973 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:20:36.3248 537 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-19 18:20:35' where subId = 26 19/02/2025 18:26:18.1266 1156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:27:07.2227 1944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:28:53.4248 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:34:01.7052 556 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 18:38:15.4400 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:38:59.1393 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:39:43.8366 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:43:00.5975 953 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:50:33.6262 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:50:49.8679 1444 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 19/02/2025 18:51:18.7105 1986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:51:49.7628 2212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:52:07.7546 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:52:37.6260 767 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 18:56:14.8036 2372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:57:12.9622 2863 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/02/2025 18:57:51.3373 4046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:58:17.9503 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:58:53.0014 2514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 18:59:32.6398 1373 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:12:38.0546 1161 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/02/2025 19:14:13.0739 522 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 19:14:15.2955 557 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 19:14:55.1100 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:17:02.5683 2459 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-19 19:17:00',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'; 19/02/2025 19:21:03.7804 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:23:12.9308 1771 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 19:24:35.2238 1302 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:25:13.2310 567 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 19:28:49.6060 1075 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:29:36.3304 1591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:29:40.2833 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:32:22.9758 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:32:23.5852 726 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-02-19 19:31:24',9,'V',5677954257798610,4836143422170110,2025,'2025-02-19 19:31:24',4,1,0,4,'2025-02-19 19:46:24','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 19/02/2025 19:32:25.8879 1232 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:34:21.5757 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:34:51.5490 759 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 19/02/2025 19:35:16.5149 1470 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 19:37:31.7492 2303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:37:44.5223 1414 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:37:47.6185 1592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:37:50.1794 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:42:23.2499 638 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 19:45:49.4936 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 19:54:32.4972 3605 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-02-19 19:54:00',1,'V',5392581408431680,5636456970542010,2025,'2025-02-19 19:54:00',17,1,0,4,'2025-02-19 20:09:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 19:54:44.0274 813 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-02-19 19:54:43',0,'V',4654549630281210,4937624849293300,2025,'2025-02-19 19:54:43',18,1,0,4,'2025-02-19 20:09:43','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 19:55:24.4144 684 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 19:55:33.1346 3153 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); 19/02/2025 19:55:35.1671 1356 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 19:55:40.0546 1146 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:02:30.3181 884 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:08:30.4553 1356 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:10:17.4039 577 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 20:11:37.7394 749 ms. EXEC: update payInventory set invCreation = '2025-02-19 20:11:36',invModify = '2025-02-19 20:11:36',invUseId=0,invStatus='V' where invId = 237280 19/02/2025 20:11:51.6684 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:12:13.9564 622 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/02/2025 20:13:59.6841 1602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:17:12.9795 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:19:33.9885 815 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-19 20:19:33' where payTraUID = 4630721358934670 and payStatus='V' and payEnabled=1 19/02/2025 20:20:15.0389 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:21:01.4171 771 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/02/2025 20:21:46.3503 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:23:13.2655 553 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 20:23:12' where traUID = 4640585553937280 and traStatus='V' and traEnabled=1 19/02/2025 20:29:37.9012 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:30:19.2308 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:31:43.7503 1438 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:48:13.7006 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 20:49:46.6042 757 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/02/2025 20:52:37.9439 621 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-02-19 20:52:37','V',4816405960496600,2025,'2025-02-19 20:52:36','457057515600327005012999',1,2,16,'I','',1,0,1,'','',4) 19/02/2025 20:53:18.3888 1103 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 407243 else acvFstPayId end),acvLstPayId = 407243 where acvSftId = 900 and acvCodeId = 3 19/02/2025 20:53:19.1484 573 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5147737653488230,5681987311380280,2025,'2025-02-19 20:53:18',' Data: 2/19/2025 8:52:49 PM Codice: 457057022100327005012999 Ingresso: 2/19/2025 7:30:21 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500601247 ',0) 19/02/2025 20:53:19.8919 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:01:06.8951 820 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 19/02/2025 21:02:35.2323 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:11:36.7116 1667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:13:12.6583 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:15:50.5734 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:17:37.5300 1387 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:18:04.2151 1708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:18:13.6919 1309 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 21:18:33.9824 759 ms. EXEC: update payReceipt set recCreation = '2025-02-19 21:18:33',recModify = '2025-02-19 21:18:33',recUseId=0,recStatus='V' where recId = 353338 19/02/2025 21:20:05.8832 1185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:20:49.1932 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:25:19.1817 1155 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/02/2025 21:31:12.8796 658 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 21:31:25.9500 1114 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:32:38.8590 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:32:46.5976 517 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-19 21:32:45' where traUID = 5425662439263990 and traStatus='V' and traEnabled=1 19/02/2025 21:33:05.0037 1296 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:40:58.3157 1505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:41:17.5185 3607 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 26 ms.) 19/02/2025 21:47:27.0811 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 21:47:56.4782 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 21:51:50.6659 586 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-02-19 21:51:50',0,'V',5130224596444920,4799193859751910,2025,'2025-02-19 21:51:50',18,1,0,4,'2025-02-19 22:06:50','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/02/2025 21:52:13.9316 619 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/02/2025 22:01:38.6532 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:02:57.0923 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:07:13.3148 988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:10:58.7493 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/02/2025 22:12:43.5363 1867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:15:08.4181 1074 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:16:12.1347 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:17:51.7691 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:26:38.4623 590 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 19/02/2025 22:26:38.4633 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:28:37.8628 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:29:58.7097 2712 ms. EXEC: update payReceipt set recCreation = '2025-02-19 22:29:55',recModify = '2025-02-19 22:29:55',recUseId=0,recStatus='V' where recId = 353354 19/02/2025 22:31:03.8403 1228 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:32:05.8507 3544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:32:09.6975 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 22:37:54.6535 779 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/02/2025 22:41:01.7765 760 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4699301957256420,5511928568556620,2025,'2025-02-19 22:41:01','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/19/2025 8:45:34 PM Date : 2/19/2025 10:40:56 PM Code : 457057473400327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 19/02/2025 23:05:54.4723 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:06:40.1560 1203 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:10:03.4626 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:14:32.5773 943 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:15:23.3057 1881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:31:00.2387 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:39:29.8096 1779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:46:31.1039 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:49:39.8541 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/02/2025 23:56:48.5701 518 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2)