23/11/2024 00:15:42.9876 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:22:19.1090 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:23:35.7483 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:24:18.5060 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:27:59.1989 1034 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:31:50.5929 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:36:03.5264 950 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:39:24.8703 1613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:45:25.1287 648 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-23 00:45:24',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','') 23/11/2024 00:46:34.2380 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:46:48.3754 566 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4921649042527170,4946470741958300,2024,'2024-11-23 00:46:47',' Date: 11/23/2024 12:46:47 AM Code: 456170006400327005012999 Entry Date: 11/23/2024 12:01:04 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400750663 ',0) 23/11/2024 00:48:54.7181 967 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-23 00:48:53','V',5087421657893760,2024,'2024-11-23 00:48:52','456170006400327005012999',2,2,2,'O','',0,'2024-11-23 00:48:53',1,'','',0) 23/11/2024 00:52:26.1367 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:54:09.0697 1492 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 00:56:58.3501 665 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/11/2024 01:33:59.9094 1379 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 01:36:13.6740 718 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-23 01:36:12' where subId = 178 23/11/2024 01:36:15.0499 513 ms. EXEC: update abbCards set carLastDate = '2024-11-23 01:36:14',carLastDirection='O' where carStatus='V' and carId = 164 23/11/2024 01:36:35.8478 2474 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/11/2024 01:36:35.8568 2368 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 01:47:21.2711 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 01:52:00.2340 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 01:53:20.7159 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 01:57:06.5912 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:02:19.8050 964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:05:12.7969 1180 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:09:25.5002 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:10:26.3179 2021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:12:35.5295 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:14:30.5255 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:17:48.8053 1292 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:19:22.1318 1491 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:22:05.2271 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:23:34.3768 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:25:27.0483 1439 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:28:34.1817 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:43:28.3828 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:48:09.7193 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:48:24.9745 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:49:51.6105 1191 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 02:52:48.5831 507 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 23/11/2024 02:53:29.9398 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:02:08.8144 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:04:28.8643 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:04:30.2192 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:04:35.2826 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:04:42.6875 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:05:09.2113 1053 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:11:21.7839 834 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/11/2024 03:11:22.7646 662 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-23 03:11:21' where traUID = 5507276624129990 and traStatus='V' and traEnabled=1 23/11/2024 03:26:11.6951 2589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:30:57.7177 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:32:42.4088 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:36:54.9410 724 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/11/2024 03:45:26.6528 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 03:58:14.8593 1526 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/11/2024 04:04:30.2898 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 04:11:06.4052 560 ms. EXEC: update payReceipt set recCreation = '2024-11-23 04:11:05',recModify = '2024-11-23 04:11:05',recUseId=0,recStatus='V' where recId = 325186 23/11/2024 04:14:00.8692 625 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/11/2024 04:15:53.0134 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 04:19:15.3607 1198 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 23/11/2024 04:29:12.1198 905 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 04:38:24.1590 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 04:43:05.0613 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 04:53:29.7187 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 04:58:32.8908 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 04:58:32.9518 796 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/11/2024 05:09:01.2959 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:13:16.1046 553 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/11/2024 05:17:08.0370 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:18:47.3326 1053 ms. EXEC: update payReceipt set recCreation = '2024-11-23 05:18:46',recModify = '2024-11-23 05:18:46',recUseId=0,recStatus='V' where recId = 325188 23/11/2024 05:21:21.7210 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:22:38.0622 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:24:08.4067 568 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/11/2024 05:27:00.3999 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:27:01.6378 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:32:22.5081 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:35:48.0928 1714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:35:59.2093 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:36:25.0316 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:36:47.7358 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:38:39.2879 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:38:51.9764 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:38:54.8083 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:43:01.4145 1365 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:50:50.0325 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:55:32.3537 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:59:10.3097 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 05:59:47.3946 3048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 11:12:30.2289 4787 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/11/2024 11:12:45.7022 4259 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 23/11/2024 11:13:09.4291 2630 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/11/2024 11:48:23.5090 2362 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 11:58:08.3760 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:35:31.9569 4669 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-23 14:35:27','V',5715843172654180,2024,'2024-11-23 14:35:25','456175252500327001012999',1,2,1,'I','',1,0,1,'','',4) 23/11/2024 14:35:36.6981 4658 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/11/2024 14:36:19.4520 2939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:36:24.2022 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:37:00.8709 2524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:37:25.5696 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:37:39.9413 3099 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:38:03.5443 3467 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 23/11/2024 14:38:08.3075 3519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:39:05.1348 4793 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-23 14:38:55','V',5112665862793410,2024,'2024-11-23 14:38:41','456174731100327005012999',2,2,2,'O','',0,'2024-11-23 14:39:00',1,'','',0) 23/11/2024 14:39:09.8440 4704 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/11/2024 14:39:14.5762 4728 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-23 14:39:09' where payTraUID = 5665949005397550 and payStatus='V' and payEnabled=1 23/11/2024 14:39:33.6001 19021 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-23 14:39:09' where traUID = 5665949005397550 and traStatus='V' and traEnabled=1 23/11/2024 14:39:49.3997 6135 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/11/2024 14:39:49.4107 6158 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/11/2024 14:39:49.4237 6154 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 23/11/2024 14:39:49.4317 6164 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/11/2024 14:40:32.0615 15045 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-23 14:40:17','0230004100121',0,0,5689300468680590,147,'0000-00-00 00:00:00','0000-00-00 00:00:00') 23/11/2024 14:40:36.8207 4685 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-23 14:40:32',0,'V',5689300468680590,4989576293798830,2024,'2024-11-23 14:40:32',2,1,0,-1,'2024-11-23 15:40:32','S','KES',0,0,0,'','','',3,0,0) 23/11/2024 14:40:37.7364 854 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/11/2024 14:40:39.7367 1827 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-23 14:40:37' where traUID = 4989576293798830 and traStatus='V' and traEnabled=1 23/11/2024 14:40:39.7897 1735 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 23/11/2024 14:40:39.8218 1807 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 23/11/2024 14:40:40.5923 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:40:42.0743 1380 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:40:44.7401 2463 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:40:44.7461 875 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/11/2024 14:40:49.7455 4903 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:40:54.7378 4789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:40:58.9677 4128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:42:12.9406 73769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 14:51:29.1056 662 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-23 14:51:28','V',4890404245676720,2024,'2024-11-23 14:51:28','456175348800327005012999',1,2,16,'I','',1,0,1,'','',4) 23/11/2024 14:53:16.1121 508 ms. EXEC: update payInventory set invCreation = '2024-11-23 14:53:15',invModify = '2024-11-23 14:53:15',invUseId=0,invStatus='V' where invId = 220959 23/11/2024 17:34:47.6803 508 ms. EXEC: update paycash set casCreation = '2024-11-23 17:34:47',casModify = '2024-11-23 17:34:47',casUseId=0,casStatus='V' where casId = 196455 23/11/2024 17:57:01.0569 4753 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/11/2024 17:57:16.4892 5863 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/11/2024 17:57:25.9785 9381 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '456176085900327005012999' OR useBadId = '456176085900327005012999') 23/11/2024 17:57:37.6393 1753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/11/2024 17:57:42.2344 2086 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-23 17:57:40' where traUID = 5210973350522800 and traStatus='V' and traEnabled=1 23/11/2024 17:57:42.2364 1272 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1