15/11/2024 00:02:59.2930 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:03:57.6460 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:06:07.6959 1320 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:06:33.9714 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:07:11.8277 932 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 00:07:11.9848 637 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 15/11/2024 00:21:40.7293 1840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:24:07.9326 1378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:30:54.7014 949 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 00:38:47.8905 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:38:50.5473 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:54:27.5223 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:56:31.6082 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 00:56:50.8301 1205 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 15/11/2024 00:59:25.1232 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 01:02:32.5894 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:06:33.1431 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:07:00.3143 1140 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:20:37.9036 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:23:36.0776 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:25:25.3816 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:27:07.8201 1789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:27:18.1760 1152 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:30:52.9345 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:32:39.0224 2723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:33:14.9174 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:33:43.8527 1963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:35:34.9599 2510 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 01:35:58.2675 1448 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:39:29.0093 2977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:39:48.1451 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:40:02.0594 1592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:40:20.7899 2853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:41:40.9705 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:43:57.2635 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:44:06.1174 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:44:44.4621 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:46:12.3558 509 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 15/11/2024 01:46:12.5119 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:47:21.0217 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 01:47:32.8255 527 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-15 01:47:32',0,'V',5038013334789680,4744189358349470,2024,'2024-11-15 01:47:32',18,1,0,4,'2024-11-15 02:02:32','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 15/11/2024 01:49:27.1299 990 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 01:49:28.0335 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:49:29.0862 1496 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 01:49:27' where traUID = 4744189358349470 and traStatus='V' and traEnabled=1 15/11/2024 01:55:47.9183 2301 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 01:57:02.2130 1004 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:03:14.2375 727 ms. OPEN: select * from tabClass where claStatus='V' and claPosition<>0 order by claPosition,claId 15/11/2024 02:07:07.1492 531 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/11/2024 02:10:32.4163 1260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:16:08.8551 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:16:17.5689 527 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 15/11/2024 02:21:11.9106 1230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:21:22.9459 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:23:01.3347 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:24:02.4605 1845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:24:06.2460 1153 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:24:26.2544 1399 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:25:23.3896 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:25:33.3873 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:25:46.5791 1298 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:26:47.0785 1111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:36:45.0630 1724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:43:09.3338 1282 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 15/11/2024 02:53:19.7866 1344 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 02:57:04.1325 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:10:19.4689 826 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 15/11/2024 03:19:14.8957 538 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 15/11/2024 03:25:29.7681 1471 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:25:49.3742 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 03:25:59.4229 2209 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 03:28:26.2851 2066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:29:46.1424 2090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:30:12.4380 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:34:08.7419 2644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:35:37.7113 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:35:54.6696 901 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 03:41:16.1544 505 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 03:41:37.2505 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:43:41.7948 1239 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:44:31.9943 1273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:51:09.8341 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 03:58:17.1116 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 04:02:54.5369 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 04:05:35.0112 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 04:11:53.6531 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 04:12:24.3937 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 04:12:27.2096 627 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/11/2024 04:12:27.2096 644 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-15 04:12:26',4,6,'2024-11-15 04:12:26','456091162900327005012999','Payed (Credit Card ) Ticket ') 15/11/2024 04:13:36.3117 649 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 04:20:10.6112 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 04:28:15.7563 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 04:41:55.3579 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 04:58:02.7323 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:04:24.4543 1894 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 05:04:22' where payTraUID = 4659155377296660 and payStatus='V' and payEnabled=1 15/11/2024 05:09:38.2289 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:10:32.1630 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:12:51.2849 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:23:49.4006 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:28:35.8100 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:32:28.8937 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:41:18.6307 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:45:05.7184 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 05:58:49.0615 1073 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 05:59:58.1577 623 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 05:59:57' where traUID = 5263813246074890 and traStatus='V' and traEnabled=1 15/11/2024 06:02:01.8273 1943 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 06:03:27.7667 1756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 06:07:03.5008 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 06:07:37.1443 742 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 06:07:36','V',5279472686483250,2024,'2024-11-15 06:07:35','456092205500327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 06:08:00.6150 527 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 06:08:45.5290 521 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 06:13:40.1939 1249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 06:13:46.5892 2531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 06:18:14.6733 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 06:18:59.7614 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 06:21:54.0338 651 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 15/11/2024 06:31:49.9180 1821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 06:34:50.4276 1336 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:05:29.4523 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:05:43.2185 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 85 ms.) 15/11/2024 07:11:08.8280 1773 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 15/11/2024 07:11:52.8895 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:13:52.4964 635 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 07:13:54.4297 1744 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 07:13:52' where traUID = 5250537018183130 and traStatus='V' and traEnabled=1 15/11/2024 07:15:16.9418 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:19:26.0252 513 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 07:20:01.5350 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 07:20:59.6758 2590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:22:21.6306 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:22:59.0566 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:25:41.5842 918 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/11/2024 07:26:03.9671 1063 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 15/11/2024 07:27:05.2150 1894 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-15 07:27:02',0,'V',5723055330886010,5661669153881050,2024,'2024-11-15 07:27:02',3,1,0,4,'2024-11-15 07:42:02','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 15/11/2024 07:27:48.5190 1793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:28:55.8690 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 07:29:03.6492 1273 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 07:33:26.9141 1378 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 07:33:37.9925 1895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:34:46.2020 964 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 15/11/2024 07:37:05.8934 1019 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 07:37:35.8054 2307 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:38:15.0586 1061 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 07:38:15.0626 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 3 ms.) 15/11/2024 07:39:34.0604 2385 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 15/11/2024 07:39:42.1678 2512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:42:17.0963 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:44:31.5221 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:44:45.1272 1011 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:46:36.3725 701 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 07:50:17.1240 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 07:52:40.4568 767 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 07:52:39',5,3,0,2,0,0,0,0,'2','') 15/11/2024 07:54:34.7431 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:54:50.6398 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 07:57:46.9235 2121 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-15 07:57:44','V',4879323359521160,2024,'2024-11-15 07:57:43','456092866300327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 07:58:34.1031 698 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-15 07:58:33','V',5718536351575040,2024,'2024-11-15 07:58:31','456092871100327005012999',1,2,16,'I','',1,0,1,'','0230003943861',31,0) 15/11/2024 07:59:02.5871 639 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-15 07:59:01','V',4687249621450110,2024,'2024-11-15 07:58:59','456092873900327001012999',1,2,1,'I','',1,0,1,'','',4) 15/11/2024 08:00:22.8397 3442 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:00:19',5,3,0,2,0,0,0,0,'2','') 15/11/2024 08:00:23.1960 1575 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-15 08:00:21',0,3,'2024-11-15 08:00:21','0230003944086','POF - User Transit Supervisor Supervisor') 15/11/2024 08:01:13.3815 2267 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:01:11',5,3,0,2,0,0,0,0,'2','') 15/11/2024 08:01:44.8165 1016 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:01:32',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 15/11/2024 08:01:58.0814 974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:02:27.0667 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 08:03:39.5321 1318 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:03:50.7967 1404 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,0,50,-25,-1250,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,0,50,25,1250,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,0,100,-29,-2900,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,0,100,29,2900,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,0,200,-8,-1600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,0,200,8,1600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:16',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 15/11/2024 08:03:52.8190 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:03:53.0101 1682 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:46',5,3,42101,0,50,-25,-1250,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:46',5,3,42101,0,100,-29,-2900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:46',5,3,42101,0,200,-8,-1600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:46',5,3,42101,0,1000,-2,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:03:46',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 15/11/2024 08:04:31.2077 1153 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:07:12.1622 529 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:07:08',5,3,42101,0,50,14,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+14,5),curAmount=round(curAmount+700,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-15 08:07:08',5,3,42101,0,100,3,300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+3,5),curAmount=round(curAmount+300,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 15/11/2024 08:08:33.7397 725 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-15 08:08:33','V',5358281654761680,2024,'2024-11-15 08:08:32','456092899900327005012999',2,2,2,'O','',0,'2024-11-15 08:08:33',1,'','',0) 15/11/2024 08:08:38.9982 729 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 15/11/2024 08:12:18.7030 549 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-15 08:12:18' where subId = 200 15/11/2024 08:12:24.5759 639 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 08:12:24.6160 903 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 08:12:24.7380 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:14:50.7366 3154 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 15/11/2024 08:18:00.6665 850 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 15/11/2024 08:18:14.5277 1303 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 371350 else acvFstPayId end),acvLstPayId = 371350 where acvSftId = 818 and acvCodeId = 3 15/11/2024 08:20:50.7771 1140 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 08:22:31.8887 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:23:40.1533 711 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 08:24:12.1677 1484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:26:31.3397 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:26:33.6692 522 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 08:26:33','V',5562424542363210,2024,'2024-11-15 08:26:32','456093039200327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 08:30:28.2290 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 08:30:31.2240 690 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 15/11/2024 08:33:31.3123 4001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:34:36.7660 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:42:15.7407 1583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:42:36.6196 830 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 08:42:35',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'; 15/11/2024 08:42:38.0486 1427 ms. EXEC: update payInventory set invCreation = '2024-11-15 08:42:36',invModify = '2024-11-15 08:42:36',invUseId=0,invStatus='V' where invId = 219331 15/11/2024 08:42:38.9892 936 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 08:42:38',0,0,'V',4879093426609240,5402072607675290,2024,'2024-11-15 08:42:38',3,'KES',-1,50,-50,'N',''); 15/11/2024 08:45:38.0258 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 75 ms.) 15/11/2024 08:46:30.9442 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:46:36.4258 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 08:49:06.4491 624 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-15 08:49:05',0,'V',5107528169342270,5091612774586540,2024,'2024-11-15 08:49:05',2,1,0,-1,'2024-11-15 09:49:05','S','KES',0,0,0,'','','',3,0,0) 15/11/2024 08:49:14.3013 843 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 08:53:22.9525 930 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:00:25.7179 658 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-15 09:00:24',0,'V',5054915580888120,5011447538948010,2024,'2024-11-15 09:00:24',3,1,0,4,'2024-11-15 09:15:24','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 15/11/2024 09:00:34.6669 715 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 15/11/2024 09:00:34.6679 714 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 09:00:34.6679 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:04:13.1789 871 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-15 09:04:12','V',5178335179359440,2024,'2024-11-15 09:04:11','456093265100327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 09:04:25.3260 1585 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 15/11/2024 09:05:26.7731 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:06:27.0023 1152 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 15/11/2024 09:06:41.6281 732 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 09:06:44.8412 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:06:50.3729 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 09:07:40.0211 647 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 09:07:40.8336 1596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 09:08:15.5578 3491 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:08:20.8213 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 09:09:27.4979 3146 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 09:09:39.2688 578 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 09:09:40.0973 762 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-15 09:09:39','V',5604251640819420,2024,'2024-11-15 09:09:38','456093297800327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 09:10:21.6941 730 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 09:10:37.3055 2673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:10:37.3055 638 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 15/11/2024 09:11:00.0567 1107 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-15 09:10:58','V',4796518357314090,2024,'2024-11-15 09:10:58','456093305800327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 09:12:54.0459 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:12:56.4525 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:13:01.7691 1242 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:13:07.1947 3221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:13:38.2384 2698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:14:55.9413 811 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-15 09:14:55','V',5640737721770440,2024,'2024-11-15 09:14:52','456093329200327005012999',1,2,16,'I','',1,0,1,'','0230004100099',144,0) 15/11/2024 09:16:00.3224 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 09:17:38.3759 573 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-15 09:14:58',6,'V',5324327808760260,5027278732772620,2024,'2024-11-15 09:14:58',4,1,0,4,'2024-11-15 09:29:58','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 15/11/2024 09:17:39.0743 604 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 371358 else acvFstPayId end),acvLstPayId = 371358 where acvSftId = 818 and acvCodeId = 3 15/11/2024 09:17:57.0443 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:20:25.0072 753 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 09:20:24','V',5055111165468010,2024,'2024-11-15 09:20:22','456093295700327005012999',2,2,2,'O','',0,'2024-11-15 09:20:24',1,'','',0) 15/11/2024 09:20:43.5386 954 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-15 09:20:42','0230003944081',0,0,4705939313056750,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 15/11/2024 09:20:49.0323 1000 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 09:20:53.1380 985 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 09:20:53.1930 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:20:55.8508 664 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/11/2024 09:23:48.5522 590 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-15 09:23:47','V',5159916476412830,2024,'2024-11-15 09:23:46','456093039200327005012999',2,2,2,'O','',0,'2024-11-15 09:23:47',1,'','',0) 15/11/2024 09:23:54.9865 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 09:25:45.5063 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:31:16.2433 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:32:26.4652 1424 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:33:07.7288 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:36:39.4823 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:37:43.8613 918 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-15 09:37:42','V',5285224974246380,2024,'2024-11-15 09:37:42','456093466200327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 09:40:59.7202 649 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 09:40:58','V',5534984496835270,2024,'2024-11-15 09:40:57','456093485700327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 09:41:00.2765 553 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 09:41:08.8633 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:42:20.5141 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:44:53.6064 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 09:44:54.0827 1023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:48:33.5474 555 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 09:48:43.3869 757 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 15/11/2024 09:48:52.8603 976 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 09:49:46.4731 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 09:51:59.0507 1316 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 09:51:57' where traUID = 4847683339467270 and traStatus='V' and traEnabled=1 15/11/2024 09:53:13.2843 997 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 15/11/2024 09:53:25.4464 614 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 09:55:08.1010 1455 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-15 09:55:06','V',5415927335407580,2024,'2024-11-15 09:55:06','456093570600327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 09:59:25.1447 619 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 15/11/2024 09:59:25.9232 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:01:05.6149 918 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:01:30.7737 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:02:03.4025 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:05:30.7780 5268 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 15/11/2024 10:07:26.0000 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:08:07.9380 632 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4968568703538920,4763272535269790,2024,'2024-11-15 10:08:07',' Date: 11/15/2024 10:05:27 AM Code: 456093386700327005012999 Entry Date: 11/15/2024 9:24:27 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 # 2400416163 ',0) 15/11/2024 10:11:28.3459 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:15:16.0831 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:15:42.6378 1561 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 10:15:40',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 15/11/2024 10:18:36.8822 1281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:18:48.5711 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:18:59.3563 712 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 10:19:12.9273 3131 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 10:19: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'; 15/11/2024 10:19:13.5187 590 ms. EXEC: update payInventory set invCreation = '2024-11-15 10:19:12',invModify = '2024-11-15 10:19:12',invUseId=0,invStatus='V' where invId = 219348 15/11/2024 10:19:14.6585 860 ms. EXEC: update paycash set casCreation = '2024-11-15 10:19:13',casModify = '2024-11-15 10:19:13',casUseId=0,casStatus='V' where casId = 194992 15/11/2024 10:19:27.1418 1328 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 10:19:32.0311 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:19:55.3437 608 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 10:19:54',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-15 10:19:54',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'; 15/11/2024 10:21:44.1143 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:21:44.8538 901 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-15 10:21:43','V',5149829752048170,2024,'2024-11-15 10:21:39','456093729900327005012999',1,2,16,'I','',1,0,1,'','0810007113876',103,0) 15/11/2024 10:21:45.4602 538 ms. EXEC: update abbCards set carLastDate = '2024-11-15 10:21:44',carLastDirection='I' where carStatus='V' and carId = 103 15/11/2024 10:22:22.5770 713 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:23:55.2089 1113 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-15 10:23:54','V',5381747410169770,2024,'2024-11-15 10:23:51','456093641600327001012999',2,2,2,'O','',0,'2024-11-15 10:23:54',1,'','',0) 15/11/2024 10:28:27.0005 1595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:29:43.0713 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:29:59.3662 588 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 10:30:42.0357 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:31:19.3076 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:33:26.9009 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:34:06.9877 957 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 15/11/2024 10:35:57.4605 634 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 10:36:22.3311 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:37:24.5487 2436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:38:24.7559 617 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-15 10:38:24','V',4815662742085100,2024,'2024-11-15 10:38:22','456093658500327005012999',2,2,2,'O','',0,'2024-11-15 10:38:24',1,'','',0) 15/11/2024 10:40:59.4613 739 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:41:03.5680 872 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/11/2024 10:41:04.8879 1292 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100 15/11/2024 10:41:16.2395 2512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:41:32.9296 2216 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:41:40.3316 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:42:22.4427 531 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-15 10:42:21','V',5673581052106040,2024,'2024-11-15 10:42:21','456093531500327005012999',2,2,2,'O','',0,'2024-11-15 10:42:21',1,'','',0) 15/11/2024 10:42:36.7473 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:42:51.9985 637 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-15 09:42:51') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-15 10:42:51' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-15 10:42:51' and (resAreId = 1 or resAreId <= 0) nr: 0 15/11/2024 10:42:52.0635 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:46:19.5912 752 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-15 10:46:18',4,6,'2024-11-15 10:46:18','456093806800327005012999','Payed (Credit Card ) Ticket ') 15/11/2024 10:46:24.2022 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:47:59.9582 526 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-15 10:47:59','V',5507111156756530,2024,'2024-11-15 10:47:58','456093848200327005012999',2,2,2,'O','',0,'2024-11-15 10:47:59',1,'','',0) 15/11/2024 10:48:06.0133 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 10:48:23.9532 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:48:46.6414 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:50:37.7697 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:50:55.4665 801 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 10:51:38.9655 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 10:51:58.3705 623 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 15/11/2024 10:54:55.1056 598 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 10:59:10.0980 556 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-15 10:59:09',0,16,'2024-11-15 10:59:09','','Unauthorized Transit Entry 2') 15/11/2024 10:59:40.5043 1196 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-15 10:59:39','V',4767640546301720,2024,'2024-11-15 10:59:38','456085472300327005012999',2,2,2,'O','',0,'2024-11-15 10:59:39',1,'','0230003950896',20,0) 15/11/2024 11:00:39.8920 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:08:13.7022 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:10:15.9208 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:10:21.9659 642 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 11:10:21','V',5278758100791310,2024,'2024-11-15 11:10:19','456093681500327005012999',2,2,2,'O','',0,'2024-11-15 11:10:21',1,'','',0) 15/11/2024 11:12:19.7566 510 ms. EXEC: update payReceipt set recCreation = '2024-11-15 11:12:19',recModify = '2024-11-15 11:12:19',recUseId=0,recStatus='V' where recId = 322762 15/11/2024 11:12:46.4234 538 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 11:12:45' where traUID = 5033831437830210 and traStatus='V' and traEnabled=1 15/11/2024 11:12:53.7443 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:13:18.2296 759 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 11:13:17','V',4772559304067670,2024,'2024-11-15 11:13:15','456093804300327005012999',2,2,2,'O','',0,'2024-11-15 11:13:17',1,'','',0) 15/11/2024 11:13:44.7473 1845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:14:21.5840 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:15:56.3262 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:15:58.2215 608 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 11:15:57','V',5132640362123850,2024,'2024-11-15 11:15:53','456093265100327005012999',2,2,2,'O','',0,'2024-11-15 11:15:57',1,'','',0) 15/11/2024 11:16:53.3974 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:17:00.7923 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:17:52.1847 679 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 15/11/2024 11:18:07.5299 569 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 11:18:16.8762 805 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:19:18.5264 724 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-15 11:19:17','V',5315267210595850,2024,'2024-11-15 11:19:16','456094075600327005012999',1,2,16,'I','',1,0,1,'','0560008421774',187,0) 15/11/2024 11:19:29.2865 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:19:30.7415 725 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 11:20:23.7159 822 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-15 11:20:22','V',5748698953514190,2024,'2024-11-15 11:20:22','456094082200327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 11:20:24.2753 555 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 11:23:01.1791 2269 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:26:03.2327 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:26:15.1087 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:26:34.0663 629 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 11:26:33',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'; 15/11/2024 11:26:48.5520 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:28:16.1946 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:30:02.6987 757 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456093815500327005012999' 15/11/2024 11:30:09.9126 805 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:33:52.4522 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:34:08.3799 1429 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/11/2024 11:35:00.8970 722 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49717, trcLastPrinted = '2400749717', trcLastDate = '2024-11-15 11:35:00' where trcStatus='V' and trcTerId = 18 15/11/2024 11:35:32.7382 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:37:21.6620 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:39:19.5778 1961 ms. EXEC: update payReceipt set recCreation = '2024-11-15 11:39:17',recModify = '2024-11-15 11:39:17',recUseId=0,recStatus='V' where recId = 322776 15/11/2024 11:40:57.2541 1231 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:43:49.5562 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:44:40.3551 912 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 11:44:39' where payTraUID = 5141719589462400 and payStatus='V' and payEnabled=1 15/11/2024 11:44:44.9402 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:44:56.9402 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 11:49:58.3226 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 11:50:16.4807 848 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-15 11:50:15',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 15/11/2024 11:58:01.4214 2006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:09:22.8136 824 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 12:09:21','V',5335062281833950,2024,'2024-11-15 12:09:20','456094376000327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 1 ms.) 15/11/2024 12:09:49.4944 860 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 12:11:55.1494 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:16:58.1218 758 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 12:16:57',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'; 15/11/2024 12:16:59.3136 1040 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 12:16:58',0,0,'V',5577744958977400,4824943150028280,2024,'2024-11-15 12:16:58',3,'KES',-1,50,-50,'N',''); 15/11/2024 12:19:38.9173 648 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 12:19:48.0454 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 12:20:12.1184 778 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 12:20:15.0654 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 12:20:30.4707 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:20:41.6262 780 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 12:20:40',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 12:20:40',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'; 15/11/2024 12:21:00.6158 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:21:48.9521 689 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 12:21:48' where traUID = 5175114426715850 and traStatus='V' and traEnabled=1 15/11/2024 12:22:36.0846 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 12:22:46.3215 1545 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 12:22:46.3225 1455 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:23:51.4300 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:27:44.0104 2336 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:28:30.3203 758 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 12:28:34.7372 513 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 12:30:43.0380 644 ms. OPEN: select * from tabDevice where devId = 4 and devStatus = 'V' 15/11/2024 12:30:59.0397 516 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 15/11/2024 12:32:58.0542 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:33:25.4215 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:36:25.0135 1417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:37:03.1700 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:37:03.1710 3041 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 12:38:06.5443 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:38:17.9299 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 12:40:02.0665 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:40:45.7116 1479 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-15 12:40:44','V',5089140371684770,2024,'2024-11-15 12:40:43','456094564300327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 12:40:52.2520 820 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 12:41:01.6383 780 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 12:42:24.6137 1936 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 12:42:22',0,0,'V',4634325539133370,5429813092109380,2024,'2024-11-15 12:42:22',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 12:42:22',0,0,'V',4634325539133370,5429813092109380,2024,'2024-11-15 12:42:22',3,'KES',-1,100,-100,'N',''); 15/11/2024 12:42:26.2268 1612 ms. EXEC: update paycash set casCreation = '2024-11-15 12:42:24',casModify = '2024-11-15 12:42:24',casUseId=0,casStatus='V' where casId = 195035 15/11/2024 12:42:28.4553 2228 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 12:42:22',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-15 12:42:22',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'; 15/11/2024 12:43:09.3746 608 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 15/11/2024 12:43:50.1549 534 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 12:45:41.1490 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 12:46:04.0253 684 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49724, trcLastPrinted = '2400749724', trcLastDate = '2024-11-15 12:46:03' where trcStatus='V' and trcTerId = 18 15/11/2024 12:47:41.9497 551 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/11/2024 12:49:26.5787 791 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-15 12:49:25','V',5750108776133260,2024,'2024-11-15 12:49:24','456094021500327005012999',2,2,2,'O','',0,'2024-11-15 12:49:25',1,'','',0) 15/11/2024 12:49:30.1130 723 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 12:50:17.0864 561 ms. OPEN: show columns from tabParameters where Field = 'parUseFloorCounter' 15/11/2024 12:50:24.2912 977 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 12:50:52.0468 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:53:48.4996 1131 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 12:53:47',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'; 15/11/2024 12:56:56.8975 632 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 12:56:56',0,0,'V',4626020301016470,5716932554381120,2024,'2024-11-15 12:56:56',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 12:56:56',0,0,'V',4626020301016470,5716932554381120,2024,'2024-11-15 12:56:56',3,'KES',-1,100,-100,'N',''); 15/11/2024 12:56:58.0183 1032 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 12:56:56',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 12:56:56',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'; 15/11/2024 12:57:13.6677 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 12:57:37.6948 526 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-15 12:54:57',6,'V',5121072600170070,5730878213395240,2024,'2024-11-15 12:54:57',4,1,0,4,'2024-11-15 13:09:57','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 15/11/2024 12:59:08.4604 1642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:05:53.5201 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:06:00.3666 942 ms. EXEC: update payReceipt set recCreation = '2024-11-15 13:05:59',recModify = '2024-11-15 13:05:59',recUseId=0,recStatus='V' where recId = 322813 15/11/2024 13:06:18.2706 1229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:06:27.7779 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:08:15.3208 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:08:18.2688 799 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-15 13:08:17','V',5671072316622140,2024,'2024-11-15 13:08:16','456094729600327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 13:08:42.5050 813 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-15 13:08:41','V',5628582414961860,2024,'2024-11-15 13:08:41','456094564300327005012999',2,2,2,'O','',0,'2024-11-15 13:08:41',1,'','',0) 15/11/2024 13:08:46.9399 775 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:09:51.0948 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:10:23.6395 570 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 15/11/2024 13:10:31.0445 929 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:12:05.7257 667 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 13:16:31.7185 1518 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 15/11/2024 13:17:36.2266 681 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 15/11/2024 13:18:23.5652 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:18:40.1102 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:24:05.7138 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:26:24.0552 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:30:56.0550 538 ms. EXEC: update payReceipt set recCreation = '2024-11-15 13:30:55',recModify = '2024-11-15 13:30:55',recUseId=0,recStatus='V' where recId = 322823 15/11/2024 13:31:06.1927 776 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-15 13:31:05','0560008421774',0,0,5164536650062610,187,'0000-00-00 00:00:00','0000-00-00 00:00:00') 15/11/2024 13:31:07.0403 510 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-15 13:31:06','V',5028712318280920,2024,'2024-11-15 13:31:04','456094075600327005012999',2,2,2,'O','',0,'2024-11-15 13:31:06',1,'','0560008421774',187,0) 15/11/2024 13:31:56.7225 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:32:38.4744 919 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:33:50.4575 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:34:26.7357 1394 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 13:34:25','V',5499693136112160,2024,'2024-11-15 13:34:24','456094489900327005012999',2,2,2,'O','',0,'2024-11-15 13:34:25',1,'','',0) 15/11/2024 13:34:32.8998 1707 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:34:47.6677 772 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 13:34:48.4052 728 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 13:42:00.8731 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:43:45.6111 1085 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49737, trcLastPrinted = '2400749737', trcLastDate = '2024-11-15 13:43:44' where trcStatus='V' and trcTerId = 18 15/11/2024 13:44:28.7860 933 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:47:39.1411 747 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:48:02.7309 820 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 13:48:01' where traUID = 4800589718647800 and traStatus='V' and traEnabled=1 15/11/2024 13:50:30.5387 722 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-15 13:50:29','V',5336397239307910,2024,'2024-11-15 13:50:28','456094664900327005012999',2,2,2,'O','',0,'2024-11-15 13:50:29',1,'','',0) 15/11/2024 13:55:10.8449 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 13:56:05.4124 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:56:31.8291 1442 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:56:45.0979 1311 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:57:27.8605 501 ms. EXEC: update paycash set casCreation = '2024-11-15 13:57:27',casModify = '2024-11-15 13:57:27',casUseId=0,casStatus='V' where casId = 195056 15/11/2024 13:57:30.2831 2236 ms. EXEC: update payInventory set invCreation = '2024-11-15 13:57:28',invModify = '2024-11-15 13:57:28',invUseId=0,invStatus='V' where invId = 219413 15/11/2024 13:57:34.5039 1554 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-15 13:57:32','V',5612587586656180,2024,'2024-11-15 13:57:31','456095025100327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 13:58:06.9456 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 13:58:41.9980 1137 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 13:58:43.4060 599 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 13:58:42' where traUID = 5058073999447660 and traStatus='V' and traEnabled=1 15/11/2024 14:00:21.6626 1122 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-15 14:00:20','V',5549974771278380,2024,'2024-11-15 14:00:18','456094836000327005012999',2,2,2,'O','',0,'2024-11-15 14:00:20',1,'','',0) 15/11/2024 14:00:22.2990 536 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 14:00:21' where payTraUID = 5342774383591830 and payStatus='V' and payEnabled=1 15/11/2024 14:00:22.3251 535 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4636940810992140,4938096227171830,2024,'2024-11-15 14:00:21','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/15/2024 1:39:34 PM Date : 11/15/2024 2:00:20 PM Code : 456094917400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 15/11/2024 14:00:24.1663 619 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 14:00:23',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 15/11/2024 14:06:56.9817 627 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 14:06:56',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'; 15/11/2024 14:07:00.8803 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:09:32.1754 684 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/11/2024 14:10:17.3746 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:10:48.5545 1379 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:13:06.6027 578 ms. EXEC: update paycash set casCreation = '2024-11-15 14:13:06',casModify = '2024-11-15 14:13:06',casUseId=0,casStatus='V' where casId = 195061 15/11/2024 14:16:00.0636 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:16:50.8215 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:19:31.8231 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:21:29.3176 986 ms. EXEC: update payReceipt set recCreation = '2024-11-15 14:21:28',recModify = '2024-11-15 14:21:28',recUseId=0,recStatus='V' where recId = 322853 15/11/2024 14:22:19.2960 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:22:46.3010 680 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:23:13.4061 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:23:32.2467 1464 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 14:23:30',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'; 15/11/2024 14:23:32.9021 601 ms. EXEC: update payInventory set invCreation = '2024-11-15 14:23:32',invModify = '2024-11-15 14:23:32',invUseId=0,invStatus='V' where invId = 219419 15/11/2024 14:24:08.5350 612 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 14:24:18.0463 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-15 14:24:17','V',4760019326986880,2024,'2024-11-15 14:24:13','456094994500327005012999',2,2,2,'O','',0,'2024-11-15 14:24:17',1,'','',0) 15/11/2024 14:27:39.1787 1626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:32:04.7641 1930 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 15/11/2024 14:32:05.7458 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:32:36.3452 1878 ms. EXEC: update payInventory set invCreation = '2024-11-15 14:32:34',invModify = '2024-11-15 14:32:34',invUseId=0,invStatus='V' where invId = 219421 15/11/2024 14:35:49.4643 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:36:04.1191 640 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 371521 else acvFstPayId end),acvLstPayId = 371521 where acvSftId = 826 and acvCodeId = 3 15/11/2024 14:37:30.4497 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:37:47.9264 697 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 14:37:47',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'; 15/11/2024 14:37:58.1603 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:38:39.8221 516 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 121 ms.) 15/11/2024 14:38:50.2481 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:39:07.9879 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-15 14:39:07','V',5718933679461160,2024,'2024-11-15 14:39:05','456094701500327005012999',2,2,2,'O','',0,'2024-11-15 14:39:07',1,'','',0) 15/11/2024 14:40:03.5170 1389 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 14:43:10.3869 740 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/11/2024 14:43:13.2978 507 ms. EXEC: update paycash set casCreation = '2024-11-15 14:43:12',casModify = '2024-11-15 14:43:12',casUseId=0,casStatus='V' where casId = 195066 15/11/2024 14:43:52.6911 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:44:20.5858 566 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 14:44:32.4057 2246 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 14:44:30' where payTraUID = 5408898869741500 and payStatus='V' and payEnabled=1 15/11/2024 14:47:55.5324 554 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 14:47:54' where traUID = 5498389070436480 and traStatus='V' and traEnabled=1 15/11/2024 14:47:59.2799 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:49:54.9802 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:50:45.9222 656 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 14:54:05.5396 735 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-15 14:54:03',0,'V',5273467401019270,5038818866782580,2024,'2024-11-15 14:54:03',3,1,0,4,'2024-11-15 15:09:03','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 15/11/2024 14:54:06.9886 689 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 14:54:05',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'; 15/11/2024 14:56:01.2319 785 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-15 14:56:00','V',5314330548036240,2024,'2024-11-15 14:55:58','456095298700327005012999',2,2,2,'O','',0,'2024-11-15 14:56:00',1,'','',0) 15/11/2024 14:56:05.0204 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 14:57:24.4715 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:57:56.4789 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 14:59:33.2325 971 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 14:59:32' where traUID = 4787994021504260 and traStatus='V' and traEnabled=1 15/11/2024 15:01:30.8011 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:01:31.6587 1334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:02:20.3162 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:02:21.0487 770 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-15 15:00:08',12,'V',5107047265846430,4813296725547890,2024,'2024-11-15 15:00:08',17,1,0,4,'2024-11-15 15:15:08','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 15/11/2024 15:02:49.3165 837 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-15 15:02:48' where subId = 208 15/11/2024 15:03:17.0281 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:03:26.9757 562 ms. EXEC: update payReceipt set recCreation = '2024-11-15 15:03:26',recModify = '2024-11-15 15:03:26',recUseId=0,recStatus='V' where recId = 322869 15/11/2024 15:04:26.0862 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:10:36.6658 1200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:11:03.8940 1229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:11:35.7523 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:15:13.7199 850 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-15 15:15:12',0,'V',4648296831141990,5347284074828870,2024,'2024-11-15 15:15:12',2,1,0,-1,'2024-11-15 16:15:12','S','KES',0,0,0,'','','',3,0,0) 15/11/2024 15:15:44.2283 965 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 15:15:43',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-15 15:15:43',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'; 15/11/2024 15:15:50.7016 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:17:28.3218 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:18:01.0907 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:21:24.8549 733 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 15:21:24','V',5011744040998940,2024,'2024-11-15 15:21:23','456095359900327005012999',2,2,2,'O','',0,'2024-11-15 15:21:24',1,'','',0) 15/11/2024 15:21:26.0567 845 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 15:21:25' where payTraUID = 5450585503577560 and payStatus='V' and payEnabled=1 15/11/2024 15:21:27.7258 1668 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 15:21:25' where traUID = 5450585503577560 and traStatus='V' and traEnabled=1 15/11/2024 15:21:31.1541 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:22:05.2999 881 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 15/11/2024 15:22:42.0795 836 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 15:22:41','V',5214749502752160,2024,'2024-11-15 15:22:40','456095315500327005012999',2,2,2,'O','',0,'2024-11-15 15:22:41',1,'','',0) 15/11/2024 15:24:56.8685 803 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456094860600327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 15/11/2024 15:26:55.1936 604 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 15:28:32.9169 1286 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-15 15:28:31','V',5749650279615750,2024,'2024-11-15 15:28:30','456095500800327005012999',2,2,2,'O','',0,'2024-11-15 15:28:31',1,'','',0) 15/11/2024 15:28:33.0640 1338 ms. EXEC: update payReceipt set recCreation = '2024-11-15 15:28:31',recModify = '2024-11-15 15:28:31',recUseId=0,recStatus='V' where recId = 322889 15/11/2024 15:28:34.3078 598 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 15:28:33' where traUID = 5348778139756130 and traStatus='V' and traEnabled=1 15/11/2024 15:28:38.5466 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:28:38.6667 874 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 15/11/2024 15:29:05.7808 935 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-15 15:29:04','V',4659398109488850,2024,'2024-11-15 15:29:03','456095241600327005012999',2,2,2,'O','',0,'2024-11-15 15:29:04',1,'','',0) 15/11/2024 15:29:11.4106 1507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:30:00.3773 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:32:45.5297 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:33:39.8099 1309 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:34:29.2540 744 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:34:45.4918 951 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 15:37:16.1575 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:37:37.6718 1403 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:44:38.5100 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:44:43.7725 637 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 15:45:21.7179 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:46:33.2717 871 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:46:43.8318 817 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 15:46:42',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'; 15/11/2024 15:46:46.6186 2785 ms. EXEC: update payInventory set invCreation = '2024-11-15 15:46:43',invModify = '2024-11-15 15:46:43',invUseId=0,invStatus='V' where invId = 219447 15/11/2024 15:47:39.8532 834 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-15 15:47:39','V',5678976345337390,2024,'2024-11-15 15:47:37','456095685700327001012999',1,2,1,'I','',1,0,1,'','0230003943530',44,0) 15/11/2024 15:47:39.9883 1627 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 15:47:38',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'; 15/11/2024 15:47:40.8469 858 ms. EXEC: update payInventory set invCreation = '2024-11-15 15:47:39',invModify = '2024-11-15 15:47:39',invUseId=0,invStatus='V' where invId = 219448 15/11/2024 15:47:41.5223 1666 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 15:47:46.7088 1018 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-15 15:47:45',0,'V',4991239791918880,4888673395346630,2024,'2024-11-15 15:47:45',18,1,0,4,'2024-11-15 16:02:45','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 15/11/2024 15:48:15.8422 1214 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 15:48:14' where payTraUID = 4740434674326920 and payStatus='V' and payEnabled=1 15/11/2024 15:48:21.3639 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:50:01.8751 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:50:26.1113 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:50:38.8918 934 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 15:50:44.4595 664 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentCustomers' 15/11/2024 15:50:45.2621 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:50:52.4058 1096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 15:51:01.2508 670 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 15:52:38.5227 654 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-15 15:52:37','V',4878829888307850,2024,'2024-11-15 15:52:34','456095669800327005012999',2,2,2,'O','',0,'2024-11-15 15:52:37',1,'','',0) 15/11/2024 15:52:51.4534 713 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 15:56:25.6135 539 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 15/11/2024 15:58:10.1593 753 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-15 15:58:09','V',5077596055289780,2024,'2024-11-15 15:58:08','456095748800327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 16:00:11.2282 697 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 16:00:16.6668 950 ms. EXEC: update payReceipt set recCreation = '2024-11-15 16:00:15',recModify = '2024-11-15 16:00:15',recUseId=0,recStatus='V' where recId = 322913 15/11/2024 16:00:49.5578 1230 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 16:00:48' where traUID = 5536657369498970 and traStatus='V' and traEnabled=1 15/11/2024 16:03:08.7978 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:03:19.7422 655 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 16:03:27.1411 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:09:40.6797 864 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-15 16:09:39',0,'V',4750107406715200,4977853032716010,2024,'2024-11-15 16:09:39',18,1,0,4,'2024-11-15 16:24:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 15/11/2024 16:12:28.6479 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:15:31.5371 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:15:43.2699 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:18:27.5647 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:21:13.3555 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:21:52.3145 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:23:10.5218 577 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 16:23:09' where payTraUID = 5011879422256770 and payStatus='V' and payEnabled=1 15/11/2024 16:23:21.3020 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:27:01.8943 1646 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 16:27:17.4167 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 16:28:22.7494 520 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 16:28:43.1640 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:29:12.0233 552 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-15 16:29:11','V',5235342495561320,2024,'2024-11-15 16:29:10','456094744100327005012999',2,2,2,'O','',0,'2024-11-15 16:29:11',1,'','0230004101201',9,0) 15/11/2024 16:29:12.9359 897 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 16:29:14.0907 1081 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 16:29:43.9666 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:32:16.8198 647 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-15 16:32:16','V',4896081373757940,2024,'2024-11-15 16:32:15','456095917100327005012999',2,2,2,'O','',0,'2024-11-15 16:32:16',1,'','',0) 15/11/2024 16:32:22.1703 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:32:51.0636 702 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 15/11/2024 16:37:17.5717 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:38:01.8273 2377 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:39:14.6129 518 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-15 16:39:13',0,'V',5068113895522050,5661845712106700,2024,'2024-11-15 16:39:13',18,1,0,4,'2024-11-15 16:54:13','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 15/11/2024 16:40:20.2678 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:40:20.7091 1149 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 15/11/2024 16:41:06.3966 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:42:02.1919 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 16:42:08.6222 1233 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 371616 else acvFstPayId end),acvLstPayId = 371616 where acvSftId = 818 and acvCodeId = 3 15/11/2024 16:43:18.3758 858 ms. EXEC: update payReceipt set recCreation = '2024-11-15 16:43:17',recModify = '2024-11-15 16:43:17',recUseId=0,recStatus='V' where recId = 322942 15/11/2024 16:44:09.7491 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:45:28.1415 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:47:03.8224 1151 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 16:47:08.9598 848 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 16:51:32.0336 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 16:53:27.0685 562 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-15 16:53:26','0230003957466',0,0,4823596754617650,21,'0000-00-00 00:00:00','0000-00-00 00:00:00') 15/11/2024 16:53:35.5671 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:00:41.5447 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:00:57.2072 639 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-15 17:00:56' where subId = 108 15/11/2024 17:01:04.5231 821 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-15 17:01:03',0,'V',5620804585238960,4968468054718730,2024,'2024-11-15 17:01:03',18,1,0,4,'2024-11-15 17:16:03','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 15/11/2024 17:01:06.2422 1046 ms. EXEC: update payReceipt set recCreation = '2024-11-15 17:01:05',recModify = '2024-11-15 17:01:05',recUseId=0,recStatus='V' where recId = 322950 15/11/2024 17:02:33.9899 1518 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 17:02:33.9899 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 17:02:42.5386 769 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:02:43.3681 537 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 15/11/2024 17:02:43.7764 1555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:02:46.2010 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 17:02:52.8545 564 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-15 17:02:52','V',4759252293308380,2024,'2024-11-15 17:02:50','456094179300327005012999',2,2,2,'O','',0,'2024-11-15 17:02:52',1,'','0230004101223',11,0) 15/11/2024 17:02:53.8611 512 ms. EXEC: update abbCards set carLastDate = '2024-11-15 17:02:53',carLastDirection='O' where carStatus='V' and carId = 11 15/11/2024 17:03:00.3565 1247 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:03:04.8975 851 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-15 17:03:03',0,'V',5221926736962140,5411140928909840,2024,'2024-11-15 17:03:03',3,1,0,4,'2024-11-15 17:18:03','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 15/11/2024 17:03:25.5393 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:04:00.3686 890 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:06:56.8925 1057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 17:07:17.3562 514 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 17:07:16' where traUID = 5063845567931380 and traStatus='V' and traEnabled=1 15/11/2024 17:10:10.5099 678 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 17:15:17.6251 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:18:18.1707 1329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 17:19:44.4504 545 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCarId = 186 15/11/2024 17:19:45.3850 810 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 17:19:43' where traUID = 5424939992083780 and traStatus='V' and traEnabled=1 15/11/2024 17:27:50.6102 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 17:28:04.1422 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 17:28:54.9261 545 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 17:28:54',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'; 15/11/2024 17:30:21.4480 1371 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-15 17:30:20','V',5175479323003610,2024,'2024-11-15 17:30:19','456096254000327005012999',2,2,2,'O','',0,'2024-11-15 17:30:20',1,'','',0) 15/11/2024 17:30:25.3075 784 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:36:35.7811 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 17:38:37.3553 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:40:02.6743 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 17:43:43.7220 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 17:47:29.0415 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:11:14.7421 958 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 18:12:36.6798 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:13:19.6926 632 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-15 18:13:19','0230003944059',0,0,5351591542397480,13,'0000-00-00 00:00:00','0000-00-00 00:00:00') 15/11/2024 18:13:48.1536 864 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 18:14:13.0852 1080 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 18:14:11',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-15 18:14:11',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'; 15/11/2024 18:17:21.8644 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:19:15.1040 788 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 18:19:57.4413 913 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCarID = 25 15/11/2024 18:20:02.3586 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 18:22:15.4075 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:22:40.1811 565 ms. EXEC: update payReceipt set recCreation = '2024-11-15 18:22:39',recModify = '2024-11-15 18:22:39',recUseId=0,recStatus='V' where recId = 322974 15/11/2024 18:23:40.9326 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:24:23.1879 1636 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 15/11/2024 18:25:55.2244 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:28:17.9207 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 18:28:50.9968 567 ms. EXEC: update paycash set casCreation = '2024-11-15 18:28:50',casModify = '2024-11-15 18:28:50',casUseId=0,casStatus='V' where casId = 195133 15/11/2024 18:28:52.1065 1109 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 18:28:50',3,42101,0,50,2,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 15/11/2024 18:30:19.1957 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:30:43.3489 906 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-15 18:30:42','V',5447336753494690,2024,'2024-11-15 18:30:41','456096479400327005012999',2,2,2,'O','',0,'2024-11-15 18:30:42',1,'','',0) 15/11/2024 18:31:25.6191 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:35:15.5107 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:38:02.6074 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:38:42.7672 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:42:27.0050 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 18:52:18.3751 900 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-15 18:52:17','V',4990910705830960,2024,'2024-11-15 18:52:14','456092871100327005012999',2,2,2,'O','',0,'2024-11-15 18:52:17',1,'','0230003943861',31,0) 15/11/2024 18:56:32.0996 543 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 18:59:38.2830 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:00:49.3545 1414 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-15 19:00:47','V',5357245578229340,2024,'2024-11-15 19:00:47','456096521300327005012999',2,2,2,'O','',0,'2024-11-15 19:00:47',1,'','',0) 15/11/2024 19:00:55.6667 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 19:06:40.5282 892 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 19:09:15.2265 565 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 19:09:45.8760 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:10:48.7020 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:12:08.7134 850 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-15 19:12:06',0,'V',4801449467759110,5113989752760940,2024,'2024-11-15 19:12:06',3,1,0,4,'2024-11-15 19:27:06','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 15/11/2024 19:14:29.0172 539 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '778341' and traDirection='I' order by traId DESC LIMIT 1 15/11/2024 19:15:09.2460 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 19:16:57.1732 1357 ms. EXEC: update payReceipt set recCreation = '2024-11-15 19:16:55',recModify = '2024-11-15 19:16:55',recUseId=0,recStatus='V' where recId = 322995 15/11/2024 19:24:08.8676 512 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/11/2024 19:25:51.9324 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:33:49.5105 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:36:21.2959 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:42:22.1540 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:44:05.3470 1484 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-15 19:44:03',0,'V',4809052131198700,4909662120695950,2024,'2024-11-15 19:44:03',3,1,0,4,'2024-11-15 19:59:03','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 15/11/2024 19:44:07.0031 521 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 19:44:06',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'; 15/11/2024 19:44:07.2683 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 9 ms.) 15/11/2024 19:45:21.7621 729 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 19:48:41.4765 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 19:51:04.7932 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:51:20.2566 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 19:59:56.9968 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:03:09.0732 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:03:20.7249 1452 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 20:10:47.8727 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:14:23.4377 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:15:42.3214 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:20:43.6297 583 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-15 20:20:40',0,'V',4852071669150440,5334075008190020,2024,'2024-11-15 20:20:40',3,1,0,4,'2024-11-15 20:35:40','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 15/11/2024 20:22:40.9071 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 20:23:04.6540 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 20:23:14.0572 602 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 20:25:08.2335 568 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-15 20:25:07','V',4987573977162860,2024,'2024-11-15 20:25:07','456097350700327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 20:25:43.2499 757 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 20:32:50.5024 1269 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 15/11/2024 20:33:25.1225 721 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 20:33:47.0662 869 ms. EXEC: update payReceipt set recCreation = '2024-11-15 20:33:46',recModify = '2024-11-15 20:33:46',recUseId=0,recStatus='V' where recId = 323008 15/11/2024 20:33:47.9968 912 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 20:33:47',0,0,'V',5662687977968130,4868760108627900,2024,'2024-11-15 20:33:47',3,'KES',1,50,50,'N',''); 15/11/2024 20:34:53.7307 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:34:53.7798 754 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 20:35:15.8485 579 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-15 20:35:15',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 15/11/2024 20:37:10.3690 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 20:37:10.8573 1072 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 15/11/2024 20:37:10.8583 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:39:30.5026 752 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456097181500327005012999' 15/11/2024 20:41:36.7760 794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 20:43:34.2345 582 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-15 20:43:33','V',5543497357180620,2024,'2024-11-15 20:43:33','456097461300327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 20:44:23.9389 751 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 20:44:27.3561 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 20:44:28.4098 1017 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 15/11/2024 20:45:31.7231 503 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-15 20:45:31','V',5483077460036280,2024,'2024-11-15 20:45:30','456097281200327005012999',2,2,2,'O','',0,'2024-11-15 20:45:31',1,'','',0) 15/11/2024 20:47:51.6166 658 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 20:47:50' where payTraUID = 5464303643374220 and payStatus='V' and payEnabled=1 15/11/2024 20:47:54.1963 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 20:49:26.3829 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:51:36.2367 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:55:42.6673 1308 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 20:55:41' where traUID = 4846064679764350 and traStatus='V' and traEnabled=1 15/11/2024 20:57:02.3796 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:57:13.0087 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 20:57:25.5180 563 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 20:57:24' where payTraUID = 4912911999717270 and payStatus='V' and payEnabled=1 15/11/2024 21:05:43.5408 817 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-15 21:05:42','V',5260365423382310,2024,'2024-11-15 21:05:42','456097594200327005012999',1,2,16,'I','',1,0,1,'','',4) 15/11/2024 21:09:59.9251 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:22:54.0293 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 21:26:16.4405 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:26:37.0433 1063 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 21:30:37.3589 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:33:46.0279 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:35:48.2696 685 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5306145700006030,5022419973338220,2024,'2024-11-15 21:35:47',' Date: 11/15/2024 9:35:47 PM Code: 456097162000327005012999 Entry Date: 11/15/2024 7:53:40 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 # 2400749826 ',0) 15/11/2024 21:39:20.8176 1026 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-15 21:39:19',0,'V',5363322693936550,5197852836785690,2024,'2024-11-15 21:39:19',18,1,0,4,'2024-11-15 21:54:19','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 15/11/2024 21:39:24.4791 1845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:42:15.2001 583 ms. OPEN: select last_insert_id() as vLast 15/11/2024 21:42:15.7545 554 ms. EXEC: update payReceipt set recCreation = '2024-11-15 21:42:15',recModify = '2024-11-15 21:42:15',recUseId=0,recStatus='V' where recId = 323025 15/11/2024 21:42:22.8843 1198 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-15 21:42:21','V',5322903107021750,2024,'2024-11-15 21:42:20','456097627900327005012999',2,2,2,'O','',0,'2024-11-15 21:42:21',1,'','',0) 15/11/2024 21:42:25.1488 1404 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 21:42:23' where payTraUID = 5665502757085260 and payStatus='V' and payEnabled=1 15/11/2024 21:44:44.3198 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:45:33.8378 1090 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-15 21:45:32',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 15/11/2024 21:45:34.8785 1720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:45:34.9456 1046 ms. EXEC: update payInventory set invCreation = '2024-11-15 21:45:33',invModify = '2024-11-15 21:45:33',invUseId=0,invStatus='V' where invId = 219515 15/11/2024 21:46:23.7202 753 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 21:46:23.8102 596 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 15/11/2024 21:46:24.2075 906 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 15/11/2024 21:47:36.8300 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:48:41.2000 2019 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 21:48:45.5179 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 21:48:54.5319 1272 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 21:51:23.4544 988 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 21:51:22',0,0,'V',4676109428241350,5056001851680850,2024,'2024-11-15 21:51:22',3,'KES',1,100,100,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-15 21:51:22',0,0,'V',4676109428241350,5056001851680850,2024,'2024-11-15 21:51:22',3,'KES',1,50,50,'N',''); 15/11/2024 21:52:40.7601 523 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-15 21:52:40','V',4611901354593310,2024,'2024-11-15 21:52:38','456097484000327005012999',2,2,2,'O','',0,'2024-11-15 21:52:40',1,'','',0) 15/11/2024 21:58:37.8807 599 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 44 15/11/2024 21:59:49.4065 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:01:28.8499 785 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 22:02:07.7669 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:04:55.3449 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:05:01.4520 560 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-15 22:05:00',0,'V',5034976152878370,4844743340544560,2024,'2024-11-15 22:05:00',18,1,0,4,'2024-11-15 22:20:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 15/11/2024 22:05:05.4076 2445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:05:19.9983 853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:10:09.4237 2112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:16:53.0834 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 22:19:47.1167 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:26:53.6817 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:28:05.2795 1086 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 22:28:05.8970 577 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 22:28:05' where traUID = 4972620318511920 and traStatus='V' and traEnabled=1 15/11/2024 22:28:06.2442 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:28:11.4326 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 22:29:22.3440 543 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 15/11/2024 22:30:43.7154 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:36:38.6545 1979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:38:17.5406 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:39:27.0721 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:40:08.5068 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:40:23.8840 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:40:35.4818 1045 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:41:33.5556 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:42:45.2975 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:43:37.3793 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:44:24.3927 537 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 15/11/2024 22:51:38.1255 653 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-15 22:49:25',12,'V',5096343614783080,4853878604657740,2024,'2024-11-15 22:49:25',17,1,0,4,'2024-11-15 23:04:25','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 15/11/2024 22:51:39.8697 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 22:57:27.2688 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 23:00:07.7880 580 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-15 23:00:07',0,'V',5139365463204990,4958271699371130,2024,'2024-11-15 23:00:07',2,1,0,-1,'2024-11-16 00:00:07','S','KES',0,0,0,'','','',3,0,0) 15/11/2024 23:00:08.7197 920 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-15 23:00:07','V',5461295744211290,2024,'2024-11-15 23:00:02','456098269000327001012999',2,2,2,'O','',0,'2024-11-15 23:00:07',1,'','0230003944081',15,0) 15/11/2024 23:00:28.1797 652 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 23:00:29.3965 810 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-15 23:00:28' where payTraUID = 4804993644703620 and payStatus='V' and payEnabled=1 15/11/2024 23:02:30.5344 1262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 23:09:10.3415 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 23:11:58.0056 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 23:19:40.1383 2275 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 23:26:00.8277 769 ms. EXEC: update paycash set casCreation = '2024-11-15 23:26:00',casModify = '2024-11-15 23:26:00',casUseId=0,casStatus='V' where casId = 195163 15/11/2024 23:26:33.1323 899 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 23:26:50.8931 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 23:26:58.4232 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 23:28:06.2905 1019 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/11/2024 23:28:08.2558 1954 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 15/11/2024 23:37:30.8617 895 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 15/11/2024 23:40:53.3490 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 23:42:55.3275 619 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 23:42:54' where traUID = 5465622960126520 and traStatus='V' and traEnabled=1 15/11/2024 23:52:16.9497 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 15/11/2024 23:54:45.1998 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/11/2024 23:56:21.3640 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1