08/02/2025 00:00:27.8980 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 00:01:43.1480 732 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 08/02/2025 00:08:33.1587 993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 00:13:19.9860 2355 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 00:22:34.4445 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 00:29:10.3527 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 00:31:04.2848 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 00:34:51.3567 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 00:37:55.1351 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 00:37:55.1762 762 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 00:38:53.9189 705 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 00:38:54.7945 684 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 00:38:53' where traUID = 4623870281523910 and traStatus='V' and traEnabled=1 08/02/2025 00:39:48.4389 608 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 181 ms.) 08/02/2025 00:39:49.3595 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 00:40:16.1476 779 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 00:40:15' where traUID = 4949465266303160 and traStatus='V' and traEnabled=1 08/02/2025 00:50:16.2751 1739 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/02/2025 00:50:23.5981 898 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 00:50:24.1565 550 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456937863000327005012999' 08/02/2025 00:52:56.2395 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 00:53:32.6722 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 00:53:32.8663 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 00:57:04.8659 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 00:58:11.4780 1431 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 01:08:29.6497 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 01:08:32.0233 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 01:10:39.0574 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 01:11:03.0046 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 01:11:16.7139 515 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-08 01:11:16','V',4846110984037780,2025,'2025-02-08 01:11:13','456937806200327005012999',2,2,2,'O','',0,'2025-02-08 01:11:16',1,'','',0) 08/02/2025 01:11:45.4553 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 01:12:00.7107 1140 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 01:11:59' where payTraUID = 5258821822696640 and payStatus='V' and payEnabled=1 08/02/2025 01:17:10.3934 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 01:17:50.5456 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 01:20:51.8494 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 01:23:04.6124 1617 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 08/02/2025 01:30:01.6323 820 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 01:30:18.3827 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 01:30:19.6856 708 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-08 01:30:18','V',4857392046510190,2025,'2025-02-08 01:30:17','456937085100327005012999',2,2,2,'O','',0,'2025-02-08 01:30:18',1,'','',0) 08/02/2025 01:30:20.7563 611 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 01:30:26.5782 1038 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 01:31:02.7157 1494 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-08 01:31:01','V',4992012961358870,2025,'2025-02-08 01:31:00','456936787600327005012999',2,2,2,'O','',0,'2025-02-08 01:31:01',1,'','',0) 08/02/2025 01:31:13.7552 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 01:31:58.3944 540 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 01:31:57' where payTraUID = 5714535479564880 and payStatus='V' and payEnabled=1 08/02/2025 01:41:03.5737 604 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 01:50:14.6230 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 01:53:21.9949 1100 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/02/2025 02:27:07.3439 1265 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 02:27:54.5359 554 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-08 02:27:53',0,2,'2025-02-08 02:27:53','','Unauthorized Transit Exit 1') 08/02/2025 02:28:18.2139 1640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 02:33:28.2249 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 02:37:24.3848 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 02:37:42.1138 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 02:41:05.5296 1008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 02:52:34.6504 740 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 02:56:28.6949 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 03:02:47.3564 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 03:13:56.6107 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 03:14:38.2219 763 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/02/2025 03:14:52.8398 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 03:17:43.1392 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 03:17:56.3541 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 03:32:50.0374 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 03:40:20.6376 1671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 03:47:40.1293 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 03:50:41.4201 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 03:50:52.0863 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 03:51:08.6506 920 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 08/02/2025 03:51:10.4328 989 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5618, trcLastPrinted = '2500705618', trcLastDate = '2025-02-08 03:51:09' where trcStatus='V' and trcTerId = 18 08/02/2025 03:51:12.2440 1144 ms. EXEC: update payReceipt set recCreation = '2025-02-08 03:51:11',recModify = '2025-02-08 03:51:11',recUseId=0,recStatus='V' where recId = 350307 08/02/2025 03:58:45.1808 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 04:23:40.0094 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 04:25:59.7711 1157 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 04:28:32.4745 1338 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 04:36:21.5603 659 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-08 04:36:20','V',4956722249477190,2025,'2025-02-08 04:36:19','456941657900327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 04:37:48.1569 1579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 04:41:10.2618 2300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 04:46:22.0940 1194 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 04:46:20' where traUID = 5080918031628470 and traStatus='V' and traEnabled=1 08/02/2025 04:54:58.1316 1363 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 04:58:49.4132 2270 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 05:02:30.4780 911 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 08/02/2025 05:04:36.9086 521 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/02/2025 05:04:44.7449 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 05:06:11.9580 830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 05:07:25.9411 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 05:22:21.7629 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 05:22:23.3880 593 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-08 05:22:21',0,'V',5574627965601920,4956722249477190,2025,'2025-02-08 05:22:21',3,1,0,4,'2025-02-08 05:37:21','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 08/02/2025 05:22:27.5578 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 05:23:37.9074 730 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/02/2025 05:34:18.6394 664 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/02/2025 05:37:52.6214 2043 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 05:43:03.4829 1276 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 05:43:47.3026 1350 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 05:52:55.6020 620 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 05:53:44.9074 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 06:01:39.9261 644 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 08/02/2025 06:01:54.9773 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 06:02:33.8196 513 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 06:03:39.2970 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 06:15:13.0769 1116 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 06:32:30.8605 1122 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 06:37:31.5882 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 06:38:42.7944 775 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 08/02/2025 07:03:41.0232 1749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:04:32.9624 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:08:07.2806 2535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:10:16.9294 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:10:35.7401 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:11:19.8850 572 ms. OPEN: show columns from tabAbbGroups where Field = 'abgTarId' 08/02/2025 07:11:21.3850 1481 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-08 07:11:19','V',5281783619499610,2025,'2025-02-08 07:11:17','456942587700327005012999',1,2,16,'I','',1,0,1,'','0230003943530',44,0) 08/02/2025 07:12:56.0482 1049 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 07:16:30.6835 637 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/02/2025 07:16:51.6988 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:16:55.7365 1603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:17:18.3488 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:17:27.2318 867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:18:44.5156 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:21:54.7505 535 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/02/2025 07:22:00.9937 1832 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/02/2025 07:27:47.5334 1839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:29:25.9091 3020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:30:51.3870 693 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-08 07:30:47',0,'V',4837034231595270,5544483131816020,2025,'2025-02-08 07:30:47',3,1,0,4,'2025-02-08 07:45:47','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 08/02/2025 07:30:52.7399 550 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 07:30:52',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 07:32:26.2412 955 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 07:32:25' where payTraUID = 5544483131816020 and payStatus='V' and payEnabled=1 08/02/2025 07:32:40.3147 598 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/02/2025 07:35:09.2376 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:35:09.2686 519 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/02/2025 07:38:21.0115 1283 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:41:19.1071 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:46:31.9251 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:47:56.6625 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:48:35.1596 681 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 07:49:04.0682 1312 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 07:51:35.9300 521 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-08 07:51:35','V',4757918216300400,2025,'2025-02-08 07:51:35','456942829500327005012999',1,2,16,'I','',1,0,1,'','0230004098567',165,0) 08/02/2025 07:51:40.9254 931 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/02/2025 07:53:03.8306 886 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:01:40.3864 684 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5107195235819500,5170969456711530,2025,'2025-02-08 08:01:39','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/8/2025 7:29:21 AM Date : 2/8/2025 8:01:38 AM Code : 456942696100327005012999 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) 08/02/2025 08:03:02.0648 1495 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 08:04:16.5282 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:05:11.0001 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:05:22.8101 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:06:18.7150 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:11:52.1608 550 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/02/2025 08:14:24.9403 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:15:06.2053 1463 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:20:48.2489 3107 ms. EXEC: update payCurInventory set curQuantity=0,curAmount=0 where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 08/02/2025 08:20:48.8804 631 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,0,100,-42,-4200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,0,100,42,4200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,0,200,-16,-3200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,0,200,16,3200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:20:29',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 08/02/2025 08:24:39.4195 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:24:51.3756 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:26:45.5189 692 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:26:41',5,3,42101,0,50,6,300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+6,5),curAmount=round(curAmount+300,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:26:41',5,3,42101,0,200,2,400,1,'I','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'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-08 08:26:41',5,3,42101,0,100,13,1300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+13,5),curAmount=round(curAmount+1300,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 08/02/2025 08:27:04.7109 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:27:52.8305 646 ms. EXEC: update payInventory set invCreation = '2025-02-08 08:27:52',invModify = '2025-02-08 08:27:52',invUseId=0,invStatus='V' where invId = 235705 08/02/2025 08:27:53.2988 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:32:56.9975 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:33:15.5491 873 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:35:24.9327 654 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 08:35:38.2328 866 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-08 08:35:37','V',5010500367522190,2025,'2025-02-08 08:35:35','456943093500327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 08:38:25.8893 535 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 08/02/2025 08:38:27.6265 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:39:01.9417 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:42:47.6826 706 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 08:47:14.8326 1280 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:47:46.5080 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:48:18.1295 3266 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:48:41.1821 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 08:53:32.4864 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 08:53:32.7366 648 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 09:02:38.2391 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:02:49.9230 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:08:41.3950 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:09:46.4261 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:12:19.0034 1982 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-08 09:12:17',0,0,'V',5323445866230090,5584325027735130,2025,'2025-02-08 09:12:17',3,'KES',1,100,100,'N',''); 08/02/2025 09:13:50.8416 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 09:14:36.4976 572 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-08 09:14:35','V',5697208930879800,2025,'2025-02-08 09:14:34','456942983600327005012999',2,2,2,'O','',0,'2025-02-08 09:14:35',1,'','',0) 08/02/2025 09:14:45.5627 4743 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/02/2025 09:15:20.9797 526 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 09:15:24.3670 883 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 09:18:10.6796 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 09:23:40.3579 1240 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5631, trcLastPrinted = '2500705631', trcLastDate = '2025-02-08 09:23:39' where trcStatus='V' and trcTerId = 18 08/02/2025 09:26:01.9388 631 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-08 09:25:12',1,'V',5244824964524560,4685531579375730,2025,'2025-02-08 09:25:12',4,1,0,4,'2025-02-08 09:40:12','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/02/2025 09:29:01.6586 739 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-08 09:29:00','V',5734045664004650,2025,'2025-02-08 09:28:59','456943213300327005012999',2,2,2,'O','',0,'2025-02-08 09:29:00',1,'','',0) 08/02/2025 09:32:11.7203 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:34:26.6667 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:35:31.5707 1234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:37:09.4650 822 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403734 else acvFstPayId end),acvLstPayId = 403734 where acvSftId = 889 and acvCodeId = 3 08/02/2025 09:37:34.4379 2300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:37:53.2466 657 ms. EXEC: update payReceipt set recCreation = '2025-02-08 09:37:52',recModify = '2025-02-08 09:37:52',recUseId=0,recStatus='V' where recId = 350344 08/02/2025 09:38:12.2725 984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:42:08.6826 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:42:17.3025 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:42:41.7420 1676 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 09:42:39',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/02/2025 09:43:44.3354 1138 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 09:43:42',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 09:43:44.9208 585 ms. EXEC: update payInventory set invCreation = '2025-02-08 09:43:44',invModify = '2025-02-08 09:43:44',invUseId=0,invStatus='V' where invId = 235720 08/02/2025 09:43:48.9826 2569 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/02/2025 09:43:58.7832 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:46:34.2275 577 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-08 09:45:43',1,'V',5054775700060090,5481202546903300,2025,'2025-02-08 09:45:43',4,1,0,4,'2025-02-08 10:00:43','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/02/2025 09:46:44.7676 796 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 09:46:43' where payTraUID = 4882756759628580 and payStatus='V' and payEnabled=1 08/02/2025 09:46:51.2670 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 09:48:49.8494 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 09:48:54.5806 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:48:59.7641 767 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 09:51:24.2079 689 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 09:51:35.8478 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:54:36.7794 1254 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:54:53.8879 961 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 09:54:52' where payTraUID = 5762045080005220 and payStatus='V' and payEnabled=1 08/02/2025 09:56:46.4592 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 09:58:47.9345 707 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/02/2025 10:02:27.8324 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:02:33.2281 1019 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-08 09:02:32') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-08 10:02:32' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-08 10:02:32' and (resAreId = 1 or resAreId <= 0) nr: 0 08/02/2025 10:02:33.2301 939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:02:39.0860 546 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 10:04:33.4745 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 10:04:45.3636 719 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 10:04:46.1781 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:08:36.6152 1279 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 10:15:56.4781 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 10:16:09.2388 1419 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/02/2025 10:17:29.1809 2045 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:20:10.6473 1918 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:25:52.7280 586 ms. OPEN: select * from opeShifts where sftId = 896 and sftStatus = 'V' 08/02/2025 10:25:55.3538 765 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 08/02/2025 10:27:28.2597 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:28:02.9712 1138 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 10:29:24.3193 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:33:06.1556 1447 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 10:34:31.3263 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 10:35:50.1106 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 10:38:08.8316 611 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1750, trcLastPrinted = '2500401750', trcLastDate = '2025-02-08 10:38:08' where trcStatus='V' and trcTerId = 4 08/02/2025 10:38:43.1078 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:41:47.1034 3973 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 10:42:40.3175 1477 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:43:09.7504 2018 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 10:43:44.1317 1054 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:45:15.6167 2461 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 10:47:03.2576 505 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 10:48:02.0804 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 10:51:27.3044 523 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 08/02/2025 10:52:18.2750 600 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-08 10:52:17','V',5739397719395100,2025,'2025-02-08 10:52:17','456943913700327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 10:52:18.8724 554 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 10:54:40.6424 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 10:55:09.9693 883 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 10:59:55.8689 1399 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403767 else acvFstPayId end),acvLstPayId = 403767 where acvSftId = 897 and acvCodeId = 3 08/02/2025 11:01:06.4757 2090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:01:06.8990 2731 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 11:01:04',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-08 11:01:04',3,42101,0,100,-4,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 11:02:25.2721 581 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 11:02:58.4396 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:03:20.0282 2571 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-08 11:03:17',0,'V',5697718762793350,5743877442604570,2025,'2025-02-08 11:03:17',18,1,0,4,'2025-02-08 11:18:17','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/02/2025 11:05:22.8724 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:07:32.9405 1981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:08:14.3555 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:11:10.7470 1151 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:11:10.7480 605 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/02/2025 11:11:12.7994 1876 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-08 11:11:10' where subId = 16 08/02/2025 11:11:31.3910 3077 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:15:34.5637 1075 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:16:39.0884 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:16:50.8444 513 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 11:16:53.3931 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:17:09.4310 1104 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:17:24.1409 1200 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-08 11:17:22',0,'V',4631071762841780,5361042311877450,2025,'2025-02-08 11:17:22',18,1,0,4,'2025-02-08 11:32:22','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 08/02/2025 11:17:25.9211 1004 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:18:08.0857 1153 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:18:18.7790 647 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5646, trcLastPrinted = '2500705646', trcLastDate = '2025-02-08 11:18:18' where trcStatus='V' and trcTerId = 18 08/02/2025 11:19:16.4330 1111 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 11:21:00.4725 807 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/02/2025 11:22:55.2892 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:23:32.4804 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:24:09.4315 1513 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 11:24:07' where traUID = 5000102079463520 and traStatus='V' and traEnabled=1 (WAIT TIME 7 ms.) 08/02/2025 11:24:52.1324 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:32:34.7737 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:34:56.0134 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:35:45.7051 602 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 11:35:53.4703 757 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 11:35:59.0581 659 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/02/2025 11:36:28.1858 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:36:39.1803 833 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 11:37:15.8221 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:43:23.5452 708 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:46:03.1623 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:47:29.0625 1290 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/02/2025 11:47:39.3124 762 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-08 11:47:38',4,6,'2025-02-08 11:47:38','456944118800327005012999','Payed (Credit Card ) Ticket ') 08/02/2025 11:49:15.2504 668 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 11:49:14' where traUID = 5752425010246670 and traStatus='V' and traEnabled=1 08/02/2025 11:49:42.7640 1264 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:51:58.5160 977 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:52:46.7927 554 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-08 11:52:35',12,'V',5171950336155610,5123914321537050,2025,'2025-02-08 11:52:35',17,1,0,4,'2025-02-08 12:07:35','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/02/2025 11:52:46.8938 515 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 08/02/2025 11:53:27.1470 952 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-08 11:53:26','V',5582820904789030,2025,'2025-02-08 11:53:25','456944280500327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 11:54:19.2953 641 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1758, trcLastPrinted = '2500401758', trcLastDate = '2025-02-08 11:54:18' where trcStatus='V' and trcTerId = 4 08/02/2025 11:54:26.8865 668 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 11:54:32.9086 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 11:55:01.5390 2055 ms. OPEN: select last_insert_id() as vLast 08/02/2025 11:55:08.2035 803 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 11:56:01.3335 629 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-08 11:56:00',0,'V',5041889797565010,5052065807878220,2025,'2025-02-08 11:56:00',18,1,0,4,'2025-02-08 12:11:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/02/2025 11:56:07.7148 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 11:57:17.6041 700 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-08 11:57:16',0,'V',5132672541810070,4843942738629600,2025,'2025-02-08 11:57:16',2,1,0,-1,'2025-02-08 12:57:16','S','KES',0,0,0,'','','',3,0,0) 08/02/2025 11:57:21.1155 1009 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 08/02/2025 11:58:57.5128 617 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/02/2025 12:01:32.6919 1349 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 12:01:30',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-08 12:01:31',3,42101,0,100,-2,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 12:01:31',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 08/02/2025 12:05:00.0564 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:05:00.5817 890 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/02/2025 12:05:48.7283 537 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 08/02/2025 12:06:51.1406 1498 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:07:16.0295 807 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456944186600327005012999' 08/02/2025 12:07:54.5355 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:08:08.3449 2070 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-08 12:08:06',0,'V',4909106676826500,5315372685330780,2025,'2025-02-08 12:08:06',2,1,0,-1,'2025-02-08 13:08:06','S','KES',0,0,0,'','','',3,0,0) 08/02/2025 12:08:55.9661 709 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 12:08:56.5225 1337 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 12:08:54',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-08 12:08:54',3,42101,0,100,-4,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 12:09:30.6607 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:09:34.5883 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:14:26.7302 834 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403813 else acvFstPayId end),acvLstPayId = 403813 where acvSftId = 894 and acvCodeId = 3 08/02/2025 12:15:44.2047 613 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 12:15:43',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/02/2025 12:19:09.9630 515 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 08/02/2025 12:19:16.4975 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 08/02/2025 12:21:37.8222 2621 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-08 12:21:35',0,'V',5251406027039200,5364623181587400,2025,'2025-02-08 12:21:35',18,1,0,4,'2025-02-08 12:36:35','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/02/2025 12:21:39.7985 993 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 12:22:20.8773 521 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 12:22:29.0449 822 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 12:22:42.6231 922 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-08 12:22:41','0230004100967',0,0,5195791905213210,12,'0000-00-00 00:00:00','0000-00-00 00:00:00') 08/02/2025 12:22:43.7598 811 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 12:22:46.0064 2244 ms. EXEC: update abbCards set carLastDate = '2025-02-08 12:22:43',carLastDirection='O' where carStatus='V' and carId = 12 08/02/2025 12:22:46.1345 595 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-08 12:22:45','V',4979890292767280,2025,'2025-02-08 12:22:43','456944456300327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 12:22:46.9300 691 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 12:22:46' where payTraUID = 4825318073085070 and payStatus='V' and payEnabled=1 08/02/2025 12:22:50.7696 512 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 12:23:10.5280 1498 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 08/02/2025 12:23:23.6228 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:26:29.8890 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:28:22.9076 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:31:14.0995 808 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-08 12:31:13','V',4646989273855290,2025,'2025-02-08 12:31:12','456944507200327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 12:32:09.6191 699 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 12:35:03.2888 597 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4735100720800840,5613990724064160,2025,'2025-02-08 12:35:02',' Date: 2/8/2025 12:34:08 PM Code: 456944371500327005012999 Entry Date: 2/8/2025 12:08:35 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500401766 ',0) 08/02/2025 12:35:40.8002 2315 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:35:48.1141 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:36:01.5722 1233 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 12:36:16.5764 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:38:33.2190 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:38:53.4827 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:40:03.2139 719 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 12:40:07.8631 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:41:38.9257 708 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 12:41:48.4362 782 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-08 12:41:47','V',5242190186050470,2025,'2025-02-08 12:41:46','456944103700327001012999',2,2,2,'O','',0,'2025-02-08 12:41:47',1,'','',0) 08/02/2025 12:41:49.6330 655 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 12:41:48' where traUID = 4875549339246140 and traStatus='V' and traEnabled=1 08/02/2025 12:43:49.8684 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:45:24.4815 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:46:13.6158 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:46:16.5328 732 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 12:46:16.5338 732 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/02/2025 12:46:20.7846 4005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:46:20.7856 3085 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/02/2025 12:46:25.8521 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:50:10.7914 2890 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 12:50:07',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/02/2025 12:53:59.2472 1192 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 12:54:13.3117 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 12:54:17.6577 645 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 12:55:25.2905 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 12:56:15.9238 692 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 08/02/2025 12:56:53.7304 751 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-08 12:56:52','V',4989209306175250,2025,'2025-02-08 12:56:52','456944661200327001012999',1,2,1,'I','',1,0,1,'','',4) 08/02/2025 12:57:35.7518 701 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 12:57:34',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 12:57:38.1475 1739 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 08/02/2025 12:58:19.3153 634 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 12:58:18',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 12:59:05.8278 666 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 12:59:12.9447 2261 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-08 12:59:10','V',5206637331761440,2025,'2025-02-08 12:59:09','456944411800327005012999',2,2,2,'O','',0,'2025-02-08 12:59:10',1,'','',0) 08/02/2025 12:59:14.8019 1662 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 13:01:21.5378 610 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-08 13:01:20','V',5714809922356710,2025,'2025-02-08 13:01:19','456944370300327005012999',2,2,2,'O','',0,'2025-02-08 13:01:20',1,'','',0) 08/02/2025 13:01:27.2316 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:04:40.2093 2066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:05:26.7839 3243 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:06:50.5396 1723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:07:00.4423 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:07:34.4213 1960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:07:45.0465 689 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:08:15.1089 694 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 08/02/2025 13:08:31.0117 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-08 13:08:30',0,'V',4930332308489590,4979890292767280,2025,'2025-02-08 13:08:30',18,1,0,4,'2025-02-08 13:23:30','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/02/2025 13:08:35.5958 4415 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4979890292767280,4930332308489590,2025,'2025-02-08 13:08:31',' Date: 2/8/2025 1:08:30 PM Code: 456944456300327005012999 Entry Date: 2/8/2025 12:22:43 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 # 2500705673 ',0) 08/02/2025 13:11:36.9486 1183 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 13:11:35',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-08 13:11:35',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 13:11:37.6571 707 ms. EXEC: update payInventory set invCreation = '2025-02-08 13:11:36',invModify = '2025-02-08 13:11:36',invUseId=0,invStatus='V' where invId = 235779 08/02/2025 13:12:13.5664 750 ms. EXEC: update paycash set casCreation = '2025-02-08 13:12:12',casModify = '2025-02-08 13:12:12',casUseId=0,casStatus='V' where casId = 208674 08/02/2025 13:12:15.3616 1795 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 13:12:12',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 13:12:15.9550 592 ms. EXEC: update payInventory set invCreation = '2025-02-08 13:12:15',invModify = '2025-02-08 13:12:15',invUseId=0,invStatus='V' where invId = 235780 08/02/2025 13:14:09.5940 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:14:15.5770 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:14:21.1528 1031 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 13:14:21.8683 712 ms. EXEC: update abbCards set carLastDate = '2025-02-08 13:14:21',carLastDirection='I' where carStatus='V' and carId = 13 08/02/2025 13:14:23.3733 693 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 13:15:59.6525 537 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-08 13:15:59','V',4767357927053950,2025,'2025-02-08 13:15:58','456944775800327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 13:16:37.2970 668 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 13:16:38.0175 589 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 13:16:37' where payTraUID = 4888777536117040 and payStatus='V' and payEnabled=1 08/02/2025 13:16:38.5769 558 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 13:16:37' where traUID = 4888777536117040 and traStatus='V' and traEnabled=1 08/02/2025 13:17:16.2825 792 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 18 and payDateTime = '2025-02-08 13:17:15' nr: 0 08/02/2025 13:18:49.0453 1062 ms. OPEN: show columns from tmpPay where Field = 'tmpInvoice' 08/02/2025 13:18:51.6010 942 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/02/2025 13:18:58.6788 1068 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-08 13:18:57','V',4882261221631060,2025,'2025-02-08 13:18:55','456944522200327001012999',2,2,2,'O','',0,'2025-02-08 13:18:57',1,'','',0) 08/02/2025 13:19:03.0448 1151 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:19:36.2473 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:19:43.5382 667 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403865 else acvFstPayId end),acvLstPayId = 403865 where acvSftId = 894 and acvCodeId = 3 (WAIT TIME 11 ms.) 08/02/2025 13:19:54.5637 1861 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 13:20:09.2296 700 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-08 13:20:08','V',5035351907807730,2025,'2025-02-08 13:20:05','456944800500327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 13:20:10.8907 1519 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 13:20:17.7434 559 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-08 13:20:17' where subId = 14 08/02/2025 13:20:41.0511 853 ms. OPEN: select * from tabTerminal where terId = 2 08/02/2025 13:20:47.9618 2641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:22:26.4876 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:22:37.3279 666 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 13:22:36' where traUID = 5455529497940670 and traStatus='V' and traEnabled=1 08/02/2025 13:23:24.5269 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:23:54.8224 696 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 13:27:34.0682 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:27:45.2147 1217 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 13:29:48.0339 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:30:42.3057 866 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5680, trcLastPrinted = '2500705680', trcLastDate = '2025-02-08 13:30:41' where trcStatus='V' and trcTerId = 18 08/02/2025 13:31:17.0569 582 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 13:33:44.5037 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:33:58.0459 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:35:58.2783 1389 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/02/2025 13:36:15.4300 747 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:38:24.7405 977 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-08 13:38:23','V',5277783939221360,2025,'2025-02-08 13:38:23','456944670700327005012999',2,2,2,'O','',0,'2025-02-08 13:38:23',1,'','',0) 08/02/2025 13:38:32.0075 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:39:28.9871 550 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 13:39:28' where traUID = 4890734078444430 and traStatus='V' and traEnabled=1 08/02/2025 13:39:30.4731 1485 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 08/02/2025 13:39:57.3663 830 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/02/2025 13:41:15.3441 1088 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 08/02/2025 13:41:15.8254 1062 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 13:41:41.8140 1322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:41:48.8938 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:42:29.0680 1675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:43:32.4400 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 13:44:56.1957 1561 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 13:45:08.2228 1445 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 86 ms.) 08/02/2025 13:46:09.1131 977 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-08 13:46:08','V',4986826652820150,2025,'2025-02-08 13:46:07','456944956700327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 13:48:01.8134 600 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/02/2025 13:48:24.8720 598 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 13:48:45.8172 1730 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-08 13:48:44','V',4680318433005690,2025,'2025-02-08 13:48:43','456944972300327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 13:49:58.4544 561 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 13:49:57' where traUID = 5259221812621650 and traStatus='V' and traEnabled=1 08/02/2025 13:50:29.8807 588 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 08/02/2025 13:50:30.9074 539 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/02/2025 13:50:31.3847 856 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:51:37.0382 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 13:52:25.5901 1332 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/02/2025 13:56:03.6318 1432 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 14:01:19.8763 843 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 08/02/2025 14:02:49.2061 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:02:49.2131 582 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 08/02/2025 14:03:40.3037 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:05:04.0885 1082 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-08 14:05:03','V',5459702217295720,2025,'2025-02-08 14:05:02','456945070200327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 14:05:25.3269 1215 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:05:53.9973 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:07:49.8608 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:09:07.6855 586 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 14:09:06',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 14:10:04.7401 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:10:21.3184 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:12:40.8509 668 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 14:12:48.4210 1059 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:13:05.9629 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:16:20.1104 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:17:17.0356 531 ms. EXEC: update payReceipt set recCreation = '2025-02-08 14:17:16',recModify = '2025-02-08 14:17:16',recUseId=0,recStatus='V' where recId = 350492 08/02/2025 14:17:34.9097 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:20:48.5359 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:21:04.3436 539 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/02/2025 14:22:28.7308 633 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 08/02/2025 14:24:12.9253 1735 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 08/02/2025 14:27:44.7278 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:28:50.3292 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:29:38.7250 551 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-08 14:29:38' where subId = 43 08/02/2025 14:29:42.8628 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:29:43.1680 751 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/02/2025 14:29:47.3809 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:30:40.9982 742 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 14:33:32.7455 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:35:16.4027 905 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:36:37.8059 1047 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:37:18.2613 795 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 14:37:24.5896 786 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/02/2025 14:37:34.1100 552 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-08 14:37:33','V',5369490422284380,2025,'2025-02-08 14:37:32','456945060000327005012999',2,2,2,'O','',0,'2025-02-08 14:37:33',1,'','',0) 08/02/2025 14:37:52.1072 673 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-08 14:37:51',0,16,'2025-02-08 14:37:51','','Unauthorized Transit Entry 2') 08/02/2025 14:39:33.5824 608 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-08 14:39:32','V',5252575069174610,2025,'2025-02-08 14:39:31','456944861000327001012999',2,2,2,'O','',0,'2025-02-08 14:39:32',1,'','',0) 08/02/2025 14:39:34.3039 669 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 14:39:39.8587 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:40:41.8247 693 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 14:42:19.4338 563 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/02/2025 14:42:33.7315 1047 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:43:02.8572 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:43:03.2074 553 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTariffTerminal' nr: 1 08/02/2025 14:43:30.2507 616 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-08 14:43:29' where subId = 158 08/02/2025 14:44:07.6921 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:44:39.8189 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:47:34.6583 713 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 08/02/2025 14:50:16.8161 927 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:53:26.1804 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 08/02/2025 14:53:26.5246 729 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:54:51.8654 632 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 14:54:51' where payTraUID = 4867538861937850 and payStatus='V' and payEnabled=1 08/02/2025 14:54:56.3445 1295 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:56:22.5969 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 14:57:36.6070 535 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 14:59:02.9105 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 14:59:42.8805 1163 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 14:59:45.4183 2298 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 15:04:22.0566 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:05:48.0709 532 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/02/2025 15:06:13.9114 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 15:07:20.5015 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 15:07:41.4567 548 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-08 15:07:39',0,'V',5576994473292860,5342875451245100,2025,'2025-02-08 15:07:39',3,1,0,4,'2025-02-08 15:22:39','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 08/02/2025 15:08:42.5631 1463 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 15:08:40',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 15:10:05.0590 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:12:31.5932 624 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/02/2025 15:15:24.6354 674 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:15:26.5027 1013 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 15:15:25',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/02/2025 15:15:27.0431 534 ms. EXEC: update payInventory set invCreation = '2025-02-08 15:15:26',invModify = '2025-02-08 15:15:26',invUseId=0,invStatus='V' where invId = 235800 08/02/2025 15:18:55.8945 1040 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 15:22:57.9235 845 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:24:11.0700 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 15:26:11.6006 783 ms. EXEC: update payReceipt set recCreation = '2025-02-08 15:26:10',recModify = '2025-02-08 15:26:10',recUseId=0,recStatus='V' where recId = 350531 08/02/2025 15:26:12.2481 643 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-08 15:26:11',0,0,'V',5258994303617640,5084444470275440,2025,'2025-02-08 15:26:11',3,'KES',1,50,50,'N',''); 08/02/2025 15:27:30.2629 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:27:31.4037 577 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 15:28:17.9592 709 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 15:28:25.5013 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:31:23.2627 517 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 15:31:41.0028 779 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-08 15:31:40','V',5598343672319130,2025,'2025-02-08 15:31:39','456945300400327005012999',2,2,2,'O','',0,'2025-02-08 15:31:40',1,'','',0) 08/02/2025 15:31:42.0224 825 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 15:31:46.6986 591 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); 08/02/2025 15:32:10.3646 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:32:44.3487 913 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 15:32:43' where traUID = 4661083898373180 and traStatus='V' and traEnabled=1 08/02/2025 15:33:27.7951 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:33:40.8910 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 15:34:55.1673 1313 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 15:35:34.2898 506 ms. OPEN: show columns from movAnomaly where Field = 'anmAmountProgressive' 08/02/2025 15:36:11.9783 1143 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 08/02/2025 15:36:12.0453 1291 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 15:39:04.9435 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 15:41:22.2885 596 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 15:41:35.9918 654 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-08 15:41:35','V',4848596995520890,2025,'2025-02-08 15:41:32','456945649200327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 15:42:44.7593 776 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/02/2025 15:43:01.0244 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:45:49.9044 1026 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 15 08/02/2025 15:46:07.1460 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 15:47:58.3293 521 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 15:48:08.3871 1255 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:51:07.0751 640 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 08/02/2025 15:52:08.2245 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:53:44.2674 588 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 15:53:47.9839 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:56:14.7380 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 15:58:10.9475 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:02:06.3775 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 16:06:14.6561 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:06:55.6457 727 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-08 16:06:54','V',5114174825559640,2025,'2025-02-08 16:06:54','456945801400327001012999',1,2,1,'I','',1,0,1,'','',4) 08/02/2025 16:08:27.8409 1438 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5727, trcLastPrinted = '2500705727', trcLastDate = '2025-02-08 16:08:26' where trcStatus='V' and trcTerId = 18 08/02/2025 16:08:59.4021 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:12:59.2579 703 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 16:13:11.9654 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:13:28.5736 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 16:19:17.5591 2481 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 16:19:22.6175 1080 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-08 16:19:21','V',5675263961990960,2025,'2025-02-08 16:19:18','456945504500327005012999',2,2,2,'O','',0,'2025-02-08 16:19:21',1,'','',0) 08/02/2025 16:19:26.5171 514 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5358882686599080,5285095157682930,2025,'2025-02-08 16:19:26',' Date: 2/8/2025 4:19:25 PM Code: 456944949400327005012999 Entry Date: 2/8/2025 1:44:54 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500705728 ',0) 08/02/2025 16:22:40.4309 631 ms. EXEC: update payReceipt set recCreation = '2025-02-08 16:22:39',recModify = '2025-02-08 16:22:39',recUseId=0,recStatus='V' where recId = 350561 08/02/2025 16:23:59.3429 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:24:46.9286 1118 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 16:26:11.4538 848 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 16:27:18.6345 1312 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 16:27:21.5525 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:28:34.4509 2179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:29:33.8404 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:29:55.0686 1220 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-08 16:29:53',0,'V',5471376237514850,4948577390769520,2025,'2025-02-08 16:29:53',18,1,0,4,'2025-02-08 16:44:53','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/02/2025 16:30:18.0528 874 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 16:30:16',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 16:32:28.9040 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:33:33.8673 506 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 16:36:14.3836 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 16:41:56.6884 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 16:43:41.2473 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:44:36.1730 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 16:46:31.9875 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:51:39.1545 737 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-08 16:51:38','V',5097996717167100,2025,'2025-02-08 16:51:37','456945753900327001012999',2,2,2,'O','',0,'2025-02-08 16:51:38',1,'','',0) 08/02/2025 16:51:39.7849 517 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 16:54:45.1537 558 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-08 16:54:43',0,'V',5261460234563650,5185274533153690,2025,'2025-02-08 16:54:43',3,1,0,4,'2025-02-08 17:09:43','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 08/02/2025 16:54:46.1523 641 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 16:54:45',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 16:57:50.7596 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 16:58:27.0659 976 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5739, trcLastPrinted = '2500705739', trcLastDate = '2025-02-08 16:58:26' where trcStatus='V' and trcTerId = 18 08/02/2025 17:02:38.9305 794 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 17:03:31.7690 893 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 17:05:01.4391 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 17:06:32.8772 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:08:02.4119 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:09:23.0919 588 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-08 17:09:22','V',5756813013846950,2025,'2025-02-08 17:09:20','456945164200327005012999',2,2,2,'O','',0,'2025-02-08 17:09:22',1,'','0230003944059',13,0) 08/02/2025 17:10:52.1323 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 17:10:52.7538 571 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 17:11:03.9082 537 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 17:11:03' where payTraUID = 5154765130626380 and payStatus='V' and payEnabled=1 08/02/2025 17:13:23.7237 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:15:54.3767 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 17:18:36.0012 1567 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/02/2025 17:18:36.6416 594 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4631383702781120,5583614540943440,2025,'2025-02-08 17:18:36','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/8/2025 5:00:35 PM Date : 2/8/2025 5:18:33 PM Code : 456946123500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 08/02/2025 17:18:38.2137 1137 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 17:18:36',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/02/2025 17:18:59.2848 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:21:08.3856 1672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:23:31.7806 566 ms. OPEN: select * from tabTerminal where terId = 2 08/02/2025 17:23:35.9914 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 17:27:17.8966 655 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 17:28:15.4602 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 2 ms.) 08/02/2025 17:28:58.1248 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:30:05.9894 1586 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 17:33:07.5931 502 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 08/02/2025 17:33:15.4113 564 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 17:33:18.7105 518 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 17:35:16.9595 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 17:35:22.2471 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:35:32.2127 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:36:13.2882 1082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:36:56.7373 1025 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-08 17:36:54',0,'V',5719654717166770,4816113283674680,2025,'2025-02-08 17:36:54',3,1,0,4,'2025-02-08 17:51:54','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0) 08/02/2025 17:36:58.4905 995 ms. EXEC: update payInventory set invCreation = '2025-02-08 17:36:57',invModify = '2025-02-08 17:36:57',invUseId=0,invStatus='V' where invId = 235831 08/02/2025 17:37:00.3667 1834 ms. EXEC: update paycash set casCreation = '2025-02-08 17:36:58',casModify = '2025-02-08 17:36:58',casUseId=0,casStatus='V' where casId = 208726 08/02/2025 17:37:00.3727 1341 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:37:23.8014 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:38:00.1297 723 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 17:37:59' where traUID = 5007691372368010 and traStatus='V' and traEnabled=1 08/02/2025 17:38:07.4206 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:40:48.3776 1431 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 17:42:00.7902 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 17:42:09.8643 883 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 17:42:32.6345 979 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-08 17:42:31','V',5052104847780690,2025,'2025-02-08 17:42:29','456946374900327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 17:42:33.4351 736 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 17:50:36.4245 525 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-08 17:50:35','V',4869342953068100,2025,'2025-02-08 17:50:34','456946423400327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 17:50:37.7434 645 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 17:53:53.7811 595 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-08 17:53:53',0,'V',5314020274516940,4666085704884580,2025,'2025-02-08 17:53:53',18,1,0,4,'2025-02-08 18:08:53','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/02/2025 17:54:00.9969 671 ms. EXEC: update payReceipt set recCreation = '2025-02-08 17:54:00',recModify = '2025-02-08 17:54:00',recUseId=0,recStatus='V' where recId = 350597 08/02/2025 17:55:00.1144 794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 17:55:00.6898 507 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 17:55:03.1794 1112 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 08/02/2025 17:55:31.0681 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 18:06:16.1245 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:12:34.9748 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 18:14:42.9346 1894 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4869342953068100,4854512585668120,2025,'2025-02-08 18:14:41','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/8/2025 5:50:34 PM Date : 2/8/2025 6:14:38 PM Code : 456946423400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 08/02/2025 18:14:44.9039 879 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 18:14:43',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/02/2025 18:16:00.1042 1456 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:16:19.4662 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 18:17:02.0456 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:17:32.3409 569 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-08 18:17:31','V',5162235315609530,2025,'2025-02-08 18:17:31','456946585100327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 18:17:33.1645 814 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 18:22:46.4035 1329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:23:44.9178 584 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 08/02/2025 18:25:38.9332 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:27:59.0669 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:28:12.8141 607 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 18:28:14.1580 2172 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:31:16.7554 1070 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-08 18:31:15',0,'V',4659345171833120,5052104847780690,2025,'2025-02-08 18:31:15',18,1,0,4,'2025-02-08 18:46:15','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 08/02/2025 18:36:25.6864 1372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:40:31.1037 592 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 18:46:35.5675 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:47:31.3088 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:49:07.5374 529 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 18:49:07' where payTraUID = 5162235315609530 and payStatus='V' and payEnabled=1 08/02/2025 18:49:13.9757 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 18:51:22.3770 551 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-08 18:51:21',0,2,'2025-02-08 18:51:21','','Unauthorized Transit Exit 1') 08/02/2025 18:52:41.4631 508 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-08 18:52:40',0,0,'V',4824710477890420,5086177263766650,2025,'2025-02-08 18:52:40',3,'KES',1,50,50,'N',''); 08/02/2025 18:53:27.1348 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:55:19.2620 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:56:56.4480 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 18:56:56.9794 1324 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 18:57:21.5358 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:04:05.9047 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:14:34.0572 875 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 6 ms.) 08/02/2025 19:24:27.7661 1580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:29:12.2046 813 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 19:34:33.8976 749 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 08/02/2025 19:35:28.1399 678 ms. OPEN: select * from movtransit where traCode = '456945537300327005012999' and traStatus='V' ORDER BY traId DESC 08/02/2025 19:37:04.0162 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 19:38:08.4394 803 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 19:38:07',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-08 19:38:07',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 19:38:56.1364 787 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 19:42:41.0091 749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 19:44:21.9708 1175 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 19:46:26.8064 2228 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 08/02/2025 19:48:17.2373 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 19:48:22.3747 1231 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:48:27.2370 972 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:50:28.2821 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:50:59.7863 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:53:25.3748 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:55:21.1410 715 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 19:57:04.5892 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 19:57:08.0755 2767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:58:10.7765 1251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:58:52.4244 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 19:59:13.7557 510 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 08/02/2025 19:59:14.9435 887 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 19:59:47.9166 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 19:59:53.6104 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 20:00:27.1019 1140 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4946080842613650,5377779837813150,2025,'2025-02-08 20:00:25','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/8/2025 7:13:32 PM Date : 2/8/2025 8:00:25 PM Code : 456946921200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 08/02/2025 20:04:59.2483 750 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 08/02/2025 20:05:39.4322 659 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 08/02/2025 20:05:39.4753 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 20:05:55.1137 1191 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 08/02/2025 20:05:55.9273 809 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 08/02/2025 20:05:57.3682 1040 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 20:06:13.5891 616 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 20:06:12' where traUID = 4678999605833200 and traStatus='V' and traEnabled=1 08/02/2025 20:06:35.0015 907 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 20:08:07.4294 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 20:14:01.0164 2283 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 20:14:35.1743 824 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-08 20:14:34',0,2,'2025-02-08 20:14:34','','Manual Open Barrier Exit 1') 08/02/2025 20:16:02.6819 649 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 08/02/2025 20:16:25.3730 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 20:20:01.5673 1247 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 20:20:00',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/02/2025 20:21:44.7954 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 20:22:19.1104 755 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-08 20:22:18',0,'V',5602008787495800,5152068754180860,2025,'2025-02-08 20:22:18',18,1,0,4,'2025-02-08 20:37:18','C','KES',500,500,0,'','','',1,500,0,0,'',0,0) 08/02/2025 20:23:22.5418 1073 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 20:24:43.4430 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 20:25:36.1202 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 20:26:36.3035 1862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 20:28:40.3906 632 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-08 20:28:39','V',4735169138393350,2025,'2025-02-08 20:28:39','456947371900327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 20:30:09.9426 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 20:40:42.6842 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 20:42:34.9263 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 20:43:49.8725 583 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 20:44:16.2038 520 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 20:44:35.4327 534 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-08 20:44:34',0,'V',5314704203985040,5190786039761750,2025,'2025-02-08 20:44:34',18,1,0,4,'2025-02-08 20:59:34','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/02/2025 21:00:22.2583 1472 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:00:32.1139 1797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:00:56.8155 1011 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:01:09.5780 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:01:19.3256 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:02:17.7568 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:02:24.9436 579 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-08 21:02:24','V',5063132979713980,2025,'2025-02-08 21:02:24','456947574400327005012999',1,2,16,'I','',1,0,1,'','',4) 08/02/2025 21:03:34.5324 671 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-08 21:03:33','V',5121416277336440,2025,'2025-02-08 21:03:32','456947581200327001012999',1,2,1,'I','',1,0,1,'','',4) 08/02/2025 21:04:47.8324 804 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/02/2025 21:05:05.6224 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:05:27.0787 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 21:10:23.5631 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:11:58.3445 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:13:00.5311 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:17:32.2691 597 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 08/02/2025 21:20:28.5970 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:21:15.7075 1971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:24:31.9307 1185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:25:33.0337 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 21:25:36.9483 664 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 21:25:35',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 21:27:06.1100 941 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/02/2025 21:28:26.2817 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 21:28:30.1352 818 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 21:28:29',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 08/02/2025 21:28:31.1669 663 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-08 21:28:30',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 08/02/2025 21:30:02.0737 737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 21:31:18.3688 676 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 08/02/2025 21:32:40.8571 1916 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-08 21:32:38','V',5328294337251060,2025,'2025-02-08 21:32:37','456947546500327005012999',2,2,2,'O','',0,'2025-02-08 21:32:38',1,'','',0) 08/02/2025 21:32:41.9428 586 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 21:32:41' where payTraUID = 4837702076786960 and payStatus='V' and payEnabled=1 08/02/2025 21:32:48.2410 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 21:36:05.0010 501 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/02/2025 21:38:09.6762 1576 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 08/02/2025 21:39:17.5905 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:39:39.2930 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:40:41.7467 1165 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:43:41.1456 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:44:33.6678 1526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:44:35.1547 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 21:48:47.3356 675 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 08/02/2025 21:52:36.3452 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:02:57.4787 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 22:04:31.1884 902 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 08/02/2025 22:04:31.8959 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 22:05:55.9411 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:07:49.3809 1393 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:12:36.5930 522 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 08/02/2025 22:14:45.2482 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:18:41.8676 1117 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 08/02/2025 22:19:49.9992 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:26:44.8457 878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:34:12.7877 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 22:34:37.3171 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:36:20.0218 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:36:34.8047 505 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 08/02/2025 22:36:34.9878 720 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 22:37:28.8719 1075 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:41:16.5035 958 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 08/02/2025 22:45:34.4952 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:45:42.1623 2511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:46:21.5367 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 22:50:08.5676 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:52:16.7313 685 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 08/02/2025 22:54:17.5321 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 22:57:39.2413 830 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-08 22:57:38' where payTraUID = 5510060015797230 and payStatus='V' and payEnabled=1 08/02/2025 22:57:39.7827 541 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-08 22:57:38' where traUID = 5510060015797230 and traStatus='V' and traEnabled=1 08/02/2025 23:00:46.8840 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 23:01:29.9769 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 23:13:46.4730 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/02/2025 23:18:35.4522 796 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 08/02/2025 23:21:00.7362 629 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 08/02/2025 23:21:06.7323 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 23:21:12.7733 671 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4753624947365880,5284854067418420,2025,'2025-02-08 23:21:12',' Date: 2/8/2025 11:21:11 PM Code: 456948083000327005012999 Entry Date: 2/8/2025 10:27:10 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500705802 ',0) 08/02/2025 23:29:29.2844 670 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-08 23:29:28',0,'V',4622465273564350,4820380041064430,2025,'2025-02-08 23:29:28',18,1,0,4,'2025-02-08 23:44:28','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 08/02/2025 23:47:12.2827 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 23:50:52.1317 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 23:55:10.0425 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 23:55:38.5076 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 08/02/2025 23:57:22.2872 1142 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1