07/02/2025 00:05:03.6191 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:09:21.0965 513 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5223450798497540,5183934421175520,2025,'2025-02-07 00:09:20','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/6/2025 11:17:34 PM Date : 2/7/2025 12:09:18 AM Code : 456928385400327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/02/2025 00:14:55.9783 4109 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/02/2025 00:16:10.4477 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 00:17:32.6004 606 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-02-06 23:17:31') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-07 00:17:31' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-07 00:17:31' and (resAreId = 1 or resAreId <= 0) nr: 0 07/02/2025 00:21:53.9774 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:24:52.7569 1406 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/02/2025 00:25:29.9190 570 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 07/02/2025 00:26:30.6962 1230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:27:25.6784 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 00:28:29.6808 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:32:35.7385 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:33:38.7331 1183 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:38:08.8501 850 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 00:38:59.8877 1186 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 07/02/2025 00:40:38.2733 610 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/02/2025 00:40:38.4774 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:40:38.4784 707 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/02/2025 00:44:16.2289 1689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:56:37.0376 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 00:57:36.7701 783 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 01:00:41.7523 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:09:34.6523 867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:15:35.9140 568 ms. EXEC: update payReceipt set recCreation = '2025-02-07 01:15:35',recModify = '2025-02-07 01:15:35',recUseId=0,recStatus='V' where recId = 349837 07/02/2025 01:17:22.9005 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 01:19:43.9080 1626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:25:21.7118 525 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 01:27:07.8337 866 ms. EXEC: update payReceipt set recCreation = '2025-02-07 01:27:06',recModify = '2025-02-07 01:27:06',recUseId=0,recStatus='V' where recId = 349838 07/02/2025 01:27:53.7207 571 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 01:28:10.0868 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 01:29:49.0689 530 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 07/02/2025 01:37:49.2021 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:44:47.0171 1976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:48:19.0037 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:49:27.6502 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:52:05.4521 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:53:07.2079 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 01:55:20.1980 863 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 02:04:18.6277 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:09:50.0622 1315 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:11:49.7802 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:12:40.6727 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:14:57.4994 1373 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:16:00.8743 533 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 02:21:48.4648 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:27:07.8921 1154 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 02:41:44.9052 4148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:43:18.2664 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:48:47.6585 1694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:52:11.1553 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 02:53:11.4462 639 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 02:57:21.6316 697 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 03:03:45.5747 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:05:02.1676 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:05:34.4194 1702 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/02/2025 03:05:56.5484 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:06:53.7121 2560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:11:13.8493 970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:14:26.5619 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:22:21.8778 583 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/02/2025 03:25:55.3524 2143 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/02/2025 03:25:56.0979 745 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 03:29:07.1083 541 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 07/02/2025 03:40:52.3990 1837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:41:09.6907 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:41:35.4151 919 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-02-07 03:41:32',0,'V',4885157818320200,5658127326340740,2025,'2025-02-07 03:41:32',3,1,0,4,'2025-02-07 03:56:32','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 07/02/2025 03:41:35.9345 505 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5658127326340740,4885157818320200,2025,'2025-02-07 03:41:35','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/7/2025 3:25:43 AM Date : 2/7/2025 3:41:32 AM Code : 456931234300327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/02/2025 03:42:50.3699 3142 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 03:43:36.8604 857 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-02-07 03:43:36','V',5591120237366840,2025,'2025-02-07 03:43:34','456931234300327005012999',2,2,2,'O','',0,'2025-02-07 03:43:36',1,'','',0) 07/02/2025 03:43:39.7364 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:44:15.2484 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:46:42.6122 830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:48:39.1802 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:52:01.2350 565 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 03:53:27.4594 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 03:59:19.4629 863 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-02-07 03:59:18','V',5344334665051940,2025,'2025-02-07 03:59:18','456931435800327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 04:06:09.5857 1546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 04:09:57.8223 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 04:11:10.4434 2246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 04:13:32.5547 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 04:18:26.4588 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 04:20:23.3499 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 04:21:59.2319 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 04:30:16.3336 585 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 04:38:19.3718 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 04:49:56.4389 999 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 04:49:56.5600 844 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 07/02/2025 04:57:10.7241 2246 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456931620100327005012999' 07/02/2025 04:57:16.3929 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 04:57:33.5726 3319 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:00:04.3497 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:00:29.0074 2357 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/02/2025 05:00:29.0084 1922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:06:12.9624 535 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 05:07:05.7951 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:17:42.4534 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:17:46.8704 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:26:24.7852 662 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 05:32:24.0956 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:33:03.2120 966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:34:40.0466 1801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:36:13.2518 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:40:23.8985 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 05:50:17.4206 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 05:51:42.5943 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 06:10:24.6476 1116 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 06:10:38.1788 1753 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/02/2025 06:16:21.4022 1165 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/02/2025 06:17:30.3109 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 06:21:10.3289 570 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 06:21:49.2793 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 06:28:22.9009 906 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 06:29:45.8561 900 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-02-07 06:29:44','V',4859461100956660,2025,'2025-02-07 06:29:42','456932234100327005012999',2,2,2,'O','',0,'2025-02-07 06:29:44',1,'','',0) 07/02/2025 06:31:24.9983 1294 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 06:34:52.2697 738 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 06:37:06.3585 1415 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 06:44:39.3253 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 06:46:32.8192 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 06:49:45.1855 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 06:50:18.2719 985 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 06:50:40.4939 935 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-07 06:50:39','V',4822411235729450,2025,'2025-02-07 06:50:38','456932463800327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 07:01:33.6810 1639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:02:40.0679 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:02:46.4713 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:03:15.0156 669 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 07:03:15.0166 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:14:18.7322 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:19:53.8101 1209 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/02/2025 07:26:20.9373 1013 ms. EXEC: update abbCards set carLastDate = '2025-02-07 07:26:19',carLastDirection='I' where carStatus='V' and carId = 192 07/02/2025 07:30:23.4346 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:32:39.8260 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 07:34:36.0107 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:36:25.1626 912 ms. EXECSCALAR: select count(*) from tabUser where useStatus='V' and useId = 1 and (useManualCashServices<>0 or useSuperuser<>0) nr: 1 (WAIT TIME 140 ms.) 07/02/2025 07:36:43.7262 1353 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403169 else acvFstPayId end),acvLstPayId = 403169 where acvSftId = 889 and acvCodeId = 3 07/02/2025 07:40:45.8202 786 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-02-07 07:40:45','V',5420618942118190,2025,'2025-02-07 07:40:43','456932764300327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 07:40:59.8977 1961 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 07:40:57',0,16,'2025-02-07 07:40:57','','Unauthorized Transit Entry 2') 07/02/2025 07:41:19.7792 803 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 07:41:31.2019 1727 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/02/2025 07:48:15.7869 2402 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:48:51.9744 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:52:45.7828 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 47 ms.) 07/02/2025 07:53:56.2856 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 07:56:38.1412 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:00:22.0168 1878 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 08:09:35.3116 1152 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 08:09:35.9310 617 ms. EXEC: update abbCards set carLastDate = '2025-02-07 08:09:35',carLastDirection='I' where carStatus='V' and carId = 30 07/02/2025 08:09:40.9895 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 08:14:06.5193 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:14:57.0625 1469 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 08:15:38.6657 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:15:38.7578 2449 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 08:19:56.6325 1594 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 08:19:57.5661 753 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 08:19:56' where traUID = 5443547705515370 and traStatus='V' and traEnabled=1 07/02/2025 08:20:03.1309 616 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 08:23:46.3871 557 ms. EXEC: update payCurInventory set curQuantity=0,curAmount=0 where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 07/02/2025 08:23:47.2346 847 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:23:40',5,3,42101,0,50,-12,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:23:40',5,3,42101,0,100,-70,-7000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:23:40',5,3,42101,0,200,-15,-3000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:23:40',5,3,42101,0,500,-2,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:23:40',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 07/02/2025 08:23:50.0946 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:28:18.5544 708 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 08:28:39.4426 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:28:49.8696 744 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 08:28:48' where traUID = 5616677799578870 and traStatus='V' and traEnabled=1 07/02/2025 08:28:59.2750 850 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 08:29:51.6014 699 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:29:47',5,3,42101,0,50,8,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+8,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:29:47',5,3,42101,0,200,2,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:29:47',5,3,42101,0,100,12,1200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+12,5),curAmount=round(curAmount+1200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 07/02/2025 08:29:52.2149 603 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:29:47',5,3,42101,0,50,2,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 08:29:47',5,3,42101,0,100,3,300,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+3,5),curAmount=round(curAmount+300,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 07/02/2025 08:31:58.3473 1595 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 08:31:56' where payTraUID = 5318839721996760 and payStatus='V' and payEnabled=1 07/02/2025 08:31:58.4183 1314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 70 ms.) 07/02/2025 08:31:58.8636 512 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 08:31:56' where traUID = 5318839721996760 and traStatus='V' and traEnabled=1 07/02/2025 08:32:37.0535 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:34:29.0464 714 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-02-07 08:34:28','V',5340095047412900,2025,'2025-02-07 08:34:26','456933086600327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 08:34:29.9410 539 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 08:35:21.0166 1331 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 08:35:21.1367 985 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:35:52.9672 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:41:08.9472 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:43:58.5041 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 08:46:05.3690 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 08:46:18.6680 627 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-02-07 08:46:18','V',4991876683602680,2025,'2025-02-07 08:46:17','456933157700327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 08:46:29.7515 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:47:46.4795 666 ms. EXEC: update paycash set casCreation = '2025-02-07 08:47:45',casModify = '2025-02-07 08:47:45',casUseId=0,casStatus='V' where casId = 208408 07/02/2025 08:50:29.0936 689 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 07/02/2025 08:51:04.6267 1479 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:54:19.5267 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 08:56:58.8506 991 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 08:57:06.0845 999 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-02-07 08:57:05','V',5184583814481150,2025,'2025-02-07 08:57:04','456932509300327005012999',2,2,2,'O','',0,'2025-02-07 08:57:05',1,'','',0) 07/02/2025 09:02:06.2529 613 ms. EXEC: update abbCards set carLastDate = '2025-02-07 09:02:05',carLastDirection='I' where carStatus='V' and carId = 183 07/02/2025 09:02:40.7122 736 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 09:02:39' where traUID = 4986673028711070 and traStatus='V' and traEnabled=1 07/02/2025 09:03:01.5853 1263 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-02-07 09:03:00',0,'V',5640908949192430,5068422334177120,2025,'2025-02-07 09:03:00',18,1,0,4,'2025-02-07 09:18:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 09:07:22.9454 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 09:10:40.7073 1333 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 09:10:38',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 07/02/2025 09:12:02.7949 671 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 09:12:03.8887 1092 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/02/2025 09:17:37.0513 567 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 09:19:35.5346 716 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 09:20:06.1964 742 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 09:20:27.7730 1543 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-02-07 09:20:26','V',5212239169130530,2025,'2025-02-07 09:20:25','456932764300327005012999',2,2,2,'O','',0,'2025-02-07 09:20:26',1,'','',0) 07/02/2025 09:20:32.6263 926 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 09:22:22.1875 649 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 09:27:02.9345 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 09:28:02.2036 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 09:29:15.8455 515 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 09:29:16.3949 544 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 09:29:33.2693 3561 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 09:32:09.3420 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 09:36:09.2415 847 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 62 ms.) 07/02/2025 09:36:34.5647 1052 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 09:36:33',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'; 07/02/2025 09:36:55.9641 709 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 09:36:55' where traUID = 5387199974531820 and traStatus='V' and traEnabled=1 07/02/2025 09:37:06.8765 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 09:37:35.1597 903 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 09:37:34',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-02-07 09:37:34',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'; 07/02/2025 09:38:17.4804 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 09:38:22.5808 697 ms. EXEC: update paycash set casCreation = '2025-02-07 09:38:21',casModify = '2025-02-07 09:38:21',casUseId=0,casStatus='V' where casId = 208419 07/02/2025 09:41:18.8182 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 09:42:39.8741 834 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 09:42:38',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'; 07/02/2025 09:42:41.2400 667 ms. EXEC: update payInventory set invCreation = '2025-02-07 09:42:40',invModify = '2025-02-07 09:42:40',invUseId=0,invStatus='V' where invId = 235494 07/02/2025 09:43:04.4828 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 09:43:37.4461 810 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 07/02/2025 09:44:01.7075 525 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 09:44:17.9555 668 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 09:45:14.1336 2962 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 09:46:15.1919 551 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/02/2025 09:46:57.1834 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 09:47:03.3275 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 09:47:17.4931 847 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-02-07 09:47:16','V',4857407145337360,2025,'2025-02-07 09:47:16','456933523600327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 09:47:23.9215 543 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 09:48:21.7987 928 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-02-07 09:48:20','V',4715163805721350,2025,'2025-02-07 09:48:19','456932463800327005012999',2,2,2,'O','',0,'2025-02-07 09:48:20',1,'','',0) 07/02/2025 09:48:28.0729 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 09:48:31.3822 549 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-02-07 09:47:40',1,'V',4639046231706480,5600512525342010,2025,'2025-02-07 09:47:40',4,1,0,4,'2025-02-07 10:02:40','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 09:48:33.3515 1957 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 09:48:31',4,1,'2025-02-07 09:48:31','456933453900327005012999','Payed (Credit Card ) Ticket ') 07/02/2025 09:48:36.7218 3270 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403205 else acvFstPayId end),acvLstPayId = 403205 where acvSftId = 889 and acvCodeId = 3 07/02/2025 09:48:37.8416 505 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5600512525342010,4639046231706480,2025,'2025-02-07 09:48:37',' Date: 2/7/2025 9:47:40 AM Code: 456933453900327005012999 Entry Date: 2/7/2025 9:35:39 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 # 2500401669 ',0) 07/02/2025 09:53:05.2367 1051 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 09:53:04',0,16,'2025-02-07 09:53:04','','Unauthorized Transit Entry 2') 07/02/2025 09:53:05.2407 1039 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-02-07 09:53:04','V',5757240665535940,2025,'2025-02-07 09:53:01','456933486800327005012999',2,2,2,'O','',0,'2025-02-07 09:53:04',1,'','',0) 07/02/2025 09:53:46.9049 1973 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-02-07 09:53:44','V',5159650770461480,2025,'2025-02-07 09:53:42','456933562200327005012999',1,2,16,'I','',1,0,1,'','0230003957463',25,0) 07/02/2025 09:53:47.7925 822 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 09:53:49.1214 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 09:55:16.5526 2064 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-02-07 09:55:14','V',5696520808766200,2025,'2025-02-07 09:55:12','456933571200327001012999',1,2,1,'I','',1,0,1,'','',4) 07/02/2025 09:55:29.9467 839 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-02-07 09:55:29','V',5091856037454180,2025,'2025-02-07 09:55:27','456933201600327005012999',2,2,2,'O','',0,'2025-02-07 09:55:29',1,'','',0) 07/02/2025 09:55:38.5125 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 09:55:46.5039 5009 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 09:56:58.3195 1146 ms. OPEN: show columns from tabTariff where Field = 'tarCustomMessage' 07/02/2025 09:56:58.3266 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 09:59:29.5760 740 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-02-07 09:59:28','V',5649413641077480,2025,'2025-02-07 09:59:28','456933596800327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 10:00:53.9642 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:01:12.3606 608 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 10:01:23.4211 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:02:49.4023 1202 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 10:07:07.6613 600 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 10:07:24.0914 1159 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-02-07 10:07:22',0,'V',5415510902908580,5287743553684230,2025,'2025-02-07 10:07:22',18,1,0,4,'2025-02-07 10:22:22','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 10:07:37.7296 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:09:09.2757 2110 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:09:12.9892 1665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:09:25.2655 1675 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 10:09:23' where payTraUID = 4897677595241780 and payStatus='V' and payEnabled=1 07/02/2025 10:14:01.7668 510 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 10:15:07.6854 816 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 10:16:29.5969 1077 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:18:54.7032 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:20:15.5930 898 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 10:20:16.3345 710 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 10:20:18.3158 1927 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 10:20:16' where payTraUID = 4835994865120750 and payStatus='V' and payEnabled=1 07/02/2025 10:25:55.2951 2270 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/02/2025 10:29:30.8341 845 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 10:33:38.2677 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:34:19.3445 947 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-02-07 10:34:18','V',5323477896918970,2025,'2025-02-07 10:34:17','456933637300327005012999',2,2,2,'O','',0,'2025-02-07 10:34:18',1,'','',0) 07/02/2025 10:34:21.5940 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:35:04.5081 1531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:36:03.6281 704 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403223 else acvFstPayId end),acvLstPayId = 403223 where acvSftId = 889 and acvCodeId = 3 07/02/2025 10:36:04.6618 715 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4857407145337360,5162515251910630,2025,'2025-02-07 10:36:03',' Date: 2/7/2025 10:35:12 AM Code: 456933523600327005012999 Entry Date: 2/7/2025 9:47:16 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 # 2500401675 ',0) 07/02/2025 10:36:21.0269 822 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 10:36:25.8902 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:39:51.5528 505 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 10:39:54.3717 1292 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 10:39:52' where traUID = 4857407145337360 and traStatus='V' and traEnabled=1 07/02/2025 10:39:59.3711 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:40:10.0594 523 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 10:40:34.9382 641 ms. EXEC: update abbCards set carLastDate = '2025-02-07 10:40:34',carLastDirection='O' where carStatus='V' and carId = 183 07/02/2025 10:41:17.7742 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:42:28.3921 503 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabCardConversionRules' nr: 1 07/02/2025 10:43:12.9142 757 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 10:43:11' where traUID = 5086946294590770 and traStatus='V' and traEnabled=1 07/02/2025 10:43:17.5594 673 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 10:43:17.6504 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:43:17.6674 772 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 07/02/2025 10:47:04.8493 558 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 10:48:02.9977 638 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-02-07 10:48:02','V',5150967679398710,2025,'2025-02-07 10:47:59','456933887900327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 10:48:04.8049 590 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5046082518997450,4792393623584910,2025,'2025-02-07 10:48:04','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/7/2025 10:14:00 AM Date : 2/7/2025 10:48:02 AM Code : 456933684000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/02/2025 10:48:06.4460 787 ms. EXEC: update payInventory set invCreation = '2025-02-07 10:48:05',invModify = '2025-02-07 10:48:05',invUseId=0,invStatus='V' where invId = 235511 07/02/2025 10:48:42.6706 714 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 10:48:41' where traUID = 5231453781494570 and traStatus='V' and traEnabled=1 07/02/2025 10:48:45.5265 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:48:52.1210 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:49:13.7946 967 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 10:51:40.7242 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:51:48.5935 510 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 10:52:01.0399 1263 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 07/02/2025 10:52:39.5840 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:55:37.6386 501 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 10:55:38.8955 1033 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 10:55:37',0,16,'2025-02-07 10:55:37','','Unauthorized Transit Entry 2') (WAIT TIME 358 ms.) 07/02/2025 10:57:40.0616 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 10:57:43.4599 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 10:59:58.3052 5033 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:01:45.3387 2345 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:02:22.8101 767 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-02-07 11:01:33',1,'V',5071500289049260,5005281563819760,2025,'2025-02-07 11:01:33',4,1,0,4,'2025-02-07 11:16:33','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 11:05:42.5344 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:05:46.5741 573 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-02-07 11:05:46','V',4620239309384390,2025,'2025-02-07 11:05:45','456933994500327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 11:05:47.2305 647 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 11:06:38.4492 972 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 11:07:13.5980 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:08:18.2518 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:08:41.4656 954 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/02/2025 11:12:00.6995 771 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:15:05.4667 1259 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 11:15:06.1751 1727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:15:06.9647 1496 ms. OPEN: select * from tabParameters order by parId desc limit 1 07/02/2025 11:15:06.9867 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 2 ms.) 07/02/2025 11:15:07.0187 1481 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 42 ms.) 07/02/2025 11:15:16.6662 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:15:29.4579 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:16:33.0410 955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:17:28.5826 557 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 11:17:28',0,16,'2025-02-07 11:17:28','','Unauthorized Transit Entry 2') 07/02/2025 11:23:26.1988 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:23:42.8621 1023 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 11:23:41',17,12,'2025-02-07 11:23:41','456933993200327005012999','Pagato (Contanti ) Biglietto ') 07/02/2025 11:23:44.7874 1688 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5707209059217240,5207319370643620,2025,'2025-02-07 11:23:43',' Data: 2/7/2025 11:23:31 AM Codice: 456933993200327005012999 Ingresso: 2/7/2025 11:05:32 AM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500600938 ',0) 07/02/2025 11:25:36.2859 539 ms. EXEC: update payReceipt set recCreation = '2025-02-07 11:25:35',recModify = '2025-02-07 11:25:35',recUseId=0,recStatus='V' where recId = 349925 07/02/2025 11:26:14.3517 526 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 11:26:13',0,2,'2025-02-07 11:26:13','','Unauthorized Transit Exit 1') 07/02/2025 11:26:50.7704 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:27:03.0667 1433 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:28:38.7905 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:28:57.6143 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:30:11.3552 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:30:16.2806 4598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:31:20.2609 602 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 11:31:48.8523 1320 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:31:51.2799 1579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:33:57.1702 1312 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:34:40.4165 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:35:38.8871 1468 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:39:47.2663 558 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-02-07 11:39:46','V',5620104753058990,2025,'2025-02-07 11:39:44','456934198400327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 11:40:23.3618 1580 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-02-07 11:40:21','V',5359275069433000,2025,'2025-02-07 11:40:19','456933828800327005012999',2,2,2,'O','',0,'2025-02-07 11:40:21',1,'','',0) 07/02/2025 11:40:56.2621 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:41:06.4420 1011 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 11:41:43.9894 508 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 11:41:57.9098 2879 ms. EXEC: update abbCards set carLastDate = '2025-02-07 11:41:54',carLastDirection='O' where carStatus='V' and carId = 171 (WAIT TIME 66 ms.) 07/02/2025 11:42:42.9854 971 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:44:05.2481 678 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 11:44:04' where payTraUID = 4620239309384390 and payStatus='V' and payEnabled=1 07/02/2025 11:44:11.2401 832 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:44:59.5959 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:54:46.0431 895 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 11:54:45' where traUID = 4916344752257970 and traStatus='V' and traEnabled=1 07/02/2025 11:54:50.5982 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:55:06.4129 848 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 07/02/2025 11:58:05.4296 614 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5464, trcLastPrinted = '2500705464', trcLastDate = '2025-02-07 11:58:04' where trcStatus='V' and trcTerId = 18 07/02/2025 11:59:01.7757 554 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 11:59:01' where payTraUID = 4989790566749410 and payStatus='V' and payEnabled=1 07/02/2025 11:59:05.9726 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 11:59:13.4566 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 11:59:32.8118 865 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 11:59:54.5435 681 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 11:59:53' where payTraUID = 5072850138732780 and payStatus='V' and payEnabled=1 07/02/2025 12:00:21.3767 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:00:28.7166 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:00:51.0928 1050 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-02-07 12:00:39',12,'V',4699185607299500,5057373133810160,2025,'2025-02-07 12:00:39',17,1,0,4,'2025-02-07 12:15:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 12:00:52.1385 767 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403272 else acvFstPayId end),acvLstPayId = 403272 where acvSftId = 894 and acvCodeId = 3 07/02/2025 12:00:57.9124 756 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 12:03:11.0556 1565 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 12:03:11.7160 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:03:19.6464 969 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:03:32.7433 1043 ms. EXECSCALAR: select terAddress from tabTerminal where terId = 16 nr: 5 07/02/2025 12:05:08.5021 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:12:05.5546 1371 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 403279 else acvFstPayId end),acvLstPayId = 403279 where acvSftId = 894 and acvCodeId = 3 07/02/2025 12:12:15.5814 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:13:19.4157 787 ms. OPEN: show columns from tabArea where Field = 'areType' 07/02/2025 12:13:30.5972 1532 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-02-07 12:12:37',1,'V',5604845209403830,4981810588739970,2025,'2025-02-07 12:12:37',4,1,0,4,'2025-02-07 12:27:37','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 12:13:44.7728 1410 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:13:52.5181 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:14:28.4144 759 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-07 12:14:27','V',5674450233564890,2025,'2025-02-07 12:14:26','456934291400327005012999',2,2,2,'O','',0,'2025-02-07 12:14:27',1,'','',0) 07/02/2025 12:15:31.1809 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:16:19.7708 1914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:16:23.6975 1795 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 12:16:47.5496 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:17:00.1342 784 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:17:00.1952 571 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 12:17:09.1352 554 ms. EXEC: update payReceipt set recCreation = '2025-02-07 12:17:08',recModify = '2025-02-07 12:17:08',recUseId=0,recStatus='V' where recId = 349954 07/02/2025 12:17:24.0764 789 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 12:17:24.1894 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:18:27.9336 632 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 12:19:44.3654 512 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456934111700327005012999' 07/02/2025 12:19:50.6537 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:22:08.5501 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:23:03.4532 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:23:05.5557 658 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 12:23:18.4554 2500 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:23:19.0108 2766 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 12:24:35.4776 547 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 12:24:50.1055 537 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-02-07 12:24:49','V',4697830832475960,2025,'2025-02-07 12:24:49','456934468900327001012999',1,2,1,'I','',1,0,1,'','',4) 07/02/2025 12:24:50.9440 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:25:25.2133 3505 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 07/02/2025 12:26:30.3794 1110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:27:32.1973 595 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 12:27:35.5986 550 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 12:28:36.6990 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:29:24.4073 1679 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 12:31:17.5049 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:34:06.5704 707 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-07 12:34:05','V',5438129530151570,2025,'2025-02-07 12:34:02','456934524200327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 12:36:12.7789 697 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 12:36:34.6757 589 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 12:38:36.3701 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:38:44.7338 835 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 12:38:43' where traUID = 5193748695461510 and traStatus='V' and traEnabled=1 07/02/2025 12:39:52.8900 776 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-02-07 12:39:52',0,'V',5097269782370770,5685032036574430,2025,'2025-02-07 12:39:52',18,1,0,4,'2025-02-07 12:54:52','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 12:39:53.6985 572 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5685032036574430,5097269782370770,2025,'2025-02-07 12:39:53',' Date: 2/7/2025 12:39:52 PM Code: 456934372200327005012999 Entry Date: 2/7/2025 12:08:42 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 # 2500705475 ',0) 07/02/2025 12:42:20.1767 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:43:06.9494 662 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-07 12:43:06','V',4800006804144710,2025,'2025-02-07 12:43:04','456934198400327005012999',2,2,2,'O','',0,'2025-02-07 12:43:06',1,'','',0) 07/02/2025 12:43:12.8644 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:44:11.2019 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:45:16.7874 579 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 12:45:16' where traUID = 5097805229121040 and traStatus='V' and traEnabled=1 07/02/2025 12:45:18.0912 899 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-02-07 12:45:13',0,'V',5314802088269740,4965833011566650,2025,'2025-02-07 12:45:13',3,1,0,4,'2025-02-07 13:00:13','C','KES',200,200,0,'',' ',' ',1,200,0,0,'',0,0) 07/02/2025 12:45:22.4552 4119 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4965833011566650,5314802088269740,2025,'2025-02-07 12:45:18','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/7/2025 9:36:00 AM Date : 2/7/2025 12:45:13 PM Code : 456933456000327005012999 Total : 200.00 KES VAT 16% : 27.59 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/02/2025 12:45:24.4335 1976 ms. EXEC: update payReceipt set recCreation = '2025-02-07 12:45:22',recModify = '2025-02-07 12:45:22',recUseId=0,recStatus='V' where recId = 349970 07/02/2025 12:45:25.5633 563 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 12:45:26.2298 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:48:22.4521 840 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 12:48:21' where traUID = 5107832753944590 and traStatus='V' and traEnabled=1 07/02/2025 12:48:38.1307 3094 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:48:44.4350 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:50:18.8650 708 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-02-07 12:50:18','V',5460858365077000,2025,'2025-02-07 12:50:15','456934530400327005012999',2,2,2,'O','',0,'2025-02-07 12:50:18',1,'','',0) 07/02/2025 12:53:25.0231 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:53:43.9859 1364 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:53:56.5814 1142 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:55:07.2093 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 12:56:04.8693 834 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/02/2025 12:56:13.0589 1499 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 12:56:54.7841 630 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/02/2025 12:57:10.2526 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 12:57:18.5052 1038 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 12:58:14.1209 589 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-02-07 12:58:13','V',5589484004464580,2025,'2025-02-07 12:58:13','456934669300327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 12:59:04.6361 2128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:01:53.2913 543 ms. EXEC: update paycash set casCreation = '2025-02-07 13:01:52',casModify = '2025-02-07 13:01:52',casUseId=0,casStatus='V' where casId = 208458 07/02/2025 13:01:54.0038 711 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 13:01:52',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'; 07/02/2025 13:01:56.0042 1443 ms. EXEC: update paycash set casCreation = '2025-02-07 13:01:54',casModify = '2025-02-07 13:01:54',casUseId=0,casStatus='V' where casId = 208459 07/02/2025 13:01:57.0149 1009 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 13:01:54',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 07/02/2025 13:02:25.6973 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:05:27.2883 1938 ms. OPEN: select * from tabTerminal where terId = 16 07/02/2025 13:05:27.3023 905 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 07/02/2025 13:05:31.9264 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:09:27.7582 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:11:51.8758 605 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 07/02/2025 13:13:18.2933 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:13:34.2381 699 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-02-07 13:12:44',1,'V',5656824062739860,5562601975159230,2025,'2025-02-07 13:12:44',4,1,0,4,'2025-02-07 13:27:44','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 13:13:35.4920 1240 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 13:13:34',4,1,'2025-02-07 13:13:34','456934584300327005012999','Payed (Credit Card ) Ticket ') 07/02/2025 13:14:46.1478 1139 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:15:28.1943 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:17:10.1784 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:18:05.2056 501 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 13:18:23.9423 1052 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 13:18:26.2939 1168 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:20:00.3386 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:25:31.4989 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:27:19.4531 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:28:12.8762 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:28:23.5345 576 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-07 13:28:22',0,0,'V',5144097329002560,5164006221106160,2025,'2025-02-07 13:28:22',3,'KES',1,50,50,'N',''); 07/02/2025 13:31:08.6313 701 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/02/2025 13:31:41.9378 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:32:31.5354 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:32:31.5364 580 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 1 ms.) 07/02/2025 13:32:56.0520 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:33:09.1719 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:36:16.8100 792 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 13:40:48.9223 1229 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-02-07 13:40:47','V',5528272916539530,2025,'2025-02-07 13:40:47','456933596800327005012999',2,2,2,'O','',0,'2025-02-07 13:40:47',1,'','',0) 07/02/2025 13:41:03.3401 2257 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:42:00.0765 817 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-02-07 13:41:57',0,'V',4966567652571250,5737072388836320,2025,'2025-02-07 13:41:57',3,1,0,4,'2025-02-07 13:56:57','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 07/02/2025 13:43:20.3289 1219 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 13:45:25.0234 664 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 13:45:25.8739 703 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:47:23.6597 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:51:33.5330 1386 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-02-07 13:51:32','V',5320211058104110,2025,'2025-02-07 13:51:30','456934989000327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 13:52:35.3088 1994 ms. EXEC: update payReceipt set recCreation = '2025-02-07 13:52:33',recModify = '2025-02-07 13:52:33',recUseId=0,recStatus='V' where recId = 350005 07/02/2025 13:52:39.1964 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:52:42.1945 1484 ms. EXEC: update payReceipt set recCreation = '2025-02-07 13:52:40',recModify = '2025-02-07 13:52:40',recUseId=0,recStatus='V' where recId = 350006 07/02/2025 13:52:57.0115 778 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-02-07 13:52:56',0,'V',5489828620653190,4722046928264560,2025,'2025-02-07 13:52:56',18,1,0,4,'2025-02-07 14:07:56','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 07/02/2025 13:52:58.0142 657 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4722046928264560,5489828620653190,2025,'2025-02-07 13:52:57',' Date: 2/7/2025 1:52:56 PM Code: 456933976700327005012999 Entry Date: 2/7/2025 11:02:47 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 # 2500705492 ',0) 07/02/2025 13:54:12.7318 3862 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 13:54:08' where traUID = 5372301755290950 and traStatus='V' and traEnabled=1 07/02/2025 13:54:39.2227 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:54:46.5787 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:54:51.8863 566 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-02-07 13:54:51','V',5306119833051530,2025,'2025-02-07 13:54:49','456934795000327001012999',2,2,2,'O','',0,'2025-02-07 13:54:51',1,'','',0) 07/02/2025 13:54:53.2192 1053 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 13:55:22.5201 1893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:55:25.5041 1379 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:55:53.8993 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 13:57:50.7555 651 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 13:57:49' where traUID = 5219553166470580 and traStatus='V' and traEnabled=1 07/02/2025 13:59:00.7249 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 13:59:46.5699 1204 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:01:33.6444 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:02:08.5471 664 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 14:04:14.3153 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 14:05:53.0772 1562 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5614554896120890,5236530442805020,2025,'2025-02-07 14:05:51',' Date: 2/7/2025 2:05:51 PM Code: 456934690500327005012999 Entry Date: 2/7/2025 1:01:45 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500705499 ',0) 07/02/2025 14:06:19.7883 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 14:09:36.9008 1321 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-02-07 14:09:35','V',4711922941327820,2025,'2025-02-07 14:09:34','456935097400327001012999',1,2,1,'I','',1,0,1,'','',4) 07/02/2025 14:09:57.2455 864 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5501, trcLastPrinted = '2500705501', trcLastDate = '2025-02-07 14:09:56' where trcStatus='V' and trcTerId = 18 07/02/2025 14:10:27.2118 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 14:23:11.8304 627 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 14:25:32.5487 682 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 14:26:13.8156 1158 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 07/02/2025 14:26:49.5448 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:28:35.1754 1234 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-02-07 14:27:45',1,'V',4675563667355700,5487676663868140,2025,'2025-02-07 14:27:45',4,1,0,4,'2025-02-07 14:42:45','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 14:29:08.5220 655 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 14:30:04.5509 640 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 14:35:41.8374 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:37:33.7662 522 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 14:38:28.5333 999 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 14:40:37.9299 583 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 14:40:37',17,12,'2025-02-07 14:40:37','456934798300327005012999','Pagato (Contanti ) Biglietto ') 07/02/2025 14:41:10.0957 564 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1699, trcLastPrinted = '2500401699', trcLastDate = '2025-02-07 14:41:09' where trcStatus='V' and trcTerId = 4 07/02/2025 14:41:11.0524 699 ms. EXEC: update payReceipt set recCreation = '2025-02-07 14:41:10',recModify = '2025-02-07 14:41:10',recUseId=0,recStatus='V' where recId = 350035 07/02/2025 14:42:31.0115 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 14:43:09.0033 501 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 14:43:29.2910 1280 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 14:43:29.2970 1277 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:44:16.2008 1871 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 14:44:14',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/02/2025 14:45:44.1223 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 14:46:07.1369 896 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 14:46:36.7580 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:48:09.0065 2525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:50:44.6079 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:51:47.7136 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 14:52:33.1114 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 14:53:36.2511 1374 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:53:46.6722 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:55:13.7862 735 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 14:55:28.9084 3040 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 14:55:25' where payTraUID = 5555250976754980 and payStatus='V' and payEnabled=1 07/02/2025 14:55:30.0462 1137 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 14:55:25' where traUID = 5555250976754980 and traStatus='V' and traEnabled=1 07/02/2025 14:55:53.7643 1381 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 14:57:10.0359 4516 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-02-07 14:57:05','V',5371031392292140,2025,'2025-02-07 14:57:02','456934829500327005012999',2,2,2,'O','',0,'2025-02-07 14:57:05',1,'','',0) 07/02/2025 14:57:11.0046 626 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 14:57:10' where payTraUID = 5432663842262320 and payStatus='V' and payEnabled=1 07/02/2025 15:01:55.5443 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:03:11.0344 615 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 15:03:17.8731 840 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:03:23.0686 662 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 15:03:56.2120 993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:05:31.6477 934 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 15:05:30',4,1,'2025-02-07 15:05:30','456935195700327005012999','Payed (Credit Card ) Ticket ') 07/02/2025 15:05:31.6547 943 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 15:05:42.0467 931 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:05:49.0465 513 ms. EXEC: update payReceipt set recCreation = '2025-02-07 15:05:48',recModify = '2025-02-07 15:05:48',recUseId=0,recStatus='V' where recId = 350050 07/02/2025 15:06:16.3450 1613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:06:22.9644 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:07:32.0392 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:07:44.1915 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:08:36.0626 898 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 15:08:52.6218 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:08:59.8077 1129 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:09:15.1391 672 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-07 15:09:14',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-02-07 15:09:14',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 07/02/2025 15:10:56.6758 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:15:51.3464 620 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-02-07 15:15:50','V',5698611653109410,2025,'2025-02-07 15:15:48','456930000200327003229999',22,22,3,'I','',1,0,1,'','',2) 07/02/2025 15:16:30.9342 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:18:25.0716 570 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 15:18:31.0746 990 ms. OPEN: show columns from tabParameters where Field = 'parForce24Hours' 07/02/2025 15:18:31.9042 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:19:21.5048 571 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 15:19:42.7742 2942 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 15:19:39' where traUID = 4723878631703880 and traStatus='V' and traEnabled=1 07/02/2025 15:19:46.1295 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:19:57.8364 536 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-02-07 15:19:57',0,'V',5456853788828690,5412649943404270,2025,'2025-02-07 15:19:57',18,1,0,4,'2025-02-07 15:34:57','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 07/02/2025 15:20:18.0491 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:21:37.8892 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:21:56.1095 1475 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-02-07 15:21:54','V',5520331660498200,2025,'2025-02-07 15:21:53','456935531300327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 15:22:20.4950 1382 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:24:00.8560 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:26:31.6311 541 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 07/02/2025 15:26:32.9130 1086 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:26:45.1233 538 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 15:26:44' where payTraUID = 5412649943404270 and payStatus='V' and payEnabled=1 07/02/2025 15:27:12.2566 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:27:56.0453 1903 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 15:30:17.1078 1250 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 15:30:36.4029 989 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:31:38.9223 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-02-07 15:31:38','V',5330989819441910,2025,'2025-02-07 15:31:36','456935589600327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 15:37:22.0627 504 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 15:37:21',4,1,'2025-02-07 15:37:21','456935321500327005012999','Payed (Credit Card ) Ticket ') 07/02/2025 15:39:41.0238 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:39:43.7136 969 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-02-07 15:39:42',0,'V',5202458101660710,5733059533889950,2025,'2025-02-07 15:39:42',2,1,0,-1,'2025-02-07 16:39:42','S','KES',0,0,0,'','','',3,0,0) 07/02/2025 15:39:44.4481 549 ms. EXEC: update abbCards set carLastDate = '2025-02-07 15:39:43',carLastDirection='O' where carStatus='V' and carId = 192 07/02/2025 15:39:49.9308 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:41:35.6715 837 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5288606526722460,4897748463190590,2025,'2025-02-07 15:41:34','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/7/2025 3:15:16 PM Date : 2/7/2025 3:41:33 PM Code : 456935491600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 07/02/2025 15:41:36.6441 972 ms. EXEC: update payReceipt set recCreation = '2025-02-07 15:41:35',recModify = '2025-02-07 15:41:35',recUseId=0,recStatus='V' where recId = 350074 07/02/2025 15:41:37.2085 546 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-07 15:41:36',0,0,'V',4825946134063420,5288606526722460,2025,'2025-02-07 15:41:36',3,'KES',1,200,200,'N',''); 07/02/2025 15:41:38.8526 1650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:41:39.1908 615 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 15:41:37',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-02-07 15:41:37',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'; 07/02/2025 15:42:12.7396 699 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 15:42:12.8106 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:42:49.2203 767 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 15:43:09.1038 729 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 15:43:08' where payTraUID = 5288606526722460 and payStatus='V' and payEnabled=1 07/02/2025 15:43:13.1145 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:44:26.0369 865 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:46:12.3719 1172 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 07/02/2025 15:48:48.8519 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:48:51.7348 1004 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:49:13.4916 1366 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 15:49:11' where traUID = 5465838989658470 and traStatus='V' and traEnabled=1 07/02/2025 15:49:38.8607 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:50:00.3273 675 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:50:29.5181 863 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5523, trcLastPrinted = '2500705523', trcLastDate = '2025-02-07 15:50:28' where trcStatus='V' and trcTerId = 18 07/02/2025 15:51:11.5886 658 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 15:53:04.3539 3991 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 07/02/2025 15:53:05.8960 1453 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 15:53:04',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'; 07/02/2025 15:55:19.5435 1225 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:55:31.0103 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 15:56:31.4022 978 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 15:58:28.9258 1003 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-02-07 15:58:27','V',5361644988767410,2025,'2025-02-07 15:58:22','456935750200327001012999',1,2,1,'I','',1,0,1,'','',4) 07/02/2025 16:01:13.0880 606 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 07/02/2025 16:01:18.3125 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:02:58.1862 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:03:37.7339 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:04:55.3905 873 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456935789300327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/02/2025 16:07:12.5254 717 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 16:08:21.9735 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:08:35.3105 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:08:46.5701 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:09:02.9112 968 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 16:09:03.6547 607 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 16:09:02' where traUID = 5520331660498200 and traStatus='V' and traEnabled=1 07/02/2025 16:09:11.3379 1170 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:10:20.8230 899 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:10:42.8199 1153 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 07/02/2025 16:10:49.5204 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:11:01.6086 1554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:11:06.3318 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:11:14.2822 1499 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:11:42.8345 1261 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/02/2025 16:11:42.8926 1228 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:12:57.0998 818 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 16:12:56',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 07/02/2025 16:13:39.9008 3214 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:14:54.3402 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:15:05.0795 2284 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:15:19.2551 2364 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:15:54.1337 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:17:05.0768 566 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 16:17:04' where payTraUID = 5614361262078190 and payStatus='V' and payEnabled=1 07/02/2025 16:17:11.6182 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:17:34.3306 846 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 16:17:47.5345 2844 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 16:17:44' where traUID = 5448917960077230 and traStatus='V' and traEnabled=1 07/02/2025 16:17:47.5386 2883 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 16:17:44',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'; 07/02/2025 16:18:18.7747 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:19:16.5168 565 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-07 16:19:15','V',5190529789652110,2025,'2025-02-07 16:19:14','456935633300327005012999',2,2,2,'O','',0,'2025-02-07 16:19:15',1,'','',0) (WAIT TIME 2 ms.) 07/02/2025 16:19:42.1522 2165 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:19:54.1843 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:20:59.3145 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:21:26.6420 604 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 16:21:25' where traUID = 5672339432659310 and traStatus='V' and traEnabled=1 07/02/2025 16:21:53.7053 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:22:04.2234 600 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/02/2025 16:22:45.0351 1523 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 16:23:23.4971 2510 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-02-07 16:23:20',0,'V',5469459112940850,5424147291562460,2025,'2025-02-07 16:23:20',18,1,0,4,'2025-02-07 16:38:20','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 16:23:53.1002 3228 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:24:00.1820 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:24:52.7759 2936 ms. EXEC: update payInventory set invCreation = '2025-02-07 16:24:49',invModify = '2025-02-07 16:24:49',invUseId=0,invStatus='V' where invId = 235595 07/02/2025 16:25:20.8649 663 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 16:25:20' where traUID = 5424147291562460 and traStatus='V' and traEnabled=1 07/02/2025 16:25:25.6892 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:25:44.3808 723 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:26:06.1926 1359 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 16:26:04' where traUID = 5200186426989300 and traStatus='V' and traEnabled=1 07/02/2025 16:28:21.7334 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:28:50.1306 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:29:36.6391 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:30:10.6131 1717 ms. EXEC: update payReceipt set recCreation = '2025-02-07 16:30:08',recModify = '2025-02-07 16:30:08',recUseId=0,recStatus='V' where recId = 350114 07/02/2025 16:30:10.6532 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-02-07 16:30:09',0,'V',4731792143752330,4940726704583990,2025,'2025-02-07 16:30:09',18,1,0,4,'2025-02-07 16:45:09','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 07/02/2025 16:30:20.7180 936 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 16:30:36.7068 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:30:36.7098 758 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 16:30:56.6994 777 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 16:30:55' where payTraUID = 4676269055465560 and payStatus='V' and payEnabled=1 07/02/2025 16:30:58.9699 2270 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 16:30:55' where traUID = 4676269055465560 and traStatus='V' and traEnabled=1 07/02/2025 16:31:10.2445 749 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5538, trcLastPrinted = '2500705538', trcLastDate = '2025-02-07 16:31:09' where trcStatus='V' and trcTerId = 18 07/02/2025 16:31:25.8831 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:32:46.7629 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:33:30.4055 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:34:25.0805 1275 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 16:34:23' where traUID = 5036933217442310 and traStatus='V' and traEnabled=1 07/02/2025 16:34:54.5395 764 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 16:34:53' where payTraUID = 4940726704583990 and payStatus='V' and payEnabled=1 07/02/2025 16:35:02.1476 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:38:47.8935 1636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:41:00.5544 852 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 16:41:13.7713 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:42:13.9851 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:42:30.5653 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:43:08.8443 1655 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-07 16:43:07',0,0,'V',5441782552361010,5194145401031190,2025,'2025-02-07 16:43:07',3,'KES',1,1000,1000,'N',''); 07/02/2025 16:43:10.4203 1192 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 16:43:09',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-02-07 16:43:09',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 16:43:09',3,42101,0,500,-1,-500,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 07/02/2025 16:46:37.4506 865 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 16:46:38.5073 904 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:46:53.6135 2574 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 16:46:50',3,42101,0,200,-3,-600,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-3,5),curAmount=round(curAmount+-600,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 07/02/2025 16:48:25.9451 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 16:48:33.2640 1423 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:49:08.7591 1727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:52:31.2222 505 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-02-07 16:52:30','V',5652496102551010,2025,'2025-02-07 16:52:30','456936075000327001012999',1,2,1,'I','',1,0,1,'','',4) 07/02/2025 16:52:55.7998 558 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 16:52:56.8365 1035 ms. EXEC: update abbCards set carLastDate = '2025-02-07 16:52:55',carLastDirection='I' where carStatus='V' and carId = 15 07/02/2025 16:55:12.5134 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 16:58:05.0813 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 16:58:48.2175 1551 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-07 16:58:46','0230003943861',0,0,5293631865284200,31,'0000-00-00 00:00:00','0000-00-00 00:00:00') 07/02/2025 16:58:49.1091 818 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-02-07 16:58:48',0,'V',5293631865284200,5137613242575520,2025,'2025-02-07 16:58:48',2,1,0,-1,'2025-02-07 17:58:48','S','KES',0,0,0,'','','',3,0,0) 07/02/2025 16:58:50.2960 1095 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 16:58:50.9544 604 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 16:58:52.6886 1580 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 16:58:50' where traUID = 5137613242575520 and traStatus='V' and traEnabled=1 07/02/2025 16:58:54.3117 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 17:00:42.6320 508 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/02/2025 17:01:03.5812 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:02:06.8791 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:06:49.3945 527 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-02-07 17:06:48','V',5080097961880770,2025,'2025-02-07 17:06:47','456933280300327005012999',2,2,2,'O','',0,'2025-02-07 17:06:48',1,'','0810007086215',125,0) 07/02/2025 17:07:02.6384 1054 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:07:19.6430 1489 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 17:08:29.7444 773 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 17:10:48.0001 790 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 17:12:23.0485 1282 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-02-07 17:12:21',0,'V',5448660929428960,5364891293621680,2025,'2025-02-07 17:12:21',18,1,0,4,'2025-02-07 17:27:21','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 07/02/2025 17:14:21.8019 1866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:15:55.3903 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:18:07.2586 696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 17:19:54.7474 1999 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-07 17:19:52' where subId = 16 07/02/2025 17:19:58.8222 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 17:19:59.5947 744 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 07/02/2025 17:20:31.7805 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:21:03.2488 576 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 17:23:14.6748 2369 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:29:48.1403 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:30:59.1134 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:31:42.3417 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 17:32:40.9304 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:33:48.6222 522 ms. OPEN: select * from abbSubscriptions inner join abbCards on subId = carSubId inner join tabCustomer on cusId = subCusId where carStatus = 'V' and subStatus='V' and carCode = '456936047600327001012999' AND subAbbType <> 6 07/02/2025 17:34:19.7963 667 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 07/02/2025 17:35:45.1862 891 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 17:35:59.1957 843 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 17:35:59.2037 775 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 17:39:28.6846 870 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-07 17:39:27' where subId = 172 07/02/2025 17:39:30.8200 917 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 17:39:29' where traUID = 4763580996105080 and traStatus='V' and traEnabled=1 07/02/2025 17:39:34.2984 673 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 17:39:34.3154 902 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 17:41:38.7797 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 17:42:17.0166 1065 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 17:42:18.2654 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:44:27.0587 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 17:44:31.6408 545 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 17:47:35.2571 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:51:59.9434 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 17:56:08.4297 637 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 17:56:52.1874 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:01:21.2226 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:03:01.5826 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:03:23.9777 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:08:08.5505 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:08:12.6453 717 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 18:08:13.1856 528 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 18:08:20.7077 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:10:09.5925 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:10:36.3346 3233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:13:44.2369 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:14:00.0376 1346 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:14:30.4071 1852 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5191607224455720,5072439885712350,2025,'2025-02-07 18:14:28',' Date: 2/7/2025 6:13:39 PM Code: 456936274400327005012999 Entry Date: 2/7/2025 5:25:44 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500401721 ',0) 07/02/2025 18:16:32.6259 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:17:46.7611 532 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 18:17:45' where traUID = 5191607224455720 and traStatus='V' and traEnabled=1 07/02/2025 18:18:57.5311 750 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-02-07 18:18:56','V',5675289855064290,2025,'2025-02-07 18:18:56','456936554500327005012999',2,2,2,'O','',0,'2025-02-07 18:18:56',1,'','',0) 07/02/2025 18:18:58.2996 519 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 18:19:03.3310 542 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 18:19:03.6122 826 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:19:11.0803 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:22:08.3433 1029 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:22:33.7896 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:23:33.5320 801 ms. EXEC: update paycash set casCreation = '2025-02-07 18:23:32',casModify = '2025-02-07 18:23:32',casUseId=0,casStatus='V' where casId = 208533 07/02/2025 18:26:49.6969 810 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 18:27:03.9335 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:27:47.1528 713 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:29:53.7826 1044 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/02/2025 18:30:50.8712 880 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 18:30:51.8159 768 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:30:55.0661 1227 ms. EXEC: update paycash set casCreation = '2025-02-07 18:30:53',casModify = '2025-02-07 18:30:53',casUseId=0,casStatus='V' where casId = 208535 07/02/2025 18:31:25.5587 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:31:53.0614 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:32:12.3194 717 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-07 18:32:11',0,0,'V',4936331113159790,5147986261942960,2025,'2025-02-07 18:32:11',3,'KES',1,100,100,'N',''); 07/02/2025 18:32:40.6366 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:34:21.1897 973 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 18:34:20' where payTraUID = 5147986261942960 and payStatus='V' and payEnabled=1 07/02/2025 18:34:21.7761 585 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 18:34:20' where traUID = 5147986261942960 and traStatus='V' and traEnabled=1 07/02/2025 18:34:42.8564 1684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:36:01.8189 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:36:42.2523 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:40:44.3532 519 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 07/02/2025 18:42:37.2567 684 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 156 order by traDateTime desc,traId desc 07/02/2025 18:43:55.2195 1319 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:44:03.5061 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:44:59.7622 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:49:23.3758 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:49:38.8263 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:50:51.4384 1658 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-02-07 18:50:49','V',5174929237060320,2025,'2025-02-07 18:50:48','456936784800327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 18:50:56.2227 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:51:46.7859 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:52:35.4789 1317 ms. EXEC: update payInventory set invCreation = '2025-02-07 18:52:34',invModify = '2025-02-07 18:52:34',invUseId=0,invStatus='V' where invId = 235624 07/02/2025 18:52:35.5199 1299 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 18:52:36.1304 649 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-07 18:52:35',0,0,'V',4864966123464800,5214418904023130,2025,'2025-02-07 18:52:35',3,'KES',-1,50,-50,'N',''); 07/02/2025 18:52:36.8428 682 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 18:52:35',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 07/02/2025 18:52:37.5483 613 ms. EXEC: update payInventory set invCreation = '2025-02-07 18:52:36',invModify = '2025-02-07 18:52:36',invUseId=0,invStatus='V' where invId = 235625 (WAIT TIME 92 ms.) 07/02/2025 18:52:38.4579 1618 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-02-07 18:52:36',0,'V',5246441828757810,5667100913672240,2025,'2025-02-07 18:52:36',18,1,0,4,'2025-02-07 19:07:36','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 18:53:24.7203 1181 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:54:48.9803 1052 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 18:54:47' where traUID = 5667100913672240 and traStatus='V' and traEnabled=1 07/02/2025 18:57:05.0805 699 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 18:57:05.1065 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 18:59:36.0928 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 18:59:36.1258 734 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 18:59:56.0593 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:00:32.3279 1729 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 19:00:30',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'; 07/02/2025 19:02:09.9270 781 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-02-07 19:01:20',1,'V',4636823567053940,5326247477859760,2025,'2025-02-07 19:01:20',4,1,0,4,'2025-02-07 19:16:20','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 19:04:23.8507 1093 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 5 ms.) 07/02/2025 19:05:30.4498 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:06:58.3944 3096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:07:16.2525 2392 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:07:31.2437 2023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:07:54.2372 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:09:38.1476 1336 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-02-07 19:09:36','V',5089256718162000,2025,'2025-02-07 19:09:36','456936572400327005012999',2,2,2,'O','',0,'2025-02-07 19:09:36',1,'','',0) 07/02/2025 19:09:46.1390 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:10:53.4566 1080 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 19:10:58.4160 758 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 19:11:42.4098 1053 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 07/02/2025 19:12:53.7201 3571 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 19:12:58.8586 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:18:29.7177 860 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 19:22:59.7706 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:23:15.4602 529 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5565, trcLastPrinted = '2500705565', trcLastDate = '2025-02-07 19:23:14' where trcStatus='V' and trcTerId = 18 07/02/2025 19:25:08.2946 620 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 19:25:07' where payTraUID = 4916393282253270 and payStatus='V' and payEnabled=1 07/02/2025 19:25:08.9711 676 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 19:25:07' where traUID = 4916393282253270 and traStatus='V' and traEnabled=1 07/02/2025 19:25:12.9418 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:26:51.1353 1116 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:28:04.2848 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:30:06.4526 711 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:32:07.2044 1205 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:32:33.1139 794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:35:08.7774 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:38:18.1436 703 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-07 19:38:17','0560008336102',0,0,4870503281583240,185,'0000-00-00 00:00:00','0000-00-00 00:00:00') 07/02/2025 19:38:20.0139 882 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 19:38:18' where traUID = 4748666916053320 and traStatus='V' and traEnabled=1 07/02/2025 19:38:23.1380 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:38:32.1911 543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 07/02/2025 19:39:15.5505 516 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 19:39:21.5706 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:40:52.2780 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:48:02.2062 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:48:44.8901 734 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/02/2025 19:50:55.9189 2456 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:52:54.7954 1762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:53:25.0019 1058 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:54:05.4263 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:56:02.6437 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 19:56:29.6139 551 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 19:56:46.9437 1236 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 19:56:45',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'; 07/02/2025 19:57:19.5587 1353 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 19:57:18',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'; 07/02/2025 19:57:20.3002 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 19:57:55.0278 1054 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-02-07 19:57:53','V',5522835193376750,2025,'2025-02-07 19:57:52','456937187200327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 19:57:59.6579 731 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 19:58:57.4921 832 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 19:58:56' where traUID = 4700293560081980 and traStatus='V' and traEnabled=1 07/02/2025 20:00:09.8111 3527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:01:50.7454 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:01:59.8136 564 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 20:01:59',4,1,'2025-02-07 20:01:59','456937178800327005012999','Payed (Credit Card ) Ticket ') 07/02/2025 20:02:45.6056 1299 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:03:31.0884 546 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 20:03:30' where traUID = 5187436545734770 and traStatus='V' and traEnabled=1 (WAIT TIME 3 ms.) 07/02/2025 20:06:22.9978 669 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 20:06:22' where payTraUID = 4746931352560970 and payStatus='V' and payEnabled=1 07/02/2025 20:06:27.4248 698 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 20:06:28.3395 680 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 20:07:41.4770 702 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-07 20:07:40','V',4776794653426440,2025,'2025-02-07 20:07:40','456937246000327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 20:08:12.4109 880 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 20:09:12.1734 937 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 20:09:20.8913 623 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 20:10:59.4951 1734 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 20:12:55.7969 599 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 20:13:29.7549 614 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 20:13:29',0,16,'2025-02-07 20:13:29','','Unauthorized Transit Entry 2') 07/02/2025 20:13:39.8377 921 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 3 ms.) 07/02/2025 20:14:53.6908 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:14:57.5864 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:15:16.7694 718 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-02-07 20:15:15',0,'V',5383905037588970,4799329757741860,2025,'2025-02-07 20:15:15',18,1,0,4,'2025-02-07 20:30:15','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 20:17:46.8560 2117 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 20:17:44' where payTraUID = 4799329757741860 and payStatus='V' and payEnabled=1 07/02/2025 20:18:37.2162 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 20:21:29.4958 610 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-02-07 20:21:28','V',5695245547381700,2025,'2025-02-07 20:21:26','456937163100327005012999',2,2,2,'O','',0,'2025-02-07 20:21:28',1,'','',0) 07/02/2025 20:21:31.3581 1851 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 20:21:36.8318 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 20:23:26.3110 549 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4628015409884960,5721306835092930,2025,'2025-02-07 20:23:25',' Date: 2/7/2025 8:23:25 PM Code: 456937317000327005012999 Entry Date: 2/7/2025 8:19:30 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 # 2500705571 ',0) 07/02/2025 20:24:06.1119 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 20:24:10.4229 2895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:24:48.5006 1430 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5572, trcLastPrinted = '2500705572', trcLastDate = '2025-02-07 20:24:47' where trcStatus='V' and trcTerId = 18 07/02/2025 20:25:33.1849 897 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 07/02/2025 20:25:33.1849 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:27:14.1873 1598 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 20:27:33.7286 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 20:28:11.9865 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:28:54.0730 804 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 20:32:28.4222 662 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 20:32:27',17,12,'2025-02-07 20:32:27','456936626300327005012999','Pagato (Contanti ) Biglietto ') 07/02/2025 20:32:39.4086 1275 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 20:32:38' where traUID = 4902385202641340 and traStatus='V' and traEnabled=1 07/02/2025 20:40:37.5755 1152 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 20:42:02.8062 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:43:56.3211 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 20:45:58.4768 510 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-02-07 20:45:57',0,'V',4736717178388290,4830743658450230,2025,'2025-02-07 20:45:57',18,1,0,4,'2025-02-07 21:00:57','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/02/2025 20:46:27.4345 1287 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 20:46:31.3281 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:46:32.9732 807 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 20:46:32' where payTraUID = 4830743658450230 and payStatus='V' and payEnabled=1 07/02/2025 20:46:36.0773 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 20:53:31.6898 1337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:57:21.8197 1726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 20:58:17.7996 698 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 21:00:56.7783 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:01:24.6912 878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:03:55.5654 853 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 21:05:29.8513 695 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-02-07 21:05:29','V',5111264296476970,2025,'2025-02-07 21:05:28','456937592800327005012999',1,2,16,'I','',1,0,1,'','',4) 07/02/2025 21:06:36.6915 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:08:23.0506 659 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 21:08:23.7591 691 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 21:09:07.9900 1009 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:10:00.1223 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:12:11.3772 767 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 07/02/2025 21:12:13.5887 1095 ms. OPEN: select * from movtransit where traCode = '456937465500327005012999' and traStatus='V' ORDER BY traId DESC 07/02/2025 21:12:16.8880 1587 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 21:13:56.8767 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:14:21.2772 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 21:14:27.6035 1392 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:14:28.2239 1499 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-02-07 21:14:26','V',5453023907081800,2025,'2025-02-07 21:14:25','456937465500327005012999',2,2,2,'O','',0,'2025-02-07 21:14:26',1,'','',0) 07/02/2025 21:16:58.3696 2311 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:18:15.0666 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 21:18:49.7481 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 21:19:09.7796 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:19:36.6879 602 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 21:19:50.4622 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:23:44.6528 594 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-02-07 21:23:43',0,'V',4708774165192180,5005324348193770,2025,'2025-02-07 21:23:43',3,1,0,4,'2025-02-07 21:38:43','C','KES',50,200,100,'',' ',' ',2,50,0,0,'',0,0) 07/02/2025 21:23:46.2109 1527 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5005324348193770,4708774165192180,2025,'2025-02-07 21:23:44','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/7/2025 8:49:15 PM Date : 2/7/2025 9:23:43 PM Code : 456937495500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 100.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 50.00 KES',0) 07/02/2025 21:25:02.5926 973 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 07/02/2025 21:25:21.2452 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:26:14.0160 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:28:31.0948 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:28:41.4008 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:30:32.0337 2148 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-02-07 21:30:20',12,'V',5168440335557930,4898297360130960,2025,'2025-02-07 21:30:20',17,1,0,4,'2025-02-07 21:45:20','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 07/02/2025 21:30:33.4707 1361 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 21:30:32',17,12,'2025-02-07 21:30:32','456936675800327005012999','Pagato (Contanti ) Biglietto ') 07/02/2025 21:30:34.9037 880 ms. EXEC: update tabTerminalReceipt set trcProgressive = 973, trcLastPrinted = '2500600973', trcLastDate = '2025-02-07 21:30:34' where trcStatus='V' and trcTerId = 17 07/02/2025 21:31:14.0892 1028 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 21:31:12' where traUID = 5363402084296180 and traStatus='V' and traEnabled=1 07/02/2025 21:32:47.9858 959 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 21:34:22.1426 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:35:38.3312 943 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 21:35:44.9987 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 21:37:32.0562 2413 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 21:37:29',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'; 07/02/2025 21:37:50.6568 714 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/02/2025 21:38:01.5162 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:38:40.1714 2009 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 21:38:43.6427 2169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:39:36.4145 926 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-07 21:39:35','0560008419314',0,0,4650601859186520,195,'0000-00-00 00:00:00','0000-00-00 00:00:00') 07/02/2025 21:39:42.6037 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 21:40:34.0215 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 21:40:41.4675 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:42:11.1113 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 21:42:46.0529 683 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 21:45:26.9189 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:47:54.7290 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:53:09.2811 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:54:31.9030 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:54:57.6305 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:54:57.6315 663 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/02/2025 21:56:24.0890 1269 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 21:56:22' where traUID = 5505890166266640 and traStatus='V' and traEnabled=1 07/02/2025 21:56:24.2851 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 21:59:06.6201 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:01:46.2622 552 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5584, trcLastPrinted = '2500705584', trcLastDate = '2025-02-07 22:01:45' where trcStatus='V' and trcTerId = 18 07/02/2025 22:02:12.4310 652 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 22:02:11',0,2,'2025-02-07 22:02:11','','Unauthorized Transit Exit 1') 07/02/2025 22:04:47.9013 1698 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-02-07 22:04:46','V',5704360788093560,2025,'2025-02-07 22:04:44','456937262200327005012999',2,2,2,'O','',0,'2025-02-07 22:04:46',1,'','',0) 07/02/2025 22:11:42.9534 1138 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/02/2025 22:12:04.4560 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:12:05.5477 851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:12:26.3298 1153 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 22:12:27.2634 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:13:59.6490 1549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:15:13.6071 1195 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:18:32.5909 1433 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 22:19:06.9381 4287 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:19:20.0310 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:19:26.1341 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:21:08.9278 1162 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:24:54.3524 1021 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/02/2025 22:24:54.5636 1203 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-02-07 22:24:44',12,'V',4678981511771720,5663872757486260,2025,'2025-02-07 22:24:44',17,1,0,4,'2025-02-07 22:39:44','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 07/02/2025 22:25:57.2641 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:28:35.0469 923 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5498312476089410,5669404706448390,2025,'2025-02-07 22:28:34',' Date: 2/7/2025 10:28:34 PM Code: 456937337500327005012999 Entry Date: 2/7/2025 8:22:55 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500705588 ',0) 07/02/2025 22:28:38.7975 935 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 22:29:08.2834 2228 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:29:31.5462 2772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:31:37.3924 1236 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/02/2025 22:31:57.9734 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:32:10.4468 1053 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-07 22:32:09' where traUID = 5607216472415580 and traStatus='V' and traEnabled=1 07/02/2025 22:32:49.6914 1775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:34:34.0611 703 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:36:42.6622 1152 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 22:36:40',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'; 07/02/2025 22:36:50.8898 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:37:44.7873 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:38:30.6093 520 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/02/2025 22:38:35.4796 2199 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:38:42.2522 2978 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 22:38:39' where payTraUID = 5348638971467690 and payStatus='V' and payEnabled=1 07/02/2025 22:38:56.4959 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:41:17.6645 2327 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-07 22:41:15' where payTraUID = 4782749859812970 and payStatus='V' and payEnabled=1 07/02/2025 22:41:39.4292 2302 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:43:22.4630 1996 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-02-07 22:43:20','V',5185158214748380,2025,'2025-02-07 22:43:19','456937297300327005012999',2,2,2,'O','',0,'2025-02-07 22:43:20',1,'','',0) 07/02/2025 22:44:18.7001 728 ms. EXEC: update tabTerminalReceipt set trcProgressive = 980, trcLastPrinted = '2500600980', trcLastDate = '2025-02-07 22:44:17' where trcStatus='V' and trcTerId = 17 07/02/2025 22:45:29.2519 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:45:43.3584 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:46:15.0859 1419 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 22:46:13',17,12,'2025-02-07 22:46:13','456936971100327005012999','Pagato (Contanti ) Biglietto ') 07/02/2025 22:46:28.3559 1214 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:49:11.3883 1081 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:49:24.1740 1129 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-02-07 22:49:22',0,'V',5048850900650900,5195092315798350,2025,'2025-02-07 22:49:22',18,1,0,4,'2025-02-07 23:04:22','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 07/02/2025 22:50:08.8603 900 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:53:04.3902 1026 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/02/2025 22:53:05.2117 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 22:58:02.9554 1448 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:58:20.3031 1287 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 22:58:26.3212 503 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 22:58:33.2899 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:01:48.4181 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:01:50.9698 757 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4829498696973150,5001821910390660,2025,'2025-02-07 23:01:50',' Date: 2/7/2025 11:01:49 PM Code: 456937265200327005012999 Entry Date: 2/7/2025 8:10:52 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500705596 ',0) 07/02/2025 23:01:53.6887 1639 ms. EXEC: update payReceipt set recCreation = '2025-02-07 23:01:52',recModify = '2025-02-07 23:01:52',recUseId=0,recStatus='V' where recId = 350259 07/02/2025 23:01:54.1460 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:08:20.7559 1041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:09:13.9569 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:10:58.0554 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:22:12.2040 1023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:22:18.5123 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:23:11.9735 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 23:24:05.4718 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:26:47.8778 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:27:20.3528 564 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 23:29:10.2722 580 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-02-07 23:29:09','V',5337696505516830,2025,'2025-02-07 23:29:07','456937018600327005012999',2,2,2,'O','',0,'2025-02-07 23:29:09',1,'','',0) 07/02/2025 23:29:37.2004 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:29:57.0909 657 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/02/2025 23:30:01.5199 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:32:17.3879 659 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/02/2025 23:33:33.0402 514 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 23:33:32',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'; 07/02/2025 23:33:33.9038 863 ms. EXEC: update payInventory set invCreation = '2025-02-07 23:33:33',invModify = '2025-02-07 23:33:33',invUseId=0,invStatus='V' where invId = 235668 07/02/2025 23:35:50.1030 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:40:25.9859 535 ms. EXEC: update abbCards set carLastDate = '2025-02-07 23:40:25',carLastDirection='O' where carStatus='V' and carId = 15 07/02/2025 23:40:26.9656 973 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 07/02/2025 23:40:32.4803 1307 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 07/02/2025 23:40:49.2807 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:42:20.2803 3713 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/02/2025 23:43:05.2808 1516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:43:29.8294 1688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:45:17.4773 612 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 07/02/2025 23:45:17.4793 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:47:23.6758 521 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 07/02/2025 23:47:23.7599 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:47:24.8236 563 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 23:50:06.9914 734 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/02/2025 23:50:15.7444 1176 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/02/2025 23:50:56.8702 928 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 23:51:28.3105 845 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-07 23:51:27',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 07/02/2025 23:51:36.3570 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:52:24.1864 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:53:56.6100 704 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-07 23:53:55',0,2,'2025-02-07 23:53:55','','Unauthorized Transit Exit 1') 07/02/2025 23:54:08.6421 629 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 23:55:14.5147 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:56:16.3636 1004 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:57:57.7273 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:58:08.4285 842 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:58:12.0230 1753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:58:24.4594 3037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:58:34.6343 1364 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 07/02/2025 23:58:36.5476 843 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/02/2025 23:58:44.0226 795 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/02/2025 23:59:52.5190 1614 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/02/2025 23:59:52.5490 1336 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/02/2025 23:59:53.3956 864 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1