02/04/2025 00:11:00.8926 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 00:11:48.1491 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 00:30:24.3332 851 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 02/04/2025 00:38:51.4006 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 00:46:01.9539 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 00:56:26.4583 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 01:10:40.4613 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 02:00:59.1012 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 02:07:18.5712 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 02:07:21.2900 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 02:37:34.2279 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 02:41:26.9642 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 03:07:21.9602 1853 ms. EXEC: update payInventory set invCreation = '2025-04-02 03:07:20',invModify = '2025-04-02 03:07:20',invUseId=0,invStatus='V' where invId = 244561 02/04/2025 03:17:47.7708 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 03:21:57.8972 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 04:02:02.6644 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 04:10:16.8052 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 04:28:40.9651 1401 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 04:35:29.3406 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 04:46:38.0552 1337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 04:56:24.7956 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 05:07:55.1863 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 05:10:30.9455 556 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 05:10:30' where traUID = 5481255504151960 and traStatus='V' and traEnabled=1 02/04/2025 05:11:18.6453 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 05:25:29.0657 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 05:38:08.7060 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 05:38:14.2427 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 05:53:37.3728 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 05:58:06.0601 1789 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 02/04/2025 06:07:31.3008 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 06:15:15.6130 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 06:16:15.1057 1343 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 06:19:13.5428 1160 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 02/04/2025 06:19:55.8170 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 06:26:11.4717 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 06:32:33.7298 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 06:40:46.1776 1502 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 02/04/2025 06:43:53.1934 1411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 06:54:45.0524 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 06:58:21.1966 870 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 06:58:22.3284 1086 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 02/04/2025 07:08:50.5454 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 07:09:19.8130 1644 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 07:09:17',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'; 02/04/2025 07:18:49.3771 843 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-04-02 07:18:48','V',4914115817399770,2025,'2025-04-02 07:18:43','457472632300327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 07:24:28.9390 512 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 02/04/2025 07:26:08.1252 2636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 07:26:08.6546 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 07:27:26.6887 778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 07:27:47.1673 964 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 07:27:50.6266 706 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 07:27:51.3731 601 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 02/04/2025 07:28:19.3918 1317 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 07:28:19.3918 1051 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 02/04/2025 07:47:23.1684 1386 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 07:51:57.8260 966 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-04-02 07:51:56','V',5448010719070770,2025,'2025-04-02 07:51:54','457472831400327005012999',1,2,16,'I','',1,0,1,'','0230003939767',156,0) 02/04/2025 07:52:07.3803 2010 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 07:52:05',0,16,'2025-04-02 07:52:05','','Unauthorized Transit Entry 2') 02/04/2025 07:54:51.3117 683 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 07:54:51.3218 675 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-04-02 07:54:50',0,'V',4620238182461200,5628170954213060,2025,'2025-04-02 07:54:50',18,1,0,4,'2025-04-02 08:09:50','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 02/04/2025 07:56:55.4326 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-04-02 07:56:54','V',5343562850570100,2025,'2025-04-02 07:56:53','457472639100327001012999',2,2,2,'O','',0,'2025-04-02 07:56:54',1,'','',0) 02/04/2025 07:56:59.7985 697 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); 02/04/2025 08:02:15.6784 548 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 02/04/2025 08:04:10.7011 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:05:10.2589 627 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 02/04/2025 08:09:17.4038 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:11:35.6160 1094 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:17:18.2627 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:18:51.1129 700 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 02/04/2025 08:21:37.0126 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 08:21:40.3548 1840 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-04-02 08:21:38','V',5035443678603850,2025,'2025-04-02 08:21:38','457473009800327001012999',1,2,1,'I','',1,0,1,'','',4) 02/04/2025 08:22:27.1771 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:23:36.5484 636 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 02/04/2025 08:31:23.6087 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:32:05.8349 826 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 02/04/2025 08:32:30.6234 1102 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 08:33:10.2118 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:33:19.4240 680 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 08:35:20.2196 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:36:21.8027 1062 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 02/04/2025 08:37:37.1820 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:39:00.7568 1533 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 08:40:06.2235 670 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 08:40:05' where payTraUID = 5567260770530110 and payStatus='V' and payEnabled=1 02/04/2025 08:40:26.8202 694 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 02/04/2025 08:40:28.2462 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:42:06.5098 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:43:00.6109 1549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:47:30.1991 590 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 02/04/2025 08:51:10.3421 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 08:52:30.0114 589 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 08:52:29',0,16,'2025-04-02 08:52:29','','Unauthorized Transit Entry 2') 02/04/2025 08:59:52.5114 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:00:06.5337 725 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 09:01:13.8437 1932 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-04-02 09:01:11','V',5660859435700520,2025,'2025-04-02 09:01:11','457470000100327003229999',22,22,3,'I','',1,0,1,'','',2) 02/04/2025 09:04:19.2324 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:05:02.2601 961 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 02/04/2025 09:05:42.0927 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:06:09.1297 555 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 02/04/2025 09:06:19.7518 2188 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 02/04/2025 09:06:21.4720 656 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 02/04/2025 09:06:32.0650 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:06:33.7512 947 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 09:07:08.5003 2561 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-04-02 09:07:05','V',5609012475172630,2025,'2025-04-02 09:07:05','457473282500327005012999',1,2,16,'I','',1,0,1,'','0230004100082',142,0) 02/04/2025 09:08:52.7899 562 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 09:08:59.6385 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:09:07.4077 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:11:41.3344 517 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-04-02 09:11:40','V',5100618618975610,2025,'2025-04-02 09:11:40','457473310000327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 09:12:14.8488 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:14:44.0764 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:15:40.2889 683 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 02/04/2025 09:16:00.1922 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:24:40.0601 672 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-04-02 09:24:39','V',4633209557886790,2025,'2025-04-02 09:24:34','457472850500327005012999',2,2,2,'O','',0,'2025-04-02 09:24:39',1,'','',0) 02/04/2025 09:24:49.7476 1438 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:37:49.1412 1107 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); 02/04/2025 09:41:45.6133 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 09:50:19.0739 537 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-02 09:50:18','V',5098766717417000,2025,'2025-04-02 09:50:18','457473438100327005012999',2,2,2,'O','',0,'2025-04-02 09:50:18',1,'','',0) 02/04/2025 09:52:07.7895 3859 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-04-02 09:52:03',0,'V',5355996530720890,4935541919118940,2025,'2025-04-02 09:52:03',18,1,0,4,'2025-04-02 10:07:03','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 02/04/2025 09:53:25.2903 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:57:03.3699 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 09:58:28.7329 1246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:02:42.2082 2626 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-04-02 10:02:39','V',5380052261064230,2025,'2025-04-02 10:02:37','457473399500327005012999',2,2,2,'O','',0,'2025-04-02 10:02:39',1,'','',0) 02/04/2025 10:05:09.3581 674 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-04-02 10:05:08','V',5232241807552870,2025,'2025-04-02 10:05:07','457473376500327005012999',2,2,2,'O','',0,'2025-04-02 10:05:08',1,'','',0) 02/04/2025 10:07:10.8298 597 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 10:09:40.2533 539 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 10:09:39' where traUID = 5555130057962750 and traStatus='V' and traEnabled=1 02/04/2025 10:14:30.6096 579 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-04-02 10:14:29',0,'V',5376764201981680,4762580448108470,2025,'2025-04-02 10:14:29',18,1,0,4,'2025-04-02 10:29:29','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 02/04/2025 10:18:06.3946 1507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:20:07.4908 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:22:37.1149 579 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 10:22:36' where payTraUID = 5652855298802020 and payStatus='V' and payEnabled=1 02/04/2025 10:30:18.3662 3684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:33:36.7487 1702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:36:57.4429 1021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:38:25.1646 1737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:45:39.4900 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 10:50:43.5444 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 10:51:57.3428 2406 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:52:54.3540 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:54:56.5898 1235 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-04-02 10:54:55','V',5425206024991540,2025,'2025-04-02 10:54:54','457473858100327001012999',2,2,2,'O','',0,'2025-04-02 10:54:55',1,'','0230003943530',44,0) 02/04/2025 10:54:57.9668 984 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 10:54:56' where payTraUID = 5153697134751540 and payStatus='V' and payEnabled=1 02/04/2025 10:54:58.7523 785 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 10:54:56' where traUID = 5153697134751540 and traStatus='V' and traEnabled=1 02/04/2025 10:54:58.9754 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:58:02.3502 1872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 10:58:49.1225 2328 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 02/04/2025 10:58:54.7673 627 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 02/04/2025 11:04:02.2532 604 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13300, trcLastPrinted = '2500713300', trcLastDate = '2025-04-02 11:04:01' where trcStatus='V' and trcTerId = 18 02/04/2025 11:04:13.9720 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 11:04:42.4050 808 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 11:05:06.1810 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:05:28.1226 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:08:15.7508 1404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:09:57.1307 602 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 02/04/2025 11:09:58.1583 1027 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 11:10:15.3919 1234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:10:21.3148 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:15:31.2353 562 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-04-02 11:15:30','V',5461618442357740,2025,'2025-04-02 11:15:29','457473763700327005012999',2,2,2,'O','',0,'2025-04-02 11:15:30',1,'','',0) 02/04/2025 11:16:09.9082 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:17:32.3323 1609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 11:17:50.6836 508 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13303, trcLastPrinted = '2500713303', trcLastDate = '2025-04-02 11:17:50' where trcStatus='V' and trcTerId = 18 02/04/2025 11:17:51.2200 522 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4768559043442870,5638452232231960,2025,'2025-04-02 11:17:50',' Date: 4/2/2025 11:17:49 AM Code: 457473934300327005012999 Entry Date: 4/2/2025 10:55:43 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500713303 ',0) 02/04/2025 11:18:34.5560 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 11:20:16.6183 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:24:20.6727 1168 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 11:24:21.6233 710 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 11:24:20' where traUID = 5646099426473690 and traStatus='V' and traEnabled=1 02/04/2025 11:24:38.5947 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:24:38.6277 1603 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 11:24:37',0,1,'2025-04-02 11:24:37','','Unauthorized Transit Entry 1') 02/04/2025 11:24:43.2698 2069 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:29:47.1622 718 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-04-02 11:29:46','V',5298564332277750,2025,'2025-04-02 11:29:45','457473903500327005012999',2,2,2,'O','',0,'2025-04-02 11:29:46',1,'','',0) 02/04/2025 11:33:09.1674 591 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 02/04/2025 11:34:23.3481 830 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,0,50,-2,-100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,0,50,2,100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,0,100,-48,-4800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,0,100,48,4800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,0,200,-5,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,0,200,5,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,0,500,-5,-2500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,0,500,5,2500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:34:04',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 02/04/2025 11:34:24.8691 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 11:34:25.8798 665 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 11:34:25' where traUID = 4687993391405170 and traStatus='V' and traEnabled=1 02/04/2025 11:36:10.8781 547 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-04-02 11:36:10',0,'V',5525599165997420,4872761454036430,2025,'2025-04-02 11:36:10',18,1,0,4,'2025-04-02 11:51:10','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 02/04/2025 11:43:33.9607 720 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 02/04/2025 11:44:33.3825 1059 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 11:44:23',5,3,42101,0,50,11,550,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+11,5),curAmount=round(curAmount+550,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-04-02 11:44:23',5,3,42101,0,100,15,1500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+15,5),curAmount=round(curAmount+1500,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; 02/04/2025 11:45:41.9684 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:47:00.7102 2675 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 11:47:05.2822 530 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 02/04/2025 11:47:49.3017 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 11:48:02.1613 568 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-04-02 11:48:01','V',4765924101247700,2025,'2025-04-02 11:48:00','457474055100327005012999',2,2,2,'O','',0,'2025-04-02 11:48:01',1,'','',0) 02/04/2025 11:48:48.7615 1424 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 11:48:47',4,1,'2025-04-02 11:48:47','457473697900327005012999','Payed (Credit Card ) Ticket ') 02/04/2025 11:48:49.4130 581 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 422944 else acvFstPayId end),acvLstPayId = 422944 where acvSftId = 952 and acvCodeId = 3 02/04/2025 11:49:28.9384 847 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 11:50:16.8465 1108 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:52:44.1260 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:53:14.0981 1635 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 02/04/2025 11:54:52.2998 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:55:53.1876 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:55:57.0852 2794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:56:55.2411 1271 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 11:58:24.7186 697 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 11:58:27.7466 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:00:08.0227 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:02:55.6479 790 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-04-02 12:02:54','V',4886881572716290,2025,'2025-04-02 12:02:54','457473858400327005012999',2,2,2,'O','',0,'2025-04-02 12:02:54',1,'','',0) 02/04/2025 12:03:30.0859 659 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-04-02 12:03:29','V',4697666012621040,2025,'2025-04-02 12:03:28','457474106600327001012999',2,2,2,'O','',0,'2025-04-02 12:03:29',1,'','',0) 02/04/2025 12:04:21.0100 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:10:50.9981 1459 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 12:10:57.1783 665 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 12:11:09.6936 995 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-04-02 12:11:08','V',5364267164154720,2025,'2025-04-02 12:11:08','457474121000327005012999',2,2,2,'O','',0,'2025-04-02 12:11:08',1,'','',0) 02/04/2025 12:12:02.8202 726 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 12:12:42.6088 1297 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 12:13:27.6340 703 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 02/04/2025 12:14:45.2039 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:17:53.6020 920 ms. EXEC: update payReceipt set recCreation = '2025-04-02 12:17:52',recModify = '2025-04-02 12:17:52',recUseId=0,recStatus='V' where recId = 366708 02/04/2025 12:19:40.8288 830 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 02/04/2025 12:20:28.5067 1202 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 12:20:27' where traUID = 5424528200308890 and traStatus='V' and traEnabled=1 02/04/2025 12:26:10.8708 673 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 12:26:12.4449 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:26:56.9277 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:28:23.8949 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:31:08.0762 657 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 12:32:21.4213 1144 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:32:28.4400 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:32:47.3717 3204 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 12:32:43',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'; 02/04/2025 12:32:57.1592 651 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-04-02 12:32:51',1,'V',4992863378972840,4810752332213540,2025,'2025-04-02 12:32:51',4,1,0,4,'2025-04-02 12:47:51','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 02/04/2025 12:35:49.3724 508 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-04-02 12:35:48','V',5495532435593660,2025,'2025-04-02 12:35:47','457474235400327001012999',2,2,2,'O','',0,'2025-04-02 12:35:48',1,'','',0) 02/04/2025 12:35:57.0366 1278 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:37:27.7042 1409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:37:31.4678 1048 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:38:00.5842 801 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-02 12:37:59','0230003943530',0,0,4967424801248440,44,'0000-00-00 00:00:00','0000-00-00 00:00:00') 02/04/2025 12:38:02.9558 1711 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 12:38:21.4602 1347 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 12:38:38.7698 1831 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 02/04/2025 12:40:09.9248 1047 ms. OPEN: SELECT * FROM tabTerminalExtraMem WHERE extStatus=@extStatus AND extTerId = @extTerId 02/04/2025 12:40:21.2074 522 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 12:40:20',0,16,'2025-04-02 12:40:20','','Unauthorized Transit Entry 2') 02/04/2025 12:40:26.7991 911 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 02/04/2025 12:40:45.5136 802 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 97 ms.) 02/04/2025 12:41:48.2536 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:42:48.4689 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:42:54.3448 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:42:54.8532 2191 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-04-02 12:42:47',1,'V',5551437965112340,5504847606630600,2025,'2025-04-02 12:42:47',4,1,0,4,'2025-04-02 12:57:47','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 02/04/2025 12:42:56.6564 722 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5504847606630600,5551437965112340,2025,'2025-04-02 12:42:55',' Date: 4/2/2025 12:42:47 PM Code: 457474160800327005012999 Entry Date: 4/2/2025 11:33:28 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500404046 ',0) 02/04/2025 12:42:57.3308 672 ms. EXEC: update payReceipt set recCreation = '2025-04-02 12:42:56',recModify = '2025-04-02 12:42:56',recUseId=0,recStatus='V' where recId = 366721 02/04/2025 12:43:47.8937 523 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 12:47:23.6270 801 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 02/04/2025 12:53:15.7933 1073 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:53:40.3727 512 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 12:54:27.2851 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:54:27.4762 821 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 12:54:32.5026 581 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-04-02 12:54:31','V',5588249551537900,2025,'2025-04-02 12:54:30','457474455400327001012999',2,2,2,'O','',0,'2025-04-02 12:54:31',1,'','',0) 02/04/2025 12:56:22.0118 568 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 02/04/2025 12:56:46.3291 946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 12:57:55.2414 532 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 02/04/2025 12:58:25.6217 1389 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 02/04/2025 13:05:53.6875 520 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 13:05:53' where traUID = 4870964965465510 and traStatus='V' and traEnabled=1 02/04/2025 13:06:45.8484 1454 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 13:06:49.4188 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:07:23.6487 593 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-04-02 13:07:23','V',4871893175729950,2025,'2025-04-02 13:07:22','457474724200327005012999',1,2,16,'I','',1,0,1,'','0230004100967',12,0) 02/04/2025 13:07:54.1041 1812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:08:07.9444 2175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:10:54.4057 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:12:27.5160 2321 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:13:50.7827 965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:15:39.3174 991 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-04-02 13:15:38','V',5438201310602350,2025,'2025-04-02 13:15:37','457474773700327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 13:16:25.2431 563 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 13:16:26.3038 1055 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 13:16:25' where payTraUID = 5329844243665040 and payStatus='V' and payEnabled=1 02/04/2025 13:16:38.8612 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:17:21.6448 3279 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 13:17:18',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'; 02/04/2025 13:17:28.3763 924 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-04-02 13:17:27',0,'V',4900682882021300,5115873339117360,2025,'2025-04-02 13:17:27',2,1,0,-1,'2025-04-02 14:17:27','S','KES',0,0,0,'','','',3,0,0) 02/04/2025 13:17:52.9178 1423 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:20:48.5695 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:20:58.8303 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:22:04.3302 3190 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); 02/04/2025 13:22:23.8232 769 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5556581519586460,5297041776818480,2025,'2025-04-02 13:22:23','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/2/2025 12:42:37 PM Date : 4/2/2025 1:22:21 PM Code : 457474575700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 02/04/2025 13:22:24.9940 1169 ms. EXEC: update payReceipt set recCreation = '2025-04-02 13:22:23',recModify = '2025-04-02 13:22:23',recUseId=0,recStatus='V' where recId = 366737 02/04/2025 13:23:30.8831 1353 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 13:23:29' where traUID = 4692662071866230 and traStatus='V' and traEnabled=1 02/04/2025 13:23:35.0569 619 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 13:24:07.9689 3185 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-04-02 13:24:04','V',4848896084538180,2025,'2025-04-02 13:24:04','457474824400327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 13:24:22.1054 800 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 13:24:46.2555 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:24:57.4771 834 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 13:26:12.0630 2187 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 13:26:51.7916 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 13:27:20.8230 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:27:44.6549 696 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 02/04/2025 13:27:45.7277 1969 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 13:27:58.0209 1916 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 02/04/2025 13:30:17.0390 508 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 02/04/2025 13:31:53.1801 746 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 13:31:55.0583 1631 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 13:31:53' where payTraUID = 5195423171714970 and payStatus='V' and payEnabled=1 02/04/2025 13:31:55.6847 625 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 13:31:53' where traUID = 5195423171714970 and traStatus='V' and traEnabled=1 02/04/2025 13:33:04.9381 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:34:59.6709 754 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 13:34:59.7089 1293 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-02 13:34:58',0,0,'V',5426225280150370,5298339486906150,2025,'2025-04-02 13:34:58',3,'KES',1,50,50,'N',''); 02/04/2025 13:38:33.1307 1054 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:39:50.2613 1505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:42:10.5052 949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:43:05.6000 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:43:41.9063 742 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 13:48:02.0186 1382 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:48:29.6731 1880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:48:36.4096 1988 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 13:48:36.5107 1406 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:50:25.8929 607 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-04-02 13:50:19',1,'V',5254185472782260,5521556122720650,2025,'2025-04-02 13:50:19',4,1,0,4,'2025-04-02 14:05:19','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 02/04/2025 13:54:24.1394 1377 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 13:54:22' where payTraUID = 4848896084538180 and payStatus='V' and payEnabled=1 02/04/2025 13:54:24.6547 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 13:54:22' where traUID = 4848896084538180 and traStatus='V' and traEnabled=1 02/04/2025 13:54:42.3045 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 13:55:16.7396 1589 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 13:55:15' where payTraUID = 5734225499778930 and payStatus='V' and payEnabled=1 02/04/2025 13:55:17.2739 534 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 13:55:15' where traUID = 5734225499778930 and traStatus='V' and traEnabled=1 02/04/2025 14:00:21.4014 909 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 02/04/2025 14:00:43.9615 871 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 14:00:43',0,16,'2025-04-02 14:00:43','','Unauthorized Transit Entry 2') 02/04/2025 14:01:43.2792 531 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentToConfirm' 02/04/2025 14:02:30.1646 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 14:03:53.9396 723 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 14:04:39.8454 1343 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4058, trcLastPrinted = '2500404058', trcLastDate = '2025-04-02 14:04:38' where trcStatus='V' and trcTerId = 4 02/04/2025 14:04:39.8454 1310 ms. EXEC: update payReceipt set recCreation = '2025-04-02 14:04:38',recModify = '2025-04-02 14:04:38',recUseId=0,recStatus='V' where recId = 366762 02/04/2025 14:04:52.4228 1584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 14:05:29.5236 501 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 14:05:28',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-04-02 14:05:28',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'; 02/04/2025 14:05:35.5276 970 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 02/04/2025 14:06:12.3683 1153 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 02/04/2025 14:07:12.3354 1631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 14:08:39.8499 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 14:14:08.5799 1444 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-04-02 14:14:07','V',5305249062292470,2025,'2025-04-02 14:14:07','457475124700327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 14:14:16.8835 618 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 02/04/2025 14:17:01.8021 747 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 14:17:01.8432 709 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 02/04/2025 14:17:19.4049 633 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 02/04/2025 14:17:32.3656 1373 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 14:17:39.6305 1008 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 02/04/2025 14:19:56.7932 558 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '457475159400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 02/04/2025 14:19:56.9583 612 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-04-02 14:19:56','V',5437430904770170,2025,'2025-04-02 14:19:55','457474755000327005012999',2,2,2,'O','',0,'2025-04-02 14:19:56',1,'','',0) 02/04/2025 14:19:58.0861 784 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 14:21:09.5439 645 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 02/04/2025 14:28:16.6477 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 14:28:56.0241 2123 ms. EXEC: update paycash set casCreation = '2025-04-02 14:28:53',casModify = '2025-04-02 14:28:53',casUseId=0,casStatus='V' where casId = 216101 02/04/2025 14:28:56.0251 1585 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 02/04/2025 14:28:56.9587 934 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-02 14:28:53',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 02/04/2025 14:30:04.6170 675 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 14:30:03',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'; 02/04/2025 14:31:28.3460 793 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 02/04/2025 14:31:31.9945 1124 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-04-02 14:31:30','V',5253084390929570,2025,'2025-04-02 14:31:29','457474728700327005012999',2,2,2,'O','',0,'2025-04-02 14:31:30',1,'','',0) 02/04/2025 14:31:31.9945 1693 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 14:31:33.4014 1354 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 14:31:33.4424 1236 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 02/04/2025 14:32:20.2968 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 14:32:52.3342 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 14:33:16.1492 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 14:33:16.8586 653 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-02 14:33:16','V',5508704774327160,2025,'2025-04-02 14:33:15','457474522700327005012999',2,2,2,'O','',0,'2025-04-02 14:33:16',1,'','',0) 02/04/2025 14:34:28.8128 688 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 14:34:47.9486 1231 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-04-02 14:34:46','V',5670466381254140,2025,'2025-04-02 14:34:46','457475248600327001012999',1,2,1,'I','',1,0,1,'','',4) 02/04/2025 14:37:09.0370 736 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-04-02 14:37:08','V',5398802972161360,2025,'2025-04-02 14:37:07','457475005100327005012999',2,2,2,'O','',0,'2025-04-02 14:37:08',1,'','',0) 02/04/2025 14:37:53.8680 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 14:38:31.2981 656 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 14:50:02.5197 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 14:54:44.2999 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 15:02:37.7822 832 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 15:02:36' where payTraUID = 5044185931074000 and payStatus='V' and payEnabled=1 02/04/2025 15:10:34.9232 602 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 02/04/2025 15:10:41.2494 1466 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-04-02 15:10:39','V',5529512607578370,2025,'2025-04-02 15:10:39','457474976800327005012999',2,2,2,'O','',0,'2025-04-02 15:10:39',1,'','',0) 02/04/2025 15:16:58.1041 1046 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5734678586825190,5621398382559720,2025,'2025-04-02 15:16:57',' Date: 4/2/2025 3:16:56 PM Code: 457475073300327005012999 Entry Date: 4/2/2025 2:05:33 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 # 2500713357 ',0) 02/04/2025 15:17:33.8941 682 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 15:17:33',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 15:17:33',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'; 02/04/2025 15:20:30.5123 1031 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside - 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 02/04/2025 15:21:33.5144 1051 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13360, trcLastPrinted = '2500713360', trcLastDate = '2025-04-02 15:21:32' where trcStatus='V' and trcTerId = 18 02/04/2025 15:22:21.1483 838 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 15:22:20',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'; 02/04/2025 15:30:06.3539 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 15:30:38.8196 1388 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 15:36:36.6210 648 ms. OPEN: select * from tabTerminal where terId = 2 02/04/2025 15:39:51.2273 690 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-04-02 15:39:50','V',4760987192883030,2025,'2025-04-02 15:39:49','457475638900327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 15:43:25.8041 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 15:46:51.9471 511 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-04-02 15:46:51','V',4893750849714500,2025,'2025-04-02 15:46:50','457475681000327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 15:49:49.9392 2215 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-04-02 15:49:47','V',5407976554954890,2025,'2025-04-02 15:49:47','457475556900327005012999',2,2,2,'O','',0,'2025-04-02 15:49:47',1,'','',0) 02/04/2025 15:50:02.2524 3570 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 34 ms.) 02/04/2025 15:50:53.7389 620 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 15:51:31.2920 543 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13366, trcLastPrinted = '2500713366', trcLastDate = '2025-04-02 15:51:30' where trcStatus='V' and trcTerId = 18 02/04/2025 15:51:34.4231 681 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-04-02 15:51:33','V',5366653626103810,2025,'2025-04-02 15:51:33','457475709300327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 15:51:41.2657 1285 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 02/04/2025 15:52:06.7638 1303 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 15:52:05',0,16,'2025-04-02 15:52:05','','Unauthorized Transit Entry 2') 02/04/2025 15:52:25.3232 1028 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 02/04/2025 15:52:57.1785 556 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 02/04/2025 15:55:19.6775 1130 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 15:55:34.3574 518 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 15:57:54.9084 875 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13368, trcLastPrinted = '2500713368', trcLastDate = '2025-04-02 15:57:54' where trcStatus='V' and trcTerId = 18 02/04/2025 15:57:54.9334 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:00:13.7453 1291 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 16:00:15.9698 1225 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 16:02:01.9710 593 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-04-02 16:02:01','V',5166877684206950,2025,'2025-04-02 16:02:01','457475772100327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 16:03:28.5019 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:04:01.0417 1019 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 16:04:00' where payTraUID = 5526727049310510 and payStatus='V' and payEnabled=1 02/04/2025 16:04:02.5617 1519 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 16:04:00' where traUID = 5526727049310510 and traStatus='V' and traEnabled=1 02/04/2025 16:04:06.4483 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 16:07:01.6585 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:07:04.1852 726 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-04-02 16:07:03','V',4688635264434010,2025,'2025-04-02 16:07:03','457475802300327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 16:07:06.9461 662 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 16:07:27.7970 1949 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 16:07:40.1653 751 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 16:07:48.9992 1712 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 02/04/2025 16:07:58.2064 1555 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 02/04/2025 16:09:52.8171 564 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 16:10:44.1324 2786 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-04-02 16:10:36',1,'V',5603592538203120,4615015816453110,2025,'2025-04-02 16:10:36',4,1,0,4,'2025-04-02 16:25:36','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 02/04/2025 16:10:45.0811 768 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 423095 else acvFstPayId end),acvLstPayId = 423095 where acvSftId = 952 and acvCodeId = 3 02/04/2025 16:10:46.6391 1049 ms. EXEC: update payReceipt set recCreation = '2025-04-02 16:10:45',recModify = '2025-04-02 16:10:45',recUseId=0,recStatus='V' where recId = 366828 02/04/2025 16:12:37.5346 2707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:15:54.3433 2655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:16:36.2574 806 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 16:16:35' where payTraUID = 4771044291142680 and payStatus='V' and payEnabled=1 02/04/2025 16:16:37.4862 1121 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 16:16:35' where traUID = 4771044291142680 and traStatus='V' and traEnabled=1 02/04/2025 16:23:45.9279 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:23:50.0006 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:28:05.9729 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:31:25.6422 538 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-04-02 16:31:25','V',5696823297340610,2025,'2025-04-02 16:31:24','457475312600327005012999',2,2,2,'O','',0,'2025-04-02 16:31:25',1,'','',0) 02/04/2025 16:31:42.2002 547 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 16:31:41' where payTraUID = 5046745067763460 and payStatus='V' and payEnabled=1 02/04/2025 16:31:50.7640 1801 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 02/04/2025 16:32:06.5135 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-04-02 16:32:05','V',5227927957120220,2025,'2025-04-02 16:32:04','457474861600327005012999',2,2,2,'O','',0,'2025-04-02 16:32:05',1,'','',0) 02/04/2025 16:33:46.1662 1148 ms. EXEC: update payReceipt set recCreation = '2025-04-02 16:33:45',recModify = '2025-04-02 16:33:45',recUseId=0,recStatus='V' where recId = 366840 02/04/2025 16:33:49.8347 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:38:18.7816 647 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 02/04/2025 16:41:38.5795 969 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-04-02 16:41:37','V',5012720660140160,2025,'2025-04-02 16:41:37','457475940300327005012999',2,2,2,'O','',0,'2025-04-02 16:41:37',1,'','',0) 02/04/2025 16:41:39.4331 659 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 16:41:38' where payTraUID = 5504019255842020 and payStatus='V' and payEnabled=1 02/04/2025 16:41:39.9664 532 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 16:41:38' where traUID = 5504019255842020 and traStatus='V' and traEnabled=1 02/04/2025 16:41:43.0125 1288 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); 02/04/2025 16:46:49.0953 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:47:29.5884 860 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 02/04/2025 16:49:53.2625 2469 ms. EXEC: update payInventory set invCreation = '2025-04-02 16:49:50',invModify = '2025-04-02 16:49:50',invUseId=0,invStatus='V' where invId = 244689 02/04/2025 16:50:13.2429 1435 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:50:58.3331 975 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 02/04/2025 16:52:32.9085 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:53:15.4770 2332 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:53:31.2566 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:54:15.4541 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 16:55:35.1745 1285 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 02/04/2025 16:55:43.5461 1427 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-04-02 16:55:41',0,'V',5253653758479510,5507476385579770,2025,'2025-04-02 16:55:41',3,1,0,4,'2025-04-02 17:10:41','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 02/04/2025 16:56:29.0665 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:00:10.9600 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:01:21.3831 943 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 02/04/2025 17:02:38.4177 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:04:45.9220 531 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 17:04:45' where payTraUID = 4908681476744390 and payStatus='V' and payEnabled=1 02/04/2025 17:06:17.8755 1444 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:06:48.1918 751 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-02 17:06:47' where traUID = 5085801690716640 and traStatus='V' and traEnabled=1 02/04/2025 17:06:58.0834 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:07:22.4297 850 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 02/04/2025 17:07:56.3284 1079 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 02/04/2025 17:11:55.7155 4246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:16:39.9749 1420 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-04-02 17:16:38' where subId = 32 02/04/2025 17:16:41.9752 1094 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-04-02 17:16:40',0,'V',5529897587130880,4966602910288580,2025,'2025-04-02 17:16:40',2,1,0,-1,'2025-04-02 18:16:40','S','KES',0,0,0,'','','',3,0,0) 02/04/2025 17:16:43.2661 1259 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-04-02 17:16:42','V',5174991217000430,2025,'2025-04-02 17:16:36','457475247900327005012999',2,2,2,'O','',0,'2025-04-02 17:16:42',1,'','0230003943861',31,0) 02/04/2025 17:24:05.1672 1212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:26:32.3877 793 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 02/04/2025 17:27:39.8499 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,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-02 17:27:37',0,'V',5061594734614460,5289006481035740,2025,'2025-04-02 17:27:37',3,1,0,4,'2025-04-02 17:42:37','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 02/04/2025 17:31:31.4463 1536 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 17:32:02.5611 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:32:40.0372 1364 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 17:33:38.0230 1573 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 17:35:06.3281 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:36:05.7078 537 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5135018887452300,4819745642219090,2025,'2025-04-02 17:36:05',' Date: 4/2/2025 5:36:04 PM Code: 457476096100327005012999 Entry Date: 4/2/2025 4:56:01 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 # 2500713388 ',0) 02/04/2025 17:43:04.8906 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 17:43:15.8479 1067 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-04-02 17:43:14',0,'V',4886653954095310,5082350224480200,2025,'2025-04-02 17:43:14',18,1,0,4,'2025-04-02 17:58:14','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 02/04/2025 17:43:40.1832 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:45:08.6043 1859 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13390, trcLastPrinted = '2500713390', trcLastDate = '2025-04-02 17:45:06' where trcStatus='V' and trcTerId = 18 02/04/2025 17:46:34.8361 1366 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 17:46:33',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'; 02/04/2025 17:46:36.0239 1053 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-02 17:46:34',0,0,'V',4956182799115170,5591220466349220,2025,'2025-04-02 17:46:34',3,'KES',-1,50,-50,'N',''); 02/04/2025 17:50:12.2396 2030 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-02 17:50:10' where payTraUID = 5248975037663990 and payStatus='V' and payEnabled=1 02/04/2025 17:50:47.5952 558 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 17:50:47.9424 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 17:53:19.2717 1409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:54:35.0614 1328 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 02/04/2025 17:55:29.4268 1626 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-04-02 17:55:27',0,'V',5170847548861160,5441078271597510,2025,'2025-04-02 17:55:27',18,1,0,4,'2025-04-02 18:10:27','C','KES',300,300,0,'','','',1,300,0,0,'',0,0) (WAIT TIME 48 ms.) 02/04/2025 17:55:50.9282 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 17:57:22.4625 1095 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 02/04/2025 18:01:09.5224 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:03:19.9406 765 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-04-02 18:03:19','V',4710967076992470,2025,'2025-04-02 18:03:18','457476499800327005012999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 18:03:20.6661 720 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 18:03:32.5601 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:04:21.8171 3590 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 02/04/2025 18:04:31.5866 604 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-04-02 18:04:30','V',4883825676027190,2025,'2025-04-02 18:04:30','457476434100327005012999',2,2,2,'O','',0,'2025-04-02 18:04:30',1,'','',0) 02/04/2025 18:06:38.6406 940 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-02 18:06:37',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'; 02/04/2025 18:10:34.2811 904 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 18:12:58.3491 3577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 32 ms.) 02/04/2025 18:17:26.6716 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:20:59.3619 694 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 02/04/2025 18:23:08.7975 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:24:37.6180 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 18:32:59.2567 907 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-04-02 18:32:58','V',5398438676117630,2025,'2025-04-02 18:32:46','457476676600327001012999',1,2,1,'I','',1,0,1,'','',4) 02/04/2025 18:33:11.7451 844 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-04-02 18:33:10','V',4779434787407480,2025,'2025-04-02 18:32:59','457476677900327001031999',1,2,1,'I','',1,0,1,'','',4) 02/04/2025 18:33:13.9305 619 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-02 18:33:13',0,0,'V',5381313569599950,5743586323210950,2025,'2025-04-02 18:33:13',3,'KES',1,100,100,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-02 18:33:13',0,0,'V',5381313569599950,5743586323210950,2025,'2025-04-02 18:33:13',3,'KES',1,200,200,'N',''); 02/04/2025 18:34:21.6178 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:36:55.0056 1454 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:41:37.4265 1281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:47:24.4137 2113 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:55:40.8468 643 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-04-02 18:55:40',0,'V',5168564753338980,4888696566364980,2025,'2025-04-02 18:55:40',18,1,0,4,'2025-04-02 19:10:40','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 02/04/2025 18:55:41.9146 835 ms. EXEC: update payReceipt set recCreation = '2025-04-02 18:55:41',recModify = '2025-04-02 18:55:41',recUseId=0,recStatus='V' where recId = 366885 02/04/2025 18:56:43.7619 1802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:58:16.3739 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:59:30.2493 6960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 18:59:41.4298 2901 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 547 ms.) 02/04/2025 18:59:41.4769 1122 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 589 ms.) 02/04/2025 19:00:04.3722 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 19:03:10.8720 629 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 02/04/2025 19:07:28.0744 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 19:18:28.0944 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 19:19:28.2447 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 19:23:33.1832 1537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 19:27:01.9078 1789 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 19:28:56.3324 1639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 19:28:59.0182 927 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 02/04/2025 19:33:08.5730 684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 19:37:17.5323 708 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 19:37:16',0,16,'2025-04-02 19:37:16','','Unauthorized Transit Entry 2') 02/04/2025 19:39:58.8022 1318 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 19:56:13.7187 2129 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 20:09:05.5442 2260 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 02/04/2025 20:12:51.1502 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 20:16:24.0756 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 20:29:08.7904 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 20:31:01.7840 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 20:38:15.9116 30211 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 02/04/2025 20:38:16.0046 30261 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 (WAIT TIME 42 ms.) 02/04/2025 20:38:17.4406 870 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 02/04/2025 20:38:17.4416 869 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 02/04/2025 20:38:17.4416 865 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 02/04/2025 20:38:17.4426 619 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 02/04/2025 20:38:17.4436 866 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 02/04/2025 20:38:17.4436 865 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 20:38:17.4486 627 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 20:38:17.4486 871 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 20:38:17.4496 872 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 02/04/2025 20:38:17.4496 878 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 02/04/2025 20:38:17.4506 878 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 20:38:17.4516 875 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 02/04/2025 20:38:17.4546 882 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 02/04/2025 20:38:17.4546 879 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 02/04/2025 20:38:17.4556 633 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 02/04/2025 20:38:17.4616 882 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 02/04/2025 20:38:17.4616 881 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 5 ms.) 02/04/2025 20:38:17.4626 884 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 5 ms.) 02/04/2025 20:38:17.4626 887 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 5 ms.) 02/04/2025 20:38:17.4636 886 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 5 ms.) 02/04/2025 20:38:17.4646 888 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 4 ms.) 02/04/2025 20:38:17.8721 945 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 349 ms.) 02/04/2025 20:38:25.2986 6339 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0347899437191' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 02/04/2025 20:38:25.2996 5043 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457477422500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 (WAIT TIME 1 ms.) 02/04/2025 20:38:25.3016 7792 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '897727' and traDirection='I' order by traId DESC LIMIT 1 02/04/2025 20:38:25.8930 7478 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 02/04/2025 20:38:27.6772 803 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 02/04/2025 20:38:29.5785 804 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 02/04/2025 20:38:30.0439 3003 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '1882553234567' and traDirection='I' order by traId desc limit 1 02/04/2025 20:38:30.5863 2393 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-04-02 20:38:28','V',5425461899234720,2025,'2025-04-02 20:37:05','457477422500327005031999',1,2,16,'I','',1,0,1,'','',4) 02/04/2025 20:38:32.3345 1587 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 20:38:32.4056 1796 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/04/2025 20:38:34.0989 7728 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/04/2025 20:38:34.5242 4829 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '457477013800327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 02/04/2025 20:38:36.9689 2870 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); 02/04/2025 20:57:26.7553 502 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5183510201414740,4855587132517850,2025,'2025-04-02 20:57:26','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/2/2025 8:41:52 PM Date : 4/2/2025 8:57:24 PM Code : 457477451200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 02/04/2025 21:21:58.9548 2317 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 02/04/2025 22:40:34.9705 550 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 190 order by traDateTime desc,traId desc 02/04/2025 23:36:18.5037 822 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-02 23:36:17',0,2,'2025-04-02 23:36:17','','Unauthorized Transit Exit 1') 02/04/2025 23:52:18.9382 884 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 02/04/2025 23:53:48.5021 1830 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-04-02 23:53:46','V',4834532753335170,2025,'2025-04-02 23:53:45','457478376300327005012999',2,2,2,'O','',0,'2025-04-02 23:53:46',1,'','',0)