27/10/2024 00:26:52.3119 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 00:27:45.7985 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 00:40:46.5266 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 00:45:26.6613 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 00:57:05.8911 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 01:59:04.1303 543 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 02:04:06.2115 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:12:52.0509 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:12:52.0509 1022 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 02:12:58.7493 648 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 27/10/2024 02:13:59.8600 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:14:11.4818 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:14:14.1486 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:14:15.6306 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:14:20.0735 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:14:44.2786 2864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:15:34.8123 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:23:30.3641 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:24:47.2123 1696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:27:19.7359 1006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:32:28.4076 590 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 02:34:44.6023 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:35:39.1226 532 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 02:41:49.1792 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:48:56.3037 515 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/10/2024 02:50:53.6549 1237 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 02:51:05.4368 561 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 02:51:08.4218 1949 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 02:56:49.9963 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:00:24.3041 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:02:20.6976 1955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:05:31.9280 4732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:07:37.6288 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:07:54.7912 2095 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:11:17.0850 1809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:11:39.5720 869 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/10/2024 03:13:37.9909 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:13:54.2327 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:14:09.6440 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:18:21.4527 3173 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:20:43.3062 2680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:22:59.9823 2477 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:23:22.4693 2540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:23:48.3095 2852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:26:29.3097 2555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:34:25.1808 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:40:24.1349 885 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:45:26.2182 1368 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:52:51.0345 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:54:24.1135 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:56:04.3123 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 03:56:36.5678 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 04:14:38.1473 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 04:19:07.0345 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 04:20:33.9964 918 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 04:27:59.4422 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 04:30:10.4415 2254 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 04:37:53.0106 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 04:38:20.7061 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 04:41:44.7980 560 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 04:47:39.7385 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 04:48:20.7849 565 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 04:53:19.9712 1037 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 27/10/2024 05:00:42.4470 1957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:03:40.1814 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:05:35.6583 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:07:05.6583 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:20:01.6673 1541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:20:56.0855 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:22:11.2106 627 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/10/2024 05:22:19.9084 1271 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-10-27 05:22:18','V',5373163184233040,2024,'2024-10-27 05:22:16','455901933600327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 05:23:50.5558 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:24:58.6801 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:29:56.1123 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:33:33.4791 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:35:36.3910 1845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:41:34.1383 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:48:57.8429 2675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:51:42.7408 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 05:54:56.1356 1283 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:05:25.1747 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:08:15.5282 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:21:17.7974 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:23:29.7943 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:25:33.3206 1617 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 06:26:28.7666 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:28:51.4836 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:30:07.4292 1799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:33:47.5109 4103 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:42:31.2808 1244 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:43:41.9359 4374 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:45:15.8685 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:48:08.3984 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:48:43.7229 578 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/10/2024 06:54:56.4753 1313 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:55:50.6894 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 06:56:03.6840 1712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:00:05.7113 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 07:00:32.2870 1049 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 07:00:31',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 27/10/2024 07:00:33.1826 765 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='455902457000327005012999' 27/10/2024 07:04:31.1902 1119 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 07:07:37.3292 1361 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:10:42.9688 1655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:11:02.1466 1088 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:17:22.3369 1461 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:22:01.7691 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:23:00.7844 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:24:59.7456 1651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:26:10.9221 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:29:31.2785 634 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 07:35:02.4952 1205 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 27/10/2024 07:35:39.4238 2172 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:37:59.2310 1099 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:39:07.0391 1878 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 07:40:16.1932 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 07:43:27.8709 541 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 07:50:45.8897 715 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 07:51:08.7590 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:00:06.7904 709 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 08:00:12.5873 4548 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-10-27 08:00:08',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 27/10/2024 08:00:13.5869 998 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 08:00:12',1,2,'2024-10-27 08:00:12','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 27/10/2024 08:00:44.6867 1591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:01:10.6930 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:07:29.9877 852 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-10-27 08:07:28',0,'V',5690081787365430,5181337739638040,2024,'2024-10-27 08:07:28',3,1,0,4,'2024-10-27 08:22:28','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 08:07:33.4300 2829 ms. EXEC: update payInventory set invCreation = '2024-10-27 08:07:30',invModify = '2024-10-27 08:07:30',invUseId=0,invStatus='V' where invId = 215532 27/10/2024 08:07:38.2562 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:08:12.4019 786 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:08:54.1257 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:10:11.2991 644 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 = 1 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 27/10/2024 08:10:17.3982 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:10:34.3435 744 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 08:12:04.6927 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:12:34.2424 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:14:41.3170 1141 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/10/2024 08:14:44.2620 1679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:14:44.2860 1017 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 08:14:49.5325 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:14:52.6576 1157 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4797415334929140,4740381312170830,2024,'2024-10-27 08:14:51','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/27/2024 7:53:53 AM Date : 10/27/2024 8:14:49 AM Code : 455902843300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 27/10/2024 08:14:58.9037 1668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:15:00.8290 1187 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:15:03.6099 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:16:31.1422 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:18:37.8686 1608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:19:18.1174 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:20:34.4093 1715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:23:03.9789 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:24:04.8895 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:25:58.4021 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:26:36.7206 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:26:58.6523 1321 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:30:34.0167 1264 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 08:33:46.4349 1561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:35:47.8058 1585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:37:09.6563 593 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 08:41:41.3213 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:41:42.9674 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:42:37.3026 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:43:47.4023 2279 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 08:45:29.2362 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:46:56.9156 1942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:47:00.8372 648 ms. EXEC: update payInventory set invCreation = '2024-10-27 08:47:00',invModify = '2024-10-27 08:47:00',invUseId=0,invStatus='V' where invId = 215534 27/10/2024 08:48:22.3165 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:48:48.5529 2177 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 27/10/2024 08:48:48.5539 1987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:48:49.0683 1324 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 08:49:14.3011 2203 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:49:14.4192 817 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 27/10/2024 08:49:55.4245 1557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:51:35.7763 844 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 08:53:34.7946 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:53:44.6172 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:53:55.6005 1213 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:54:13.6635 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:54:17.5311 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:55:07.8967 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:55:15.3827 737 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 08:55:16.5604 1128 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 08:58:07.4523 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 08:58:22.9186 1204 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 08:58:25.2692 546 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-27 08:58:24','V',5443812531633830,2024,'2024-10-27 08:58:23','455903230300327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 09:02:37.1250 4056 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',5,3,42101,0,50,-17,-850,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',5,3,42101,0,50,17,850,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',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-10-27 09:02:22',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-10-27 09:02:22',5,3,42101,0,200,-2,-400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',5,3,42101,0,200,2,400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',5,3,42101,0,500,-6,-3000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',5,3,42101,0,500,6,3000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:22',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 27/10/2024 09:02:39.0202 1098 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:27',5,3,42101,0,50,-19,-950,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:27',5,3,42101,0,100,-30,-3000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:27',5,3,42101,0,200,-2,-400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:27',5,3,42101,0,500,-6,-3000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:27',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:02:27',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 27/10/2024 09:03:33.4535 1656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:05:01.3901 902 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-10-27 09:04:58',0,'V',4755661153422160,5561566595503490,2024,'2024-10-27 09:04:58',3,1,0,4,'2024-10-27 09:19:58','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 09:05:03.1332 679 ms. EXEC: update payInventory set invCreation = '2024-10-27 09:05:02',invModify = '2024-10-27 09:05:02',invUseId=0,invStatus='V' where invId = 215563 27/10/2024 09:05:11.8600 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:05:19.3300 516 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 09:05:18',0,3,'2024-10-27 09:05:18','0230003944086','POF - User Transit Supervisor Supervisor') 27/10/2024 09:06:27.4094 1303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:06:49.5631 3230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:07:19.9594 1729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:08:45.6895 753 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:08:39',5,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'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-27 09:08:39',5,3,42101,0,100,5,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+5,5),curAmount=round(curAmount+500,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; 27/10/2024 09:08:52.5140 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-10-27 09:08:51','V',5748324826142800,2024,'2024-10-27 09:08:49','455900000400327003229999',22,22,3,'I','',1,0,1,'','',2) 27/10/2024 09:09:09.1952 875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:10:21.0320 518 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/10/2024 09:10:56.4516 526 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 27/10/2024 09:11:50.5437 778 ms. EXEC: update payInventory set invCreation = '2024-10-27 09:11:49',invModify = '2024-10-27 09:11:49',invUseId=0,invStatus='V' where invId = 215573 27/10/2024 09:12:32.8228 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:13:36.5313 2371 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:13:38.2404 5041 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 09:13:33' where payTraUID = 5662646728188890 and payStatus='V' and payEnabled=1 27/10/2024 09:13:47.1343 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 09:14:02.1703 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 09:14:26.7627 1212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:14:56.4125 575 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 27/10/2024 09:18:37.9030 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:20:29.9767 560 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 09:20:29' where payTraUID = 5443812531633830 and payStatus='V' and payEnabled=1 27/10/2024 09:20:36.0357 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:20:42.0778 564 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 09:20:42.9103 766 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 09:20:44.4914 1588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:22:45.9673 1051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:23:25.7378 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:23:53.3072 568 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-10-27 09:23:50',0,'V',4729583699220540,4645452880277400,2024,'2024-10-27 09:23:50',3,1,0,4,'2024-10-27 09:38:50','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 09:25:02.6224 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:26:57.4789 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:30:43.3814 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:33:56.8713 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:35:15.6177 1201 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:36:13.0580 518 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 27/10/2024 09:37:48.0813 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:40:10.2210 1611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:46:37.7752 521 ms. OPEN: select * from movTransit where traStatus = 'V' and traCode='455896829400327005012999' and traBadge = '0230003943530' order by traId desc limit 1 27/10/2024 09:46:39.6975 1916 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-10-27 09:46:37','V',4656436215474630,2024,'2024-10-27 09:46:35','455896829400327005012999',2,2,2,'O','',0,'2024-10-27 09:46:37',1,'','0230003943530',44,0) 27/10/2024 09:48:39.3682 1225 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 09:48:38',4,1,'2024-10-27 09:48:38','455903415900327005012999','Payed (Credit Card ) Ticket ') 27/10/2024 09:48:56.0553 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:52:22.5269 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:53:05.7427 573 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/10/2024 09:54:30.9354 1702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:54:41.4034 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:54:44.8407 2057 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 09:55:13.5348 583 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 27/10/2024 09:56:05.9097 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:56:05.9097 532 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 27/10/2024 09:56:59.8026 518 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 09:57:22.9000 1271 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 09:57:36.9354 902 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 09:57:37.4547 518 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/10/2024 09:57:37.5257 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 09:57:37.5338 597 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 27/10/2024 09:57:37.5638 628 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 09:57:38.2212 518 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5218520393933090,4910390477595140,2024,'2024-10-27 09:57:37','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/27/2024 8:21:36 AM Date : 10/27/2024 9:57:35 AM Code : 455903009600327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 27/10/2024 09:57:38.9657 718 ms. EXEC: update payReceipt set recCreation = '2024-10-27 09:57:38',recModify = '2024-10-27 09:57:38',recUseId=0,recStatus='V' where recId = 316531 27/10/2024 09:57:40.1765 807 ms. EXEC: update payInventory set invCreation = '2024-10-27 09:57:39',invModify = '2024-10-27 09:57:39',invUseId=0,invStatus='V' where invId = 215577 27/10/2024 10:04:29.9905 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:05:20.4772 773 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 10:05:34.6196 1959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:06:30.4728 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:06:55.5115 2955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:07:44.4051 1005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:09:37.5034 3006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:09:38.9964 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:11:18.7759 638 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 10:11:19.6875 899 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 10:11:18' where payTraUID = 4772057854559760 and payStatus='V' and payEnabled=1 27/10/2024 10:11:29.7132 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:16:33.7587 2897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:22:26.1055 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:23:16.7412 661 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '455903422900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 27/10/2024 10:23:16.8123 863 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-10-27 10:23:13',0,'V',4678273178452080,5130284933705970,2024,'2024-10-27 10:23:13',3,1,0,4,'2024-10-27 10:38:13','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 10:23:25.0157 1200 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 10:23:25.2709 516 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/10/2024 10:23:50.3436 530 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 10:24:22.9613 1779 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-10-27 10:24:21','V',4685826105967380,2024,'2024-10-27 10:24:19','455903590400327005012999',2,2,2,'O','',0,'2024-10-27 10:24:21',1,'','',0) 27/10/2024 10:24:29.0624 805 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 10:25:05.8599 1174 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-10-27 10:25:04','V',4905423703570630,2024,'2024-10-27 10:25:01','455903618800327005012999',2,2,2,'O','',0,'2024-10-27 10:25:04',1,'','',0) 27/10/2024 10:26:43.3148 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:30:14.3764 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:31:59.2323 1264 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:39:05.7344 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:39:10.5897 1028 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-10-27 10:39:09','V',4998103213281400,2024,'2024-10-27 10:39:08','455903834800327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 10:39:16.8679 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:39:41.8335 2129 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:40:54.8401 652 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 27/10/2024 10:40:54.8411 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:48:32.4110 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 10:49:40.2001 508 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 10:49:39' where payTraUID = 4942157358846770 and payStatus='V' and payEnabled=1 27/10/2024 10:56:13.2240 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 10:57:32.3737 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:04:14.0363 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:04:33.3001 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:06:32.8618 1311 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:06:57.6983 2609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:11:15.4391 7904 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 27/10/2024 11:11:18.5171 813 ms. OPEN: select * from movTransit where traStatus = 'V' and traCode='455895973300327001012999' and traBadge = '0230003944081' order by traId desc limit 1 27/10/2024 11:13:02.9477 2336 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 27/10/2024 11:16:11.9516 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:17:34.1223 748 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 11:17:52.1213 2112 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-10-27 11:17:50','V',5204824154935420,2024,'2024-10-27 11:17:49','455904066900327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 11:21:35.0388 1137 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/10/2024 11:24:18.5238 2552 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-10-27 11:24:15','0230003944081',0,0,5476692353799120,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 27/10/2024 11:24:19.0521 524 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 27/10/2024 11:24:20.7913 658 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 11:24:19' where traUID = 5359061732014650 and traStatus='V' and traEnabled=1 27/10/2024 11:27:41.2368 878 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 27/10/2024 11:28:18.2575 629 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-27 11:28:15',0,'V',5482439950333920,4940337752312740,2024,'2024-10-27 11:28:15',3,1,0,4,'2024-10-27 11:43:15','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 11:28:20.9092 1442 ms. EXEC: update paycash set casCreation = '2024-10-27 11:28:19',casModify = '2024-10-27 11:28:19',casUseId=0,casStatus='V' where casId = 191730 27/10/2024 11:29:38.9362 1378 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 11:29:37' where traUID = 4940337752312740 and traStatus='V' and traEnabled=1 27/10/2024 11:31:10.5833 2361 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:31:53.3718 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:32:34.3701 640 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-10-27 11:32:33','V',4998193343875420,2024,'2024-10-27 11:32:33','455904088400327005012999',2,2,2,'O','',0,'2024-10-27 11:32:33',1,'','',0) 27/10/2024 11:32:42.6116 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 11:38:24.0170 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:38:30.5894 2654 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 11:38:38.1925 3526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:38:45.3923 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:39:26.1985 1031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:42:13.0847 662 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/10/2024 11:42:22.4969 1297 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:43:40.7411 3200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:45:09.9265 756 ms. EXEC: update payReceipt set recCreation = '2024-10-27 11:45:09',recModify = '2024-10-27 11:45:09',recUseId=0,recStatus='V' where recId = 316544 27/10/2024 11:45:10.8631 571 ms. EXEC: update paycash set casCreation = '2024-10-27 11:45:10',casModify = '2024-10-27 11:45:10',casUseId=0,casStatus='V' where casId = 191734 27/10/2024 11:45:24.0339 589 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5474994170384050,5174210355761960,2024,'2024-10-27 11:45:23',' Data: 10/27/2024 11:43:33 AM Codice: 455904145200327005012999 Ingresso: 10/27/2024 11:30:52 AM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400606599 ',0) 27/10/2024 11:48:02.5285 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 11:48:32.9697 3286 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4674889049877990,4703152839873590,2024,'2024-10-27 11:48:29','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/27/2024 11:14:02 AM Date : 10/27/2024 11:48:29 AM Code : 455904044200327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 27/10/2024 11:48:34.0525 649 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-27 11:48:33',0,0,'V',5483041477784860,4674889049877990,2024,'2024-10-27 11:48:33',3,'KES',1,100,100,'N',''); 27/10/2024 11:48:36.3630 1813 ms. EXEC: update payInventory set invCreation = '2024-10-27 11:48:34',invModify = '2024-10-27 11:48:34',invUseId=0,invStatus='V' where invId = 215586 27/10/2024 11:48:36.3640 1771 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-10-27 11:48:34','V',4809946495171460,2024,'2024-10-27 11:48:33','455904145200327005012999',2,2,2,'O','',0,'2024-10-27 11:48:34',1,'','',0) 27/10/2024 11:48:39.1599 1742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:49:15.0268 794 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 11:49:14' where traUID = 5220250187158780 and traStatus='V' and traEnabled=1 27/10/2024 11:49:20.4534 1205 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:49:20.7136 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 11:49:34.1765 2289 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 11:50:19.8409 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 11:52:12.5821 702 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-10-27 11:52:11','V',4836335496194240,2024,'2024-10-27 11:52:09','455904272900327001012999',1,2,1,'I','',1,0,1,'','',4) 27/10/2024 11:52:16.7628 925 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 11:52:15',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 27/10/2024 11:52:21.6771 1388 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:52:27.6011 2391 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 977 ms.) 27/10/2024 11:52:48.1437 640 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/10/2024 11:53:32.6264 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:55:05.6964 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:56:06.6790 1859 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='455904065200327005012999' 27/10/2024 11:56:53.9235 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 11:58:05.3110 1416 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 11:58:03',4,1,'2024-10-27 11:58:03','455904066900327005012999','Payed (Credit Card ) Ticket ') 27/10/2024 11:58:06.5839 1233 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 364098 else acvFstPayId end),acvLstPayId = 364098 where acvSftId = 811 and acvCodeId = 3 27/10/2024 11:59:34.9127 1409 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 11:59:33' where traUID = 5322754241283650 and traStatus='V' and traEnabled=1 27/10/2024 12:01:15.4187 671 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 12:01:22.5034 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 12:01:22.6195 624 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/10/2024 12:02:59.6071 684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 12:04:23.4920 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:10:58.6813 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:11:41.9521 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:12:33.6395 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:13:59.5818 602 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 12:13:58' where traUID = 5276494777800350 and traStatus='V' and traEnabled=1 27/10/2024 12:14:26.2616 817 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 12:14:25',0,16,'2024-10-27 12:14:25','','Unauthorized Transit Entry 2') 27/10/2024 12:15:29.9020 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:21:11.2334 793 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-10-27 12:21:10','V',5684467368651610,2024,'2024-10-27 12:21:06','455904446600327005012999',1,2,16,'I','',1,0,1,'','0230003943530',44,0) 27/10/2024 12:21:36.5843 1171 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 12:22:34.1186 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:22:58.0605 551 ms. EXEC: update tabTerminalReceipt set trcProgressive = 47305, trcLastPrinted = '2400747305', trcLastDate = '2024-10-27 12:22:57' where trcStatus='V' and trcTerId = 18 27/10/2024 12:22:59.0412 837 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5722177878674030,4987074499220490,2024,'2024-10-27 12:22:58',' Date: 10/27/2024 12:22:57 PM Code: 455903329100327005012999 Entry Date: 10/27/2024 9:14:51 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 200.00 KES ______________________________ Paid: 200.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400747305 ',0) 27/10/2024 12:24:20.3504 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 12:25:55.7099 548 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-27 12:25:55','V',5572076126439150,2024,'2024-10-27 12:25:53','455904475300327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 12:27:33.9754 970 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 12:27:33' where payTraUID = 4814562736897080 and payStatus='V' and payEnabled=1 27/10/2024 12:27:43.1035 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 260 ms.) 27/10/2024 12:33:09.3938 544 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-10-27 12:33:07',0,'V',5684241547600560,4639397981263280,2024,'2024-10-27 12:33:07',3,1,0,4,'2024-10-27 12:48:07','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 12:33:11.3581 706 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 12:33:10',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'; 27/10/2024 12:35:16.4054 1561 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 12:35:14' where traUID = 5341940024242920 and traStatus='V' and traEnabled=1 27/10/2024 12:35:26.6263 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 12:35:35.9805 1626 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 27/10/2024 12:35:50.9655 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:36:29.9054 2857 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/10/2024 12:36:31.9218 651 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 12:36:31' where traUID = 4639397981263280 and traStatus='V' and traEnabled=1 27/10/2024 12:37:41.3140 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 12:38:31.5675 855 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 12:38:45.2926 1241 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 12:38:59.2949 2295 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 12:38:56',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'; 27/10/2024 12:38:59.8973 602 ms. EXEC: update payInventory set invCreation = '2024-10-27 12:38:59',invModify = '2024-10-27 12:38:59',invUseId=0,invStatus='V' where invId = 215600 27/10/2024 12:39:03.3657 2934 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:39:12.3476 2500 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:39:46.9977 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:40:27.2906 3311 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 12:40:23' where traUID = 5455489850385090 and traStatus='V' and traEnabled=1 27/10/2024 12:40:51.5287 4223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:41:00.7028 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:41:11.8843 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 134 ms.) 27/10/2024 12:41:59.4239 1670 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 12:43:02.6821 1084 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 12:43:16.7044 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 12:43:29.7962 940 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 12:43:30.2344 1002 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-27 12:43:29',0,0,'V',5593940060902520,4790791055126790,2024,'2024-10-27 12:43:29',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-10-27 12:43:29',0,0,'V',5593940060902520,4790791055126790,2024,'2024-10-27 12:43:29',3,'KES',-4,100,-400,'N',''); 27/10/2024 12:44:37.0500 2031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:45:23.7361 1217 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 228 ms.) 27/10/2024 12:46:32.1787 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 486 ms.) 27/10/2024 12:47:31.3151 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:48:16.1279 1195 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/10/2024 12:50:03.8897 514 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 12:50:03',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 27/10/2024 12:50:57.2883 642 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 12:52:18.5894 694 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/10/2024 12:53:13.6711 1108 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15100, trcLastPrinted = '2400415100', trcLastDate = '2024-10-27 12:53:12' where trcStatus='V' and trcTerId = 4 27/10/2024 12:53:26.8980 640 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 12:55:29.8639 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 12:55:37.6451 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 12:56:14.4946 545 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4693735972748090,4816683138434540,2024,'2024-10-27 12:56:13',' Date: 10/27/2024 12:56:13 PM Code: 455904539500327005012999 Entry Date: 10/27/2024 12:36:35 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400747306 ',0) 27/10/2024 12:57:30.8115 900 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15102, trcLastPrinted = '2400415102', trcLastDate = '2024-10-27 12:57:29' where trcStatus='V' and trcTerId = 4 27/10/2024 12:59:03.5743 671 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-10-27 12:59:02','V',4624671128484030,2024,'2024-10-27 12:59:02','455904550700327005012999',2,2,2,'O','',0,'2024-10-27 12:59:02',1,'','',0) 27/10/2024 12:59:36.9565 690 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-10-27 12:59:36','V',5370926339583070,2024,'2024-10-27 12:59:35','455904501500327005012999',2,2,2,'O','',0,'2024-10-27 12:59:36',1,'','',0) 27/10/2024 13:00:12.4461 2086 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 13:02:04.5408 1906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 13:02:17.2613 1434 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 13:02:37.5428 551 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-10-27 13:02:36','V',5681050625451940,2024,'2024-10-27 13:02:36','455904695600327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 13:04:32.8266 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 13:05:17.1231 702 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 13:05:16',0,16,'2024-10-27 13:05:16','','Unauthorized Transit Entry 2') 27/10/2024 13:08:10.5827 1253 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 13:11:11.1690 588 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-27 13:11:10','V',5391139515089920,2024,'2024-10-27 13:11:09','455904675500327005012999',2,2,2,'O','',0,'2024-10-27 13:11:10',1,'','',0) 27/10/2024 13:12:39.6429 1199 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 13:12:38' where traUID = 5429333415917990 and traStatus='V' and traEnabled=1 27/10/2024 13:12:43.7387 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 13:15:34.2643 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 13:15:42.0074 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 13:17:01.9997 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 13:41:55.2123 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 13:51:18.1360 1672 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 27/10/2024 13:55:45.3284 1657 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 27/10/2024 13:59:28.2925 521 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 165 order by traDateTime desc,traId desc 27/10/2024 14:15:17.9217 832 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 14:21:00.8130 2696 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 135 order by traDateTime desc,traId desc 27/10/2024 14:21:18.2858 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 14:22:28.8265 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 14:23:22.0535 516 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6607, trcLastPrinted = '2400606607', trcLastDate = '2024-10-27 14:23:21' where trcStatus='V' and trcTerId = 17 27/10/2024 14:24:10.0759 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 14:24:11.3448 656 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 1045 ms.) 27/10/2024 14:24:13.2291 4007 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-10-27 14:24:06',0,'V',5436962203344640,4765117966168460,2024,'2024-10-27 14:24:06',3,1,0,4,'2024-10-27 14:39:06','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 1274 ms.) 27/10/2024 14:24:14.2117 926 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4765117966168460,5436962203344640,2024,'2024-10-27 14:24:13','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/27/2024 1:45:29 PM Date : 10/27/2024 2:24:06 PM Code : 455904952900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 27/10/2024 14:24:14.2908 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-10-27 14:24:13','V',5035559687369680,2024,'2024-10-27 14:24:08','455904775500327005012999',2,2,2,'O','',0,'2024-10-27 14:24:13',1,'','',0) 27/10/2024 14:24:15.2224 731 ms. EXEC: update paycash set casCreation = '2024-10-27 14:24:14',casModify = '2024-10-27 14:24:14',casUseId=0,casStatus='V' where casId = 191777 27/10/2024 14:24:16.1660 634 ms. EXEC: update paycash set casCreation = '2024-10-27 14:24:15',casModify = '2024-10-27 14:24:15',casUseId=0,casStatus='V' where casId = 191778 27/10/2024 14:24:43.1113 2401 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 27/10/2024 14:24:46.5216 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-10-27 14:24:45',0,'V',4866758394050590,4986654636259340,2024,'2024-10-27 14:24:45',2,1,0,-1,'2024-10-27 15:24:45','S','KES',50,50,0,'','','',3,50,0,0,'',0,0) 27/10/2024 14:25:38.9260 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 14:27:21.2263 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 14:28:01.4305 1718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 14:29:06.4756 511 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 14:29:42.1637 732 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 14:29:59.4314 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 14:30:11.7368 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 14:36:05.2917 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 14:40:11.7132 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 14:47:29.1926 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 14:51:31.5372 1001 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:00:22.1617 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:02:39.4786 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 15:04:48.5400 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 15:08:11.3675 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:09:16.6067 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 15:10:45.7871 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:12:06.9962 554 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-10-27 15:12:06','V',5593175005633270,2024,'2024-10-27 15:12:05','455905319700327005012999',2,2,2,'O','',0,'2024-10-27 15:12:06',1,'','',0) 27/10/2024 15:12:15.0227 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:19:45.0601 533 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 27/10/2024 15:22:19.3509 961 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:36:35.6995 703 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:40:37.3874 738 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:40:37.7896 1207 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 15:45:35.0657 653 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 15:45:34',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'; 27/10/2024 15:48:24.0286 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 15:49:07.7586 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 15:54:39.1160 6438 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 27/10/2024 15:56:12.2489 581 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 15:56:11' where traUID = 5480686820601230 and traStatus='V' and traEnabled=1 27/10/2024 16:06:17.7915 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 16:06:27.6283 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:06:28.8071 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:08:42.7000 856 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/10/2024 16:11:34.4979 682 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 27/10/2024 16:16:13.5864 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:18:09.0536 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 16:21:40.8880 27572 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 27/10/2024 16:22:52.8474 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:23:02.1578 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:24:27.8696 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:33:37.4008 2607 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/10/2024 16:33:38.3264 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 16:34:06.7049 592 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 364200 else acvFstPayId end),acvLstPayId = 364200 where acvSftId = 811 and acvCodeId = 3 27/10/2024 16:35:03.8311 9833 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 27/10/2024 16:36:36.7649 569 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-10-27 16:34:19',6,'V',5148361234293080,5277441416242210,2024,'2024-10-27 16:34:19',4,1,0,4,'2024-10-27 16:49:19','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 27/10/2024 16:36:37.5314 562 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15114, trcLastPrinted = '2400415114', trcLastDate = '2024-10-27 16:36:36' where trcStatus='V' and trcTerId = 4 27/10/2024 16:38:17.0207 516 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 16:38:16' where traUID = 4883553660050310 and traStatus='V' and traEnabled=1 27/10/2024 16:38:26.2730 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 16:39:03.2534 1447 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 16:39:01' where traUID = 5277441416242210 and traStatus='V' and traEnabled=1 27/10/2024 16:40:06.5268 702 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/10/2024 16:41:28.5861 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 16:48:44.8445 738 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 27/10/2024 16:49:36.9803 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-10-27 16:49:36','V',4815667098389070,2024,'2024-10-27 16:49:36','455906057600327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 16:52:41.1317 1437 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:53:56.3383 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:54:15.7516 587 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 16:54:15' where payTraUID = 5277188398927670 and payStatus='V' and payEnabled=1 27/10/2024 16:54:20.4538 507 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/10/2024 16:55:34.4876 1301 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:56:11.9474 1186 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 16:58:24.9236 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:01:27.8091 3050 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/10/2024 17:01:43.3278 582 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 17:01:42',0,16,'2024-10-27 17:01:42','','Unauthorized Transit Entry 2') 27/10/2024 17:02:39.2031 2435 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:04:53.4463 1527 ms. EXEC: update payReceipt set recCreation = '2024-10-27 17:04:51',recModify = '2024-10-27 17:04:51',recUseId=0,recStatus='V' where recId = 316649 27/10/2024 17:06:48.4822 1680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:07:24.3658 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:07:39.1660 801 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 17:07:38',0,16,'2024-10-27 17:07:38','','Unauthorized Transit Entry 2') 27/10/2024 17:10:49.0243 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:11:30.4037 673 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/10/2024 17:13:31.2116 606 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 17:13:31.3157 661 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-10-27 17:13:29',0,'V',4687382599993320,4815667098389070,2024,'2024-10-27 17:13:29',3,1,0,4,'2024-10-27 17:28:29','C','KES',50,500,450,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 17:13:31.7279 504 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 17:13:32.5485 783 ms. EXEC: update payReceipt set recCreation = '2024-10-27 17:13:31',recModify = '2024-10-27 17:13:31',recUseId=0,recStatus='V' where recId = 316654 27/10/2024 17:13:32.6676 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 17:13:31' where traUID = 5392444192869760 and traStatus='V' and traEnabled=1 27/10/2024 17:13:33.3420 779 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-27 17:13:32',0,0,'V',5158910714813850,4815667098389070,2024,'2024-10-27 17:13:32',3,'KES',1,500,500,'N',''); 27/10/2024 17:13:34.7640 1420 ms. EXEC: update paycash set casCreation = '2024-10-27 17:13:33',casModify = '2024-10-27 17:13:33',casUseId=0,casStatus='V' where casId = 191812 27/10/2024 17:13:36.3241 895 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 17:13:35',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-10-27 17:13:35',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 27/10/2024 17:14:58.3094 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:15:46.8036 1144 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:17:13.3741 1103 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 17:17:12',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'; 27/10/2024 17:17:20.9743 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:17:59.3796 595 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 27/10/2024 17:17:59.5127 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:20:37.4121 2171 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-10-27 17:20:35','V',5631335804899690,2024,'2024-10-27 17:20:34','455906243400327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 27/10/2024 17:22:51.5001 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:23:52.0567 553 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 17:24:04.7864 569 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 17:26:15.5091 920 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-10-27 17:26:14','V',5169112043259570,2024,'2024-10-27 17:26:13','455905659900327005012999',2,2,2,'O','',0,'2024-10-27 17:26:14',1,'','',0) (WAIT TIME 13 ms.) 27/10/2024 17:26:22.9342 978 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:29:45.0990 1678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:30:05.9212 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:30:14.2750 1969 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 17:30:12' where payTraUID = 5751874414984960 and payStatus='V' and payEnabled=1 27/10/2024 17:30:16.8738 2597 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 17:30:12' where traUID = 5751874414984960 and traStatus='V' and traEnabled=1 27/10/2024 17:30:59.0877 546 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 17:31:05.1189 590 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/10/2024 17:32:37.0299 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:32:43.0451 686 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/10/2024 17:32:50.4932 1893 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 17:33:42.4258 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:33:56.0792 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:34:19.2861 700 ms. EXEC: update paycash set casCreation = '2024-10-27 17:34:18',casModify = '2024-10-27 17:34:18',casUseId=0,casStatus='V' where casId = 191821 27/10/2024 17:34:19.8175 531 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 17:34:18',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 17:34:18',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 27/10/2024 17:34:45.1689 2262 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-10-27 17:34:42','V',4674824776436970,2024,'2024-10-27 17:34:42','455905752500327005012999',2,2,2,'O','',0,'2024-10-27 17:34:42',1,'','',0) 27/10/2024 17:34:52.4459 1372 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:35:50.1575 587 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-27 17:35:49',0,0,'V',5064154394552280,4994755261194840,2024,'2024-10-27 17:35:49',3,'KES',1,50,50,'N',''); 27/10/2024 17:35:50.8249 550 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 17:35:49',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'; 27/10/2024 17:37:52.2773 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:38:58.7069 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:41:25.0203 1365 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 17:41:37.8351 599 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 17:42:10.6856 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 17:43:03.7340 731 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 17:44:46.8448 1315 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/10/2024 17:44:46.8628 542 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 27/10/2024 17:45:17.7370 688 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 17:50:11.7708 765 ms. EXEC: update payReceipt set recCreation = '2024-10-27 17:50:11',recModify = '2024-10-27 17:50:11',recUseId=0,recStatus='V' where recId = 316667 27/10/2024 17:50:12.6034 557 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 17:50:11',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'; 27/10/2024 17:53:39.9146 1480 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/10/2024 17:55:42.7229 631 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-10-27 17:55:42','V',4988459561680600,2024,'2024-10-27 17:55:40','455904195200327005012999',2,2,2,'O','',0,'2024-10-27 17:55:42',1,'','',0) 27/10/2024 17:55:48.1967 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:00:33.9718 729 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 18:00:55.5976 1651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:01:56.6435 585 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/10/2024 18:02:54.0619 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:03:38.2242 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 18:06:21.2061 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:07:55.6209 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:08:55.7542 726 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-27 18:08:55','V',5376800110976930,2024,'2024-10-27 18:08:54','455906533400327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 18:09:32.3173 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 18:12:22.3269 706 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 18:17:08.9847 820 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-10-27 18:17:08','V',5637321574093630,2024,'2024-10-27 18:17:06','455906582600327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 18:17:11.1001 2111 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 18:17:22.8232 1169 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-10-27 18:17:19',0,'V',4646621852377430,5709968325146850,2024,'2024-10-27 18:17:19',3,1,0,4,'2024-10-27 18:32:19','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 18:17:25.5280 1126 ms. EXEC: update paycash set casCreation = '2024-10-27 18:17:24',casModify = '2024-10-27 18:17:24',casUseId=0,casStatus='V' where casId = 191830 27/10/2024 18:18:13.4829 1090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:18:57.5552 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:19:01.7791 1027 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 18:19:00',0,16,'2024-10-27 18:19:00','','Unauthorized Transit Entry 2') 27/10/2024 18:19:04.1297 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:19:38.6414 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:21:01.8104 878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:21:56.7501 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:28:19.2987 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:30:51.5732 609 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 27/10/2024 18:30:51.6292 692 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/10/2024 18:34:25.9503 1105 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 27/10/2024 18:36:17.1256 1443 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:40:30.9838 974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:40:58.9290 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 18:41:04.5168 1386 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 18:41:04.6769 1417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:44:56.7692 968 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 18:44:57.6678 1578 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 18:45:00.6959 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:49:45.6635 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:51:13.9231 737 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 18:52:27.1093 719 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 18:52:26' where traUID = 5637321574093630 and traStatus='V' and traEnabled=1 27/10/2024 18:53:37.3825 631 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 18:53:36' where payTraUID = 5510431704364940 and payStatus='V' and payEnabled=1 27/10/2024 18:53:38.9676 1555 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 18:53:36' where traUID = 5510431704364940 and traStatus='V' and traEnabled=1 27/10/2024 18:57:02.2171 811 ms. EXEC: update payReceipt set recCreation = '2024-10-27 18:57:01',recModify = '2024-10-27 18:57:01',recUseId=0,recStatus='V' where recId = 316678 27/10/2024 18:57:08.5945 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:57:40.3092 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 18:59:00.7825 815 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-10-27 18:58:59','V',4774348364327840,2024,'2024-10-27 18:58:58','455906584800327005012999',2,2,2,'O','',0,'2024-10-27 18:58:59',1,'','',0) 27/10/2024 18:59:37.8859 819 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 18:59:44.7506 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:00:15.5888 872 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 27/10/2024 19:01:43.6072 1606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:05:58.8974 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:07:54.6328 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:08:11.6625 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:08:32.8441 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:09:48.9453 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:13:01.7516 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:13:36.7486 708 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 19:16:51.4542 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:18:22.8500 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:18:33.4713 953 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-10-27 19:18:32','V',5430619290513880,2024,'2024-10-27 19:18:30','455906951000327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 19:23:27.9914 695 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 19:23:29.5595 736 ms. EXEC: update payInventory set invCreation = '2024-10-27 19:23:28',invModify = '2024-10-27 19:23:28',invUseId=0,invStatus='V' where invId = 215686 27/10/2024 19:23:30.2359 673 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-27 19:23:29',0,0,'V',5569665996441170,5460424064819790,2024,'2024-10-27 19:23:29',3,'KES',-2,100,-200,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-27 19:23:29',0,0,'V',5569665996441170,5460424064819790,2024,'2024-10-27 19:23:29',3,'KES',-1,200,-200,'N',''); 27/10/2024 19:23:32.6176 2340 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 19:23:29',3,42101,0,100,-2,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 19:23:29',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 27/10/2024 19:24:33.5294 1188 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:25:34.1550 3238 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-10-27 19:25:30','V',5199342385001790,2024,'2024-10-27 19:25:29','455906798600327005012999',2,2,2,'O','',0,'2024-10-27 19:25:30',1,'','',0) 27/10/2024 19:27:39.5020 629 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 19:28:21.2156 662 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 19:29:11.4681 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:30:11.9506 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 19:31:27.9308 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:31:42.8440 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:33:48.7674 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 19:37:22.5221 1388 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:37:29.2397 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 19:37:39.9851 1268 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '763134' and traDirection='I' order by traId DESC LIMIT 1 27/10/2024 19:37:48.1767 884 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-10-27 19:37:47','V',4654169675749790,2024,'2024-10-27 19:37:46','455906592900327005012999',2,2,2,'O','',0,'2024-10-27 19:37:47',1,'','',0) 27/10/2024 19:38:18.8077 608 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 19:38:18' where traUID = 4769333939267910 and traStatus='V' and traEnabled=1 27/10/2024 19:38:37.8498 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:39:36.8133 1114 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/10/2024 19:40:33.7984 598 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4650697156031580,5180460507823710,2024,'2024-10-27 19:40:33','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/27/2024 7:25:40 PM Date : 10/27/2024 7:40:31 PM Code : 455906994000327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 27/10/2024 19:40:38.0893 597 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-10-27 19:40:37','V',5088373496366950,2024,'2024-10-27 19:40:36','455906462700327005012999',2,2,2,'O','',0,'2024-10-27 19:40:37',1,'','',0) 27/10/2024 19:40:38.8599 653 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 19:40:38' where payTraUID = 5706055226705690 and payStatus='V' and payEnabled=1 27/10/2024 19:40:44.4127 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 19:41:37.2329 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 19:41:38.8830 1017 ms. EXEC: update paycash set casCreation = '2024-10-27 19:41:37',casModify = '2024-10-27 19:41:37',casUseId=0,casStatus='V' where casId = 191842 (WAIT TIME 2 ms.) 27/10/2024 19:41:44.2207 2862 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 19:44:17.9592 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 19:44:39.8612 614 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-10-27 19:44:39','V',4876979939866810,2024,'2024-10-27 19:44:37','455907107700327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 19:45:38.9498 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:46:48.5175 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:47:00.6929 611 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-10-27 19:47:00','V',4622599630622160,2024,'2024-10-27 19:46:59','455906939300327005012999',2,2,2,'O','',0,'2024-10-27 19:47:00',1,'','',0) 27/10/2024 19:47:01.2773 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 19:47:02.4271 896 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 19:47:01' where traUID = 5047631355477520 and traStatus='V' and traEnabled=1 27/10/2024 19:47:10.2374 731 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 19:47:28.1918 684 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 27/10/2024 19:47:38.3607 527 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/10/2024 19:47:47.2178 1038 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 19:48:00.8722 1333 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:49:19.0568 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:50:41.2903 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:53:18.1529 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:55:31.7156 512 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 19:57:43.4470 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 19:58:25.6280 1072 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 27/10/2024 19:59:32.0816 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-10-27 19:59:31','V',5194189595055640,2024,'2024-10-27 19:59:30','455907197000327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 19:59:32.8791 793 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 20:01:33.5970 2169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:01:57.1941 516 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 20:04:05.4622 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:04:35.9321 703 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 20:04:35' where payTraUID = 4872401833469420 and payStatus='V' and payEnabled=1 27/10/2024 20:04:38.8261 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:04:38.8371 816 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 20:04:52.6606 777 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 20:05:09.4591 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:07:49.4819 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:07:54.4033 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:09:06.5328 1873 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 20:09:04',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 20:09:04',3,42101,0,100,-2,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 20:09:04',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 27/10/2024 20:09:12.9842 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:09:20.3883 2315 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 20:10:00.5329 1415 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:11:14.6367 2382 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/10/2024 20:11:18.3042 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:15:21.8584 701 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 20:15:22.6209 749 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 20:15:21' where payTraUID = 4625926410185470 and payStatus='V' and payEnabled=1 27/10/2024 20:20:02.8542 750 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5257353352654860,5739741513440490,2024,'2024-10-27 20:20:02','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/27/2024 7:48:27 PM Date : 10/27/2024 8:20:00 PM Code : 455907130700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 27/10/2024 20:24:21.2065 766 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 20:24:22.9237 1473 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 20:24:21' where traUID = 5257353352654860 and traStatus='V' and traEnabled=1 27/10/2024 20:26:00.9600 691 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/10/2024 20:26:01.6965 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 20:29:11.7379 1959 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/10/2024 20:30:14.1878 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 20:33:47.1379 812 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 27/10/2024 20:34:00.8253 1721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:36:05.4628 936 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/10/2024 20:36:19.0642 667 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 20:44:19.5459 878 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-10-27 20:44:18','V',4851245320377870,2024,'2024-10-27 20:44:16','455907143300327005012999',2,2,2,'O','',0,'2024-10-27 20:44:18',1,'','',0) 27/10/2024 20:44:23.3976 3238 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '455907143300327005012999' 27/10/2024 20:44:33.6776 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 20:44:54.4759 984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:45:10.7501 658 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/10/2024 20:45:20.1825 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:46:18.6767 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:48:53.0776 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:49:25.9742 681 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-10-27 20:49:24',0,'V',4843466106164560,5206303921773580,2024,'2024-10-27 20:49:24',3,1,0,4,'2024-10-27 21:04:24','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 27/10/2024 20:49:27.4993 562 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-27 20:49:26',0,0,'V',5120096582970030,5206303921773580,2024,'2024-10-27 20:49:26',3,'KES',-1,50,-50,'N',''); 27/10/2024 20:49:28.4519 644 ms. EXEC: update paycash set casCreation = '2024-10-27 20:49:27',casModify = '2024-10-27 20:49:27',casUseId=0,casStatus='V' where casId = 191853 27/10/2024 20:51:38.6583 1402 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-27 20:51:37','V',5136817991115570,2024,'2024-10-27 20:51:33','455907349000327005012999',2,2,2,'O','',0,'2024-10-27 20:51:37',1,'','',0) 27/10/2024 20:52:44.4564 1219 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 20:55:19.6119 877 ms. OPEN: select * from movtransit where traCode = '455907416100327001012999' and traStatus='V' ORDER BY traId DESC 27/10/2024 20:57:45.9774 1148 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 20:59:10.8826 890 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-27 20:59:08',0,'V',5547781943432350,5611564142536020,2024,'2024-10-27 20:59:08',3,1,0,4,'2024-10-27 21:14:08','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 27/10/2024 20:59:12.7159 1261 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 20:59:39.1330 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:00:59.9865 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:01:20.9049 656 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 21:01:20' where payTraUID = 5664620676558510 and payStatus='V' and payEnabled=1 27/10/2024 21:01:22.3859 1480 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 21:01:20' where traUID = 5664620676558510 and traStatus='V' and traEnabled=1 27/10/2024 21:01:22.9973 610 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 27/10/2024 21:02:51.7282 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:10:24.2698 637 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 27/10/2024 21:17:04.0591 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:18:02.0880 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:18:16.6199 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:26:42.8393 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:27:26.7024 515 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 21:27:50.4207 1765 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 21:28:02.6321 522 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-27 21:25:46',6,'V',5577455192254810,4873482333454580,2024,'2024-10-27 21:25:46',4,1,0,4,'2024-10-27 21:40:46','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 27/10/2024 21:28:03.5187 872 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 21:28:02',4,6,'2024-10-27 21:28:02','455907004200327005012999','Payed (Credit Card ) Ticket ') 27/10/2024 21:28:20.7335 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:30:50.3772 624 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 21:32:30.4399 734 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 27/10/2024 21:32:39.9404 653 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 21:34:14.0390 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:37:03.8555 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:37:25.3463 674 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15131, trcLastPrinted = '2400415131', trcLastDate = '2024-10-27 21:37:24' where trcStatus='V' and trcTerId = 4 (WAIT TIME 129 ms.) 27/10/2024 21:38:03.0592 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:38:26.6043 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:38:45.7955 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:39:12.8430 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:39:18.7811 1530 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 21:39:27.3520 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:41:50.0790 873 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 21:41:50.6183 503 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 21:41:55.3876 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:42:58.0286 540 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/10/2024 21:45:23.0471 808 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 21:45:31.2948 1506 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5605655020592510,5498335887196080,2024,'2024-10-27 21:45:29',' Date: 10/27/2024 9:43:12 PM Code: 455906436800327005012999 Entry Date: 10/27/2024 5:52:48 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 200.00 KES ______________________________ Paid: 200.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415132 ',0) 27/10/2024 21:45:50.9513 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:46:32.6799 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:46:54.4538 1687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:47:10.1476 981 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 27/10/2024 21:47:30.5916 549 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 21:49:01.7322 1417 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-10-27 21:46:43',6,'V',5370333019861760,4633509693876850,2024,'2024-10-27 21:46:43',4,1,0,4,'2024-10-27 22:01:43','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 27/10/2024 21:49:16.3182 577 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5417832968394530,4828857095779310,2024,'2024-10-27 21:49:15',' Date: 10/27/2024 9:46:59 PM Code: 455907768500327005012999 Entry Date: 10/27/2024 9:34:45 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415135 ',0) 27/10/2024 21:50:08.4030 2089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:50:26.2702 925 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/10/2024 21:50:27.2749 996 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '455907798700327005012999' 27/10/2024 21:50:28.0785 803 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-27 21:50:26' where payTraUID = 5169561959345170 and payStatus='V' and payEnabled=1 27/10/2024 21:50:42.2842 774 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 21:50:42.8396 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:53:37.0211 660 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 21:53:45.8252 1272 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/10/2024 21:55:53.3357 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 21:56:28.4157 1296 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:05:12.5144 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:05:22.2741 539 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-10-27 22:05:21',0,'V',4804397592637120,5405514185522280,2024,'2024-10-27 22:05:21',2,1,0,-1,'2024-10-27 23:05:21','S','KES',0,0,0,'','','',3,0,0) 27/10/2024 22:05:27.8079 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 22:05:27.9820 590 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/10/2024 22:14:53.8124 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:14:53.8124 605 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/10/2024 22:15:11.6146 533 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/10/2024 22:15:44.1049 1152 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:20:09.7272 778 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 22:20:10.7619 911 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 27/10/2024 22:20:51.0375 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1452 ms.) 27/10/2024 22:21:26.0616 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 22:21:51.9253 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 22:23:17.9023 994 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 22:23:46.2358 1107 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 22:23:45',0,2,'2024-10-27 22:23:45','0230003944086','Exit 1 - User Transit Supervisor Supervisor') 27/10/2024 22:24:35.8258 1306 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-10-27 22:24:34','V',4915680565019060,2024,'2024-10-27 22:24:33','455908067300327005012999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 22:24:43.1378 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:25:18.6402 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:25:29.8379 1545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:25:29.8389 1428 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/10/2024 22:25:46.9456 2959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:26:00.4429 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 22:26:45.6159 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:27:36.2436 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:27:50.2512 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:31:37.6553 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:33:26.1938 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:33:42.8362 612 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 22:34:22.8106 1357 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 22:34:21' where traUID = 4729776953542960 and traStatus='V' and traEnabled=1 27/10/2024 22:34:57.1262 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:38:31.1741 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:40:53.6028 1122 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 22:40:52',3,42101,0,500,1,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 27/10/2024 22:40:54.6395 849 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-27 22:40:53',3,42101,0,100,-4,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 27/10/2024 22:40:56.7390 1137 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:41:01.7354 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:42:16.7529 534 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 22:42:38.2146 755 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 22:43:09.7493 675 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-27 22:43:09' where traUID = 4915680565019060 and traStatus='V' and traEnabled=1 27/10/2024 22:44:01.8680 1769 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 196 ms.) 27/10/2024 22:51:57.1062 2020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:52:01.1419 3195 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:52:05.2317 1408 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:52:16.2293 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:52:30.3950 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:52:36.0529 2984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:54:47.9854 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:55:44.5132 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:55:51.1318 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:56:24.9990 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 22:56:36.5940 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 756 ms.) 27/10/2024 23:01:37.5365 1730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:02:25.3793 3310 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:03:56.9202 905 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:10:34.6581 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:12:48.1287 2394 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:13:02.4115 1404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:20:59.6861 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:21:55.3853 1437 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:22:12.5091 1088 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 23:22:25.1317 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:22:25.1477 505 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 7 ms.) 27/10/2024 23:23:14.3715 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:23:14.4255 819 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 23:24:54.0119 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:38:01.9686 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:39:06.7471 1796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:42:06.7106 1674 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-10-27 23:42:05','V',4893346026999470,2024,'2024-10-27 23:42:03','455908001300327005012999',2,2,2,'O','',0,'2024-10-27 23:42:05',1,'','',0) 27/10/2024 23:42:07.2910 576 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 23:42:46.4999 816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:44:08.0569 608 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 23:55:00.5437 1804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/10/2024 23:57:43.3764 555 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1