13/11/2024 00:00:30.2211 940 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:08:09.7972 514 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/11/2024 00:15:48.2687 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:16:32.5321 607 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/11/2024 00:17:06.2676 1415 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/11/2024 00:21:46.4573 2010 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 00:22:42.2564 1156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:23:57.7717 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:25:13.4421 1982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:26:54.0962 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:29:13.7802 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:30:02.4837 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:31:19.9723 546 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 00:31:43.2858 753 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 00:31:43.2868 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:31:45.1911 1572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:32:15.7495 831 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 00:32:15.7505 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:33:14.6757 4286 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:34:24.2060 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:35:42.7994 944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:36:32.1433 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:36:56.2373 957 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 00:38:01.4908 3145 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/11/2024 00:38:52.5048 2667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:08.3013 1436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:11.5284 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:16.6478 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:21.9624 1464 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:25.0885 1514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:35.0921 4820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:42.8553 1467 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:46.0264 1182 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:39:57.3600 628 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 00:40:20.5744 1253 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 00:43:06.8292 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:46:26.0269 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:47:05.3431 3044 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:48:26.0498 621 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 00:58:43.1959 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:58:44.3347 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:59:00.0282 1473 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 00:59:57.5885 1659 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 01:00:30.4264 1785 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 01:02:44.4316 2154 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:03:30.9826 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:04:33.3892 2454 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:04:42.2902 2839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:05:04.2248 2424 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:05:06.6374 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:05:10.6941 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:05:17.3265 1028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:05:23.8468 2394 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:05:25.3829 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:06:01.2167 581 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 01:07:14.8288 1620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:08:16.0966 2074 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 13/11/2024 01:08:48.5712 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:10:27.0928 2175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:11:32.5735 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:11:54.4640 1514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:12:33.8743 1193 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 01:14:54.2678 2560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:17:07.5576 608 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 01:26:58.0370 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:33:11.6198 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:37:34.3128 2194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:40:11.8458 503 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 01:41:44.7516 644 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 01:43:10.2286 1132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:43:49.7419 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:48:35.0380 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:49:53.0149 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:50:58.7027 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:53:09.6539 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 01:54:36.3737 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:02:33.0482 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:02:51.3764 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:04:50.5278 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:13:45.9494 1088 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:14:25.3817 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:14:28.3007 2562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:16:07.3767 1676 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 13/11/2024 02:21:54.1116 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:26:54.5948 803 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 02:27:21.8410 1121 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 02:28:36.4687 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:29:38.8943 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:33:25.6643 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:41:00.7084 1347 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/11/2024 02:47:14.1172 1845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:51:17.6914 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:57:24.7620 783 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 02:57:38.3620 1800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:58:45.1885 1029 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 02:59:31.6405 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:15:08.7297 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:16:20.0703 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:22:29.9627 1577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:26:17.8275 2522 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 03:29:37.4004 2122 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:30:23.0858 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:33:05.3739 1871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:33:22.1711 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:39:00.0782 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:46:54.7905 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:48:30.2871 2106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:53:01.2296 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:53:35.5494 1432 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:53:42.0698 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:54:44.9577 2815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:54:44.9617 1746 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 03:55:36.1538 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:56:04.0614 953 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/11/2024 03:56:23.7625 1112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 03:59:07.5016 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:01:18.3077 1240 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 04:01:23.5812 596 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 13/11/2024 04:01:25.3944 1027 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 04:01:24' where traUID = 4643280208366840 and traStatus='V' and traEnabled=1 13/11/2024 04:01:30.3327 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 04:01:30.5498 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:01:31.4675 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:01:31.7897 1041 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 04:02:36.3827 536 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/11/2024 04:03:58.2873 614 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 04:03:58.2873 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:04:45.9430 2254 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 13/11/2024 04:05:10.6124 1660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:05:21.2585 2160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:05:39.4587 1178 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:07:11.9883 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:09:02.6330 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:09:24.7067 1095 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:12:14.2416 754 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 04:12:27.5945 1058 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 04:16:55.5650 1848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:17:01.2808 937 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:17:23.9790 1378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:17:31.8952 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:17:34.0347 1327 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:17:45.6724 773 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456071546300327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 13/11/2024 04:22:01.2056 755 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 04:25:20.1632 2241 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:27:04.4837 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:28:22.5987 533 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 04:28:29.7034 1139 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:31:16.7837 3253 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:31:34.5536 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:32:35.0038 1978 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:32:50.5242 4666 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 04:35:06.8040 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:35:18.4797 974 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 04:35:23.8603 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:46:44.7879 1040 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 04:51:07.6701 873 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 04:52:47.0643 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:00:01.7208 1364 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:10:13.4803 632 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 05:11:55.2391 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:13:33.5166 1205 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:14:59.9842 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:17:18.4834 574 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 05:17:18.4855 572 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/11/2024 05:17:48.9618 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:20:08.8790 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:21:09.0590 1174 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 13/11/2024 05:21:09.1471 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:23:22.3979 1427 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:27:21.6132 942 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 05:27:42.9174 1185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:27:44.8957 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:27:44.8967 521 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/11/2024 05:28:30.8924 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:30:45.0147 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:31:55.7769 1616 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 05:33:52.8208 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:34:44.5293 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:35:24.4509 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:39:10.4914 1671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:40:52.7165 2267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:40:56.9073 1703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:41:01.5094 965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:41:18.0074 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:41:26.2139 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:44:51.5937 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:47:24.7927 1425 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:47:47.1406 2609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:50:04.1519 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:50:56.8650 2914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:55:30.4592 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:57:47.1163 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:58:10.6530 3266 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:58:54.9515 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 05:59:05.4915 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:03:50.6554 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:04:46.9810 1681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:06:54.3838 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:07:42.0586 1848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:12:04.9217 944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:13:09.7119 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:16:40.5543 864 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 06:24:45.7505 922 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/11/2024 06:26:26.2975 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:26:27.2842 979 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/11/2024 06:28:05.6907 1252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:30:12.6093 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 06:30:36.7353 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:31:02.9788 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:32:47.3163 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:33:14.9027 876 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 06:36:09.9583 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 06:37:15.4910 988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:38:25.1544 995 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/11/2024 06:40:05.4072 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 06:51:03.8378 1250 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:00:28.9792 1325 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-13 07:00:27','V',5189084738129180,2024,'2024-11-13 07:00:26','456072382000327005012999',2,2,2,'O','',0,'2024-11-13 07:00:27',1,'','',0) 13/11/2024 07:06:26.9497 1555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:07:53.4083 1164 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:09:49.9399 1642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:14:05.5102 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:14:21.8481 1249 ms. OPEN: select payClosePeriod from paypayment inner join movtransit on paypayment.payTraUID=movtransit.traUID where movtransit.traStatus='V' AND traCode=@traCode and paypayment.payStatus='V' and paypayment.payClosePeriod is not null order by paypayment.payClosePeriod desc limit 1 13/11/2024 07:14:41.2030 677 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 07:14:40',0,16,'2024-11-13 07:14:40','','Unauthorized Transit Entry 2') 13/11/2024 07:17:06.3977 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:20:29.2308 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:22:38.3488 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:22:50.2988 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:23:42.3955 1373 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 370603 else acvFstPayId end),acvLstPayId = 370603 where acvSftId = 824 and acvCodeId = 3 13/11/2024 07:23:44.2307 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:24:13.3401 1635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:26:02.2967 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 07:26:28.2860 804 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-13 07:26:27','V',5561477624227840,2024,'2024-11-13 07:26:24','456072678400327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 07:28:44.4857 516 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 07:30:22.0387 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:35:04.1096 942 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-13 07:35:03','V',4773502829471600,2024,'2024-11-13 07:35:02','456072730200327005012999',1,2,16,'I','',1,0,1,'','0560008336057',179,0) 13/11/2024 07:35:10.5929 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 07:37:18.8824 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:38:29.6645 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:43:01.8398 870 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-13 07:43:00','V',4883324216809520,2024,'2024-11-13 07:43:00','456072778000327005012999',1,2,16,'I','',1,0,1,'','0230003957466',21,0) 13/11/2024 07:43:14.5133 609 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 07:43:57.5439 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:45:02.8645 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:46:34.9928 639 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 07:50:01.4624 1739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:55:06.0182 661 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 07:57:52.2450 761 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 07:57:53.4458 1030 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 07:58:17.7740 1404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:58:47.6439 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 07:58:59.7630 1137 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 07:59:45.8847 3255 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-13 07:59:41',0,'V',5551909987738960,5349905488370830,2024,'2024-11-13 07:59:41',3,1,0,4,'2024-11-13 08:14:41','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 13/11/2024 07:59:48.4714 1044 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 07:59:46',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-13 07:59:46',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/11/2024 07:59:56.6188 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 08:03:20.7388 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:06:29.9268 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:07:44.7467 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:10:30.5491 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 08:10:41.2192 550 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 08:12:31.6648 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:12:48.9643 849 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-13 08:10:29',9,'V',5424167855489220,4990333699139420,2024,'2024-11-13 08:10:29',4,1,0,4,'2024-11-13 08:25:29','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 13/11/2024 08:13:46.6337 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 08:17:10.2063 1312 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 08:23:40.4683 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:26:59.8551 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:29:49.2540 2725 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-13 07:29:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-13 08:29:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-13 08:29:46' and (resAreId = 1 or resAreId <= 0) nr: 0 13/11/2024 08:29:49.4411 1349 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:30:31.7693 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:34:26.3686 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 08:38:13.5469 959 ms. OPEN: SELECT * FROM tabTerminalExtraMem WHERE extStatus=@extStatus AND extTerId = @extTerId 13/11/2024 08:38:21.2931 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 08:39:31.7460 2420 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:39:57.5442 865 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 08:45:46.6147 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:49:42.9742 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 08:53:04.4404 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:00:01.2701 1333 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/11/2024 09:00:01.3361 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:00:11.9162 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:02:19.4871 1053 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-13 09:02:18','V',5393955318198630,2024,'2024-11-13 09:02:16','456073253600327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 09:05:27.0201 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:07:08.7308 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:07:38.5187 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:11:31.8961 880 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:11:32.9438 1021 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 13/11/2024 09:12:24.2490 1106 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:13:59.1502 697 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 09:13:58' where traUID = 4906583151795150 and traStatus='V' and traEnabled=1 13/11/2024 09:14:03.9474 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:18:04.0534 912 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:18:05.5253 752 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 09:18:04',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 13/11/2024 09:18:09.5190 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:19:15.7231 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:19:57.8712 791 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 09:20:19.9499 696 ms. OPEN: select * from movExtraRules where exrTraId in (select traId from movtransit where traCode = '456073049600327005012999') 13/11/2024 09:20:27.3748 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:21:31.8438 504 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 13/11/2024 09:21:32.9045 689 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:24:19.9147 906 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 09:25:02.0438 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:25:23.9094 1853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:25:43.6795 1254 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:26:14.9644 803 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:26:31.5805 740 ms. EXEC: update payInventory set invCreation = '2024-11-13 09:26:30',invModify = '2024-11-13 09:26:30',invUseId=0,invStatus='V' where invId = 218934 13/11/2024 09:26:55.1912 1347 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:27:21.0714 833 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-13 09:27:20','V',4868743212690060,2024,'2024-11-13 09:27:18','456073315700327005012999',2,2,2,'O','',0,'2024-11-13 09:27:20',1,'','',0) 13/11/2024 09:27:23.8263 2521 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 09:27:21' where traUID = 5061530792791480 and traStatus='V' and traEnabled=1 13/11/2024 09:29:38.9112 546 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/11/2024 09:30:16.9586 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:31:06.7127 1257 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 09:31:12.4556 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:35:22.0218 569 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 13/11/2024 09:35:34.8754 607 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 09:35:51.0892 592 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 09:35:50',3,42101,0,500,1,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 13/11/2024 09:35:56.4167 655 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-13 09:35:55','V',5280624507391970,2024,'2024-11-13 09:35:55','456073011900327005012999',2,2,2,'O','',0,'2024-11-13 09:35:55',1,'','',0) 13/11/2024 09:36:54.2823 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:37:48.9097 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:39:19.2428 573 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 13/11/2024 09:39:19.4940 921 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:39:47.2255 1105 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 09:42:20.0923 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:43:17.6436 834 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 09:43:16',0,3,'2024-11-13 09:43:16','0230003944086','POF - User Transit Supervisor Supervisor') 13/11/2024 09:44:38.7517 712 ms. EXEC: update payReceipt set recCreation = '2024-11-13 09:44:38',recModify = '2024-11-13 09:44:38',recUseId=0,recStatus='V' where recId = 322128 13/11/2024 09:45:38.2883 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:49:09.4910 917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:49:15.6161 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:49:43.3296 1340 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 09:49:52.8509 1731 ms. EXEC: update payReceipt set recCreation = '2024-11-13 09:49:51',recModify = '2024-11-13 09:49:51',recUseId=0,recStatus='V' where recId = 322129 13/11/2024 09:50:29.9556 1128 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,50,-11,-550,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,50,11,550,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,100,-28,-2800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,100,28,2800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,200,-3,-600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,200,3,600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 09:50:16',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 13/11/2024 09:52:27.1757 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 09:55:02.1680 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:55:11.7073 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 09:59:20.8773 585 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-13 09:57:02',9,'V',5402567467140960,5214521642213260,2024,'2024-11-13 09:57:02',4,1,0,4,'2024-11-13 10:12:02','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 09:59:22.3513 610 ms. EXEC: update payReceipt set recCreation = '2024-11-13 09:59:21',recModify = '2024-11-13 09:59:21',recUseId=0,recStatus='V' where recId = 322131 13/11/2024 09:59:35.7482 529 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16064, trcLastPrinted = '2400416064', trcLastDate = '2024-11-13 09:59:35' where trcStatus='V' and trcTerId = 4 13/11/2024 10:00:36.6098 790 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 10:00:35' where traUID = 5443037075321410 and traStatus='V' and traEnabled=1 13/11/2024 10:01:13.6334 762 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 10:03:41.0776 1668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:05:07.3651 1413 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:08:37.2689 1081 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 10:10:42.9316 705 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/11/2024 10:10:52.0437 1092 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/11/2024 10:10:58.4560 707 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-13 10:10:57','V',5532719004172340,2024,'2024-11-13 10:10:57','456073365900327005012999',2,2,2,'O','',0,'2024-11-13 10:10:57',1,'','',0) 13/11/2024 10:11:29.6578 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:13:02.0573 800 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 13/11/2024 10:14:25.9672 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:14:40.9862 2404 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-13 10:12:21',9,'V',4937736382299760,4985999787251800,2024,'2024-11-13 10:12:21',4,1,0,4,'2024-11-13 10:27:21','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 10:14:41.8638 513 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4985999787251800,4937736382299760,2024,'2024-11-13 10:14:41',' Date: 11/13/2024 10:12:21 AM Code: 456073607100327005012999 Entry Date: 11/13/2024 10:01:11 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416065 ',0) 13/11/2024 10:14:43.0226 1158 ms. EXEC: update payReceipt set recCreation = '2024-11-13 10:14:41',recModify = '2024-11-13 10:14:41',recUseId=0,recStatus='V' where recId = 322136 13/11/2024 10:15:09.8515 521 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 10:15:09' where traUID = 5286525229886540 and traStatus='V' and traEnabled=1 13/11/2024 10:15:42.1170 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:16:08.5075 585 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-50,5),subLastDebit = '2024-11-13 10:16:07' where subId = 118 13/11/2024 10:16:15.3111 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:16:16.9251 830 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-13 10:16:16','V',5579630841513630,2024,'2024-11-13 10:16:11','456073697100327005012999',1,2,16,'I','',1,0,1,'','0230004101223',11,0) 13/11/2024 10:16:31.9852 1995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:16:45.5672 1145 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/11/2024 10:17:36.1409 1228 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 10:19:25.5138 802 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/11/2024 10:20:15.4150 772 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 10:20:25.6758 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:22:12.4109 939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:22:14.4113 589 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 10:22:51.3389 1836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:22:59.3892 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:23:23.6114 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:24:03.9783 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:25:34.6447 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:25:54.6180 941 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:28:00.4318 610 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 370644 else acvFstPayId end),acvLstPayId = 370644 where acvSftId = 824 and acvCodeId = 3 13/11/2024 10:28:57.6289 1348 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:29:24.2476 605 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 10:30:37.1642 1948 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-13 09:30:35') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-13 10:30:35' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-13 10:30:35' and (resAreId = 1 or resAreId <= 0) nr: 0 13/11/2024 10:30:41.3129 1531 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16067, trcLastPrinted = '2400416067', trcLastDate = '2024-11-13 10:30:39' where trcStatus='V' and trcTerId = 4 13/11/2024 10:31:19.6865 554 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 10:31:19',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 13/11/2024 10:31:20.3099 623 ms. EXEC: update payInventory set invCreation = '2024-11-13 10:31:19',invModify = '2024-11-13 10:31:19',invUseId=0,invStatus='V' where invId = 218967 13/11/2024 10:33:43.4103 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:33:47.5220 4466 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 88 order by traDateTime desc,traId desc 13/11/2024 10:34:18.7908 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:35:14.0646 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:35:24.7608 776 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 10:35:23',4,9,'2024-11-13 10:35:23','456073540100327005012999','Payed (Credit Card ) Ticket ') 13/11/2024 10:35:30.7868 2030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:35:58.3091 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:38:45.5045 2785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:42:20.0454 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:42:58.0938 830 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-13 10:42:57','V',5041789732611230,2024,'2024-11-13 10:42:55','456073718300327005012999',2,2,2,'O','',0,'2024-11-13 10:42:57',1,'','',0) 13/11/2024 10:43:00.4583 1237 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 10:42:58' where traUID = 5453167029735280 and traStatus='V' and traEnabled=1 13/11/2024 10:43:20.4466 576 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 10:43:19' where traUID = 4870590832646620 and traStatus='V' and traEnabled=1 13/11/2024 10:43:27.0170 2083 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:43:33.0771 602 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 10:44:37.8942 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:44:41.5026 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:44:44.0183 1882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:46:22.4779 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:46:58.2597 3401 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:49:21.4071 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:51:05.4194 571 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/11/2024 10:51:15.4150 896 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:51:45.4000 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:53:27.6892 655 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/11/2024 10:53:50.5014 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:54:17.7505 512 ms. EXEC: update paycash set casCreation = '2024-11-13 10:54:17',casModify = '2024-11-13 10:54:17',casUseId=0,casStatus='V' where casId = 194672 13/11/2024 10:54:26.6995 539 ms. EXEC: update abbCards set carLastDate = '2024-11-13 10:54:26',carLastDirection='I' where carStatus='V' and carId = 29 13/11/2024 10:54:33.2628 813 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 10:57:33.8662 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 10:58:01.2414 1069 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-13 10:58:00','V',5554221122811030,2024,'2024-11-13 10:57:59','456073642700327005012999',2,2,2,'O','',0,'2024-11-13 10:58:00',1,'','',0) 13/11/2024 11:00:00.7670 2453 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 11:01:53.3440 792 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:05:08.5250 3687 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 11:07:24.9139 582 ms. EXEC: update abbCards set carLastDate = '2024-11-13 11:07:24',carLastDirection='O' where carStatus='V' and carId = 29 13/11/2024 11:07:42.5496 929 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:08:38.0506 730 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 11:09:34.8885 1375 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:09:34.8895 1243 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 11:09:55.7934 1152 ms. EXEC: update payReceipt set recCreation = '2024-11-13 11:09:54',recModify = '2024-11-13 11:09:54',recUseId=0,recStatus='V' where recId = 322153 13/11/2024 11:10:38.2327 1114 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:12:03.0842 619 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '776295' and traDirection='I' order by traId DESC LIMIT 1 13/11/2024 11:12:03.9578 1500 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 11:13:18.9667 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:13:32.5738 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:14:08.7729 2382 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-13 11:14:06','V',4963134005212220,2024,'2024-11-13 11:14:05','456073716400327005012999',2,2,2,'O','',0,'2024-11-13 11:14:06',1,'','',0) 13/11/2024 11:14:08.7749 2799 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-13 11:14:04',0,'V',5118470009967680,4745411420619520,2024,'2024-11-13 11:14:04',3,1,0,4,'2024-11-13 11:29:04','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 13/11/2024 11:14:09.5444 664 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/11/2024 11:14:09.5644 694 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4745411420619520,5118470009967680,2024,'2024-11-13 11:14:08','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/13/2024 10:50:04 AM Date : 11/13/2024 11:14:04 AM Code : 456073900400327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 50.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 13/11/2024 11:14:10.7762 565 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 11:14:09',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/11/2024 11:14:19.0538 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:15:23.9830 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:15:48.3002 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:16:13.5700 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:16:49.6721 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:17:33.1621 773 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 370666 else acvFstPayId end),acvLstPayId = 370666 where acvSftId = 824 and acvCodeId = 3 13/11/2024 11:17:34.0907 669 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4871042718178760,5060178639936720,2024,'2024-11-13 11:17:33',' Date: 11/13/2024 11:15:12 AM Code: 456073478400327005012999 Entry Date: 11/13/2024 9:39:44 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416073 ',0) 13/11/2024 11:25:34.6598 733 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 13/11/2024 11:25:34.9490 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:25:35.3853 725 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 11:27:36.2608 1441 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/11/2024 11:27:36.9493 685 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 11:27:36' where payTraUID = 4686633368588590 and payStatus='V' and payEnabled=1 13/11/2024 11:28:59.7054 672 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 11:29:07.3945 2288 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:30:34.2124 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:31:50.7914 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:32:32.3070 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:33:16.0932 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:35:26.5421 504 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 11:37:51.4746 507 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-13 11:35:42',1,'V',5739141963746760,4727294073150340,2024,'2024-11-13 11:35:42',17,1,0,4,'2024-11-13 11:50:42','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 11:37:52.2331 702 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 11:37:51',17,1,'2024-11-13 11:37:51','456073960200327005012999','Pagato (Contanti ) Biglietto ') 13/11/2024 11:39:53.7271 787 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 13/11/2024 11:39:54.1093 606 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/11/2024 11:40:05.5760 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:40:11.5980 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:40:12.3395 712 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/11/2024 11:42:15.9148 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:46:09.6695 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:46:32.9350 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 11:48:20.9300 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:49:28.4109 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 11:52:26.9208 578 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 11:52:25' where traUID = 5644261663819730 and traStatus='V' and traEnabled=1 13/11/2024 11:52:33.8775 568 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 11:52:33',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'; 13/11/2024 11:52:48.4642 2335 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-13 11:50:36',1,'V',5397427660131850,5691640748147080,2024,'2024-11-13 11:50:36',17,1,0,4,'2024-11-13 12:05:36','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 11:52:49.3037 618 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 370680 else acvFstPayId end),acvLstPayId = 370680 where acvSftId = 825 and acvCodeId = 3 13/11/2024 11:56:26.9737 1545 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 11:56:25' where traUID = 4883435921212550 and traStatus='V' and traEnabled=1 13/11/2024 11:56:37.2376 605 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 11:58:13.9730 583 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-13 11:58:13','V',5551492492423020,2024,'2024-11-13 11:58:11','456074309100327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 11:58:15.3569 1195 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 11:58:26.8036 790 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 11:59:13.7458 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:01:07.6867 656 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:01:30.6120 1786 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-13 12:01:28','V',5019670861688620,2024,'2024-11-13 12:01:27','456074168200327005012999',2,2,2,'O','',0,'2024-11-13 12:01:28',1,'','',0) 13/11/2024 12:01:31.5446 531 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 12:01:31' where payTraUID = 4869246625081030 and payStatus='V' and payEnabled=1 13/11/2024 12:01:36.5940 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:01:37.6927 1340 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 13/11/2024 12:02:05.2561 1396 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:02:05.4952 1391 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 12:02:19.4776 3123 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5462729592206290,5754920398773120,2024,'2024-11-13 12:02:16','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/13/2024 11:41:44 AM Date : 11/13/2024 12:02:14 PM Code : 456074210400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 13/11/2024 12:02:54.5179 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:03:22.7337 716 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:03:22.8588 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:05:00.5128 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:05:36.7910 578 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-13 12:05:36','V',5308654375452720,2024,'2024-11-13 12:05:35','456074210400327005012999',2,2,2,'O','',0,'2024-11-13 12:05:36',1,'','',0) 13/11/2024 12:05:43.4794 835 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:05:47.5702 1454 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-13 12:05:46','V',4956659466119580,2024,'2024-11-13 12:05:44','456074354400327005012999',1,2,16,'I','',1,0,1,'','0230004098545',159,0) 13/11/2024 12:05:48.2066 566 ms. EXEC: update abbCards set carLastDate = '2024-11-13 12:05:47',carLastDirection='I' where carStatus='V' and carId = 159 13/11/2024 12:05:57.8860 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:06:47.6242 1973 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:06:57.5568 933 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-13 12:06:56',0,'V',4919634679829210,5620463342111620,2024,'2024-11-13 12:06:56',18,1,0,4,'2024-11-13 12:21:56','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 12:07:31.7366 2213 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:07:48.4967 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:08:15.7429 938 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 12:09:34.2812 611 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-13 12:09:32',0,'V',5134175336122270,4799695644276250,2024,'2024-11-13 12:09:32',3,1,0,4,'2024-11-13 12:24:32','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 13/11/2024 12:10:07.2662 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:10:53.8382 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:11:11.8812 617 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/11/2024 12:11:24.7358 2058 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 12:11:25.9426 1214 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:11:26.0006 1210 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 12:12:40.4422 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:12:56.8021 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:12:57.0323 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:13:17.3868 1521 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 12:13:15',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-13 12:13:15',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 13/11/2024 12:13:34.3811 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:15:36.3474 686 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-13 12:15:35','V',5677946054766090,2024,'2024-11-13 12:15:34','456074137600327005012999',2,2,2,'O','',0,'2024-11-13 12:15:35',1,'','',0) 13/11/2024 12:15:43.0569 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:15:43.7873 570 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/11/2024 12:18:09.9667 1327 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:19:38.4877 1087 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/11/2024 12:19:40.9984 1017 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 12:19:39',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 12:19:39',3,42101,0,100,-2,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 12:19:39',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 13/11/2024 12:19:42.5574 1283 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:19:45.6775 719 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 12:19:44',0,16,'2024-11-13 12:19:44','','Unauthorized Transit Entry 2') 13/11/2024 12:20:49.1478 1375 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 12:21:38.7548 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:22:24.7805 908 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 12:22:51.0770 541 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 12:22:51.0770 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:23:05.4295 547 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/11/2024 12:23:39.7994 1843 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5226897556264590,4917693260100200,2024,'2024-11-13 12:23:37','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/13/2024 12:08:13 PM Date : 11/13/2024 12:23:35 PM Code : 456074369300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 13/11/2024 12:23:41.0733 973 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-13 12:23:40',0,0,'V',4708738333329470,5226897556264590,2024,'2024-11-13 12:23:40',3,'KES',-1,50,-50,'N',''); 13/11/2024 12:23:45.1650 2767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:24:23.2744 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:25:59.9398 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:26:08.1513 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:27:31.1776 1671 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 12:31:16.9450 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:31:17.1811 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:31:26.6124 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:31:34.4406 647 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-13 12:29:24',1,'V',5258713088045920,5518430251342860,2024,'2024-11-13 12:29:24',17,1,0,4,'2024-11-13 12:44:24','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 12:31:48.4269 523 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 12:31:47',0,16,'2024-11-13 12:31:47','','Unauthorized Transit Entry 2') 13/11/2024 12:32:20.4863 1272 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:33:21.2448 1468 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:34:30.2567 1129 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:35:11.2691 2594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:35:28.1173 601 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 12:35:27' where traUID = 4814214731332340 and traStatus='V' and traEnabled=1 13/11/2024 12:36:45.0155 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:37:19.5555 1665 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-13 12:37:17' where subId = 202 13/11/2024 12:37:20.5952 897 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-13 12:37:19','0560008421774',0,0,5421223445176140,187,'0000-00-00 00:00:00','0000-00-00 00:00:00') 13/11/2024 12:37:25.1452 1765 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/11/2024 12:39:26.9904 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:39:53.7072 793 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-13 12:39:52','V',5326727318900130,2024,'2024-11-13 12:39:51','456074559100327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 12:42:37.0220 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:42:49.6664 1736 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-13 12:42:47',0,'V',5066729092600270,5221092393689330,2024,'2024-11-13 12:42:47',18,1,0,4,'2024-11-13 12:57:47','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 12:42:51.1314 1049 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49487, trcLastPrinted = '2400749487', trcLastDate = '2024-11-13 12:42:50' where trcStatus='V' and trcTerId = 18 13/11/2024 12:44:17.3228 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-13 12:44:16','V',4796353637760090,2024,'2024-11-13 12:44:14','456074401600327005012999',2,2,2,'O','',0,'2024-11-13 12:44:16',1,'','',0) 13/11/2024 12:44:24.9549 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:44:55.1200 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:45:50.1807 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:47:38.5228 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:49:00.9988 569 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 12:49:21.3323 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:49:47.1625 2378 ms. EXEC: update payInventory set invCreation = '2024-11-13 12:49:44',invModify = '2024-11-13 12:49:44',invUseId=0,invStatus='V' where invId = 219001 13/11/2024 12:49:47.2216 1875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 12:52:37.0247 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 12:54:37.9993 879 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4633144193216410,5055204950948080,2024,'2024-11-13 12:54:37',' Date: 11/13/2024 12:52:18 PM Code: 456074610800327005012999 Entry Date: 11/13/2024 12:48:28 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 # 2400416080 ',0) 13/11/2024 12:57:04.5189 692 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-13 12:57:03','V',4788953596051320,2024,'2024-11-13 12:57:02','456074610800327005012999',2,2,2,'O','',0,'2024-11-13 12:57:03',1,'','',0) 13/11/2024 12:59:37.8851 650 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-13 12:59:37','V',5552248540086120,2024,'2024-11-13 12:59:36','456074677600327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 13:00:27.5581 916 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 13:01:24.1258 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 13:03:14.6254 1148 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49489, trcLastPrinted = '2400749489', trcLastDate = '2024-11-13 13:03:13' where trcStatus='V' and trcTerId = 18 13/11/2024 13:03:15.9053 1277 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5035709636653050,5621023314848250,2024,'2024-11-13 13:03:14',' Date: 11/13/2024 1:03:12 PM Code: 456074650000327001012999 Entry Date: 11/13/2024 12:55:00 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400749489 ',0) 13/11/2024 13:04:13.4296 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:04:18.3149 525 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 13:04:17' where payTraUID = 5216144046065650 and payStatus='V' and payEnabled=1 13/11/2024 13:04:19.0864 770 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 13:04:17' where traUID = 5216144046065650 and traStatus='V' and traEnabled=1 13/11/2024 13:04:19.5717 1051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:04:28.9279 1948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:04:58.3545 637 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 13:04:57' where payTraUID = 4725791940911460 and payStatus='V' and payEnabled=1 13/11/2024 13:05:24.6721 1605 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-13 13:05:23',0,'V',5080878892993290,4874725241057090,2024,'2024-11-13 13:05:23',2,1,0,-1,'2024-11-13 14:05:23','S','KES',0,0,0,'','','',3,0,0) 13/11/2024 13:05:25.6067 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-13 13:05:25','V',4743649463881580,2024,'2024-11-13 13:05:20','456074132400327005012999',2,2,2,'O','',0,'2024-11-13 13:05:25',1,'','0230003943530',44,0) 13/11/2024 13:06:46.0923 2120 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:06:53.6653 1207 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:11:09.4307 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 13:11:47.6652 542 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-13 13:11:47','V',5681304246306380,2024,'2024-11-13 13:11:45','456074750500327001012999',1,2,1,'I','',1,0,1,'','',4) 13/11/2024 13:14:10.7495 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 13:14:13.5164 575 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-13 13:14:12','V',5406812966127560,2024,'2024-11-13 13:14:11','456074661000327005012999',2,2,2,'O','',0,'2024-11-13 13:14:12',1,'','',0) 13/11/2024 13:14:14.7001 516 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 13:14:15.2805 978 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 13:14:14' where traUID = 5704055071104310 and traStatus='V' and traEnabled=1 13/11/2024 13:14:22.5213 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:16:10.6864 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:16:51.9079 1428 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 13:16:50' where payTraUID = 5433102982088980 and payStatus='V' and payEnabled=1 13/11/2024 13:17:22.3672 544 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-13 13:17:21','V',5292442914449140,2024,'2024-11-13 13:17:19','456073261000327005012999',2,2,2,'O','',0,'2024-11-13 13:17:21',1,'','',0) 13/11/2024 13:17:49.1250 568 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 13:17:48' where traUID = 5699649592854540 and traStatus='V' and traEnabled=1 13/11/2024 13:19:20.3768 541 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 13/11/2024 13:19:29.9011 739 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 13:20:18.0372 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:22:25.2229 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:23:49.6912 2026 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-13 13:23:47','V',5623558903188300,2024,'2024-11-13 13:23:46','456074714500327005012999',2,2,2,'O','',0,'2024-11-13 13:23:47',1,'','',0) 13/11/2024 13:23:52.2979 685 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 13:24:46.1028 1027 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-13 13:24:45','V',4939320073177530,2024,'2024-11-13 13:24:44','456074828400327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 13:25:24.0320 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:25:35.4266 752 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 13:26:46.7271 1000 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 13:28:37.5039 1365 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 13/11/2024 13:28:56.5006 588 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-13 13:28:55','V',5415072285637330,2024,'2024-11-13 13:28:54','456074309100327005012999',2,2,2,'O','',0,'2024-11-13 13:28:55',1,'','',0) 13/11/2024 13:28:57.8134 1206 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/11/2024 13:29:47.4445 921 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:30:49.7780 649 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/11/2024 13:33:05.1322 1616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:33:17.3603 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:33:37.4437 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:37:27.5250 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:37:55.2174 1961 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456074823100327001012999' 13/11/2024 13:39:29.5433 583 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-13 13:39:27','V',4816208207291220,2024,'2024-11-13 13:39:25','456074916500327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 1007 ms.) 13/11/2024 13:39:42.6090 2926 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 13:39:39' where traUID = 5106749294784730 and traStatus='V' and traEnabled=1 13/11/2024 13:40:14.0169 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:40:50.8814 2932 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-13 13:40:47','V',5635478057604820,2024,'2024-11-13 13:40:47','456074924700327001012999',1,2,1,'I','',1,0,1,'','',4) 13/11/2024 13:42:50.4221 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:42:58.6986 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 13:43:27.6068 717 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 13:43:47.1188 544 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 13:46:16.8936 2768 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 13:46:14',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/11/2024 13:46:18.2875 1000 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 13/11/2024 13:46:24.3696 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:47:25.8866 759 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 13:47:42.0213 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:50:12.1353 1772 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 13:50:17.8001 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:52:41.6069 600 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-13 13:52:41',0,'V',5692353560145800,4707941756516520,2024,'2024-11-13 13:52:41',2,1,0,-1,'2024-11-13 14:52:41','S','KES',0,0,0,'','','',3,0,0) 13/11/2024 13:53:26.3007 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 13:53:45.1052 1384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:53:51.7056 2776 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 14 13/11/2024 13:55:12.2743 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:55:38.1675 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:56:10.2739 4576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:56:16.3539 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 13:56:25.2959 1100 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 13:56:25.2969 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 13:56:45.7895 2342 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 13/11/2024 13:56:46.5651 766 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 13:57:55.7321 1190 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 13:57:58.3209 1621 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 13:57:59.8699 1425 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-13 13:57:58','V',5602733346206560,2024,'2024-11-13 13:57:56','456074511000327005012999',2,2,2,'O','',0,'2024-11-13 13:57:58',1,'','',0) 13/11/2024 14:00:24.7034 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:02:06.2670 670 ms. EXEC: update payReceipt set recCreation = '2024-11-13 14:02:05',recModify = '2024-11-13 14:02:05',recUseId=0,recStatus='V' where recId = 322223 13/11/2024 14:02:30.6343 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:02:52.5118 1713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:03:23.7727 787 ms. EXEC: update paycash set casCreation = '2024-11-13 14:03:22',casModify = '2024-11-13 14:03:22',casUseId=0,casStatus='V' where casId = 194723 13/11/2024 14:03:24.9094 659 ms. EXEC: update paycash set casCreation = '2024-11-13 14:03:24',casModify = '2024-11-13 14:03:24',casUseId=0,casStatus='V' where casId = 194724 13/11/2024 14:03:26.2493 1373 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 14:03:26.2623 1304 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 14:03:24',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 13/11/2024 14:04:57.5571 1597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:05:04.8840 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:05:27.3570 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:05:43.7709 1296 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 14:05:46.8460 1212 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-13 14:05:45','V',5019009018505790,2024,'2024-11-13 14:05:41','456074827500327001012999',2,2,2,'O','',0,'2024-11-13 14:05:45',1,'','',0) 13/11/2024 14:05:50.3303 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:05:53.5464 2149 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-13 14:05:51',0,0,'V',4640738532370350,5632653919975600,2024,'2024-11-13 14:05:51',3,'KES',1,50,50,'N',''); 13/11/2024 14:06:07.1695 636 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-13 14:06:05',0,'V',5299666503408410,4833010573733120,2024,'2024-11-13 14:06:05',18,1,0,4,'2024-11-13 14:21:05','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 14:06:14.3843 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:06:20.3333 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:07:08.6835 555 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/11/2024 14:07:22.6078 1804 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-13 13:07:20') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-13 14:07:20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-13 14:07:20' and (resAreId = 1 or resAreId <= 0) nr: 0 13/11/2024 14:07:38.9977 571 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 14:08:11.5864 573 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 14:08:13.3145 1053 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '456075088900327005012999') and traDirection='I' order by traId desc limit 1 13/11/2024 14:08:14.5023 775 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 14:08:15.0147 510 ms. OPEN: show columns from tabParameters where Field = 'parUseFloorCounter' 13/11/2024 14:08:34.4096 536 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/11/2024 14:08:46.9930 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:09:07.7628 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:09:08.4713 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:09:08.6754 771 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5552248540086120,5556554425126990,2024,'2024-11-13 14:09:07','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/13/2024 12:59:36 PM Date : 11/13/2024 2:09:06 PM Code : 456074677600327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 13/11/2024 14:09:09.5340 674 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-13 14:09:08',0,0,'V',5663913981715640,5552248540086120,2024,'2024-11-13 14:09:08',3,'KES',1,100,100,'N',''); 13/11/2024 14:09:10.6427 956 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 14:09:08',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/11/2024 14:09:13.8168 3174 ms. EXEC: update payInventory set invCreation = '2024-11-13 14:09:10',invModify = '2024-11-13 14:09:10',invUseId=0,invStatus='V' where invId = 219027 13/11/2024 14:09:23.8926 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:09:41.1060 623 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 14:09:50.8085 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:10:04.2514 1597 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/11/2024 14:10:16.0923 2972 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 14:11:07.5286 584 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-13 14:11:06','V',5282865226039560,2024,'2024-11-13 14:11:03','456075106300327001012999',1,2,1,'I','',1,0,1,'','',4) 13/11/2024 14:11:16.1914 1755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:12:03.9942 1041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:13:14.1159 2813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:17:00.7809 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:17:57.9210 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:18:53.4820 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:19:50.1177 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:23:26.0736 917 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-13 14:23:25' where subId = 116 13/11/2024 14:23:26.7570 676 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-13 14:23:26','0810007145851',0,0,4988278269103470,106,'0000-00-00 00:00:00','0000-00-00 00:00:00') 13/11/2024 14:23:28.7584 1164 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 14:23:27' where payTraUID = 4743578196640310 and payStatus='V' and payEnabled=1 13/11/2024 14:26:20.2116 583 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/11/2024 14:26:21.2183 998 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 14:26:20' where payTraUID = 4999989544024360 and payStatus='V' and payEnabled=1 13/11/2024 14:28:11.6708 1360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:28:45.1912 1008 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/11/2024 14:28:49.8883 827 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/11/2024 14:29:00.8936 581 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '776492' and traDirection='I' order by traId DESC LIMIT 1 13/11/2024 14:31:22.4289 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:31:28.2618 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:32:22.3798 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:32:24.3231 1032 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:32:26.4265 1160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:33:05.6347 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:33:09.2601 2891 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4919968700993550,4725688540369480,2024,'2024-11-13 14:33:06',' Data: 11/13/2024 2:30:57 PM Codice: 456074947700327005012999 Ingresso: 11/13/2024 1:44:37 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400607120 ',0) 13/11/2024 14:33:23.0773 1053 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:34:30.2650 527 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 14:34:45.8704 899 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:37:46.5258 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:38:56.9357 3002 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:41:03.0507 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:41:05.4343 1540 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 14:42:14.6494 543 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 14:43:20.9005 693 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 14:43:20.9015 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:43:41.5233 1088 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:44:36.4438 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:45:23.4982 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:46:13.1422 1056 ms. EXEC: update paycash set casCreation = '2024-11-13 14:46:12',casModify = '2024-11-13 14:46:12',casUseId=0,casStatus='V' where casId = 194739 13/11/2024 14:46:14.7463 1344 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:46:14.7673 533 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 13/11/2024 14:46:14.8584 1716 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 14:46:12',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'; 13/11/2024 14:46:19.1503 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:46:32.6963 610 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/11/2024 14:48:07.6605 620 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 14:48:47.8243 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:49:31.8816 1246 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-13 14:49:30','V',4729647256528560,2024,'2024-11-13 14:49:30','456075337000327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 14:49:32.4880 552 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 14:49:48.2075 1526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:50:00.0754 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:52:59.8812 1475 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:54:02.3158 1137 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-13 14:51:53',1,'V',5582713156917980,4939320073177530,2024,'2024-11-13 14:51:53',17,1,0,4,'2024-11-13 15:06:53','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 13/11/2024 14:54:03.3335 625 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7121, trcLastPrinted = '2400607121', trcLastDate = '2024-11-13 14:54:02' where trcStatus='V' and trcTerId = 17 13/11/2024 14:54:06.8598 1879 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 14:54:13.3161 857 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/11/2024 14:54:26.8041 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-13 14:54:26','V',5626215977905680,2024,'2024-11-13 14:54:25','456075366500327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 14:54:39.0042 1009 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:55:13.7384 939 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-13 14:55:12',0,'V',5345330963105570,5509330623027200,2024,'2024-11-13 14:55:12',3,1,0,4,'2024-11-13 15:10:12','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 13/11/2024 14:55:19.2530 1531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:56:45.9498 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:57:06.1873 542 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-13 14:57:05','V',4641755031079850,2024,'2024-11-13 14:57:03','456074708100327005012999',2,2,2,'O','',0,'2024-11-13 14:57:05',1,'','',0) 13/11/2024 14:57:07.6372 971 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 14:57:06' where traUID = 5433350806284760 and traStatus='V' and traEnabled=1 13/11/2024 14:57:10.2820 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 14:57:10.7643 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 14:58:00.4434 3314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:00:26.6008 506 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/11/2024 15:00:35.4407 964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:01:05.2705 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-13 14:58:56',1,'V',5136825812038160,5681304246306380,2024,'2024-11-13 14:58:56',17,1,0,4,'2024-11-13 15:13:56','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 13/11/2024 15:01:10.0207 828 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 15:02:33.6264 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:02:34.8502 901 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 15:02:33' where traUID = 5681304246306380 and traStatus='V' and traEnabled=1 13/11/2024 15:02:59.8349 1051 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 15:04:29.2774 535 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 15:04:28' where traUID = 5107519304851820 and traStatus='V' and traEnabled=1 13/11/2024 15:05:02.4405 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:07:49.3147 1595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:13:33.5170 1479 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/11/2024 15:16:41.3181 1882 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 15:16:51.9442 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 15:18:55.6756 1607 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 15:18:53',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 13/11/2024 15:20:05.7903 1259 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 15:20:04' where payTraUID = 5216275997430170 and payStatus='V' and payEnabled=1 13/11/2024 15:20:11.0248 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 15:20:26.7543 1233 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-13 15:20:25','V',4867716805661580,2024,'2024-11-13 15:20:24','456075478900327005012999',2,2,2,'O','',0,'2024-11-13 15:20:25',1,'','',0) 13/11/2024 15:20:27.6989 718 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 15:20:26' where payTraUID = 4901193580563220 and payStatus='V' and payEnabled=1 13/11/2024 15:20:31.8767 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 15:20:41.9564 530 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 15:20:55.0831 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 15:21:03.0294 2791 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-13 15:21:00',0,'V',4923231379645850,5530807596771490,2024,'2024-11-13 15:21:00',18,1,0,4,'2024-11-13 15:36:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 63 ms.) 13/11/2024 15:23:06.9650 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:23:36.3516 2632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:24:30.5026 550 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 15:24:40.2681 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:24:57.7788 703 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-13 15:24:57','0560008335992',0,0,5505118540282050,173,'0000-00-00 00:00:00','0000-00-00 00:00:00') 13/11/2024 15:25:01.1801 3219 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-13 15:24:57','V',5465967889889210,2024,'2024-11-13 15:24:56','456075101000327005012999',2,2,2,'O','',0,'2024-11-13 15:24:57',1,'','0560008335992',173,0) 13/11/2024 15:25:02.7481 594 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 15:25:02' where payTraUID = 5661747856339610 and payStatus='V' and payEnabled=1 13/11/2024 15:25:42.9959 840 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 15:29:06.3954 2894 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 15:30:21.1872 1439 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 15:30:19',0,16,'2024-11-13 15:30:19','','Unauthorized Transit Entry 2') 13/11/2024 15:30:22.6562 762 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-13 15:28:02',9,'V',5654722983058170,5098012490975780,2024,'2024-11-13 15:28:02',4,1,0,4,'2024-11-13 15:43:02','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 15:32:25.4230 1020 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 15:32:24' where traUID = 5098012490975780 and traStatus='V' and traEnabled=1 13/11/2024 15:32:36.8006 1534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:33:35.5717 2307 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 15:36:06.3722 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:36:09.9676 1029 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 15:38:14.8017 1249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:40:20.8157 1092 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 15:40:19' where traUID = 5484320680179830 and traStatus='V' and traEnabled=1 13/11/2024 15:40:26.6025 1937 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/11/2024 15:40:35.1692 853 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 15:40:34' where traUID = 4929283038568800 and traStatus='V' and traEnabled=1 13/11/2024 15:43:03.3149 1476 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4775623814550130,5574160351337280,2024,'2024-11-13 15:43:01',' Date: 11/13/2024 3:40:43 PM Code: 456074970300327005012999 Entry Date: 11/13/2024 1:48:23 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416093 ',0) 13/11/2024 15:44:40.6968 1412 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:44:59.1371 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:45:16.5917 1405 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 15:46:18.1587 1247 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-13 15:46:16','V',4717849662089700,2024,'2024-11-13 15:46:16','456075596300327001012999',2,2,2,'O','',0,'2024-11-13 15:46:16',1,'','',0) 13/11/2024 15:51:33.3327 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:51:46.7846 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:53:03.5918 840 ms. EXEC: update abbCards set carLastDate = '2024-11-13 15:53:02',carLastDirection='O' where carStatus='V' and carId = 14 13/11/2024 15:53:49.8216 813 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/11/2024 15:54:11.3389 736 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-13 15:54:08',0,'V',5035255919215400,5637108059811110,2024,'2024-11-13 15:54:08',3,1,0,4,'2024-11-13 16:09:08','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 13/11/2024 15:54:13.0881 838 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 15:54:11',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'; 13/11/2024 15:54:57.9470 540 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-13 15:54:57','V',4956706734987970,2024,'2024-11-13 15:54:55','456075729500327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 15:55:14.6591 727 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 15:55:14.6611 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:56:01.2241 521 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/11/2024 15:57:35.7841 605 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-13 15:57:35','V',5524405654192270,2024,'2024-11-13 15:57:34','456075573600327005012999',2,2,2,'O','',0,'2024-11-13 15:57:35',1,'','',0) 13/11/2024 15:57:36.4606 674 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 15:57:39.5456 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:57:53.5009 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 15:59:23.9612 1598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:00:09.8117 670 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 16:02:09.6266 1413 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/11/2024 16:02:13.7953 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:02:25.4621 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 4 ms.) 13/11/2024 16:02:26.0575 534 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/11/2024 16:02:33.1392 4538 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-13 16:02:28' where subId = 27 13/11/2024 16:02:34.2329 1085 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-13 16:02:33','0230003957444',0,0,4850705950134620,26,'0000-00-00 00:00:00','0000-00-00 00:00:00') 13/11/2024 16:04:15.8386 693 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 16:04:15.8426 504 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/11/2024 16:04:15.8436 505 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 16:04:16.2329 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:04:16.9374 641 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-13 16:04:16','V',5336400668111160,2024,'2024-11-13 16:04:13','456075622800327005012999',2,2,2,'O','',0,'2024-11-13 16:04:16',1,'','',0) 13/11/2024 16:04:23.7419 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:04:23.8730 558 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/11/2024 16:05:16.2989 834 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 16:05:15' where traUID = 5099470430661520 and traStatus='V' and traEnabled=1 13/11/2024 16:05:20.8119 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-13 16:05:19',0,'V',5689472231326470,4921223024786580,2024,'2024-11-13 16:05:19',18,1,0,4,'2024-11-13 16:20:19','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 13/11/2024 16:05:20.8399 1408 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:05:41.1815 776 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 16:05:39' where traUID = 5733361567535340 and traStatus='V' and traEnabled=1 13/11/2024 16:05:49.2849 1325 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:05:52.5821 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:06:33.9206 1092 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:09:48.0549 2348 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:10:47.8127 774 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4956706734987970,4673673457435890,2024,'2024-11-13 16:10:47','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/13/2024 3:54:55 PM Date : 11/13/2024 4:10:43 PM Code : 456075729500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 13/11/2024 16:11:50.2473 1804 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 16:11:48' where payTraUID = 5235016458068690 and payStatus='V' and payEnabled=1 13/11/2024 16:11:51.0279 780 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 16:11:48' where traUID = 5235016458068690 and traStatus='V' and traEnabled=1 13/11/2024 16:13:31.9001 1083 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:13:38.0161 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:14:01.8600 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:14:06.2059 2230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:14:15.9544 1195 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 16:17:14.7765 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:17:17.7095 805 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 16:17:16',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 13/11/2024 16:17:37.8349 1209 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-13 16:17:36','V',4863536236107930,2024,'2024-11-13 16:17:36','456075527100327001012999',2,2,2,'O','',0,'2024-11-13 16:17:36',1,'','',0) 13/11/2024 16:17:38.4633 619 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 16:21:08.1910 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:21:57.5379 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:22:51.9881 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 16:35:52.0918 567 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-13 16:35:50',0,'V',5395457636065000,5329099044396400,2024,'2024-11-13 16:35:50',3,1,0,4,'2024-11-13 16:50:50','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 13/11/2024 16:37:42.6655 517 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 16:38:59.6578 1527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:39:17.5557 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:40:54.4012 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 16:44:09.1029 692 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 16:52:48.2017 866 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 16:59:55.6705 1322 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4695440596325180,4946254753959850,2024,'2024-11-13 16:59:54',' Date: 11/13/2024 4:59:53 PM Code: 456075580600327005012999 Entry Date: 11/13/2024 3:30:06 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 # 2400749534 ',0) 13/11/2024 17:01:18.6167 819 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:01:19.2822 614 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/11/2024 17:01:56.0116 1350 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 17:01:54' where traUID = 5615613155483210 and traStatus='V' and traEnabled=1 13/11/2024 17:01:58.6364 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:01:59.6170 949 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 13/11/2024 17:02:14.4199 557 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-13 17:02:13','V',5257531861235130,2024,'2024-11-13 17:02:12','456075580600327005012999',2,2,2,'O','',0,'2024-11-13 17:02:13',1,'','',0) 13/11/2024 17:02:15.2925 864 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 17:02:24.1634 559 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49535, trcLastPrinted = '2400749535', trcLastDate = '2024-11-13 17:02:23' where trcStatus='V' and trcTerId = 18 13/11/2024 17:02:33.4916 934 ms. EXEC: update payInventory set invCreation = '2024-11-13 17:02:32',invModify = '2024-11-13 17:02:32',invUseId=0,invStatus='V' where invId = 219072 13/11/2024 17:02:36.2234 1647 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-13 17:02:34','V',5251526379992120,2024,'2024-11-13 17:02:33','456075848300327005012999',2,2,2,'O','',0,'2024-11-13 17:02:34',1,'','',0) 13/11/2024 17:03:53.5859 521 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 17:04:58.9655 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:05:16.5082 560 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 13/11/2024 17:05:16.5432 667 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 13/11/2024 17:08:56.0454 717 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-13 17:08:55','V',5182713563963210,2024,'2024-11-13 17:08:53','456073697100327005012999',2,2,2,'O','',0,'2024-11-13 17:08:55',1,'','0230004101223',11,0) 13/11/2024 17:13:24.6624 989 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-13 17:13:22',0,'V',5180842990562290,5202227568064840,2024,'2024-11-13 17:13:22',3,1,0,4,'2024-11-13 17:28:22','C','KES',50,200,100,'',' ',' ',2,50,0,0,'',0,0) 13/11/2024 17:13:26.2864 951 ms. EXEC: update paycash set casCreation = '2024-11-13 17:13:25',casModify = '2024-11-13 17:13:25',casUseId=0,casStatus='V' where casId = 194771 13/11/2024 17:13:54.8695 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:14:59.2033 1146 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-13 17:14:58',0,'V',4951730734426830,4899569736087430,2024,'2024-11-13 17:14:58',18,1,0,4,'2024-11-13 17:29:58','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 17:16:59.9168 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:17:18.7943 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:21:18.0757 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:21:44.5954 565 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-13 17:21:44','V',4764575870422610,2024,'2024-11-13 17:21:42','456075206800327005012999',2,2,2,'O','',0,'2024-11-13 17:21:44',1,'','0230003957422',29,0) 13/11/2024 17:22:09.7932 965 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 17:22:24.5570 505 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 17:22:24',0,16,'2024-11-13 17:22:24','','Unauthorized Transit Entry 2') 13/11/2024 17:23:46.1664 2267 ms. EXEC: update payReceipt set recCreation = '2024-11-13 17:23:43',recModify = '2024-11-13 17:23:43',recUseId=0,recStatus='V' where recId = 322312 13/11/2024 17:25:43.6276 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:27:12.1676 625 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-13 17:27:11','V',5273180401511690,2024,'2024-11-13 17:27:10','456076072600327005012999',2,2,2,'O','',0,'2024-11-13 17:27:11',1,'','',0) 13/11/2024 17:28:49.6115 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:30:10.1482 691 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-13 17:30:09','V',5324681893598190,2024,'2024-11-13 17:30:06','456073278400327005012999',2,2,2,'O','',0,'2024-11-13 17:30:09',1,'','0230004100082',142,0) 13/11/2024 17:30:12.0454 1528 ms. EXEC: update abbCards set carLastDate = '2024-11-13 17:30:10',carLastDirection='O' where carStatus='V' and carId = 142 13/11/2024 17:30:50.7512 3013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:32:12.9410 1196 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 17:32:13.1661 1287 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:34:00.8459 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:34:10.3172 1490 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-13 17:34:08','0230003950907',0,0,5367206547081440,19,'0000-00-00 00:00:00','0000-00-00 00:00:00') 13/11/2024 17:34:12.5927 592 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 13/11/2024 17:35:09.9679 754 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 17:35:09' where traUID = 5589836325400590 and traStatus='V' and traEnabled=1 13/11/2024 17:35:14.2778 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:35:23.0376 1078 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 17:35:23.0466 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:36:30.9418 688 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 13/11/2024 17:36:42.8127 601 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 13/11/2024 17:38:13.2790 532 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/11/2024 17:38:17.4708 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:39:39.6285 940 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:40:23.6138 624 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 17:40:24.4564 738 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/11/2024 17:40:48.3003 1297 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 17:40:49.1769 875 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 17:41:02.6138 930 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:47:05.1283 1990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:48:18.3171 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:48:51.2260 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:49:12.3901 1406 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:52:38.3383 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:52:43.4447 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:52:44.6525 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:54:59.3412 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:55:21.6751 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 17:55:32.2501 1238 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 17:56:02.0420 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 17:56:38.5723 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 18:04:21.2985 920 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 18:06:19.6624 543 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 18:06:18' where traUID = 5516811650973110 and traStatus='V' and traEnabled=1 13/11/2024 18:06:37.1791 1988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:07:45.0323 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 18:09:11.2317 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 18:11:53.6269 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:15:44.7969 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 18:19:41.5486 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:19:48.7163 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 18:26:50.0455 537 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/11/2024 18:27:20.7389 1953 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:28:08.2546 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:28:55.4801 1370 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:29:52.6301 3395 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:33:07.6120 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:35:11.9268 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 18:35:27.0579 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:42:49.6527 932 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 18:46:01.4095 1332 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 18:46:49.4635 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:52:34.6785 1216 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:52:41.4029 1585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:52:52.8586 690 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 18:55:42.2014 3563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:56:42.9428 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 18:57:25.9595 542 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 13/11/2024 19:00:29.5288 512 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-13 19:00:28',0,'V',5106115623450680,4917281782839530,2024,'2024-11-13 19:00:28',18,1,0,4,'2024-11-13 19:15:28','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 19:01:34.5661 1006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:03:07.7122 914 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 19:03:06',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'; 13/11/2024 19:03:15.4603 919 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 19:04:36.5874 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:06:01.2057 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 19:06:08.9979 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:06:09.0139 959 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 19:08:38.8778 1800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:09:31.6819 2868 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 19:09:57.8314 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:10:14.4744 3426 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:10:48.7303 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:11:18.8924 1475 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-13 19:11:17',0,16,'2024-11-13 19:11:17','','Unauthorized Transit Entry 2') 13/11/2024 19:12:50.2732 1256 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 13/11/2024 19:14:18.0037 1923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 187 ms.) 13/11/2024 19:14:29.2061 565 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-13 19:14:28','V',4794302035520760,2024,'2024-11-13 19:14:28','456076926800327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 19:16:33.4869 1900 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49554, trcLastPrinted = '2400749554', trcLastDate = '2024-11-13 19:16:31' where trcStatus='V' and trcTerId = 18 13/11/2024 19:21:38.3570 1807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:26:56.6781 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 19:27:52.3532 2587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:29:20.9031 599 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/11/2024 19:29:21.8127 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 19:31:49.3250 1580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:32:08.2106 1961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:32:20.6389 846 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 19:39:13.7000 800 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-13 19:39:12','V',5081338160266770,2024,'2024-11-13 19:39:12','456077075200327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 19:40:29.6796 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 19:40:32.8337 1908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:42:24.4891 1497 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:44:05.6185 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:46:09.8813 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 19:47:02.3532 799 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/11/2024 19:47:12.7471 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:47:48.5960 688 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-13 19:47:47','V',5031164375203000,2024,'2024-11-13 19:47:47','456077126700327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 19:47:54.5300 1267 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 13/11/2024 19:49:26.0409 1977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:49:57.6580 2026 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 13/11/2024 19:50:07.8838 898 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 19:50:06',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/11/2024 19:50:09.2777 1393 ms. EXEC: update payInventory set invCreation = '2024-11-13 19:50:07',invModify = '2024-11-13 19:50:07',invUseId=0,invStatus='V' where invId = 219097 13/11/2024 19:53:07.4800 1294 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/11/2024 19:54:17.2788 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:54:30.6817 2723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:58:34.3297 1850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 19:59:11.7107 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 19:59:11.8418 560 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/11/2024 19:59:47.2955 1619 ms. EXEC: update paycash set casCreation = '2024-11-13 19:59:45',casModify = '2024-11-13 19:59:45',casUseId=0,casStatus='V' where casId = 194793 13/11/2024 19:59:47.8739 578 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-13 19:59:45',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 13/11/2024 20:03:27.4305 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 20:03:38.2777 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:06:48.7934 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 20:07:01.6830 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:07:10.0566 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:07:16.9061 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:07:52.1966 1477 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:07:53.1132 903 ms. EXEC: update abbCards set carLastDate = '2024-11-13 20:07:52',carLastDirection='I' where carStatus='V' and carId = 44 13/11/2024 20:08:01.3847 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 20:10:49.7838 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:15:56.2699 1411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:17:09.4877 1090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:17:46.9096 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:21:33.7777 806 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 20:21:51.1873 932 ms. EXEC: update payInventory set invCreation = '2024-11-13 20:21:50',invModify = '2024-11-13 20:21:50',invUseId=0,invStatus='V' where invId = 219102 13/11/2024 20:21:52.5342 1345 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-13 20:21:51',0,0,'V',4641764587139350,4932978743763460,2024,'2024-11-13 20:21:51',3,'KES',-1,100,-100,'N',''); 13/11/2024 20:21:53.7190 1146 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 20:21:51',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/11/2024 20:24:56.2157 1111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:29:34.9039 529 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-13 20:29:34' where payTraUID = 5474867119872070 and payStatus='V' and payEnabled=1 13/11/2024 20:29:41.1011 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:29:41.2492 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 20:30:59.8737 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:34:43.4401 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 20:43:33.0280 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 20:43:40.1328 523 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 20:44:57.4135 876 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-13 20:44:56','V',4903180748548650,2024,'2024-11-13 20:44:55','456077469500327005012999',1,2,16,'I','',1,0,1,'','',4) 13/11/2024 20:46:01.8776 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:48:12.2458 832 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-13 20:48:11' where subId = 116 13/11/2024 20:48:13.2454 992 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-13 20:48:12','0810007145851',0,0,5010436284043530,106,'0000-00-00 00:00:00','0000-00-00 00:00:00') 13/11/2024 20:48:46.6508 1019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:49:03.1148 927 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 13/11/2024 20:49:16.1565 608 ms. EXEC: update paycash set casCreation = '2024-11-13 20:49:15',casModify = '2024-11-13 20:49:15',casUseId=0,casStatus='V' where casId = 194800 13/11/2024 20:49:16.9650 808 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 20:49:15',3,42101,0,100,2,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 20:49:15',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 13/11/2024 20:49:19.3096 2343 ms. EXEC: update payInventory set invCreation = '2024-11-13 20:49:16',invModify = '2024-11-13 20:49:16',invUseId=0,invStatus='V' where invId = 219105 13/11/2024 20:49:30.6772 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:50:23.1693 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:50:30.2460 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:51:10.0066 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:51:45.0090 1248 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/11/2024 20:52:20.5868 4389 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 20:53:17.4258 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 20:59:16.5031 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:03:24.0785 987 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 21:03:49.3564 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 21:05:15.0977 546 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeEnd' 13/11/2024 21:15:46.4383 2661 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 18 ms.) 13/11/2024 21:17:59.1279 1864 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 21:18:18.5219 1234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:19:04.1003 2495 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:19:44.6284 1337 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 13/11/2024 21:22:23.0631 1374 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:25:28.0206 502 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-13 21:25:27',0,'V',5540957961900170,5135952203572460,2024,'2024-11-13 21:25:27',18,1,0,4,'2024-11-13 21:40:27','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 13/11/2024 21:25:29.6817 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:25:35.3495 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:30:14.0048 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:32:01.8209 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:40:34.3916 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 21:44:49.9829 773 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 21:47:41.3531 618 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-13 21:47:40',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'; 13/11/2024 21:53:56.8242 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 21:55:32.3022 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 21:56:16.2367 560 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 21:57:14.2056 1017 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/11/2024 21:57:23.4147 598 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 21:59:31.2334 607 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 13/11/2024 22:02:45.9042 738 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-13 22:00:03',9,'V',5227033511136630,5031164375203000,2024,'2024-11-13 22:00:03',4,1,0,4,'2024-11-13 22:15:03','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 13/11/2024 22:02:47.8185 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 22:17:33.5199 785 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 22:17:45.6161 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 22:37:10.1724 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 22:37:58.0675 530 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 22:50:09.8372 864 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/11/2024 22:53:43.8748 1701 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 13/11/2024 22:54:03.5610 1122 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 127 ms.) 13/11/2024 22:54:04.0002 861 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 561 ms.) 13/11/2024 22:54:15.0827 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 22:54:53.8206 1284 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/11/2024 23:00:16.9439 562 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 13/11/2024 23:00:19.1604 596 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 23:02:15.1772 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:04:30.8771 1460 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:06:56.6911 2082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:07:31.8047 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:08:20.0630 1310 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:14:57.4752 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:15:15.5773 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/11/2024 23:18:38.3255 558 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 13/11/2024 23:21:18.7430 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:22:05.8445 1262 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-13 23:22:04' where traUID = 4646563985079770 and traStatus='V' and traEnabled=1 13/11/2024 23:33:20.0546 1351 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:37:03.8075 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:37:48.7075 1266 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:37:56.2326 1812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:38:38.5049 1240 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:38:38.7720 729 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/11/2024 23:39:33.4987 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:40:54.6720 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:42:43.8420 1149 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:45:07.0230 2945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:50:57.9801 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:51:58.8418 1093 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 13/11/2024 23:52:30.8953 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:55:57.7657 1229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:56:47.5570 1312 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/11/2024 23:59:11.2192 1664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1