27/03/2025 06:41:20.6655 1439 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 06:50:23.4981 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:07:25.8896 910 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/03/2025 07:13:43.9881 1226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:16:40.3433 1092 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:23:13.7446 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:26:49.5879 587 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/03/2025 07:28:02.6567 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:28:58.1135 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 07:29:25.9465 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:29:54.7471 2033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:30:14.3445 582 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/03/2025 07:30:57.5510 2668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:31:08.8967 2817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:34:40.9711 1137 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 27/03/2025 07:39:18.1253 1039 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,0,50,-1,-50,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,0,50,1,50,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,0,100,-42,-4200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,0,100,42,4200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,0,200,-4,-800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,0,200,4,800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 07:38:54',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 27/03/2025 07:40:24.1213 584 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/03/2025 07:42:03.5871 874 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-03-27 07:42:02',0,3,'2025-03-27 07:42:02','0230003944086','POF - User Transit Supervisor Supervisor') 27/03/2025 07:43:35.2786 1431 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:45:16.6818 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:45:24.8493 1283 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:45:31.3037 970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:48:41.9748 1469 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:48:48.6743 4598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:55:21.7694 573 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/03/2025 07:55:33.5204 995 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 07:55:58.7356 1899 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 27/03/2025 07:55:59.1328 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 07:55:59.9234 742 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 07:56:35.8819 849 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0230003943861' order by traId desc limit 1 27/03/2025 07:57:54.2664 1003 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 167 order by traDateTime desc,traId desc 27/03/2025 08:05:12.8290 664 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 08:06:08.1558 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:09:10.6622 639 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/03/2025 08:10:30.1223 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:13:18.4981 590 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/03/2025 08:13:23.1392 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:15:33.2630 608 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/03/2025 08:15:50.3026 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:23:07.0684 619 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5346089810298740,5117036471280670,2025,'2025-03-27 08:23:06','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 3/27/2025 7:29:00 AM Date : 3/27/2025 8:23:04 AM Code : 457412694000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 27/03/2025 08:24:07.9269 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:26:38.0783 1943 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:27:05.8863 759 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/03/2025 08:28:41.8927 735 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 08:28:58.3910 702 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 27/03/2025 08:34:37.0929 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 08:35:23.3265 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:36:18.7843 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:37:21.7982 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:38:54.2323 741 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 08:43:11.1705 1346 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-03-27 08:43:09','V',4928170007147660,2025,'2025-03-27 08:43:08','457412935000327005012999',2,2,2,'O','',0,'2025-03-27 08:43:09',1,'','',0) 27/03/2025 08:43:12.2642 779 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-03-27 08:43:11' where payTraUID = 5429108425696880 and payStatus='V' and payEnabled=1 27/03/2025 08:49:04.9547 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:49:36.7294 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:49:51.0952 1893 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 08:49:55.9435 810 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 08:52:26.6733 1449 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:52:33.9412 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 08:55:07.6230 1073 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 27/03/2025 08:56:25.1686 588 ms. EXEC: update tabTerminalReceipt set trcProgressive = 12266, trcLastPrinted = '2500712266', trcLastDate = '2025-03-27 08:56:24' where trcStatus='V' and trcTerId = 18 27/03/2025 09:00:23.1032 967 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-03-27 09:00:22',0,16,'2025-03-27 09:00:22','','Unauthorized Transit Entry 2') 27/03/2025 09:01:07.3564 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 09:01:57.0893 921 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/03/2025 09:04:33.2928 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 09:08:47.8834 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:16:23.8925 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:17:32.6814 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:19:13.4562 2190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:21:22.3220 1123 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:21:30.4916 807 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-27 09:21:29' where traUID = 4611850321781540 and traStatus='V' and traEnabled=1 27/03/2025 09:21:35.4019 604 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/03/2025 09:21:42.1576 6576 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 27/03/2025 09:21:58.3096 532 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-03-27 09:21:57','V',4793984889822890,2025,'2025-03-27 09:21:48','457413212300327001029999',2,2,1,'I','',1,0,1,'','0532370834528',10,0) 27/03/2025 09:21:59.0391 676 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 09:28:07.7674 1021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:29:02.9860 820 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 09:32:21.8646 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:32:36.8458 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 09:34:03.9762 643 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 09:34:16.4357 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:37:08.3590 1140 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:37:49.6081 720 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-03-27 09:37:48','V',5343546490769000,2025,'2025-03-27 09:37:47','457413278100327001012999',2,2,2,'O','',0,'2025-03-27 09:37:48',1,'','',0) 27/03/2025 09:38:14.3110 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 09:39:23.9434 979 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/03/2025 09:39:29.8995 1081 ms. EXEC: update tabTerminalReceipt set trcProgressive = 12274, trcLastPrinted = '2500712274', trcLastDate = '2025-03-27 09:39:28' where trcStatus='V' and trcTerId = 18 27/03/2025 09:42:49.9599 803 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-03-27 09:42:49','V',4641773096239670,2025,'2025-03-27 09:42:47','457412141300327005012999',2,2,2,'O','',0,'2025-03-27 09:42:49',1,'','0560008304916',190,0) 27/03/2025 09:42:50.7965 673 ms. EXEC: update abbCards set carLastDate = '2025-03-27 09:42:50',carLastDirection='O' where carStatus='V' and carId = 190 27/03/2025 09:46:57.7090 1855 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-03-27 09:46:55','V',5526717212290630,2025,'2025-03-27 09:46:53','457413521300327005012999',1,2,16,'I','',1,0,1,'','',4) 27/03/2025 09:48:59.9804 1008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:53:54.5973 1688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 09:54:26.6301 609 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 09:54:27.5227 877 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traCode = '457413566500327005012999' and traDirection='I' order by traId DESC LIMIT 1 nr: 892382 27/03/2025 09:56:42.4958 512 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-03-27 09:56:41','V',4768652263364180,2025,'2025-03-27 09:56:41','457413580100327001012999',1,2,1,'I','',1,0,1,'','',4) 27/03/2025 09:57:01.0294 753 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 10:01:19.4496 2044 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:02:17.3361 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:02:46.1657 1126 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:04:24.2917 1825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:05:48.8803 1535 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-03-27 10:05:47',0,'V',5353622555067600,5548798593171320,2025,'2025-03-27 10:05:47',18,1,0,4,'2025-03-27 10:20:47','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 27/03/2025 10:08:56.4306 601 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/03/2025 10:09:34.7707 738 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 892363 27/03/2025 10:12:10.3648 1731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:12:16.0787 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:19:57.1032 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:21:07.1119 999 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 27/03/2025 10:22:29.3530 1101 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:23:02.6257 1280 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:23:13.1098 1965 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 41 order by traDateTime desc,traId desc 27/03/2025 10:23:42.0225 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:25:06.5662 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:26:58.2173 2022 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:27:14.9707 1530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:27:30.9967 1434 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:27:58.2362 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:29:23.6215 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:31:44.5145 933 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/03/2025 10:38:40.5518 1582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:43:32.0176 2388 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:48:49.9504 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:51:32.4572 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:53:51.3679 929 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 10:55:06.0558 542 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-03-27 10:55:05','V',5046258228281550,2025,'2025-03-27 10:55:05','457413930500327005012999',1,2,16,'I','',1,0,1,'','',4) 27/03/2025 11:05:40.9628 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/03/2025 11:05:42.4048 1092 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 27/03/2025 11:06:19.7602 931 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-03-27 11:06:18',0,16,'2025-03-27 11:06:18','','Unauthorized Transit Entry 2') 27/03/2025 11:06:31.5853 1206 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-03-27 11:06:30','V',5141870719551980,2025,'2025-03-27 11:06:29','457413998900327005012999',1,2,16,'I','',1,0,1,'','',4) 27/03/2025 11:14:14.9042 628 ms. EXEC: update tabTerminalReceipt set trcProgressive = 12293, trcLastPrinted = '2500712293', trcLastDate = '2025-03-27 11:14:14' where trcStatus='V' and trcTerId = 18 27/03/2025 11:15:36.6059 738 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 27/03/2025 11:16:52.3666 1780 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 11:16:50',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-03-27 11:16:50',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 27/03/2025 11:17:29.8711 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:25:00.0131 2541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:26:26.1188 1026 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/03/2025 11:27:07.2358 1005 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 27/03/2025 11:27:10.6962 743 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-03-27 11:27:09','V',5316260571924150,2025,'2025-03-27 11:27:09','457414122900327005012999',1,2,16,'I','',1,0,1,'','',4) 27/03/2025 11:28:04.4168 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:28:16.1878 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:29:31.0779 826 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-03-27 11:29:30' where payTraUID = 5764243278192450 and payStatus='V' and payEnabled=1 27/03/2025 11:29:31.7474 668 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-27 11:29:30' where traUID = 5764243278192450 and traStatus='V' and traEnabled=1 27/03/2025 11:31:20.0742 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:32:23.9168 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:33:28.7790 1013 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/03/2025 11:33:36.9686 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:33:44.2175 676 ms. EXEC: update tabTerminalReceipt set trcProgressive = 12296, trcLastPrinted = '2500712296', trcLastDate = '2025-03-27 11:33:43' where trcStatus='V' and trcTerId = 18 27/03/2025 11:43:33.0352 592 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 11:44:32.3777 759 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-03-27 11:44:31','V',5669997955292720,2025,'2025-03-27 11:44:30','457414227000327005012999',1,2,16,'I','',1,0,1,'','',4) 27/03/2025 11:44:50.6261 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:46:11.9536 1041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/03/2025 11:47:52.2810 523 ms. EXEC: update payInventory set invCreation = '2025-03-27 11:47:51',invModify = '2025-03-27 11:47:51',invUseId=0,invStatus='V' where invId = 243558 27/03/2025 11:47:59.9182 2109 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-03-27 11:47:57','V',5316780584660740,2025,'2025-03-27 11:47:57','457414247700327001012999',1,2,1,'I','',1,0,1,'','',4) 27/03/2025 11:50:40.6838 1149 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/03/2025 11:52:08.0684 33866 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 27/03/2025 11:52:08.7549 685 ms. OPEN: select * from payFiscalReport where fsrStatus='V' and fsrType = 2 and fsrUseId = 1 order by fsrDateTime desc 27/03/2025 11:54:00.5661 635 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/03/2025 11:54:38.7191 1078 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-03-27 11:54:37' where traUID = 4759867666689690 and traStatus='V' and traEnabled=1 27/03/2025 11:54:43.2963 693 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/03/2025 12:30:53.9649 521 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-03-27 12:30:53' where payTraUID = 5198011127506350 and payStatus='V' and payEnabled=1 27/03/2025 13:06:15.2920 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-03-27 13:06:13',0,'V',5169165017248270,5543901901879180,2025,'2025-03-27 13:06:13',3,1,0,4,'2025-03-27 13:21:13','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 27/03/2025 21:28:29.1177 555 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-03-27 21:28:28' where payTraUID = 4979009525144770 and payStatus='V' and payEnabled=1 27/03/2025 22:07:32.1337 2352 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc