06/02/2025 00:00:51.7433 3057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:00:57.2801 2373 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:01:02.3035 3484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:01:35.1417 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:01:43.8036 1471 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:02:19.2676 1572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:02:21.2950 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:02:28.9492 1051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:02:41.1945 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:03:00.1413 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:03:03.7768 1243 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:06:17.2508 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:06:30.0975 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:06:43.7528 2605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:06:53.8746 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:07:10.9242 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:07:15.5693 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:08:26.0180 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:10:59.5550 3340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:11:01.0761 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:11:05.0117 1374 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:11:12.8931 3109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:11:44.2903 830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:11:50.4415 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:12:13.1319 612 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 00:12:12',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 06/02/2025 00:18:58.5265 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:23:19.9315 687 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 06/02/2025 00:23:24.1043 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:24:13.3327 1478 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/02/2025 00:24:26.4736 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:27:47.3767 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:29:06.8885 875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:29:22.8553 853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:29:47.0027 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:30:23.5354 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:30:36.5282 1111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:31:02.0185 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:31:43.5456 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:32:03.0869 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:33:35.3734 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:33:38.5235 2025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:34:06.8947 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:36:40.6851 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:38:42.3486 1722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:39:32.4255 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:39:33.3601 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:39:47.6388 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:40:21.6928 1755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:40:27.8630 2005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:44:41.9161 787 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/02/2025 00:47:24.0799 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:47:36.0140 1463 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:49:17.2446 2117 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:54:04.2610 2230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:57:26.5670 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:57:52.2324 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 00:58:20.6056 1247 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:03:32.6760 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:05:17.1628 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:05:45.4710 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:06:12.5243 1903 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:06:40.9545 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:06:45.6557 1398 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:07:45.1190 1677 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 06/02/2025 01:08:26.2989 3009 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:09:46.3431 895 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 06/02/2025 01:12:58.8985 1522 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/02/2025 01:15:10.9810 1241 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:19:32.3105 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:20:23.8555 4813 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 01:21:13.4302 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:21:23.9353 2385 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:21:54.3849 1457 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:21:59.5434 1679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:01.3676 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:09.9324 2574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:12.5712 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:15.3481 1351 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:19.1237 1100 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:25.3339 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:28.1168 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:32.6718 1882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:22:42.7186 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:25:28.7381 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:29:32.9335 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:32:24.1625 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:33:11.1413 1025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:33:17.0463 2290 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:33:49.9096 2057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:33:57.0774 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:36:10.9741 2158 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:36:32.9680 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:37:05.5331 1224 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:38:16.9765 2638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:38:43.1312 2974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:39:56.8381 558 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 01:40:51.2449 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:42:42.1491 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:43:39.4509 1743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:43:45.3088 2204 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:44:12.9145 1887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:44:56.2539 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:48:29.5724 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:50:08.9477 647 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 01:50:23.7077 3748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 01:57:24.2525 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:00:02.6318 2261 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:01:49.8535 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:01:54.1894 1970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:01:59.3489 1786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:02:00.4686 917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:02:03.4807 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:02:06.2055 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:02:08.6472 1529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:02:33.4070 1728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:02:39.4200 2317 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:05:31.2004 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:06:33.0162 2251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:06:35.4819 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:06:45.9740 3509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:06:50.6972 1967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:06:53.4621 1912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:07:36.0069 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:11:19.0460 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:12:57.1474 1449 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:13:40.2436 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:13:43.3427 3648 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 02:17:22.7013 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:05.3829 1072 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:15.4126 993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:25.1442 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:29.0439 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:31.3655 1513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:33.1857 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:36.0516 1993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:45.7972 3438 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:48.2369 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:19:58.2086 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:20:41.8332 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:20:44.2398 1345 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:20:47.5070 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:22:42.3298 4021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:23:51.6518 1629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:24:21.7141 1620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:25:50.8485 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:28:39.2916 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:32:09.9703 1009 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:33:43.9059 2206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:36:51.7261 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:42:08.9110 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:49:55.3339 1057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 02:55:10.2112 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 04:13:32.6238 594 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 06/02/2025 04:15:13.1989 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 04:25:28.9480 1807 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 42 ms.) 06/02/2025 04:39:44.3223 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 04:42:39.1348 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 04:50:48.1920 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 04:58:12.9863 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 05:02:46.0993 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 05:18:38.2772 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 05:20:04.4436 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 05:28:40.6522 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 05:37:47.2895 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 05:51:23.9376 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 05:53:06.9974 1242 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 05:54:18.5729 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:15:20.6978 1271 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:19:47.3634 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:22:44.6215 1234 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-06 06:22:43','V',5342851273257970,2025,'2025-02-06 06:22:42','456922296200327005012999',1,2,16,'I','',1,0,1,'','0230003957444',26,0) 06/02/2025 06:26:16.9753 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:26:24.2403 1490 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:27:18.2148 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:27:53.4667 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 06:28:34.2353 913 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:31:06.2713 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:31:07.8714 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:40:35.7360 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:40:42.5226 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:45:45.9321 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:55:41.1493 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 06:55:49.0726 1088 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:00:15.6332 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:04:15.0834 773 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 07:04:13',0,'V',5463107257364950,5603556712595140,2025,'2025-02-06 07:04:13',3,1,0,4,'2025-02-06 07:19:13','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 06/02/2025 07:04:56.5355 562 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 07:04:55','V',4872698998560350,2025,'2025-02-06 07:04:55','456922549500327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 07:05:15.2842 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:05:24.4804 780 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 06/02/2025 07:06:31.5208 585 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 07:08:46.7644 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:09:15.4308 2539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:09:22.2094 637 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 07:11:19.1336 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 07:13:52.2613 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:14:42.9887 812 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 07:14:39',0,'V',5757866589449560,5140898784497440,2025,'2025-02-06 07:14:39',3,1,0,4,'2025-02-06 07:29:39','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 06/02/2025 07:15:29.2941 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:18:53.3012 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 07:25:22.5630 539 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 07:30:49.6037 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:30:59.5645 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:32:02.9634 890 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 07:46:58.6411 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 07:49:19.3814 686 ms. EXEC: update abbCards set carLastDate = '2025-02-06 07:49:18',carLastDirection='I' where carStatus='V' and carId = 151 06/02/2025 07:59:10.1956 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:00:03.2926 1620 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 08:00:01' where traUID = 5495043092600780 and traStatus='V' and traEnabled=1 06/02/2025 08:03:56.4415 769 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 08:03:55',0,16,'2025-02-06 08:03:55','','Manual Open Barrier Entry 2') 06/02/2025 08:05:58.7183 1962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:09:38.0199 825 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 08:09:37',0,16,'2025-02-06 08:09:37','','Unauthorized Transit Entry 2') 06/02/2025 08:13:48.8007 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:14:07.5895 519 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 06/02/2025 08:16:18.2500 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:20:21.7079 1111 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 08:20:17',5,3,42101,0,50,-12,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 08:20:17',5,3,42101,0,100,-59,-5900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 08:20:17',5,3,42101,0,200,-9,-1800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 08:20:17',5,3,42101,0,500,-2,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 08:20:17',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 06/02/2025 08:20:22.3073 575 ms. OPEN: select * from payCurInventory where curTerId = 3 and curChannelId = 1 and curType in ('C','N') and curQuantity>0 order by curValue 06/02/2025 08:20:22.5164 1116 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:20:23.1338 512 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 08:20:48.3019 1047 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 08:20:47',0,3,'2025-02-06 08:20:47','0230003944086','POF - User Transit Supervisor Supervisor') 06/02/2025 08:22:17.3502 1043 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 06/02/2025 08:24:23.7728 1612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:26:10.1599 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:27:12.4731 584 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 08:27:05',5,3,42101,0,50,10,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+10,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 08:27:05',5,3,42101,0,200,2,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 08:27:05',5,3,42101,0,100,11,1100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+11,5),curAmount=round(curAmount+1100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 06/02/2025 08:27:13.3167 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:27:15.2680 1879 ms. OPEN: select * from payCurInventory where curTerId = 3 and curChannelId = 1 and curType in ('C','N') and curQuantity>0 order by curValue 06/02/2025 08:28:13.0241 1721 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4867627455133910,5267822738488830,2025,'2025-02-06 08:28:11','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/6/2025 8:15:22 AM Date : 2/6/2025 8:28:09 AM Code : 456922972200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 06/02/2025 08:30:18.1579 758 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 08:30:40.1528 1397 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:30:46.1228 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:31:03.0993 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:44:27.4804 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:49:16.4782 656 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 08:49:15' where payTraUID = 4928008361421720 and payStatus='V' and payEnabled=1 06/02/2025 08:51:23.1560 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 08:54:40.0243 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:56:59.4477 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 08:59:06.1516 744 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 08:59:05',0,'V',4863633196818240,5334017141983440,2025,'2025-02-06 08:59:05',18,1,0,4,'2025-02-06 09:14:05','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/02/2025 08:59:07.0242 554 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5334017141983440,4863633196818240,2025,'2025-02-06 08:59:06',' Date: 2/6/2025 8:59:05 AM Code: 456922936700327005012999 Entry Date: 2/6/2025 8:09:27 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 # 2500705268 ',0) 06/02/2025 08:59:30.9664 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:00:24.0173 934 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 09:00:23' where traUID = 5492213262161420 and traStatus='V' and traEnabled=1 06/02/2025 09:00:31.5224 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:01:16.6970 899 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 09:03:34.4763 2259 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 09:03:41.1328 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 09:05:14.1758 1059 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 09:05:13','V',5295725328118650,2025,'2025-02-06 09:05:12','456923271200327001012999',1,2,1,'I','',1,0,1,'','',4) 06/02/2025 09:07:06.6570 557 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 09:07:09.3759 952 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/02/2025 09:08:12.6307 1988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:08:21.6488 1084 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:12:22.8272 1420 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 09:12:29.6358 1430 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 09:13:03.2976 1506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:13:03.2976 1465 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 06/02/2025 09:13:36.5811 1000 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 09:13:35',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'; 06/02/2025 09:14:03.1511 2900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:14:10.8794 1072 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:14:15.9068 513 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 09:14:55.1334 1200 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/02/2025 09:15:10.8310 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:15:17.1943 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 09:17:33.6567 1909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:21:09.0906 687 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/02/2025 09:21:19.7739 1233 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 09:21:18',0,16,'2025-02-06 09:21:18','','Unauthorized Transit Entry 2') 06/02/2025 09:23:40.4181 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 09:23:41.0085 919 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 09:24:08.3781 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:25:20.6661 2378 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 09:25:18' where traUID = 5404692583028630 and traStatus='V' and traEnabled=1 06/02/2025 09:25:31.8286 875 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 09:26:10.4692 1234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:26:45.4559 1751 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 09:26:43' where traUID = 5376569887198390 and traStatus='V' and traEnabled=1 06/02/2025 09:26:51.7412 1528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:26:53.6485 810 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/02/2025 09:27:03.7113 930 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 09:27:02','V',4627407401075150,2025,'2025-02-06 09:27:01','456923284200327005012999',2,2,2,'O','',0,'2025-02-06 09:27:02',1,'','',0) 06/02/2025 09:31:42.6632 688 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 06/02/2025 09:31:56.4516 855 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/02/2025 09:34:58.2737 1500 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1619, trcLastPrinted = '2500401619', trcLastDate = '2025-02-06 09:34:56' where trcStatus='V' and trcTerId = 4 06/02/2025 09:34:59.1863 909 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4954212155339550,5122366550145290,2025,'2025-02-06 09:34:58',' Date: 2/6/2025 9:34:11 AM Code: 456923329200327005012999 Entry Date: 2/6/2025 9:14:52 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500401619 ',0) 06/02/2025 09:36:16.3906 504 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 09:36:15' where payTraUID = 4818221438771210 and payStatus='V' and payEnabled=1 06/02/2025 09:36:16.8239 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:36:46.7112 2045 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 09:37:52.3146 1216 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:40:09.4775 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 09:43:49.7177 1444 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 09:43:48','V',5489763000764460,2025,'2025-02-06 09:43:47','456923502700327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 09:51:06.7627 887 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 10:08:49.7321 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 10:13:48.8667 709 ms. OPEN: select 1 as Tot,payUID,payPayed,payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 06/02/2025 10:14:15.0565 1478 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 06/02/2025 10:14:21.4868 683 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 10:16:38.2655 589 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 10:17:16.5004 2269 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 10:18:34.4752 616 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 10:18:56.7993 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 10:20:55.9700 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 10:21:02.5305 665 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 10:23:19.6223 618 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 10:23:34.1652 2729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 93 ms.) 06/02/2025 10:25:16.9388 983 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 10:25:17.8144 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 10:28:19.8487 516 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 10:28:19','V',5004294855805130,2025,'2025-02-06 10:28:14','456923122300327005012999',2,2,2,'O','',0,'2025-02-06 10:28:19',1,'','',0) 06/02/2025 10:28:21.1155 570 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 10:28:20' where traUID = 5133347244357140 and traStatus='V' and traEnabled=1 06/02/2025 10:28:27.9412 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 10:29:20.2586 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 10:29:52.2322 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 10:30:44.1814 740 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 10:31:05.0085 588 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5282, trcLastPrinted = '2500705282', trcLastDate = '2025-02-06 10:31:04' where trcStatus='V' and trcTerId = 18 06/02/2025 10:31:11.7201 623 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 10:31:11',0,'V',5434348031500070,5310910837798220,2025,'2025-02-06 10:31:11',18,1,0,4,'2025-02-06 10:46:11','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 06/02/2025 10:31:22.3043 599 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 10:33:39.3318 753 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 10:33:40.1664 1040 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 06/02/2025 10:34:22.0290 827 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 10:34:21' where payTraUID = 4787335799125900 and payStatus='V' and payEnabled=1 06/02/2025 10:34:22.5924 562 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 10:34:21' where traUID = 4787335799125900 and traStatus='V' and traEnabled=1 06/02/2025 10:37:27.7979 2983 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 06/02/2025 10:38:11.7236 890 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 10:38:10','V',5038474037629500,2025,'2025-02-06 10:38:10','456923829000327001012999',1,2,1,'I','',1,0,1,'','',4) 06/02/2025 10:41:17.8081 532 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 10:49:24.2956 1017 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/02/2025 10:50:17.2785 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 10:50:20.2485 1418 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 10:52:20.1987 930 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 10:52:29.7022 615 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/02/2025 10:53:38.2756 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 10:54:05.6552 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 10:56:08.0301 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 10:57:15.8740 2504 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 10:57:12',0,'V',4798855543171050,5142891730110960,2025,'2025-02-06 10:57:12',3,1,0,4,'2025-02-06 11:12:12','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 06/02/2025 10:57:17.0648 580 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 10:57:16',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 10:57:16',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 06/02/2025 11:00:18.6678 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:00:27.3347 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:02:06.2617 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:03:19.3832 1726 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 11:03:17' where payTraUID = 5712889786505200 and payStatus='V' and payEnabled=1 06/02/2025 11:03:25.8266 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 11:04:14.0382 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-02-06 11:04:13','V',5426628489925700,2025,'2025-02-06 11:04:11','456923282700327005012999',2,2,2,'O','',0,'2025-02-06 11:04:13',1,'','',0) 06/02/2025 11:05:20.6604 1592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:05:33.4931 810 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 11:05:41.8887 1119 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:18:44.3494 916 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/02/2025 11:18:50.8608 1081 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extcode' 06/02/2025 11:18:53.1714 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:20:56.1007 552 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 402801 else acvFstPayId end),acvLstPayId = 402801 where acvSftId = 896 and acvCodeId = 3 06/02/2025 11:20:57.4766 1363 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 06/02/2025 11:22:31.3051 563 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/02/2025 11:24:18.7019 1077 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 06/02/2025 11:25:27.0382 1564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 11:28:07.8731 629 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 11:29:30.1989 1343 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 11:29:28',0,16,'2025-02-06 11:29:28','','Unauthorized Transit Entry 2') 06/02/2025 11:32:54.2361 1148 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 11:32:53','V',5314500011539880,2025,'2025-02-06 11:32:51','456923784300327005012999',2,2,2,'O','',0,'2025-02-06 11:32:53',1,'','',0) 06/02/2025 11:32:58.3509 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 11:35:46.5328 1877 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 11:36:25.4722 3522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:37:12.3649 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:40:10.2294 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 11:42:24.9607 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:42:53.5350 922 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 11:43:48.9996 923 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 11:44:30.4717 761 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 11:44:29',17,12,'2025-02-06 11:44:29','456923989200327005012999','Pagato (Contanti ) Biglietto ') 06/02/2025 11:44:44.8104 695 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 11:44:59.1071 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 11:45:13.8601 978 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 11:45:30.7405 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:46:02.4129 1205 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-06 11:46:01',0,0,'V',4800096015729410,5503225183089450,2025,'2025-02-06 11:46:01',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-06 11:46:01',0,0,'V',4800096015729410,5503225183089450,2025,'2025-02-06 11:46:01',3,'KES',-1,100,-100,'N',''); 06/02/2025 11:46:03.2985 884 ms. EXEC: update paycash set casCreation = '2025-02-06 11:46:02',casModify = '2025-02-06 11:46:02',casUseId=0,casStatus='V' where casId = 208275 06/02/2025 11:46:35.6825 508 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 11:46:35' where traUID = 4865577445232060 and traStatus='V' and traEnabled=1 06/02/2025 11:47:14.5008 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:48:27.2961 1492 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:48:53.8441 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:48:53.8451 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 11:50:37.0310 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:53:01.7520 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:53:56.9784 1836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 11:58:15.0972 561 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 11:58:14' where payTraUID = 4748703071158430 and payStatus='V' and payEnabled=1 06/02/2025 11:58:24.3395 1492 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:00:04.5163 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:01:03.2561 536 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 06/02/2025 12:01:14.4077 1090 ms. OPEN: show columns from tabTerminal where Field = 'terLastReceiptNumber' 06/02/2025 12:02:14.6485 788 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 12:02:13','V',4777666755107860,2025,'2025-02-06 12:02:13','456924333300327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 12:03:06.0133 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:03:16.9597 791 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/02/2025 12:04:36.0903 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:09:04.2709 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:09:39.4738 708 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 12:09:49.2844 562 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 12:10:15.2610 570 ms. EXEC: update payReceipt set recCreation = '2025-02-06 12:10:14',recModify = '2025-02-06 12:10:14',recUseId=0,recStatus='V' where recId = 349572 06/02/2025 12:10:21.9145 662 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/02/2025 12:11:18.8601 1440 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 12:11:17' where traUID = 5628111805782360 and traStatus='V' and traEnabled=1 06/02/2025 12:11:23.3141 606 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 12:11:23.5503 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:13:11.1471 1899 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:13:42.7806 2341 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 06/02/2025 12:13:49.4841 2131 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 12:13:47','V',4771644409573670,2025,'2025-02-06 12:13:44','456920001200327003229999',22,22,3,'I','',1,0,1,'','',2) 06/02/2025 12:14:41.3042 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:14:58.0385 594 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 12:14:55',0,'V',4858612268655290,5389534915940430,2025,'2025-02-06 12:14:55',3,1,0,4,'2025-02-06 12:29:55','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 06/02/2025 12:16:45.9586 1248 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:16:53.7549 849 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:17:05.6830 559 ms. OPEN: select devId from tabDevice where devStatus='V' and devCode = 20001 06/02/2025 12:17:18.4687 596 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 12:17:17',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'; 06/02/2025 12:17:19.8546 809 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 12:17:18',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 06/02/2025 12:17:44.5583 940 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 12:17:52.3216 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:18:11.7217 1385 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:18:44.2878 1265 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 12:18:42',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 06/02/2025 12:18:54.8149 696 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 12:18:54',0,16,'2025-02-06 12:18:54','','Unauthorized Transit Entry 2') 06/02/2025 12:19:52.3959 1007 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 12:19:51','V',5204644777933790,2025,'2025-02-06 12:19:50','456924439000327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 12:21:36.0021 576 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 12:21:56.0277 1103 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:23:56.1700 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-02-06 12:23:55','V',5725411625023530,2025,'2025-02-06 12:23:53','456924463300327001012999',1,2,1,'I','',1,0,1,'','',4) 06/02/2025 12:32:57.7948 641 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 12:32:56',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'; 06/02/2025 12:33:36.6861 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:33:36.9193 585 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 12:33:36','V',4848427643126220,2025,'2025-02-06 12:33:28','456924520800327001012999',1,2,1,'I','',1,0,1,'','',4) 06/02/2025 12:34:23.2767 590 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/02/2025 12:34:26.5369 860 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/02/2025 12:36:34.7968 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:38:27.8994 822 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 12:41:26.0961 1045 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:41:42.8004 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:42:11.0956 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:43:02.1571 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:43:05.2893 536 ms. OPEN: select * from tabParameters order by parId desc limit 1 06/02/2025 12:48:58.3144 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:49:09.6681 624 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5304, trcLastPrinted = '2500705304', trcLastDate = '2025-02-06 12:49:09' where trcStatus='V' and trcTerId = 18 06/02/2025 12:49:10.4476 557 ms. EXEC: update payReceipt set recCreation = '2025-02-06 12:49:09',recModify = '2025-02-06 12:49:09',recUseId=0,recStatus='V' where recId = 349596 06/02/2025 12:49:20.0381 603 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 12:49:20.9127 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:49:22.7659 549 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 12:49:21',0,'V',4765154955061840,4959703727581720,2025,'2025-02-06 12:49:21',18,1,0,4,'2025-02-06 13:04:21','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/02/2025 12:49:23.8647 822 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4959703727581720,4765154955061840,2025,'2025-02-06 12:49:23',' Date: 2/6/2025 12:49:21 PM Code: 456924292100327005012999 Entry Date: 2/6/2025 11:55:21 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 # 2500705305 ',0) 06/02/2025 12:49:40.8462 809 ms. EXEC: update abbCards set carLastDate = '2025-02-06 12:49:40',carLastDirection='O' where carStatus='V' and carId = 185 06/02/2025 12:49:41.9269 816 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 12:49:41' where payTraUID = 4913543423164890 and payStatus='V' and payEnabled=1 06/02/2025 12:51:03.4211 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:52:22.5257 2390 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 12:52:19' where traUID = 5349222297401020 and traStatus='V' and traEnabled=1 06/02/2025 12:52:38.2293 616 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-02-06 12:52:37',0,'V',5354583939989430,5343555276659780,2025,'2025-02-06 12:52:37',2,1,0,-1,'2025-02-06 13:52:37','S','KES',0,0,0,'','','',3,0,0) 06/02/2025 12:53:42.4038 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:54:11.5856 1103 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 12:55:40.3257 1318 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 12:55:39' where payTraUID = 4848427643126220 and payStatus='V' and payEnabled=1 06/02/2025 12:56:08.5628 654 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 12:56:32.9964 982 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 12:57:43.9864 691 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 06/02/2025 12:59:54.7660 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:01:32.2280 1496 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/02/2025 13:03:14.7695 1313 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 109 ms.) 06/02/2025 13:03:22.2796 1912 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 06/02/2025 13:05:12.9776 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:05:53.3239 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:08:44.3227 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:13:01.8539 1060 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:14:48.2480 1117 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 13:14:46',0,'V',4737828398621210,5095473366917040,2025,'2025-02-06 13:14:46',18,1,0,4,'2025-02-06 13:29:46','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/02/2025 13:14:48.9825 613 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5095473366917040,4737828398621210,2025,'2025-02-06 13:14:48',' Date: 2/6/2025 1:14:46 PM Code: 456924750600327005012999 Entry Date: 2/6/2025 1:11:46 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 # 2500705310 ',0) 06/02/2025 13:14:55.6910 749 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 13:15:51.7640 1091 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 13:15:50','V',5502067097137080,2025,'2025-02-06 13:15:49','456924605400327005012999',2,2,2,'O','',0,'2025-02-06 13:15:50',1,'','',0) 06/02/2025 13:16:22.7550 1055 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 13:16:21' where traUID = 5095473366917040 and traStatus='V' and traEnabled=1 06/02/2025 13:16:27.2300 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:18:41.0156 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:19:13.9900 636 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 13:21:17.4846 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:22:41.4475 534 ms. OPEN: select * from payCurInventory where curTerId = 18 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 06/02/2025 13:23:38.2039 958 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-06 13:23:37','V',4845223768878710,2025,'2025-02-06 13:23:35','456924821500327005012999',1,2,16,'I','',1,0,1,'','0230004098567',165,0) 06/02/2025 13:24:36.0881 503 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 13:25:12.5038 1144 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:25:16.2633 516 ms. EXEC: update payReceipt set recCreation = '2025-02-06 13:25:15',recModify = '2025-02-06 13:25:15',recUseId=0,recStatus='V' where recId = 349611 06/02/2025 13:26:48.7170 2104 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/02/2025 13:27:24.6993 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:31:00.9258 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:31:17.5240 1378 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 13:31:19.3573 1640 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 13:31:17' where traUID = 5595629692934570 and traStatus='V' and traEnabled=1 06/02/2025 13:31:23.1979 549 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 13:31:29.9364 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:32:45.5036 513 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 13:32:44' where traUID = 4671148467586370 and traStatus='V' and traEnabled=1 06/02/2025 13:32:50.3619 1159 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 13:33:03.1126 671 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/02/2025 13:35:02.9357 650 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 13:35:02' where traUID = 5482592648746780 and traStatus='V' and traEnabled=1 06/02/2025 13:35:03.7533 816 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 06/02/2025 13:35:11.7647 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:38:06.9914 1411 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/02/2025 13:38:53.7400 1617 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 13:40:00.3412 997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:40:22.0689 669 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 402880 else acvFstPayId end),acvLstPayId = 402880 where acvSftId = 894 and acvCodeId = 3 06/02/2025 13:45:02.3058 905 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:46:24.7807 1881 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5257100566153190,4884956872447930,2025,'2025-02-06 13:46:22','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/6/2025 1:00:47 PM Date : 2/6/2025 1:46:21 PM Code : 456924684700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 06/02/2025 13:47:03.4028 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:47:12.9183 529 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/02/2025 13:47:31.0426 1762 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 06/02/2025 13:48:30.3988 707 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-06 13:48:29','V',5185612502289820,2025,'2025-02-06 13:48:29','456924970900327001012999',1,2,1,'I','',1,0,1,'','0230003944059',13,0) 06/02/2025 13:48:39.6660 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:48:41.6524 584 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-06 13:48:41',0,0,'V',4948080777200910,4890614587689630,2025,'2025-02-06 13:48:41',3,'KES',-1,50,-50,'N',''); 06/02/2025 13:49:21.1041 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:49:40.4162 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:49:57.3186 538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 13:50:21.4820 667 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 13:50:20',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'; 06/02/2025 13:51:46.5836 1913 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 13:51:44',0,'V',5090304444527980,5489185628982470,2025,'2025-02-06 13:51:44',18,1,0,4,'2025-02-06 14:06:44','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/02/2025 13:53:19.2394 1285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:54:49.2384 2181 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 13:54:56.2081 1854 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 13:54:54','V',5617650491920960,2025,'2025-02-06 13:54:53','456925009300327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 13:56:38.0421 570 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 13:56:37' where payTraUID = 5157214556028280 and payStatus='V' and payEnabled=1 06/02/2025 13:57:27.9739 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:59:39.3379 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 13:59:39.3389 731 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 13:59:38' where payTraUID = 5744820248251470 and payStatus='V' and payEnabled=1 06/02/2025 14:01:43.1807 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:02:02.5058 964 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 14:02:21.5988 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:04:57.3913 636 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 14:05:22.1771 946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:05:26.2038 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:05:44.8224 1350 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:08:30.6577 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:08:32.3969 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:12:56.2617 812 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 14:14:40.0319 576 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/02/2025 14:14:41.0426 965 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 14:14:40' where traUID = 5494136976613970 and traStatus='V' and traEnabled=1 06/02/2025 14:14:47.5210 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:15:24.6101 1239 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:16:06.1423 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:16:34.2993 821 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:16:35.1009 763 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 06/02/2025 14:17:23.7078 1357 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:19:00.0781 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:21:13.0561 3328 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:21:16.7346 764 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 14:21:15',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'; 06/02/2025 14:21:25.0483 804 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 14:21:42.0578 1736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:21:45.0788 2017 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:22:09.0201 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:23:02.9196 569 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 14:23:02',4,6,'2025-02-06 14:23:02','456924656700327005012999','Payed (Credit Card ) Ticket ') 06/02/2025 14:23:16.3997 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:26:03.0396 1131 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 402915 else acvFstPayId end),acvLstPayId = 402915 where acvSftId = 894 and acvCodeId = 3 06/02/2025 14:28:03.6070 521 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 14:28:03','V',4757241074641710,2025,'2025-02-06 14:28:01','456924656700327005012999',2,2,2,'O','',0,'2025-02-06 14:28:03',1,'','',0) 06/02/2025 14:29:40.8859 831 ms. EXEC: update paycash set casCreation = '2025-02-06 14:29:40',casModify = '2025-02-06 14:29:40',casUseId=0,casStatus='V' where casId = 208323 06/02/2025 14:32:42.5189 2070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:33:19.5870 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:33:19.9682 1694 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 14:33:16',0,'V',4886237341088280,5575881415966540,2025,'2025-02-06 14:33:16',3,1,0,4,'2025-02-06 14:48:16','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 06/02/2025 14:33:55.7415 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:34:02.5881 512 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 14:36:03.6661 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:36:51.9418 947 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 402923 else acvFstPayId end),acvLstPayId = 402923 where acvSftId = 896 and acvCodeId = 3 06/02/2025 14:37:04.5063 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:40:50.3993 1140 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 06/02/2025 14:42:31.0065 873 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 14:42:30' where payTraUID = 4866406967553350 and payStatus='V' and payEnabled=1 06/02/2025 14:42:35.3674 711 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 06/02/2025 14:42:35.4345 638 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 14:42:36.2801 756 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:43:30.2376 507 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 06/02/2025 14:43:54.1028 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:44:06.8794 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:44:22.2819 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:47:33.0671 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:49:35.7021 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:53:25.9231 1013 ms. EXEC: update payReceipt set recCreation = '2025-02-06 14:53:24',recModify = '2025-02-06 14:53:24',recUseId=0,recStatus='V' where recId = 349667 06/02/2025 14:53:41.7688 599 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 06/02/2025 14:55:28.8844 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 14:58:59.9831 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 14:59:36.5349 724 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 14:59:35','V',5479452722281470,2025,'2025-02-06 14:59:33','456924207100327005012999',2,2,2,'O','',0,'2025-02-06 14:59:35',1,'','',0) 06/02/2025 15:00:09.0339 1150 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:01:08.8530 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:01:50.6823 689 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 15:02:34.6311 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:02:42.4904 612 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 06/02/2025 15:03:56.2834 1736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:04:35.0186 638 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 15:04:47.6151 1032 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 15:04:46','V',5645752102872630,2025,'2025-02-06 15:04:44','456924948500327005012999',2,2,2,'O','',0,'2025-02-06 15:04:46',1,'','',0) 06/02/2025 15:04:51.8860 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:06:20.3369 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-02-06 15:06:19','V',5657808593103680,2025,'2025-02-06 15:06:19','456925437900327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 15:06:49.5858 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:09:43.3955 762 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:11:39.8303 525 ms. OPEN: show columns from payPayment where Field = 'payClosePeriod' 06/02/2025 15:11:49.7991 890 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 15:11:48' where traUID = 5145574823332180 and traStatus='V' and traEnabled=1 06/02/2025 15:12:12.4464 1598 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 15:12:10' where payTraUID = 5590522345501290 and payStatus='V' and payEnabled=1 06/02/2025 15:12:20.1016 1232 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 3 ms.) 06/02/2025 15:12:20.1036 1086 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 06/02/2025 15:12:21.7778 754 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:14:15.2696 665 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 15:14:26.4582 536 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 15:16:38.0834 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:18:00.1059 1254 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:21:36.8527 915 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 06/02/2025 15:21:38.2367 541 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 15:21:37' where payTraUID = 5308320517304770 and payStatus='V' and payEnabled=1 06/02/2025 15:21:46.3241 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:25:03.3016 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:25:34.1425 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:27:31.4739 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:28:43.6838 1438 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:28:59.4265 2154 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:29:51.0845 1518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:30:38.9859 847 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 15:30:38' where payTraUID = 5114827006119330 and payStatus='V' and payEnabled=1 06/02/2025 15:31:03.2774 831 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 15:32:48.0143 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:33:07.6096 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:33:21.6801 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:33:26.6395 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:33:41.3154 514 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 15:35:02.1442 582 ms. EXEC: update payReceipt set recCreation = '2025-02-06 15:35:01',recModify = '2025-02-06 15:35:01',recUseId=0,recStatus='V' where recId = 349689 06/02/2025 15:35:13.2917 877 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-02-06 15:35:12',0,'V',4869415938924630,5573412323615870,2025,'2025-02-06 15:35:12',2,1,0,-1,'2025-02-06 16:35:12','S','KES',0,0,0,'','','',3,0,0) 06/02/2025 15:38:26.9709 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:38:49.4281 502 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 15:38:57.5166 664 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/02/2025 15:40:47.8043 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:42:27.4598 1378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:42:59.2163 1212 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/02/2025 15:43:19.8433 536 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 15:44:50.3876 887 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 06/02/2025 15:46:06.5752 1268 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 15:46:05',4,6,'2025-02-06 15:46:05','456924127200327005012999','Payed (Credit Card ) Ticket ') 06/02/2025 15:47:37.5889 2658 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 15:47:44.1113 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 15:47:49.1547 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 06/02/2025 15:48:08.9421 876 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1650, trcLastPrinted = '2500401650', trcLastDate = '2025-02-06 15:48:08' where trcStatus='V' and trcTerId = 4 06/02/2025 15:48:29.9624 527 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 15:51:05.4807 530 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 15:51:07.2959 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:53:11.0077 1378 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 15:53:11.0748 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 15:56:52.0484 1292 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 15:59:05.2316 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:01:01.1782 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:01:12.3237 618 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 16:01:11',0,'V',5259409656332380,4728699477398680,2025,'2025-02-06 16:01:11',18,1,0,4,'2025-02-06 16:16:11','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/02/2025 16:01:13.2454 690 ms. EXEC: update payReceipt set recCreation = '2025-02-06 16:01:12',recModify = '2025-02-06 16:01:12',recUseId=0,recStatus='V' where recId = 349703 06/02/2025 16:03:46.2770 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 16:03:51.7827 781 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 16:04:03.0574 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:04:12.8010 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 16:06:22.3167 691 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 16:06:21',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 06/02/2025 16:06:37.9843 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:06:56.8651 730 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 16:13:51.1187 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:18:35.8466 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:19:07.0507 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:21:34.1243 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:24:00.5895 1476 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:31:06.2048 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 16:36:34.9114 745 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/02/2025 16:36:36.1143 549 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 16:36:35' where payTraUID = 5016348552599100 and payStatus='V' and payEnabled=1 06/02/2025 16:39:05.5825 1143 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 16:39:04',0,'V',5188907498884660,5324335499998670,2025,'2025-02-06 16:39:04',18,1,0,4,'2025-02-06 16:54:04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/02/2025 16:40:56.2495 2137 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 16:40:54','V',5698186901726450,2025,'2025-02-06 16:40:53','456925669700327005012999',2,2,2,'O','',0,'2025-02-06 16:40:54',1,'','',0) 06/02/2025 16:40:57.6684 936 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 16:40:56' where traUID = 5324335499998670 and traStatus='V' and traEnabled=1 06/02/2025 16:43:03.9650 670 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 16:43:02',0,'V',5709968425276900,5464688471445280,2025,'2025-02-06 16:43:02',3,1,0,4,'2025-02-06 16:58:02','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 06/02/2025 16:43:52.9131 855 ms. EXEC: update payReceipt set recCreation = '2025-02-06 16:43:52',recModify = '2025-02-06 16:43:52',recUseId=0,recStatus='V' where recId = 349721 06/02/2025 16:43:53.8458 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:43:53.9628 815 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-06 16:43:52',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 06/02/2025 16:44:13.4560 693 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 16:44:41.4190 2812 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 16:44:38','V',5005962949757750,2025,'2025-02-06 16:44:38','456926027800327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 16:44:56.2970 865 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-06 16:44:55',0,16,'2025-02-06 16:44:55','','Unauthorized Transit Entry 2') 06/02/2025 16:45:03.1997 1301 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/02/2025 16:45:03.3328 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:51:54.0090 1170 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:52:22.6074 589 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 16:52:33.2816 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:58:03.6380 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:58:29.9228 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 16:58:34.5730 577 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 16:58:33','V',5370749504199560,2025,'2025-02-06 16:58:33','456926111300327001012999',1,2,1,'I','',1,0,1,'','',4) 06/02/2025 16:59:14.1748 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 16:59:35.5963 656 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 17:00:04.1767 502 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 06/02/2025 17:00:08.7948 701 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/02/2025 17:01:56.4237 1307 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403004 else acvFstPayId end),acvLstPayId = 403004 where acvSftId = 896 and acvCodeId = 3 06/02/2025 17:01:57.1432 623 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5565963592046290,5740054261380300,2025,'2025-02-06 17:01:56',' Date: 2/6/2025 5:01:09 PM Code: 456924077300327005012999 Entry Date: 2/6/2025 11:19:33 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 400.00 KES ______________________________ Paid: 400.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500401658 ',0) 06/02/2025 17:08:29.7471 606 ms. EXEC: update abbCards set carLastDate = '2025-02-06 17:08:29',carLastDirection='I' where carStatus='V' and carId = 44 06/02/2025 17:08:33.3676 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:09:56.3918 1019 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/02/2025 17:10:00.9649 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:11:40.6524 665 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 17:11:39' where traUID = 5323103389064700 and traStatus='V' and traEnabled=1 06/02/2025 17:11:41.0367 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:12:42.1301 580 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-06 17:12:41' where subId = 158 06/02/2025 17:12:43.9223 1563 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-02-06 17:12:42',0,'V',4777152620018120,5186928961441610,2025,'2025-02-06 17:12:42',2,1,0,-1,'2025-02-06 18:12:42','S','KES',0,0,0,'','','',3,0,0) 06/02/2025 17:12:44.3076 1795 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5429123807884510,4730597892643760,2025,'2025-02-06 17:12:42',' Date: 2/6/2025 5:12:41 PM Code: 456925415300327005012999 Entry Date: 2/6/2025 3:02:33 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 # 2500705351 ',0) 06/02/2025 17:12:44.5877 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:13:03.2794 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:15:16.0253 759 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 17:15:15','V',5000598523578590,2025,'2025-02-06 17:15:14','456926075700327005012999',2,2,2,'O','',0,'2025-02-06 17:15:15',1,'','',0) 06/02/2025 17:16:10.3171 527 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 17:16:09','V',5499811859402470,2025,'2025-02-06 17:16:08','456925978100327005012999',2,2,2,'O','',0,'2025-02-06 17:16:09',1,'','',0) 06/02/2025 17:17:24.7315 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:19:39.9155 614 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 17:19:39',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'; 06/02/2025 17:20:01.8323 568 ms. EXEC: update abbCards set carLastDate = '2025-02-06 17:20:01',carLastDirection='O' where carStatus='V' and carId = 202 06/02/2025 17:20:06.8117 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:23:10.2410 1074 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 17:23:09','V',4744952376788900,2025,'2025-02-06 17:23:06','456925931400327005012999',2,2,2,'O','',0,'2025-02-06 17:23:09',1,'','',0) 06/02/2025 17:30:08.5715 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:30:37.5662 531 ms. EXEC: update abbCards set carLastDate = '2025-02-06 17:30:37',carLastDirection='O' where carStatus='V' and carId = 181 06/02/2025 17:31:56.7398 1428 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:33:14.8637 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:33:22.3878 1120 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:38:48.7349 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:40:23.6261 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:40:52.5167 1176 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:41:34.9885 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:43:41.2190 872 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 17:44:58.3072 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:45:40.1155 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:51:25.0421 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:52:03.7724 1146 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:53:27.7112 762 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:53:28.4557 1553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 17:55:05.9338 1411 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/02/2025 17:56:52.4089 734 ms. EXEC: update abbCards set carLastDate = '2025-02-06 17:56:51',carLastDirection='O' where carStatus='V' and carId = 179 06/02/2025 17:56:57.0110 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 17:57:21.6917 737 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 06/02/2025 17:59:47.7436 582 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 17:59:47',0,'V',4816920046298970,5093128803280150,2025,'2025-02-06 17:59:47',18,1,0,4,'2025-02-06 18:14:47','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 06/02/2025 18:00:07.3829 698 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 18:00:42.3446 514 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 18:01:18.3830 570 ms. EXEC: update payReceipt set recCreation = '2025-02-06 18:01:17',recModify = '2025-02-06 18:01:17',recUseId=0,recStatus='V' where recId = 349744 06/02/2025 18:01:19.0545 583 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-06 18:01:18',0,0,'V',4673720960014730,4662012277946840,2025,'2025-02-06 18:01:18',3,'KES',1,100,100,'N',''); 06/02/2025 18:02:37.1534 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:03:51.6048 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:04:34.0266 654 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/02/2025 18:08:37.6946 1519 ms. EXEC: update abbCards set carLastDate = '2025-02-06 18:08:36',carLastDirection='O' where carStatus='V' and carId = 196 06/02/2025 18:14:18.4169 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:15:54.8752 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:15:55.6807 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:16:11.8767 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:17:30.9383 665 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 18:17:30' where traUID = 4890333926518030 and traStatus='V' and traEnabled=1 06/02/2025 18:17:33.4490 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 18:18:14.2926 1157 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:20:38.9236 960 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5366, trcLastPrinted = '2500705366', trcLastDate = '2025-02-06 18:20:37' where trcStatus='V' and trcTerId = 18 06/02/2025 18:21:01.1186 1657 ms. EXEC: update payReceipt set recCreation = '2025-02-06 18:20:59',recModify = '2025-02-06 18:20:59',recUseId=0,recStatus='V' where recId = 349754 06/02/2025 18:21:01.4028 1172 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:21:01.7280 609 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456926350500327005012999' 06/02/2025 18:21:11.6528 1460 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:21:40.6614 504 ms. OPEN: select payClosePeriod from paypayment inner join movtransit on paypayment.payTraUID=movtransit.traUID where movtransit.traStatus='V' AND traCode=@traCode and paypayment.payStatus='V' and paypayment.payClosePeriod is not null order by paypayment.payClosePeriod desc limit 1 06/02/2025 18:21:41.8752 1061 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 18:21:40','V',5254230255613100,2025,'2025-02-06 18:21:39','456926406800327005012999',2,2,2,'O','',0,'2025-02-06 18:21:40',1,'','',0) 06/02/2025 18:21:44.2398 1842 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 18:21:42' where traUID = 4912225058167780 and traStatus='V' and traEnabled=1 06/02/2025 18:22:19.1005 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:22:19.1785 1156 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-02-06 17:22:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-06 18:22:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-06 18:22:18' and (resAreId = 1 or resAreId <= 0) nr: 0 06/02/2025 18:23:35.4712 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:24:49.1671 620 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 18:24:57.7769 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 18:30:34.2959 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:34:56.2263 1008 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 18:35:19.4850 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:36:46.3078 1508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:41:32.4667 1034 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 18:41:31','V',4972705010541830,2025,'2025-02-06 18:41:30','456926729000327001012999',1,2,1,'I','',1,0,1,'','',4) 06/02/2025 18:42:39.0818 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 18:46:16.9263 954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:46:16.9263 953 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 18:46:17.3556 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:46:17.6598 732 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/02/2025 18:46:17.9090 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:46:17.9991 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:51:29.8083 1932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 18:51:30.5618 644 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 18:51:29',0,'V',5231230783263080,4621980494577690,2025,'2025-02-06 18:51:29',18,1,0,4,'2025-02-06 19:06:29','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/02/2025 18:51:54.1257 1106 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 18:59:18.6909 586 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 18:59:25.9408 1354 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:02:00.8947 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:04:31.0494 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:06:25.1097 1450 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 19:06:23','V',4711954208239130,2025,'2025-02-06 19:06:21','456926807500327005012999',2,2,2,'O','',0,'2025-02-06 19:06:23',1,'','',0) 06/02/2025 19:06:28.8642 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:08:36.6098 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:08:42.7039 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:12:37.1877 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:12:37.8552 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:16:17.8462 1937 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/02/2025 19:16:28.5835 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:16:32.6542 3138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:16:55.8029 2019 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/02/2025 19:18:10.5715 1926 ms. EXEC: update abbCards set carLastDate = '2025-02-06 19:18:08',carLastDirection='O' where carStatus='V' and carId = 15 06/02/2025 19:19:31.8826 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:20:06.9063 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:21:22.9769 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:23:51.7796 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:26:59.4398 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:27:03.6146 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:28:10.8932 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:28:41.4088 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:30:19.2421 815 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-02-06 19:30:18','V',4646672873066360,2025,'2025-02-06 19:30:16','456926483300327005012999',2,2,2,'O','',0,'2025-02-06 19:30:18',1,'','0230003944059',13,0) 06/02/2025 19:30:25.5273 541 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 19:30:26.3339 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:34:37.2448 2008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:36:20.5028 1910 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 19:36:26.4878 1028 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:39:39.0663 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:39:58.1122 536 ms. EXEC: update abbCards set carLastDate = '2025-02-06 19:39:57',carLastDirection='O' where carStatus='V' and carId = 82 06/02/2025 19:40:16.7968 507 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/02/2025 19:40:28.6248 528 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/02/2025 19:40:45.9366 1783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:42:23.7939 1084 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-06 19:42:22' where subId = 122 06/02/2025 19:42:26.2785 1321 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-06 19:42:24' where payTraUID = 5575788029359770 and payStatus='V' and payEnabled=1 06/02/2025 19:42:31.6192 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:43:17.6734 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:44:48.2257 800 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:45:09.0578 730 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 19:45:08','V',5442936315712280,2025,'2025-02-06 19:45:06','456926859000327005012999',2,2,2,'O','',0,'2025-02-06 19:45:08',1,'','',0) 06/02/2025 19:45:29.3045 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:51:12.9203 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 19:55:50.1090 1206 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/02/2025 19:56:46.6993 1421 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 19:57:01.5604 807 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5384, trcLastPrinted = '2500705384', trcLastDate = '2025-02-06 19:57:00' where trcStatus='V' and trcTerId = 18 06/02/2025 20:03:44.0030 505 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 20:03:43','V',5556050388856940,2025,'2025-02-06 20:03:42','456927222200327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 20:04:06.7864 569 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/02/2025 20:04:07.8251 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 20:04:58.2693 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:05:22.1405 513 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/02/2025 20:07:58.7946 1168 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:09:19.1670 535 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 20:09:43.4114 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:10:18.4732 863 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456927131900327005012999' 06/02/2025 20:10:30.2962 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:18:26.1325 764 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 20:18:40.9335 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:19:09.0215 628 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 20:19:01',12,'V',4726121951661380,5225176425125660,2025,'2025-02-06 20:19:01',17,1,0,4,'2025-02-06 20:34:01','C','KES',300,300,0,'','','',1,300,0,0,'',0,0) 06/02/2025 20:19:39.9535 674 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 20:19:41.4035 1306 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 20:19:39' where traUID = 5287279681631380 and traStatus='V' and traEnabled=1 06/02/2025 20:19:45.4672 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 20:28:19.0941 682 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 20:29:24.4944 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:30:06.4909 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 20:30:07.3695 1296 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/02/2025 20:30:25.4867 1506 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/02/2025 20:30:47.0974 508 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/02/2025 20:30:55.3480 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 20:30:55.4680 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:31:18.2545 1085 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4979124598323100,4953350090284050,2025,'2025-02-06 20:31:17',' Date: 2/6/2025 8:31:16 PM Code: 456927253700327005012999 Entry Date: 2/6/2025 8:08:57 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 # 2500705391 ',0) 06/02/2025 20:31:18.3415 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:31:52.9380 642 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/02/2025 20:33:25.3215 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:33:27.3529 2818 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 06/02/2025 20:33:45.7344 638 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 06/02/2025 20:44:35.1833 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 20:47:16.9428 1933 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/02/2025 20:48:02.7168 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 20:52:10.0774 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 20:53:50.8667 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 20:56:26.5391 722 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 20:59:03.9677 768 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 21:10:39.0015 589 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 21:10:38','V',4891679632577610,2025,'2025-02-06 21:10:38','456927623800327005012999',1,2,16,'I','',1,0,1,'','',4) 06/02/2025 21:13:54.4049 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 21:13:54.7171 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:17:27.3311 613 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-06 21:17:26','V',5646100616544690,2025,'2025-02-06 21:17:26','456926757900327005012999',2,2,2,'O','',0,'2025-02-06 21:17:26',1,'','',0) 06/02/2025 21:17:27.9985 664 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/02/2025 21:17:35.7108 595 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 21:17:58.9125 582 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 21:22:25.3039 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 21:24:45.9121 570 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/02/2025 21:25:06.0318 1090 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 06/02/2025 21:30:47.3480 1039 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/02/2025 21:32:54.5651 2075 ms. EXEC: update payReceipt set recCreation = '2025-02-06 21:32:52',recModify = '2025-02-06 21:32:52',recUseId=0,recStatus='V' where recId = 349807 06/02/2025 21:33:03.8424 594 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-06 21:33:02',0,'V',5158828362920790,4891679632577610,2025,'2025-02-06 21:33:02',3,1,0,4,'2025-02-06 21:48:02','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 06/02/2025 21:34:05.2760 1916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:34:15.2798 534 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 06/02/2025 21:35:01.4181 682 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 21:35:02.0455 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:38:51.2507 1424 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4660125856902590,5266865192772110,2025,'2025-02-06 21:38:49','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/6/2025 9:24:44 PM Date : 2/6/2025 9:38:48 PM Code : 456927708400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 50.00 KES',0) 06/02/2025 21:39:56.6650 1546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:40:24.5009 815 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-06 21:40:23',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'; 06/02/2025 21:41:20.1316 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 21:42:52.2700 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:46:07.1019 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:46:22.6035 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:48:03.5118 691 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/02/2025 21:48:03.5118 683 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 06/02/2025 21:49:53.0930 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:50:29.1945 558 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/02/2025 21:50:29.3356 621 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 06/02/2025 21:52:11.0034 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 21:52:16.1749 716 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-06 21:52:15' where traUID = 5029012344154220 and traStatus='V' and traEnabled=1 06/02/2025 21:52:18.5335 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 21:55:05.2294 847 ms. OPEN: select useParkAccess from tabUser where (useBadId = '456927525200327001012999' or useBadId = '456927525200327001012999') 06/02/2025 21:56:15.7552 1096 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/02/2025 21:59:08.7114 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:05:13.0461 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:07:06.1938 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:08:49.8360 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:14:37.3434 2032 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 06/02/2025 22:15:34.3460 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:20:15.6365 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:22:02.8421 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 22:29:51.5996 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:32:27.8294 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:34:16.5321 791 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 06/02/2025 22:34:17.2255 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 22:34:42.4316 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 22:37:54.7989 1421 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:38:09.5859 692 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5407, trcLastPrinted = '2500705407', trcLastDate = '2025-02-06 22:38:08' where trcStatus='V' and trcTerId = 18 06/02/2025 22:40:17.4966 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:42:04.0217 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:43:25.0916 690 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/02/2025 22:44:09.7599 1195 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:44:21.6059 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:47:09.8469 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:50:24.0724 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:51:29.5568 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:52:43.3698 1114 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:54:48.3644 1840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 22:57:17.7606 1915 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 06/02/2025 23:04:12.5946 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 23:05:39.9608 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/02/2025 23:07:57.9222 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 23:07:59.1291 529 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 06/02/2025 23:13:37.2931 1411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 23:14:43.5710 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 23:14:44.7928 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 23:16:59.1889 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 23:22:05.2772 704 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 06/02/2025 23:48:21.7330 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 23:53:59.8730 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/02/2025 23:54:52.3245 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1