10/02/2025 00:01:42.4615 2279 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:08:43.7836 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:12:09.3319 1268 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/02/2025 00:13:00.1381 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:13:32.4559 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:13:34.0259 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:16:43.9517 1143 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:18:36.8327 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:22:17.1930 1196 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:31:44.7769 1422 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:46:40.5768 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:48:35.5682 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:50:37.9516 1431 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 00:52:06.3350 886 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 00:55:37.9044 816 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 00:56:20.6812 1710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 01:18:31.7709 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 01:29:07.7378 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 01:30:55.4333 1855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 01:37:04.8739 2282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 01:41:21.1754 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 01:51:43.2491 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 01:53:36.7444 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 01:59:50.1087 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:03:54.1289 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:07:37.3601 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:07:38.9982 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:07:42.3885 2019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:07:47.1737 2958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:07:48.3445 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:07:50.7701 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:07:56.2348 3303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:07:59.0307 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:08:03.5067 2077 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:08:05.1588 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:08:11.0748 1760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:08:30.4588 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:08:39.0666 3553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:08:47.3092 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:09:38.1254 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:09:40.1997 1319 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:09:48.5994 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:09:50.3096 999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:10:23.4719 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:10:27.2174 1071 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:10:30.5146 2153 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:11:46.9100 1907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:12:13.1447 2106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:12:39.2182 2252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:23:00.7935 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:32:15.0364 607 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/02/2025 02:32:44.0329 3016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:32:44.0370 1690 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 10 ms.) 10/02/2025 02:34:29.8842 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:43:57.0438 1518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:48:02.5780 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:54:20.1471 1115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 02:59:55.2596 504 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/02/2025 03:01:52.2143 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:03:24.4434 1778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:05:51.3552 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:09:51.2044 741 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/02/2025 03:10:28.8347 1906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:12:12.2573 945 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 03:29:32.0080 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 03:32:34.4587 1394 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:36:12.0382 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:36:53.8693 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:37:39.9333 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:45:54.3827 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:49:37.1366 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 03:54:08.3721 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:01:56.2590 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:09:21.8218 973 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:17:12.0192 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:28:44.9775 1043 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:30:48.8058 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:32:26.3685 1833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:33:23.7561 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:37:43.2327 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:41:10.9285 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:44:33.5018 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:50:59.1603 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:51:03.6924 591 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 04:51:03',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'; 10/02/2025 04:53:31.9281 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:55:48.4290 1086 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 04:57:06.4184 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:05:38.2569 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:09:09.5490 1377 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:15:23.6338 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:15:42.6846 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:17:52.2868 560 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 05:21:50.0628 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:25:12.3379 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:31:25.7422 554 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/02/2025 05:34:56.7161 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:34:58.7785 1407 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:38:14.0409 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:39:31.2819 890 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/02/2025 05:43:54.8983 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:43:57.0287 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:44:33.1340 1718 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 05:44:33.1340 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:44:39.0480 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:44:40.5090 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:44:42.5884 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:49:48.1300 711 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 05:51:23.5692 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:51:29.0679 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:54:23.5904 1252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:54:58.4018 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 05:56:33.9371 1413 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:10:54.5822 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 06:10:58.5889 1165 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:12:55.5856 1754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:13:50.7007 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:16:00.1618 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:16:40.2648 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:17:56.6092 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:19:55.1199 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:24:55.1758 622 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/02/2025 06:40:32.6787 542 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 06:40:42.3472 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:43:01.3487 2407 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:43:18.3622 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:50:36.8683 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 06:50:38.5494 513 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456962463400327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 10/02/2025 06:50:39.9113 812 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 06:53:06.7822 607 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-10 06:53:06','V',4928114861210590,2025,'2025-02-10 06:53:05','456962478500327005012999',1,2,16,'I','',1,0,1,'','0230003957444',26,0) 10/02/2025 06:53:13.2715 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 06:53:14.8055 1458 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); (WAIT TIME 40 ms.) 10/02/2025 06:56:01.8339 569 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 10/02/2025 06:56:49.4910 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 3 ms.) 10/02/2025 07:01:57.7875 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:09:02.6574 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:11:21.7239 1228 ms. EXEC: update payReceipt set recCreation = '2025-02-10 07:11:20',recModify = '2025-02-10 07:11:20',recUseId=0,recStatus='V' where recId = 350942 10/02/2025 07:11:23.2350 1026 ms. OPEN: select * from payCurInventory where curTerId = 18 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue (WAIT TIME 37 ms.) 10/02/2025 07:14:21.3708 901 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 07:21:26.6330 1010 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:24:49.6016 1030 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/02/2025 07:26:53.3358 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:29:32.2017 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:39:11.3244 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:39:47.5088 1406 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 07:40:00.0662 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:41:17.6434 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 07:42:06.5474 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:45:19.5762 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:53:15.5886 774 ms. EXEC: update abbCards set carLastDate = '2025-02-10 07:53:14',carLastDirection='I' where carStatus='V' and carId = 185 10/02/2025 07:55:42.9407 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 07:58:57.0924 2188 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:00:37.7951 918 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 08:00:36' where payTraUID = 5482819443185740 and payStatus='V' and payEnabled=1 10/02/2025 08:00:40.0386 2241 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 08:00:36' where traUID = 5482819443185740 and traStatus='V' and traEnabled=1 10/02/2025 08:00:44.9359 757 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 08:00:54.1862 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:00:54.3022 1439 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:42',5,3,42101,0,50,-3,-150,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:42',5,3,42101,0,50,3,150,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:42',5,3,42101,0,100,-39,-3900,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:42',5,3,42101,0,100,39,3900,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:42',5,3,42101,0,200,-5,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:42',5,3,42101,0,200,5,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:42',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 10/02/2025 08:00:56.1545 1519 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:49',5,3,42101,0,50,-7,-350,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:49',5,3,42101,0,100,-49,-4900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:49',5,3,42101,0,200,-6,-1200,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:00:49',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 10/02/2025 08:03:05.5245 597 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/02/2025 08:07:38.8584 1527 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 08:07:34',5,3,42101,0,50,8,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+8,5),curAmount=round(curAmount+400,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-10 08:07:34',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-10 08:07:34',5,3,42101,0,100,12,1200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+12,5),curAmount=round(curAmount+1200,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; 10/02/2025 08:08:09.1928 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:09:00.3292 1045 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 08:09:33.7307 544 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5646097249362110,4653304758051330,2025,'2025-02-10 08:09:33','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/10/2025 7:15:54 AM Date : 2/10/2025 8:09:29 AM Code : 456962615400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 10/02/2025 08:09:56.8602 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 08:11:20.5936 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 08:11:51.5554 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:12:21.5436 836 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 08:12:22.6544 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 08:12:43.8846 557 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 08:18:08.6282 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:18:13.6105 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:20:44.9834 2689 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-10 08:20:42',4,1,'2025-02-10 08:20:42','456962463400327005012999','Payed (Credit Card ) Ticket ') 10/02/2025 08:23:03.9319 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 08:24:06.4830 1352 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-10 08:24:05','V',4924441670807510,2025,'2025-02-10 08:24:02','456963024200327005012999',1,2,16,'I','',1,0,1,'','0230003944406',17,0) 10/02/2025 08:25:17.7829 1113 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:30:30.3883 663 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-10 08:30:29','V',5330367347886850,2025,'2025-02-10 08:30:29','456962671300327005012999',2,2,2,'O','',0,'2025-02-10 08:30:29',1,'','',0) 10/02/2025 08:30:48.7286 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:30:48.7397 549 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 08:31:27.8790 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:37:31.1909 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:38:56.9506 1304 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:39:15.8023 725 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/02/2025 08:39:55.9593 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:42:46.9024 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 08:49:18.1807 568 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 10/02/2025 08:49:22.8318 558 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-10 08:49:22','V',5189343200003370,2025,'2025-02-10 08:49:19','456963175900327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 08:49:23.3692 507 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 08:49:26.4662 2765 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 08:49:47.6355 2467 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:50:52.5922 1122 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:51:36.7579 1817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:52:32.6285 1330 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-10 08:52:29',0,'V',5240198370607150,4802517227267110,2025,'2025-02-10 08:52:29',3,1,0,4,'2025-02-10 09:07:29','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 10/02/2025 08:52:33.7263 671 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 08:52:32',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'; 10/02/2025 08:55:43.7151 1097 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 08:55:43.7892 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 08:58:27.9946 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:01:20.3026 1924 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 10/02/2025 09:01:25.3900 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 09:01:48.0313 1734 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 09:01:48.0413 1739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:02:51.4189 539 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 10/02/2025 09:04:05.2526 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 09:04:50.8963 2511 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 09:06:27.6494 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:08:12.7101 2048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:08:38.5275 2728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:09:05.5907 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:10:08.9523 587 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 09:11:43.8982 616 ms. OPEN: show columns from tmpPay where Field = 'tmpVatType' 10/02/2025 09:11:44.4356 534 ms. OPEN: show columns from tabParameters where Field = 'parVatMethod' 10/02/2025 09:12:06.0641 1391 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:12:23.7891 656 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0230004101223' order by traId desc limit 1 10/02/2025 09:18:02.5780 876 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/02/2025 09:18:43.1133 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 09:19:19.2376 773 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-10 09:19:18','V',4810409200905890,2025,'2025-02-10 09:19:14','456963355400327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 09:20:58.3553 728 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-10 09:20:08',1,'V',5532763814333450,5189343200003370,2025,'2025-02-10 09:20:08',4,1,0,4,'2025-02-10 09:35:08','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 09:21:01.5425 2360 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5189343200003370,5532763814333450,2025,'2025-02-10 09:20:59',' Date: 2/10/2025 9:20:08 AM Code: 456963175900327005012999 Entry Date: 2/10/2025 8:49:19 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 # 2500401830 ',0) 10/02/2025 09:21:42.9083 570 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-10 09:21:42',0,'V',5511939995740810,4917963859641670,2025,'2025-02-10 09:21:42',18,1,0,4,'2025-02-10 09:36:42','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/02/2025 09:23:35.4690 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:23:40.5755 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 09:25:41.1316 1651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:25:44.0616 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:26:46.7097 511 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 09:26:46.7107 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:26:46.7107 508 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/02/2025 09:26:56.9776 714 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 10/02/2025 09:26:58.5257 1001 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 09:27:06.7352 505 ms. EXEC: update payCurInventory set curType='N' where curType<>'N' and curValue = 500 and curDevCode in (42102,42101,42001); 10/02/2025 09:27:55.6741 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:28:58.8076 3126 ms. EXEC: update paycash set casCreation = '2025-02-10 09:28:55',casModify = '2025-02-10 09:28:55',casUseId=0,casStatus='V' where casId = 208872 10/02/2025 09:29:01.0401 1837 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 09:28:59',0,0,'V',5304532638651960,5081193850923380,2025,'2025-02-10 09:28:59',3,'KES',-1,50,-50,'N',''); 10/02/2025 09:29:02.4421 539 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 09:29:24.6140 2350 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:30:50.3257 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:32:08.8485 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:32:17.9807 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:32:34.3957 2075 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:35:31.7200 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 09:36:42.7338 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 09:50:56.4486 864 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5045954729154180,5433598076030830,2025,'2025-02-10 09:50:55','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/10/2025 9:39:33 AM Date : 2/10/2025 9:50:53 AM Code : 456963477300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 10/02/2025 10:02:35.3399 1591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:07:18.9687 512 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-10 10:06:27',1,'V',5287947586488370,4937822173925030,2025,'2025-02-10 10:06:27',4,1,0,4,'2025-02-10 10:21:27','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 10:07:52.3392 508 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 10/02/2025 10:07:55.3262 1043 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:08:07.7226 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:08:55.6298 964 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-10 10:08:54' where subId = 198 10/02/2025 10:08:58.5087 1177 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 10:08:57' where traUID = 4943994983994360 and traStatus='V' and traEnabled=1 10/02/2025 10:09:31.8752 744 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 404443 else acvFstPayId end),acvLstPayId = 404443 where acvSftId = 894 and acvCodeId = 3 10/02/2025 10:12:53.3728 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:13:11.8182 817 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-10 10:13:10','0230003944059',0,0,5701126756120440,13,'0000-00-00 00:00:00','0000-00-00 00:00:00') 10/02/2025 10:13:22.0491 3710 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 404447 else acvFstPayId end),acvLstPayId = 404447 where acvSftId = 894 and acvCodeId = 3 10/02/2025 10:13:22.8736 529 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1045, trcLastPrinted = '2500601045', trcLastDate = '2025-02-10 10:13:22' where trcStatus='V' and trcTerId = 17 10/02/2025 10:13:31.6916 1165 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 10:13:53.9485 2239 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 10:13:51' where traUID = 5098757501796830 and traStatus='V' and traEnabled=1 10/02/2025 10:14:01.2244 1334 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 10:14:19.3957 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-10 10:13:28',1,'V',4866642627857200,4630969104570100,2025,'2025-02-10 10:13:28',4,1,0,4,'2025-02-10 10:28:28','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 10:14:20.3403 672 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 404449 else acvFstPayId end),acvLstPayId = 404449 where acvSftId = 889 and acvCodeId = 3 10/02/2025 10:14:30.2480 800 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-10 10:14:29','V',4821901047672970,2025,'2025-02-10 10:14:26','456963359100327005012999',2,2,2,'O','',0,'2025-02-10 10:14:29',1,'','',0) 10/02/2025 10:14:30.7863 536 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 10:14:35.8227 788 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 10:15:14.9611 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:16:32.2741 996 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 10:16:51.5500 651 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 10:18:12.8808 541 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/02/2025 10:19:09.2097 1039 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 10:19:09.2497 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:20:19.2088 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:22:12.1578 559 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 10:22:27.9214 1246 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/02/2025 10:24:22.3704 1415 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:26:25.3372 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:26:40.6114 1518 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 10/02/2025 10:26:50.1919 699 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5098585362062090,5728531080902020,2025,'2025-02-10 10:26:49','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/10/2025 9:38:48 AM Date : 2/10/2025 10:26:47 AM Code : 456963472800327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 10/02/2025 10:27:47.6185 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 10:28:08.0153 899 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/02/2025 10:28:46.8644 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:28:46.9945 2460 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-10 10:28:44','V',5619055245619560,2025,'2025-02-10 10:28:42','456963472800327005012999',2,2,2,'O','',0,'2025-02-10 10:28:44',1,'','',0) 10/02/2025 10:28:50.5259 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 10:30:10.5227 501 ms. OPEN: select useParkAccess from tabUser where (useBadId = '456963688400327005012999' or useBadId = '456963688400327005012999') 10/02/2025 10:30:25.1075 625 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 1 ms.) 10/02/2025 10:33:27.8134 840 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 10:35:29.3542 1682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:35:38.6325 1247 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:46:40.4328 1709 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-10 10:46:38',0,'V',5167203318763030,4862209427203850,2025,'2025-02-10 10:46:38',18,1,0,4,'2025-02-10 11:01:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 10:47:38.3068 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:49:52.1138 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:50:10.2490 1062 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 10:52:08.2654 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:52:32.3236 749 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-10 10:52:31',0,'V',5524313687305180,5755904048477420,2025,'2025-02-10 10:52:31',18,1,0,4,'2025-02-10 11:07:31','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 10:52:54.9448 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 10:53:28.2502 869 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 10:53:33.6399 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 10:55:23.9731 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 10:56:06.1415 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:56:46.5086 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 10:57:04.3967 2680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:04:35.5543 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:06:47.5731 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:15:22.6637 1596 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 10/02/2025 11:15:23.1340 1801 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 11:15:24.0146 760 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:16:00.3481 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:16:04.9202 2673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:16:42.8457 1794 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 11:16:40',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-10 11:16:40',3,42101,0,100,-3,-300,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-3,5),curAmount=round(curAmount+-300,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 11:16:40',3,42101,0,200,-3,-600,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-3,5),curAmount=round(curAmount+-600,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 10/02/2025 11:18:11.1651 904 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-10 11:18:08',0,'V',4832621020020960,4622386651647200,2025,'2025-02-10 11:18:08',3,1,0,4,'2025-02-10 11:33:08','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 10/02/2025 11:18:12.5350 616 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 11:18:11',0,0,'V',5497391230850850,4622386651647200,2025,'2025-02-10 11:18:11',3,'KES',1,100,100,'N',''); 10/02/2025 11:18:53.2454 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:22:23.8561 1840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:26:12.7492 773 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 11:27:05.4967 743 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-10 11:27:04','V',5015533483310920,2025,'2025-02-10 11:27:04','456964122400327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 11:29:24.4302 729 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 11:34:01.6647 781 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/02/2025 11:34:36.0498 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:36:01.3372 566 ms. OPEN: show columns from tabArea where Field = 'areType' 10/02/2025 11:36:01.3412 569 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 11:36:01.5003 729 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:36:02.1168 581 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 11:36:42.4759 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:38:08.8000 701 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-10 11:38:08',0,'V',5071823028751530,4918171509097530,2025,'2025-02-10 11:38:08',18,1,0,4,'2025-02-10 11:53:08','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/02/2025 11:38:09.7907 977 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5963, trcLastPrinted = '2500705963', trcLastDate = '2025-02-10 11:38:08' where trcStatus='V' and trcTerId = 18 10/02/2025 11:38:50.8833 525 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 11:38:56.3560 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:39:16.7337 1166 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 11:39:21.5199 642 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-10 11:39:20','V',4699228304688290,2025,'2025-02-10 11:39:19','456964195900327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 11:39:22.2004 663 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 11:39:51.3110 1178 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-10 11:39:48',0,'V',5632093539315290,5561294371360710,2025,'2025-02-10 11:39:48',3,1,0,4,'2025-02-10 11:54:48','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 10/02/2025 11:39:54.3290 1672 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 11:39:52',0,0,'V',5245442310774580,5561294371360710,2025,'2025-02-10 11:39:52',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-10 11:39:52',0,0,'V',5245442310774580,5561294371360710,2025,'2025-02-10 11:39:52',3,'KES',-1,100,-100,'N',''); 10/02/2025 11:39:55.2847 641 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 11:39:52',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-10 11:39:52',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'; 10/02/2025 11:43:06.0800 1153 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 11:43:44.7781 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:45:59.1357 1379 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:50:56.0105 1113 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 11:50:54',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'; 10/02/2025 11:50:56.6289 616 ms. EXEC: update payInventory set invCreation = '2025-02-10 11:50:56',invModify = '2025-02-10 11:50:56',invUseId=0,invStatus='V' where invId = 236061 10/02/2025 11:52:21.7772 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 11:53:28.4140 1289 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:54:08.8252 593 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 11:54:08.8282 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:55:48.6154 639 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 11:57:07.5275 2147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:57:52.2956 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 11:59:25.6074 681 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 12:00:41.5345 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 12:02:26.1949 964 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 12:03:35.7447 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:03:36.9705 552 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 10/02/2025 12:03:44.4175 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 12:05:24.6930 1074 ms. EXEC: update payReceipt set recCreation = '2025-02-10 12:05:23',recModify = '2025-02-10 12:05:23',recUseId=0,recStatus='V' where recId = 351018 10/02/2025 12:05:51.9223 954 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 12:08:48.6663 2155 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 12:09:08.2014 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 12:12:54.4837 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 12:13:16.5175 849 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 12:13:31.7528 1262 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-10 12:13:30','V',5613468595277070,2025,'2025-02-10 12:13:29','456964400900327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 12:19:32.2413 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:20:04.0798 698 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 12:21:12.6019 2007 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-10 12:21:10','V',5759324584902830,2025,'2025-02-10 12:21:09','456964446900327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 12:24:38.6565 1947 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 12:24:36',0,0,'V',5436219064787500,5465722190187160,2025,'2025-02-10 12:24:36',3,'KES',-2,200,-400,'N',''); 10/02/2025 12:25:08.3525 2566 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-10 12:25:05','V',5462545169158580,2025,'2025-02-10 12:25:05','456964411000327005012999',2,2,2,'O','',0,'2025-02-10 12:25:05',1,'','',0) 10/02/2025 12:25:12.1000 3736 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 12:25:16.0967 3986 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 12:25:17.5417 1438 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 12:25:16' where payTraUID = 5081515114659490 and payStatus='V' and payEnabled=1 10/02/2025 12:25:18.1571 614 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 12:25:16' where traUID = 5081515114659490 and traStatus='V' and traEnabled=1 10/02/2025 12:25:18.3242 1346 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:25:24.4894 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:26:13.0470 637 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5969, trcLastPrinted = '2500705969', trcLastDate = '2025-02-10 12:26:12' where trcStatus='V' and trcTerId = 18 10/02/2025 12:27:57.3432 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:30:16.0436 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:31:06.2283 656 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '456964011800327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 10/02/2025 12:31:52.3674 1038 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 12:31:51' where traUID = 5464608304022420 and traStatus='V' and traEnabled=1 10/02/2025 12:31:58.4745 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:32:11.8815 805 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-10 12:32:11','V',4900022518962250,2025,'2025-02-10 12:32:10','456964336600327005012999',2,2,2,'O','',0,'2025-02-10 12:32:11',1,'','',0) 10/02/2025 12:32:14.4903 1809 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 12:32:12' where payTraUID = 5453737761007290 and payStatus='V' and payEnabled=1 10/02/2025 12:32:15.7891 1297 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 12:32:12' where traUID = 5453737761007290 and traStatus='V' and traEnabled=1 10/02/2025 12:32:16.4576 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:32:44.6215 989 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 12:32:43' where payTraUID = 5018498856686140 and payStatus='V' and payEnabled=1 10/02/2025 12:34:13.1611 1030 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:34:58.0513 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 12:35:52.5740 650 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-10 12:35:51','0560008304916',0,0,4677777257326530,190,'0000-00-00 00:00:00','0000-00-00 00:00:00') 10/02/2025 12:35:54.0920 904 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 12:35:53' where payTraUID = 4734423935208990 and payStatus='V' and payEnabled=1 10/02/2025 12:35:55.4289 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 12:38:04.4337 753 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-10 12:38:03','V',4701203985539780,2025,'2025-02-10 12:38:02','456964548200327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 12:38:10.0185 588 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 12:38:09' where payTraUID = 5613468595277070 and payStatus='V' and payEnabled=1 10/02/2025 12:38:15.3751 545 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/02/2025 12:38:19.1867 666 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/02/2025 12:38:22.9992 1903 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 12:40:08.4282 700 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 12:40:14.3091 580 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1052, trcLastPrinted = '2500601052', trcLastDate = '2025-02-10 12:40:13' where trcStatus='V' and trcTerId = 17 10/02/2025 12:41:47.0065 575 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 12:41:45',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/02/2025 12:41:47.9261 804 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 12:41:47',0,0,'V',5086330008613960,4869765212571010,2025,'2025-02-10 12:41:47',3,'KES',-1,50,-50,'N',''); 10/02/2025 12:41:57.6547 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:42:29.9124 1196 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 12:42:42.3618 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 11 ms.) 10/02/2025 12:42:47.5322 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:48:33.9864 914 ms. EXEC: update payReceipt set recCreation = '2025-02-10 12:48:33',recModify = '2025-02-10 12:48:33',recUseId=0,recStatus='V' where recId = 351040 10/02/2025 12:48:36.2139 1797 ms. EXEC: update payInventory set invCreation = '2025-02-10 12:48:34',invModify = '2025-02-10 12:48:34',invUseId=0,invStatus='V' where invId = 236076 10/02/2025 12:48:36.2199 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 12:49:27.7055 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 12:52:49.2762 2321 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 12:52:49.5544 520 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 12:53:44.4443 737 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/02/2025 13:03:30.5707 776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:04:42.6412 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:05:39.0061 656 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 13:06:28.5775 787 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 13:06:27',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-10 13:06:27',3,42101,0,100,-4,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/02/2025 13:09:12.8680 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:09:16.2833 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:09:46.4076 640 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 13:09:46.4106 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:09:47.9857 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:10:39.5634 530 ms. EXEC: update payInventory set invCreation = '2025-02-10 13:10:39',invModify = '2025-02-10 13:10:39',invUseId=0,invStatus='V' where invId = 236085 10/02/2025 13:10:40.9923 1293 ms. EXEC: update paycash set casCreation = '2025-02-10 13:10:39',casModify = '2025-02-10 13:10:39',casUseId=0,casStatus='V' where casId = 208921 10/02/2025 13:10:42.0971 1103 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 13:10:39',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 10/02/2025 13:12:15.8362 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:12:38.1582 507 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 13:15:04.2115 676 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 13:15:03' where traUID = 5029776589022120 and traStatus='V' and traEnabled=1 10/02/2025 13:15:10.3266 1353 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:15:48.9256 1874 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 13:16:50.0307 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:18:02.7876 998 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:19:08.0365 577 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 13:19:11.7800 564 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 13:23:38.4185 836 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 13:26:20.3124 515 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-10 13:26:19' where subId = 178 10/02/2025 13:28:08.7164 835 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 13:29:13.7771 507 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 13:29:58.5953 657 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-10 13:29:57','V',4920876771901310,2025,'2025-02-10 13:29:56','456964859600327001012999',1,2,1,'I','',1,0,1,'','',4) 10/02/2025 13:30:00.8478 845 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 13:29:59' where payTraUID = 4958254814806740 and payStatus='V' and payEnabled=1 10/02/2025 13:31:08.5063 948 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 13:31:08.8576 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:36:23.9840 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:36:49.2680 569 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-10 13:36:48',17,12,'2025-02-10 13:36:48','456964294300327005012999','Pagato (Contanti ) Biglietto ') 10/02/2025 13:37:37.2653 688 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 13:40:47.3442 709 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-10 13:40:46','V',5352764143948830,2025,'2025-02-10 13:40:46','456964446900327005012999',2,2,2,'O','',0,'2025-02-10 13:40:46',1,'','',0) 10/02/2025 13:40:48.1877 562 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 13:40:47' where payTraUID = 5759324584902830 and payStatus='V' and payEnabled=1 10/02/2025 13:40:52.8849 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:43:13.6116 724 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 13:45:27.5818 1107 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:45:35.2309 717 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-10 13:45:34',0,'V',5047314960368830,4701203985539780,2025,'2025-02-10 13:45:34',3,1,0,4,'2025-02-10 14:00:34','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 10/02/2025 13:47:41.3167 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:48:05.7982 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:48:26.3430 2019 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-10 13:48:24','V',5749823331035070,2025,'2025-02-10 13:48:06','456964968600327001031999',1,2,1,'I','',1,0,1,'','',4) 10/02/2025 13:49:22.6840 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:49:42.7274 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:49:49.8362 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:50:10.9394 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:50:27.7407 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:50:43.4553 1549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 13:51:01.1342 919 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 13:51:01.8367 890 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-10 13:51:00',0,'V',4759959090326370,5340612647947890,2025,'2025-02-10 13:51:00',18,1,0,4,'2025-02-10 14:06:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 13:51:03.1045 1165 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5986, trcLastPrinted = '2500705986', trcLastDate = '2025-02-10 13:51:01' where trcStatus='V' and trcTerId = 18 10/02/2025 13:51:04.6986 1572 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5340612647947890,4759959090326370,2025,'2025-02-10 13:51:03',' Date: 2/10/2025 1:51:00 PM Code: 456964952100327001012999 Entry Date: 2/10/2025 1:45:21 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500705986 ',0) 10/02/2025 13:52:09.8785 793 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 13:52:10.7681 585 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 13:52:10' where payTraUID = 5340612647947890 and payStatus='V' and payEnabled=1 10/02/2025 13:53:11.4379 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:53:45.2396 1930 ms. EXEC: update payReceipt set recCreation = '2025-02-10 13:53:43',recModify = '2025-02-10 13:53:43',recUseId=0,recStatus='V' where recId = 351071 10/02/2025 13:54:27.3059 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:54:28.1855 612 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-50,5),subLastDebit = '2025-02-10 13:54:27' where subId = 49 10/02/2025 13:54:30.0828 684 ms. EXEC: update abbCards set carLastDate = '2025-02-10 13:54:29',carLastDirection='O' where carStatus='V' and carId = 50 10/02/2025 13:54:31.2516 1116 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 13:54:30' where payTraUID = 4986668771200020 and payStatus='V' and payEnabled=1 10/02/2025 13:54:33.2880 2035 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 13:54:30' where traUID = 4986668771200020 and traStatus='V' and traEnabled=1 10/02/2025 13:54:38.0312 2086 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traCode = '456965007500327005012999' and traDirection='I' order by traId DESC LIMIT 1 nr: 845308 10/02/2025 13:56:55.4716 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 13:58:48.7479 2026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:01:45.6459 738 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 14:02:11.5804 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:05:30.8755 1521 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-10 14:05:29','V',4955260344934190,2025,'2025-02-10 14:05:25','456965008900327001012999',2,2,2,'O','',0,'2025-02-10 14:05:29',1,'','0230003944081',15,0) 10/02/2025 14:05:32.1513 658 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 14:05:32.9098 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:05:32.9609 806 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCarId = 15 10/02/2025 14:05:36.1200 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:07:58.1736 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:09:39.7910 1034 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:10:32.2943 1730 ms. EXEC: update payReceipt set recCreation = '2025-02-10 14:10:30',recModify = '2025-02-10 14:10:30',recUseId=0,recStatus='V' where recId = 351074 10/02/2025 14:11:52.3922 641 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 10/02/2025 14:13:29.3134 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:14:20.9782 2752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:14:36.1244 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:14:58.1602 839 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 14:15:34.1124 1026 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-10 14:15:33','V',5451406696337270,2025,'2025-02-10 14:15:31','456964794000327005012999',2,2,2,'O','',0,'2025-02-10 14:15:33',1,'','',0) 10/02/2025 14:15:34.9159 569 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 14:18:43.9141 605 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-10 14:18:43','0230004098588',0,0,5077312916646900,183,'0000-00-00 00:00:00','0000-00-00 00:00:00') 10/02/2025 14:18:56.1684 1427 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:20:20.9084 753 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 14:20:19',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'; 10/02/2025 14:20:43.8318 1005 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-10 14:20:42',0,'V',5725384410412920,5023672309604340,2025,'2025-02-10 14:20:42',18,1,0,4,'2025-02-10 14:35:42','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 14:21:42.5773 1840 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 10/02/2025 14:21:42.6234 1679 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 14:22:42.1915 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:22:54.2716 1396 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:23:38.7205 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:23:39.3439 590 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 14:24:16.5369 1368 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/02/2025 14:24:16.8031 2204 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5320420247876920,5413953004413660,2025,'2025-02-10 14:24:14',' Date: 2/10/2025 2:24:14 PM Code: 456965002700327005012999 Entry Date: 2/10/2025 1:53:47 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 # 2500705992 ',0) (WAIT TIME 246 ms.) 10/02/2025 14:24:30.8095 1711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:25:23.4700 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:25:49.9848 1135 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:25:53.4772 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:26:40.7770 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:28:11.3059 632 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 14:28:13.8236 1158 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 14:28:12' where payTraUID = 4735429514278800 and payStatus='V' and payEnabled=1 10/02/2025 14:28:17.9274 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:28:18.1755 722 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 14:29:55.8393 548 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/02/2025 14:31:11.1049 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:31:11.1069 1517 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5995, trcLastPrinted = '2500705995', trcLastDate = '2025-02-10 14:31:09' where trcStatus='V' and trcTerId = 18 10/02/2025 14:31:11.7904 642 ms. EXEC: update payReceipt set recCreation = '2025-02-10 14:31:11',recModify = '2025-02-10 14:31:11',recUseId=0,recStatus='V' where recId = 351092 10/02/2025 14:31:12.8601 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:32:18.5743 3061 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 14:33:58.2304 1175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:34:03.1657 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:34:49.8871 1531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:40:52.5382 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:41:09.1243 607 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456964939100327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 10/02/2025 14:43:15.1741 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:43:53.6270 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:44:45.1287 1701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:47:25.3285 850 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 14:53:04.4267 2427 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-10 14:53:01','V',4722138436905310,2025,'2025-02-10 14:53:01','456965358100327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 14:53:14.7326 611 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/02/2025 14:54:02.6338 1246 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 14:54:01',3,42101,0,100,-4,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/02/2025 14:54:04.1889 708 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 14:56:35.1354 966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:57:19.5964 1489 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 14:57:31.3283 965 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 15:01:05.2242 770 ms. EXEC: update payReceipt set recCreation = '2025-02-10 15:01:04',recModify = '2025-02-10 15:01:04',recUseId=0,recStatus='V' where recId = 351104 10/02/2025 15:02:04.3870 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:02:46.4443 652 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4722138436905310,5212278919035040,2025,'2025-02-10 15:02:45',' Data: 2/10/2025 3:02:37 PM Codice: 456965358100327005012999 Ingresso: 2/10/2025 2:53:01 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500601062 ',0) 10/02/2025 15:02:47.3989 954 ms. EXEC: update payReceipt set recCreation = '2025-02-10 15:02:46',recModify = '2025-02-10 15:02:46',recUseId=0,recStatus='V' where recId = 351106 10/02/2025 15:02:49.2112 587 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100 10/02/2025 15:03:16.4375 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:04:25.5190 801 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 15:04:34.5250 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:06:40.9961 2494 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 15:06:38',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-10 15:06:38',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'; 10/02/2025 15:06:52.5459 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:06:54.9605 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:07:26.9380 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:08:43.0813 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:11:06.9481 501 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 15:13:11.5359 502 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-10 15:13:10',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'; 10/02/2025 15:13:11.5740 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:13:35.4810 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:13:58.0662 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:14:07.3775 640 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 15:14:07.3935 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:14:53.8278 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:15:53.2848 727 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 15:17:13.8690 815 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 15:17:35.9949 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:17:47.7028 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:18:50.7742 876 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:19:12.8921 656 ms. EXEC: update payInventory set invCreation = '2025-02-10 15:19:12',invModify = '2025-02-10 15:19:12',invUseId=0,invStatus='V' where invId = 236124 10/02/2025 15:20:26.2304 555 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 15:23:28.4230 1076 ms. EXEC: update payInventory set invCreation = '2025-02-10 15:23:27',invModify = '2025-02-10 15:23:27',invUseId=0,invStatus='V' where invId = 236126 10/02/2025 15:24:04.8586 573 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 15:24:04',0,0,'V',5019454359705800,5460723901654050,2025,'2025-02-10 15:24:04',3,'KES',1,50,50,'N',''); 10/02/2025 15:25:14.3003 554 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 15:25:58.0327 1317 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:27:34.9649 1191 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 10/02/2025 15:29:13.5943 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:29:22.9716 557 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 10/02/2025 15:29:46.8707 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:30:31.8350 776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:30:42.0718 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:35:11.3080 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:37:16.7744 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:37:42.5688 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:44:27.2028 784 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/02/2025 15:46:35.4792 521 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 15:48:25.2720 634 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 15:49:31.0153 736 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 15:50:17.3144 788 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 15:50:16',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'; 10/02/2025 15:50:17.4535 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:50:48.0952 1156 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-10 15:50:46','V',5461941958867830,2025,'2025-02-10 15:50:46','456965704600327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 15:51:32.9383 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:52:03.2787 861 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 15:52:04.7087 1397 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); (WAIT TIME 1 ms.) 10/02/2025 15:53:04.8452 882 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-10 15:52:13',1,'V',5676869427677720,5171710276195290,2025,'2025-02-10 15:52:13',4,1,0,4,'2025-02-10 16:07:13','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 15:53:47.3067 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 15:53:47.3548 625 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 15:53:49.4732 1102 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 15:54:24.5518 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:01:09.5415 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:02:47.1001 668 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4928475599650350,5092361678872500,2025,'2025-02-10 16:02:46',' Data: 2/10/2025 4:02:38 PM Codice: 456964100400327005012999 Ingresso: 2/10/2025 11:23:24 AM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 300.00 KES ______________________________ Pagato: 300.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500601068 ',0) 10/02/2025 16:03:53.9611 3264 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/02/2025 16:04:02.2537 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:08:06.2449 1836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:09:11.3417 526 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5351550943367570,5406790024572010,2025,'2025-02-10 16:09:10',' Date: 2/10/2025 4:09:10 PM Code: 456965696900327005012999 Entry Date: 2/10/2025 3:49:29 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 # 2500706013 ',0) 10/02/2025 16:10:06.1075 598 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-10 16:10:05','V',5268426369797560,2025,'2025-02-10 16:10:02','456964100400327005012999',2,2,2,'O','',0,'2025-02-10 16:10:05',1,'','',0) 10/02/2025 16:10:16.7397 585 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 16:10:18.3538 810 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 16:10:17',0,0,'V',5620782967006940,5690106894258990,2025,'2025-02-10 16:10:17',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-10 16:10:17',0,0,'V',5620782967006940,5690106894258990,2025,'2025-02-10 16:10:17',3,'KES',-1,100,-100,'N',''); 10/02/2025 16:10:19.4915 1103 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 16:10:17',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-10 16:10:17',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'; 10/02/2025 16:10:21.8861 2391 ms. EXEC: update payInventory set invCreation = '2025-02-10 16:10:19',invModify = '2025-02-10 16:10:19',invUseId=0,invStatus='V' where invId = 236138 10/02/2025 16:11:30.8906 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:12:22.5273 545 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-10 16:12:21','V',5433577324518890,2025,'2025-02-10 16:12:18','456965486200327001012999',2,2,2,'O','',0,'2025-02-10 16:12:21',1,'','',0) 10/02/2025 16:12:29.0467 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:12:45.5478 575 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 16:13:00.9382 1908 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/02/2025 16:13:27.7972 1171 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:13:52.6440 743 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-10 16:13:51','V',5349093391537790,2025,'2025-02-10 16:13:50','456965406700327005012999',2,2,2,'O','',0,'2025-02-10 16:13:51',1,'','',0) 10/02/2025 16:14:09.6024 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:17:32.5079 631 ms. EXEC: update paycash set casCreation = '2025-02-10 16:17:31',casModify = '2025-02-10 16:17:31',casUseId=0,casStatus='V' where casId = 208974 10/02/2025 16:17:33.8258 1317 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 16:17:31',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-10 16:17:31',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'; 10/02/2025 16:18:04.4024 909 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 10/02/2025 16:18:25.9038 608 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 16:18:55.3747 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:20:56.6483 596 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 16:20:56' where payTraUID = 5367697709282070 and payStatus='V' and payEnabled=1 10/02/2025 16:25:20.4698 1464 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:26:41.0300 1187 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 16:26:47.3373 1102 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:28:11.9122 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:28:37.0531 829 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/02/2025 16:28:37.0571 625 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 16:29:22.3696 528 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 16:29:25.1995 3230 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:31:19.3333 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:31:57.8382 1214 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:33:57.7429 572 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 16:36:20.4689 605 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-10 16:36:19','V',5379266207309100,2025,'2025-02-10 16:36:19','456965977900327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 16:37:51.8104 603 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 16:37:51' where traUID = 5528591927832830 and traStatus='V' and traEnabled=1 10/02/2025 16:37:55.4739 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:41:28.3561 675 ms. EXEC: update payReceipt set recCreation = '2025-02-10 16:41:27',recModify = '2025-02-10 16:41:27',recUseId=0,recStatus='V' where recId = 351159 10/02/2025 16:41:49.8536 802 ms. OPEN: select * from tabTerminal where terId = 16 10/02/2025 16:42:02.1238 2886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:45:02.5893 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 16:46:15.8296 680 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1870, trcLastPrinted = '2500401870', trcLastDate = '2025-02-10 16:46:15' where trcStatus='V' and trcTerId = 4 10/02/2025 16:54:28.0377 551 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/02/2025 16:55:54.2737 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:57:31.5942 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 16:58:01.6234 553 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 10/02/2025 17:03:02.1186 1566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:03:24.5217 697 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 17:03:53.9795 1956 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-10 17:03:52',0,'V',4682753361558720,5416876794198490,2025,'2025-02-10 17:03:52',2,1,0,-1,'2025-02-10 18:03:52','S','KES',0,0,0,'','','',3,0,0) 10/02/2025 17:03:54.8851 771 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 17:05:31.1269 1083 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 17:05:34.7943 567 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 17:06:37.6196 763 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 17:07:39.3401 1260 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/02/2025 17:08:37.5133 1898 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 17:09:18.4458 554 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-10 17:09:17',0,16,'2025-02-10 17:09:17','','Unauthorized Transit Entry 2') 10/02/2025 17:10:36.6765 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:10:38.9730 565 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 17:10:38' where traUID = 4939374096515860 and traStatus='V' and traEnabled=1 10/02/2025 17:10:42.4614 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 17:11:07.8514 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 17:11:38.7262 1068 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 17:13:22.1338 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 17:13:23.3907 1227 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 17:16:03.4038 620 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 10/02/2025 17:17:17.4005 795 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 17:17:19.9302 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:26:15.7528 515 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 17:30:47.9980 918 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/02/2025 17:33:19.6150 538 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-10 17:33:16',0,'V',5402698107116830,5554955029256820,2025,'2025-02-10 17:33:16',3,1,0,4,'2025-02-10 17:48:16','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 10/02/2025 17:34:14.1307 541 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 17:39:03.4224 1225 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 10/02/2025 17:39:38.4029 967 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/02/2025 17:40:32.0981 607 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 17:42:55.8238 721 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 17:43:01.8438 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:48:57.6783 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:49:14.0633 787 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 17:49:21.8155 1726 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/02/2025 17:52:02.8148 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:52:42.5456 2335 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:54:16.9501 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:55:37.3232 775 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-10 17:55:36','V',5606259662816310,2025,'2025-02-10 17:55:33','456962929100327005012999',2,2,2,'O','',0,'2025-02-10 17:55:36',1,'','0230003950907',19,0) 10/02/2025 17:55:43.9476 953 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 17:55:50.2639 1509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 17:56:08.2080 851 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 17:56:08.5412 2106 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 17:56:46.5968 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 17:59:34.8620 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 18:00:21.0871 525 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 18:06:18.5267 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 18:08:10.3119 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:08:49.9055 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:10:31.0276 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:10:47.9289 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:12:40.2906 9472 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 10/02/2025 18:12:40.2936 9540 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 18:12:54.1969 1593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:14:33.9941 871 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456964819000327001012999' 10/02/2025 18:14:35.0628 1060 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 10/02/2025 18:14:35.2959 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:14:47.5842 1218 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:15:52.5139 585 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 10/02/2025 18:15:53.2024 1811 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 18:15:51' where traUID = 5422481172783780 and traStatus='V' and traEnabled=1 10/02/2025 18:16:14.7659 515 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 18:16:21.9397 4923 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 10/02/2025 18:17:50.3012 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 18:18:04.0564 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:19:28.1590 660 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 18:20:30.2518 1860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:20:32.2892 1526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:20:39.0897 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:20:46.1285 1508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:21:08.3254 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:21:13.5019 1191 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:21:13.5079 661 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 18:23:30.2119 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:24:05.4706 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:24:23.3657 1593 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-10 18:24:21','V',5147014220896350,2025,'2025-02-10 18:24:19','456966105000327005012999',2,2,2,'O','',0,'2025-02-10 18:24:21',1,'','',0) 10/02/2025 18:38:07.6982 1456 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 18:39:08.7142 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:39:23.6273 1319 ms. EXEC: update payReceipt set recCreation = '2025-02-10 18:39:22',recModify = '2025-02-10 18:39:22',recUseId=0,recStatus='V' where recId = 351198 10/02/2025 18:39:24.8911 958 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 18:39:23',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-10 18:39:23',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'; 10/02/2025 18:39:25.5255 633 ms. EXEC: update payInventory set invCreation = '2025-02-10 18:39:24',invModify = '2025-02-10 18:39:24',invUseId=0,invStatus='V' where invId = 236156 10/02/2025 18:40:29.3655 3062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:40:29.5136 2689 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 18:40:57.1422 851 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 18:41:06.5145 870 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 18:41:05' where traUID = 5435405229861040 and traStatus='V' and traEnabled=1 10/02/2025 18:41:14.0296 867 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 10/02/2025 18:41:27.1494 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:41:31.0340 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:41:34.0420 555 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 18:42:39.0668 545 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/02/2025 18:45:26.9407 565 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 18:46:43.0089 804 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 18:47:02.2649 1390 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 18:47:03.0194 1844 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/02/2025 18:47:07.4284 608 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-10 18:47:06','V',5015576040951440,2025,'2025-02-10 18:47:05','456966762500327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 18:47:27.3948 3011 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:47:45.7932 578 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/02/2025 18:48:28.3638 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-10 18:48:27','V',4804789386210340,2025,'2025-02-10 18:48:27','456966721000327005012999',2,2,2,'O','',0,'2025-02-10 18:48:27',1,'','',0) 10/02/2025 18:48:29.9659 604 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 10/02/2025 18:48:38.7778 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:49:31.7505 1229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:49:39.4026 2792 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 18:51:04.3478 1446 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:51:29.4517 852 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-10 17:51:28') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-10 18:51:28' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-10 18:51:28' and (resAreId = 1 or resAreId <= 0) nr: 0 10/02/2025 18:51:30.2482 765 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/02/2025 18:51:33.2673 630 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 18:51:41.0935 1438 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-10 18:51:39','V',5538600366496750,2025,'2025-02-10 18:51:39','456966789900327001012999',1,2,1,'I','',1,0,1,'','',4) 10/02/2025 18:52:00.9709 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:52:48.6220 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 18:52:53.4572 609 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/02/2025 18:52:57.0526 2112 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-10 18:52:54','V',5226924950750090,2025,'2025-02-10 18:52:53','456963314200327005012999',2,2,2,'O','',0,'2025-02-10 18:52:54',1,'','0230004101223',11,0) 10/02/2025 19:00:31.9477 1520 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 10/02/2025 19:04:05.9788 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:06:47.3103 1687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:07:15.7985 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:09:15.7052 733 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-10 19:09:14','V',5411424474630620,2025,'2025-02-10 19:09:13','456966895300327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 19:09:15.7232 684 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-10 19:09:14',0,'V',5113918877532480,5113454565752640,2025,'2025-02-10 19:09:14',18,1,0,4,'2025-02-10 19:24:14','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 19:09:36.9245 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:10:22.1879 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 19:10:23.3627 1866 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/02/2025 19:10:23.4818 2299 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 10/02/2025 19:10:23.4898 1073 ms. OPEN: show columns from tabArea where Field = 'areType' 10/02/2025 19:10:34.1440 852 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 19:11:55.1615 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:22:11.7654 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:28:29.3825 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:29:18.2364 1380 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:35:26.3321 1005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:36:03.3360 2080 ms. EXEC: update abbCards set carLastDate = '2025-02-10 19:36:01',carLastDirection='O' where carStatus='V' and carId = 171 10/02/2025 19:36:39.6664 2444 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-10 19:36:37',0,'V',4961520964329230,5015576040951440,2025,'2025-02-10 19:36:37',18,1,0,4,'2025-02-10 19:51:37','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 19:36:40.5220 773 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6046, trcLastPrinted = '2500706046', trcLastDate = '2025-02-10 19:36:39' where trcStatus='V' and trcTerId = 18 10/02/2025 19:37:39.2915 1488 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 19:40:01.9435 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:41:12.4150 595 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/02/2025 19:41:13.5868 1149 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-10 19:41:12' where payTraUID = 5288473505780900 and payStatus='V' and payEnabled=1 10/02/2025 19:45:10.8474 1033 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-10 19:45:09','V',4929332161547170,2025,'2025-02-10 19:45:08','456967110800327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 19:46:37.0624 1017 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 19:53:40.8482 1234 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 19:53:41.9310 832 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 19:53:41' where traUID = 5668013205164110 and traStatus='V' and traEnabled=1 10/02/2025 19:53:47.4026 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 19:53:52.8123 881 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/02/2025 19:54:16.6093 877 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 19:54:53.4561 691 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/02/2025 19:56:18.5874 861 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-10 19:56:17',0,'V',5158511468271670,5411424474630620,2025,'2025-02-10 19:56:17',18,1,0,4,'2025-02-10 20:11:17','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/02/2025 19:58:15.6942 695 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 19:59:01.9023 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:01:11.8897 1069 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:07:34.1720 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 20:07:39.7718 611 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 20:09:21.9625 1082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:11:37.7859 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:16:21.9581 790 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 20:16:35.5753 608 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 20:20:51.4275 594 ms. EXEC: update payInventory set invCreation = '2025-02-10 20:20:50',invModify = '2025-02-10 20:20:50',invUseId=0,invStatus='V' where invId = 236163 10/02/2025 20:22:28.5989 748 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/02/2025 20:22:28.6069 1127 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/02/2025 20:22:58.6931 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:24:07.1031 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 20:25:14.2343 2065 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4801171867803330,4762072422840960,2025,'2025-02-10 20:25:12',' Data: 2/10/2025 8:25:03 PM Codice: 456966780700327005012999 Ingresso: 2/10/2025 6:50:07 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500601074 ',0) 10/02/2025 20:25:45.2322 782 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 20:25:44' where traUID = 4929332161547170 and traStatus='V' and traEnabled=1 10/02/2025 20:25:47.1645 1904 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 10/02/2025 20:25:50.3906 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 20:27:05.5692 616 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 20:28:13.9314 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:28:25.6883 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:29:08.1439 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:33:43.9915 979 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-10 20:33:43' where subId = 177 10/02/2025 20:33:48.2064 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 20:34:06.4737 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:35:24.7443 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:42:25.2033 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:44:24.8968 1520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:46:28.7021 935 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 20:46:28.8382 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:50:32.8414 789 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-10 20:50:32','V',4967837059690730,2025,'2025-02-10 20:50:30','456967503000327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 20:50:42.4909 1483 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-10 20:50:41',0,16,'2025-02-10 20:50:41','','Unauthorized Transit Entry 2') 10/02/2025 20:53:34.6277 1555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 20:56:35.3423 578 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-10 20:56:34','V',4881076064380070,2025,'2025-02-10 20:56:34','456967539400327001012999',1,2,1,'I','',1,0,1,'','',4) 10/02/2025 21:01:11.0509 1057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:01:20.9765 1005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:10:04.2086 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 21:12:42.2640 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:15:31.0035 726 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-10 21:15:30','V',5193686585843330,2025,'2025-02-10 21:15:30','456967653000327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 21:18:20.2114 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:20:48.7904 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:22:52.5166 621 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 21:23:15.5621 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:28:01.5926 1475 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:30:46.0993 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:31:19.1556 838 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6061, trcLastPrinted = '2500706061', trcLastDate = '2025-02-10 21:31:18' where trcStatus='V' and trcTerId = 18 10/02/2025 21:31:49.9643 2924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:31:57.4904 1379 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:35:30.2976 546 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-10 21:35:29','V',5162413903700840,2025,'2025-02-10 21:35:28','456967772800327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 21:41:03.8530 813 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 21:41:10.2953 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 21:43:15.5957 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:43:22.1040 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:43:26.1267 792 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/02/2025 21:44:30.3159 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:44:47.4695 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 21:44:55.8361 928 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 21:44:54',0,0,'V',5712276780471470,4881076064380070,2025,'2025-02-10 21:44:54',3,'KES',1,50,50,'N',''); 10/02/2025 21:45:07.5970 732 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/02/2025 21:47:28.2767 744 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 21:49:29.5763 924 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 21:49:35.4413 877 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 21:53:08.8209 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:54:17.6512 2195 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/02/2025 21:55:54.1611 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:56:19.4261 2074 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:56:26.8041 789 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 10/02/2025 21:56:37.1110 1144 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 21:57:19.7427 1603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:58:04.0075 543 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6063, trcLastPrinted = '2500706063', trcLastDate = '2025-02-10 21:58:03' where trcStatus='V' and trcTerId = 18 10/02/2025 21:58:19.9842 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 21:58:58.5272 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:01:43.0018 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:05:06.2066 2914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:08:59.4145 963 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-10 22:08:58',0,0,'V',5011246592117190,5363914135274330,2025,'2025-02-10 22:08:58',3,'KES',1,50,50,'N',''); 10/02/2025 22:09:00.0349 535 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 22:08:58',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'; 10/02/2025 22:09:45.0883 1754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:11:10.8199 1908 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/02/2025 22:18:37.3214 1108 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-10 22:18:36',0,16,'2025-02-10 22:18:36','','Unauthorized Transit Entry 2') 10/02/2025 22:23:39.5127 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:24:38.4394 522 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-10 22:24:37','V',4988776216144270,2025,'2025-02-10 22:24:37','456968067700327005012999',1,2,16,'I','',1,0,1,'','',4) 10/02/2025 22:27:14.7776 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:29:52.0714 1072 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:31:07.5702 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:34:02.8732 725 ms. EXEC: update payReceipt set recCreation = '2025-02-10 22:34:02',recModify = '2025-02-10 22:34:02',recUseId=0,recStatus='V' where recId = 351255 10/02/2025 22:34:04.0370 758 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 22:34:03',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'; 10/02/2025 22:36:02.0564 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 22:41:29.7889 646 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-10 22:41:29',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/02/2025 22:42:49.7618 517 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/02/2025 22:43:15.3890 1331 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:45:27.7281 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 22:46:23.3135 1424 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:47:19.0219 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 22:47:20.0356 984 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/02/2025 22:47:40.3553 976 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-10 22:47:39','V',4908115856776140,2025,'2025-02-10 22:47:36','456967653000327005012999',2,2,2,'O','',0,'2025-02-10 22:47:39',1,'','',0) 10/02/2025 22:50:32.6482 1924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:50:40.5265 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 22:53:27.3418 1894 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 22:55:34.2312 868 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-10 22:55:33' where traUID = 5149431299923920 and traStatus='V' and traEnabled=1 10/02/2025 22:56:23.5914 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/02/2025 22:56:42.5121 935 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-10 22:56:41' where subId = 16 10/02/2025 23:08:56.2659 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 23:11:22.2012 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 23:18:57.3045 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 23:20:05.3853 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 23:30:53.9717 545 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/02/2025 23:40:18.9529 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 23:46:18.4839 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 23:46:25.2014 905 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/02/2025 23:51:43.9899 1921 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/02/2025 23:54:39.5901 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1