25/01/2025 00:00:42.1278 921 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:03:10.1764 694 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 00:03:16.7859 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 00:03:37.5097 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:06:53.5946 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:08:39.2088 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:13:58.0879 1355 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 25/01/2025 00:16:09.1689 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:19:13.2119 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:21:00.8650 2117 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:21:42.2699 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:22:19.4440 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:26:28.1857 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:31:49.6490 885 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:35:41.0235 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:38:49.4480 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 00:42:46.4511 2091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:46:31.7967 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:47:54.5245 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 00:53:37.4989 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:06:31.4882 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:12:10.4730 1423 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/01/2025 01:12:32.6611 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:12:38.8743 1970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:15:29.5193 1683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:16:28.0604 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:17:12.2047 3346 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:20:05.7071 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:20:30.1595 1474 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:23:12.8013 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:26:09.4900 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:26:55.9279 1272 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:28:46.2640 1262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:29:15.6374 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:32:31.4320 1251 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 25/01/2025 01:39:04.9393 1614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:41:52.7718 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:47:35.0129 1281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:50:36.0940 1562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 01:56:00.8856 1183 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:02.7721 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:05.4989 899 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:10.7955 1534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:13.7756 1353 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:16.4214 1176 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:25.3334 3404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:30.9262 1496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:36.6681 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:40.0715 1250 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:43.7910 1213 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:49.1976 1698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:51.5873 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:00:54.6123 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:06:02.2184 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:12:45.2731 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:18:21.5248 1279 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:25:47.8320 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:28:57.0278 1972 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 25/01/2025 02:31:40.0478 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:38:03.1255 1381 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:41:06.4828 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:42:34.3639 3123 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:42:39.1620 600 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 02:42:38' where traUID = 4740763909195410 and traStatus='V' and traEnabled=1 25/01/2025 02:45:41.9427 1343 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:46:26.6181 934 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:47:22.1407 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:47:32.3176 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:47:39.1952 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:50:37.0939 2181 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:53:14.0484 2157 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:54:58.8251 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:56:49.7382 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:58:57.2333 1538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:59:50.3391 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 02:59:57.1167 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:05:44.0343 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:07:28.8115 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:09:12.6123 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:11:56.3716 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:18:00.7910 1882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:19:33.7274 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:21:54.7799 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:29:59.8839 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:31:44.0471 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:31:44.5835 1240 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 03:33:06.2391 1864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:37:22.0426 544 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 25/01/2025 03:40:14.5909 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:43:06.1234 721 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 25/01/2025 03:43:40.6193 1618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:44:08.7660 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:45:16.1535 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:45:21.8462 1129 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:45:25.0994 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 03:46:07.7885 833 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 03:50:41.6667 721 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 25/01/2025 03:54:27.4320 1414 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 25/01/2025 03:56:36.6498 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:01:26.9056 2232 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:03:37.4811 1653 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 25/01/2025 04:05:20.1757 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:06:51.1453 540 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/01/2025 04:15:37.3949 1723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:18:59.8722 1876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:19:22.5512 1931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:19:25.2180 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:20:43.8030 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:21:58.5683 670 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 25/01/2025 04:21:58.5693 659 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/01/2025 04:22:10.4001 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:24:02.0982 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:26:12.7338 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:26:30.5959 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:26:49.7319 2580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:26:51.9153 759 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/01/2025 04:26:57.0918 2574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:27:02.9518 3467 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:27:02.9518 1888 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 25/01/2025 04:27:06.7454 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:27:11.8378 712 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/01/2025 04:27:14.1164 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:27:46.0619 3484 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 04:27:49.5083 2055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:27:53.6210 3362 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 25/01/2025 04:28:06.1175 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:31:58.9656 624 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 04:33:11.3145 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:38:12.4562 882 ms. EXEC: update payReceipt set recCreation = '2025-01-25 04:38:11',recModify = '2025-01-25 04:38:11',recUseId=0,recStatus='V' where recId = 345585 25/01/2025 04:38:13.8401 1136 ms. EXEC: update paycash set casCreation = '2025-01-25 04:38:12',casModify = '2025-01-25 04:38:12',casUseId=0,casStatus='V' where casId = 206507 25/01/2025 04:38:38.2867 2381 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:41:10.5384 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:41:14.7512 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:41:24.2756 1589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:41:29.3830 3789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:41:32.4151 1345 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:41:42.7850 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:42:21.5369 3775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:42:39.8291 4020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:44:28.2192 719 ms. OPEN: select * from tabParameters order by parId desc limit 1 25/01/2025 04:57:31.5918 765 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5171786446521200,5358643113762350,2025,'2025-01-25 04:57:30','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/25/2025 4:44:26 AM Date : 1/25/2025 4:57:27 AM Code : 456801706600327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 100.00 KES',0) 25/01/2025 04:58:42.0555 1896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 04:59:36.2690 698 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside - 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 25/01/2025 04:59:38.8087 1776 ms. EXEC: update tabArea set areFreePark = areTotalPark where areStatus='V' and areTotalPark > 0 and areFreePark>areTotalPark 25/01/2025 04:59:44.4215 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 05:01:22.4882 1956 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:08:17.5995 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:10:27.8447 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:12:16.1867 1308 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:13:28.3194 764 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 25/01/2025 05:21:09.1659 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:21:14.1372 640 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 25/01/2025 05:21:31.5078 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:21:34.9561 1358 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:22:16.9721 1467 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 25/01/2025 05:24:27.1795 1485 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/01/2025 05:24:49.1060 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:28:58.6581 1888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:33:34.0079 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:34:11.5814 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:35:12.8779 2111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:35:50.2231 1466 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:35:57.9303 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:48:58.6540 3036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:56:19.2218 2797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:56:32.8920 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:56:40.4481 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:56:41.6529 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:56:44.3547 1988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:56:48.8668 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:58:59.9238 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 05:59:40.9402 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 06:01:13.1456 503 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 06:01:13.9851 567 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 06:01:15.3891 1397 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/01/2025 06:01:29.1162 2161 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-25 06:01:26',0,16,'2025-01-25 06:01:26','','Unauthorized Transit Entry 2') 25/01/2025 06:01:52.3015 3111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 06:10:16.6057 632 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 06:10:15',3,42101,0,500,1,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 25/01/2025 06:10:52.0614 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 06:12:11.9795 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 06:21:08.3876 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 06:24:40.5061 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 06:32:44.2618 881 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-25 06:32:43','V',4817807682536730,2025,'2025-01-25 06:32:42','456802356200327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 06:38:32.8791 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 06:39:48.2457 1076 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/01/2025 06:47:15.9663 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 06:55:29.9631 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:17:29.1346 1004 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:23:09.3770 628 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 1 ms.) 25/01/2025 07:28:06.6260 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 07:28:13.0060 1353 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:29:54.3713 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:30:07.0413 575 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/01/2025 07:37:01.4421 1565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:38:02.6799 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:38:06.3242 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:38:33.3003 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:39:25.0532 792 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/01/2025 07:41:48.7012 1656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:48:00.4250 2202 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 07:49:21.6908 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:51:25.9036 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 07:59:41.0216 699 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 08:00:41.5419 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:03:07.1993 525 ms. EXEC: update payCurInventory set curQuantity=0,curAmount=0 where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 25/01/2025 08:03:08.7063 1506 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,50,-2,-100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,50,2,100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,100,-28,-2800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,100,28,2800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,200,-19,-3800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,200,19,3800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-25 07:59:38',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 25/01/2025 08:03:24.0330 1757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:03:45.6067 758 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-25 08:03:44',0,3,'2025-01-25 08:03:44','0230003944086','POF - User Transit Supervisor Supervisor') 25/01/2025 08:04:01.7939 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 08:04:59.3054 518 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/01/2025 08:16:53.4913 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:28:39.6942 503 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/01/2025 08:32:48.7171 542 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 08:32:48',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'; 25/01/2025 08:33:25.4173 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 08:34:36.3283 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:35:47.9997 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 46 ms.) 25/01/2025 08:35:49.0164 677 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-25 08:35:48','V',4878562373434880,2025,'2025-01-25 08:35:46','456802899400327005012999',2,2,2,'O','',0,'2025-01-25 08:35:48',1,'','',0) 25/01/2025 08:39:42.5365 1506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:41:19.8842 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:41:27.6851 588 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 08:42:43.6193 614 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 08:45:08.2520 758 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-25 08:45:07','V',4954510261565420,2025,'2025-01-25 08:45:06','456803150600327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 08:45:09.7069 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:45:45.6437 814 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 08:46:48.4926 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:47:36.3539 759 ms. EXEC: update paycash set casCreation = '2025-01-25 08:47:35',casModify = '2025-01-25 08:47:35',casUseId=0,casStatus='V' where casId = 206518 25/01/2025 08:49:09.7722 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 08:50:35.7047 527 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-25 08:50:33',0,'V',5640605984012600,4954510261565420,2025,'2025-01-25 08:50:33',3,1,0,4,'2025-01-25 09:05:33','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 25/01/2025 08:52:09.4401 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:52:20.4871 789 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 08:53:46.4466 1587 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 25/01/2025 08:55:04.0038 1029 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 08:59:57.1247 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:00:29.9555 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:02:31.8428 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:05:09.8139 600 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-25 09:05:09','V',4894636790922950,2025,'2025-01-25 09:05:09','456803270900327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 09:07:37.8778 548 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 09:08:05.6314 703 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-25 09:08:04','V',5064149458063970,2025,'2025-01-25 09:08:04','456803288400327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 09:08:12.7159 529 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 25/01/2025 09:08:18.9749 1906 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 09:08:20.6079 943 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-25 09:08:19','V',5303574449437100,2025,'2025-01-25 09:08:19','456803289900327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 09:08:25.1648 583 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-25 09:08:24',0,'V',4850847591949010,4900185944836320,2025,'2025-01-25 09:08:24',18,1,0,4,'2025-01-25 09:23:24','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/01/2025 09:08:26.0434 802 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3513, trcLastPrinted = '2500703513', trcLastDate = '2025-01-25 09:08:25' where trcStatus='V' and trcTerId = 18 25/01/2025 09:08:26.7658 551 ms. EXEC: update payReceipt set recCreation = '2025-01-25 09:08:26',recModify = '2025-01-25 09:08:26',recUseId=0,recStatus='V' where recId = 345607 25/01/2025 09:08:52.4141 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 09:09:11.3211 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:20:49.2016 1081 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 25/01/2025 09:21:05.0086 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:21:05.1317 863 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 09:21:28.3334 2563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:22:20.4435 1041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:22:27.6811 1049 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 09:22:28.7808 1099 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); 25/01/2025 09:23:55.4247 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:24:35.5291 570 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 09:25:10.1341 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:35:46.7190 557 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 09:35:46.8521 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 09:35:47.2063 1041 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/01/2025 09:36:44.9279 1236 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5185958084126220,5085590067060420,2025,'2025-01-25 09:36:43','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/25/2025 9:18:41 AM Date : 1/25/2025 9:36:42 AM Code : 456803352100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 25/01/2025 09:38:29.4252 877 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 09:38:29.5953 1051 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 09:38:31.6056 533 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-25 09:38:31','V',5713202243746470,2025,'2025-01-25 09:38:30','456803471000327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 09:40:21.6404 938 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 09:42:16.2961 1111 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 09:42:20.8319 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 09:47:14.9164 1004 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 09:47:26.5658 714 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/01/2025 09:48:13.4065 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:48:51.4366 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:49:41.8466 553 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 09:49:41',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'; 25/01/2025 09:50:19.3084 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 09:51:28.3772 1006 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-25 09:51:27','0230004098588',0,0,4969328680475350,183,'0000-00-00 00:00:00','0000-00-00 00:00:00') 25/01/2025 09:51:32.2806 1748 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 09:51:30' where payTraUID = 5475345261727740 and payStatus='V' and payEnabled=1 25/01/2025 09:51:38.7968 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 09:58:06.5326 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 10:03:16.4281 3379 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-25 10:03:12',0,'V',4974663453256590,5009420157819530,2025,'2025-01-25 10:03:12',3,1,0,4,'2025-01-25 10:18:12','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 25/01/2025 10:04:31.3797 4381 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-25 10:04:26','V',5656626065747150,2025,'2025-01-25 10:04:26','456803258300327005012999',2,2,2,'O','',0,'2025-01-25 10:04:26',1,'','',0) 25/01/2025 10:05:12.7249 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 861 ms.) 25/01/2025 10:05:13.5664 766 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-25 10:05:12','V',5470527600582450,2025,'2025-01-25 10:05:05','456803496100327005012999',2,2,2,'O','',0,'2025-01-25 10:05:12',1,'','',0) 25/01/2025 10:06:52.7493 733 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-25 10:06:52','V',4954046966233310,2025,'2025-01-25 10:06:50','456803641000327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 10:07:47.6251 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:08:06.0938 1278 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 10:11:14.5143 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:15:11.5173 759 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 10:17:12.6091 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:17:40.4678 1500 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 10:22:43.9128 513 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 25/01/2025 10:24:09.7022 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:26:28.5002 611 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 10:27:16.3285 677 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 10:32:55.9509 594 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 10:33:14.8329 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:33:51.1609 964 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-25 10:33:50','V',5655062061803170,2025,'2025-01-25 10:33:48','456803802800327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 10:35:27.6551 526 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3527, trcLastPrinted = '2500703527', trcLastDate = '2025-01-25 10:35:27' where trcStatus='V' and trcTerId = 18 (WAIT TIME 57 ms.) 25/01/2025 10:47:28.7448 1384 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-25 10:47:27','V',4920994645729050,2025,'2025-01-25 10:47:26','456803644900327001012999',2,2,2,'O','',0,'2025-01-25 10:47:27',1,'','',0) 25/01/2025 10:47:29.2852 537 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 10:47:29.9726 606 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 10:47:29' where traUID = 4663301680022820 and traStatus='V' and traEnabled=1 25/01/2025 10:47:31.8158 849 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-25 10:47:30','V',5697190927312390,2025,'2025-01-25 10:47:30','456803885000327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 10:48:13.3301 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 10:49:03.4269 649 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-25 10:49:02',17,12,'2025-01-25 10:49:02','456803784000327005012999','Pagato (Contanti ) Biglietto ') 25/01/2025 10:49:53.8288 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:50:21.6435 574 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-25 10:50:21','V',4960730184101990,2025,'2025-01-25 10:50:20','456803902000327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 10:50:22.5810 526 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 10:51:41.0398 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:52:21.8107 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:52:21.8147 769 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 832396 25/01/2025 10:52:50.8821 1273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 10:53:32.0622 593 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 10:55:25.6682 717 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 10:55:31.4799 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 10:58:20.0598 1230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:00:21.2277 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:01:13.2486 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 11:04:21.1108 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 11:04:28.9097 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:08:25.8069 832 ms. OPEN: select * from tabTerminal where terId = 2 25/01/2025 11:08:34.0442 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 11:09:14.8050 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:10:29.1792 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:10:29.1812 1576 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-25 11:07:06',12,'V',5158695244176870,5061135780374980,2025,'2025-01-25 11:07:06',17,1,0,4,'2025-01-25 11:22:06','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/01/2025 11:11:29.8797 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:12:18.5095 555 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-25 11:12:17','V',4898727145321270,2025,'2025-01-25 11:12:16','456803879000327005012999',2,2,2,'O','',0,'2025-01-25 11:12:17',1,'','',0) 25/01/2025 11:12:23.7288 1181 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 11:13:37.7517 716 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5403996412653300,4705990827491020,2025,'2025-01-25 11:13:37',' Date: 1/25/2025 11:13:36 AM Code: 456803703900327005012999 Entry Date: 1/25/2025 10:17:19 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 # 2500703536 ',0) 25/01/2025 11:17:40.7729 954 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-25 11:17:39','V',5345451445247040,2025,'2025-01-25 11:17:39','456803778300327005012999',2,2,2,'O','',0,'2025-01-25 11:17:39',1,'','',0) 25/01/2025 11:17:41.4533 677 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 11:17:42.1047 644 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 11:17:43.3085 630 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 11:17:42' where traUID = 4694282026043130 and traStatus='V' and traEnabled=1 25/01/2025 11:19:27.5205 777 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 11:19:52.5674 529 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-25 11:19:52','V',5507390782395440,2025,'2025-01-25 11:19:51','456804079100327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 11:23:38.8149 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:24:06.6786 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:25:33.1244 1282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:27:40.8504 503 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 11:29:05.3940 1246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:29:48.2412 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:29:52.4438 858 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-25 11:29:51','V',4993667572502600,2025,'2025-01-25 11:29:50','456803873000327005012999',2,2,2,'O','',0,'2025-01-25 11:29:51',1,'','',0) 25/01/2025 11:34:30.3120 923 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1045, trcLastPrinted = '2500401045', trcLastDate = '2025-01-25 11:34:29' where trcStatus='V' and trcTerId = 4 25/01/2025 11:34:54.9516 1333 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 11:35:23.2366 646 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 11:35:22' where traUID = 4830606138942590 and traStatus='V' and traEnabled=1 25/01/2025 11:35:23.9100 672 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 832436 25/01/2025 11:37:50.8072 1480 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 11:37:49' where payTraUID = 5049759056578080 and payStatus='V' and payEnabled=1 25/01/2025 11:38:45.2227 824 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-25 11:38:44','V',4690304224367110,2025,'2025-01-25 11:38:43','456804192300327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 11:40:28.8224 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 11:44:32.3158 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:46:17.2683 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:46:23.2521 1225 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-25 11:46:22','V',5421010641578060,2025,'2025-01-25 11:46:21','456804238100327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 11:47:24.8622 1454 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:48:40.3630 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:48:45.1821 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:49:48.0290 1830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:50:29.0460 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 11:53:19.1358 820 ms. OPEN: select * from tabTerminal where terId = 2 25/01/2025 11:53:27.7153 1095 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 11:54:05.9375 658 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-25 11:54:05','V',4690847598452990,2025,'2025-01-25 11:54:03','456804284300327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 11:54:06.7000 700 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 11:55:21.9337 530 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 11:55:21' where traUID = 5481673370499330 and traStatus='V' and traEnabled=1 25/01/2025 11:55:30.1539 1908 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); 25/01/2025 11:55:32.8926 2546 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 11:59:44.7871 589 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 25/01/2025 11:59:49.5842 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:00:56.9229 2197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:02:02.0181 650 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 3 and payDateTime = '2025-01-25 12:01:57' nr: 0 25/01/2025 12:02:02.8787 859 ms. EXECSCALAR: SELECT COUNT(*) FROM payPayment INNER JOIN movTransit ON traUID = payTrauid WHERE payStatus='V' AND payPayed=0 AND payAmount=0 AND payDiscount = 100 AND payDiscountType = 1 AND traStatus='V' AND traEnabled = 1 AND traCode = '456804079100327005012999' nr: 0 25/01/2025 12:02:06.9443 5651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:02:07.7148 770 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); 25/01/2025 12:02:16.8145 528 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-25 12:02:16',0,2,'2025-01-25 12:02:16','0230003944086','Exit 1 - User Transit Supervisor Supervisor') 25/01/2025 12:02:50.7841 600 ms. EXEC: update tabTerminalReceipt set trcProgressive = 540, trcLastPrinted = '2500600540', trcLastDate = '2025-01-25 12:02:50' where trcStatus='V' and trcTerId = 17 25/01/2025 12:02:51.5165 571 ms. EXEC: update payReceipt set recCreation = '2025-01-25 12:02:50',recModify = '2025-01-25 12:02:50',recUseId=0,recStatus='V' where recId = 345669 25/01/2025 12:02:54.4584 908 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100 25/01/2025 12:03:43.7487 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:06:51.1855 606 ms. EXEC: update payReceipt set recCreation = '2025-01-25 12:06:50',recModify = '2025-01-25 12:06:50',recUseId=0,recStatus='V' where recId = 345672 25/01/2025 12:07:45.5800 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:08:06.9496 545 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-25 12:08:06','V',5107442835571160,2025,'2025-01-25 12:08:04','456804216900327005012999',2,2,2,'O','',0,'2025-01-25 12:08:06',1,'','',0) 25/01/2025 12:10:39.2171 529 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1047, trcLastPrinted = '2500401047', trcLastDate = '2025-01-25 12:10:38' where trcStatus='V' and trcTerId = 4 25/01/2025 12:11:20.6674 510 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 12:14:23.0551 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:15:25.4506 1210 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 12:15:26.0580 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:16:45.0701 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:19:37.0241 579 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5309309363525580,4830217884413520,2025,'2025-01-25 12:19:36','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/25/2025 11:59:53 AM Date : 1/25/2025 12:19:35 PM Code : 456804319300327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 25/01/2025 12:19:38.1178 520 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 12:19:37',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'; 25/01/2025 12:19:38.2980 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:20:06.4818 574 ms. EXEC: update payReceipt set recCreation = '2025-01-25 12:20:05',recModify = '2025-01-25 12:20:05',recUseId=0,recStatus='V' where recId = 345681 25/01/2025 12:20:46.8154 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:22:08.1150 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:24:39.5520 1112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:25:32.1904 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:27:07.1015 886 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 12:28:09.0398 727 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-25 12:28:08',0,'V',4859199991830250,4690304224367110,2025,'2025-01-25 12:28:08',18,1,0,4,'2025-01-25 12:43:08','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/01/2025 12:28:57.8238 2264 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:29:00.7576 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:29:31.8623 786 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 12:29:30',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'; 25/01/2025 12:32:45.8974 6764 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 25/01/2025 12:32:50.8005 4881 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 25/01/2025 12:32:57.1165 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 12:33:02.6470 695 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '456804101600327005012999' and traDirection='I' order by traId desc limit 1 25/01/2025 12:33:02.7921 819 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-25 12:33:01','V',4973954712505820,2025,'2025-01-25 12:32:49','456804419400327001029999',2,2,1,'I','',1,0,1,'','0532370677393',15,0) 25/01/2025 12:34:28.0422 3433 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 25/01/2025 12:35:01.3683 544 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 12:35:00' where payTraUID = 5384177291250040 and payStatus='V' and payEnabled=1 25/01/2025 12:35:02.2719 903 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 12:35:00' where traUID = 5384177291250040 and traStatus='V' and traEnabled=1 25/01/2025 12:35:36.6707 553 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue (WAIT TIME 2 ms.) 25/01/2025 12:35:51.7722 542 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/01/2025 12:37:55.4667 3589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:37:55.4667 3355 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 12:41:35.5318 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:44:01.5114 771 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 12:44:19.7069 1100 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 12:44:18' where traUID = 5450785164363020 and traStatus='V' and traEnabled=1 25/01/2025 12:45:32.2699 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:45:56.8385 1716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:46:12.2893 1704 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 12:47:00.2858 1830 ms. EXEC: update payInventory set invCreation = '2025-01-25 12:46:58',invModify = '2025-01-25 12:46:58',invUseId=0,invStatus='V' where invId = 233255 25/01/2025 12:47:00.9442 657 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-25 12:47:00',0,0,'V',5434640864142180,5708870217854950,2025,'2025-01-25 12:47:00',3,'KES',-1,50,-50,'N',''); 25/01/2025 12:47:01.9798 794 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 12:47:00',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'; 25/01/2025 12:47:03.5919 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:47:29.6184 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:50:43.1741 503 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 12:50:42' where traUID = 5089794138151670 and traStatus='V' and traEnabled=1 25/01/2025 12:51:39.8550 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:53:49.4722 753 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 25/01/2025 12:53:55.9744 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:54:08.9046 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 12:55:18.9640 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 12:55:54.6436 911 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-25 12:55:53','V',5677154575694610,2025,'2025-01-25 12:55:53','456804655300327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 12:56:35.1543 742 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 12:58:04.1417 1014 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 25/01/2025 12:58:07.4388 2286 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-01-25 12:58:05',0,'V',5374954791842140,4973954712505820,2025,'2025-01-25 12:58:05',2,1,0,-1,'2025-01-25 13:58:05','S','KES',0,0,0,'','','',3,0,0) 25/01/2025 12:58:11.2262 781 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:01:13.7674 1904 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 25/01/2025 13:01:48.9517 579 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 13:01:57.9274 587 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-25 13:01:57',0,'V',5470937557220850,5594359513410570,2025,'2025-01-25 13:01:57',18,1,0,4,'2025-01-25 13:16:57','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 25/01/2025 13:04:42.6869 5788 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 25/01/2025 13:04:58.4749 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:06:03.4411 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:09:13.7589 858 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 25/01/2025 13:15:57.8378 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:16:11.0872 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:18:13.2687 536 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 13:20:43.4639 960 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:22:26.0600 737 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-25 13:22:24',0,'V',5495122542249310,5742772025222640,2025,'2025-01-25 13:22:24',3,1,0,4,'2025-01-25 13:37:24','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 25/01/2025 13:22:36.9079 1201 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:24:12.5115 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:24:12.8887 567 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 13:24:56.9266 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:25:33.0095 976 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:27:14.9462 1081 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-25 13:23:53',12,'V',5499364496065380,5102845808906890,2025,'2025-01-25 13:23:53',17,1,0,4,'2025-01-25 13:38:53','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/01/2025 13:27:30.4670 562 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 13:27:31.8599 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:27:44.0366 646 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 13:27:43' where payTraUID = 5185233219957840 and payStatus='V' and payEnabled=1 25/01/2025 13:27:45.4125 1374 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 13:27:43' where traUID = 5185233219957840 and traStatus='V' and traEnabled=1 25/01/2025 13:27:49.7002 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:27:53.2044 1151 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 832569 25/01/2025 13:28:20.5087 2215 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-25 13:28:18','V',4684218995209680,2025,'2025-01-25 13:28:17','456804849700327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 13:28:43.3222 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:29:39.0045 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:29:56.3455 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:30:13.0351 525 ms. EXECSCALAR: select traId from movtransit where traUID = 5391071212857560 and traStatus='V' nr: 832598 25/01/2025 13:32:42.9582 1257 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-25 13:32:41','V',5154338267095960,2025,'2025-01-25 13:32:41','456804876100327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 13:32:44.2770 735 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 13:35:48.9921 508 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-25 13:35:48','V',5638274615947330,2025,'2025-01-25 13:35:48','456804660700327005012999',2,2,2,'O','',0,'2025-01-25 13:35:48',1,'','',0) 25/01/2025 13:35:54.8519 795 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:35:55.0049 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:37:05.4966 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:39:41.2164 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:40:02.5819 512 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 13:40:01',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'; 25/01/2025 13:41:36.1863 1501 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-25 13:41:34','V',4811719028823930,2025,'2025-01-25 13:41:32','456804929200327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 13:42:34.6093 646 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-25 13:42:33',17,12,'2025-01-25 13:42:33','456804737400327005012999','Pagato (Contanti ) Biglietto ') 25/01/2025 13:42:46.0686 559 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-25 13:42:44',0,'V',5484338645839440,5154338267095960,2025,'2025-01-25 13:42:44',3,1,0,4,'2025-01-25 13:57:44','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 15 ms.) 25/01/2025 13:42:46.7961 707 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5154338267095960,5484338645839440,2025,'2025-01-25 13:42:46','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/25/2025 1:32:41 PM Date : 1/25/2025 1:42:44 PM Code : 456804876100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 25/01/2025 13:42:47.9868 634 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 13:42:47',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'; 25/01/2025 13:42:50.1482 721 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 13:43:21.9874 1142 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 13:43:25.6897 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:43:28.9348 768 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:43:37.9235 1476 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:44:47.7988 1471 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-25 13:44:46','V',5150451609201820,2025,'2025-01-25 13:44:45','456804948500327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 13:45:14.4857 513 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 183 order by traDateTime desc,traId desc 25/01/2025 13:45:40.4762 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:46:29.2361 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:47:03.2127 6171 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 25/01/2025 13:48:17.4167 1095 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 13:48:16' where traUID = 5165183019771430 and traStatus='V' and traEnabled=1 25/01/2025 13:48:18.0411 624 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 832568 25/01/2025 13:48:59.5114 660 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-25 13:48:58','V',4817457374940790,2025,'2025-01-25 13:48:58','456804623600327005012999',2,2,2,'O','',0,'2025-01-25 13:48:58',1,'','',0) 25/01/2025 13:50:33.5020 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:53:29.3892 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:54:54.6023 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:54:56.7656 2127 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 13:56:29.4464 3224 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:57:20.5308 1286 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 25/01/2025 13:57:23.0384 1435 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-25 13:57:21','V',4775441127262430,2025,'2025-01-25 13:57:20','456804828300327005012999',2,2,2,'O','',0,'2025-01-25 13:57:21',1,'','',0) 25/01/2025 13:57:31.4297 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 13:58:00.9174 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:58:03.4050 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 13:59:39.5840 854 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 25/01/2025 14:00:11.5683 1870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:00:26.7689 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:11:59.0969 586 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 14:14:59.3152 2101 ms. EXEC: update payInventory set invCreation = '2025-01-25 14:14:57',invModify = '2025-01-25 14:14:57',invUseId=0,invStatus='V' where invId = 233274 25/01/2025 14:15:44.8060 566 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 14:15:48.5984 3470 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-25 14:15:45','V',5632625654629300,2025,'2025-01-25 14:15:43','456805134300327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 14:16:17.7409 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:20:04.1665 1803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:21:54.0192 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:23:54.6117 2083 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 25/01/2025 14:24:41.2152 1036 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 14:24:40' where traUID = 5539514624744510 and traStatus='V' and traEnabled=1 25/01/2025 14:24:41.3533 743 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-25 14:24:40','V',5524818966845500,2025,'2025-01-25 14:24:40','456805188000327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 14:24:43.1935 875 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 14:26:03.1010 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:26:16.6766 1638 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-25 14:26:15',4,6,'2025-01-25 14:26:15','456805116400327005012999','Payed (Credit Card ) Ticket ') 25/01/2025 14:26:17.7773 1025 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 398324 else acvFstPayId end),acvLstPayId = 398324 where acvSftId = 891 and acvCodeId = 3 25/01/2025 14:26:22.0060 683 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4768954036763190,4808130386343340,2025,'2025-01-25 14:26:21',' Date: 1/25/2025 2:26:20 PM Code: 456805097700327005012999 Entry Date: 1/25/2025 2:09:37 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 # 2500703574 ',0) 25/01/2025 14:27:17.9915 750 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 14:28:25.4012 744 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-25 14:28:24','V',5543670892903930,2025,'2025-01-25 14:28:23','456805097700327005012999',2,2,2,'O','',0,'2025-01-25 14:28:24',1,'','',0) 25/01/2025 14:28:25.4522 581 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 14:28:26.0816 615 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 14:29:13.4807 696 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-25 14:29:12','V',5564269269669200,2025,'2025-01-25 14:29:12','456805116400327005012999',2,2,2,'O','',0,'2025-01-25 14:29:12',1,'','',0) 25/01/2025 14:31:26.0137 572 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 25/01/2025 14:31:52.9268 1759 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 14:36:33.7589 1367 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:46:17.0307 1699 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/01/2025 14:46:17.0317 1505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:48:02.9579 635 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 25/01/2025 14:48:47.1649 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 14:55:11.8939 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:55:57.2957 624 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5085657020784250,5432309938776420,2025,'2025-01-25 14:55:56',' Date: 1/25/2025 2:55:56 PM Code: 456805230900327001012999 Entry Date: 1/25/2025 2:31:49 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 # 2500703579 ',0) 25/01/2025 14:56:04.7514 1926 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 14:57:14.4927 709 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 14:57:15.0730 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 14:57:53.9117 1417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:00:10.1570 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:00:24.0959 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:00:44.4458 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:00:48.2222 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:05:52.9824 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:07:15.3664 1057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:07:20.2645 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:07:28.5498 1283 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 25/01/2025 15:07:28.7609 1041 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 8 ms.) 25/01/2025 15:07:35.8664 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:07:43.1501 756 ms. EXEC: update payReceipt set recCreation = '2025-01-25 15:07:42',recModify = '2025-01-25 15:07:42',recUseId=0,recStatus='V' where recId = 345761 25/01/2025 15:07:43.1561 759 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 15:07:45.8458 954 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1060, trcLastPrinted = '2500401060', trcLastDate = '2025-01-25 15:07:44' where trcStatus='V' and trcTerId = 4 25/01/2025 15:07:50.1505 788 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 15 ms.) 25/01/2025 15:09:42.0915 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:09:53.7639 512 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-25 15:09:51',0,'V',4757954813035380,5460999804933770,2025,'2025-01-25 15:09:51',3,1,0,4,'2025-01-25 15:24:51','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 25/01/2025 15:10:03.6051 547 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 25/01/2025 15:10:34.5888 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:10:38.0990 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:12:51.1203 934 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:16:07.9842 778 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:16:51.0115 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:17:56.1388 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:18:37.9713 911 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:19:11.5266 728 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:19:52.7077 729 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 25/01/2025 15:19:52.8288 850 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 25/01/2025 15:21:57.9291 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:24:51.9845 567 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 15:24:51',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'; 25/01/2025 15:24:54.8092 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:28:33.5800 527 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 15:34:06.4771 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:41:21.7121 507 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 15:41:26.5491 769 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4993264916564980,5582854601245080,2025,'2025-01-25 15:41:25',' Data: 1/25/2025 3:38:02 PM Codice: 456805371200327005012999 Ingresso: 1/25/2025 2:55:12 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500600556 ',0) 25/01/2025 15:43:13.3048 1974 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-25 15:43:11','V',5437273497201360,2025,'2025-01-25 15:43:10','456805659000327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 15:43:23.3782 877 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 25/01/2025 15:43:26.5002 1308 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:43:49.7459 1341 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:45:18.5663 716 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:45:20.1012 693 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-25 15:45:19','V',5279113653696700,2025,'2025-01-25 15:45:11','456805671100327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 15:47:04.6885 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:47:04.7406 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:47:34.5345 784 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:49:57.6542 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:51:16.6663 536 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-25 15:51:16','V',5622799476181370,2025,'2025-01-25 15:51:15','456805442500327005012999',2,2,2,'O','',0,'2025-01-25 15:51:16',1,'','',0) 25/01/2025 15:51:41.9254 946 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 15:51:49.5302 943 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:52:02.8266 871 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 15:52:01' where payTraUID = 5321507381506540 and payStatus='V' and payEnabled=1 25/01/2025 15:52:05.3682 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 15:52:48.9919 566 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 15:52:48' where traUID = 4921450259180110 and traStatus='V' and traEnabled=1 25/01/2025 15:55:26.7199 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:55:26.8039 676 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 (WAIT TIME 77 ms.) 25/01/2025 15:55:46.6405 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 15:56:59.4157 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 16:00:00.6446 505 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-25 16:00:00',0,'V',5757429869943560,5290999872001080,2025,'2025-01-25 16:00:00',2,1,0,-1,'2025-01-25 17:00:00','S','KES',0,0,0,'','','',3,0,0) 25/01/2025 16:01:16.6848 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:01:17.7695 1112 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 25/01/2025 16:01:49.2395 681 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 16:02:12.2861 589 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/01/2025 16:04:27.7790 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 16:09:07.3643 1315 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:09:34.2183 2024 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/01/2025 16:10:45.1923 855 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-25 15:10:44') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-25 16:10:44' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-25 16:10:44' and (resAreId = 1 or resAreId <= 0) nr: 0 25/01/2025 16:10:51.8866 1131 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5152121651808900,5484286606977170,2025,'2025-01-25 16:10:50',' Date: 1/25/2025 4:10:49 PM Code: 456805711300327005012999 Entry Date: 1/25/2025 3:51:53 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 # 2500703597 ',0) 25/01/2025 16:10:51.9196 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-25 16:10:50','V',5097976357051980,2025,'2025-01-25 16:10:50','456805303200327005012999',2,2,2,'O','',0,'2025-01-25 16:10:50',1,'','',0) 25/01/2025 16:11:04.2694 1656 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5740255796336220,5678691379989740,2025,'2025-01-25 16:11:02','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/25/2025 1:24:23 PM Date : 1/25/2025 4:11:01 PM Code : 456804826300327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 100.00 KES',0) 25/01/2025 16:11:05.6863 915 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 16:11:04',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'; 25/01/2025 16:11:21.6244 627 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 16:11:20' where payTraUID = 5300519988791250 and payStatus='V' and payEnabled=1 25/01/2025 16:13:32.2442 2902 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 16:13:29' where payTraUID = 5740255796336220 and payStatus='V' and payEnabled=1 25/01/2025 16:13:53.2876 2332 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 16:13:50' where traUID = 4899286417292530 and traStatus='V' and traEnabled=1 25/01/2025 16:13:57.8085 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 16:14:27.5623 1236 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 16:15:41.1140 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 16:25:35.8147 1011 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:26:31.2138 581 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 16:27:05.8890 1480 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:27:37.0338 1447 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:39:55.5591 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:39:58.7721 996 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 25/01/2025 16:41:15.3307 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:44:32.5487 954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:45:06.9856 503 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 16:45:06',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 25/01/2025 16:45:21.5118 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:48:05.2754 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 16:50:40.0765 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 16:51:34.3009 674 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 16:53:40.0257 645 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 16:53:50.0950 1129 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 16:53:56.1219 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 16:55:40.4039 911 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-25 16:55:39',0,0,'V',5446834468270100,5032718667395020,2025,'2025-01-25 16:55:39',3,'KES',1,100,100,'N',''); 25/01/2025 16:57:45.8870 576 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-25 16:57:45','V',4991105060372400,2025,'2025-01-25 16:57:44','456806106400327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 17:10:05.4139 700 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-25 17:10:04' where subId = 26 25/01/2025 17:12:45.1242 833 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 17:16:01.7579 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 17:16:09.0995 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 17:16:30.4391 703 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456806136400327005012999' 25/01/2025 17:18:24.8466 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 17:18:53.8950 990 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 17:19:19.7194 1025 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-25 17:19:18','V',5510395724347290,2025,'2025-01-25 17:19:18','456806235800327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 17:19:20.4889 576 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 17:20:18.4747 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 17:21:27.8937 829 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 17:21:29.0534 1158 ms. EXECSCALAR: select traId from movtransit where traUID = 5554092189957850 and traStatus='V' nr: 832831 25/01/2025 17:23:46.0643 513 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 17:23:45' where payTraUID = 5381576123464100 and payStatus='V' and payEnabled=1 25/01/2025 17:26:51.6350 916 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-25 17:26:50','V',5220332563341560,2025,'2025-01-25 17:26:49','456806047200327005012999',2,2,2,'O','',0,'2025-01-25 17:26:50',1,'','',0) 25/01/2025 17:26:56.8153 675 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 17:35:57.0260 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 17:35:57.6884 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 17:35:58.3278 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 17:35:58.9613 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 17:36:46.2683 983 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-25 17:36:45','V',5694485308276240,2025,'2025-01-25 17:36:44','456806248600327005012999',2,2,2,'O','',0,'2025-01-25 17:36:45',1,'','',0) 25/01/2025 17:36:53.9761 1014 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 17:36:54.8777 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 17:36:59.6237 1043 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/01/2025 17:38:45.1393 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 17:40:37.8866 595 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 17:40:48.1892 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 17:43:19.4351 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 17:43:22.1768 2713 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 17:44:03.6311 1127 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 17:44:18.6546 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 17:46:08.2551 520 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 25/01/2025 17:46:24.6115 876 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 17:48:16.6095 598 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 25/01/2025 17:48:43.6897 519 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 17:49:25.5192 1031 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-25 17:49:24','V',5416911578474810,2025,'2025-01-25 17:49:23','456806075200327005012999',2,2,2,'O','',0,'2025-01-25 17:49:24',1,'','',0) 25/01/2025 17:49:27.8247 1798 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 17:49:25' where traUID = 4717643734309930 and traStatus='V' and traEnabled=1 25/01/2025 17:49:29.0785 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 17:53:00.7267 593 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-25 17:52:59',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'; 25/01/2025 17:54:10.4279 652 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-25 17:54:09','V',5764360783172690,2025,'2025-01-25 17:54:09','456806444900327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 17:56:47.7326 775 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 17:57:16.2687 521 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-25 17:57:14',0,'V',5014308490649060,5299841585976860,2025,'2025-01-25 17:57:14',3,1,0,4,'2025-01-25 18:12:14','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 25/01/2025 18:08:29.1754 1027 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 18:11:35.8678 559 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 18:11:36.6813 1236 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 18:12:03.5393 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 18:17:07.0758 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 18:20:25.2665 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 18:21:04.8686 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 18:21:05.0167 823 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/01/2025 18:27:34.3736 538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/01/2025 18:30:57.0011 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 18:33:43.7938 1378 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 18:33:44.7574 684 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 18:37:15.4540 585 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/01/2025 18:37:30.3815 1982 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 18:37:35.4837 510 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/01/2025 18:38:13.2767 632 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 18:40:48.6242 713 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 25/01/2025 18:40:49.4037 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 18:47:30.4488 600 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 18:47:33.9291 829 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 25/01/2025 18:47:34.0661 875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 18:51:14.5955 774 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 18:53:26.6072 833 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 18:55:59.5061 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 18:58:13.7763 678 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 19:03:14.1377 1160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:05:04.9200 1092 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:06:33.0219 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 19:07:14.7091 1747 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 25/01/2025 19:08:38.4061 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:09:01.5568 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:10:29.8698 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 19:10:43.6916 685 ms. EXEC: update payReceipt set recCreation = '2025-01-25 19:10:43',recModify = '2025-01-25 19:10:43',recUseId=0,recStatus='V' where recId = 345866 25/01/2025 19:10:44.6712 786 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-25 19:10:43',0,0,'V',5728620140012430,5362457815391710,2025,'2025-01-25 19:10:43',3,'KES',1,50,50,'N',''); 25/01/2025 19:13:57.6075 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:14:02.6037 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 19:15:56.5540 1309 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:16:06.8305 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:22:12.5434 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:23:52.9691 630 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-25 19:23:52','V',5179764970316140,2025,'2025-01-25 19:23:51','456806983100327005012999',1,2,16,'I','',1,0,1,'','',4) 25/01/2025 19:26:40.1681 1922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:30:00.5482 556 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/01/2025 19:30:00.9614 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:32:54.2533 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 19:32:56.1745 861 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 398464 else acvFstPayId end),acvLstPayId = 398464 where acvSftId = 891 and acvCodeId = 3 25/01/2025 19:32:58.1518 1950 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 19:34:43.6137 908 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 19:36:00.2072 529 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 19:43:27.3158 957 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-25 19:43:26',0,0,'V',5487132648796130,5446025456325950,2025,'2025-01-25 19:43:26',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-25 19:43:26',0,0,'V',5487132648796130,5446025456325950,2025,'2025-01-25 19:43:26',3,'KES',-1,100,-100,'N',''); 25/01/2025 19:49:53.5447 1729 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 19:49:51' where traUID = 5446025456325950 and traStatus='V' and traEnabled=1 25/01/2025 19:56:04.4018 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 19:59:03.0251 937 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 20:00:01.9575 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 20:01:59.2949 758 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 20:03:16.5628 540 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4729266450093800,4880987707133500,2025,'2025-01-25 20:03:16',' Date: 1/25/2025 8:03:15 PM Code: 456806196300327005012999 Entry Date: 1/25/2025 5:12:43 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 # 2500703635 ',0) 25/01/2025 20:03:34.9795 1086 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-25 20:03:33',0,16,'2025-01-25 20:03:33','','Unauthorized Transit Entry 2') 25/01/2025 20:03:48.0397 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 20:03:51.9172 592 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 25/01/2025 20:07:03.9099 861 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 20:08:26.4753 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 20:09:51.6053 1497 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 218 ms.) 25/01/2025 20:11:53.6377 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 20:13:38.6933 621 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 20:13:37' where traUID = 5060186741473040 and traStatus='V' and traEnabled=1 25/01/2025 20:18:45.2737 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 20:19:19.7846 695 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 25/01/2025 20:19:53.8031 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 20:21:58.5743 667 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 20:22:05.7848 1730 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 20:22:18.4739 810 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/01/2025 20:23:04.7993 1278 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-25 20:23:03','V',4774208586269780,2025,'2025-01-25 20:23:02','456806482800327005012999',2,2,2,'O','',0,'2025-01-25 20:23:03',1,'','',0) 25/01/2025 20:24:23.7403 648 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 20:29:07.5093 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 20:31:01.8368 1214 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/01/2025 20:34:56.7368 1050 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 20:35:20.1527 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 20:36:34.4138 1072 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 20:37:02.3485 1033 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 20:37:01' where traUID = 5153058727209820 and traStatus='V' and traEnabled=1 25/01/2025 21:03:20.0879 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:03:59.2348 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:04:36.9897 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:04:46.6949 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:05:57.4387 994 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-25 21:05:56','V',4951940215167140,2025,'2025-01-25 21:05:54','456806962300327005012999',2,2,2,'O','',0,'2025-01-25 21:05:56',1,'','',0) 25/01/2025 21:06:11.2275 1349 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/01/2025 21:14:29.4124 1322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:18:09.7236 929 ms. EXEC: update paycash set casCreation = '2025-01-25 21:18:08',casModify = '2025-01-25 21:18:08',casUseId=0,casStatus='V' where casId = 206644 25/01/2025 21:18:43.1778 709 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-25 21:18:42',0,'V',4794958249715250,4884975111438280,2025,'2025-01-25 21:18:42',18,1,0,4,'2025-01-25 21:33:42','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 25/01/2025 21:18:43.2048 758 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 21:19:32.2454 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 21:19:45.7840 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:20:08.2832 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:22:28.0349 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:22:41.8186 3253 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:24:44.9247 708 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 21:25:04.7692 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:27:52.7728 1232 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:34:54.9865 1402 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:36:58.8160 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 21:43:35.0667 740 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 22:06:28.4746 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:06:48.1140 1265 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 25/01/2025 22:19:12.9794 565 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 22:19:19.6256 1297 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 9 ms.) 25/01/2025 22:19:31.6562 568 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/01/2025 22:21:43.5749 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:22:41.8798 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:34:18.9631 608 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-25 22:34:18',0,'V',5409856084430670,5222068449486880,2025,'2025-01-25 22:34:18',18,1,0,4,'2025-01-25 22:49:18','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 25/01/2025 22:34:31.2900 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 22:36:30.0603 1430 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:38:20.1311 1571 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 22:38:20.8085 664 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-25 22:38:20' where payTraUID = 5390216146468480 and payStatus='V' and payEnabled=1 25/01/2025 22:38:25.7206 527 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 25/01/2025 22:39:23.5373 889 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-25 22:39:22' where traUID = 5650651705837100 and traStatus='V' and traEnabled=1 25/01/2025 22:40:19.7479 629 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-25 22:40:19','V',4776483752122380,2025,'2025-01-25 22:40:17','456807386300327005012999',2,2,2,'O','',0,'2025-01-25 22:40:19',1,'','',0) 25/01/2025 22:40:21.7122 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:40:25.8508 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 22:40:30.3576 853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:41:35.5290 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:42:41.3147 615 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-25 22:42:40','V',4749892508809320,2025,'2025-01-25 22:42:38','456808013400327005012999',2,2,2,'O','',0,'2025-01-25 22:42:40',1,'','',0) 25/01/2025 22:42:42.2713 825 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/01/2025 22:42:47.4426 1171 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:47:35.0059 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:53:44.7354 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 22:54:07.7470 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 553 ms.) 25/01/2025 22:54:51.1045 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 22:55:54.9460 616 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/01/2025 22:55:55.0311 661 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/01/2025 23:00:09.0902 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 23:00:09.1332 558 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/01/2025 23:02:50.1253 1098 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 25/01/2025 23:09:50.4318 753 ms. EXEC: update abbCards set carLastDate = '2025-01-25 23:09:49',carLastDirection='O' where carStatus='V' and carId = 13 25/01/2025 23:09:57.2721 814 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 23:10:01.2347 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 23:11:49.8055 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 23:18:22.4346 519 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/01/2025 23:25:07.3644 1964 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 23:25:12.6847 701 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/01/2025 23:30:54.1846 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 23:31:07.2359 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 23:33:25.2124 741 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-25 23:33:24','V',5338167407404960,2025,'2025-01-25 23:33:20','456808480000327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 25/01/2025 23:36:03.6459 1857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 23:54:02.1612 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 23:58:33.1450 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/01/2025 23:59:06.3571 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);