03/02/2025 00:00:38.1947 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:00:52.8636 1078 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:10:41.5233 832 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 03/02/2025 00:25:09.0059 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:28:51.8048 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:29:18.8391 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:29:59.6918 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:38:29.1399 1755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:42:15.7474 1598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:44:21.7387 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:55:06.3623 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 00:57:01.4973 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 01:05:33.7223 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 01:10:36.0190 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 01:24:55.7554 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 01:33:56.5256 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:00:32.8519 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:03:00.9242 1730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:03:04.5817 2268 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 02:03:48.1442 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:04:27.7220 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:07:08.4328 523 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/02/2025 02:08:51.0263 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:26:00.1444 1341 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:26:09.5097 543 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 02:26:38.8466 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:41:36.7208 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:50:12.5001 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:52:05.8779 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:55:46.9046 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 02:59:14.2851 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:05:55.4108 1842 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 03:05:53' where payTraUID = 5219169717166410 and payStatus='V' and payEnabled=1 03/02/2025 03:07:27.1219 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:15:05.1441 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:16:59.4135 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:24:06.4698 1488 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:27:30.9293 3941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:27:47.9768 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:28:09.8316 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:35:13.8749 724 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 03/02/2025 03:41:22.9619 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:42:37.2402 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:46:19.5077 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:50:03.6485 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:51:56.9333 2013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:53:02.7108 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 03:55:00.5306 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 04:03:24.9073 866 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/02/2025 04:04:25.0470 663 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 04:04:25.6714 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 04:09:42.0948 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 04:16:18.2501 644 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 04:19:35.1865 1563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 04:19:48.7727 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 04:26:42.3158 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 04:28:34.8520 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 04:39:49.4459 2006 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/02/2025 04:50:13.1324 1472 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 04:57:54.0516 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 04:59:15.2846 1437 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 05:02:15.1074 1775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 05:11:04.5290 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 05:15:03.0396 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 05:32:17.4072 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 05:34:37.2729 2040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 05:51:39.7905 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:10:48.3505 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:13:25.0876 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:22:21.9222 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:28:39.4540 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:30:39.5813 1052 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/02/2025 06:30:39.7464 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:32:23.6008 2491 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:33:38.8918 1175 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-03 06:33:37','V',5210715105252200,2025,'2025-02-03 06:33:35','456892361500327005012999',1,2,16,'I','',1,0,1,'','0560008516054',163,0) 03/02/2025 06:33:41.8028 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:34:24.7549 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:35:36.5985 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 06:36:10.2613 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 06:36:19.8268 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:36:52.4719 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:45:13.7815 1191 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:46:09.5212 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:47:35.1132 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:47:36.4621 740 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 06:47:54.2101 636 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 06:48:44.0899 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 06:56:26.1119 1306 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 07:10:08.4789 1332 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 07:33:22.3810 2823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 07:33:29.7380 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 07:34:50.8860 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 07:42:58.9295 963 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-03 07:42:56',0,'V',4842310542758400,5432290331378510,2025,'2025-02-03 07:42:56',3,1,0,4,'2025-02-03 07:57:56','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 03/02/2025 07:49:04.3721 725 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-03 07:49:03','V',5236759665539960,2025,'2025-02-03 07:49:03','456892446000327005012999',2,2,2,'O','',0,'2025-02-03 07:49:03',1,'','',0) 03/02/2025 07:51:09.3267 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 07:51:45.5843 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 07:52:05.0124 953 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-03 07:52:04','V',5472937588211110,2025,'2025-02-03 07:52:02','456892832200327005012999',1,2,16,'I','',1,0,1,'','0560008512164',186,0) 03/02/2025 07:52:11.7510 693 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/02/2025 07:53:17.5415 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 07:58:30.9398 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 08:03:23.5911 763 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-03 08:03:22','V',5602881148587080,2025,'2025-02-03 08:03:22','456892900200327005012999',1,2,16,'I','',1,0,1,'','0230003950863',158,0) 03/02/2025 08:03:27.8059 1321 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 08:03:37.1412 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:03:37.4845 745 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-03 08:03:36','V',5127110719305060,2025,'2025-02-03 08:03:35','456892901500327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 08:03:38.0208 532 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 08:06:52.6366 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 08:06:58.0863 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:08:08.6351 1755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:09:14.5948 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:09:47.8223 1202 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:10:21.9244 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:11:02.9752 561 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 03/02/2025 08:11:47.7766 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:14:16.2021 1120 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-03 08:14:08',5,3,42101,0,50,-6,-300,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-03 08:14:08',5,3,42101,0,100,-42,-4200,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-03 08:14:08',5,3,42101,0,200,-2,-400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-03 08:14:08',5,3,42101,0,500,-5,-2500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-03 08:14:08',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 03/02/2025 08:26:38.0756 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:26:45.3695 1046 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 08:26:44' where payTraUID = 5076369683370690 and payStatus='V' and payEnabled=1 03/02/2025 08:26:58.2473 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:29:10.3067 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:35:19.5158 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:39:10.2301 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:44:34.5527 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:46:02.0020 1684 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 08:47:09.0574 2196 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:47:29.2421 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:48:44.6501 969 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 08:48:44.7212 552 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 08:48:50.4320 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:55:13.8167 781 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 03/02/2025 08:55:51.4452 1251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 08:56:08.5278 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:00:51.0031 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:04:38.1310 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:05:42.1023 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:06:59.2605 646 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 09:06:58' where traUID = 5588366060382380 and traStatus='V' and traEnabled=1 03/02/2025 09:07:00.6705 1408 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 839214 03/02/2025 09:07:34.2713 1603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:08:36.1222 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:09:11.1969 550 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 09:09:11.8073 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 09:10:54.3868 838 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 03/02/2025 09:12:53.0542 644 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-03 09:12:52','V',5166366495270200,2025,'2025-02-03 09:12:51','456893257400327005012999',2,2,2,'O','',0,'2025-02-03 09:12:52',1,'','',0) 03/02/2025 09:14:10.5627 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 09:14:30.3151 1002 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:16:48.3165 1124 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-03 09:16:47','V',4733911013013550,2025,'2025-02-03 09:16:46','456893340600327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 09:21:31.8806 891 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 09:23:59.5106 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:24:46.6375 1421 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 09:24:47.7072 1065 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 09:25:41.3646 625 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-03 09:25:40','V',5463716325157610,2025,'2025-02-03 09:25:39','456893393900327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 09:27:28.4221 2483 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:28:14.4143 964 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 09:28:31.3768 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:30:35.8891 705 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 09:30:35' where traUID = 4665366540592330 and traStatus='V' and traEnabled=1 03/02/2025 09:30:40.7134 762 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 09:30:55.0000 846 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 03/02/2025 09:32:43.2143 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 09:34:42.3090 511 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5307882575888810,4640673677259690,2025,'2025-02-03 09:34:41','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/3/2025 9:27:23 AM Date : 2/3/2025 9:34:40 AM Code : 456893404300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 03/02/2025 09:35:39.0204 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:35:54.9282 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 09:36:50.2787 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:41:44.2328 1728 ms. EXEC: update payReceipt set recCreation = '2025-02-03 09:41:42',recModify = '2025-02-03 09:41:42',recUseId=0,recStatus='V' where recId = 348539 03/02/2025 09:41:47.5550 2238 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:42:00.5889 563 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 09:42:04.7167 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 09:42:28.8250 1109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:43:25.9056 666 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-03 09:43:24',0,'V',4973691989309110,5567001297780720,2025,'2025-02-03 09:43:24',3,1,0,4,'2025-02-03 09:58:24','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 03/02/2025 09:43:28.5594 1395 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 03/02/2025 09:44:09.7834 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:44:14.1944 1137 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 09:46:23.2638 644 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 03/02/2025 09:47:13.4047 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 09:50:24.7904 1333 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:52:10.2088 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 09:58:17.1553 931 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 09:58:27.4893 1782 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/02/2025 10:01:26.3965 1816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:01:46.2019 625 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/02/2025 10:02:54.9905 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:09:28.9624 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:09:42.2374 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 10:10:08.3110 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:10:08.5482 622 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 10:10:09.0395 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:10:09.2757 725 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/02/2025 10:10:10.1172 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:10:10.7627 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:10:12.1846 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:10:45.3131 1228 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:12:38.1775 1397 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:18:41.1544 641 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5235950254287500,5416380551403910,2025,'2025-02-03 10:18:40',' Date: 2/3/2025 10:18:39 AM Code: 456893475200327005012999 Entry Date: 2/3/2025 9:39:12 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704839 ',0) 03/02/2025 10:20:20.2475 1395 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-03 10:20:18','V',5062374914003650,2025,'2025-02-03 10:20:17','456893721700327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 10:20:21.1371 534 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 10:20:41.1567 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 10:20:47.3098 2870 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 03/02/2025 10:20:49.4673 1547 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 10:20:47',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 03/02/2025 10:20:50.5430 599 ms. EXEC: update payInventory set invCreation = '2025-02-03 10:20:49',invModify = '2025-02-03 10:20:49',invUseId=0,invStatus='V' where invId = 234763 03/02/2025 10:20:55.3173 577 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 10:20:54' where payTraUID = 5235950254287500 and payStatus='V' and payEnabled=1 03/02/2025 10:21:01.6606 1802 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 03/02/2025 10:28:18.5555 2821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:28:27.1263 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:28:35.7761 1873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:28:44.0267 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:29:15.4350 546 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 10:30:02.3678 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 10:33:40.2764 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:33:53.4053 680 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 401609 else acvFstPayId end),acvLstPayId = 401609 where acvSftId = 894 and acvCodeId = 3 03/02/2025 10:35:49.3288 1453 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:36:40.1482 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-03 10:36:39','V',5041478785998350,2025,'2025-02-03 10:36:38','456893607200327005012999',2,2,2,'O','',0,'2025-02-03 10:36:39',1,'','',0) 03/02/2025 10:36:43.8187 577 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/02/2025 10:37:41.9021 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:37:56.2648 1521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:38:03.9670 1801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:39:07.4010 565 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 10:39:08.0494 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 10:39:08.9230 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:39:13.3450 4320 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:39:13.3690 4898 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/02/2025 10:39:22.2801 828 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-03 10:39:19',0,'V',4906998743411060,4996850176840930,2025,'2025-02-03 10:39:19',3,1,0,4,'2025-02-03 10:54:19','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 03/02/2025 10:40:52.4841 623 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-03 10:40:51','V',5297061701431910,2025,'2025-02-03 10:40:51','456893601900327005012999',2,2,2,'O','',0,'2025-02-03 10:40:51',1,'','',0) 03/02/2025 10:43:40.5730 781 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 10:43:41.2385 634 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 10:43:40' where payTraUID = 5669456291344860 and payStatus='V' and payEnabled=1 03/02/2025 10:45:28.1068 2466 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 10:48:02.6435 1519 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-03 10:48:01',0,'V',4878902704881040,5472036479756660,2025,'2025-02-03 10:48:01',18,1,0,4,'2025-02-03 11:03:01','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/02/2025 10:48:52.3071 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 10:52:41.1782 888 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 10:56:22.1338 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 10:56:27.6896 1298 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/02/2025 10:56:27.7677 1430 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 10:58:52.3156 1745 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-03 10:58:50','V',5486772583198540,2025,'2025-02-03 10:58:49','456893538000327005012999',2,2,2,'O','',0,'2025-02-03 10:58:50',1,'','',0) 03/02/2025 10:59:44.5399 1504 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 03/02/2025 11:00:00.1605 2268 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4847, trcLastPrinted = '2500704847', trcLastDate = '2025-02-03 10:59:57' where trcStatus='V' and trcTerId = 18 03/02/2025 11:00:15.2457 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:00:16.8008 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:00:29.0351 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:01:16.8144 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:04:12.2563 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 11:14:24.6831 932 ms. EXEC: update paycash set casCreation = '2025-02-03 11:14:23',casModify = '2025-02-03 11:14:23',casUseId=0,casStatus='V' where casId = 207830 03/02/2025 11:17:06.7489 671 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 11:17:07.5664 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:17:18.1836 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:19:48.7986 672 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 11:20:13.1591 531 ms. EXEC: update payReceipt set recCreation = '2025-02-03 11:20:12',recModify = '2025-02-03 11:20:12',recUseId=0,recStatus='V' where recId = 348577 03/02/2025 11:22:13.0163 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:23:30.5919 725 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 11:27:14.2163 1013 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-03 11:27:13',4,6,'2025-02-03 11:27:13','456893883200327005012999','Payed (Credit Card ) Ticket ') 03/02/2025 11:28:18.0856 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 11:29:23.1817 712 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-03 11:29:21',0,'V',5044012041801920,4923233617128260,2025,'2025-02-03 11:29:21',3,1,0,4,'2025-02-03 11:44:21','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 03/02/2025 11:29:25.5483 529 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 11:29:24',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'; 03/02/2025 11:31:19.2103 1032 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:34:28.1713 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 11:34:28.3704 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:35:09.6193 812 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 11:37:21.1544 641 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-03 11:37:20','V',4926930177256590,2025,'2025-02-03 11:37:19','456894183900327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 11:37:57.9724 1059 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 11:39:04.4724 843 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 11:41:41.0254 544 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 03/02/2025 11:41:42.0221 531 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-03 11:41:41','V',5244264110862080,2025,'2025-02-03 11:41:39','456893549900327005012999',2,2,2,'O','',0,'2025-02-03 11:41:41',1,'','',0) 03/02/2025 11:41:47.4888 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 11:42:41.9197 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:42:45.6182 777 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/02/2025 11:43:25.1710 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:47:39.9416 896 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 11:47:39' where payTraUID = 5541627015732410 and payStatus='V' and payEnabled=1 03/02/2025 11:47:48.6034 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:48:06.3504 1201 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-03 11:48:05',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-03 11:48:05',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 11:48:05',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 03/02/2025 11:49:17.2605 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:49:45.4185 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:49:48.5837 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:50:18.4769 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:51:07.6462 1540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 11:56:54.7163 672 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 11:57:05.5156 585 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 11:59:07.2721 1001 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 03/02/2025 11:59:52.9901 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 12:00:26.0204 568 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/02/2025 12:00:31.9845 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:04:48.2230 874 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/02/2025 12:04:51.6584 516 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-03 12:04:51',0,16,'2025-02-03 12:04:51','','Unauthorized Transit Entry 2') 03/02/2025 12:08:47.1969 544 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4857, trcLastPrinted = '2500704857', trcLastDate = '2025-02-03 12:08:46' where trcStatus='V' and trcTerId = 18 03/02/2025 12:09:22.2136 1036 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-03 12:09:21','V',5060547004556300,2025,'2025-02-03 12:09:20','456894376000327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 12:10:47.1842 541 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 12:10:50.6625 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 12:11:24.2493 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:12:08.0039 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:13:32.8174 1017 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-03 12:13:31','V',5007313705186910,2025,'2025-02-03 12:13:30','456894401000327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 12:13:33.9632 1060 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 12:18:27.6641 1074 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 12:18:28.5377 865 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 12:18:32.5674 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 12:19:10.7753 565 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-03 12:19:10','V',5653120941886480,2025,'2025-02-03 12:19:09','456894434900327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 12:21:28.6237 776 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/02/2025 12:24:12.1474 681 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 12:26:07.2524 1184 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:27:12.7878 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:27:20.8382 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:29:52.3899 714 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-03 12:29:51',0,0,'V',5338661910982840,4698102275151710,2025,'2025-02-03 12:29:51',3,'KES',1,100,100,'N',''); 03/02/2025 12:32:03.5877 561 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 12:32:03' where payTraUID = 4698102275151710 and payStatus='V' and payEnabled=1 03/02/2025 12:32:05.3509 1763 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 12:32:03' where traUID = 4698102275151710 and traStatus='V' and traEnabled=1 03/02/2025 12:32:11.2760 521 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); 03/02/2025 12:32:36.2729 816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:33:18.7717 778 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-03 12:33:17','V',5615729894677550,2025,'2025-02-03 12:33:16','456894428100327005012999',2,2,2,'O','',0,'2025-02-03 12:33:17',1,'','',0) 03/02/2025 12:34:00.7621 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 12:34:11.2592 976 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/02/2025 12:35:17.8003 672 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 12:37:40.9372 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:37:44.6147 966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:41:23.2608 1986 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 12:41:21' where traUID = 4758915398757970 and traStatus='V' and traEnabled=1 03/02/2025 12:44:06.3313 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 12:49:23.9004 1429 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 12:49:56.2213 825 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 12:52:53.1251 823 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 12:53:01.7780 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 12:57:50.6476 800 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 12:57:56.2894 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 12:57:57.2851 959 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/02/2025 12:59:48.3343 998 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 12:59:47' where payTraUID = 4934677147396480 and payStatus='V' and payEnabled=1 03/02/2025 13:00:43.1455 1004 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 13:00:41' where traUID = 5195315636502700 and traStatus='V' and traEnabled=1 03/02/2025 13:01:22.0928 1211 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-03 13:01:20','V',4834588197750750,2025,'2025-02-03 13:01:20','456894688000327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 13:01:46.8016 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 13 ms.) 03/02/2025 13:02:13.4626 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 13:07:30.1361 655 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 13:12:23.3367 622 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-03 13:12:22','V',5421499301437510,2025,'2025-02-03 13:12:22','456894302200327005012999',2,2,2,'O','',0,'2025-02-03 13:12:22',1,'','',0) 03/02/2025 13:12:24.1333 792 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 13:12:27.0793 2943 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 13:12:27.7167 634 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 13:12:27' where payTraUID = 5366115638099550 and payStatus='V' and payEnabled=1 03/02/2025 13:12:29.0616 1343 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 13:12:27' where traUID = 5366115638099550 and traStatus='V' and traEnabled=1 03/02/2025 13:12:32.1647 1580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:13:22.3897 1339 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-03 13:13:21','V',5639171956117310,2025,'2025-02-03 13:13:20','456894760000327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 13:13:56.7640 1421 ms. EXEC: update paycash set casCreation = '2025-02-03 13:13:55',casModify = '2025-02-03 13:13:55',casUseId=0,casStatus='V' where casId = 207859 03/02/2025 13:14:21.0435 725 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-03 13:14:20','V',5362973453514860,2025,'2025-02-03 13:14:19','456894765900327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 13:14:22.9708 1470 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 13:14:30.2987 755 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/02/2025 13:17:38.8014 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-03 13:17:34',12,'V',5662054798995290,5447491396502170,2025,'2025-02-03 13:17:34',17,1,0,4,'2025-02-03 13:32:34','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/02/2025 13:17:40.3575 1347 ms. EXEC: update tabTerminalReceipt set trcProgressive = 828, trcLastPrinted = '2500600828', trcLastDate = '2025-02-03 13:17:39' where trcStatus='V' and trcTerId = 17 03/02/2025 13:19:17.9436 2132 ms. EXEC: update payReceipt set recCreation = '2025-02-03 13:19:15',recModify = '2025-02-03 13:19:15',recUseId=0,recStatus='V' where recId = 348635 03/02/2025 13:21:01.3606 986 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 13:21:06.1509 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 13:21:22.6881 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 13:23:06.3933 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:27:58.9064 1457 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 13:30:07.7477 775 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-03 13:30:06','V',5564149569100680,2025,'2025-02-03 13:30:05','456894860500327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 13:30:09.1016 1349 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 13:31:44.2371 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:33:25.0824 748 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-03 13:33:24','V',5277653976616630,2025,'2025-02-03 13:33:23','456894465400327005012999',2,2,2,'O','',0,'2025-02-03 13:33:24',1,'','',0) 03/02/2025 13:33:26.0050 623 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 13:34:01.9753 546 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 13:36:02.6781 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 13:36:22.4445 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:39:43.3776 609 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 13:39:43.6378 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:40:16.5290 574 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-03 13:40:15','V',5697461487490190,2025,'2025-02-03 13:40:14','456894458700327005012999',2,2,2,'O','',0,'2025-02-03 13:40:15',1,'','',0) 03/02/2025 13:43:15.1680 524 ms. EXEC: update payReceipt set recCreation = '2025-02-03 13:43:14',recModify = '2025-02-03 13:43:14',recUseId=0,recStatus='V' where recId = 348645 03/02/2025 13:44:22.0594 1040 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 13:46:30.7505 1125 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-03 13:46:29','V',5439633599565250,2025,'2025-02-03 13:46:27','456894958700327005012999',1,2,16,'I','',1,0,1,'','0230004101179',8,0) 03/02/2025 13:46:40.1829 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:47:09.2816 1162 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 13:47:20.2541 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:48:06.5744 1589 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-03 13:48:04',0,'V',4916856594901750,5564149569100680,2025,'2025-02-03 13:48:04',18,1,0,4,'2025-02-03 14:03:04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/02/2025 13:48:07.2999 636 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4880, trcLastPrinted = '2500704880', trcLastDate = '2025-02-03 13:48:06' where trcStatus='V' and trcTerId = 18 03/02/2025 13:49:07.7499 1335 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-03 13:49:06',0,'V',5005059226755690,4771416060645920,2025,'2025-02-03 13:49:06',18,1,0,4,'2025-02-03 14:04:06','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/02/2025 13:49:08.4884 550 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4771416060645920,5005059226755690,2025,'2025-02-03 13:49:07',' Date: 2/3/2025 1:49:06 PM Code: 456894881100327005012999 Entry Date: 2/3/2025 1:33:31 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 # 2500704882 ',0) 03/02/2025 13:49:36.4783 924 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-03 13:49:35' where subId = 14 03/02/2025 13:49:39.7185 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:50:15.4988 556 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-03 13:50:14',0,'V',4802794278266490,4917750554510750,2025,'2025-02-03 13:50:14',18,1,0,4,'2025-02-03 14:05:14','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/02/2025 13:53:27.1356 665 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 13:55:16.5497 872 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 13:55:21.6181 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:55:23.0961 2337 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 13:56:05.1956 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:56:16.7184 937 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 401719 else acvFstPayId end),acvLstPayId = 401719 where acvSftId = 894 and acvCodeId = 3 03/02/2025 13:56:30.5268 1849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 13:56:37.5215 1111 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/02/2025 13:57:38.3097 647 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 13:57:56.8042 612 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-03 13:57:56','V',5466289696415350,2025,'2025-02-03 13:57:54','456894724800327001012999',2,2,2,'O','',0,'2025-02-03 13:57:56',1,'','',0) 03/02/2025 13:58:37.0235 951 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/02/2025 13:59:00.4323 792 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 13:59:09.2423 997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:01:12.3537 1274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:02:28.1540 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:02:29.4809 523 ms. EXEC: update payReceipt set recCreation = '2025-02-03 14:02:28',recModify = '2025-02-03 14:02:28',recUseId=0,recStatus='V' where recId = 348665 03/02/2025 14:03:58.0949 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:04:20.5171 669 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5621985267736060,5646110884347140,2025,'2025-02-03 14:04:19',' Data: 2/3/2025 2:04:15 PM Codice: 456894980600327005012999 Ingresso: 2/3/2025 1:50:06 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500600832 ',0) 03/02/2025 14:05:21.9387 541 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 14:05:22.0498 662 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 14:06:38.1884 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:07:45.4299 728 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 14:07:44',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'; 03/02/2025 14:09:49.2848 993 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/02/2025 14:12:25.3415 889 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-03 14:12:24','V',5557137427248690,2025,'2025-02-03 14:12:23','456895114300327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 14:12:27.1047 1756 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 14:13:59.3452 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:15:16.0972 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:16:36.8879 905 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:16:58.0112 636 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 14:16:57' where payTraUID = 5696479717853300 and payStatus='V' and payEnabled=1 03/02/2025 14:17:01.4986 674 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:17:01.6847 711 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 14:17:55.5372 662 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 14:17:54',3,42101,0,500,1,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 03/02/2025 14:17:56.9621 1112 ms. EXEC: update payInventory set invCreation = '2025-02-03 14:17:55',invModify = '2025-02-03 14:17:55',invUseId=0,invStatus='V' where invId = 234821 03/02/2025 14:17:57.0342 550 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-03 14:17:15',6,'V',5431297270156660,5638325434835910,2025,'2025-02-03 14:17:15',4,1,0,4,'2025-02-03 14:32:15','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 03/02/2025 14:21:29.9884 799 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 14:25:43.2540 942 ms. EXEC: update paycash set casCreation = '2025-02-03 14:25:42',casModify = '2025-02-03 14:25:42',casUseId=0,casStatus='V' where casId = 207875 03/02/2025 14:26:44.5285 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:27:32.4119 1303 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-03 14:26:49',6,'V',4969864506935730,5132766017665110,2025,'2025-02-03 14:26:49',4,1,0,4,'2025-02-03 14:41:49','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/02/2025 14:27:34.7605 535 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 03/02/2025 14:29:38.0550 1078 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 14:29:42.4070 622 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 14:29:41' where traUID = 5132766017665110 and traStatus='V' and traEnabled=1 03/02/2025 14:30:18.6155 547 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 14:32:39.8631 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:33:07.4238 874 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 14:33:06' where traUID = 5639171956117310 and traStatus='V' and traEnabled=1 03/02/2025 14:33:20.9670 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:33:31.7213 1491 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 14:33:31.9704 1435 ms. EXEC: update tabTerminalReceipt set trcProgressive = 835, trcLastPrinted = '2500600835', trcLastDate = '2025-02-03 14:33:30' where trcStatus='V' and trcTerId = 17 03/02/2025 14:34:24.7602 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:35:34.5865 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:35:56.7685 1657 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4895, trcLastPrinted = '2500704895', trcLastDate = '2025-02-03 14:35:55' where trcStatus='V' and trcTerId = 18 03/02/2025 14:36:02.1992 707 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4994328393498520,5709609931786670,2025,'2025-02-03 14:36:01','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/3/2025 1:41:11 PM Date : 2/3/2025 2:35:57 PM Code : 456894927100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) (WAIT TIME 1 ms.) 03/02/2025 14:37:22.5616 929 ms. EXEC: update paycash set casCreation = '2025-02-03 14:37:21',casModify = '2025-02-03 14:37:21',casUseId=0,casStatus='V' where casId = 207878 03/02/2025 14:37:23.1290 567 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 14:37:21',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'; 03/02/2025 14:37:37.3386 717 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/02/2025 14:40:09.0494 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:40:43.8200 1136 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:40:49.8390 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:41:25.6213 609 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-03 14:41:25','V',5087717475570750,2025,'2025-02-03 14:41:23','456895020900327005012999',2,2,2,'O','',0,'2025-02-03 14:41:25',1,'','',0) 03/02/2025 14:44:24.7516 558 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 14:44:24' where payTraUID = 5645796649055730 and payStatus='V' and payEnabled=1 03/02/2025 14:44:31.4021 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:44:31.4301 891 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:44:39.4526 890 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/02/2025 14:48:39.3500 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 14:49:27.0123 511 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-03 14:49:25',0,'V',5498038512656540,5057705897507960,2025,'2025-02-03 14:49:25',3,1,0,4,'2025-02-03 15:04:25','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 03/02/2025 14:49:27.8109 507 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 14:49:27',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 03/02/2025 14:49:51.4419 1183 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 14:51:27.6390 870 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 14:51:26',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'; 03/02/2025 14:51:59.5997 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 14:54:50.4144 626 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 14:54:49' where traUID = 4615045885798530 and traStatus='V' and traEnabled=1 03/02/2025 14:56:36.0519 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:02:07.9057 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:02:46.5989 550 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 15:03:02.3146 550 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 15:03:25.0440 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:03:57.3539 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:05:53.5466 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:05:56.3434 580 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 03/02/2025 15:06:28.9355 630 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 15:06:29.5229 568 ms. OPEN: select * from tabTerminal where terId = 16 03/02/2025 15:06:44.1068 1194 ms. EXEC: update payReceipt set recCreation = '2025-02-03 15:06:42',recModify = '2025-02-03 15:06:42',recUseId=0,recStatus='V' where recId = 348705 03/02/2025 15:07:34.5920 862 ms. EXEC: update payInventory set invCreation = '2025-02-03 15:07:33',invModify = '2025-02-03 15:07:33',invUseId=0,invStatus='V' where invId = 234839 03/02/2025 15:08:21.3036 510 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 03/02/2025 15:10:32.4705 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:12:34.1859 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:14:00.4243 712 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-03 15:13:59',0,0,'V',5562210754599320,4709089517907020,2025,'2025-02-03 15:13:59',3,'KES',1,100,100,'N',''); 03/02/2025 15:17:44.7112 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:18:27.7584 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:18:51.0732 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:19:17.5641 718 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 15:19:17.5641 714 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/02/2025 15:19:18.5348 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:19:26.7914 656 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 254 ms.) 03/02/2025 15:19:26.7964 909 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 11 ms.) 03/02/2025 15:19:36.0106 977 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-03 15:19:33',0,'V',4809014303347930,5109069584958000,2025,'2025-02-03 15:19:33',3,1,0,4,'2025-02-03 15:34:33','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 03/02/2025 15:19:37.1684 1111 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5109069584958000,4809014303347930,2025,'2025-02-03 15:19:36','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/3/2025 3:13:29 PM Date : 2/3/2025 3:19:33 PM Code : 456895480900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 03/02/2025 15:19:38.5714 1079 ms. EXEC: update paycash set casCreation = '2025-02-03 15:19:37',casModify = '2025-02-03 15:19:37',casUseId=0,casStatus='V' where casId = 207894 03/02/2025 15:19:39.6001 527 ms. EXEC: update payInventory set invCreation = '2025-02-03 15:19:39',invModify = '2025-02-03 15:19:39',invUseId=0,invStatus='V' where invId = 234844 03/02/2025 15:19:52.5148 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:20:03.0079 554 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/02/2025 15:20:33.6307 639 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5227969263403300,5086800261951620,2025,'2025-02-03 15:20:32',' Date: 2/3/2025 3:20:32 PM Code: 456895240500327005012999 Entry Date: 2/3/2025 2:33:25 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704907 ',0) 03/02/2025 15:20:49.4874 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:21:09.8232 614 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '456895350500327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 03/02/2025 15:21:10.7618 659 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 15:21:17.1181 1890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:24:15.2928 646 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 15:24:14',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'; 03/02/2025 15:24:21.4330 518 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 15:24:20' where payTraUID = 4856027596044740 and payStatus='V' and payEnabled=1 03/02/2025 15:24:27.5051 518 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 15:24:27.5171 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:25:33.4678 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:25:45.8722 1653 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-03 15:25:44','V',5372124479534260,2025,'2025-02-03 15:25:42','456895440800327005012999',2,2,2,'O','',0,'2025-02-03 15:25:44',1,'','',0) 03/02/2025 15:25:50.7915 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:26:10.8921 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:27:04.6935 843 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:27:28.3486 850 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 15:27:30.6962 2339 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 15:27:31.3926 676 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 15:27:30' where payTraUID = 5733062411891980 and payStatus='V' and payEnabled=1 03/02/2025 15:27:39.2480 1339 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:27:54.1250 536 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 15:27:53' where traUID = 5470849832028990 and traStatus='V' and traEnabled=1 03/02/2025 15:28:45.4548 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:28:57.9102 899 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 15:29:23.0363 505 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 03/02/2025 15:29:23.3735 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:30:19.8277 571 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 15:32:18.5131 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:37:44.9332 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:38:58.8743 1327 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 15:39:29.2889 534 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/02/2025 15:43:57.8758 656 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:46:56.0275 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:48:59.9014 1870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 15:49:35.9728 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 15:49:47.4346 1357 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 03/02/2025 15:49:48.9496 750 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5541177282677000,5025382074688250,2025,'2025-02-03 15:49:48',' Date: 2/3/2025 3:49:47 PM Code: 456895643400327005012999 Entry Date: 2/3/2025 3:40:34 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 # 2500704914 ',0) 03/02/2025 15:52:18.8461 1067 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 03/02/2025 15:54:03.5401 616 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-03 15:54:02','V',5005489098688360,2025,'2025-02-03 15:54:02','456895724200327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 15:59:22.5902 976 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 15:59:21',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 03/02/2025 15:59:23.7409 808 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-03 15:59:22',0,0,'V',5615039642793580,5611363223236190,2025,'2025-02-03 15:59:22',3,'KES',-1,50,-50,'N',''); 03/02/2025 15:59:25.5091 1620 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-03 15:59:22',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-03 15:59:22',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-03 15:59:22',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 03/02/2025 16:02:18.4693 599 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 16:02:17' where traUID = 4788806887735350 and traStatus='V' and traEnabled=1 03/02/2025 16:02:25.1418 1151 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:05:29.2055 1256 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 16:05:36.2473 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:07:44.7343 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:08:54.8358 1158 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:10:02.6532 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:10:05.4071 640 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-03 16:10:04','V',5397906145195200,2025,'2025-02-03 16:10:03','456894973500327001012999',2,2,2,'O','',0,'2025-02-03 16:10:04',1,'','',0) 03/02/2025 16:10:12.7320 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:12:39.8677 682 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 16:12:41.8871 1976 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 16:12:39' where traUID = 5544893998707660 and traStatus='V' and traEnabled=1 03/02/2025 16:15:49.5342 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:16:11.2589 2286 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-03 16:16:08',0,'V',4937387041463150,5035729996795460,2025,'2025-02-03 16:16:08',18,1,0,4,'2025-02-03 16:31:08','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/02/2025 16:16:41.4153 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:17:25.3881 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:21:38.2203 513 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/02/2025 16:23:50.7581 1148 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/02/2025 16:23:59.0447 777 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 16:23:58' where traUID = 5516539461754970 and traStatus='V' and traEnabled=1 03/02/2025 16:25:46.8728 620 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 16:29:17.5725 1185 ms. EXEC: update payInventory set invCreation = '2025-02-03 16:29:16',invModify = '2025-02-03 16:29:16',invUseId=0,invStatus='V' where invId = 234861 03/02/2025 16:31:18.4363 740 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 03/02/2025 16:31:19.3029 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:31:47.0897 1663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:34:07.8851 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-03 16:34:07',0,'V',4620866340388900,4796239192668310,2025,'2025-02-03 16:34:07',18,1,0,4,'2025-02-03 16:49:07','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 03/02/2025 16:35:09.3658 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:35:23.2812 1059 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:37:59.2408 784 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/02/2025 16:37:59.2518 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:43:19.1745 1083 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:47:09.2574 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:47:54.4700 1560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:47:57.6552 640 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 16:48:41.2076 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-03 16:48:40','V',5005466221844440,2025,'2025-02-03 16:48:40','456896052000327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 16:54:03.3889 699 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 03/02/2025 16:55:18.4547 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:56:12.3802 721 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/02/2025 16:57:17.7906 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 16:58:52.0984 765 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 16:58:51' where traUID = 5400517271184770 and traStatus='V' and traEnabled=1 03/02/2025 16:58:59.2823 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 16:59:30.4364 1078 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 17:00:00.5918 2431 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-03 16:59:58','V',5149660128577550,2025,'2025-02-03 16:59:56','456895977200327005012999',2,2,2,'O','',0,'2025-02-03 16:59:58',1,'','',0) 03/02/2025 17:00:04.0362 3250 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 17:03:29.5454 635 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/02/2025 17:06:54.0789 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 17:08:50.5628 840 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/02/2025 17:10:54.6779 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 17:23:07.8385 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 17:26:07.6422 550 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-03 17:26:07',0,'V',4763363473592000,5376512947988180,2025,'2025-02-03 17:26:07',2,1,0,-1,'2025-02-03 18:26:07','S','KES',0,0,0,'','','',3,0,0) 03/02/2025 17:27:47.0976 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 17:30:10.2266 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 17:33:05.1811 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 17:34:52.8990 638 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 03/02/2025 17:36:10.7347 920 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 03/02/2025 17:40:02.3096 561 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 03/02/2025 17:40:46.4465 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 17:41:58.5543 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 17:46:08.4576 807 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 03/02/2025 17:47:14.4893 996 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 03/02/2025 17:47:15.3989 614 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 17:47:22.8900 1330 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 17:51:59.3233 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 17:54:27.0693 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 17:56:38.1231 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 17:58:25.9862 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 17:59:17.7342 1513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:04:30.7692 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:05:33.4067 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:05:39.0555 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:14:17.8259 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 18:14:17.8289 684 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extcode' 03/02/2025 18:15:26.2412 859 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 18:15:25' where traUID = 5225405924583250 and traStatus='V' and traEnabled=1 03/02/2025 18:17:42.1883 1053 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 18:17:41' where payTraUID = 5010501010109120 and payStatus='V' and payEnabled=1 03/02/2025 18:19:12.7156 639 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-03 18:19:12','0230003957463',0,0,5227354561675270,25,'0000-00-00 00:00:00','0000-00-00 00:00:00') 03/02/2025 18:19:13.8084 1078 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-03 18:19:12',0,'V',5227354561675270,4777966158368330,2025,'2025-02-03 18:19:12',2,1,0,-1,'2025-02-03 19:19:12','S','KES',0,0,0,'','','',3,0,0) 03/02/2025 18:19:14.5238 633 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 18:19:15.9028 1377 ms. EXEC: update abbCards set carLastDate = '2025-02-03 18:19:14',carLastDirection='O' where carStatus='V' and carId = 25 03/02/2025 18:19:16.5592 646 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 18:19:19.7574 1319 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 18:19:27.3906 947 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 03/02/2025 18:21:27.6360 639 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 18:21:42.0838 1074 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:23:11.1721 1313 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:23:59.8811 825 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-03 18:23:59',0,'V',5335257616343620,5570473457726870,2025,'2025-02-03 18:23:59',18,1,0,4,'2025-02-03 18:38:59','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/02/2025 18:24:02.5739 1384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:33:55.1015 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:34:05.9839 1242 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/02/2025 18:34:17.1965 736 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 18:34:16' where traUID = 4784978775287540 and traStatus='V' and traEnabled=1 03/02/2025 18:34:42.0213 1100 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4950, trcLastPrinted = '2500704950', trcLastDate = '2025-02-03 18:34:40' where trcStatus='V' and trcTerId = 18 03/02/2025 18:36:00.1963 649 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-03 18:35:59','V',5603515930685870,2025,'2025-02-03 18:35:56','456896614000327005012999',2,2,2,'O','',0,'2025-02-03 18:35:59',1,'','',0) 03/02/2025 18:36:11.9863 1062 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/02/2025 18:37:08.8788 548 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-03 18:37:08','V',5017444097930110,2025,'2025-02-03 18:36:59','456896408400327005012999',2,2,2,'O','',0,'2025-02-03 18:37:08',1,'','',0) 03/02/2025 18:37:08.9528 570 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-03 18:37:08','V',4637512176745310,2025,'2025-02-03 18:37:01','456896702100327001012999',1,2,1,'I','',1,0,1,'','',4) 03/02/2025 18:38:33.0578 1198 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:41:55.9903 1125 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 18:43:56.0786 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:44:06.2675 525 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 18:44:05' where traUID = 5589582001116100 and traStatus='V' and traEnabled=1 03/02/2025 18:45:31.1960 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 18:46:30.5973 1759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 18:52:39.2500 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:02:46.9386 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:05:42.0352 1507 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 19:14:35.9338 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:18:22.0770 582 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 19:19:23.4515 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 19:21:52.4214 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:22:40.5651 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:24:28.7804 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:27:30.5225 1395 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:29:33.1991 846 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 19:36:24.3256 1194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:41:43.2887 899 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 19:45:18.5315 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:47:54.2800 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 19:48:33.3734 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 19:53:57.9483 1224 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:02:13.5440 1118 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:05:32.9580 2108 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-03 20:05:28',12,'V',4729710059631650,5646101519889040,2025,'2025-02-03 20:05:28',17,1,0,4,'2025-02-03 20:20:28','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 03/02/2025 20:07:26.5610 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 20:08:15.7793 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:08:20.9598 571 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-03 20:08:20',0,2,'2025-02-03 20:08:20','','Unauthorized Transit Exit 1') 03/02/2025 20:08:51.0952 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:08:59.6811 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:20:49.2056 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:30:15.1500 545 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 20:34:35.3352 920 ms. EXEC: update payReceipt set recCreation = '2025-02-03 20:34:34',recModify = '2025-02-03 20:34:34',recUseId=0,recStatus='V' where recId = 348810 03/02/2025 20:35:10.3589 2078 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/02/2025 20:35:37.9516 851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:36:36.1050 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 20:41:13.5610 3791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:42:37.0785 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:48:38.7945 2334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 20:51:27.7940 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 20:54:18.0423 725 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-03 20:54:17','V',5049795614383410,2025,'2025-02-03 20:54:16','456897525600327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 20:56:23.2881 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 21:01:20.8137 505 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/02/2025 21:02:53.1502 547 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-03 21:02:52' where subId = 139 03/02/2025 21:04:40.1207 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 21:05:17.9833 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:08:15.1223 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 21:10:31.6348 636 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 21:10:30' where traUID = 4699426428032230 and traStatus='V' and traEnabled=1 03/02/2025 21:11:21.5286 2889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:11:46.4414 973 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/02/2025 21:13:43.9820 778 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 21:15:42.7875 1000 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:18:15.1767 1248 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/02/2025 21:18:45.7364 1224 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:18:51.8266 1188 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:19:18.4926 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:21:04.2973 550 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 21:21:03' where payTraUID = 4613977274174200 and payStatus='V' and payEnabled=1 03/02/2025 21:21:22.0363 614 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/02/2025 21:22:50.0539 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:36:55.5356 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 21:37:42.5144 556 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/02/2025 21:37:47.5018 861 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 21:38:34.7838 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:38:50.2483 1061 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 21:38:49' where payTraUID = 5707282032857650 and payStatus='V' and payEnabled=1 03/02/2025 21:40:27.2380 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 21:45:00.1639 535 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-03 21:44:59','V',5727373664208960,2025,'2025-02-03 21:44:59','456897829900327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 21:49:51.5882 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:53:26.0585 1079 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:55:52.8199 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 21:59:44.7060 1417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:00:50.3695 962 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-03 22:00:49','V',5099832659291930,2025,'2025-02-03 22:00:48','456897924800327005012999',1,2,16,'I','',1,0,1,'','',4) 03/02/2025 22:08:57.1182 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:09:49.6197 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:12:19.6954 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:15:58.4786 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:16:43.5551 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:19:25.9231 821 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 03/02/2025 22:19:27.3110 1922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:21:28.2990 1448 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 22:22:40.3468 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-03 22:22:39','V',5390523174216240,2025,'2025-02-03 22:22:36','456897837000327005012999',2,2,2,'O','',0,'2025-02-03 22:22:39',1,'','',0) 03/02/2025 22:25:52.9482 1189 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 22:31:10.5994 1044 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-03 22:31:09' where traUID = 5702086069893780 and traStatus='V' and traEnabled=1 03/02/2025 22:31:14.7972 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 22:36:52.8062 696 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-03 22:36:52' where subId = 16 03/02/2025 22:38:29.4756 1056 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/02/2025 22:44:26.9938 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:44:31.9492 1159 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 22:49:37.2830 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:55:46.2579 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 22:55:50.6899 948 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/02/2025 22:55:51.6135 728 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-03 22:55:50' where payTraUID = 4981252823760210 and payStatus='V' and payEnabled=1 03/02/2025 22:55:55.9405 684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/02/2025 23:07:43.7479 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:08:08.6838 1606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:10:07.5713 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:11:25.7402 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:13:35.5732 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:17:01.5147 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:20:01.3115 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:28:44.2216 1335 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/02/2025 23:32:49.2586 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:33:48.3096 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:46:13.3042 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:49:59.6215 618 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/02/2025 23:50:49.8305 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:54:16.7047 588 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/02/2025 23:56:45.5345 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/02/2025 23:59:00.5299 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1