28/01/2025 00:05:33.1517 1751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:05:42.1367 585 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 00:06:05.2291 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:06:45.0266 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:07:18.2158 1708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:12:08.6615 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:12:34.4847 1588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:15:48.0109 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:16:05.3674 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:16:36.4462 693 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 28/01/2025 00:18:35.7548 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:20:30.0370 682 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 00:20:30.0370 749 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 28/01/2025 00:27:38.0986 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:34:36.2055 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:35:22.6825 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:37:34.5675 1802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:43:37.0663 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:46:05.5344 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 00:48:58.2986 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:01:14.3163 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:06:35.6677 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:07:30.1460 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:17:52.2841 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:18:52.0319 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:33:34.8539 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:34:30.0627 724 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 01:34:31.3076 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:35:25.6798 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:40:18.1649 520 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 01:57:15.2505 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 01:58:03.3566 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:00:25.6105 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:01:19.8917 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:01:27.7489 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:14:41.1552 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:15:01.5488 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:35:00.1826 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:35:05.2210 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:43:33.4120 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:56:37.0953 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:57:50.4552 2076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 02:59:01.0063 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 03:16:07.1939 608 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 03:29:31.3851 612 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 03:30:23.8881 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 03:32:27.0583 580 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/01/2025 03:42:35.5102 1536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 03:42:47.3301 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 03:44:36.3678 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 03:46:50.5483 2434 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 28/01/2025 03:52:33.7573 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 03:52:43.1206 616 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 28/01/2025 03:52:43.1226 1848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 03:55:08.8963 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:00:29.6673 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:03:37.0283 1234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:05:41.6024 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:18:53.6988 1360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:27:29.5482 1231 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:33:08.4897 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:35:34.2429 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:41:44.9214 1084 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 ('2025-01-28 04:41:42',0,'V',4678989886219950,5304545142986180,2025,'2025-01-28 04:41:42',3,1,0,4,'2025-01-28 04:56:42','C','KES',100,0,0,'',' ',' ',98,100,0,0,'',0,0) 28/01/2025 04:41:48.1436 1212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:45:17.7724 2688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 04:52:25.8630 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 04:53:08.2943 1022 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:55:14.6036 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 04:57:05.3795 1289 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:11:54.1747 925 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 05:17:47.7475 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:25:56.1654 1321 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:26:42.8235 1189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:27:00.1731 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:28:37.8953 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:28:48.4463 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:30:13.8333 1937 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:32:33.8227 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:33:24.2613 1218 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:33:45.1312 586 ms. EXEC: update payReceipt set recCreation = '2025-01-28 05:33:44',recModify = '2025-01-28 05:33:44',recUseId=0,recStatus='V' where recId = 346527 28/01/2025 05:37:27.8138 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:38:31.4723 579 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,'2025-01-28 05:38:30','V',5612831016628690,2025,'2025-01-28 05:38:30','456831687400327005012999',2,2,2,'O','',0,'2025-01-28 05:38:30',1,'','',0) 28/01/2025 05:39:19.1661 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:53:46.9500 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:55:47.5354 1197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:56:11.0521 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 05:58:49.2096 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 06:10:40.0549 914 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/01/2025 06:13:03.8718 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 06:25:12.2487 3533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 06:36:13.8381 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 06:56:30.6198 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:09:09.5641 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:09:25.8980 606 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 28/01/2025 07:11:08.4657 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:12:18.1932 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:17:29.2968 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:18:14.2497 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 07:26:17.3790 751 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 07:26:29.3160 561 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-28 07:26:28',0,16,'2025-01-28 07:26:28','','Unauthorized Transit Entry 2') 28/01/2025 07:26:42.2657 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:27:58.8017 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:29:06.2877 865 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,'2025-01-28 07:29:05','V',5584021206651820,2025,'2025-01-28 07:29:03','456832694300327005012999',1,2,16,'I','',1,0,1,'','',4) 28/01/2025 07:29:57.6280 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:35:45.1318 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:38:28.7750 745 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 07:38:28.7780 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:38:53.3764 820 ms. EXEC: update payReceipt set recCreation = '2025-01-28 07:38:52',recModify = '2025-01-28 07:38:52',recUseId=0,recStatus='V' where recId = 346537 28/01/2025 07:39:35.8707 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 07:41:26.4025 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:42:38.6086 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 07:47:40.9648 814 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 07:47:44.4181 843 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 07:48:04.7586 690 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 07:49:32.1046 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 07:53:27.2885 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:55:26.9414 1545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:55:54.6228 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:56:23.9484 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 07:56:59.1899 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 07:58:11.1369 2412 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 07:59:00.5999 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 08:00:32.4592 1017 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 08:03:40.2505 600 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 08:03:44.8435 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 08:06:35.1611 603 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 ('2025-01-28 08:06:07',1,'V',5331016283613310,5527875695086260,2025,'2025-01-28 08:06:07',4,1,0,4,'2025-01-28 08:21:07','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/01/2025 08:07:21.3840 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 08:07:21.5421 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 08:07:40.5598 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 08:11:25.8140 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 08:11:25.8701 549 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/01/2025 08:23:41.5773 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 08:33:11.9401 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 08:35:01.9235 774 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 08:40:07.4253 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 09:02:35.0937 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 09:06:08.7993 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 09:10:41.2350 1018 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,'2025-01-28 09:10:40','V',5199274808683720,2025,'2025-01-28 09:10:38','456833303800327005012999',1,2,16,'I','',1,0,1,'','',4) 28/01/2025 09:16:35.0901 643 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 09:16:35.4433 585 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 09:16:42.6992 542 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/01/2025 09:19:27.0928 1005 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3937, trcLastPrinted = '2500703937', trcLastDate = '2025-01-28 09:19:26' where trcStatus='V' and trcTerId = 18 28/01/2025 09:24:03.2601 922 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 09:24:07.0586 1175 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/01/2025 09:24:09.6894 1087 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/01/2025 09:28:32.9730 1074 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 09:29:04.0858 595 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 09:31:08.7339 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 09:36:46.6113 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 09:37:41.2778 756 ms. OPEN: SELECT * FROM tabTerminalExtraMem WHERE extStatus=@extStatus AND extTerId = @extTerId 28/01/2025 09:37:43.0780 1686 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,'2025-01-28 09:37:41','V',5673074054843710,2025,'2025-01-28 09:37:39','456833465900327005012999',1,2,16,'I','',1,0,1,'','',4) 28/01/2025 09:38:13.5843 643 ms. EXEC: update payCurInventory set curQuantity=round(curQuantity+35,8),curAmount=round(curAmount+1750,8) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N' 28/01/2025 09:38:16.1400 2229 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-28 09:35:34',5,3,42101,0,50,-35,-1750,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-28 09:35:34',5,3,42101,0,50,35,1750,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-28 09:35:34',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 ('2025-01-28 09:35:34',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 ('2025-01-28 09:35:34',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 ('2025-01-28 09:35:34',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 ('2025-01-28 09:35:34',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 28/01/2025 09:40:26.7212 1398 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 09:40:28.9617 509 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4901436734240590,5500727506181110,2025,'2025-01-28 09:40:28',' Date: 1/28/2025 9:40:27 AM Code: 456833461700327005012999 Entry Date: 1/28/2025 9:36:57 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500703938 ',0) 28/01/2025 09:40:37.8676 729 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,'2025-01-28 09:40:37','V',5077959483101240,2025,'2025-01-28 09:40:35','456833483500327001012999',1,2,1,'I','',1,0,1,'','',4) 28/01/2025 09:46:01.4935 1404 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/01/2025 09:49:06.7721 1688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 09:52:24.0857 522 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/01/2025 09:56:07.1315 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 09:57:01.2466 523 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 28/01/2025 09:57:55.4108 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 09:58:38.4255 1095 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 09:59:29.1553 1461 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:01:40.7071 663 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/01/2025 10:05:04.0517 643 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,'2025-01-28 10:05:03','V',5442332594836290,2025,'2025-01-28 10:05:02','456833552600327001012999',2,2,2,'O','',0,'2025-01-28 10:05:03',1,'','',0) 28/01/2025 10:05:05.0734 616 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/01/2025 10:07:22.0688 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:09:21.0802 1537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:09:21.1903 1644 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 28/01/2025 10:10:18.4024 583 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-01-28 10:10:17',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 28/01/2025 10:10:25.1750 527 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 28/01/2025 10:10:42.0352 563 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 ('2025-01-28 10:10:41',0,'V',4826883366276920,5006771181099810,2025,'2025-01-28 10:10:41',18,1,0,4,'2025-01-28 10:25:41','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/01/2025 10:11:29.3057 764 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 10:12:35.7751 1784 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 10:12:49.4602 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 10:14:46.9276 980 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,'2025-01-28 10:14:45','V',5043768953470920,2025,'2025-01-28 10:14:44','456833483500327001012999',2,2,2,'O','',0,'2025-01-28 10:14:45',1,'','',0) 28/01/2025 10:14:55.4993 1610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:16:53.6221 934 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 10:16:55.5744 766 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 10:16:54' where payTraUID = 4840031030951350 and payStatus='V' and payEnabled=1 28/01/2025 10:17:00.6047 523 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/01/2025 10:17:13.5934 785 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 ('2025-01-28 10:17:12',0,'V',5245333934042310,4880025030683690,2025,'2025-01-28 10:17:12',3,1,0,4,'2025-01-28 10:32:12','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 28/01/2025 10:17:35.3789 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:17:35.3789 634 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 10:19:02.6622 689 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5314899030216530,5396247056721740,2025,'2025-01-28 10:19:01','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/28/2025 9:43:08 AM Date : 1/28/2025 10:19:00 AM Code : 456833498800327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 28/01/2025 10:19:03.5187 657 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-28 10:19:02',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'; 28/01/2025 10:19:22.3563 2185 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,'2025-01-28 10:19:20','V',5676032946368140,2025,'2025-01-28 10:19:20','456833716000327005012999',1,2,16,'I','',1,0,1,'','',4) 28/01/2025 10:19:46.4404 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 10:19:50.0208 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,'2025-01-28 10:19:49','V',5260995880444970,2025,'2025-01-28 10:19:48','456833718800327001012999',1,2,1,'I','',1,0,1,'','',4) 28/01/2025 10:20:25.2383 2350 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 10:20:22' where traUID = 4880025030683690 and traStatus='V' and traEnabled=1 28/01/2025 10:24:28.5936 903 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 10:25:21.6830 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:26:49.1164 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:28:29.4383 769 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/01/2025 10:28:32.4683 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 10:28:32.6004 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:28:37.6338 773 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5153576911030080,4913322409794460,2025,'2025-01-28 10:28:36','---------------------------------- %The Mall P0006032390 Canceled payment ---------------------------------- POF Entry : 1/28/2025 10:14:07 AM Date : 1/28/2025 10:28:34 AM Code : 456833684700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 0.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',1) 28/01/2025 10:28:39.0647 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:31:55.0515 632 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 ('2025-01-28 10:31:51',0,'V',4711472552718930,5260995880444970,2025,'2025-01-28 10:31:51',3,1,0,4,'2025-01-28 10:46:51','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 1 ms.) 28/01/2025 10:31:57.2599 1738 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-28 10:31:55',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'; 28/01/2025 10:32:33.3430 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:33:13.1966 646 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 28/01/2025 10:33:45.4961 721 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/01/2025 10:36:19.7240 801 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 10:38:19.0396 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:38:47.1374 567 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 16 28/01/2025 10:39:23.1464 934 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/01/2025 10:42:34.0638 6178 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 28/01/2025 10:42:44.5958 639 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 ('2025-01-28 10:42:43',0,'V',5011310926717090,5572417444677810,2025,'2025-01-28 10:42:43',18,1,0,4,'2025-01-28 10:57:43','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/01/2025 10:43:16.0037 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:43:35.1555 1049 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,'2025-01-28 10:43:34','V',4870860834358390,2025,'2025-01-28 10:43:33','456833661900327005012999',2,2,2,'O','',0,'2025-01-28 10:43:34',1,'','',0) 28/01/2025 10:43:39.5554 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 10:43:54.8607 802 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 28/01/2025 10:44:53.1996 6840 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 28/01/2025 10:46:54.6656 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 10:47:11.4498 557 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5256990528820480,4858736107347100,2025,'2025-01-28 10:47:10',' Date: 1/28/2025 10:47:10 AM Code: 456833686300327005012999 Entry Date: 1/28/2025 10:14:23 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500703954 ',0) 28/01/2025 10:51:23.8062 1287 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,'2025-01-28 10:51:22','V',5618972283337560,2025,'2025-01-28 10:51:21','456833139500327005012999',2,2,2,'O','',0,'2025-01-28 10:51:22',1,'','',0) 28/01/2025 10:52:58.3082 1042 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 28/01/2025 10:53:43.8396 640 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 10:56:17.9154 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:58:51.3607 2087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 10:59:36.0586 728 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 ('2025-01-28 10:59:35',0,'V',5454344823361020,5216931363958730,2025,'2025-01-28 10:59:35',18,1,0,4,'2025-01-28 11:14:35','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/01/2025 11:01:36.6220 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 11:03:12.1507 1777 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,'2025-01-28 11:03:10','V',4984055246414600,2025,'2025-01-28 11:03:08','456833978800327001012999',1,2,1,'I','',1,0,1,'','',4) 28/01/2025 11:03:20.2421 697 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:07:03.6782 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 11:09:06.6872 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:10:52.3677 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:12:24.6833 569 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 11:13:55.6040 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 11:18:40.5771 990 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/01/2025 11:22:52.6803 558 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 28/01/2025 11:23:04.7433 1861 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-28 11:23:02',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'; 28/01/2025 11:23:05.5028 629 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-28 11:23: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'; 28/01/2025 11:24:53.7230 1202 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 11:25:09.8117 3337 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 28/01/2025 11:25:37.4532 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 11:27:10.0329 762 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 11:27:09' where traUID = 4867340645954790 and traStatus='V' and traEnabled=1 28/01/2025 11:28:54.0864 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:34:47.8484 808 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/01/2025 11:35:11.2850 3081 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-28 11:35:08',0,16,'2025-01-28 11:35:08','','Unauthorized Transit Entry 2') 28/01/2025 11:36:29.3551 594 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5763702666309880,5076270630468220,2025,'2025-01-28 11:36:28',' Date: 1/28/2025 11:36:01 AM Code: 456834095600327005012999 Entry Date: 1/28/2025 11:22:36 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500401200 ',0) 28/01/2025 11:42:27.4340 1499 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 11:42:25' where traUID = 5035180226532020 and traStatus='V' and traEnabled=1 28/01/2025 11:44:43.7889 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:44:50.8476 1091 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,'2025-01-28 11:44:49','V',5703570818705990,2025,'2025-01-28 11:44:49','456834228900327005012999',1,2,16,'I','',1,0,1,'','0560008304916',190,0) 28/01/2025 11:46:14.4584 690 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 11:46:13' where payTraUID = 5330855988358430 and payStatus='V' and payEnabled=1 28/01/2025 11:46:47.6135 729 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:49:10.5529 518 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-01-28 11:49:10',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 28/01/2025 11:49:39.5062 632 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 ('2025-01-28 11:49:12',6,'V',5622639613710560,5199274808683720,2025,'2025-01-28 11:49:12',4,1,0,4,'2025-01-28 12:04:12','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/01/2025 11:49:40.5139 909 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_ticket' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 28/01/2025 11:49:41.4285 913 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-28 11:49:40',4,6,'2025-01-28 11:49:40','456833303800327005012999','Payed (Credit Card ) Ticket ') 28/01/2025 11:50:14.2114 673 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/01/2025 11:50:29.9919 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 11:52:39.6734 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:59:00.8887 558 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 11:59:00' where payTraUID = 5454900283046770 and payStatus='V' and payEnabled=1 28/01/2025 11:59:01.4121 522 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 11:59:00' where traUID = 5454900283046770 and traStatus='V' and traEnabled=1 28/01/2025 11:59:05.1075 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:59:25.8404 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 11:59:58.6062 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:01:04.8794 1353 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/01/2025 12:05:44.4249 669 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5129887696848830,5254310415552280,2025,'2025-01-28 12:05:43',' Date: 1/28/2025 12:05:43 PM Code: 456834292300327005012999 Entry Date: 1/28/2025 11:55:23 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500703966 ',0) 28/01/2025 12:07:00.1024 1230 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,'2025-01-28 12:06:58','V',5763610140332060,2025,'2025-01-28 12:06:56','456834361600327001012999',1,2,1,'I','',1,0,1,'','',4) 28/01/2025 12:07:02.0957 541 ms. EXEC: update payReceipt set recCreation = '2025-01-28 12:07:01',recModify = '2025-01-28 12:07:01',recUseId=0,recStatus='V' where recId = 346625 28/01/2025 12:07:38.5901 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:07:44.0697 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:08:15.4687 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:09:06.8131 600 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 12:09:21.6180 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:09:30.5489 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:11:18.7721 1544 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,'2025-01-28 12:11:17','V',5536260689548330,2025,'2025-01-28 12:11:16','456834061900327005012999',2,2,2,'O','',0,'2025-01-28 12:11:17',1,'','',0) 28/01/2025 12:11:19.9669 937 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 12:11:19' where traUID = 5547863049151550 and traStatus='V' and traEnabled=1 28/01/2025 12:11:25.2274 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:12:14.4042 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:14:26.9999 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:16:36.0180 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:17:55.8902 1108 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:17:58.7862 1458 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:18:21.4573 904 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/01/2025 12:18:42.2752 759 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:18:42.9766 551 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/01/2025 12:20:43.4760 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:23:32.2997 708 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:26:07.7554 939 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 12:26:26.9822 1252 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4886441094115910,5664747511534020,2025,'2025-01-28 12:26:25',' Date: 1/28/2025 12:26:24 PM Code: 456834378300327005012999 Entry Date: 1/28/2025 12:09:43 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 # 2500703972 ',0) 28/01/2025 12:28:38.2768 668 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 28/01/2025 12:28:45.8859 651 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 12:28:55.3031 652 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399341 else acvFstPayId end),acvLstPayId = 399341 where acvSftId = 889 and acvCodeId = 3 28/01/2025 12:29:07.2151 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:31:40.6945 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:33:15.3176 588 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/01/2025 12:35:44.4141 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:36:55.3764 616 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 12:37:25.4615 1460 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 12:39:34.4475 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:43:10.4606 561 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 12:43:11.4423 1150 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 12:45:13.9060 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:45:18.7142 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:47:58.2747 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:49:24.8784 509 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 28/01/2025 12:49:26.1273 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:51:26.6216 640 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-28 12:51:25',0,16,'2025-01-28 12:51:25','','Unauthorized Transit Entry 2') 28/01/2025 12:51:29.9609 1533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:53:12.7534 720 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 28/01/2025 12:53:12.7544 852 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 12:54:24.3452 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:55:38.2685 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 12:55:50.3636 1724 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 28/01/2025 12:56:13.9383 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 12:56:14.4737 508 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/01/2025 13:01:51.7887 501 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,'2025-01-28 13:01:51','V',5526433007077770,2025,'2025-01-28 13:01:49','456834429900327005012999',2,2,2,'O','',0,'2025-01-28 13:01:51',1,'','',0) 28/01/2025 13:02:05.8161 7377 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/01/2025 13:02:05.8581 7177 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 13:02:05.8581 2117 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:02:05.8601 2322 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 28/01/2025 13:04:19.9896 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:04:53.1387 612 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-28 13:04:52',17,1,'2025-01-28 13:04:52','456834492400327005012999','Pagato (Contanti ) Biglietto ') 28/01/2025 13:05:41.9002 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:05:57.3155 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:06:23.2328 552 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 13:09:51.0885 522 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/01/2025 13:09:58.3943 538 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/01/2025 13:10:04.9207 997 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:10:22.4053 2167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:13:18.7490 561 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,'2025-01-28 13:13:18','V',5147579828595210,2025,'2025-01-28 13:13:16','456834558500327005012999',2,2,2,'O','',0,'2025-01-28 13:13:18',1,'','',0) 28/01/2025 13:13:30.9631 2421 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:20:55.7138 953 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:21:21.6992 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:23:00.6062 800 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:23:39.2459 550 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 13:23:38' where payTraUID = 5391692296038840 and payStatus='V' and payEnabled=1 28/01/2025 13:25:23.7236 1035 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 28/01/2025 13:25:24.6833 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:25:37.0545 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:25:37.6069 629 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4906805768677460,4944366902317240,2025,'2025-01-28 13:25:36',' Date: 1/28/2025 1:25:35 PM Code: 456834134500327005012999 Entry Date: 1/28/2025 11:29:05 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 # 2500703989 ',0) 28/01/2025 13:27:02.2394 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:29:40.1437 794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:33:35.1395 3257 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 13:35:00.7106 2999 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 ('2025-01-28 13:34:57',0,'V',5595982379350560,4675077955238550,2025,'2025-01-28 13:34:57',18,1,0,4,'2025-01-28 13:49:57','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/01/2025 13:35:01.8663 1095 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3990, trcLastPrinted = '2500703990', trcLastDate = '2025-01-28 13:35:00' where trcStatus='V' and trcTerId = 18 28/01/2025 13:37:10.6112 1027 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 13:37:09' where traUID = 4675077955238550 and traStatus='V' and traEnabled=1 28/01/2025 13:37:18.1282 1826 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 28/01/2025 13:41:24.8969 1301 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:42:31.9746 1090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:44:06.5457 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:44:48.5297 917 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:45:06.8069 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 13:47:41.3430 751 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,'2025-01-28 13:47:40','V',5365027310124630,2025,'2025-01-28 13:47:40','456834966000327001012999',1,2,1,'I','',1,0,1,'','',4) 28/01/2025 13:51:46.9639 810 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:51:47.0869 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:52:33.7861 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:53:49.1524 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 13:54:28.4276 1920 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-28 13:54:26',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 ('2025-01-28 13:54:26',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 28/01/2025 13:56:22.1845 1244 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,'2025-01-28 13:56:20','V',5222335036433060,2025,'2025-01-28 13:56:20','456835018000327005012999',1,2,16,'I','',1,0,1,'','',4) 28/01/2025 13:56:46.9890 1047 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 13:56:51.9493 4490 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 13:56:47' where payTraUID = 4664610470278060 and payStatus='V' and payEnabled=1 28/01/2025 13:56:56.6795 3545 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399390 else acvFstPayId end),acvLstPayId = 399390 where acvSftId = 889 and acvCodeId = 3 28/01/2025 13:56:56.7305 3583 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/01/2025 13:58:39.3380 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 13:58:42.0408 1100 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:02:08.9848 557 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 28/01/2025 14:03:50.6947 926 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/01/2025 14:03:54.7824 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:04:35.2504 1425 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399398 else acvFstPayId end),acvLstPayId = 399398 where acvSftId = 891 and acvCodeId = 3 28/01/2025 14:04:35.2684 1298 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 ('2025-01-28 14:04:33',0,'V',5345713411772070,4901513563174520,2025,'2025-01-28 14:04:33',18,1,0,4,'2025-01-28 14:19:33','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 28/01/2025 14:05:35.0263 1108 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:05:56.2824 522 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 28/01/2025 14:07:10.5060 3077 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:11:24.3403 542 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 ('2025-01-28 14:11:21',0,'V',5501595523464720,5693931774928830,2025,'2025-01-28 14:11:21',3,1,0,4,'2025-01-28 14:26:21','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 28/01/2025 14:11:33.2182 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:12:36.2763 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:12:56.6679 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:14:33.1363 517 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5514092241138460,5368426319562180,2025,'2025-01-28 14:14:32',' Data: 1/28/2025 2:11:07 PM Codice: 456834949500327005012999 Ingresso: 1/28/2025 1:44:55 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500600650 ',0) 28/01/2025 14:16:01.0559 874 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:16:37.2140 746 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 14:16:37.7003 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:18:54.9109 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:19:09.4466 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:20:19.0440 1138 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-28 14:20:17' where subId = 206 28/01/2025 14:20:27.8819 751 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/01/2025 14:21:02.2418 809 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:21:19.2152 771 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:21:53.4820 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:22:59.5861 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:22:59.8283 1418 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,'2025-01-28 14:22:58','V',4744363425860450,2025,'2025-01-28 14:22:56','456835147400327005012999',2,2,2,'O','',0,'2025-01-28 14:22:58',1,'','0810007108790',194,0) 28/01/2025 14:23:01.4384 883 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 14:23:00' where payTraUID = 4909071837595860 and payStatus='V' and payEnabled=1 28/01/2025 14:23:08.2939 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:31:33.8382 517 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/01/2025 14:34:15.4100 749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:36:04.8820 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:38:02.5575 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:38:43.3217 1813 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,'2025-01-28 14:38:41','V',5066940572570090,2025,'2025-01-28 14:38:39','456835271900327005012999',1,2,16,'I','',1,0,1,'','',4) 28/01/2025 14:46:55.5301 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:47:21.8887 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:47:41.7899 555 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 14:47:45.5544 979 ms. OPEN: select * from tabTerminal where terId = 16 28/01/2025 14:48:25.6462 2459 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 14:50:52.6432 571 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/01/2025 14:50:52.9204 947 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:50:57.4324 637 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,'2025-01-28 14:50:56','V',5584761135713660,2025,'2025-01-28 14:50:56','456835345600327005012999',1,2,16,'I','',1,0,1,'','',4) 28/01/2025 14:51:06.2733 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:53:38.4819 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:53:51.4695 1603 ms. EXEC: update payReceipt set recCreation = '2025-01-28 14:53:49',recModify = '2025-01-28 14:53:49',recUseId=0,recStatus='V' where recId = 346719 28/01/2025 14:54:34.5603 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:54:47.7111 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:55:03.4236 859 ms. EXEC: update payReceipt set recCreation = '2025-01-28 14:55:02',recModify = '2025-01-28 14:55:02',recUseId=0,recStatus='V' where recId = 346721 28/01/2025 14:55:07.0600 1310 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:55:36.9949 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 14:55:54.9039 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:56:00.3065 830 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 ('2025-01-28 14:52:34',1,'V',4831197996302940,5576362393094200,2025,'2025-01-28 14:52:34',17,1,0,4,'2025-01-28 15:07:34','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 28/01/2025 14:57:42.6608 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 14:58:15.3776 697 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:03:02.6312 1363 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 15:04:13.9718 913 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 15:04:12' where traUID = 5392429853732930 and traStatus='V' and traEnabled=1 28/01/2025 15:04:17.7574 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:07:40.3265 950 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:07:45.0767 2325 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 15:07:47.5603 2479 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 28/01/2025 15:11:56.2142 666 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 15:16:20.0772 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 15:16:51.1970 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 15:17:23.2894 975 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-28 15:17:21',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 ('2025-01-28 15:17:21',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 28/01/2025 15:17:24.0209 731 ms. EXEC: update payInventory set invCreation = '2025-01-28 15:17:23',invModify = '2025-01-28 15:17:23',invUseId=0,invStatus='V' where invId = 233702 28/01/2025 15:20:33.0120 780 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 15:23:46.0137 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:28:31.7634 1114 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,'2025-01-28 15:28:30','V',4686995648454750,2025,'2025-01-28 15:28:30','456835352400327005012999',2,2,2,'O','',0,'2025-01-28 15:28:30',1,'','',0) 28/01/2025 15:31:44.6740 815 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 15:31:43' where payTraUID = 5192244774385490 and payStatus='V' and payEnabled=1 28/01/2025 15:32:01.1911 638 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 15:32:00' where traUID = 4745019286298230 and traStatus='V' and traEnabled=1 28/01/2025 15:32:55.2771 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,'2025-01-28 15:32:54','V',4696773505665660,2025,'2025-01-28 15:32:53','456835103500327005012999',2,2,2,'O','',0,'2025-01-28 15:32:54',1,'','',0) 28/01/2025 15:33:00.6437 703 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:33:29.5690 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:34:07.1221 1704 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-28 15:34:05',0,0,'V',5116576566048070,4624902602648540,2025,'2025-01-28 15:34:05',3,'KES',1,50,50,'N',''); 28/01/2025 15:34:12.4586 1322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 15:36:33.4597 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 15:37:35.7072 676 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/01/2025 15:37:41.1519 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:45:15.8782 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 15:48:09.1268 1293 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-28 15:48:07',0,16,'2025-01-28 15:48:07','','Unauthorized Transit Entry 2') 28/01/2025 15:50:10.7199 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:52:32.1873 839 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-28 15:52:31',4,6,'2025-01-28 15:52:31','456835600600327005012999','Payed (Credit Card ) Ticket ') 28/01/2025 15:53:41.0823 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:54:51.7984 1714 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 15:54:50' where payTraUID = 5394554876510650 and payStatus='V' and payEnabled=1 28/01/2025 15:57:11.7858 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:58:15.9136 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 15:58:31.4039 696 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456835661600327001012999' 28/01/2025 16:00:24.9847 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 16:01:31.1208 777 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 16:03:43.1049 1595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:04:56.2827 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:06:36.2734 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 16:11:02.5030 900 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-28 16:11:01',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-28 16:11:01',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'; 28/01/2025 16:13:37.6985 632 ms. EXEC: update payInventory set invCreation = '2025-01-28 16:13:37',invModify = '2025-01-28 16:13:37',invUseId=0,invStatus='V' where invId = 233716 28/01/2025 16:17:06.1736 974 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 16:17:08.4842 1239 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:18:40.3174 2179 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 28/01/2025 16:22:36.2830 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:24:47.7077 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:25:06.6793 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:26:39.1030 868 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 16:27:29.2424 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 16:29:24.9696 1530 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 16:29:49.1328 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:31:53.1930 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:33:12.4418 894 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-28 16:33:11',0,2,'2025-01-28 16:33:11','','Unauthorized Transit Exit 1') 28/01/2025 16:34:17.8324 999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:35:36.0867 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:37:24.0367 782 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-28 16:37:23' where subId = 14 28/01/2025 16:38:05.1681 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:38:14.2552 565 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_invalidbadge' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 28/01/2025 16:38:45.6991 595 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 16:40:27.9494 802 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 16:40:28.8840 636 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 16:40:28' where traUID = 5085891950017420 and traStatus='V' and traEnabled=1 28/01/2025 16:40:37.4827 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 16:40:58.4097 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 16:41:03.3940 2084 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 ('2025-01-28 16:40:59',0,'V',5186884623613970,4757746341380730,2025,'2025-01-28 16:40:59',3,1,0,4,'2025-01-28 16:55:59','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 28/01/2025 16:41:19.1225 820 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 16:44:01.7620 1235 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 28/01/2025 16:46:44.2474 818 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 16:46:52.7991 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 16:47:00.6834 3031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:47:43.0816 1407 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:50:13.6101 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:50:25.8783 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:54:32.8027 870 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 16:58:19.0861 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 16:59:04.8006 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 17:01:43.4034 773 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 17:12:09.0041 1185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 17:12:14.6359 2136 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 ('2025-01-28 17:12:12',0,'V',5356622927557190,4763182013683260,2025,'2025-01-28 17:12:12',2,1,0,-1,'2025-01-28 18:12:12','S','KES',0,0,0,'','','',3,0,0) 28/01/2025 17:12:17.6659 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 17:12:19.0088 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 17:12:25.6012 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 17:19:09.0263 728 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,'2025-01-28 17:19:08','V',5350966503384060,2025,'2025-01-28 17:19:07','456836131600327005012999',2,2,2,'O','',0,'2025-01-28 17:19:08',1,'','0230003957422',29,0) 28/01/2025 17:19:10.8946 563 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-28 17:19:09' where traUID = 5087486771350470 and traStatus='V' and traEnabled=1 28/01/2025 17:22:58.3693 569 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 28/01/2025 17:25:08.4231 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 17:27:54.0026 722 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 28/01/2025 17:33:20.6375 1488 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 28/01/2025 17:33:25.7859 628 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/01/2025 17:33:25.9340 983 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 17:34:51.5121 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 17:36:10.9951 1198 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 17:42:52.5640 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 17:53:01.9251 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 17:59:29.8128 1320 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 18:01:49.7557 739 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 28/01/2025 18:09:43.2813 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 18:09:43.6685 586 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 28/01/2025 18:10:09.3658 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 18:14:17.3459 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 18:14:39.5067 3640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 18:19:56.9190 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 18:29:45.5799 868 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 18:30:41.9466 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 18:43:31.8488 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 18:47:47.9014 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 18:58:37.9794 737 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 28/01/2025 19:03:26.9070 971 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 19:03:27.0741 502 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 28/01/2025 19:03:33.0311 724 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4042, trcLastPrinted = '2500704042', trcLastDate = '2025-01-28 19:03:32' where trcStatus='V' and trcTerId = 18 28/01/2025 19:03:56.5628 545 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 19:03:55' where payTraUID = 4933297098444050 and payStatus='V' and payEnabled=1 28/01/2025 19:04:10.3200 2298 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:08:32.3347 1888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:11:59.1472 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:12:41.5626 879 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,'2025-01-28 19:12:40','V',4833809841734100,2025,'2025-01-28 19:12:39','456835379900327005012999',2,2,2,'O','',0,'2025-01-28 19:12:40',1,'','',0) 28/01/2025 19:14:45.3673 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 19:17:02.0056 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 19:17:33.2355 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:20:49.4308 1303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:21:52.2028 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:22:18.6496 879 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 19:24:30.1628 1750 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 19:25:35.3635 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:27:13.6334 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:30:23.2094 941 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 19:33:09.9161 3581 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 28/01/2025 19:35:26.3044 653 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,'2025-01-28 19:35:25','V',4646987472646120,2025,'2025-01-28 19:35:25','456833797900327005012999',2,2,2,'O','',0,'2025-01-28 19:35:25',1,'','',0) 28/01/2025 19:40:40.3372 3355 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 28/01/2025 19:43:56.5074 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 19:52:00.4602 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 19:54:45.1715 768 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 28/01/2025 19:57:57.5348 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 19:58:02.9494 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:04:05.1446 989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:07:29.2137 1668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:11:09.1265 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:13:42.0290 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 20:13:45.1681 519 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/01/2025 20:14:36.5625 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:20:23.8825 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:23:06.8629 4068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:24:06.6969 1686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:33:09.2206 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:33:15.6039 734 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/01/2025 20:37:02.8495 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:38:25.2838 2994 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 20:39:17.2376 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:40:13.5453 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:41:17.1359 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:41:42.7131 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:49:32.5169 801 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 20:53:41.1324 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:54:07.3159 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 20:57:53.0754 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 21:04:53.7633 510 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,'2025-01-28 21:04:53','V',5082080264541470,2025,'2025-01-28 21:04:52','456837589200327001012999',1,2,1,'I','',1,0,1,'','',4) 28/01/2025 21:05:12.3627 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:09:39.1184 869 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/01/2025 21:10:11.7342 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:11:25.8559 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:12:44.0623 1515 ms. EXEC: update payReceipt set recCreation = '2025-01-28 21:12:42',recModify = '2025-01-28 21:12:42',recUseId=0,recStatus='V' where recId = 346818 28/01/2025 21:14:03.4774 1839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:15:53.2979 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:15:56.8033 600 ms. OPEN: select * from tabTerminal where terId = 2 28/01/2025 21:16:55.3174 734 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 21:17:00.4339 520 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,'2025-01-28 21:16:59','V',4893059521551390,2025,'2025-01-28 21:16:58','456836738500327005012999',2,2,2,'O','',0,'2025-01-28 21:16:59',1,'','',0) 28/01/2025 21:17:05.0740 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 21:18:20.1503 1418 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 28/01/2025 21:18:20.1523 899 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:19:48.4905 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:22:53.0961 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:26:16.1560 2568 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 ('2025-01-28 21:26:13',0,'V',5424173252575880,4895385623844930,2025,'2025-01-28 21:26:13',2,1,0,-1,'2025-01-28 22:26:13','S','KES',0,0,0,'','','',3,0,0) 28/01/2025 21:27:33.3377 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:29:18.8334 1361 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:41:48.5455 503 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/01/2025 21:42:49.9957 611 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-28 21:42:49' where subId = 11 28/01/2025 21:50:13.1474 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 21:53:29.2869 634 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 28/01/2025 21:55:01.0094 565 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 28/01/2025 21:56:20.9177 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 21:58:51.4805 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 22:04:17.0135 575 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-28 22:04:16' where subId = 11 28/01/2025 22:06:02.2230 666 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 22:06:01' where payTraUID = 5614414894463940 and payStatus='V' and payEnabled=1 28/01/2025 22:08:58.1028 525 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-28 22:08:57' where payTraUID = 5042346613091560 and payStatus='V' and payEnabled=1 28/01/2025 22:09:04.2660 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 22:12:39.4485 557 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 28/01/2025 22:18:36.3779 1415 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 22:24:31.8193 619 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 28/01/2025 22:41:07.7375 1771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 22:49:45.0290 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 28/01/2025 22:52:22.8544 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 22:57:42.9747 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 22:59:58.9538 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:00:37.5376 2494 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 28/01/2025 23:00:47.2111 1060 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:06:33.4591 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:09:46.1613 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:10:55.3766 2610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:11:54.9736 1369 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:12:23.5507 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:17:42.6344 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:23:42.1322 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:26:22.8369 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:36:31.3676 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 28/01/2025 23:43:59.3668 584 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 28/01/2025 23:47:41.4488 747 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,'2025-01-28 23:47:40','V',5189761061282880,2025,'2025-01-28 23:47:38','456838540000327005012999',2,2,2,'O','',0,'2025-01-28 23:47:40',1,'','0230003939927',164,0) 28/01/2025 23:58:34.8596 588 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)