05/02/2025 00:01:37.8062 798 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 00:06:10.2127 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 00:11:55.6647 944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 00:13:42.6172 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 00:14:57.6050 881 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 00:14:58.3224 702 ms. OPEN: select * from abbAreaGroup where argStatus='V' and argAbgId = 99999 and argAreId = 1 05/02/2025 00:21:25.4146 511 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/02/2025 00:21:41.9518 1198 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 00:35:16.4625 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 00:46:45.9746 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:03:59.7518 727 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/02/2025 01:09:43.4496 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:10:40.5803 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:11:23.3132 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 446 ms.) 05/02/2025 01:14:17.3001 1057 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 01:21:10.7271 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:23:18.6227 1041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:32:15.6325 1180 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:35:14.5477 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:36:41.3344 1422 ms. EXEC: update paycash set casCreation = '2025-02-05 01:36:39',casModify = '2025-02-05 01:36:39',casUseId=0,casStatus='V' where casId = 208074 05/02/2025 01:36:43.9912 2545 ms. EXEC: update payInventory set invCreation = '2025-02-05 01:36:41',invModify = '2025-02-05 01:36:41',invUseId=0,invStatus='V' where invId = 235055 05/02/2025 01:40:11.3227 893 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 05/02/2025 01:40:23.1807 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:43:54.1166 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:43:57.3378 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:48:17.1207 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:49:03.5722 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:49:27.5464 2605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:50:43.4038 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:52:58.9866 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 01:54:47.8504 1408 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/02/2025 01:54:53.5903 1344 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 02:02:02.1305 1554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 02:09:32.0186 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 02:27:06.9845 602 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/02/2025 02:39:08.9606 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 02:42:07.1493 659 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 02:50:23.1445 772 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-05 02:50:22','V',5318018468371960,2025,'2025-02-05 02:50:22','456910970300327005012999',2,2,2,'O','',0,'2025-02-05 02:50:22',1,'','',0) 05/02/2025 02:50:29.1176 748 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 03:08:05.9656 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 03:18:06.1601 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 03:23:58.0850 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 03:26:59.6440 1168 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 03:33:27.9064 676 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/02/2025 03:34:02.6420 650 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 03:39:06.1405 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 03:53:34.8118 1439 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 03:55:44.4947 504 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/02/2025 03:59:35.6833 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 04:01:02.9083 1659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 04:01:22.1104 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 04:21:41.3042 1260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 04:26:00.0384 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 04:27:26.7722 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 04:31:16.6759 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 04:32:56.1563 533 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/02/2025 04:38:14.4759 999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 04:46:13.7745 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 04:46:49.2215 752 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 04:47:13.9133 806 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/02/2025 04:53:44.1176 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 04:54:17.7754 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 05:07:01.6723 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 05:08:15.7434 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 05:15:42.9494 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 05:18:06.5656 1109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 05:20:16.7098 1404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 05:25:34.5501 756 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 05:31:03.3519 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 05:32:27.6870 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 05:44:44.0669 750 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 06:00:14.2239 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 06:00:14.2449 986 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 06:00:50.2763 1999 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/02/2025 06:02:46.4070 572 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/02/2025 06:08:45.2270 2410 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 06:11:11.2219 1111 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/02/2025 06:13:06.4200 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 06:14:54.2721 867 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 06:14:53',4,6,'2025-02-05 06:14:53','456912010100327005012999','Payed (Credit Card ) Ticket ') 05/02/2025 06:34:31.2636 708 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/02/2025 06:38:49.3480 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 06:44:33.4501 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 06:53:30.0355 607 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 06:55:00.6539 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 06:55:04.0452 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 06:56:17.1927 501 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 06:56:17.2128 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 07:10:55.9049 1153 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 07:10:54',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 07:10:54',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 05/02/2025 07:13:32.6371 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 07:17:19.7414 1648 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/02/2025 07:21:34.7241 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 07:24:58.2629 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 07:34:14.6228 727 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 07:34:13',0,16,'2025-02-05 07:34:13','','Unauthorized Transit Entry 2') 05/02/2025 07:34:27.3244 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 07:37:57.7791 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 07:38:36.2891 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 07:38:38.2144 629 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 07:38:37',4,6,'2025-02-05 07:38:37','456912595900327005012999','Payed (Credit Card ) Ticket ') 05/02/2025 07:43:07.8331 566 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 07:47:33.1127 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 07:48:19.0779 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 07:49:09.1608 2433 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-05 07:49:06',0,'V',5615529148780470,5444871612458440,2025,'2025-02-05 07:49:06',18,1,0,4,'2025-02-05 08:04:06','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/02/2025 07:49:09.1818 2225 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 07:49:10.0424 729 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5123, trcLastPrinted = '2500705123', trcLastDate = '2025-02-05 07:49:09' where trcStatus='V' and trcTerId = 18 05/02/2025 07:49:20.9888 537 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/02/2025 07:52:35.2142 1434 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/02/2025 07:55:16.6015 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 07:56:14.8900 538 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 07:56:14' where payTraUID = 5591294043849430 and payStatus='V' and payEnabled=1 05/02/2025 08:02:57.9375 688 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 08:04:06.4869 660 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 08:05:51.6632 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 08:22:25.8306 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 08:45:04.6731 1953 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 08:55:51.7233 728 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 08:57:59.5552 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 08:58:22.3987 838 ms. EXEC: update abbCards set carLastDate = '2025-02-05 08:58:21',carLastDirection='I' where carStatus='V' and carId = 82 05/02/2025 08:58:27.7313 657 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 08:58:27',0,16,'2025-02-05 08:58:27','','Unauthorized Transit Entry 2') 05/02/2025 09:04:30.1107 783 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 09:04:45.0859 1242 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 05/02/2025 09:06:32.6607 756 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/02/2025 09:07:30.1297 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:09:38.7991 555 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 09:09:46.9296 574 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-05 09:09:46','V',5658496037227000,2025,'2025-02-05 09:09:45','456913298500327005012999',1,2,16,'I','',1,0,1,'','0810007086215',125,0) 05/02/2025 09:09:52.9277 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:13:16.2674 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 09:14:33.9880 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:16:19.1432 635 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 09:16:42.3179 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:20:16.7922 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:20:21.8986 1078 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-05 09:19:41',6,'V',4884480139621750,4999654880366150,2025,'2025-02-05 09:19:41',4,1,0,4,'2025-02-05 09:34:41','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/02/2025 09:21:02.1949 1367 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:21:04.3374 561 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 09:21:03',4,6,'2025-02-05 09:21:03','456913240900327005012999','Payed (Credit Card ) Ticket ') 05/02/2025 09:22:34.4414 652 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-05 09:22:33','V',5761380580052330,2025,'2025-02-05 09:22:31','456913375100327001012999',1,2,1,'I','',1,0,1,'','',4) 05/02/2025 09:22:53.0300 962 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 09:22:51' where traUID = 4999654880366150 and traStatus='V' and traEnabled=1 05/02/2025 09:22:58.4597 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 09:24:03.2216 1347 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 09:29:07.7878 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:30:26.5902 644 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 09:33:44.9926 2411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:34:55.3533 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 09:36:36.1405 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 09:42:32.5740 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 09:43:24.0808 797 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-05 09:43:23' where subId = 202 05/02/2025 09:43:36.1030 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:44:59.6256 1408 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 09:44:58' where traUID = 5761380580052330 and traStatus='V' and traEnabled=1 05/02/2025 09:44:59.6266 1385 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-05 09:44:18',6,'V',5466070164093620,5330058437942100,2025,'2025-02-05 09:44:18',4,1,0,4,'2025-02-05 09:59:18','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/02/2025 09:47:17.5010 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:47:36.0285 538 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/02/2025 09:48:46.4402 1163 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,0,100,-21,-2100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,0,100,21,2100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,0,200,-7,-1400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,0,200,7,1400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:14',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 05/02/2025 09:48:48.3025 1269 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:39',5,3,42101,0,50,-4,-200,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:39',5,3,42101,0,100,-29,-2900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:39',5,3,42101,0,200,-7,-1400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:39',5,3,42101,0,500,-4,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:39',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:48:39',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 05/02/2025 09:49:13.7717 725 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 09:49:13',0,3,'2025-02-05 09:49:13','0230003944086','POF - User Transit Supervisor Supervisor') 05/02/2025 09:49:51.1220 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 09:51:58.6054 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:52:37.4907 2257 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:52:55.4479 632 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 09:52:59.4786 740 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 09:52:59.7037 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:52:59.7067 668 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 05/02/2025 09:53:41.9073 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 09:54:37.6161 598 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:54:32',5,3,42101,0,50,16,800,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+16,5),curAmount=round(curAmount+800,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-05 09:54:32',5,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'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 09:54:32',5,3,42101,0,100,10,1000,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+10,5),curAmount=round(curAmount+1000,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; 05/02/2025 09:54:48.0061 759 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 09:54:59.8601 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 09:55:16.2812 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:55:44.6845 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 09:57:28.7200 739 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5278838856452840,5598645279868110,2025,'2025-02-05 09:57:27',' Date: 2/5/2025 9:56:46 AM Code: 456913483400327005012999 Entry Date: 2/5/2025 9:40:34 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 # 2500401574 ',0) 05/02/2025 09:59:16.7972 604 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 10:01:10.7994 1093 ms. EXEC: update payReceipt set recCreation = '2025-02-05 10:01:09',recModify = '2025-02-05 10:01:09',recUseId=0,recStatus='V' where recId = 349192 05/02/2025 10:05:32.9439 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:09:03.5246 1332 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-05 10:09:02','V',5444453526219850,2025,'2025-02-05 10:09:01','456913654100327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 10:09:08.8632 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 10:12:13.1250 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 10:12:34.7216 2014 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 10:12:32' where traUID = 5541335415353660 and traStatus='V' and traEnabled=1 05/02/2025 10:13:57.2055 672 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4908715925917460,5042850184907380,2025,'2025-02-05 10:13:56','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/5/2025 10:02:51 AM Date : 2/5/2025 10:13:55 AM Code : 456913617100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 05/02/2025 10:13:58.5434 823 ms. EXEC: update paycash set casCreation = '2025-02-05 10:13:57',casModify = '2025-02-05 10:13:57',casUseId=0,casStatus='V' where casId = 208101 05/02/2025 10:14:00.1925 1646 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 10:13:57',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 05/02/2025 10:14:01.9007 1379 ms. EXEC: update paycash set casCreation = '2025-02-05 10:14:00',casModify = '2025-02-05 10:14:00',casUseId=0,casStatus='V' where casId = 208102 05/02/2025 10:14:01.9687 1201 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-05 10:14:00','V',5162421411672440,2025,'2025-02-05 10:14:00','456913684000327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 10:15:26.5380 860 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 10:15:52.3395 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 10:15:55.5627 763 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 10:15:54',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'; 05/02/2025 10:17:34.7148 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:18:25.3851 544 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 10:18:36.7849 792 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 10:19:42.0110 714 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 10:20:04.8685 790 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/02/2025 10:20:29.9055 1285 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5549480227354320,4806098189193620,2025,'2025-02-05 10:20:28',' Date: 2/5/2025 10:19:48 AM Code: 456913455200327005012999 Entry Date: 2/5/2025 9:35:52 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 # 2500401578 ',0) 05/02/2025 10:20:48.2319 2324 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 10:21:26.5699 1315 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 10:21:58.3034 1130 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 10:21:56' where traUID = 5529358353632160 and traStatus='V' and traEnabled=1 05/02/2025 10:23:51.7552 1170 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:23:57.3910 586 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 10:23:58.7479 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:23:58.8710 1471 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 10:23:57' where payTraUID = 4843884856349120 and payStatus='V' and payEnabled=1 05/02/2025 10:24:16.0757 668 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 10:24: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'; 05/02/2025 10:28:13.8317 677 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 10:33:40.9323 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:33:42.6995 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:40:56.1961 1086 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:42:38.7536 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:42:39.4120 2049 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 402383 else acvFstPayId end),acvLstPayId = 402383 where acvSftId = 895 and acvCodeId = 3 05/02/2025 10:43:08.9200 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:44:09.5751 687 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/02/2025 10:47:09.5760 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:47:53.7860 662 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 10:48:59.9608 600 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 10:49:19.5470 1008 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 10:52:42.1132 633 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-05 10:52:41','V',4913164502706940,2025,'2025-02-05 10:52:40','456913916000327005012999',1,2,16,'I','',1,0,1,'','0810007130453',196,0) 05/02/2025 10:55:18.0439 545 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 10:55:17' where payTraUID = 4775964966463600 and payStatus='V' and payEnabled=1 05/02/2025 10:57:39.8099 570 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5139, trcLastPrinted = '2500705139', trcLastDate = '2025-02-05 10:57:39' where trcStatus='V' and trcTerId = 18 05/02/2025 10:57:59.8104 775 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5140, trcLastPrinted = '2500705140', trcLastDate = '2025-02-05 10:57:59' where trcStatus='V' and trcTerId = 18 05/02/2025 10:58:15.1959 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 10:58:32.0393 1114 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 10:59:56.7606 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:01:18.6311 1033 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 05/02/2025 11:05:20.6861 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:07:13.9738 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:07:14.0498 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:11:00.0579 1164 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:11:57.8981 2780 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1585, trcLastPrinted = '2500401585', trcLastDate = '2025-02-05 11:11:55' where trcStatus='V' and trcTerId = 4 05/02/2025 11:13:21.4997 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:13:26.1239 545 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 11:14:30.4054 883 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:15:34.7900 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:18:05.0928 2618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:18:50.3205 1255 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 05/02/2025 11:19:32.7412 633 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 11:20:54.1573 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:20:59.1417 546 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 11:20:58',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'; 05/02/2025 11:24:22.3163 690 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/02/2025 11:25:12.7885 967 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-05 11:25:10',0,'V',4806755967083060,5344823444021470,2025,'2025-02-05 11:25:10',3,1,0,4,'2025-02-05 11:40:10','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 05/02/2025 11:25:23.6809 530 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 11:26:46.2278 888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:28:07.1506 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:28:18.0380 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:30:51.4129 1199 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:31:28.5460 591 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 11:31:27' where payTraUID = 5013916617371140 and payStatus='V' and payEnabled=1 05/02/2025 11:31:29.0874 541 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 11:31:27' where traUID = 5013916617371140 and traStatus='V' and traEnabled=1 05/02/2025 11:33:08.9580 1488 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 11:33:11.1185 1955 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 11:34:17.2053 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:35:12.8189 549 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-05 11:35:12','V',4947076261229090,2025,'2025-02-05 11:35:11','456914171100327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 11:35:36.8312 913 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 11:36:00.8955 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:36:20.8550 674 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456914063300327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 05/02/2025 11:36:23.0005 617 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-05 11:36:22','V',5635739638094520,2025,'2025-02-05 11:36:21','456914178100327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 11:36:23.6259 620 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 11:38:58.5368 740 ms. OPEN: select * from tabTerminal where terId = 2 05/02/2025 11:39:23.6969 572 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 11:40:07.9148 588 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 11:40:34.3317 1207 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 11:40:51.1021 1552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:40:55.8013 926 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 11:40:54' where payTraUID = 5537819801357990 and payStatus='V' and payEnabled=1 05/02/2025 11:40:57.2422 1439 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 11:40:54' where traUID = 5537819801357990 and traStatus='V' and traEnabled=1 05/02/2025 11:43:13.4795 813 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:43:14.4452 1467 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:44:36.6649 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:46:46.4618 779 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/02/2025 11:49:14.2789 501 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/02/2025 11:50:36.9309 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:51:54.1822 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-05 11:51:53','V',5378498959410120,2025,'2025-02-05 11:51:51','456914271100327001012999',1,2,1,'I','',1,0,1,'','0230004101216',10,0) 05/02/2025 11:52:49.1674 1984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:54:03.9701 1974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:54:04.2203 2103 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 11:56:52.5033 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 11:57:59.5707 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 11:59:01.3335 691 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 12:01:58.3965 843 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-02-05 12:01:57',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-05 12:01:57',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 12:01:57',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'; 05/02/2025 12:03:01.7904 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:04:20.5437 1048 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-02-05 12:04:19',0,0,'V',5752262106582550,5617920047411430,2025,'2025-02-05 12:04:19',3,'KES',1,200,200,'N',''); 05/02/2025 12:04:26.9741 2030 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 12:04:24',17,1,'2025-02-05 12:04:24','456913549800327005012999','Pagato (Contanti ) Biglietto ') 05/02/2025 12:08:25.4576 2269 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 05/02/2025 12:08:27.2749 577 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0230003943530' order by traId desc limit 1 05/02/2025 12:11:25.4135 912 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/02/2025 12:12:08.2555 798 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 05/02/2025 12:13:16.1025 773 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 12:13:20.2193 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:16:27.7443 2513 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-05 12:16:25',0,'V',4648367051511780,4845740894536320,2025,'2025-02-05 12:16:25',18,1,0,4,'2025-02-05 12:31:25','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/02/2025 12:16:30.4771 1186 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:17:06.2774 658 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 12:17:07.7804 1086 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 12:17:06' where traUID = 5348829468447790 and traStatus='V' and traEnabled=1 05/02/2025 12:18:22.4570 850 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-05 12:18:21',0,'V',4660190047544220,5492279922823490,2025,'2025-02-05 12:18:21',18,1,0,4,'2025-02-05 12:33:21','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/02/2025 12:18:48.4786 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:20:37.1472 523 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5324668919513240,4733225431095260,2025,'2025-02-05 12:20:36',' Data: 2/5/2025 12:20:29 PM Codice: 456914346100327005012999 Ingresso: 2/5/2025 12:04:21 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500600885 ',0) 05/02/2025 12:20:37.8507 698 ms. EXEC: update payReceipt set recCreation = '2025-02-05 12:20:37',recModify = '2025-02-05 12:20:37',recUseId=0,recStatus='V' where recId = 349254 05/02/2025 12:20:41.6903 2232 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 12:20:39' where payTraUID = 4845740894536320 and payStatus='V' and payEnabled=1 05/02/2025 12:20:44.5112 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:21:17.2074 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:27:34.7661 704 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456914178100327005012999' 05/02/2025 12:27:39.8055 758 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:27:49.6262 1514 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 12:27:50.7739 1644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:27:53.7920 1906 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/02/2025 12:28:37.1764 540 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-05 12:28:35',0,'V',4670889885488270,4774233981107820,2025,'2025-02-05 12:28:35',3,1,0,4,'2025-02-05 12:43:35','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 05/02/2025 12:32:42.8888 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:34:51.0346 2602 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 12:34:48' where payTraUID = 4666512085752410 and payStatus='V' and payEnabled=1 05/02/2025 12:34:53.5553 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:35:43.7133 1085 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 12:36:02.4910 1269 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 12:36:17.9865 532 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/02/2025 12:41:45.3062 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:42:06.0112 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:42:45.6721 533 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/02/2025 12:43:46.9226 1290 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-05 12:43:45','V',5151663572152300,2025,'2025-02-05 12:43:45','456914109700327005012999',2,2,2,'O','',0,'2025-02-05 12:43:45',1,'','',0) 05/02/2025 12:43:47.7351 720 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 12:43:47' where payTraUID = 4717377617171100 and payStatus='V' and payEnabled=1 05/02/2025 12:43:52.5794 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:44:11.8014 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:46:11.4044 640 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 12:46:25.1487 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:56:35.2690 648 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 12:56:34' where traUID = 5441125392958730 and traStatus='V' and traEnabled=1 05/02/2025 12:56:39.4208 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:56:39.4258 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:57:40.6153 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:57:55.2842 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 12:58:58.5440 864 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 12:58:57' where traUID = 5124662399770490 and traStatus='V' and traEnabled=1 05/02/2025 12:59:04.4190 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 12:59:16.1089 802 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-05 12:59:15','V',5206745696859030,2025,'2025-02-05 12:59:14','456914564400327005012999',2,2,2,'O','',0,'2025-02-05 12:59:15',1,'','',0) 05/02/2025 12:59:16.8855 674 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 12:59:32.5661 633 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 13:01:14.9745 846 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 13:01:23.2130 732 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 13:01:32.6224 779 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-05 13:01:30',0,'V',5552350950585660,5226594560632220,2025,'2025-02-05 13:01:30',3,1,0,4,'2025-02-05 13:16:30','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 05/02/2025 13:01:32.6845 696 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 13:02:12.9617 948 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-05 13:02:11',0,'V',4836278052496850,5388672830392270,2025,'2025-02-05 13:02:11',3,1,0,4,'2025-02-05 13:17:11','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 05/02/2025 13:03:26.7427 635 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 13:03:34.6681 620 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 13:03:33' where traUID = 5226594560632220 and traStatus='V' and traEnabled=1 05/02/2025 13:06:27.5932 588 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 13:06:50.6088 631 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 13:07:04.2761 530 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 13:07:07.0920 601 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '456914566600327005012999' order by traId desc limit 1 05/02/2025 13:07:51.6111 731 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 13:08:35.6369 1051 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 13:10:27.2445 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 13:10:28.0441 1031 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-05 13:10:22',0,'V',5703290295859740,5734454612713340,2025,'2025-02-05 13:10:22',3,1,0,4,'2025-02-05 13:25:22','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 05/02/2025 13:10:32.5862 693 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/02/2025 13:12:37.3326 858 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 13:17:43.0497 552 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 13:18:07.0630 1641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:18:09.0413 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:19:48.9060 604 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/02/2025 13:22:20.6147 622 ms. EXEC: update payInventory set invCreation = '2025-02-05 13:22:19',invModify = '2025-02-05 13:22:19',invUseId=0,invStatus='V' where invId = 235167 05/02/2025 13:23:49.5079 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 13:24:42.8311 1596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:27:08.9350 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 13:28:42.5204 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:28:54.0772 1179 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-05 13:28:46',1,'V',4997898761796620,5398685336766970,2025,'2025-02-05 13:28:46',17,1,0,4,'2025-02-05 13:43:46','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/02/2025 13:30:02.1263 1539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:30:09.5383 587 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 13:30:52.0621 585 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/02/2025 13:32:55.6659 547 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-05 13:32:55','V',4812602652458130,2025,'2025-02-05 13:32:54','456914638100327001012999',2,2,2,'O','',0,'2025-02-05 13:32:55',1,'','',0) 05/02/2025 13:33:10.3858 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-05 13:33:09','V',4908358419671560,2025,'2025-02-05 13:33:08','456914878800327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 13:35:17.7321 794 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/02/2025 13:35:49.9229 605 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-05 13:35:49',0,'V',5492948688225300,5534187446824900,2025,'2025-02-05 13:35:49',18,1,0,4,'2025-02-05 13:50:49','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/02/2025 13:35:49.9259 593 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 2 ms.) 05/02/2025 13:37:20.7174 660 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 13:37:50.6817 586 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 13:39:33.7615 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 13:40:51.3821 1016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:45:04.8418 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 13:45:25.7229 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:48:41.8908 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:51:00.1014 1353 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 13:51:13.3624 1368 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 13:51:21.5229 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 13:58:23.3967 1257 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 13:58:23.3967 719 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 13:59:34.0735 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:00:47.4813 2455 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:01:38.2366 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:03:43.1392 1924 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:04:01.1664 1643 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/02/2025 14:05:01.8666 1333 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-05 14:05:00','V',5194855142021430,2025,'2025-02-05 14:04:59','456914803300327005012999',2,2,2,'O','',0,'2025-02-05 14:05:00',1,'','',0) 05/02/2025 14:05:16.9368 757 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '840990' and traDirection='I' order by traId DESC LIMIT 1 05/02/2025 14:05:23.7194 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:05:26.2751 2554 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 05/02/2025 14:05:38.5904 2133 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5051208977424000,4914449551452290,2025,'2025-02-05 14:05:36',' Date: 2/5/2025 2:05:35 PM Code: 456914407800327005012999 Entry Date: 2/5/2025 12:14:38 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 # 2500705172 ',0) 05/02/2025 14:06:44.5401 1247 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 14:06:45.1825 596 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 14:08:07.2311 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:09:45.5137 1817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:10:59.4468 1255 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:15:56.7932 1953 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:16:32.3823 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:17:28.5453 1171 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-05 14:17:27','V',5481667448872690,2025,'2025-02-05 14:17:27','456915144700327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 14:17:29.2588 746 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/02/2025 14:17:46.7827 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:26:38.4108 2795 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 14:27:06.3027 939 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:28:02.8840 511 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 14:28:02',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'; 05/02/2025 14:29:03.8122 593 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-05 14:29:03' where subId = 198 05/02/2025 14:29:05.4023 660 ms. OPEN: show columns from tabParameters where Field = 'parUseFloorCounter' 05/02/2025 14:30:12.3427 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:33:57.3601 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:34:22.9474 540 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-05 14:34:22',0,'V',5664785824199510,4703398385985200,2025,'2025-02-05 14:34:22',2,1,0,-1,'2025-02-05 15:34:22','S','KES',0,0,0,'','','',3,0,0) 05/02/2025 14:34:24.3093 945 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 14:35:09.7341 623 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 14:35:09' where traUID = 4796559287701740 and traStatus='V' and traEnabled=1 05/02/2025 14:35:54.2533 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:38:18.2408 850 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 14:39:08.1876 1045 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 14:41:21.4189 1201 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/02/2025 14:41:47.7767 751 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/02/2025 14:44:39.4330 1252 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-05 14:44:38',0,'V',5564608505318450,4799397366726700,2025,'2025-02-05 14:44:38',18,1,0,4,'2025-02-05 14:59:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/02/2025 14:45:36.1954 1086 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 14:45:38.8792 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:46:45.3843 643 ms. EXEC: update paycash set casCreation = '2025-02-05 14:46:44',casModify = '2025-02-05 14:46:44',casUseId=0,casStatus='V' where casId = 208173 05/02/2025 14:47:40.8549 740 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4944921720066750,4789226188990020,2025,'2025-02-05 14:47:40',' Date: 2/5/2025 2:46:59 PM Code: 456915085700327005012999 Entry Date: 2/5/2025 2:07:37 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 # 2500401598 ',0) 05/02/2025 14:48:57.5108 1290 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 14:49:20.6194 1317 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 05/02/2025 14:51:15.6474 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:52:25.9200 725 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-05 14:52:25','V',4980294046083840,2025,'2025-02-05 14:52:24','456915354400327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 14:52:44.0652 947 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1600, trcLastPrinted = '2500401600', trcLastDate = '2025-02-05 14:52:43' where trcStatus='V' and trcTerId = 4 05/02/2025 14:54:53.6660 589 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/02/2025 14:54:53.6670 589 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/02/2025 14:59:16.4440 596 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 14:59:25.0759 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 14:59:31.5693 936 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/02/2025 14:59:31.7204 918 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 15:01:32.5722 816 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-05 15:01:31','V',5469472055342360,2025,'2025-02-05 15:01:30','456915409000327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 15:02:51.1174 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:07:28.0730 2307 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 15:07:36.9130 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:10:00.5093 596 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 15:11:37.6361 1125 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 15:13:16.7892 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 22 ms.) 05/02/2025 15:13:47.1968 1122 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-05 15:13:46','V',4757742272380860,2025,'2025-02-05 15:13:45','456915482500327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 15:13:51.9110 847 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 15:22:43.8033 512 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 15:23:41.3833 525 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/02/2025 15:28:37.8901 788 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 15:29:14.4459 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:32:20.9632 1175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:32:40.6385 1295 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 402557 else acvFstPayId end),acvLstPayId = 402557 where acvSftId = 895 and acvCodeId = 3 05/02/2025 15:33:14.7126 1182 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:33:53.1597 1680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:39:13.5687 1373 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5193982798930490,5509085923049040,2025,'2025-02-05 15:39:12',' Date: 2/5/2025 3:39:11 PM Code: 456915147000327005012999 Entry Date: 2/5/2025 2:17:50 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 # 2500705193 ',0) 05/02/2025 15:41:28.1478 524 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-05 15:41:27','V',5603375269776040,2025,'2025-02-05 15:41:26','456915648600327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 15:41:48.1634 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 15:41:48.2615 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:47:14.5565 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:49:18.0821 1158 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/02/2025 15:49:19.1248 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:49:19.1379 661 ms. OPEN: show columns from tabParameters where Field = 'parForce24Hours' 05/02/2025 15:49:19.1389 664 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 05/02/2025 15:50:58.9575 513 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-05 15:50:58','V',5571212112414620,2025,'2025-02-05 15:50:56','456915640600327001012999',2,2,2,'O','',0,'2025-02-05 15:50:58',1,'','0230003944081',15,0) 05/02/2025 15:51:03.3534 802 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 15:51:12.5146 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 15:51:13.8425 534 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 15:53:07.5466 973 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 15:53:25.1715 846 ms. EXEC: update payReceipt set recCreation = '2025-02-05 15:53:24',recModify = '2025-02-05 15:53:24',recUseId=0,recStatus='V' where recId = 349370 05/02/2025 15:54:22.1091 570 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-05 15:54:21','V',5488220324242590,2025,'2025-02-05 15:54:19','456915527400327005012999',2,2,2,'O','',0,'2025-02-05 15:54:21',1,'','',0) 05/02/2025 15:55:24.2792 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 15:57:08.9161 519 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 15:57:44.4942 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 15:57:44.7653 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-05 15:57:43','V',5475914572798260,2025,'2025-02-05 15:57:40','456915746000327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 15:57:45.6249 514 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 15:59:26.0579 735 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-05 15:59:24',0,'V',4666230745101180,4757742272380860,2025,'2025-02-05 15:59:24',3,1,0,4,'2025-02-05 16:14:24','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 05/02/2025 16:02:41.6234 7264 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 05/02/2025 16:04:31.7360 774 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5603375269776040,4984093064747000,2025,'2025-02-05 16:04:30','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 2/5/2025 3:41:26 PM Date : 2/5/2025 4:04:28 PM Code : 456915648600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 05/02/2025 16:04:32.5535 816 ms. EXEC: update payReceipt set recCreation = '2025-02-05 16:04:31',recModify = '2025-02-05 16:04:31',recUseId=0,recStatus='V' where recId = 349378 05/02/2025 16:04:56.5828 749 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5203, trcLastPrinted = '2500705203', trcLastDate = '2025-02-05 16:04:55' where trcStatus='V' and trcTerId = 18 05/02/2025 16:07:16.2104 4467 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:09:42.2463 564 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 16:09:50.6000 1071 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:10:50.5206 1621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:11:19.8884 1192 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:12:15.1799 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:13:55.7270 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:16:19.3533 645 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 16:17:02.6376 1435 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 16:18:58.9674 1813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:22:45.2967 1014 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/02/2025 16:23:16.5128 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:29:15.9933 789 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-05 16:29:15','V',5162341567471390,2025,'2025-02-05 16:29:13','456915614100327001012999',2,2,2,'O','',0,'2025-02-05 16:29:15',1,'','',0) 05/02/2025 16:30:39.5539 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:33:20.1807 515 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 16:36:26.4609 683 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 16:36:25' where traUID = 4791568040602900 and traStatus='V' and traEnabled=1 05/02/2025 16:36:46.6836 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:37:29.7588 541 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 05/02/2025 16:38:13.5935 618 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4697101554449950,4706010888421920,2025,'2025-02-05 16:38:12',' Date: 2/5/2025 4:38:12 PM Code: 456915735900327005012999 Entry Date: 2/5/2025 3:55:59 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 # 2500705211 ',0) 05/02/2025 16:38:34.0463 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:41:07.5543 634 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 16:42:24.4384 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:42:31.5592 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:44:29.2509 975 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:46:42.7253 2647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:52:30.1346 683 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 16:52:30.7901 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:52:39.9093 2415 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 05/02/2025 16:52:40.8549 3819 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 16:52:36',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'; 05/02/2025 16:53:40.6344 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:54:18.6321 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:55:03.8958 715 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:55:04.4041 513 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/02/2025 16:55:19.3403 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 16:58:05.9901 840 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 16:58:58.9760 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 16:59:40.9044 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:01:15.6076 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:03:50.9978 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 17:05:28.8941 2123 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 17:07:47.1298 758 ms. EXEC: update abbCards set carLastDate = '2025-02-05 17:07:46',carLastDirection='I' where carStatus='V' and carId = 13 05/02/2025 17:08:13.4336 557 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 17:14:04.8636 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:16:49.0738 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:17:12.7469 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:22:39.3161 527 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 17:22:38' where traUID = 4775568579027560 and traStatus='V' and traEnabled=1 05/02/2025 17:25:11.0458 741 ms. EXEC: update payReceipt set recCreation = '2025-02-05 17:25:10',recModify = '2025-02-05 17:25:10',recUseId=0,recStatus='V' where recId = 349409 05/02/2025 17:25:22.4936 1126 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-05 17:25:21',0,'V',4777365534467810,5023164471551760,2025,'2025-02-05 17:25:21',2,1,0,-1,'2025-02-05 18:25:21','S','KES',0,0,0,'','','',3,0,0) 05/02/2025 17:25:47.3735 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 17:25:54.2081 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:29:10.4330 1691 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-05 17:29:08',0,'V',5494103444843480,5750363899750760,2025,'2025-02-05 17:29:08',18,1,0,4,'2025-02-05 17:44:08','C','KES',300,300,0,'','','',1,300,0,0,'',0,0) 05/02/2025 17:29:24.0512 764 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 17:30:20.5605 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:31:15.9470 1015 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 17:37:50.0730 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 17:38:55.4753 868 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-02-05 17:38:54' where subId = 172 05/02/2025 17:42:44.4614 1275 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:43:01.7140 663 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-05 17:43:01',0,'V',5020728729510150,5615479186322520,2025,'2025-02-05 17:43:01',18,1,0,4,'2025-02-05 17:58:01','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/02/2025 17:46:04.5499 1876 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/02/2025 17:46:04.5609 1113 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 05/02/2025 17:46:06.1620 883 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 17:47:19.7808 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:50:33.5021 1229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:51:14.0235 1726 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/02/2025 17:55:46.7883 509 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-05 17:55:46',0,'V',5420326393538100,4896940408363190,2025,'2025-02-05 17:55:46',18,1,0,4,'2025-02-05 18:10:46','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/02/2025 17:55:48.0691 1024 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4896940408363190,5420326393538100,2025,'2025-02-05 17:55:47',' Date: 2/5/2025 5:55:46 PM Code: 456916350200327005012999 Entry Date: 2/5/2025 5:38:22 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 # 2500705225 ',0) 05/02/2025 17:56:31.9108 691 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-05 17:56:31',0,'V',5691828057754000,5681008573737010,2025,'2025-02-05 17:56:31',2,1,0,-1,'2025-02-05 18:56:31','S','KES',0,0,0,'','','',3,0,0) 05/02/2025 17:57:13.4360 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 17:58:01.1483 1091 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 17:58:00' where payTraUID = 4896940408363190 and payStatus='V' and payEnabled=1 05/02/2025 17:59:11.1787 525 ms. EXEC: update payReceipt set recCreation = '2025-02-05 17:59:10',recModify = '2025-02-05 17:59:10',recUseId=0,recStatus='V' where recId = 349416 05/02/2025 18:00:41.1967 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 18:01:42.6343 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 18:03:36.2923 2055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 18:14:26.9130 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 18:14:28.0067 709 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/02/2025 18:14:31.8933 871 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 18:14:31',0,16,'2025-02-05 18:14:31','','Unauthorized Transit Entry 2') 05/02/2025 18:19:46.3353 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 18:23:43.6100 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 18:27:33.1115 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 18:28:29.3176 922 ms. EXEC: update paycash set casCreation = '2025-02-05 18:28:28',casModify = '2025-02-05 18:28:28',casUseId=0,casStatus='V' where casId = 208211 05/02/2025 18:28:37.8653 597 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5227, trcLastPrinted = '2500705227', trcLastDate = '2025-02-05 18:28:37' where trcStatus='V' and trcTerId = 18 05/02/2025 18:28:54.7348 676 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-05 18:28:54','V',5221061436532420,2025,'2025-02-05 18:28:52','456916653200327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 18:30:33.3025 890 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 05/02/2025 18:33:10.3669 687 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 18:34:05.7895 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 18:39:18.7154 693 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-05 18:39:17',0,'V',5725127418402640,5485354691213490,2025,'2025-02-05 18:39:17',18,1,0,4,'2025-02-05 18:54:17','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/02/2025 18:41:27.1814 1011 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 18:45:04.6898 659 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-05 18:45:04',0,16,'2025-02-05 18:45:04','','Unauthorized Transit Entry 2') 05/02/2025 18:45:11.7175 533 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-05 18:45:11','V',5661397959285020,2025,'2025-02-05 18:45:09','456916750900327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 18:45:12.8353 909 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 18:46:02.8802 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 18:46:33.3548 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 18:48:53.1125 575 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-05 18:48:52','V',5758374429974910,2025,'2025-02-05 18:48:52','456916773200327005012999',1,2,16,'I','',1,0,1,'','',4) 05/02/2025 18:49:12.1644 886 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/02/2025 18:49:41.8285 550 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 18:54:01.9507 503 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/02/2025 18:54:03.8560 1480 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 18:57:33.8182 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 19:01:02.5235 580 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5571221275820980,4978311234280380,2025,'2025-02-05 19:01:01',' Date: 2/5/2025 7:01:01 PM Code: 456916710300327005012999 Entry Date: 2/5/2025 6:38:23 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 # 2500705236 ',0) 05/02/2025 19:01:17.7559 806 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 19:01:25.6302 1462 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:02:50.6808 617 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/02/2025 19:04:13.5349 913 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-05 19:04:12',0,'V',4979482464994720,5750588786248630,2025,'2025-02-05 19:04:12',2,1,0,-1,'2025-02-05 20:04:12','S','KES',0,0,0,'','','',3,0,0) 05/02/2025 19:04:21.9456 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 19:05:38.6886 1048 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 19:05: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'; 05/02/2025 19:05:39.5742 885 ms. EXEC: update payInventory set invCreation = '2025-02-05 19:05:38',invModify = '2025-02-05 19:05:38',invUseId=0,invStatus='V' where invId = 235234 05/02/2025 19:07:59.3419 567 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/02/2025 19:09:29.9332 529 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-05 19:09:29',0,'V',5601061181414550,5370287176887880,2025,'2025-02-05 19:09:29',18,1,0,4,'2025-02-05 19:24:29','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/02/2025 19:10:23.4725 561 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 19:11:46.9520 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 19:12:34.5123 1151 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 19:12:39.4636 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 19:13:25.3037 652 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 05/02/2025 19:16:05.2850 1115 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/02/2025 19:16:08.2510 793 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-02-05 19:16:07',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'; 05/02/2025 19:16:22.1554 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:16:31.2816 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:22:46.1655 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:24:04.4296 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 19:24:32.4866 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:30:49.7331 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 19:35:41.7599 791 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 19:43:04.1455 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 19:44:23.1571 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:51:56.4811 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:56:28.7145 1082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:57:04.8210 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:57:39.9457 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 19:57:40.0588 889 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/02/2025 20:04:25.3443 537 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/02/2025 20:04:26.2680 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 20:04:59.1062 1044 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/02/2025 20:05:21.6185 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:09:16.0522 507 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-05 20:09:15','V',4765483517561590,2025,'2025-02-05 20:09:15','456916938000327005012999',2,2,2,'O','',0,'2025-02-05 20:09:15',1,'','',0) 05/02/2025 20:09:21.5820 782 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 20:10:40.8327 953 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 20:13:35.5680 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:13:42.2656 548 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 05/02/2025 20:17:34.3568 1422 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/02/2025 20:18:41.1320 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:20:33.9034 1168 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/02/2025 20:22:38.1635 529 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 20:22:56.8582 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:23:59.9920 866 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-05 20:23:59' where payTraUID = 5684241881132080 and payStatus='V' and payEnabled=1 05/02/2025 20:24:25.4482 784 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-05 20:24:24','0230003944059',0,0,5191177184314040,13,'0000-00-00 00:00:00','0000-00-00 00:00:00') 05/02/2025 20:24:26.1917 732 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-05 20:24:25',0,'V',5191177184314040,4643755891281030,2025,'2025-02-05 20:24:25',2,1,0,-1,'2025-02-05 21:24:25','S','KES',0,0,0,'','','',3,0,0) 05/02/2025 20:24:27.7428 1140 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 20:26:09.1905 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1 ms.) 05/02/2025 20:27:03.5523 755 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 20:27:03.5523 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:32:25.9547 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:33:51.9579 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:34:06.2756 1184 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:35:28.2512 825 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 20:35:38.9754 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:35:40.7646 1010 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/02/2025 20:36:12.9845 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:39:37.1087 1119 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 20:40:20.9674 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:41:30.5616 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:43:56.3623 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:50:54.5406 575 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 05/02/2025 20:50:55.0419 914 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 20:56:10.7227 553 ms. OPEN: select sum(casTotAmount) as vTot from payCash where casStatus='V' and casTraUID = 5589619806643210 05/02/2025 20:56:12.7881 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 20:59:28.4477 1813 ms. EXECSCALAR: SELECT COUNT(*) FROM payPayment INNER JOIN movTransit ON traUID = payTrauid WHERE payStatus='V' AND payPayed=0 AND payAmount=0 AND payDiscount = 100 AND payDiscountType = 1 AND traStatus='V' AND traEnabled = 1 AND traCode = '456916307400327005012999' nr: 0 05/02/2025 21:00:41.4921 3840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:01:15.9565 1120 ms. EXEC: update payReceipt set recCreation = '2025-02-05 21:01:14',recModify = '2025-02-05 21:01:14',recUseId=0,recStatus='V' where recId = 349463 05/02/2025 21:01:20.3424 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:02:10.5014 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:03:10.1158 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 21:07:54.1322 743 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/02/2025 21:07:54.9347 574 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-05 21:07:54' where traUID = 5612967218916800 and traStatus='V' and traEnabled=1 05/02/2025 21:11:46.1053 522 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-05 21:11:45',0,'V',5450880455352550,5120370110950040,2025,'2025-02-05 21:11:45',18,1,0,4,'2025-02-05 21:26:45','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/02/2025 21:11:46.7768 582 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5120370110950040,5450880455352550,2025,'2025-02-05 21:11:46',' Date: 2/5/2025 9:11:45 PM Code: 456916749000327005012999 Entry Date: 2/5/2025 6:44:50 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 # 2500705254 ',0) 05/02/2025 21:12:11.5635 809 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-05 21:12:10','V',5138537877077400,2025,'2025-02-05 21:12:10','456916843000327005012999',2,2,2,'O','',0,'2025-02-05 21:12:10',1,'','',0) 05/02/2025 21:12:13.7931 2192 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/02/2025 21:12:18.0429 509 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 21:13:03.1855 707 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 21:16:22.4085 586 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 05/02/2025 21:16:22.4125 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 21:18:34.7551 2291 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 05/02/2025 21:21:17.0740 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:21:45.0160 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:25:18.4465 660 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/02/2025 21:28:00.7555 734 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 21:28:09.1341 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:35:07.3934 836 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/02/2025 21:35:12.1807 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:36:00.9097 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:42:43.2522 599 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/02/2025 21:42:56.4782 1211 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:50:55.5917 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:51:59.0147 964 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456917597000327001012999' 05/02/2025 21:53:01.3018 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:53:24.2874 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:55:55.9992 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 21:57:39.1370 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 21:59:28.6462 590 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-02-05 21:59:28','V',5086481579555270,2025,'2025-02-05 21:59:27','456917719900327005012999',2,2,2,'O','',0,'2025-02-05 21:59:28',1,'','',0) 05/02/2025 21:59:32.5168 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 22:00:30.4851 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:00:48.9816 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:06:50.1453 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:15:20.9002 535 ms. EXEC: update abbCards set carLastDate = '2025-02-05 22:15:20',carLastDirection='I' where carStatus='V' and carId = 15 05/02/2025 22:15:41.1849 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:16:26.2175 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:16:27.5984 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:23:13.9176 691 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 05/02/2025 22:23:15.0243 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 22:26:51.7622 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:27:15.5253 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:27:35.6659 1758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:28:02.0147 830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:33:05.2261 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:34:39.9583 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 22:37:13.9596 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 22:37:14.8362 824 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 22:44:33.6994 886 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 22:45:55.0676 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:00:41.1017 944 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:08:17.9902 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:18:10.7417 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 23:18:48.4332 801 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 05/02/2025 23:26:08.4312 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:26:35.8258 1382 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 23:26:48.1311 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/02/2025 23:26:48.7355 527 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/02/2025 23:26:50.3006 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:26:53.6749 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:31:40.3250 522 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/02/2025 23:33:50.4041 1663 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-05 23:33:48','V',5588354508178400,2025,'2025-02-05 23:33:46','456910000600327003229999',22,22,3,'I','',1,0,1,'','',2) 05/02/2025 23:35:56.8498 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:36:40.7075 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:37:38.0593 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:38:41.4403 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:49:08.5180 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/02/2025 23:49:15.9150 733 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/02/2025 23:54:54.2802 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1