30/01/2025 00:01:48.9439 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 00:01:56.2758 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 00:32:52.8174 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 00:41:42.0040 1434 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 00:42:40.1478 803 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 00:46:48.7820 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 00:54:16.3591 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 00:56:56.6922 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 00:59:29.8736 755 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 00:59:29',0,'V',5703180112599890,4719646678464290,2025,'2025-01-30 00:59:29',18,1,0,4,'2025-01-30 01:14:29','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 30/01/2025 01:03:35.2525 1746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:13:43.0877 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:17:40.0941 2249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:23:06.5312 1270 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:24:55.6401 647 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 01:25:01.2799 1212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:26:29.8221 1528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:29:37.5865 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:31:07.0613 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:34:42.1190 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 01:37:02.3057 3941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:37:03.6716 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:37:09.2994 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:37:12.4905 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:37:40.8284 1821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:37:55.2931 1794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:37:55.4842 721 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 01:41:49.4946 1213 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 01:42:26.2812 1279 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:48:21.4040 2040 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 01:52:24.3123 1312 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 01:59:56.6636 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:02:19.0777 612 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 02:05:12.4646 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:08:05.4352 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:09:10.0133 574 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 30/01/2025 02:09:10.5417 1195 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:13:03.9597 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:15:28.7744 1471 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:19:27.5030 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:21:51.9565 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:23:15.5343 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:25:56.4018 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 02:36:38.6790 516 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/01/2025 02:37:50.3719 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:08:03.7907 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:09:56.6581 1194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:17:11.1585 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:17:28.3740 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:19:36.4306 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:20:32.9893 2750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:20:39.1034 2354 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:21:36.7960 2419 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:22:03.0655 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:23:34.9129 2245 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:23:40.3866 1131 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:23:45.0747 543 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 03:23:52.5307 6064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:25:03.2830 1160 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 30/01/2025 03:27:17.1714 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:28:24.4084 1490 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:32:58.2594 802 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 30/01/2025 03:39:12.5495 1005 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 03:40:01.2780 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:40:35.9602 1430 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:41:28.9046 588 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 03:43:22.8968 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:44:08.0239 930 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 30/01/2025 03:47:34.9102 704 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 03:48:02.1804 913 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:49:29.6448 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:49:52.3260 1711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:50:29.4148 2998 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 30/01/2025 03:52:18.0103 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:53:21.8440 1876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 03:57:59.9798 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:00:59.6449 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:01:47.5569 1383 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:03:25.0421 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:08:08.8927 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:13:07.8505 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:18:47.7056 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:23:52.7925 2404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:24:55.2382 1813 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/01/2025 04:26:12.7270 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:27:03.2277 5157 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:27:07.5606 1600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:28:16.2425 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:30:28.6120 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:33:10.9985 1376 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 04:33:47.1737 3017 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 30/01/2025 04:36:21.5828 1303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:37:48.7391 1553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:37:48.7401 1300 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 04:38:15.0307 1432 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:38:16.7328 972 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:38:35.9676 3308 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 04:38:35.9706 2816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:39:05.5254 2992 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 30/01/2025 04:39:18.4820 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:40:23.9428 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:40:25.3918 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:40:44.3764 989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:40:58.2747 3576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:41:08.0553 1656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:41:12.1410 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:41:13.6280 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:41:25.7781 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:47:17.8664 778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:51:10.4008 1923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:53:36.6275 1363 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 04:58:27.6850 521 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 04:58:58.1563 1569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:00:19.8519 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:05:32.7060 1473 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:07:58.1902 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:08:56.8564 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:12:53.5826 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:13:46.3318 2993 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 05:13:47.3595 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 05:16:09.5025 1337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:17:31.5674 1704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:20:25.1413 2521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:24:33.0360 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:27:46.4923 615 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 05:27:47.3358 754 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 30/01/2025 05:30:01.4298 614 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 05:33:55.4692 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:34:25.7704 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:36:53.4321 576 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 05:39:32.9827 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:40:17.2063 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:40:55.7350 1405 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:41:23.5896 2073 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:44:30.2083 1488 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:45:35.0086 715 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 05:45:34','V',5739218132761960,2025,'2025-01-30 05:45:31','456851600600327005012999',2,2,2,'O','',0,'2025-01-30 05:45:34',1,'','',0) 30/01/2025 05:45:39.8128 1116 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 05:46:49.0481 1167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:49:33.8873 1842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:50:57.6272 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 05:51:58.8892 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 05:52:38.0343 1750 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/01/2025 05:57:10.3333 1993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:01:58.1446 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:03:25.4459 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:03:53.9620 2262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:05:57.4745 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:06:58.4022 973 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 30/01/2025 06:09:25.6756 1549 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-30 06:09:24','V',4867606017137760,2025,'2025-01-30 06:09:22','456848417000327005012999',2,2,2,'O','',0,'2025-01-30 06:09:24',1,'','0230003944081',15,0) 30/01/2025 06:10:37.0183 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:10:52.5567 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:15:33.8096 1150 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 30/01/2025 06:21:54.7132 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:22:55.5989 1621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:23:57.4102 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:24:15.8985 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:33:42.7503 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:34:14.4845 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:34:44.8408 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:35:05.9509 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:38:52.2591 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:39:05.9203 683 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1294, trcLastPrinted = '2500401294', trcLastDate = '2025-01-30 06:39:05' where trcStatus='V' and trcTerId = 4 30/01/2025 06:41:19.1062 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:46:28.2738 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:47:04.9183 1674 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-30 06:47:03','0230003944059',0,0,4960617323899420,13,'0000-00-00 00:00:00','0000-00-00 00:00:00') 30/01/2025 06:47:19.0538 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 06:48:10.5852 594 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/01/2025 06:51:44.8184 615 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-30 06:51:44',0,2,'2025-01-30 06:51:44','','Unauthorized Transit Exit 1') 30/01/2025 06:53:22.2415 2281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:55:03.9875 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:55:50.4085 885 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:56:47.0703 2337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:57:38.9170 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 06:58:23.1275 604 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 30/01/2025 06:59:21.3775 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:01:44.2189 2021 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 30/01/2025 07:01:55.6706 523 ms. EXEC: update payReceipt set recCreation = '2025-01-30 07:01:55',recModify = '2025-01-30 07:01:55',recUseId=0,recStatus='V' where recId = 347161 30/01/2025 07:03:39.4179 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:05:03.8853 1331 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:05:13.3927 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:05:29.6806 578 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 07:07:02.6437 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:07:16.2968 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:07:29.1654 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:07:58.2518 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:08:45.2252 4518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:10:16.2531 984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:15:38.4384 1473 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 07:15:59.6906 615 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-01-30 07:15:59',0,'V',5611576392375460,5543635941537440,2025,'2025-01-30 07:15:59',2,1,0,-1,'2025-01-30 08:15:59','S','KES',0,0,0,'','','',3,0,0) 30/01/2025 07:16:00.9764 656 ms. EXEC: update abbCards set carLastDate = '2025-01-30 07:16:00',carLastDirection='O' where carStatus='V' and carId = 13 30/01/2025 07:16:01.8540 875 ms. OPEN: select useParkAccess from tabUser where (useBadId = '456852496600327005012999' or useBadId = '456852496600327005012999') 30/01/2025 07:16:54.6173 946 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 07:17:18.0369 625 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-30 07:17:17',4,9,'2025-01-30 07:17:17','456852393900327005012999','Payed (Credit Card ) Ticket ') 30/01/2025 07:19:30.7926 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:19:31.8363 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:19:44.7800 699 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 07:21:29.9342 716 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 07:22:23.7882 505 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 07:23:37.6986 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:24:10.2544 662 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 07:24:10.9088 645 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 07:24:12.0886 816 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 07:24:10' where traUID = 5431342259451550 and traStatus='V' and traEnabled=1 30/01/2025 07:24:12.9672 2058 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 30/01/2025 07:24:25.1743 1324 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 07:24:25.8328 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:28:57.4753 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:29:03.9146 681 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 30/01/2025 07:29:07.4179 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:29:12.7415 2818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:29:16.1007 3383 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 07:29:16.1438 2337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:29:16.1528 1706 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 07:29:52.8873 1011 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:29:54.9967 1154 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:30:03.5835 2105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:31:46.0720 1165 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 07:31:48.1143 1059 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:32:49.3392 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:36:01.5287 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:36:30.8653 1683 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 30/01/2025 07:37:24.7042 619 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 07:39:09.1710 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:41:06.0391 973 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 07:41:07.0208 776 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 07:41:06' where payTraUID = 4745361684143080 and payStatus='V' and payEnabled=1 30/01/2025 07:42:28.3481 1514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:45:42.7650 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 07:46:03.5109 1596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:46:23.6063 782 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-30 07:46:22','0560008336102',0,0,4762985486756200,185,'0000-00-00 00:00:00','0000-00-00 00:00:00') (WAIT TIME 277 ms.) 30/01/2025 07:46:27.5170 3212 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 07:46:28.0843 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,payVatPercent,payVatAmount) VALUES ('2025-01-30 07:46:27',0,'V',4762985486756200,4715662164669280,2025,'2025-01-30 07:46:27',2,1,0,-1,'2025-01-30 08:46:27','S','KES',0,0,0,'','','',3,0,0) 30/01/2025 07:47:40.9670 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:48:11.7696 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 07:49:52.2247 1117 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:49:57.9276 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:53:01.8305 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 07:55:21.8380 844 ms. OPEN: SELECT traTarId,traDateTime FROM movTransit WHERE traStatus='V' AND traUID = '5495279277351040' ORDER BY traId DESC LIMIT 1 30/01/2025 07:55:25.2003 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 07:58:18.5571 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:05:19.0617 898 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 08:06:04.3820 906 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/01/2025 08:06:31.9003 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 08:07:15.8327 1837 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 08:07:21.9578 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 08:08:02.0846 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:22:30.7474 617 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,50,-17,-850,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,50,17,850,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,100,-37,-3700,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,100,37,3700,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,200,-8,-1600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,200,8,1600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:16',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 30/01/2025 08:22:35.2484 2193 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:26',5,3,42101,0,50,-22,-1100,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:26',5,3,42101,0,100,-46,-4600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:26',5,3,42101,0,200,-8,-1600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:26',5,3,42101,0,500,-2,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:26',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-30 08:22:26',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 30/01/2025 08:23:01.2467 935 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 08:26:22.7414 2229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:29:08.4501 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 08:29:29.2580 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:30:11.2561 730 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 08:30:10','V',4914162701061630,2025,'2025-01-30 08:30:08','456850000200327003229999',22,22,3,'I','',1,0,1,'','',2) 30/01/2025 08:30:11.8865 616 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 08:30:40.3645 1464 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 30/01/2025 08:36:34.1794 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:49:40.4445 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:50:09.0806 1892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:52:19.9651 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:53:30.3201 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 08:55:20.1615 773 ms. EXEC: update payReceipt set recCreation = '2025-01-30 08:55:19',recModify = '2025-01-30 08:55:19',recUseId=0,recStatus='V' where recId = 347172 30/01/2025 08:56:24.6766 600 ms. EXEC: update abbCards set carLastDate = '2025-01-30 08:56:24',carLastDirection='I' where carStatus='V' and carId = 125 30/01/2025 08:57:34.3582 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:00:02.6393 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:00:39.4789 622 ms. OPEN: select * from tabTerminalReceipt where trcStatus='V' and trcTerId = 4 order by trcId desc limit 1 30/01/2025 09:00:40.5106 1017 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1296, trcLastPrinted = '2500401296', trcLastDate = '2025-01-30 09:00:39' where trcStatus='V' and trcTerId = 4 30/01/2025 09:00:40.5696 1652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:01:21.9583 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:02:04.4617 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:03:40.1306 682 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 09:03:39','V',5365161303881590,2025,'2025-01-30 09:03:37','456852865200327005012999',2,2,2,'O','',0,'2025-01-30 09:03:39',1,'','',0) 30/01/2025 09:06:17.9451 887 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 09:13:49.5518 1016 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-30 09:13:48',0,0,'V',4707411993318080,4633028113286270,2025,'2025-01-30 09:13:48',3,'KES',1,50,50,'N',''); 30/01/2025 09:14:39.1250 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:19:16.3234 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:21:54.2239 1503 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-30 09:21:52','V',5005022397824050,2025,'2025-01-30 09:21:52','456853371200327005012999',1,2,16,'I','',1,0,1,'','0560008335992',173,0) 30/01/2025 09:22:03.7723 934 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 09:26:59.9742 2721 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 09:27:52.3502 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:28:10.6814 637 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 09:28:10.9976 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:30:19.6846 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:33:08.5975 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:35:16.6461 1023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:35:34.2779 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:38:55.9616 948 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:39:30.1545 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:43:26.8717 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:45:04.4349 683 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 09:45:03' where traUID = 4844243833958840 and traStatus='V' and traEnabled=1 30/01/2025 09:45:12.7904 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:46:49.1128 812 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:48:30.0543 527 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 30/01/2025 09:53:13.8659 713 ms. EXEC: update payReceipt set recCreation = '2025-01-30 09:53:13',recModify = '2025-01-30 09:53:13',recUseId=0,recStatus='V' where recId = 347187 30/01/2025 09:56:40.2989 966 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 30/01/2025 09:57:14.9710 637 ms. EXEC: update payReceipt set recCreation = '2025-01-30 09:57:14',recModify = '2025-01-30 09:57:14',recUseId=0,recStatus='V' where recId = 347189 30/01/2025 09:57:22.0828 517 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-30 09:57:21','V',5157145300892290,2025,'2025-01-30 09:57:20','456853584000327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 30/01/2025 09:57:31.4430 1073 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 09:58:38.5148 1464 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-30 09:58:37',0,16,'2025-01-30 09:58:37','','Unauthorized Transit Entry 2') 30/01/2025 09:58:58.5883 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:59:45.7017 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 09:59:51.3505 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 10:00:09.5927 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 10:04:14.8646 816 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 10:04:33.7552 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 10:06:19.4228 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 10:07:15.6164 927 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 10:10:24.1754 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 10:16:51.7424 911 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 10:20:59.5970 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 10:21:00.3055 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 10:24:54.6971 1080 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 10:25:16.5787 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 10:32:28.4961 964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 10:33:27.0002 734 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 10:35:40.9948 4907 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 = 12 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 30/01/2025 10:50:10.2191 655 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 10:51:24.0345 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 10:51:46.8737 955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 10:52:50.6252 1966 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 10:52:48','V',5113927891647840,2025,'2025-01-30 10:52:48','456853438600327005012999',2,2,2,'O','',0,'2025-01-30 10:52:48',1,'','',0) 30/01/2025 10:57:05.2223 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:00:59.0295 777 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 11:01:06.4865 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:01:46.4512 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:03:11.0347 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:03:38.1619 507 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 11:06:56.5184 853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:08:24.3031 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:13:29.1698 594 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 11:13:28' where payTraUID = 4669356133340010 and payStatus='V' and payEnabled=1 30/01/2025 11:13:42.3066 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:14:33.7660 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:18:13.6859 2201 ms. EXEC: update paycash set casCreation = '2025-01-30 11:18:11',casModify = '2025-01-30 11:18:11',casUseId=0,casStatus='V' where casId = 207151 30/01/2025 11:19:38.9369 927 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:19:53.4336 1057 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 11:19:52' where traUID = 5554409779624430 and traStatus='V' and traEnabled=1 30/01/2025 11:19:57.1481 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:22:05.1886 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:24:51.1135 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:25:14.6102 881 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 11:25:35.3400 596 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/01/2025 11:27:15.0487 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:27:38.9346 513 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 30/01/2025 11:27:43.5147 649 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 11:27:45.3289 1356 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 11:27:43','V',5554038433598530,2025,'2025-01-30 11:27:42','456853575000327005012999',2,2,2,'O','',0,'2025-01-30 11:27:43',1,'','',0) 30/01/2025 11:27:46.7529 1412 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 11:27:47.8516 566 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 11:27:47' where traUID = 4693144062699610 and traStatus='V' and traEnabled=1 30/01/2025 11:28:09.9864 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:28:42.9234 1338 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 11:28:43.6989 770 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 11:30:43.5330 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:34:04.2131 1023 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentToConfirm' 30/01/2025 11:34:05.0957 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:34:07.6614 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:34:09.5456 604 ms. EXEC: update payReceipt set recCreation = '2025-01-30 11:34:08',recModify = '2025-01-30 11:34:08',recUseId=0,recStatus='V' where recId = 347227 30/01/2025 11:34:39.2025 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:37:18.2367 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:37:41.0080 546 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 11:39:18.0608 542 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 11:39:15',0,'V',4800584590133800,5585010476343140,2025,'2025-01-30 11:39:15',3,1,0,4,'2025-01-30 11:54:15','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 30/01/2025 11:40:47.8818 557 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 30/01/2025 11:41:08.1454 765 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 11:41:07','V',4683762895379140,2025,'2025-01-30 11:41:06','456854206600327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 11:41:08.8438 684 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 11:41:53.3856 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 11:42:15.9997 585 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 11:42:19.0968 785 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 11:42:18','V',4999212080875140,2025,'2025-01-30 11:42:14','456854047500327005012999',2,2,2,'O','',0,'2025-01-30 11:42:18',1,'','',0) 30/01/2025 11:43:23.7480 2092 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 400076 else acvFstPayId end),acvLstPayId = 400076 where acvSftId = 872 and acvCodeId = 3 30/01/2025 11:44:53.4069 1111 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 11:46:40.0151 1569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:47:38.3361 608 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 30/01/2025 11:49:21.8443 1007 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 11:49:20','V',5037706547880270,2025,'2025-01-30 11:49:18','456854255800327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 11:49:24.4560 2497 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 11:49:26.3483 1728 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 11:49:26.5064 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 11:49:36.2249 854 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 11:49:35','V',4845917330426810,2025,'2025-01-30 11:49:32','456854172400327005012999',2,2,2,'O','',0,'2025-01-30 11:49:35',1,'','',0) 30/01/2025 11:49:57.5711 631 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 11:50:04.2326 1230 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-30 11:50:03',0,16,'2025-01-30 11:50:03','','Unauthorized Transit Entry 2') 30/01/2025 11:50:17.2863 641 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 11:50:16' where payTraUID = 5568383583044440 and payStatus='V' and payEnabled=1 30/01/2025 11:50:24.3160 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:01:22.9563 800 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:01:58.5371 2255 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 400086 else acvFstPayId end),acvLstPayId = 400086 where acvSftId = 892 and acvCodeId = 3 30/01/2025 12:02:00.3393 1622 ms. EXEC: update tabTerminalReceipt set trcProgressive = 703, trcLastPrinted = '2500600703', trcLastDate = '2025-01-30 12:01:58' where trcStatus='V' and trcTerId = 17 30/01/2025 12:03:42.5756 778 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 12:03:41' where payTraUID = 5069847150702670 and payStatus='V' and payEnabled=1 30/01/2025 12:03:43.2821 705 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 12:03:41' where traUID = 5069847150702670 and traStatus='V' and traEnabled=1 30/01/2025 12:03:50.8421 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:04:16.0850 648 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 12:04:15' where traUID = 4696655074873760 and traStatus='V' and traEnabled=1 30/01/2025 12:04:56.7211 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:05:29.7782 804 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 12:05:28','V',5129217710037010,2025,'2025-01-30 12:05:27','456853936100327005012999',2,2,2,'O','',0,'2025-01-30 12:05:28',1,'','',0) 30/01/2025 12:11:57.3868 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:12:04.2244 529 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 12:12:03',0,'V',5198785445536110,5215163338059090,2025,'2025-01-30 12:12:03',18,1,0,4,'2025-01-30 12:27:03','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 12:12:16.3164 2527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 12:13:24.6351 529 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 12:13:27.6871 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:14:29.4234 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:15:37.4759 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:15:38.0983 557 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 12:15:37' where payTraUID = 4634585016056010 and payStatus='V' and payEnabled=1 30/01/2025 12:15:46.0786 1262 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 12:17:06.0280 546 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 12:17:13.5381 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 3 ms.) 30/01/2025 12:17:51.2292 1106 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-30 12:17:50',0,0,'V',5392805228874400,5037464935216160,2025,'2025-01-30 12:17:50',3,'KES',1,100,100,'N',''); 30/01/2025 12:18:09.4394 935 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:19:23.9882 1306 ms. EXEC: update payReceipt set recCreation = '2025-01-30 12:19:22',recModify = '2025-01-30 12:19:22',recUseId=0,recStatus='V' where recId = 347252 30/01/2025 12:19:42.8258 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:20:28.5984 799 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 12:21:31.8477 2101 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 12:21:29' where payTraUID = 5704071396738060 and payStatus='V' and payEnabled=1 30/01/2025 12:21:36.3097 852 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:22:54.0526 1170 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4231, trcLastPrinted = '2500704231', trcLastDate = '2025-01-30 12:22:52' where trcStatus='V' and trcTerId = 18 30/01/2025 12:23:05.1320 730 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 12:23:04' where payTraUID = 5753905726551290 and payStatus='V' and payEnabled=1 30/01/2025 12:23:27.5300 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:25:55.9241 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:25:59.8127 959 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 12:28:53.7169 901 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 12:28:53.9201 1065 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/01/2025 12:28:54.0932 1382 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:35:11.7617 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:35:27.2530 887 ms. EXEC: update abbCards set carLastDate = '2025-01-30 12:35:26',carLastDirection='O' where carStatus='V' and carId = 21 30/01/2025 12:35:33.3011 583 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 12:38:15.1943 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:38:49.5432 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:41:55.4304 546 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 12:41:54' where traUID = 5012592463856630 and traStatus='V' and traEnabled=1 30/01/2025 12:43:44.9864 608 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5602011027460210,4837764722896940,2025,'2025-01-30 12:43:44',' Date: 1/30/2025 12:43:43 PM Code: 456854240600327005012999 Entry Date: 1/30/2025 11:46:46 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 # 2500704238 ',0) 30/01/2025 12:43:50.2089 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:44:00.8900 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:44:21.2436 1144 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:45:39.0492 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:45:49.0779 869 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:47:16.2291 648 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 12:48:51.2286 1388 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5364815909355900,4913884785507250,2025,'2025-01-30 12:48:49','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/30/2025 12:01:58 PM Date : 1/30/2025 12:48:48 PM Code : 456854331800327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 30/01/2025 12:50:26.7605 529 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 12:50:25',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'; 30/01/2025 12:51:45.9134 1201 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 12:51:51.5531 1229 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:52:36.1870 771 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 12:53:11.0603 1430 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 12:49:43',12,'V',5107647821835190,5458195466936090,2025,'2025-01-30 12:49:43',17,1,0,4,'2025-01-30 13:04:43','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 12:53:12.1890 512 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5458195466936090,5107647821835190,2025,'2025-01-30 12:53:11',' Data: 1/30/2025 12:49:43 PM Codice: 456854604800327005012999 Ingresso: 1/30/2025 12:47:28 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 # 2500600708 ',0) 30/01/2025 12:53:12.8585 668 ms. EXEC: update payReceipt set recCreation = '2025-01-30 12:53:12',recModify = '2025-01-30 12:53:12',recUseId=0,recStatus='V' where recId = 347275 30/01/2025 12:53:12.8635 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:54:32.1855 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:54:46.9693 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 653 ms.) 30/01/2025 12:54:47.5277 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:54:51.9947 592 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 12:54:51',0,'V',5504918908508830,4842337212016100,2025,'2025-01-30 12:54:51',18,1,0,4,'2025-01-30 13:09:51','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 12:56:29.3728 801 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 12:56:28','V',5378068630283310,2025,'2025-01-30 12:56:27','456854547100327005012999',2,2,2,'O','',0,'2025-01-30 12:56:28',1,'','',0) 30/01/2025 12:56:51.7898 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 12:56:59.6330 536 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-30 12:56:59' where subId = 108 30/01/2025 12:57:05.5389 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 12:57:34.7795 639 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 12:57:31',0,'V',4746041496192600,5488622199745000,2025,'2025-01-30 12:57:31',3,1,0,4,'2025-01-30 13:12:31','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 30/01/2025 12:57:35.5960 531 ms. EXEC: update payReceipt set recCreation = '2025-01-30 12:57:35',recModify = '2025-01-30 12:57:35',recUseId=0,recStatus='V' where recId = 347279 30/01/2025 13:00:36.7161 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:02:10.8279 1543 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 30/01/2025 13:07:36.0503 607 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 30/01/2025 13:07:37.1180 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:09:33.2236 1964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:11:33.0386 529 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 13:11:32',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'; 30/01/2025 13:13:50.1422 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:14:44.7537 538 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 13:14:44' where traUID = 5763445242223330 and traStatus='V' and traEnabled=1 30/01/2025 13:15:47.3276 606 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 13:16:13.2629 682 ms. EXEC: update abbCards set carLastDate = '2025-01-30 13:16:12',carLastDirection='O' where carStatus='V' and carId = 164 30/01/2025 13:17:08.2376 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:24:15.1039 650 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 13:24:20.0372 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:24:21.0438 963 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 13:24:29.3614 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:25:51.7675 1036 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 13:26:15.9576 791 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:29:11.5476 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:30:04.8663 976 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 13:30:03','V',5659666767214340,2025,'2025-01-30 13:30:02','456854654600327005012999',2,2,2,'O','',0,'2025-01-30 13:30:03',1,'','',0) 30/01/2025 13:31:00.2263 594 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 13:30:59',0,'V',5416482881243980,5028603213605710,2025,'2025-01-30 13:30:59',18,1,0,4,'2025-01-30 13:45:59','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 30/01/2025 13:31:19.4881 782 ms. EXEC: update payReceipt set recCreation = '2025-01-30 13:31:18',recModify = '2025-01-30 13:31:18',recUseId=0,recStatus='V' where recId = 347297 30/01/2025 13:31:43.7283 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:33:00.8363 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:33:35.1593 587 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 13:33:34' where payTraUID = 5263374840197050 and payStatus='V' and payEnabled=1 30/01/2025 13:33:40.0186 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:37:08.9096 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:37:13.6488 835 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 13:38:10.5348 1463 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 30/01/2025 13:38:26.8117 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:38:26.8117 774 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 13:40:00.4372 684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:41:46.5111 787 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 13:41:47.4478 583 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 13:41:46' where traUID = 5656522380740250 and traStatus='V' and traEnabled=1 30/01/2025 13:43:52.4273 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:44:39.7549 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:47:34.9550 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:48:01.5938 781 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 13:48:00',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 30/01/2025 13:50:00.8515 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:51:46.6912 839 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:53:27.5736 2076 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 13:53:27.5986 2139 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentToConfirm' 30/01/2025 13:56:32.9730 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 13:56:46.6012 783 ms. EXEC: update abbCards set carLastDate = '2025-01-30 13:56:45',carLastDirection='O' where carStatus='V' and carId = 15 30/01/2025 13:56:48.3703 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:58:05.4739 1673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 13:58:18.0232 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:05:57.3045 507 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 14:06:20.2318 539 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 14:06:19' where traUID = 5046921928699630 and traStatus='V' and traEnabled=1 30/01/2025 14:06:24.0504 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:13:22.2960 597 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 14:13:21' where payTraUID = 4866510776322490 and payStatus='V' and payEnabled=1 30/01/2025 14:13:26.8681 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:14:42.4526 695 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:14:50.0326 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:14:57.9679 721 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 14:14:57',0,'V',5244444573062780,5349649962390760,2025,'2025-01-30 14:14:57',18,1,0,4,'2025-01-30 14:29:57','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 14:15:58.6375 1076 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:16:23.7563 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:16:33.8720 714 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5331237936297510,5064611303224710,2025,'2025-01-30 14:16:33',' Date: 1/30/2025 2:16:32 PM Code: 456855006300327001012999 Entry Date: 1/30/2025 1:54:23 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704256 ',0) 30/01/2025 14:19:52.1105 1486 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 14:19:50',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'; 30/01/2025 14:22:12.2421 1947 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 14:22:10','V',5182661546402710,2025,'2025-01-30 14:22:08','456855058100327005012999',2,2,2,'O','',0,'2025-01-30 14:22:10',1,'','',0) 30/01/2025 14:24:05.0751 702 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 14:24:28.5958 1012 ms. EXEC: update payReceipt set recCreation = '2025-01-30 14:24:27',recModify = '2025-01-30 14:24:27',recUseId=0,recStatus='V' where recId = 347324 30/01/2025 14:26:10.6640 691 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 14:26:09','V',4730620155063340,2025,'2025-01-30 14:26:07','456855196700327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 14:27:40.8903 1005 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 14:27:50.1685 613 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 14:28:20.5428 654 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 14:28:19',0,'V',5396350292023930,4746656515676530,2025,'2025-01-30 14:28:19',18,1,0,4,'2025-01-30 14:43:19','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 14:28:21.6085 759 ms. EXEC: update payReceipt set recCreation = '2025-01-30 14:28:20',recModify = '2025-01-30 14:28:20',recUseId=0,recStatus='V' where recId = 347327 30/01/2025 14:30:26.6791 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:33:10.4906 988 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:36:19.9452 4265 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 400193 else acvFstPayId end),acvLstPayId = 400193 where acvSftId = 872 and acvCodeId = 3 30/01/2025 14:40:11.1336 553 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 30/01/2025 14:40:15.8648 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:41:05.9883 544 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 14:41:38.5921 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:44:03.0781 794 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1338, trcLastPrinted = '2500401338', trcLastDate = '2025-01-30 14:44:02' where trcStatus='V' and trcTerId = 4 30/01/2025 14:44:54.9357 824 ms. EXEC: update abbCards set carLastDate = '2025-01-30 14:44:54',carLastDirection='I' where carStatus='V' and carId = 82 30/01/2025 14:45:00.4044 1590 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 14:45:41.5579 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:46:42.4085 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:47:32.8873 763 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 30/01/2025 14:47:33.6117 883 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 14:47:55.6835 941 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 14:47:54','V',5098991651604610,2025,'2025-01-30 14:47:54','456855327400327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 14:51:01.1404 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:51:32.2082 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:51:53.9317 642 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 30/01/2025 14:52:44.4044 958 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 14:52:43',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 14:52:43',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'; 30/01/2025 14:53:48.3281 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:54:02.9499 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:54:03.2161 808 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:54:18.7044 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:54:45.9446 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 14:55:53.0835 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:58:10.0981 969 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 14:59:18.4037 777 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 14:59:17',0,'V',5543392222530990,5115132570986250,2025,'2025-01-30 14:59:17',18,1,0,4,'2025-01-30 15:14:17','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 15:00:02.1389 787 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-30 15:00:01',0,0,'V',5661935958991410,5069084665102150,2025,'2025-01-30 15:00:01',3,'KES',1,50,50,'N',''); 30/01/2025 15:00:02.1399 762 ms. EXEC: update tabTerminalReceipt set trcProgressive = 720, trcLastPrinted = '2500600720', trcLastDate = '2025-01-30 15:00:01' where trcStatus='V' and trcTerId = 17 30/01/2025 15:00:02.8404 698 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5713074272298210,5536876813490830,2025,'2025-01-30 15:00:02',' Data: 1/30/2025 2:56:34 PM Codice: 456855210700327005012999 Ingresso: 1/30/2025 2:28:27 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 # 2500600720 ',0) 30/01/2025 15:00:02.8404 701 ms. EXEC: update paycash set casCreation = '2025-01-30 15:00:02',casModify = '2025-01-30 15:00:02',casUseId=0,casStatus='V' where casId = 207198 30/01/2025 15:00:10.4535 746 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 30/01/2025 15:00:11.0869 1035 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 15:00:12.8481 617 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 15:00:34.7877 1251 ms. EXEC: update tabTerminalReceipt set trcProgressive = 722, trcLastPrinted = '2500600722', trcLastDate = '2025-01-30 15:00:33' where trcStatus='V' and trcTerId = 17 30/01/2025 15:00:57.4789 1484 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 15:00:55' where traUID = 5713074272298210 and traStatus='V' and traEnabled=1 30/01/2025 15:01:06.3568 680 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 1 ms.) 30/01/2025 15:01:12.0366 647 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 15:01:11' where traUID = 5579350755668220 and traStatus='V' and traEnabled=1 (WAIT TIME 1 ms.) 30/01/2025 15:01:14.7925 541 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-30 15:01:14',0,2,'2025-01-30 15:01:14','','Manual Open Barrier Exit 1') 30/01/2025 15:01:20.1250 568 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 30/01/2025 15:02:21.3770 557 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 15:02:20','V',4819770639365810,2025,'2025-01-30 15:02:19','456855413900327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 15:03:26.6046 1119 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:03:52.6270 881 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 30/01/2025 15:04:08.2124 856 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 15:04:07' where traUID = 5069084665102150 and traStatus='V' and traEnabled=1 30/01/2025 15:05:39.4343 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:06:17.9491 2314 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 15:06:23.3797 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:06:40.4041 1678 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 15:06:38','V',5035240040233010,2025,'2025-01-30 15:06:37','456855234600327005012999',2,2,2,'O','',0,'2025-01-30 15:06:38',1,'','',0) 30/01/2025 15:07:09.7567 936 ms. EXEC: update paycash set casCreation = '2025-01-30 15:07:08',casModify = '2025-01-30 15:07:08',casUseId=0,casStatus='V' where casId = 207202 30/01/2025 15:07:11.3948 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:07:20.8601 1126 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 15:07:19','V',5657920061320780,2025,'2025-01-30 15:07:19','456855271400327005012999',2,2,2,'O','',0,'2025-01-30 15:07:19',1,'','',0) 30/01/2025 15:07:26.0906 1424 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:11:46.0493 552 ms. EXEC: update paycash set casCreation = '2025-01-30 15:11:45',casModify = '2025-01-30 15:11:45',casUseId=0,casStatus='V' where casId = 207203 30/01/2025 15:12:36.3769 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:12:44.6985 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:13:09.7426 611 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 15:14:22.4272 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-01-30 15:14:21','V',5615216947645010,2025,'2025-01-30 15:14:18','456855485800327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 15:14:43.1930 594 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 15:14:42',0,'V',4747024414811970,5324010669210440,2025,'2025-01-30 15:14:42',18,1,0,4,'2025-01-30 15:29:42','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 15:16:53.1889 503 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 15:18:22.3525 1115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:19:28.8649 1704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:19:41.0411 570 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 15:19:40' where traUID = 5137948967121230 and traStatus='V' and traEnabled=1 30/01/2025 15:19:56.1812 1817 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 30/01/2025 15:20:40.3827 969 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 15:20:39',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 15:20:39',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'; 30/01/2025 15:20:40.9571 573 ms. EXEC: update payInventory set invCreation = '2025-01-30 15:20:40',invModify = '2025-01-30 15:20:40',invUseId=0,invStatus='V' where invId = 234029 30/01/2025 15:22:40.1648 1358 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-30 15:22:38',4,9,'2025-01-30 15:22:38','456854141500327005012999','Payed (Credit Card ) Ticket ') 30/01/2025 15:23:06.8766 667 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 15:25:02.6520 735 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:26:34.6695 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:26:39.0064 1029 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 15:28:25.0687 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:28:28.3589 767 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 1 ms.) 30/01/2025 15:28:29.7819 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:29:54.9048 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:30:26.8251 639 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-30 15:30:26' where subId = 66 30/01/2025 15:30:28.6283 708 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 15:30:26',0,'V',4777279670680140,4853307621325940,2025,'2025-01-30 15:30:26',3,1,0,4,'2025-01-30 15:45:26','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 30/01/2025 15:30:28.7914 854 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 15:30:31.2160 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:32:25.6995 653 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 15:32:25' where payTraUID = 4853307621325940 and payStatus='V' and payEnabled=1 30/01/2025 15:34:14.2801 1191 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:35:35.1381 769 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 30/01/2025 15:36:32.2583 779 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 15:36:37.6529 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:37:34.2223 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:38:15.3408 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:38:33.4489 1365 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:41:17.6847 1544 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 15:41:16','V',4631191631137870,2025,'2025-01-30 15:41:14','456855647400327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 15:41:30.7924 732 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 15:41:29',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'; 30/01/2025 15:41:34.8241 1192 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:41:37.0906 797 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 15:42:32.7258 1651 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 30/01/2025 15:42:36.5544 736 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 15:45:21.3978 581 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 400243 else acvFstPayId end),acvLstPayId = 400243 where acvSftId = 872 and acvCodeId = 3 30/01/2025 15:48:02.7586 973 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 15:48:01','V',5159857263399900,2025,'2025-01-30 15:47:59','456855687900327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 15:48:14.2633 2973 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:48:29.2253 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:48:52.8711 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:48:55.9711 686 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 15:49:46.2948 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:52:11.5058 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:52:13.4011 758 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 15:52:12' where traUID = 5099627530930710 and traStatus='V' and traEnabled=1 30/01/2025 15:52:13.4851 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:52:16.4561 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:58:07.3366 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:58:18.1768 1030 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 15:58:57.7423 755 ms. EXEC: update abbCards set carLastDate = '2025-01-30 15:58:56',carLastDirection='I' where carStatus='V' and carId = 44 30/01/2025 15:58:59.4244 1427 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 15:58:59.4254 1364 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 15:59:05.4584 719 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 400248 else acvFstPayId end),acvLstPayId = 400248 where acvSftId = 872 and acvCodeId = 3 30/01/2025 16:04:12.5186 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:04:28.1751 1142 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 16:04:26' where traUID = 5566150382377930 and traStatus='V' and traEnabled=1 30/01/2025 16:06:37.6836 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:06:50.7083 574 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 16:06:59.9555 772 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:07:29.2000 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 16:09:36.1087 538 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 16:09:35','V',5488752692811530,2025,'2025-01-30 16:09:34','456855817400327001012999',1,2,1,'I','',1,0,1,'','',4) 30/01/2025 16:15:30.0062 514 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 16:16:43.1211 1752 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 16:16:41',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'; 30/01/2025 16:17:00.9000 604 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 16:17:01.7475 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:17:04.3703 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 16:18:04.4424 616 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4923194945485850,5062993362473130,2025,'2025-01-30 16:18:03',' Date: 1/30/2025 4:18:03 PM Code: 456855587200327005012999 Entry Date: 1/30/2025 3:31:12 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 # 2500704282 ',0) 30/01/2025 16:18:05.2359 755 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456855587200327005012999' 30/01/2025 16:18:26.7603 744 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 16:23:27.9526 692 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 16:23:27','V',5454418206910680,2025,'2025-01-30 16:23:26','456855900600327001012999',1,2,1,'I','',1,0,1,'','',4) 30/01/2025 16:23:28.4940 526 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 16:23:56.3035 1440 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 16:26:08.4448 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:26:29.7871 1182 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 16:27:08.6150 668 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 16:27:36.8829 654 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 16:27:37.7005 757 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:28:39.8730 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 16:30:06.7781 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:31:39.0848 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 16:33:17.6346 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 16:38:23.5270 1007 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 16:38:22' where traUID = 5513965653962090 and traStatus='V' and traEnabled=1 30/01/2025 16:38:24.3216 1296 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 16:39:43.3224 587 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 16:40:09.9672 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:45:52.2359 625 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4286, trcLastPrinted = '2500704286', trcLastDate = '2025-01-30 16:45:51' where trcStatus='V' and trcTerId = 18 30/01/2025 16:55:56.8779 598 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 16:55:57.9937 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:58:35.1547 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 16:58:45.9979 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 16:58:55.5843 1682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:00:43.3143 1988 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 17:01:25.3014 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:02:20.0390 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:04:38.9488 2194 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:04:50.9598 711 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 17:04:50',0,'V',4983128602153400,4819770639365810,2025,'2025-01-30 17:04:50',18,1,0,4,'2025-01-30 17:19:50','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 30/01/2025 17:05:21.7594 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:06:00.9306 1114 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:06:35.9380 529 ms. EXEC: update abbCards set carLastDate = '2025-01-30 17:06:35',carLastDirection='O' where carStatus='V' and carId = 29 30/01/2025 17:06:36.5053 564 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 30/01/2025 17:07:42.0731 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:11:04.5094 1460 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 17:11:02' where traUID = 5260931558913690 and traStatus='V' and traEnabled=1 30/01/2025 17:11:08.4451 928 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:11:09.1966 663 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 17:11:43.1613 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:13:57.4620 728 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 17:16:40.9012 600 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 17:16:40.9122 1022 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:16:44.2715 1254 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:19:11.6720 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:20:54.9369 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:21:41.7672 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:22:12.4587 1061 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:24:37.9979 592 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 17:24:59.2271 2411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:25:52.5768 677 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-01-30 17:25:51',0,'V',4689406256914590,5330823596448920,2025,'2025-01-30 17:25:51',2,1,0,-1,'2025-01-30 18:25:51','S','KES',0,0,0,'','','',3,0,0) 30/01/2025 17:28:01.0276 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:30:11.2877 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:36:53.0611 725 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:37:40.2697 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:38:09.1920 1674 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 17:38:45.8785 567 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 30/01/2025 17:38:48.2811 795 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/01/2025 17:39:08.3335 1461 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:40:56.4398 602 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5168502081929310,5555144192649530,2025,'2025-01-30 17:40:55',' Date: 1/30/2025 5:40:55 PM Code: 456855556200327005012999 Entry Date: 1/30/2025 3:26:02 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704296 ',0) 30/01/2025 17:41:22.9995 700 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 30/01/2025 17:42:14.3038 3497 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 17:42:10','V',4927415560639260,2025,'2025-01-30 17:42:09','456855556200327005012999',2,2,2,'O','',0,'2025-01-30 17:42:10',1,'','',0) 30/01/2025 17:42:56.1898 3200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:43:08.0097 2068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:43:10.6044 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:43:24.8579 2523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:43:24.8579 1464 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 30/01/2025 17:43:53.1538 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:44:06.7739 962 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:46:36.9883 1246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:48:17.4725 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:49:15.3712 1510 ms. EXEC: update abbCards set carLastDate = '2025-01-30 17:49:13',carLastDirection='O' where carStatus='V' and carId = 26 30/01/2025 17:49:42.2031 1656 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 17:50:54.6595 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-01-30 17:50:54','V',5222407709674670,2025,'2025-01-30 17:50:53','456856425300327001012999',1,2,1,'I','',1,0,1,'','',4) 30/01/2025 17:51:16.0048 2846 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 17:51:21.1682 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:52:22.7504 1846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:53:37.8806 3802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 17:53:38.0987 3678 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '836615' and traDirection='I' order by traId DESC LIMIT 1 30/01/2025 17:54:32.3160 659 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 17:55:04.8787 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:56:59.6454 504 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 17:56:59' where traUID = 5018629536300210 and traStatus='V' and traEnabled=1 30/01/2025 17:57:09.3219 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 17:57:27.3419 784 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-30 17:57:26','0230003950863',0,0,5525247062248140,158,'0000-00-00 00:00:00','0000-00-00 00:00:00') 30/01/2025 17:57:28.4807 1094 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 30/01/2025 18:06:18.6953 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 18:06:54.6884 1813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:08:54.8687 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:09:00.6155 565 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 18:09:00',0,'V',4949304976720220,4835541775888580,2025,'2025-01-30 18:09:00',18,1,0,4,'2025-01-30 18:24:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 18:14:12.6390 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:14:35.6184 937 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:16:17.0812 1286 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 18:17:08.1403 840 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 18:17:24.3381 729 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4301, trcLastPrinted = '2500704301', trcLastDate = '2025-01-30 18:17:23' where trcStatus='V' and trcTerId = 18 30/01/2025 18:17:33.2260 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:18:04.9923 530 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4302, trcLastPrinted = '2500704302', trcLastDate = '2025-01-30 18:18:04' where trcStatus='V' and trcTerId = 18 30/01/2025 18:18:05.7408 745 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5677349120825970,5096982042755540,2025,'2025-01-30 18:18:04',' Date: 1/30/2025 6:18:04 PM Code: 456856447000327005012999 Entry Date: 1/30/2025 5:54:30 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 # 2500704302 ',0) 30/01/2025 18:18:46.3159 1699 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 18:18:47.2375 754 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 18:19:06.1231 3242 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 18:19:06.7175 565 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 18:20:10.9925 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:21:19.1120 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:22:45.2195 607 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-30 18:22:44','0230003943530',0,0,4884437453429020,44,'0000-00-00 00:00:00','0000-00-00 00:00:00') 30/01/2025 18:22:45.8940 540 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 30/01/2025 18:22:48.6828 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:22:48.7069 1868 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCarId = 44 30/01/2025 18:22:56.5081 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 18:25:01.1804 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:25:23.9456 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:29:54.4574 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:30:44.7340 1628 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 30/01/2025 18:33:10.2982 707 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 18:33:09','V',4890488083568110,2025,'2025-01-30 18:33:08','456856678800327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 18:38:15.0064 550 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 18:38:14','V',4651508961332380,2025,'2025-01-30 18:38:14','456856402400327005012999',2,2,2,'O','',0,'2025-01-30 18:38:14',1,'','',0) 30/01/2025 18:38:15.5938 583 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 18:38:16.3733 579 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 18:38:15' where traUID = 4856341436826100 and traStatus='V' and traEnabled=1 30/01/2025 18:38:58.7966 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 18:39:12.6429 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:40:01.4885 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:40:23.4952 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:42:51.7953 1335 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 18:44:19.1717 1275 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:45:08.0113 2170 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 18:48:46.7715 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:51:12.2027 756 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 18:51:11','V',5183549145832070,2025,'2025-01-30 18:51:09','456856786900327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 18:51:12.2507 667 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4305, trcLastPrinted = '2500704305', trcLastDate = '2025-01-30 18:51:11' where trcStatus='V' and trcTerId = 18 30/01/2025 18:51:12.9932 740 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5236911238181460,5149347500512080,2025,'2025-01-30 18:51:12',' Date: 1/30/2025 6:51:11 PM Code: 456856075000327005012999 Entry Date: 1/30/2025 4:52:30 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704305 ',0) 30/01/2025 18:51:12.9932 720 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 18:51:18.8732 538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/01/2025 18:52:07.0424 870 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 18:52:06','V',5561360191903310,2025,'2025-01-30 18:52:05','456856663500327005012999',2,2,2,'O','',0,'2025-01-30 18:52:06',1,'','',0) 30/01/2025 18:52:14.5133 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 18:54:44.1934 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 18:54:56.7217 575 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 18:55:04.4949 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 19:01:40.3004 967 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 19:07:54.3434 873 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-30 19:07:52',0,'V',5360418734517720,5072509602290960,2025,'2025-01-30 19:07:52',18,1,0,4,'2025-01-30 19:22:52','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/01/2025 19:08:13.0078 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:09:53.1818 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:10:28.8996 591 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 19:10:34.8506 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 19:10:35.6341 1031 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 19:10:42.9130 1102 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 19:10:54.3396 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 19:11:02.3130 774 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 30/01/2025 19:11:52.5095 1017 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4309, trcLastPrinted = '2500704309', trcLastDate = '2025-01-30 19:11:51' where trcStatus='V' and trcTerId = 18 30/01/2025 19:12:42.3758 938 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 19:14:44.2243 613 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 19:17:06.1451 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:20:58.8460 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:21:48.5863 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:22:28.9432 509 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 30/01/2025 19:24:55.3020 1473 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:25:42.2034 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:26:20.7742 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:26:39.8899 1046 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 19:26:38','V',4770934030688930,2025,'2025-01-30 19:26:38','456856999800327005012999',1,2,16,'I','',1,0,1,'','',4) 30/01/2025 19:28:05.7233 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:31:39.3070 1335 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:33:48.8156 806 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 19:33:48','V',5580489166032750,2025,'2025-01-30 19:33:47','456856776700327005012999',2,2,2,'O','',0,'2025-01-30 19:33:48',1,'','',0) 30/01/2025 19:33:53.8459 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 19:38:49.9388 706 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 19:39:27.9272 580 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/01/2025 19:41:03.2148 1347 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:41:29.6615 2387 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:41:29.7586 1600 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 30/01/2025 19:42:22.7480 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:43:31.4479 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:43:31.8862 564 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 19:43:31','V',5347826160379420,2025,'2025-01-30 19:43:30','456856928300327005012999',2,2,2,'O','',0,'2025-01-30 19:43:31',1,'','',0) 30/01/2025 19:50:03.8731 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 19:55:22.0597 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 19:58:04.2051 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:58:11.8152 3724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 19:58:55.0701 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 19:59:09.5548 543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 30/01/2025 20:05:29.6758 1430 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 20:05:43.9413 969 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:05:48.1251 637 ms. EXEC: update payReceipt set recCreation = '2025-01-30 20:05:47',recModify = '2025-01-30 20:05:47',recUseId=0,recStatus='V' where recId = 347441 30/01/2025 20:06:17.4727 1303 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 20:06:16' where payTraUID = 5313207056095780 and payStatus='V' and payEnabled=1 30/01/2025 20:06:19.8483 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 20:08:57.4856 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:09:23.2649 603 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 20:09:22' where payTraUID = 5066236240629130 and payStatus='V' and payEnabled=1 30/01/2025 20:09:23.9673 702 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 20:09:22' where traUID = 5066236240629130 and traStatus='V' and traEnabled=1 30/01/2025 20:09:30.4917 775 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 20:10:12.1645 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 20:14:59.5145 940 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 20:14:58' where payTraUID = 5724178302879000 and payStatus='V' and payEnabled=1 30/01/2025 20:15:00.3441 824 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 20:14:58' where traUID = 5724178302879000 and traStatus='V' and traEnabled=1 30/01/2025 20:15:10.3468 4983 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 20:15:11.3965 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 20:15:19.6100 1573 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 20:15:23.7978 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:15:38.3535 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:16:10.9413 1447 ms. EXEC: update payReceipt set recCreation = '2025-01-30 20:16:09',recModify = '2025-01-30 20:16:09',recUseId=0,recStatus='V' where recId = 347446 30/01/2025 20:17:40.5201 560 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 20:17:39' where payTraUID = 4964919968488380 and payStatus='V' and payEnabled=1 30/01/2025 20:17:45.9438 1273 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/01/2025 20:18:35.9892 1573 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 20:18:34',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 20:18:34',3,42101,0,500,-1,-500,1,'O','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'; 30/01/2025 20:18:37.2941 1294 ms. EXEC: update payInventory set invCreation = '2025-01-30 20:18:35',invModify = '2025-01-30 20:18:35',invUseId=0,invStatus='V' where invId = 234064 30/01/2025 20:22:49.9959 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:22:50.0490 762 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5633483485158100,5443075339620460,2025,'2025-01-30 20:22:49','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/30/2025 7:46:57 PM Date : 1/30/2025 8:22:47 PM Code : 456857121700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 30/01/2025 20:25:16.9381 740 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 20:26:23.3155 1728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:28:07.0598 624 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-30 20:28:06','V',5446877151696680,2025,'2025-01-30 20:28:05','456857368500327001012999',1,2,1,'I','',1,0,1,'','',4) 30/01/2025 20:29:03.7107 1038 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:29:54.0403 1741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:30:26.0407 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:30:48.7999 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:33:49.7638 712 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 20:43:32.5482 1044 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:45:45.4150 623 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-30 20:45:44',1,2,'2025-01-30 20:45:44','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 30/01/2025 20:48:22.7582 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:48:22.7672 568 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 20:48:54.1311 518 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 30/01/2025 20:49:49.4451 853 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 20:50:47.4959 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:50:51.5096 3108 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 20:52:59.4280 687 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 20:57:52.6170 931 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 20:58:01.8782 615 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-30 20:58:01',4,9,'2025-01-30 20:58:01','456856853800327005012999','Payed (Credit Card ) Ticket ') 30/01/2025 21:00:16.0088 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:10:02.5647 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:13:52.2092 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:13:52.9077 508 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5222407709674670,5413824158201210,2025,'2025-01-30 21:13:52',' Date: 1/30/2025 9:13:52 PM Code: 456856425300327001012999 Entry Date: 1/30/2025 5:50:53 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 200.00 KES ______________________________ Paid: 200.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500704326 ',0) 30/01/2025 21:15:58.9629 1173 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 21:16:27.7311 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 21:18:15.2390 878 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 21:18:43.1666 577 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 21:23:58.3712 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 21:24:48.8580 602 ms. EXEC: update payReceipt set recCreation = '2025-01-30 21:24:48',recModify = '2025-01-30 21:24:48',recUseId=0,recStatus='V' where recId = 347465 30/01/2025 21:24:50.2419 1372 ms. OPEN: select * from payCurInventory where curTerId = 18 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 30/01/2025 21:26:02.0489 807 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 21:26:01' where payTraUID = 5030222517055400 and payStatus='V' and payEnabled=1 30/01/2025 21:27:06.8262 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:27:16.3746 2244 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/01/2025 21:33:11.0936 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:33:22.3381 1450 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-30 21:33:20' where traUID = 4806815788287340 and traStatus='V' and traEnabled=1 30/01/2025 21:38:11.1621 1887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:38:29.1992 526 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 21:38:35.1751 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 21:40:08.3824 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:40:11.2003 887 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-01-30 21:40:10',0,'V',4974446639226970,5408145767319640,2025,'2025-01-30 21:40:10',2,1,0,-1,'2025-01-30 22:40:10','S','KES',0,0,0,'','','',3,0,0) 30/01/2025 21:40:11.9988 519 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 21:40:25.4078 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:40:46.9862 1536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:42:08.2956 507 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 30/01/2025 21:42:08.4477 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:42:09.9947 1040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:43:21.8187 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:44:28.4842 568 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/01/2025 21:44:34.8655 509 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/01/2025 21:44:34.9876 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 21:49:15.0878 710 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-30 21:49: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'; 30/01/2025 21:49:15.6071 518 ms. EXEC: update payInventory set invCreation = '2025-01-30 21:49:15',invModify = '2025-01-30 21:49:15',invUseId=0,invStatus='V' where invId = 234073 30/01/2025 21:50:02.3433 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 21:50:05.6365 1985 ms. EXEC: update abbCards set carLastDate = '2025-01-30 21:50:03',carLastDirection='O' where carStatus='V' and carId = 112 30/01/2025 21:50:33.7703 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 21:51:54.1651 1120 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:51:56.0583 562 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/01/2025 21:57:54.3858 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 21:57:55.5976 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:59:16.6367 1717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 21:59:50.9957 2379 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-30 21:59:48' where payTraUID = 5753748009497890 and payStatus='V' and payEnabled=1 30/01/2025 22:02:26.5276 21334 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 22:03:22.4030 3361 ms. EXEC: update payReceipt set recCreation = '2025-01-30 22:03:19',recModify = '2025-01-30 22:03:19',recUseId=0,recStatus='V' where recId = 347477 30/01/2025 22:04:13.8693 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 22:04:52.3781 9808 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 30/01/2025 22:05:37.6333 11293 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 22:07:10.5684 12753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 22:07:21.9710 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 22:07:27.0324 4454 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 22:07:51.9411 16577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 22:09:20.5543 16285 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/01/2025 22:09:44.6614 9620 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 30/01/2025 22:11:39.2930 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/01/2025 22:12:57.6013 48737 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 22:18:40.4763 26616 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 30/01/2025 22:18:40.5493 26395 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 34 ms.) 30/01/2025 22:18:40.5503 26443 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 35 ms.) 30/01/2025 22:18:41.1245 558 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 30/01/2025 22:18:41.3897 837 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 22:18:41.3917 839 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/01/2025 22:18:41.8759 738 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 30/01/2025 22:18:42.7764 676 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 30/01/2025 22:18:42.7764 676 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 30/01/2025 22:18:44.0963 639 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode (WAIT TIME 211 ms.) 30/01/2025 22:18:49.5528 6181 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 30/01/2025 22:18:52.3497 2600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/01/2025 22:18:54.3478 1997 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); 30/01/2025 22:19:05.1355 1739 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456785228900327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 30/01/2025 22:19:35.1616 753 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456857212700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 30/01/2025 22:22:13.2596 15253 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 = 12 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 30/01/2025 22:23:20.8163 2623 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 = 9 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 30/01/2025 22:42:55.0283 2889 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc