14/11/2024 00:00:06.5493 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:00:34.8232 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:06:21.6701 1137 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:10:39.0441 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:12:17.5190 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:14:08.5091 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:16:52.1085 873 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 00:17:29.4044 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:28:38.7740 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:31:09.6704 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:31:15.6894 573 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 14/11/2024 00:33:28.6267 1040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:38:41.7462 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:40:12.1390 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:45:51.8643 966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:46:49.1217 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:48:51.7460 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:55:17.4674 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:56:13.3759 903 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 00:57:00.7817 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:57:06.7517 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:57:13.8784 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 00:57:52.3372 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:00:06.6461 842 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 01:00:07.2475 1201 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:02:27.6215 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:02:39.8517 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:05:02.9916 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:09:04.8556 1420 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:15:47.3563 1112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:16:09.6193 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:21:03.3634 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:21:18.5776 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:21:47.0627 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:25:30.6357 502 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 14/11/2024 01:28:10.0205 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:29:45.8888 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:29:56.9112 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:39:28.2239 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:41:19.8886 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:43:24.0787 1138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:44:58.8505 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:45:01.5763 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:47:24.4745 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:47:28.5883 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:53:00.5482 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 01:53:28.9903 1697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:04:06.1008 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:09:19.7337 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:09:36.4629 875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:17:43.6425 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:21:56.5478 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:24:33.9717 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:29:00.5859 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:33:28.3632 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:37:39.2677 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:38:45.5159 1928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:41:00.4350 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:41:42.9894 2582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:43:07.1286 1645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:44:08.9100 1466 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:46:58.3175 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:49:07.9954 4763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:52:14.2852 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:55:14.9201 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 02:59:55.4028 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:02:40.6582 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:03:47.4548 1141 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:05:22.9516 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:06:00.9270 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:12:55.5990 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:18:08.6812 1653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:18:17.6022 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:22:56.3887 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:24:43.9527 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 03:36:09.2392 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 03:39:24.4268 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:48:22.4016 1941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:54:52.3333 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 03:55:50.5322 609 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 03:55:52.3354 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:06:22.5989 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:10:39.1427 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:36:29.9837 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:38:36.1932 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:39:05.3127 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:43:31.0966 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:51:02.8863 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 04:51:04.3362 2254 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:52:03.7382 972 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:52:39.7864 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 04:55:56.0984 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:00:41.4091 2390 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:02:49.8014 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:04:11.7184 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:08:12.9555 1610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:09:45.0167 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 05:09:45.4180 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:10:05.6507 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:10:24.0991 615 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/11/2024 05:11:41.5454 1096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:12:04.9112 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:20:38.7372 1146 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:22:56.6503 2675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:26:35.7159 1726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:29:21.0590 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:38:39.7694 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 05:45:06.7776 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 05:51:13.7023 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:11:22.6298 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:13:41.8288 714 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 06:17:27.5386 778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:20:33.4359 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:21:08.5574 2768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:26:54.3908 930 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 14/11/2024 06:28:06.8863 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:29:48.7885 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:29:49.8332 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:37:32.3386 1723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:38:24.2243 579 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/11/2024 06:38:35.4628 797 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 06:38:35.5379 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:42:05.6645 670 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 06:43:06.2210 527 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 06:43:05' where traUID = 5690573671902030 and traStatus='V' and traEnabled=1 14/11/2024 06:45:37.3081 534 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 14/11/2024 06:45:37.6263 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:45:37.6273 531 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/11/2024 06:46:34.8036 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 06:55:57.3772 3451 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 14/11/2024 06:56:11.5397 2626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:58:31.9106 1318 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:59:19.8446 790 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 06:59:20.2629 1088 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 06:59:22.2362 546 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 06:59:21' where payTraUID = 4996443505263230 and payStatus='V' and payEnabled=1 14/11/2024 07:00:28.0102 1482 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 07:02:14.3753 747 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 07:06:19.1150 1797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 07:08:41.6093 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 07:11:04.3398 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 07:15:32.6653 597 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/11/2024 07:19:15.2962 690 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4642458998288540,4903135400971400,2024,'2024-11-14 07:19:14','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/14/2024 7:08:56 AM Date : 11/14/2024 7:19:11 AM Code : 456082573600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 14/11/2024 07:20:44.8141 672 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 07:20:44' where payTraUID = 4642458998288540 and payStatus='V' and payEnabled=1 14/11/2024 07:20:46.2080 1393 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 07:20:44' where traUID = 4642458998288540 and traStatus='V' and traEnabled=1 14/11/2024 07:20:49.8755 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 07:26:12.8005 559 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,'2024-11-14 07:26:12','V',4695958026092920,2024,'2024-11-14 07:26:10','456082538700327005012999',2,2,2,'O','',0,'2024-11-14 07:26:12',1,'','',0) 14/11/2024 07:26:17.5146 917 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 07:29:29.5411 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 07:31:17.1170 1143 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 07:35:33.3454 1296 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 07:42:36.9148 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 07:53:01.7442 886 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 14/11/2024 07:59:06.2050 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:00:40.4593 563 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,'2024-11-14 08:00:39','V',5066182157372040,2024,'2024-11-14 08:00:37','456082883700327005012999',1,2,16,'I','',1,0,1,'','0230004100104',151,0) 14/11/2024 08:01:17.4731 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:03:11.3716 1199 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 08:04:25.4504 999 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,0,50,-7,-350,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,0,50,7,350,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,0,100,-44,-4400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,0,100,44,4400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,0,200,-7,-1400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,0,200,7,1400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-14 08:04:11',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 14/11/2024 08:07:56.3539 2247 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:12:19.1775 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:13:41.9830 1371 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:17:53.6147 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 08:18:12.0901 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 08:18:15.2232 1129 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 08:19:13.1300 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:22:19.0856 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:22:44.4966 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:23:11.6017 1388 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 08:24:46.5083 642 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/11/2024 08:24:59.0297 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:25:53.8874 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:26:08.3791 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:26:43.9279 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:27:21.5641 1099 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/11/2024 08:27:30.2069 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:27:40.6089 618 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 08:28:03.4862 921 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/11/2024 08:29:15.7206 1151 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 08:29:16.3360 581 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,'2024-11-14 08:29:15','V',4883258248312630,2024,'2024-11-14 08:29:14','456083055400327001012999',1,2,1,'I','',1,0,1,'','',4) 14/11/2024 08:29:38.9982 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:30:03.2915 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:30:55.0462 621 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 14/11/2024 08:37:21.9374 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:37:36.1639 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:37:43.2677 1812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:38:05.1143 1910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:41:03.0464 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:41:58.9949 1823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 96 ms.) 14/11/2024 08:41:59.0229 1671 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,'2024-11-14 08:41:57','V',5190211550788880,2024,'2024-11-14 08:41:56','456083131600327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 08:42:07.7788 920 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/11/2024 08:42:09.6751 622 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 08:42:09',0,16,'2024-11-14 08:42:09','','Unauthorized Transit Entry 2') 14/11/2024 08:42:11.3071 1098 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:44:21.8786 1285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:45:14.1216 1244 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:49:50.3417 2085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:50:51.9460 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:51:30.9002 4136 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:54:27.4525 633 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 08:54:26' where traUID = 5038456272173680 and traStatus='V' and traEnabled=1 14/11/2024 08:54:33.6616 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 08:55:35.0948 537 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 08:55:34','V',4930555066847750,2024,'2024-11-14 08:55:33','456083213300327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 08:55:50.4992 522 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/11/2024 08:56:00.3077 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 08:57:16.2586 610 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 08:57:17.9318 1595 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 08:57:23.2133 1706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:01:49.3116 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:02:59.9730 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:03:52.0859 1332 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 14/11/2024 09:05:23.2539 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:05:56.4642 3134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:07:24.4421 532 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 09:08:31.0918 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:10:37.7086 1401 ms. EXEC: update payReceipt set recCreation = '2024-11-14 09:10:36',recModify = '2024-11-14 09:10:36',recUseId=0,recStatus='V' where recId = 322397 14/11/2024 09:11:12.9733 1150 ms. EXEC: update paycash set casCreation = '2024-11-14 09:11:11',casModify = '2024-11-14 09:11:11',casUseId=0,casStatus='V' where casId = 194819 (WAIT TIME 4 ms.) 14/11/2024 09:11:54.8534 1162 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 09:12:58.6453 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:14:38.0492 2050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:15:43.7423 1308 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:18:36.2031 1568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:19:52.2432 856 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 14/11/2024 09:23:49.9228 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:23:58.1143 1156 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 09:23:58.1343 1045 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:25:08.2884 654 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-14 09:25:07',0,'V',4840933623433430,5116905888342430,2024,'2024-11-14 09:25:07',18,1,0,4,'2024-11-14 09:40:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 09:26:40.8145 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:30:02.5998 1726 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 09:37:04.5187 744 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 09:37:03','V',5720833342425100,2024,'2024-11-14 09:37:03','456083462300327001012999',1,2,1,'I','',1,0,1,'','',4) 14/11/2024 09:39:48.7098 588 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 09:39:54.1034 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:40:51.9952 1363 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:43:45.0672 706 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,'2024-11-14 09:43:44','V',4644728840908730,2024,'2024-11-14 09:43:43','456083502300327001012999',1,2,1,'I','',1,0,1,'','0230003944059',13,0) 14/11/2024 09:43:51.1913 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 1 ms.) 14/11/2024 09:44:53.2659 527 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 09:44:52','V',5222590279753410,2024,'2024-11-14 09:44:52','456083509200327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 09:45:45.3568 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:45:49.9969 755 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 09:45:53.6884 596 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 09:46:07.9069 504 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 14/11/2024 09:46:26.7546 3823 ms. OPEN: select 1 as Tot,payUID,payPayed,payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 14/11/2024 09:46:26.9077 46329 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 14/11/2024 09:48:08.6618 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:48:39.9908 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:49:26.5200 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:51:06.3690 762 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:51:45.8154 1280 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,'2024-11-14 09:51:44','V',4998644449285960,2024,'2024-11-14 09:51:41','456083550100327001012999',1,2,1,'I','',1,0,1,'','',4) 14/11/2024 09:51:54.9685 538 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 09:51:54','V',5120643126382430,2024,'2024-11-14 09:51:53','456083551300327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 09:52:34.5911 599 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 09:52:33' where traUID = 4869768503394530 and traStatus='V' and traEnabled=1 14/11/2024 09:52:37.1348 1857 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 09:52:40.5641 1114 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:52:43.5280 2012 ms. EXEC: update payReceipt set recCreation = '2024-11-14 09:52:41',recModify = '2024-11-14 09:52:41',recUseId=0,recStatus='V' where recId = 322411 14/11/2024 09:54:35.6061 4381 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 09:54:31','V',5438612194506370,2024,'2024-11-14 09:54:29','456083444700327005012999',2,2,2,'O','',0,'2024-11-14 09:54:31',1,'','',0) 14/11/2024 09:54:37.5744 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:55:25.1473 1448 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:55:26.7584 1607 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeEnd' (WAIT TIME 8 ms.) 14/11/2024 09:55:27.4619 665 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,'2024-11-14 09:55:26','V',5304166921972670,2024,'2024-11-14 09:55:20','456083572000327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 09:56:07.8329 541 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49578, trcLastPrinted = '2400749578', trcLastDate = '2024-11-14 09:56:07' where trcStatus='V' and trcTerId = 18 14/11/2024 09:56:08.4914 623 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4653269464007410,4722925806272630,2024,'2024-11-14 09:56:07',' Date: 11/14/2024 9:56:06 AM Code: 456083278000327005012999 Entry Date: 11/14/2024 9:06:20 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 # 2400749578 ',0) 14/11/2024 09:58:00.0431 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 09:58:06.6726 558 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 09:59:08.8793 613 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 09:59:12.8599 825 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 09:59:13.8106 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:59:25.6415 1039 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTariffTerminal' nr: 1 14/11/2024 09:59:27.0324 707 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 09:59:36.9441 758 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 09:59:37.0822 825 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/11/2024 10:00:28.4536 1781 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,'2024-11-14 10:00:26','V',5478258599098590,2024,'2024-11-14 10:00:25','456080000200327003229999',22,22,3,'I','',1,0,1,'','',2) 14/11/2024 10:00:28.4536 1657 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,'2024-11-14 10:00:26','V',5760709892094240,2024,'2024-11-14 10:00:26','456083602600327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 10:01:06.9163 919 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 10:01:45.2250 1558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:02:05.6157 1314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:02:57.2623 650 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 ('2024-11-14 10:02:56',0,'V',4787657430657710,5270735574571330,2024,'2024-11-14 10:02:56',18,1,0,4,'2024-11-14 10:17:56','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 10:02:58.5412 673 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,'2024-11-14 10:02:57','V',5434227623153860,2024,'2024-11-14 10:02:56','456083509200327005012999',2,2,2,'O','',0,'2024-11-14 10:02:57',1,'','',0) 14/11/2024 10:02:58.5422 717 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5270735574571330,4787657430657710,2024,'2024-11-14 10:02:57',' Date: 11/14/2024 10:02:56 AM Code: 456083520000327005012999 Entry Date: 11/14/2024 9:46:40 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 # 2400749580 ',0) 14/11/2024 10:03:06.0192 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:04:07.2732 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:05:44.0611 650 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 ('2024-11-14 10:05:43',0,'V',5395800330785180,5120643126382430,2024,'2024-11-14 10:05:43',18,1,0,4,'2024-11-14 10:20:43','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 10:06:14.4724 520 ms. OPEN: select * from abbCards where carId = 165 14/11/2024 10:06:53.0923 2348 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/11/2024 10:07:28.7292 513 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 10:07:35.3146 589 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 10:07:40.3900 945 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:07:45.1743 606 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,'2024-11-14 10:07:44','V',4852218979705250,2024,'2024-11-14 10:07:42','456083646200327005012999',1,2,16,'I','',1,0,1,'','0230003957463',25,0) 14/11/2024 10:07:45.8637 679 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 14/11/2024 10:07:46.4651 531 ms. EXEC: update abbCards set carLastDate = '2024-11-14 10:07:45',carLastDirection='I' where carStatus='V' and carId = 25 14/11/2024 10:07:47.1146 643 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 14/11/2024 10:07:54.2263 1144 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:08:51.7359 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:09:21.3167 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:09:37.6657 1202 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:09:40.6947 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:10:47.4714 1411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:11:33.3722 660 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 10:12:21.5675 896 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 14 ms.) 14/11/2024 10:12:57.5666 1054 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 10:13:05.3769 1084 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/11/2024 10:13:19.1851 1481 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:13:34.4804 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:13:54.6319 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:13:56.9875 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:15:28.0685 1128 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 ('2024-11-14 10:15:26',0,'V',4643050040005110,5186543693712650,2024,'2024-11-14 10:15:26',3,1,0,4,'2024-11-14 10:30:26','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 14/11/2024 10:15:44.5396 590 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 10:17:46.8505 668 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-14 10:17:46' where subId = 15 14/11/2024 10:17:47.6901 832 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-14 10:17:46','0230003944064',0,0,4781743419887650,14,'0000-00-00 00:00:00','0000-00-00 00:00:00') 14/11/2024 10:17:49.3192 1619 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 ('2024-11-14 10:17:47',0,'V',4781743419887650,4774103339790680,2024,'2024-11-14 10:17:47',2,1,0,-1,'2024-11-14 11:17:47','S','KES',0,0,0,'','','',3,0,0) 14/11/2024 10:18:00.3256 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:18:38.8204 556 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 10:19:25.5006 1105 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/11/2024 10:20:23.4424 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:21:28.5821 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:21:37.8903 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:23:13.6825 508 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 ('2024-11-14 10:23:13',0,'V',4634536980132690,5739871469994940,2024,'2024-11-14 10:23:13',18,1,0,4,'2024-11-14 10:38:13','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 10:23:14.5240 646 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5739871469994940,4634536980132690,2024,'2024-11-14 10:23:13',' Date: 11/14/2024 10:23:13 AM Code: 456083587900327005012999 Entry Date: 11/14/2024 9:57:59 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 # 2400749583 ',0) 14/11/2024 10:26:37.8293 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:28:02.2808 651 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/11/2024 10:28:03.6768 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:28:43.8597 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:29:59.5934 1454 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 10:29:58',0,16,'2024-11-14 10:29:58','','Unauthorized Transit Entry 2') 14/11/2024 10:30:03.1938 559 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5503097250574630,5249519000392950,2024,'2024-11-14 10:30:02','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/14/2024 9:53:13 AM Date : 11/14/2024 10:29:59 AM Code : 456083559300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 14/11/2024 10:31:58.7843 844 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,'2024-11-14 10:31:57','V',5538732194881130,2024,'2024-11-14 10:31:56','456083791600327005012999',1,2,16,'I','',1,0,1,'','0230004101223',11,0) 14/11/2024 10:33:03.3836 533 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 10:33:02','V',5352185135751410,2024,'2024-11-14 10:32:59','456083797900327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 10:33:38.5181 1669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:34:23.9426 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:35:04.3786 2116 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:36:40.7472 2294 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 10:38:05.8412 1136 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49585, trcLastPrinted = '2400749585', trcLastDate = '2024-11-14 10:38:04' where trcStatus='V' and trcTerId = 18 14/11/2024 10:39:52.8599 563 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 10:39:51' where traUID = 5145998416720680 and traStatus='V' and traEnabled=1 14/11/2024 10:39:55.9100 3234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:43:12.8889 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:44:37.2094 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:44:44.0870 1019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:44:52.4005 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:46:04.4198 558 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49586, trcLastPrinted = '2400749586', trcLastDate = '2024-11-14 10:46:03' where trcStatus='V' and trcTerId = 18 14/11/2024 10:47:17.8760 664 ms. EXEC: update abbCards set carLastDate = '2024-11-14 10:47:17',carLastDirection='O' where carStatus='V' and carId = 20 14/11/2024 10:47:25.8174 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:49:20.3261 694 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 10:49:32.4702 966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:52:26.5499 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 10:52:26.5499 603 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 10:53:27.6188 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:54:32.9776 785 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 10:54:31' where traUID = 4874655981858420 and traStatus='V' and traEnabled=1 14/11/2024 10:55:36.5032 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 10:55:59.9209 816 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 10:57:13.3321 27815 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal 14/11/2024 10:59:12.3338 740 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:00:45.1880 559 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 11:01:00.2061 1167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:03:10.7155 585 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 11:03:10' where traUID = 4796687988733020 and traStatus='V' and traEnabled=1 14/11/2024 11:03:16.6005 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:07:27.7268 878 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:07:55.9077 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:11:00.4934 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:11:57.8469 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:11:58.4033 556 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); 14/11/2024 11:12:53.1590 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:13:39.4570 863 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:13:40.2135 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:13:41.6214 1421 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,'2024-11-14 11:13:40','V',4685447537732640,2024,'2024-11-14 11:13:34','456084041400327005012999',1,2,16,'I','',1,0,1,'','0230004101179',8,0) 14/11/2024 11:14:15.3810 1040 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,'2024-11-14 11:14:14','V',5306946990120130,2024,'2024-11-14 11:14:13','456084045300327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 11:16:43.9345 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:16:54.1714 971 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 371022 else acvFstPayId end),acvLstPayId = 371022 where acvSftId = 818 and acvCodeId = 3 14/11/2024 11:17:01.5143 537 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 11:17:00','V',4834563703514220,2024,'2024-11-14 11:16:58','456083980900327005012999',2,2,2,'O','',0,'2024-11-14 11:17:00',1,'','',0) 14/11/2024 11:17:03.8309 1663 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 11:17:02' where payTraUID = 4706837095146530 and payStatus='V' and payEnabled=1 14/11/2024 11:18:22.9158 655 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 11:20:23.6146 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:23:57.5355 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:26:12.2125 586 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 11:27:27.3267 2008 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 14/11/2024 11:28:49.5636 1451 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:30:43.4767 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:31:04.0094 886 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 11:31:07.2396 3202 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 11:31:12.5141 897 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:31:15.5942 623 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/11/2024 11:33:30.3112 545 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 11:33:40.9173 3081 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:33:58.3119 604 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 ('2024-11-14 11:33:56',0,'V',5430889707522390,5710663439851010,2024,'2024-11-14 11:33:56',3,1,0,4,'2024-11-14 11:48:56','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 14/11/2024 11:35:50.8781 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:36:42.5356 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:39:09.1786 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:40:23.1580 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:40:48.1017 794 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,'2024-11-14 11:40:47','V',4826130549937770,2024,'2024-11-14 11:40:44','456084204400327001012999',1,2,1,'I','',1,0,1,'','',4) 14/11/2024 11:40:50.9636 2766 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 11:41:52.4267 1419 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:42:42.2860 1318 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:43:09.7043 1209 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 11:43:10.5339 794 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 11:43:09' where payTraUID = 5563989037390420 and payStatus='V' and payEnabled=1 14/11/2024 11:43:29.7577 1156 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-50,5),subLastDebit = '2024-11-14 11:43:28' where subId = 150 14/11/2024 11:43:34.5619 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:47:36.6637 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:48:15.5957 860 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 14/11/2024 11:49:37.5785 593 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/11/2024 11:49:42.4757 2863 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-50,5),subLastDebit = '2024-11-14 11:49:39' where subId = 120 14/11/2024 11:49:42.9931 517 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-14 11:49:42','0810007154469',-50,3300,5498282204008530,109,'0000-00-00 00:00:00','0000-00-00 00:00:00') 14/11/2024 11:49:56.0188 781 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 11:49:56.2990 749 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,'2024-11-14 11:49:55','V',5019761896875120,2024,'2024-11-14 11:49:54','456084259400327001012999',1,2,1,'I','',1,0,1,'','',4) 14/11/2024 11:49:57.5978 1198 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 11:50:58.5866 722 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:51:00.8151 2649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:51:14.5633 1212 ms. EXEC: update abbCards set carLastDate = '2024-11-14 11:51:13',carLastDirection='O' where carStatus='V' and carId = 10 14/11/2024 11:51:16.4045 1313 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 11:51:14' where payTraUID = 4836861482445520 and payStatus='V' and payEnabled=1 14/11/2024 11:52:14.2742 1412 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:52:20.2531 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,'2024-11-14 11:52:18','V',4869438611100990,2024,'2024-11-14 11:52:17','456084273700327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 11:52:20.2582 2639 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 11:52:31.7568 2339 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 11:52:29',0,16,'2024-11-14 11:52:29','','Unauthorized Transit Entry 2') (WAIT TIME 3 ms.) 14/11/2024 11:52:39.6471 4107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:53:10.1185 3634 ms. EXEC: update abbCards set carLastDate = '2024-11-14 11:53:06',carLastDirection='O' where carStatus='V' and carId = 111 14/11/2024 11:53:11.3743 832 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,'2024-11-14 11:53:10','V',5091881009710380,2024,'2024-11-14 11:53:05','456084278500327005012999',1,2,16,'I','',1,0,1,'','0810007127724',111,0) 14/11/2024 11:54:42.6263 1496 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 11:54:57.8705 664 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 11:54:57',17,1,'2024-11-14 11:54:57','456083864600327005012999','Pagato (Contanti ) Biglietto ') 14/11/2024 11:55:16.0976 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:55:41.1984 3024 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 11:55:50.3515 1465 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:55:50.3525 1020 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 11:56:32.9009 1196 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:56:35.8699 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:57:18.9077 4355 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:57:23.1165 965 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 11:57:40.7963 3779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:57:55.3951 3176 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 14/11/2024 11:58:43.2490 503 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 11:58:42',3,42101,0,1000,1,1000,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 1000 and curType = 'N'; 14/11/2024 11:58:44.5679 741 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 11:58:43',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 11:58:43',3,42101,0,500,-1,-500,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 14/11/2024 11:58:46.3671 2111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:59:46.2752 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:59:49.0690 2285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:59:51.4986 1109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:59:51.5207 923 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/11/2024 11:59:54.0363 994 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 11:59:53','V',5410667745551100,2024,'2024-11-14 11:59:52','456084319200327001012999',1,2,1,'I','',1,0,1,'','',4) 14/11/2024 11:59:55.6604 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 11:59:59.2678 1586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:02.5860 2704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:05.6701 1000 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:08.2929 1507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:19.3553 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:32.9613 1009 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:43.2932 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:47.0988 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:53.3029 2025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:00:53.4330 929 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 12:00:58.7516 1047 ms. EXEC: update payReceipt set recCreation = '2024-11-14 12:00:57',recModify = '2024-11-14 12:00:57',recUseId=0,recStatus='V' where recId = 322462 14/11/2024 12:01:02.0868 1537 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/11/2024 12:01:19.1752 1265 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:03:22.8058 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:03:36.0447 2781 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 14/11/2024 12:03:36.0497 2714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:03:38.9386 2861 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/11/2024 12:03:39.0086 2258 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 14/11/2024 12:03:55.0364 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:03:58.9970 544 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 12:03:59.7615 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:04:30.1348 666 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4831557926339730,4890128118233060,2024,'2024-11-14 12:04:29','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/14/2024 11:11:52 AM Date : 11/14/2024 12:04:27 PM Code : 456084031200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 14/11/2024 12:04:33.0878 1684 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 12:04:30',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 ('2024-11-14 12:04:30',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'; 14/11/2024 12:04:49.0845 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:05:14.7406 3730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:05:54.3681 1383 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/11/2024 12:05:58.0445 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:06:04.0876 624 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 12:06:03','V',4750870664945190,2024,'2024-11-14 12:06:02','456084356200327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 12:07:13.3288 2081 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 14/11/2024 12:08:31.1098 787 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,'2024-11-14 12:08:30','V',5211293498416460,2024,'2024-11-14 12:08:28','456084370800327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 12:08:46.1639 840 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 ('2024-11-14 12:08:43',0,'V',5189170115025610,5079839293828650,2024,'2024-11-14 12:08:43',3,1,0,4,'2024-11-14 12:23:43','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 14/11/2024 12:08:53.8040 1342 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,'2024-11-14 12:08:52','V',5025977313019150,2024,'2024-11-14 12:08:51','456084373100327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 12:09:12.6165 2155 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,'2024-11-14 12:09:10','V',5669361212895710,2024,'2024-11-14 12:09:10','456084375000327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 12:10:25.5573 572 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,'2024-11-14 12:10:24','V',4873607862184380,2024,'2024-11-14 12:10:23','456084031200327005012999',2,2,2,'O','',0,'2024-11-14 12:10:24',1,'','',0) 14/11/2024 12:10:26.7281 1159 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 12:10:26.8301 620 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 12:10:26',0,16,'2024-11-14 12:10:26','','Unauthorized Transit Entry 2') 14/11/2024 12:10:32.3648 1027 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 ('2024-11-14 12:10:29',0,'V',5530757630476990,4744365726070890,2024,'2024-11-14 12:10:29',3,1,0,4,'2024-11-14 12:25:29','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 14/11/2024 12:11:19.1501 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:17:06.0989 3477 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,'2024-11-14 12:17:02','V',4764079697890620,2024,'2024-11-14 12:17:01','456084293700327001012999',2,2,2,'O','',0,'2024-11-14 12:17:02',1,'','',0) 14/11/2024 12:17:07.0075 598 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 12:17:06' where payTraUID = 4744365726070890 and payStatus='V' and payEnabled=1 14/11/2024 12:17:15.7123 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:17:16.2707 509 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 12:17:37.2307 555 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 12:17:36','V',4654994220954420,2024,'2024-11-14 12:17:31','456084310400327005012999',2,2,2,'O','',0,'2024-11-14 12:17:36',1,'','',0) 14/11/2024 12:17:41.5956 4290 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 6 ms.) 14/11/2024 12:18:39.6874 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:18:40.3369 619 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 12:19:28.1228 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:19:40.6061 696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:19:52.7883 3671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:20:15.2633 561 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 12:20:19.3170 3841 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 12:20:15' where payTraUID = 4934569265229530 and payStatus='V' and payEnabled=1 14/11/2024 12:20:22.1079 2788 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 12:20:15' where traUID = 4934569265229530 and traStatus='V' and traEnabled=1 14/11/2024 12:20:26.1656 1647 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 12:20:26.7660 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:20:38.9951 2814 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,'2024-11-14 12:20:36','V',5182271315822530,2024,'2024-11-14 12:20:21','456084442100327005031999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 12:21:09.8017 3981 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:22:03.4566 508 ms. EXEC: update abbCards set carLastDate = '2024-11-14 12:22:02',carLastDirection='I' where carStatus='V' and carId = 14 14/11/2024 12:22:07.8365 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:24:35.2420 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 405 ms.) 14/11/2024 12:28:45.7353 1302 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:28:58.6210 799 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 12:28:59.4665 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:29:04.6290 1249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:29:16.9792 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:29:52.0867 2289 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:30:29.9780 756 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:30:31.4890 1511 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); 14/11/2024 12:31:00.9097 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:31:17.3526 811 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 12:32:06.2433 1176 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,'2024-11-14 12:32:05','V',5342560181622520,2024,'2024-11-14 12:32:03','456084452000327005012999',2,2,2,'O','',0,'2024-11-14 12:32:05',1,'','0230003944064',14,0) 14/11/2024 12:32:07.7533 1507 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 12:32:19.1349 2289 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:32:22.6913 2139 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 12:33:52.7945 737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:33:55.7205 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:34:08.8422 813 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49597, trcLastPrinted = '2400749597', trcLastDate = '2024-11-14 12:34:08' where trcStatus='V' and trcTerId = 18 14/11/2024 12:35:06.6729 1421 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,'2024-11-14 12:35:05','V',5122611184011870,2024,'2024-11-14 12:35:04','456084454200327005012999',2,2,2,'O','',0,'2024-11-14 12:35:05',1,'','',0) 14/11/2024 12:35:27.8400 1042 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 ('2024-11-14 12:35:26',0,'V',4743600732809040,5344748931622780,2024,'2024-11-14 12:35:26',2,1,0,-1,'2024-11-14 13:35:26','S','KES',0,0,0,'','','',3,0,0) 14/11/2024 12:35:29.7693 969 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 12:35:28' where payTraUID = 5344748931622780 and payStatus='V' and payEnabled=1 14/11/2024 12:35:30.3527 1681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:35:35.1409 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:36:50.4762 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:38:05.5654 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:41:35.1114 1160 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 12:43:27.0532 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:45:36.2995 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:47:04.4254 597 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 ('2024-11-14 12:44:23',6,'V',4773175022550810,4709880691203940,2024,'2024-11-14 12:44:23',4,1,0,4,'2024-11-14 12:59:23','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/11/2024 12:48:36.4549 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:48:41.6794 2591 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 14/11/2024 12:48:43.8699 641 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,'2024-11-14 12:48:43','V',5500173406738150,2024,'2024-11-14 12:48:38','456084611800327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 14/11/2024 12:49:30.9883 611 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 12:49:30' where payTraUID = 5575587232051110 and payStatus='V' and payEnabled=1 14/11/2024 12:50:01.2005 3648 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,'2024-11-14 12:49:57','V',5763609793885990,2024,'2024-11-14 12:49:57','456084619700327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 12:50:03.0137 812 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/11/2024 12:50:41.9027 877 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 14/11/2024 12:53:32.7188 527 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 12:53:58.2699 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 12:55:56.2537 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 12:57:16.4283 563 ms. OPEN: select traCode from movTransit where traCode ='456084663400327005012999' 14/11/2024 12:57:31.7766 700 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,'2024-11-14 12:57:31','V',5722192854357610,2024,'2024-11-14 12:57:30','456084331000327005012999',2,2,2,'O','',0,'2024-11-14 12:57:31',1,'','',0) 14/11/2024 12:58:28.5335 1588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:02:29.6506 974 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 13:02:33.3791 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:02:49.6439 1242 ms. EXEC: update payReceipt set recCreation = '2024-11-14 13:02:48',recModify = '2024-11-14 13:02:48',recUseId=0,recStatus='V' where recId = 322487 14/11/2024 13:03:34.4219 584 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49600, trcLastPrinted = '2400749600', trcLastDate = '2024-11-14 13:03:33' where trcStatus='V' and trcTerId = 18 14/11/2024 13:04:03.1260 1244 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 13:04:07.2478 580 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 13:05:19.8833 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:06:14.5589 2986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:06:52.5663 596 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 13:06:51',0,16,'2024-11-14 13:06:51','','Unauthorized Transit Entry 2') 14/11/2024 13:07:11.3148 1785 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 14/11/2024 13:07:22.3592 1167 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 13:07:21' where traUID = 5080322711050560 and traStatus='V' and traEnabled=1 14/11/2024 13:07:50.9893 531 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 13:08:29.3119 2267 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49602, trcLastPrinted = '2400749602', trcLastDate = '2024-11-14 13:08:27' where trcStatus='V' and trcTerId = 18 14/11/2024 13:09:02.4841 1117 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:09:18.3026 1252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:12:24.3439 604 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/11/2024 13:12:40.5768 1476 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:13:12.6602 3585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:13:53.0462 1380 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 13:14:00.8914 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:14:09.5962 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:15:05.4386 1349 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:15:09.8525 1290 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:15:29.1674 1080 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 13:15:27',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 14/11/2024 13:15:35.2965 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:17:05.3587 856 ms. EXEC: update abbCards set carLastDate = '2024-11-14 13:17:04',carLastDirection='O' where carStatus='V' and carId = 20 14/11/2024 13:17:11.9021 889 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:17:36.1893 1235 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:18:11.6870 3030 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,'2024-11-14 13:18:08','V',5258203229472490,2024,'2024-11-14 13:18:07','456084516800327005012999',2,2,2,'O','',0,'2024-11-14 13:18:08',1,'','',0) 14/11/2024 13:18:17.7981 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:18:21.6697 532 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/11/2024 13:19:32.6001 1584 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,'2024-11-14 13:19:31','V',4751670251041520,2024,'2024-11-14 13:19:28','456084663400327005012999',2,2,2,'O','',0,'2024-11-14 13:19:31',1,'','',0) 14/11/2024 13:21:03.2416 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:21:55.4835 620 ms. EXEC: update paycash set casCreation = '2024-11-14 13:21:54',casModify = '2024-11-14 13:21:54',casUseId=0,casStatus='V' where casId = 194879 14/11/2024 13:24:25.0915 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:24:59.3063 549 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-14 13:24:58',0,'V',5659620479897430,5148696899359580,2024,'2024-11-14 13:24:58',18,1,0,4,'2024-11-14 13:39:58','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/11/2024 13:25:24.9195 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:26:32.5376 524 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 13:26:32' where payTraUID = 4958815056242270 and payStatus='V' and payEnabled=1 14/11/2024 13:27:20.3956 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:27:58.5941 1335 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 14/11/2024 13:27:59.9260 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:28:20.1705 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:28:22.5872 646 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,'2024-11-14 13:28:21','V',5268850026512730,2024,'2024-11-14 13:28:21','456084055100327005012999',2,2,2,'O','',0,'2024-11-14 13:28:21',1,'','',0) 14/11/2024 13:28:47.1906 556 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 13:30:00.9369 916 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 13:29:59' where traUID = 4775082835751930 and traStatus='V' and traEnabled=1 14/11/2024 13:35:09.9503 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:35:36.0558 1127 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,'2024-11-14 13:35:34','V',4623280134697930,2024,'2024-11-14 13:35:34','456084813200327005012999',2,2,2,'O','',0,'2024-11-14 13:35:34',1,'','',0) 14/11/2024 13:35:36.6732 557 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 13:35:39.2459 2361 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 13:35:36' where traUID = 5514580161563900 and traStatus='V' and traEnabled=1 14/11/2024 13:35:51.2910 1478 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:35:58.2146 649 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,'2024-11-14 13:35:57','V',5522053739029090,2024,'2024-11-14 13:35:56','456084788400327005012999',2,2,2,'O','',0,'2024-11-14 13:35:57',1,'','',0) 14/11/2024 13:35:59.0571 551 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 13:35:58' where traUID = 4632349314416170 and traStatus='V' and traEnabled=1 14/11/2024 13:36:00.5111 1446 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456084788400327005012999' 14/11/2024 13:36:03.1929 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:39:10.9724 514 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 13:39:10' where traUID = 4857857767230960 and traStatus='V' and traEnabled=1 14/11/2024 13:39:14.7159 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:41:24.4776 933 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:42:22.7985 1040 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 13:42:21' where payTraUID = 5696962679125300 and payStatus='V' and payEnabled=1 14/11/2024 13:44:11.9535 554 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 13:45:32.8215 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:46:16.7118 814 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:46:27.8332 546 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-14 12:46:27') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-14 13:46:27' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-14 13:46:27' and (resAreId = 1 or resAreId <= 0) nr: 0 14/11/2024 13:47:00.9194 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:48:51.1870 737 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-14 13:48:49',0,'V',5583619119444580,4822819688063310,2024,'2024-11-14 13:48:49',3,1,0,4,'2024-11-14 14:03:49','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 14/11/2024 13:48:53.4285 940 ms. EXEC: update paycash set casCreation = '2024-11-14 13:48:52',casModify = '2024-11-14 13:48:52',casUseId=0,casStatus='V' where casId = 194884 14/11/2024 13:50:00.8486 978 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:51:06.6956 2366 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 13:51:45.2103 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:51:45.9738 1429 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:51:52.4461 993 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 13:52:01.9605 1950 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 13:52:02.3698 3026 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 13:51:59',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'; 14/11/2024 13:52:55.1290 1670 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,'2024-11-14 13:52:53','V',5659998299701040,2024,'2024-11-14 13:52:51','456084997100327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 13:53:37.1671 1696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:53:52.2472 1415 ms. EXEC: update abbCards set carLastDate = '2024-11-14 13:53:50',carLastDirection='I' where carStatus='V' and carId = 165 14/11/2024 13:53:53.2448 715 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 13:53:52' where payTraUID = 5398895725737840 and payStatus='V' and payEnabled=1 14/11/2024 13:54:03.3216 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 13:56:13.4925 730 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 14/11/2024 14:00:37.6711 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:01:05.0694 838 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 ('2024-11-14 14:01:03',0,'V',5276406754054370,5001120705981090,2024,'2024-11-14 14:01:03',18,1,0,4,'2024-11-14 14:16:03','C','KES',300,300,0,'','','',1,300,0,0,'',0,0) 14/11/2024 14:02:14.2296 843 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 14:02:19.1318 1351 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:02:50.4348 954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:02:59.2597 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:03:39.7697 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:04:16.0880 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 ('2024-11-14 14:04:15',0,'V',5240929386546520,5454678294484900,2024,'2024-11-14 14:04:15',18,1,0,4,'2024-11-14 14:19:15','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 14:04:46.0540 547 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 ('2024-11-14 14:04:45',0,'V',5092353150078570,4955847407506980,2024,'2024-11-14 14:04:45',18,1,0,4,'2024-11-14 14:19:45','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 14:05:49.8096 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:05:50.8773 1341 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 14:05:53.8913 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:05:55.4484 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:07:57.6570 655 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 14:09:05.4043 1175 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 14:09:06.5310 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:09:26.7626 808 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 14/11/2024 14:11:29.0843 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:12:46.8773 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:12:53.7358 1017 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5556016074305400,5638939615419380,2024,'2024-11-14 14:12:52',' Date: 11/14/2024 2:12:52 PM Code: 456084617700327005012999 Entry Date: 11/14/2024 12:49:37 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400749616 ',0) 14/11/2024 14:12:54.9316 993 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 14/11/2024 14:15:41.9582 1299 ms. EXEC: update payReceipt set recCreation = '2024-11-14 14:15:40',recModify = '2024-11-14 14:15:40',recUseId=0,recStatus='V' where recId = 322526 14/11/2024 14:15:43.5503 1281 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 14:15:41',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'; 14/11/2024 14:17:44.4181 1219 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:17:49.3724 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:19:01.2174 730 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 14:19:34.6087 783 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 ('2024-11-14 14:17:22',1,'V',5558709925317380,4704252703573330,2024,'2024-11-14 14:17:22',17,1,0,4,'2024-11-14 14:32:22','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 14:24:22.6171 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:25:12.0461 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:26:37.8545 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:26:38.5579 902 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 14:26:52.6974 662 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 14:26:51',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 14/11/2024 14:28:06.5107 1083 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,'2024-11-14 14:28:05','V',4959739384262330,2024,'2024-11-14 14:28:04','456085111600327005012999',2,2,2,'O','',0,'2024-11-14 14:28:05',1,'','',0) 14/11/2024 14:28:12.1325 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:30:00.4428 1050 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:30:16.9338 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:30:17.4312 1323 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/11/2024 14:34:10.9552 528 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 14:34:10' where payTraUID = 4788134599195960 and payStatus='V' and payEnabled=1 14/11/2024 14:35:28.3689 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:35:47.5828 602 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 ('2024-11-14 14:35:46',0,'V',5366813594671570,5659998299701040,2024,'2024-11-14 14:35:46',18,1,0,4,'2024-11-14 14:50:46','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 14:41:13.8297 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:41:42.2908 815 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:42:02.3852 1617 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5502060162295340,5620111138397970,2024,'2024-11-14 14:42:00',' Date: 11/14/2024 2:42:00 PM Code: 456084567500327005012999 Entry Date: 11/14/2024 12:41:15 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400749623 ',0) 14/11/2024 14:42:05.5043 3118 ms. EXEC: update payReceipt set recCreation = '2024-11-14 14:42:02',recModify = '2024-11-14 14:42:02',recUseId=0,recStatus='V' where recId = 322542 14/11/2024 14:42:15.5470 1329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:42:34.6787 1092 ms. EXEC: update payReceipt set recCreation = '2024-11-14 14:42:33',recModify = '2024-11-14 14:42:33',recUseId=0,recStatus='V' where recId = 322543 14/11/2024 14:42:35.2832 592 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-14 14:42:34',0,0,'V',4712184899465100,4936483698051440,2024,'2024-11-14 14:42:34',3,'KES',1,200,200,'N',''); 14/11/2024 14:42:52.3486 1143 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:45:43.8201 1032 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 14:45:43.9762 1373 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 14:45:42' where payTraUID = 4936483698051440 and payStatus='V' and payEnabled=1 14/11/2024 14:45:49.1977 978 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 14:49:54.1764 534 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 14:49:53' where payTraUID = 4993817572216730 and payStatus='V' and payEnabled=1 14/11/2024 15:00:52.0870 842 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:04:08.2911 828 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,'2024-11-14 15:04:07','V',4825625379619150,2024,'2024-11-14 15:04:05','456085200500327005012999',2,2,2,'O','',0,'2024-11-14 15:04:07',1,'','',0) 14/11/2024 15:06:55.6839 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:09:54.5154 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:11:28.8784 603 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,'2024-11-14 15:11:28','V',5351294819265340,2024,'2024-11-14 15:11:27','456085365100327005012999',2,2,2,'O','',0,'2024-11-14 15:11:28',1,'','',0) 14/11/2024 15:11:39.2964 793 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:11:39.8688 558 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 15:12:06.1363 1194 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,'2024-11-14 15:12:04','V',5147980445981610,2024,'2024-11-14 15:12:03','456085472300327005012999',1,2,16,'I','',1,0,1,'','0230003950896',20,0) 14/11/2024 15:12:07.0749 934 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 15:12:08.0616 710 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,'2024-11-14 15:12:07','V',4809310150562000,2024,'2024-11-14 15:12:05','456084375000327005012999',2,2,2,'O','',0,'2024-11-14 15:12:07',1,'','',0) 14/11/2024 15:12:08.2127 840 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 15:12:12.5146 2327 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:12:27.4736 684 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,'2024-11-14 15:12:26','V',4847234007400600,2024,'2024-11-14 15:12:25','456084582900327005012999',2,2,2,'O','',0,'2024-11-14 15:12:26',1,'','',0) 14/11/2024 15:12:28.7104 796 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 15:12:27' where payTraUID = 5527989804205420 and payStatus='V' and payEnabled=1 14/11/2024 15:13:04.8305 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:19:13.0516 649 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 15:19:12' where traUID = 5143881410709210 and traStatus='V' and traEnabled=1 14/11/2024 15:19:19.1837 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:22:00.2012 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:22:04.8213 2378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:22:10.7803 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:23:11.6780 1717 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,'2024-11-14 15:23:09','V',5213115695576770,2024,'2024-11-14 15:23:08','456085167500327005012999',2,2,2,'O','',0,'2024-11-14 15:23:09',1,'','',0) 14/11/2024 15:23:43.8175 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:23:44.1067 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:24:01.8235 917 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 ('2024-11-14 15:24:00',0,'V',5551150690938970,5660472525074240,2024,'2024-11-14 15:24:00',18,1,0,4,'2024-11-14 15:39:00','C','KES',400,400,0,'','','',1,400,0,0,'',0,0) 14/11/2024 15:24:32.8903 1127 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 ('2024-11-14 15:24:30',0,'V',5698207055937540,4718591032238870,2024,'2024-11-14 15:24:30',3,1,0,4,'2024-11-14 15:39:30','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 14/11/2024 15:24:34.5143 592 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 15:24:33',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 ('2024-11-14 15:24:33',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'; 14/11/2024 15:25:01.8126 624 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 15:25:02.8513 1031 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movInside' nr: 1 14/11/2024 15:25:03.9540 1100 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 15:25:01' where payTraUID = 5660472525074240 and payStatus='V' and payEnabled=1 14/11/2024 15:25:05.8423 1887 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 15:25:01' where traUID = 5660472525074240 and traStatus='V' and traEnabled=1 14/11/2024 15:25:48.0525 568 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 15:25:55.2163 728 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:26:33.2997 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:26:43.0412 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:26:43.0412 602 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 15:27:58.4076 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:29:16.1535 1657 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,'2024-11-14 15:29:14','V',5276820545548700,2024,'2024-11-14 15:29:13','456085207100327005012999',2,2,2,'O','',0,'2024-11-14 15:29:14',1,'','',0) 14/11/2024 15:29:17.1632 1007 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 15:29:18.3120 1140 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 15:29:22.1925 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:29:39.0708 591 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 ('2024-11-14 15:28:59',0,'V',4663999767340090,5157257489978530,2024,'2024-11-14 15:28:59',3,1,0,4,'2024-11-14 15:43:59','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 14/11/2024 15:29:44.7206 813 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 ('2024-11-14 15:27:00',6,'V',5756204785154840,5005610137946310,2024,'2024-11-14 15:27:00',4,1,0,4,'2024-11-14 15:42:00','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 15:31:57.8035 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:33:12.0381 587 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 15:34:10.0068 1656 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16133, trcLastPrinted = '2400416133', trcLastDate = '2024-11-14 15:34:08' where trcStatus='V' and trcTerId = 4 14/11/2024 15:36:20.4400 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:36:48.1755 1013 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/11/2024 15:36:52.2352 629 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 ('2024-11-14 15:34:11',6,'V',4779569667122750,5632365028858450,2024,'2024-11-14 15:34:11',4,1,0,4,'2024-11-14 15:49:11','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 14/11/2024 15:37:08.0898 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:39:38.2121 733 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/11/2024 15:39:42.9593 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:42:04.9532 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:43:08.9850 1057 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 15:43:07' where traUID = 4869438611100990 and traStatus='V' and traEnabled=1 14/11/2024 15:49:45.3668 501 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 15:49:44' where payTraUID = 5051443451386090 and payStatus='V' and payEnabled=1 14/11/2024 15:49:50.3982 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:52:00.6061 1082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:56:05.3607 1016 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 15:56:03',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/11/2024 15:56:36.5495 1232 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:57:33.5506 1597 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/11/2024 15:57:59.8021 1452 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:58:36.4887 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:58:37.0941 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 15:59:12.7989 1818 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 15:59:13.3953 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 15:59:22.1542 1274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:01:53.5083 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:03:01.9510 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:05:32.1324 2153 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 16:06:44.6728 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:08:14.1096 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:08:19.6783 823 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 16:09:40.2171 556 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 16:11:39.4178 680 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:13:27.6331 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:22:35.5982 544 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 16:22:36.3847 773 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 14/11/2024 16:23:54.7120 1050 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/11/2024 16:25:18.2518 1000 ms. EXEC: update payInventory set invCreation = '2024-11-14 16:25:17',invModify = '2024-11-14 16:25:17',invUseId=0,invStatus='V' where invId = 219241 14/11/2024 16:27:06.3781 2338 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 16:27:13.4728 573 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-14 16:27:12',0,0,'V',4662880447319190,5348826975263200,2024,'2024-11-14 16:27:12',3,'KES',1,200,200,'N',''); 14/11/2024 16:27:15.1369 748 ms. EXEC: update paycash set casCreation = '2024-11-14 16:27:14',casModify = '2024-11-14 16:27:14',casUseId=0,casStatus='V' where casId = 194917 14/11/2024 16:27:16.5479 1849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:27:17.7357 2597 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 16:27:14',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 ('2024-11-14 16:27:14',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'; 14/11/2024 16:27:21.3171 1509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:28:00.0690 3006 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 16:28:17.3575 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:29:47.7299 4350 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:30:41.0785 1521 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 ('2024-11-14 16:30:35',0,'V',5223602592788080,4882256517047060,2024,'2024-11-14 16:30:35',3,1,0,4,'2024-11-14 16:45:35','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 14/11/2024 16:30:41.9421 726 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4882256517047060,5223602592788080,2024,'2024-11-14 16:30:41','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/14/2024 4:05:15 PM Date : 11/14/2024 4:30:35 PM Code : 456085791500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 14/11/2024 16:30:45.3244 2606 ms. EXEC: update paycash set casCreation = '2024-11-14 16:30:42',casModify = '2024-11-14 16:30:42',casUseId=0,casStatus='V' where casId = 194918 14/11/2024 16:31:23.2517 768 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:31:36.3284 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:31:40.6583 902 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:34:36.9361 1982 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 16:34:34',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'; 14/11/2024 16:34:39.0445 1504 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 14/11/2024 16:35:01.7287 6058 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 16:34:55' where payTraUID = 4674946643925220 and payStatus='V' and payEnabled=1 14/11/2024 16:35:02.8044 1074 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 16:34:55' where traUID = 4674946643925220 and traStatus='V' and traEnabled=1 14/11/2024 16:35:11.0389 768 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 14/11/2024 16:35:27.2207 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:35:32.3932 1843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:36:07.7188 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:36:09.4319 539 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 16:41:14.8640 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:41:23.8460 3083 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 16:42:03.2783 2810 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 16:42:00',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'; 14/11/2024 16:46:13.3864 812 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 16:46:13.4335 1675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:46:42.2207 628 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456085928900327001012999' 14/11/2024 16:46:48.7841 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:46:50.0730 1513 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 14/11/2024 16:46:50.8835 807 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 14/11/2024 16:47:08.5873 1274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:47:18.4199 5336 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/11/2024 16:47:42.9163 1945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:48:52.9641 1015 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:49:04.7940 5524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:49:08.9948 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:49:20.7226 1185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:49:25.2046 2094 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 16:49:29.4915 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:49:31.8160 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:50:05.4145 1994 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 16:50:03',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 14/11/2024 16:51:44.7288 573 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 16:51:45.4403 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:52:53.7119 1447 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 16:52:52',0,16,'2024-11-14 16:52:52','','Unauthorized Transit Entry 2') 14/11/2024 16:54:53.2938 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:58:34.0413 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 16:58:41.9336 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 16:59:18.4830 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:00:23.1772 1632 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 ('2024-11-14 17:00:19',0,'V',5404977007288100,4629694256665750,2024,'2024-11-14 17:00:19',3,1,0,4,'2024-11-14 17:15:19','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 14/11/2024 17:02:08.4716 1821 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 17:02:06' where payTraUID = 4629694256665750 and payStatus='V' and payEnabled=1 14/11/2024 17:02:12.7965 564 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 14/11/2024 17:02:22.1647 1011 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 17:02:22.2067 750 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 17:02:51.2882 535 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 ('2024-11-14 17:02:50',0,'V',5546782665099220,4685447537732640,2024,'2024-11-14 17:02:50',2,1,0,-1,'2024-11-14 18:02:50','S','KES',0,0,0,'','','',3,0,0) 14/11/2024 17:02:55.4389 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:08:38.9134 1575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:09:06.0676 852 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 17:09:05' where traUID = 4988019779616580 and traStatus='V' and traEnabled=1 14/11/2024 17:09:10.4035 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:09:41.1620 558 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 ('2024-11-14 17:09:40',0,'V',5320754385596980,5172084681993860,2024,'2024-11-14 17:09:40',2,1,0,-1,'2024-11-14 18:09:40','S','KES',0,0,0,'','','',3,0,0) 14/11/2024 17:13:57.4192 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:14:14.4976 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:15:21.2963 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:16:04.2039 702 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 17:17:18.1944 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:17:21.5596 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:17:27.5967 1377 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:17:31.7775 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:17:41.4479 1073 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:18:31.2482 1081 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,'2024-11-14 17:18:30','V',4986151806792340,2024,'2024-11-14 17:18:25','456085363400327005012999',2,2,2,'O','',0,'2024-11-14 17:18:30',1,'','',0) 14/11/2024 17:18:32.8022 964 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 17:18:31' where payTraUID = 4933693558626250 and payStatus='V' and payEnabled=1 14/11/2024 17:18:40.7355 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:18:48.5337 1339 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 17:19:07.3043 787 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:19:11.7042 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:20:00.5819 861 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/11/2024 17:20:00.7470 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:20:30.1857 1572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:21:20.5463 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:21:21.8612 3328 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 17:21:18' where payTraUID = 4788116643150390 and payStatus='V' and payEnabled=1 14/11/2024 17:21:28.5106 1172 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 14/11/2024 17:21:45.0827 951 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 17:22:17.4493 1313 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:24:11.3634 2051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:25:48.1401 1086 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-14 17:25:47' where subId = 32 14/11/2024 17:26:33.8586 1420 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:30:15.7799 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:30:27.1535 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:32:55.9870 796 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,'2024-11-14 17:32:55','V',4758923418191270,2024,'2024-11-14 17:32:54','456086317400327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 17:33:14.2441 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:33:30.4320 597 ms. EXEC: update payReceipt set recCreation = '2024-11-14 17:33:29',recModify = '2024-11-14 17:33:29',recUseId=0,recStatus='V' where recId = 322607 14/11/2024 17:33:38.1912 696 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 17:33:37','V',4701957493383650,2024,'2024-11-14 17:33:36','456086321600327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 17:34:47.2213 1501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:34:53.9227 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:36:10.3308 669 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 17:38:05.1785 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:40:28.9086 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:40:58.9987 1652 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 17:41:28.2772 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:47:20.8238 917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 17:52:51.9250 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:53:18.5028 528 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,'2024-11-14 17:53:17','V',5384480576785840,2024,'2024-11-14 17:53:16','456082772400327005012999',2,2,2,'O','',0,'2024-11-14 17:53:17',1,'','0230003950907',19,0) 14/11/2024 17:54:14.6783 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 17:54:34.7097 567 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 17:54:34' where payTraUID = 4641885772976430 and payStatus='V' and payEnabled=1 14/11/2024 17:54:35.5662 856 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 17:54:34' where traUID = 4641885772976430 and traStatus='V' and traEnabled=1 14/11/2024 17:58:16.6390 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:00:12.0150 707 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 156 14/11/2024 18:00:13.0617 627 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,'2024-11-14 18:00:12','V',5603657049007230,2024,'2024-11-14 18:00:09','456083263100327005012999',2,2,2,'O','',0,'2024-11-14 18:00:12',1,'','0230003939767',156,0) 14/11/2024 18:01:42.0392 1017 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:03:30.2085 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:03:43.3602 891 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 18:04:01.0991 598 ms. EXEC: update paycash set casCreation = '2024-11-14 18:04:00',casModify = '2024-11-14 18:04:00',casUseId=0,casStatus='V' where casId = 194929 14/11/2024 18:05:01.2023 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:06:47.9636 527 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/11/2024 18:06:49.0983 1661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:07:36.6321 949 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:07:41.6194 654 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 18:08:21.9794 1955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:09:46.2697 2042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:09:48.9735 574 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 14/11/2024 18:09:53.5396 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:10:12.1080 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:10:49.2878 1901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:14:37.5253 2898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:14:43.8265 1356 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 777433 14/11/2024 18:14:43.9906 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:14:48.8679 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:14:49.7985 886 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 18:15:30.4877 817 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 18:15:50.1869 1307 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 18:15:50.9013 712 ms. EXEC: update abbCards set carLastDate = '2024-11-14 18:15:50',carLastDirection='O' where carStatus='V' and carId = 25 14/11/2024 18:15:51.5027 524 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 18:15:55.8927 773 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:16:17.3610 555 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/11/2024 18:18:44.2642 548 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,'2024-11-14 18:18:43','V',5475918891270640,2024,'2024-11-14 18:18:42','456086592200327001012999',1,2,1,'I','',1,0,1,'','',4) 14/11/2024 18:19:50.7586 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:22:37.8963 652 ms. EXEC: update abbCards set carLastDate = '2024-11-14 18:22:37',carLastDirection='O' where carStatus='V' and carId = 14 14/11/2024 18:24:40.7373 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:25:24.3175 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:26:07.3732 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:26:30.2465 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:27:35.7973 4808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:28:00.9731 1073 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,'2024-11-14 18:27:59','V',5730467332937310,2024,'2024-11-14 18:27:59','456086647900327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 18:28:40.5035 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:28:52.0082 1703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:29:11.9385 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:30:22.7699 866 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 14/11/2024 18:32:38.7927 1851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:36:56.9592 594 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 18:38:46.5334 1040 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:41:26.8566 778 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 18:45:29.9700 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:48:11.9252 1197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:49:10.3502 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:49:26.4630 694 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,'2024-11-14 18:49:25','V',4814796021120370,2024,'2024-11-14 18:49:21','456086776100327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 18:49:38.2399 1362 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:50:04.8356 1167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 18:55:07.1336 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:55:14.2444 515 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 18:59:36.6957 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 18:59:38.0696 1343 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 19:02:08.5352 1078 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 14/11/2024 19:03:32.1791 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 19:09:04.3650 931 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 371253 else acvFstPayId end),acvLstPayId = 371253 where acvSftId = 818 and acvCodeId = 3 14/11/2024 19:11:24.4566 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 19:16:51.9224 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 19:18:04.0776 1095 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 14/11/2024 19:18:07.1226 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 19:18:08.4175 1092 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,'2024-11-14 19:18:07','V',4846900260794700,2024,'2024-11-14 19:18:06','456086948600327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 19:18:08.9639 542 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 19:20:05.8370 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 19:20:25.9665 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 19:24:21.0005 651 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5441548777637840,4713892389784990,2024,'2024-11-14 19:24:20',' Date: 11/14/2024 7:21:39 PM Code: 456086838100327005012999 Entry Date: 11/14/2024 6:59:41 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416146 ',0) 14/11/2024 19:25:03.7070 2249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 19:25:50.8325 1090 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 19:26:53.3953 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 19:31:18.8597 667 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,'2024-11-14 19:31:18','V',5487040646669240,2024,'2024-11-14 19:31:17','456087027700327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 19:32:22.8584 573 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 371261 else acvFstPayId end),acvLstPayId = 371261 where acvSftId = 825 and acvCodeId = 3 14/11/2024 19:32:23.6820 802 ms. EXECSCALAR: select terAddress from tabTerminal where terId = 16 nr: 5 14/11/2024 19:34:07.7845 596 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 19:35:19.8827 1540 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191338' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 14/11/2024 19:35:23.1569 1344 ms. EXEC: update abbCards set carLastDate = '2024-11-14 19:35:21',carLastDirection='I' where carStatus='V' and carId = 44 14/11/2024 19:35:28.6056 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 19:45:11.8382 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 19:46:28.1242 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 19:47:37.5316 528 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,'2024-11-14 19:47:37','V',5594687022466480,2024,'2024-11-14 19:47:36','456087027700327005012999',2,2,2,'O','',0,'2024-11-14 19:47:37',1,'','',0) 14/11/2024 19:47:38.3981 743 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 19:48:35.7765 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 19:49:13.9300 1852 ms. EXECSCALAR: select count(*) from tabTerminalReceipt where trcStatus='V' and trcTerId = 3 and trcProgressive<>0 nr: 0 14/11/2024 19:50:45.1729 699 ms. EXEC: update paycash set casCreation = '2024-11-14 19:50:44',casModify = '2024-11-14 19:50:44',casUseId=0,casStatus='V' where casId = 194939 14/11/2024 19:51:01.5439 1250 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 72 ms.) 14/11/2024 19:51:41.9149 806 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-14 19:51:41','V',4964259660428900,2024,'2024-11-14 19:51:40','456086829800327001012999',2,2,2,'O','',0,'2024-11-14 19:51:41',1,'','',0) 14/11/2024 19:51:48.3942 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 19:52:00.1861 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 19:52:34.0297 782 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 19:52:36.2832 1960 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 19:52:34' where traUID = 5605342491153470 and traStatus='V' and traEnabled=1 14/11/2024 19:52:39.7105 607 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 19:53:44.6298 914 ms. EXEC: update payReceipt set recCreation = '2024-11-14 19:53:43',recModify = '2024-11-14 19:53:43',recUseId=0,recStatus='V' where recId = 322643 14/11/2024 19:53:46.4381 1724 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-14 19:53:44',0,0,'V',5639633406575270,5113793174176600,2024,'2024-11-14 19:53:44',3,'KES',1,200,200,'N',''); (WAIT TIME 55 ms.) 14/11/2024 19:54:28.6312 1009 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 19:56:10.8996 938 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,'2024-11-14 19:56:09','V',5665963195487520,2024,'2024-11-14 19:56:07','456086378700327005012999',2,2,2,'O','',0,'2024-11-14 19:56:09',1,'','',0) 14/11/2024 20:00:17.2702 726 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 20:01:22.1115 1175 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 20:05:40.4311 917 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 20:05:39',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/11/2024 20:05:45.2993 636 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 14/11/2024 20:06:58.4692 640 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 20:07:15.9599 1102 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 20:10:10.1883 610 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-14 20:10:09',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 14/11/2024 20:10:10.1963 791 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:10:19.0462 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:11:58.6798 543 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 14/11/2024 20:13:18.0809 958 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,'2024-11-14 20:13:17','V',5561532617602490,2024,'2024-11-14 20:13:16','456087279600327005012999',1,2,16,'I','',1,0,1,'','',4) 14/11/2024 20:16:27.5975 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:16:28.1479 623 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 14/11/2024 20:16:31.3930 655 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 ('2024-11-14 20:14:20',1,'V',4852044700938410,5640297901523020,2024,'2024-11-14 20:14:20',17,1,0,4,'2024-11-14 20:29:20','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/11/2024 20:16:33.3053 1026 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5640297901523020,4852044700938410,2024,'2024-11-14 20:16:32',' Data: 11/14/2024 8:14:20 PM Codice: 456086486400327005012999 Ingresso: 11/14/2024 6:01:04 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 # 2400607157 ',0) 14/11/2024 20:17:02.8330 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:17:03.9948 3748 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 20:17:04.3761 676 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 ('2024-11-14 20:14:53',1,'V',5030352263616390,5376668828630430,2024,'2024-11-14 20:14:53',17,1,0,4,'2024-11-14 20:29:53','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/11/2024 20:17:05.2216 776 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456086671400327005012999' 14/11/2024 20:17:09.6656 1096 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 14/11/2024 20:17:12.7707 1330 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:17:18.6116 536 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 20:17:18',0,16,'2024-11-14 20:17:18','','Unauthorized Transit Entry 2') 14/11/2024 20:17:18.6606 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:17:46.4422 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:18:09.3915 791 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-14 20:18:08' where payTraUID = 5640297901523020 and payStatus='V' and payEnabled=1 14/11/2024 20:18:17.5980 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:18:18.2544 1096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:21:42.5399 724 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 20:21:43.0563 514 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/11/2024 20:22:37.4956 2158 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:23:13.5187 783 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7159, trcLastPrinted = '2400607159', trcLastDate = '2024-11-14 20:23:12' where trcStatus='V' and trcTerId = 17 14/11/2024 20:23:23.3443 2150 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:24:49.9331 2321 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:24:58.2106 1513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:26:00.6744 890 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 14/11/2024 20:26:45.4883 835 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49673, trcLastPrinted = '2400749673', trcLastDate = '2024-11-14 20:26:44' where trcStatus='V' and trcTerId = 18 14/11/2024 20:26:58.4580 717 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 14/11/2024 20:26:59.9280 2061 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 20:27:00.5754 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:27:35.6178 1110 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 ('2024-11-14 20:27:34',0,'V',4848779050932070,4858092036254530,2024,'2024-11-14 20:27:34',18,1,0,4,'2024-11-14 20:42:34','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/11/2024 20:29:49.0109 671 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 14/11/2024 20:31:00.2605 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:35:15.5611 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:35:15.6342 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:35:38.0852 2616 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 ('2024-11-14 20:32:55',6,'V',5036241588465380,5662267471661730,2024,'2024-11-14 20:32:55',4,1,0,4,'2024-11-14 20:47:55','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 14/11/2024 20:37:04.4229 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:43:24.2166 1083 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:44:00.7830 1185 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 20:44:04.2113 1256 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:45:13.3785 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:45:27.4259 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:45:29.5433 569 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 20:46:04.8609 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 20:47:00.0498 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:48:44.2314 761 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 20:52:29.3288 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:52:54.1194 1055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:53:18.1084 2645 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,'2024-11-14 20:53:15','V',5402311561574960,2024,'2024-11-14 20:53:13','456087385400327005012999',2,2,2,'O','',0,'2024-11-14 20:53:15',1,'','',0) 14/11/2024 20:53:36.4631 512 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 14/11/2024 20:55:16.5990 1054 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:56:02.4907 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:56:11.5037 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:56:15.7135 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 20:58:47.9222 649 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 14/11/2024 21:07:06.3912 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:09:44.1036 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:12:43.0652 2066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:15:08.9647 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:15:31.6458 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 21:15:31.9390 804 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 ('2024-11-14 21:15:30',0,'V',5002137403828120,4985746157227470,2024,'2024-11-14 21:15:30',18,1,0,4,'2024-11-14 21:30:30','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 14/11/2024 21:21:49.1500 834 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 21:22:04.7024 510 ms. EXEC: update paycash set casCreation = '2024-11-14 21:22:04',casModify = '2024-11-14 21:22:04',casUseId=0,casStatus='V' where casId = 194953 14/11/2024 21:25:17.8094 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:25:18.1787 934 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 21:25:23.0720 524 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 21:28:07.6059 519 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-14 21:28:07',17,1,'2024-11-14 21:28:07','456086948600327005012999','Pagato (Contanti ) Biglietto ') 14/11/2024 21:28:27.8554 839 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4926648782239350,5674933894974380,2024,'2024-11-14 21:28:27',' Data: 11/14/2024 9:26:16 PM Codice: 456086947000327005012999 Ingresso: 11/14/2024 7:17:50 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 # 2400607164 ',0) 14/11/2024 21:28:50.2114 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:29:14.3245 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:29:31.1187 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 21:29:56.9630 735 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 14/11/2024 21:30:33.2442 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:30:42.3483 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:37:01.3065 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 21:38:40.5638 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:43:33.1703 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:44:11.1126 533 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/11/2024 21:48:01.4616 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 21:48:07.8448 568 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 21:50:34.9051 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 21:50:35.5025 551 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 14/11/2024 21:52:54.7835 991 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 14/11/2024 21:54:09.1802 1204 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:54:35.7980 1646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:55:42.8598 571 ms. EXEC: update payReceipt set recCreation = '2024-11-14 21:55:42',recModify = '2024-11-14 21:55:42',recUseId=0,recStatus='V' where recId = 322679 14/11/2024 21:55:44.8361 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 21:55:44.9312 1919 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-14 21:55:42',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 14/11/2024 21:58:11.5712 821 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 21:58:25.0652 820 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:01:27.9374 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:01:56.7707 1271 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 22:04:25.2178 1527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:04:34.0217 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:10:15.6830 1974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:11:55.7388 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:14:46.3138 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:15:40.4640 744 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 14/11/2024 22:17:32.1456 1091 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:18:26.3939 1113 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:18:29.6650 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:19:08.7522 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:19:38.9173 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:23:22.8829 1149 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:25:04.1256 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:25:04.6499 641 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 14/11/2024 22:25:46.9932 827 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 14/11/2024 22:25:53.4145 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:29:06.4085 674 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:29:20.0186 520 ms. OPEN: show columns from movAnomaly where Field = 'anmAmountProgressive' 14/11/2024 22:29:24.1783 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:29:24.8338 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:29:46.5033 1298 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:29:53.6680 599 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 22:29:53.6690 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:30:34.7575 556 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 14/11/2024 22:36:34.8901 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:39:36.7476 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:40:26.7650 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:42:55.7356 612 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 14/11/2024 22:44:03.6069 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:44:45.2067 1193 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:44:57.5880 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:49:41.7668 809 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 22:51:34.7053 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:51:40.7924 3748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 22:54:45.9361 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:00:06.9776 1949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:03:06.2293 685 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 14/11/2024 23:03:45.6857 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:10:29.6166 2298 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:10:36.8774 1598 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,'2024-11-14 23:10:35','V',5142431562590230,2024,'2024-11-14 23:10:33','456088343300327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 14/11/2024 23:10:41.4445 851 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 23:15:11.9712 522 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-14 23:15:11' where traUID = 5384884199557480 and traStatus='V' and traEnabled=1 14/11/2024 23:15:16.9305 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 23:18:21.4648 664 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 14/11/2024 23:20:23.7005 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:25:19.9284 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:27:16.7075 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 23:37:24.9318 1316 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:38:37.9436 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/11/2024 23:39:02.6081 2047 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 14/11/2024 23:44:22.0595 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:45:37.2348 972 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:53:43.6427 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 14/11/2024 23:56:42.5172 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1