13/02/2025 00:16:20.0087 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 00:18:57.1064 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 00:22:39.5831 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 00:26:24.5405 1161 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 00:37:05.9412 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 00:41:24.3191 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 00:41:30.5332 1702 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/02/2025 00:47:40.1430 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:00:01.0604 1072 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:02:22.6967 2048 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 01:02:22.7277 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:02:30.1717 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:04:44.7773 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 01:05:06.6530 629 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/02/2025 01:07:24.7279 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:07:24.8420 1102 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 13/02/2025 01:12:08.0016 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:12:26.5120 642 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 01:13:27.4470 928 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/02/2025 01:13:54.1390 1330 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 01:17:42.1244 2080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:18:28.7838 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:19:51.5605 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:28:06.1660 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:29:03.7157 1313 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:34:30.9325 1193 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:40:14.9260 2121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:41:34.9969 1711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:42:18.8274 1604 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 01:48:43.7612 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:58:06.8651 1547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 01:59:01.3737 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:06:33.9613 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:08:25.9096 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:09:08.6724 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:10:46.6774 1536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:13:02.4647 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:13:04.2619 518 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/02/2025 02:14:50.3833 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:14:51.2059 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:18:06.6794 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:23:48.1429 796 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/02/2025 02:27:42.0124 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:29:06.2251 1114 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:30:01.0860 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:32:27.9928 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:33:41.4393 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:35:34.9426 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:38:51.7050 2074 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:39:06.3509 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:43:32.7121 1487 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 02:49:43.8058 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:08:25.9529 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:12:36.5616 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:23:26.2461 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:24:42.8606 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:25:45.6449 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 03:29:42.3261 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:30:18.4314 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:24.3157 3881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:28.4745 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:31.8418 1488 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:34.6807 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:38.5593 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:41.2972 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:45.3629 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:47.3082 875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:54.2279 1539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:31:56.7886 1489 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:32:01.9020 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:32:06.2430 2502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:32:12.3841 1623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:32:12.4932 985 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/02/2025 03:32:21.9695 1188 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:32:24.4482 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:32:27.3342 1561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:32:28.9462 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:32:38.3005 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:33:04.8324 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:42:43.7035 604 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/02/2025 03:49:15.2790 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:54:26.0291 2085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 03:55:41.2657 944 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 04:02:14.8385 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:12:14.3005 736 ms. EXEC: update payInventory set invCreation = '2025-02-13 04:12:13',invModify = '2025-02-13 04:12:13',invUseId=0,invStatus='V' where invId = 236539 13/02/2025 04:13:34.8047 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:14:23.5145 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:17:24.2674 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:20:29.0378 655 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/02/2025 04:21:56.4986 977 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/02/2025 04:26:42.9004 1374 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:26:45.6802 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:26:48.2189 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:27:33.5304 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:38:01.3267 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:42:00.7038 504 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 04:45:26.8285 1160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:45:55.1025 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:46:54.1923 1765 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/02/2025 04:52:20.8741 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 04:59:40.2898 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 05:04:07.1154 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 05:18:18.6714 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 05:33:09.0699 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 05:52:02.0028 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 05:59:35.7421 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:05:31.6204 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:07:47.0905 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:15:55.1560 1118 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:18:11.1695 4519 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 06:18:18.1252 4105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:18:20.0004 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:18:24.5315 1103 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:18:28.2900 2943 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:37:16.3791 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:42:25.8303 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:43:22.1792 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:53:43.6004 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:54:44.1972 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:57:07.0903 1861 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 06:57:05' where traUID = 5655383829920050 and traStatus='V' and traEnabled=1 13/02/2025 06:58:47.5509 1837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 06:59:27.0685 1529 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/02/2025 07:01:23.9852 1425 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:01:30.0903 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:02:22.1093 1688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:03:18.1100 1393 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:03:22.2568 1995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:03:26.7078 2111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:05:00.6490 1495 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-13 07:04:59','V',5094858608083040,2025,'2025-02-13 07:04:58','456992549800327005012999',1,2,16,'I','',1,0,1,'','0560008304916',190,0) 13/02/2025 07:11:26.3565 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:12:58.8017 1173 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:13:14.1421 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:13:34.2166 950 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:36:21.8313 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:38:10.2583 1294 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:41:27.8472 877 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-13 07:41:26' where subId = 206 13/02/2025 07:41:32.5434 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:41:44.6806 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:45:29.8691 936 ms. EXEC: update payInventory set invCreation = '2025-02-13 07:45:28',invModify = '2025-02-13 07:45:28',invUseId=0,invStatus='V' where invId = 236546 13/02/2025 07:45:31.1370 1146 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-13 07:45:29',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'; 13/02/2025 07:45:32.2667 1557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:49:31.7008 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:50:05.3255 1555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 07:54:21.2289 2955 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4747521103632880,5433700711653330,2025,'2025-02-13 07:54:18',' Date: 2/13/2025 7:54:17 AM Code: 456992585500327005012999 Entry Date: 2/13/2025 7:10:55 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500706376 ',0) 13/02/2025 07:59:00.4488 1405 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:02:24.7282 885 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:02:50.1003 1173 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 08:02:48' where traUID = 5275433471163820 and traStatus='V' and traEnabled=1 13/02/2025 08:03:04.6611 917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:04:20.7903 504 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 08:04:41.7094 1708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:04:46.2234 1045 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:08:47.9461 1269 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:08:59.3478 869 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 552 ms.) 13/02/2025 08:13:18.5430 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:13:18.5440 503 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/02/2025 08:17:17.6420 2372 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 08:24:30.4153 543 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,0,100,-34,-3400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,0,100,34,3400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,0,200,-4,-800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,0,200,4,800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:24:14',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 13/02/2025 08:25:20.3759 654 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/02/2025 08:26:46.3587 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:32:04.0235 1473 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-13 08:32:02',0,16,'2025-02-13 08:32:02','','Unauthorized Transit Entry 2') 13/02/2025 08:37:32.4275 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:40:50.1365 772 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:40:45',5,3,42101,0,50,4,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+200,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-13 08:40:45',5,3,42101,0,200,3,600,1,'I','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'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 08:40:45',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; 13/02/2025 08:41:32.6171 1010 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 08:48:49.2992 702 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/02/2025 08:49:09.4867 921 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:49:09.9601 1483 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-13 08:49:08',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'; 13/02/2025 08:51:35.4180 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 08:51:55.2583 599 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-13 08:51:54',4,9,'2025-02-13 08:51:54','456993014100327005012999','Payed (Credit Card ) Ticket ') 13/02/2025 08:51:55.8947 615 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 405596 else acvFstPayId end),acvLstPayId = 405596 where acvSftId = 872 and acvCodeId = 3 13/02/2025 08:55:58.5380 1038 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:00:50.7777 1047 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-13 09:00:49','V',4764487014404030,2025,'2025-02-13 09:00:47','456993244700327001012999',1,2,1,'I','',1,0,1,'','',4) 13/02/2025 09:02:20.7232 2234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:08:33.5010 1310 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:13:20.6590 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:21:19.9946 1160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:24:47.3171 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:27:13.9307 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:27:36.4529 909 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-13 09:27:35',0,2,'2025-02-13 09:27:35','','Manual Open Barrier Exit 1') 13/02/2025 09:33:49.7201 659 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 09:33:50.8969 1150 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 09:36:34.1737 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:37:22.6333 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:44:50.9751 505 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5498394697266330,5484334121397410,2025,'2025-02-13 09:44:50',' Date: 2/13/2025 9:44:49 AM Code: 456993429800327005012999 Entry Date: 2/13/2025 9:31:38 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500706381 ',0) 13/02/2025 09:46:12.6010 857 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 09:46:15.1187 2439 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-13 09:46:12' where payTraUID = 5381097440604480 and payStatus='V' and payEnabled=1 13/02/2025 09:47:55.0270 1942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:48:19.9397 723 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 09:48:20.1579 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:48:31.4705 625 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-13 09:48:30','V',5702924355209400,2025,'2025-02-13 09:48:30','456993531000327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 09:50:57.6098 1832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:57:30.1340 1518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:58:07.1169 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 09:58:33.2404 1430 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:03:39.1318 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:11:11.9916 1837 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/02/2025 10:16:53.5214 799 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/02/2025 10:21:16.1882 1671 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-13 10:21:14','V',4650543148196150,2025,'2025-02-13 10:21:11','456993727100327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 13/02/2025 10:21:16.7085 511 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 10:21:25.6385 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:21:39.2327 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:21:53.8675 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:22:26.6966 623 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 10:23:18.8167 1795 ms. OPEN: show columns from movAnomaly where Field = 'anmMandatory' 13/02/2025 10:23:25.2660 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 10:24:28.1343 517 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 10:24:50.5194 901 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-13 10:24:48',0,'V',4915878895299320,5702924355209400,2025,'2025-02-13 10:24:48',3,1,0,4,'2025-02-13 10:39:48','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 13/02/2025 10:29:33.9561 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:32:31.3505 759 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-13 10:32:30','V',5603978875571280,2025,'2025-02-13 10:32:29','456993794900327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 10:32:32.2671 556 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 10:34:18.1053 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:35:21.2218 1240 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:40:16.9558 946 ms. EXEC: update abbCards set carLastDate = '2025-02-13 10:40:16',carLastDirection='I' where carStatus='V' and carId = 11 13/02/2025 10:40:22.9338 570 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 10:40:36.9292 536 ms. EXEC: update abbCards set carLastDate = '2025-02-13 10:40:36',carLastDirection='I' where carStatus='V' and carId = 20 13/02/2025 10:40:53.6815 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:44:38.1413 1050 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-13 10:44:36',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'; 13/02/2025 10:45:56.7842 559 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 10:48:55.2143 613 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 10:49:28.1485 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:49:36.2499 2427 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:49:56.7807 1055 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 10:49:55' where traUID = 5448545109279290 and traStatus='V' and traEnabled=1 13/02/2025 10:50:32.5258 1637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:51:17.9514 2044 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 10:51:15',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 13/02/2025 10:51:18.6458 693 ms. EXEC: update payInventory set invCreation = '2025-02-13 10:51:17',invModify = '2025-02-13 10:51:17',invUseId=0,invStatus='V' where invId = 236592 13/02/2025 10:51:19.7115 1062 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-13 10:51:18',0,0,'V',4928261275665230,5720533750873450,2025,'2025-02-13 10:51:18',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-13 10:51:18',0,0,'V',4928261275665230,5720533750873450,2025,'2025-02-13 10:51:18',3,'KES',-1,100,-100,'N',''); 13/02/2025 10:51:20.4650 692 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-13 10:51:18',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-13 10:51:18',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/02/2025 10:51:45.3238 678 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-13 10:51:44',0,'V',5567432369432660,5397023211252130,2025,'2025-02-13 10:51:44',18,1,0,4,'2025-02-13 11:06:44','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/02/2025 10:51:46.0373 578 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6389, trcLastPrinted = '2500706389', trcLastDate = '2025-02-13 10:51:45' where trcStatus='V' and trcTerId = 18 13/02/2025 10:53:15.2083 1191 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/02/2025 10:53:15.2093 1289 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 10:55:05.8637 1080 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 10:58:18.5980 5411 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 13/02/2025 10:59:47.7059 1306 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/02/2025 11:00:47.1142 672 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 11:04:15.7186 2088 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:05:59.1192 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:07:19.4823 2647 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 11:10:46.7698 1179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:10:52.0213 1659 ms. EXEC: update payReceipt set recCreation = '2025-02-13 11:10:50',recModify = '2025-02-13 11:10:50',recUseId=0,recStatus='V' where recId = 351967 13/02/2025 11:10:53.7065 1271 ms. EXEC: update payInventory set invCreation = '2025-02-13 11:10:52',invModify = '2025-02-13 11:10:52',invUseId=0,invStatus='V' where invId = 236600 13/02/2025 11:13:22.4556 685 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6395, trcLastPrinted = '2500706395', trcLastDate = '2025-02-13 11:13:21' where trcStatus='V' and trcTerId = 18 13/02/2025 11:15:06.4735 675 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 11:16:56.1884 878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:20:31.5593 3876 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 11:20:27' where traUID = 5359931290406110 and traStatus='V' and traEnabled=1 13/02/2025 11:20:33.6587 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 11:20:56.5181 2486 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-13 11:20:40',12,'V',5130184780500680,5261959473817430,2025,'2025-02-13 11:20:40',17,1,0,4,'2025-02-13 11:35:40','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 13/02/2025 11:20:58.2533 1724 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-13 11:20:56',17,12,'2025-02-13 11:20:56','456993666200327005012999','Pagato (Contanti ) Biglietto ') 13/02/2025 11:20:58.8216 508 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 405644 else acvFstPayId end),acvLstPayId = 405644 where acvSftId = 894 and acvCodeId = 3 13/02/2025 11:21:00.1205 1313 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/02/2025 11:21:26.9626 1642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:22:24.9646 506 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5335750609692950,4920321574075880,2025,'2025-02-13 11:22:24','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/13/2025 11:01:58 AM Date : 2/13/2025 11:22:23 AM Code : 456993971800327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 13/02/2025 11:24:32.4994 507 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5747218988852250,5509662796419670,2025,'2025-02-13 11:24:31',' Date: 2/13/2025 11:24:31 AM Code: 456994015900327005012999 Entry Date: 2/13/2025 11:09:19 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500706398 ',0) 13/02/2025 11:25:00.0650 1562 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-13 11:24:58','V',4750369185920440,2025,'2025-02-13 11:24:57','456993851300327005012999',2,2,2,'O','',0,'2025-02-13 11:24:58',1,'','',0) 13/02/2025 11:26:48.8051 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 11:26:50.7244 614 ms. OPEN: show columns from tabArea where Field = 'areType' 13/02/2025 11:28:53.3079 540 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 11:28:57.7980 2013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:29:47.5514 518 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-13 11:29:47' where payTraUID = 4764366932070180 and payStatus='V' and payEnabled=1 13/02/2025 11:29:48.1779 625 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 11:29:47' where traUID = 4764366932070180 and traStatus='V' and traEnabled=1 13/02/2025 11:30:50.8941 663 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-13 11:30:50',0,'V',4994537208391340,4942581751355580,2025,'2025-02-13 11:30:50',2,1,0,-1,'2025-02-13 12:30:50','S','KES',50,50,0,'','','',3,50,0,0,'',0,0) 13/02/2025 11:31:02.5199 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:36:16.8929 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-13 11:36:15','V',4948009643532450,2025,'2025-02-13 11:36:14','456993544400327005012999',2,2,2,'O','',0,'2025-02-13 11:36:15',1,'','',0) 13/02/2025 11:36:17.7305 533 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 11:36:17' where traUID = 5652403037941000 and traStatus='V' and traEnabled=1 13/02/2025 11:36:50.1003 593 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 11:37:21.8366 688 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-13 11:37:21','V',5454836834624750,2025,'2025-02-13 11:37:20','456994030500327005012999',2,2,2,'O','',0,'2025-02-13 11:37:21',1,'','',0) 13/02/2025 11:40:30.3655 1438 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-13 11:40:28' where payTraUID = 4912575981677610 and payStatus='V' and payEnabled=1 13/02/2025 11:40:42.8739 2033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:41:47.4033 705 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 13/02/2025 11:41:56.5005 2682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:42:49.8704 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:42:51.9608 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:42:54.8037 2337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:42:58.0409 1028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:43:03.2424 4689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:43:05.2577 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:43:15.7068 2218 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:43:23.0427 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:44:48.2961 538 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 11:45:03.5863 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:45:21.8947 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:45:26.9050 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:46:22.5965 1660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:46:25.8727 2025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:46:38.3141 2405 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:46:44.9756 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:47:02.5504 1900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:47:06.6492 2334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:47:13.0925 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:47:16.6379 1727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 11:49:49.6238 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:04:30.9339 592 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 12:04:34.7535 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:08:57.5803 587 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 12:10:00.5967 2832 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/02/2025 12:12:05.4127 974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:14:52.7894 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:15:35.5171 1407 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/02/2025 12:16:16.3966 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:17:03.3992 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:18:48.6711 1665 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 12:19:09.1769 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:20:21.6426 907 ms. EXEC: update payInventory set invCreation = '2025-02-13 12:20:20',invModify = '2025-02-13 12:20:20',invUseId=0,invStatus='V' where invId = 236618 13/02/2025 12:21:07.6656 553 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5429325794833480,5244107948853780,2025,'2025-02-13 12:21:07','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/13/2025 12:11:00 PM Date : 2/13/2025 12:21:06 PM Code : 456994386000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 13/02/2025 12:23:14.4729 3509 ms. EXEC: update payReceipt set recCreation = '2025-02-13 12:23:10',recModify = '2025-02-13 12:23:10',recUseId=0,recStatus='V' where recId = 352006 13/02/2025 12:25:11.9020 1742 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 12:26:08.3069 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 12:27:12.9054 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:27:35.6627 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:32:02.4153 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:32:55.4911 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:33:15.0282 1666 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 12:33:13' where traUID = 5712651954862340 and traStatus='V' and traEnabled=1 13/02/2025 12:38:04.2722 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:38:29.8654 728 ms. EXEC: update payReceipt set recCreation = '2025-02-13 12:38:29',recModify = '2025-02-13 12:38:29',recUseId=0,recStatus='V' where recId = 352015 13/02/2025 12:40:07.3400 1145 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 12:40:35.4919 900 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 12:40:44.2238 1338 ms. EXEC: update paycash set casCreation = '2025-02-13 12:40:42',casModify = '2025-02-13 12:40:42',casUseId=0,casStatus='V' where casId = 209369 13/02/2025 12:41:29.5123 979 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-13 12:41:28' where subId = 108 13/02/2025 12:44:20.6524 640 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 12:44:38.3013 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:44:46.5559 1053 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 12:55:03.7766 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 12:55:32.8361 824 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-13 12:55:32','V',4863407040730370,2025,'2025-02-13 12:55:30','456993214200327005012999',2,2,2,'O','',0,'2025-02-13 12:55:32',1,'','0230003939786',160,0) 13/02/2025 12:55:34.2581 561 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 12:55:33' where traUID = 5236480826253720 and traStatus='V' and traEnabled=1 13/02/2025 12:59:25.2555 569 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-13 12:59:24','V',5040123812569270,2025,'2025-02-13 12:59:23','456994676300327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 13:03:53.4080 879 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 13/02/2025 13:09:16.4633 782 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 13:09:15' where traUID = 5166050470594480 and traStatus='V' and traEnabled=1 13/02/2025 13:09:48.2197 1165 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:09:59.6454 3492 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 13:09:56',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-13 13:09:56',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'; 13/02/2025 13:10:20.5995 798 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/02/2025 13:10:42.2050 1041 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/02/2025 13:12:15.4188 726 ms. EXEC: update paycash set casCreation = '2025-02-13 13:12:14',casModify = '2025-02-13 13:12:14',casUseId=0,casStatus='V' where casId = 209379 13/02/2025 13:12:31.2764 697 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/02/2025 13:12:37.3435 1454 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/02/2025 13:12:37.3625 1673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:13:11.7737 1662 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-13 13:13:10' where payTraUID = 5747267001356960 and payStatus='V' and payEnabled=1 13/02/2025 13:13:59.9531 1579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:14:26.0417 803 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-13 13:14:24',0,'V',4769939763133320,5081527368134040,2025,'2025-02-13 13:14:24',3,1,0,4,'2025-02-13 13:29:24','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 13/02/2025 13:17:33.2837 2671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:20:22.9308 1282 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-13 13:20:21','V',5678045072244300,2025,'2025-02-13 13:20:21','456994802100327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 13:20:23.8674 824 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456994802100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 13/02/2025 13:20:26.0249 1165 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/02/2025 13:25:51.5469 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-13 13:25:50','V',5037626582333350,2025,'2025-02-13 13:25:49','456994122700327005012999',2,2,2,'O','',0,'2025-02-13 13:25:50',1,'','',0) 13/02/2025 13:25:52.1393 590 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 13:25:53.1970 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:25:53.2490 510 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 13:25:52' where traUID = 4903951033558930 and traStatus='V' and traEnabled=1 13/02/2025 13:26:12.5830 574 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 13:27:16.6251 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:27:29.5228 1434 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 13:27:54.4006 1176 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-13 13:27:53','V',5589754551541100,2025,'2025-02-13 13:27:51','456994736700327005012999',2,2,2,'O','',0,'2025-02-13 13:27:53',1,'','',0) 13/02/2025 13:31:00.3045 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:31:00.3045 579 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 13:32:28.6990 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:34:06.7529 610 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-13 13:34:06','V',5418003413064780,2025,'2025-02-13 13:34:04','456994884400327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 13:34:07.3233 568 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 13:35:52.4130 1644 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 13:38:10.4009 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:39:37.3424 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:51:09.9829 698 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 13:51:10.7834 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:52:50.2874 672 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 13:53:17.8960 1168 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:53:53.9843 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:55:26.3154 715 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-13 13:55:25','0230003939927',0,0,4895359940219620,164,'0000-00-00 00:00:00','0000-00-00 00:00:00') 13/02/2025 13:56:29.4149 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 13:57:52.0635 767 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-13 13:57:51','V',4802953679347140,2025,'2025-02-13 13:57:50','456995027000327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 14:00:08.0029 1713 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 14:00:30.3100 1046 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-13 14:00:29','V',4760660430231580,2025,'2025-02-13 14:00:28','456994920300327005012999',2,2,2,'O','',0,'2025-02-13 14:00:29',1,'','',0) 13/02/2025 14:00:48.2080 834 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 14:01:13.1518 617 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-13 14:01:12',0,'V',4762442357885250,4633687418941910,2025,'2025-02-13 14:01:12',18,1,0,4,'2025-02-13 14:16:12','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/02/2025 14:01:13.9213 527 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6425, trcLastPrinted = '2500706425', trcLastDate = '2025-02-13 14:01:13' where trcStatus='V' and trcTerId = 18 13/02/2025 14:03:00.4630 928 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 14:02:59' where traUID = 4633687418941910 and traStatus='V' and traEnabled=1 13/02/2025 14:10:53.3852 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 14:15:16.8225 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 14:18:36.2587 635 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-13 14:18:35',0,0,'V',4916308712015020,5524814259527650,2025,'2025-02-13 14:18:35',3,'KES',1,100,100,'N',''); 13/02/2025 14:21:33.1998 785 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 13/02/2025 14:24:33.6412 654 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 14:26:45.0423 1668 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 13/02/2025 14:27:13.6636 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 14:27:31.5827 538 ms. EXEC: update paycash set casCreation = '2025-02-13 14:27:31',casModify = '2025-02-13 14:27:31',casUseId=0,casStatus='V' where casId = 209398 13/02/2025 14:27:32.7384 568 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 14:27:32',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-13 14:27:32',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'; 13/02/2025 14:27:39.9983 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 14:28:58.8624 603 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 14:30:16.4126 566 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-13 14:30:15','V',5342697466251320,2025,'2025-02-13 14:30:15','456995221500327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 14:32:31.3484 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 14:32:38.0449 716 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 14:32:38.2080 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 14:34:11.0775 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 14:35:23.8735 1442 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/02/2025 14:36:04.0965 714 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-13 14:36:03','V',5657415549501430,2025,'2025-02-13 14:36:03','456995256300327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 14:36:49.7012 601 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-13 14:36:49',17,12,'2025-02-13 14:36:49','456995004300327005012999','Pagato (Contanti ) Biglietto ') 13/02/2025 14:36:50.7930 663 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 405746 else acvFstPayId end),acvLstPayId = 405746 where acvSftId = 894 and acvCodeId = 3 13/02/2025 14:37:23.5990 4599 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 14:38:04.4575 1899 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/02/2025 14:38:26.3683 715 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/02/2025 14:41:21.0790 1571 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 14:42:48.6279 746 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 14:43:17.5754 696 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 14:43:19.8780 655 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 405753 else acvFstPayId end),acvLstPayId = 405753 where acvSftId = 872 and acvCodeId = 3 13/02/2025 14:46:15.9363 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 14:48:42.1536 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 14:49:29.2523 807 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 14:53:31.8626 532 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 14:59:58.5308 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:00:08.4835 1485 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 15:00:13.8281 567 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 13/02/2025 15:00:17.2514 1138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:02:08.5023 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:02:33.0268 1249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:03:16.2328 1704 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 15:03:29.9481 1443 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:04:02.1597 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:04:50.2221 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:04:57.4599 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:05:16.3366 2522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:08:00.4241 663 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/02/2025 15:09:24.0193 737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 15:09:28.7365 2194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:10:12.6260 1666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:10:26.8036 1276 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:10:48.0899 2124 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/02/2025 15:10:48.0939 1268 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:10:58.2237 1468 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 13/02/2025 15:11:05.9569 2950 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:12:07.2041 935 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-13 15:12:06',0,16,'2025-02-13 15:12:06','','Unauthorized Transit Entry 2') 13/02/2025 15:12:48.8081 746 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/02/2025 15:17:09.6667 1013 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 15:17:34.2082 925 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/02/2025 15:20:00.8909 1773 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/02/2025 15:20:11.7242 2138 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 15:20:11.9693 2527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:20:12.1264 3958 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-13 15:20:08',0,'V',5668689219873690,5657415549501430,2025,'2025-02-13 15:20:08',18,1,0,4,'2025-02-13 15:35:08','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/02/2025 15:20:24.9311 544 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 15:22:21.8447 3251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:22:34.1980 1759 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-13 15:21:45',9,'V',5657090883267990,5609894120950980,2025,'2025-02-13 15:21:45',4,1,0,4,'2025-02-13 15:36:45','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/02/2025 15:22:37.6964 1067 ms. OPEN: select * from payCurInventory where curTerId = 18 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 13/02/2025 15:23:23.3471 1185 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/02/2025 15:25:14.1167 711 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 15:27:01.0216 969 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/02/2025 15:28:23.8603 521 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/02/2025 15:28:23.8693 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:29:00.4460 1883 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/02/2025 15:30:36.7307 740 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 15:31:41.8906 622 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-13 15:31:41','V',4851213897182760,2025,'2025-02-13 15:31:40','456995109900327005012999',2,2,2,'O','',0,'2025-02-13 15:31:41',1,'','',0) 13/02/2025 15:31:43.0814 632 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-13 15:31:42' where payTraUID = 4956815446216350 and payStatus='V' and payEnabled=1 13/02/2025 15:31:44.6965 1251 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 847695 13/02/2025 15:33:10.5332 1087 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 15:33:09' where traUID = 4620709443453040 and traStatus='V' and traEnabled=1 13/02/2025 15:38:33.2791 1771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:39:28.2050 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 15:43:19.4644 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:44:12.4510 985 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:45:13.1048 786 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-13 15:45:12','V',4710063480223400,2025,'2025-02-13 15:45:09','456995670900327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 15:45:13.6942 581 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 15:45:14.4237 712 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 13/02/2025 15:45:23.3677 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 15:48:13.7474 606 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-13 15:48:13','V',5625582730910640,2025,'2025-02-13 15:48:11','456995689100327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 15:52:17.7316 548 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 15:53:10.0047 2514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 15:55:59.9243 1016 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-13 15:55:58','V',4653760923242670,2025,'2025-02-13 15:55:57','456995300800327005012999',2,2,2,'O','',0,'2025-02-13 15:55:58',1,'','',0) 13/02/2025 15:56:11.5481 1281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:57:12.2399 1226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:58:08.1045 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 15:59:17.9055 559 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 15:59:18.5749 668 ms. EXEC: update abbCards set carLastDate = '2025-02-13 15:59:17',carLastDirection='I' where carStatus='V' and carId = 13 13/02/2025 16:01:44.7625 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 15 ms.) 13/02/2025 16:02:58.9154 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:06:24.0764 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:09:00.3136 549 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 16:10:26.6257 629 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/02/2025 16:10:32.3695 1407 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 405809 else acvFstPayId end),acvLstPayId = 405809 where acvSftId = 872 and acvCodeId = 3 13/02/2025 16:10:35.5046 521 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 16:11:08.8861 718 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5104312128618480,4767369908827770,2025,'2025-02-13 16:11:08','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/13/2025 3:48:48 PM Date : 2/13/2025 4:11:07 PM Code : 456995692800327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 13/02/2025 16:14:25.6622 1833 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 16:14:23' where traUID = 5450985600703760 and traStatus='V' and traEnabled=1 13/02/2025 16:14:54.6567 742 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-13 16:14:53','V',4974316247663890,2025,'2025-02-13 16:14:51','456995262300327005012999',2,2,2,'O','',0,'2025-02-13 16:14:53',1,'','',0) 13/02/2025 16:15:23.6902 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 16:17:15.7287 893 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/02/2025 16:23:45.5480 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:26:02.0699 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:26:53.7337 541 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-13 16:26:53','V',5439351605149040,2025,'2025-02-13 16:26:52','456995471600327005012999',2,2,2,'O','',0,'2025-02-13 16:26:53',1,'','',0) 13/02/2025 16:26:54.4842 743 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 16:26:55.2647 651 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/02/2025 16:26:56.6136 1197 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside - 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 13/02/2025 16:38:43.6788 531 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/02/2025 16:38:53.7856 521 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 16:39:41.7158 1667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:40:05.6349 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:41:33.4640 587 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-13 16:41:32','V',5689014775783420,2025,'2025-02-13 16:41:31','456995726000327005012999',2,2,2,'O','',0,'2025-02-13 16:41:32',1,'','',0) 13/02/2025 16:41:39.4671 529 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 16:45:00.5454 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:47:29.5376 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:47:47.3116 1131 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/02/2025 16:48:01.3080 611 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 16:48:01.3080 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 16:48:31.4453 1090 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456995583600327005012999' 13/02/2025 16:49:18.4349 626 ms. EXEC: update paycash set casCreation = '2025-02-13 16:49:17',casModify = '2025-02-13 16:49:17',casUseId=0,casStatus='V' where casId = 209433 13/02/2025 17:00:01.5337 680 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-13 17:00:00',0,0,'V',5050503019703140,4967183058036130,2025,'2025-02-13 17:00:00',3,'KES',2,100,200,'N',''); 13/02/2025 17:00:02.6564 734 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-13 17:00:00',3,42101,0,100,2,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/02/2025 17:00:41.7527 1851 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 17:01:18.8607 1376 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:01:25.0288 2470 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:01:27.2513 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:01:30.5916 1011 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:01:39.3685 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:02:11.8513 3674 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-13 17:02:08','V',4913162881600950,2025,'2025-02-13 17:02:07','456996132700327001012999',1,2,1,'I','',1,0,1,'','',4) 13/02/2025 17:02:14.3510 2314 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 17:02:22.1473 1651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:03:02.2272 922 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-13 17:03:01','0230004100104',0,0,5535128591986570,151,'0000-00-00 00:00:00','0000-00-00 00:00:00') 13/02/2025 17:07:03.5026 1001 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-13 17:07:02',0,'V',4890303207472750,5735291953016050,2025,'2025-02-13 17:07:02',2,1,0,-1,'2025-02-13 18:07:02','S','KES',0,0,0,'','','',3,0,0) 13/02/2025 17:08:41.3885 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:08:41.3915 693 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 17:10:32.3814 1402 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-13 17:10:30','V',5270869414013220,2025,'2025-02-13 17:10:29','456996182900327001012999',1,2,1,'I','',1,0,1,'','',4) 13/02/2025 17:10:44.1924 518 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-13 17:10:43',0,16,'2025-02-13 17:10:43','','Unauthorized Transit Entry 2') 13/02/2025 17:12:14.7686 1292 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-13 17:12:13','V',5289513966113540,2025,'2025-02-13 17:12:12','456996193200327001012999',1,2,1,'I','',1,0,1,'','',4) 13/02/2025 17:12:17.2092 1631 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 17:12:38.3505 2481 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/02/2025 17:12:39.0139 629 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-13 17:12:38','V',5063072440768170,2025,'2025-02-13 17:12:37','456996195700327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 17:15:52.5762 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:16:00.4945 638 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-13 17:15:59',0,'V',4875289140189600,5622565943443920,2025,'2025-02-13 17:15:59',2,1,0,-1,'2025-02-13 18:15:59','S','KES',0,0,0,'','','',3,0,0) 13/02/2025 17:16:05.2517 724 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 17:23:03.6753 1382 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/02/2025 17:23:54.5485 533 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 13/02/2025 17:29:55.7867 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 17:30:10.2024 718 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-13 17:30:09' where subId = 139 13/02/2025 17:30:19.8379 952 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 17:33:32.1837 504 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-13 17:33:31',0,'V',5453240750952330,5270869414013220,2025,'2025-02-13 17:33:31',18,1,0,4,'2025-02-13 17:48:31','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/02/2025 17:33:47.7232 794 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-13 17:33:46',0,'V',5698232291132380,5560633517506300,2025,'2025-02-13 17:33:46',2,1,0,-1,'2025-02-13 18:33:46','S','KES',0,0,0,'','','',3,0,0) 13/02/2025 17:33:48.8399 538 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 17:33:48' where traUID = 5560633517506300 and traStatus='V' and traEnabled=1 13/02/2025 17:38:21.8403 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:38:46.6520 1061 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/02/2025 17:39:41.7241 1168 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 17:39:55.9516 688 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 17:54:16.3316 1023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 17:56:13.8557 1226 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/02/2025 17:57:54.3163 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:04:49.7035 1382 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-13 18:04:48','V',4838223593729580,2025,'2025-02-13 18:04:47','456996183300327005012999',2,2,2,'O','',0,'2025-02-13 18:04:48',1,'','',0) 13/02/2025 18:05:05.4961 740 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 18:05:04',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-13 18:05:04',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'; 13/02/2025 18:05:11.3781 974 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 18:05:16.6706 1168 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 18:05:22.2274 925 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/02/2025 18:05:35.7445 547 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 18:06:59.0225 1101 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6477, trcLastPrinted = '2500706477', trcLastDate = '2025-02-13 18:06:57' where trcStatus='V' and trcTerId = 18 13/02/2025 18:08:57.0925 3110 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 18:09:34.8129 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:10:06.9665 618 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 18:11:08.9642 680 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 18:15:00.4960 4232 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 18:16:02.2596 1137 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:16:40.0360 567 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5118516044550040,5507051990512250,2025,'2025-02-13 18:16:39','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/13/2025 6:05:38 PM Date : 2/13/2025 6:16:38 PM Code : 456996513800327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 13/02/2025 18:16:40.8626 629 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-13 18:16:40',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'; 13/02/2025 18:28:44.8962 673 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 18:28:59.8623 516 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-13 18:28:59' where payTraUID = 5594378235593610 and payStatus='V' and payEnabled=1 13/02/2025 18:29:00.5237 660 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 18:28:59' where traUID = 5594378235593610 and traStatus='V' and traEnabled=1 13/02/2025 18:29:04.9807 793 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 18:32:57.4255 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:34:31.7260 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:34:37.0466 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 18:35:18.5085 593 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 18:35:28.3041 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 18:35:50.1067 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:39:29.1121 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:40:09.6834 1683 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/02/2025 18:40:14.1504 1523 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 18:41:00.5206 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:43:51.1154 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:44:56.0531 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:47:07.8668 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:47:46.8790 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:50:28.6379 1396 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/02/2025 18:51:06.0811 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 18:51:18.8967 596 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 18:52:55.7989 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:54:29.1768 538 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 13/02/2025 18:54:31.7495 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 18:57:32.2660 1556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:00:54.9263 522 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-13 19:00:54',0,'V',5705299077155490,5444052012669040,2025,'2025-02-13 19:00:54',18,1,0,4,'2025-02-13 19:15:54','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/02/2025 19:01:16.6570 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:06:29.1069 556 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 19:06:28',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 13/02/2025 19:06:29.9314 631 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-13 19:06:29',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-13 19:06:29',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'; 13/02/2025 19:06:53.6534 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:07:41.6867 514 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/02/2025 19:08:19.6443 4909 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-13 19:07:28',9,'V',5022737758913680,5308575261962990,2025,'2025-02-13 19:07:28',4,1,0,4,'2025-02-13 19:22:28','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 13/02/2025 19:09:31.7388 543 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 19:09:31' where traUID = 5308575261962990 and traStatus='V' and traEnabled=1 13/02/2025 19:12:29.4464 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:12:53.2234 2461 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:13:26.1735 2043 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6487, trcLastPrinted = '2500706487', trcLastDate = '2025-02-13 19:13:24' where trcStatus='V' and trcTerId = 18 13/02/2025 19:13:54.5546 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:15:05.1782 2039 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/02/2025 19:15:30.1500 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:20:24.0491 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:28:31.5857 2514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:28:52.8650 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:31:48.6913 1053 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:34:38.6757 1689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:37:05.7076 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:38:45.7169 1012 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 13/02/2025 19:42:46.1537 675 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 19:43:35.8812 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:45:09.8204 568 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/02/2025 19:45:09.8764 543 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 19:45:26.3025 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 19:46:50.4001 860 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 19:54:34.6050 596 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-13 19:54:34','V',5657557520876630,2025,'2025-02-13 19:54:30','456997036800327005012999',2,2,2,'O','',0,'2025-02-13 19:54:34',1,'','',0) 13/02/2025 19:56:17.0387 759 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-13 19:56:16',0,'V',5410755457518430,5262387580319060,2025,'2025-02-13 19:56:16',18,1,0,4,'2025-02-13 20:11:16','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/02/2025 19:57:07.5277 746 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 19:58:51.3455 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:00:21.8364 1580 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-13 20:00:20' where payTraUID = 4700444565207020 and payStatus='V' and payEnabled=1 13/02/2025 20:01:17.7340 1641 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-13 20:01:16','V',4679898900443680,2025,'2025-02-13 20:01:15','456997207500327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 20:04:24.3336 1313 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 20:07:14.2539 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:07:43.4466 699 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 20:09:01.5531 2210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:09:58.3474 555 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/02/2025 20:10:44.7406 1394 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-13 20:10:43','V',5516643188742000,2025,'2025-02-13 20:10:42','456997264200327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 20:10:45.2950 552 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 20:10:46.5598 1239 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 13/02/2025 20:10:49.6119 2968 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 20:15:42.6514 1708 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 20:15:40' where traUID = 4867140968030840 and traStatus='V' and traEnabled=1 13/02/2025 20:15:52.0627 1497 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/02/2025 20:19:13.0185 836 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-13 20:19:12','V',5572857213907990,2025,'2025-02-13 20:19:11','456997030700327005012999',2,2,2,'O','',0,'2025-02-13 20:19:12',1,'','',0) 13/02/2025 20:26:10.1692 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:27:16.5439 1005 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 20:27:15' where traUID = 5600031109925250 and traStatus='V' and traEnabled=1 13/02/2025 20:27:46.8022 638 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6500, trcLastPrinted = '2500706500', trcLastDate = '2025-02-13 20:27:46' where trcStatus='V' and trcTerId = 18 13/02/2025 20:31:33.8680 1929 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/02/2025 20:32:41.5566 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 20:34:00.7168 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 20:34:06.6418 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:36:28.7524 517 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 13/02/2025 20:39:18.6488 792 ms. OPEN: select ticId from tabTicketType where ticStatus='V' and ticType = 1 13/02/2025 20:39:58.9879 832 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-13 20:39:58' where payTraUID = 4671067497791570 and payStatus='V' and payEnabled=1 13/02/2025 20:42:47.7495 1322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:43:08.1912 1336 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 20:43:06' where traUID = 4974295798224770 and traStatus='V' and traEnabled=1 13/02/2025 20:44:31.6984 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:50:54.7570 851 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 20:50:55.9188 1161 ms. EXEC: update abbCards set carLastDate = '2025-02-13 20:50:54',carLastDirection='O' where carStatus='V' and carId = 44 13/02/2025 20:50:57.9612 1530 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 20:50:56' where traUID = 5030447802229350 and traStatus='V' and traEnabled=1 13/02/2025 20:51:03.0606 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 20:53:05.1077 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:54:45.1551 1000 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:55:38.4743 1458 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:56:19.8081 1960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:56:54.4074 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:56:59.2676 1136 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 20:56:57' where traUID = 5516643188742000 and traStatus='V' and traEnabled=1 13/02/2025 20:58:55.7440 2028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 20:59:14.1534 2223 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 13/02/2025 21:00:10.0480 1564 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/02/2025 21:01:22.9941 1448 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:03:04.6085 2357 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:04:42.1382 1355 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-13 21:04:40','V',4891299071104200,2025,'2025-02-13 21:04:40','456997588000327005012999',1,2,16,'I','',1,0,1,'','',4) 13/02/2025 21:04:43.7083 1374 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/02/2025 21:04:46.3961 2072 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/02/2025 21:05:11.3379 588 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5129953184687600,4660979459461880,2025,'2025-02-13 21:05:10',' Date: 2/13/2025 9:05:10 PM Code: 456997397100327005012999 Entry Date: 2/13/2025 8:32:51 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 # 2500706511 ',0) 13/02/2025 21:13:59.9639 725 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/02/2025 21:16:02.7455 544 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-13 21:16:02',0,0,'V',5302243704817740,5208828804221550,2025,'2025-02-13 21:16:02',3,'KES',1,100,100,'N',''); 13/02/2025 21:16:03.4090 637 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-13 21:16:02',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'; 13/02/2025 21:16:04.1315 629 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-13 21:16:03',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-13 21:16:03',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'; 13/02/2025 21:16:53.2745 947 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 21:17:58.7066 1421 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:29:27.4060 611 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 13/02/2025 21:29:27.4130 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:29:45.1570 1041 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 21:29:46.3147 1157 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 13/02/2025 21:33:57.5788 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:34:24.9562 632 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5048090411555070,5171504680756160,2025,'2025-02-13 21:34:24','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/13/2025 9:16:19 PM Date : 2/13/2025 9:34:23 PM Code : 456997657900327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 13/02/2025 21:35:23.5587 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 21:36:48.7780 1293 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 21:39:29.4932 1617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:39:36.9962 2136 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:40:06.3740 1730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:40:06.3820 888 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/02/2025 21:40:57.5284 1075 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 21:44:38.4317 685 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/02/2025 21:45:36.7649 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:47:06.8346 593 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4688677079642500,5045069937337890,2025,'2025-02-13 21:47:06',' Data: 2/13/2025 9:46:53 PM Codice: 456997276500327005012999 Ingresso: 2/13/2025 8:12:45 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 # 2500601157 ',0) 13/02/2025 21:47:57.8139 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:48:52.2035 1137 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 21:49:09.4341 1208 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/02/2025 21:50:24.5516 673 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 21:50:37.9856 605 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/02/2025 21:53:30.5428 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:53:35.7443 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 21:58:41.1428 563 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/02/2025 21:58:51.5498 540 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 22:01:24.6868 758 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 22:01:26.8102 2115 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 13/02/2025 22:04:59.6475 698 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 13/02/2025 22:11:54.6268 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 22:15:25.2385 1647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 22:15:47.3174 600 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6520, trcLastPrinted = '2500706520', trcLastDate = '2025-02-13 22:15:46' where trcStatus='V' and trcTerId = 18 13/02/2025 22:15:48.4461 1120 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5365601880230030,4851935775701980,2025,'2025-02-13 22:15:47',' Date: 2/13/2025 10:15:46 PM Code: 456997836000327005012999 Entry Date: 2/13/2025 9:46:00 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 # 2500706520 ',0) 13/02/2025 22:24:12.6914 742 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/02/2025 22:24:51.4005 576 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-13 22:24:50','V',5411408747275900,2025,'2025-02-13 22:24:49','456998068900327001012999',1,2,1,'I','',1,0,1,'','',4) 13/02/2025 22:29:28.3095 1462 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 22:33:47.1167 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 22:42:45.8504 896 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1160, trcLastPrinted = '2500601160', trcLastDate = '2025-02-13 22:42:44' where trcStatus='V' and trcTerId = 17 13/02/2025 22:43:11.7859 774 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-13 22:43:11',0,2,'2025-02-13 22:43:11','','Manual Open Barrier Exit 1') 13/02/2025 22:44:48.0397 1292 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 22:44:52.7748 2739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 22:44:57.1898 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 22:45:29.8268 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 22:45:30.4952 640 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 22:48:43.3870 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/02/2025 22:49:04.0339 1202 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/02/2025 22:54:05.5008 537 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 13/02/2025 22:54:29.8031 2161 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-13 22:54:27','V',5212854450155470,2025,'2025-02-13 22:54:26','456997733700327001012999',2,2,2,'O','',0,'2025-02-13 22:54:27',1,'','',0) 13/02/2025 22:54:31.2741 1102 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/02/2025 22:54:31.2911 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 23:04:53.1481 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 23:06:00.1752 594 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/02/2025 23:06:51.9601 1007 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-13 23:06:50','V',4821447897920620,2025,'2025-02-13 23:06:49','456998134800327005012999',2,2,2,'O','',0,'2025-02-13 23:06:50',1,'','',0) 13/02/2025 23:07:16.3495 624 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 23:07:15' where traUID = 5506642651669310 and traStatus='V' and traEnabled=1 13/02/2025 23:08:42.0461 561 ms. EXEC: update abbCards set carLastDate = '2025-02-13 23:08:41',carLastDirection='I' where carStatus='V' and carId = 15 13/02/2025 23:16:32.9320 563 ms. EXEC: update payReceipt set recCreation = '2025-02-13 23:16:32',recModify = '2025-02-13 23:16:32',recUseId=0,recStatus='V' where recId = 352242 13/02/2025 23:19:41.6430 1430 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 23:20:05.6772 630 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/02/2025 23:25:35.7833 1426 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-13 23:25:34','V',4890381103650010,2025,'2025-02-13 23:25:33','456998272100327005012999',2,2,2,'O','',0,'2025-02-13 23:25:34',1,'','',0) 13/02/2025 23:25:37.3013 806 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-13 23:25:36' where traUID = 5548976150662540 and traStatus='V' and traEnabled=1 13/02/2025 23:27:19.9954 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 23:29:31.4389 1151 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/02/2025 23:55:59.2630 609 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V'