03/04/2025 00:12:11.0545 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 00:21:41.6936 1336 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 00:22:38.3605 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 00:40:24.2686 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 00:41:30.9613 802 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 03/04/2025 00:43:47.1415 1927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 00:48:12.2111 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:03:08.1730 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:06:20.3319 3232 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:06:23.0047 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:06:26.4390 2726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:06:31.9536 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:06:33.8639 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:06:41.4550 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:06:43.8836 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:06:51.7799 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:07:16.9006 2064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:07:24.0143 1231 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:14:56.7809 554 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-03 01:14:56','V',5303264974773930,2025,'2025-04-03 01:14:54','457480238300327005012999',2,2,2,'O','',0,'2025-04-03 01:14:56',1,'','',0) 03/04/2025 01:14:57.5365 538 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 01:14:56' where traUID = 5713503533946300 and traStatus='V' and traEnabled=1 03/04/2025 01:22:49.7188 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:26:38.5622 1760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:27:22.3122 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:27:56.4359 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:32:35.2182 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:38:17.0280 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:54:16.6273 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 01:56:26.7606 1041 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 02:07:01.5904 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 02:20:04.4577 1417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 02:23:00.5166 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 02:28:10.9576 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 02:56:46.1583 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 02:59:08.0665 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 02:59:29.9592 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:07:11.1033 2060 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:07:24.3822 1963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:22:49.6394 574 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/04/2025 03:33:24.7376 1011 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5007159171658960,5685386673774170,2025,'2025-04-03 03:33:23',' Date: 4/3/2025 3:33:23 AM Code: 457481118300327005012999 Entry Date: 4/3/2025 3:06:23 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500713432 ',0) 03/04/2025 03:33:25.9204 1181 ms. EXEC: update payReceipt set recCreation = '2025-04-03 03:33:24',recModify = '2025-04-03 03:33:24',recUseId=0,recStatus='V' where recId = 366929 03/04/2025 03:33:34.5222 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:33:43.8715 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:41:15.5740 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:44:37.0890 567 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 03:44:35',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'; 03/04/2025 03:48:27.8521 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:52:46.0241 1539 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-03 03:52:44','V',4947512597880080,2025,'2025-04-03 03:52:43','457481396300327005012999',1,2,16,'I','',1,0,1,'','',4) 03/04/2025 03:52:49.9147 3091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:52:57.2166 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 03:56:37.8966 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 04:07:53.9688 3937 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 04:41:35.1064 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 05:07:46.5573 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 05:09:59.4178 857 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-03 05:09:58','V',5008118742756200,2025,'2025-04-03 05:09:56','457481396300327005012999',2,2,2,'O','',0,'2025-04-03 05:09:58',1,'','',0) 03/04/2025 05:51:16.1522 1424 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5396083267532570,5488258072330850,2025,'2025-04-03 05:51:14',' Date: 4/3/2025 5:51:10 AM Code: 457482050600327005012999 Entry Date: 4/3/2025 5:41:46 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 # 2500404083 ',0) 03/04/2025 05:53:46.1469 680 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/04/2025 05:57:47.0276 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:03:45.5313 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:10:40.4330 510 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/04/2025 06:10:50.8510 764 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 06:10:51.0651 508 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/04/2025 06:10:51.0661 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:14:05.5626 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:18:18.5693 546 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 03/04/2025 06:18:41.2045 2190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:20:19.5895 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:24:27.2596 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:27:47.2947 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:30:05.1001 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:39:43.2530 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:42:33.7143 1031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:43:37.7613 551 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-03 06:43:37','V',5366555423478620,2025,'2025-04-03 06:43:36','457482301400327005012999',2,2,2,'O','',0,'2025-04-03 06:43:37',1,'','',0) 03/04/2025 06:43:38.6039 598 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-03 06:43:38' where payTraUID = 5571910261293680 and payStatus='V' and payEnabled=1 03/04/2025 06:43:42.3654 1122 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/04/2025 06:44:45.0664 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 06:54:12.0454 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 07:02:57.1422 1124 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 07:06:44.5344 1817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 07:10:42.0519 1090 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 179 order by traDateTime desc,traId desc 03/04/2025 07:12:28.7362 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 07:14:27.7636 4256 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 03/04/2025 07:17:44.7660 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 07:18:54.4916 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 07:19:53.7532 1027 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 07:33:02.8676 1131 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 07:34:19.3313 592 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 07:34:20.8182 859 ms. EXECSCALAR: select traId from movtransit where traUID = 5038551584938000 and traStatus='V' nr: 897846 03/04/2025 07:36:02.7559 1002 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 07:36:15.1061 1104 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-03 07:36:14','V',5194526997295920,2025,'2025-04-03 07:36:13','457482737300327005012999',1,2,16,'I','',1,0,1,'','',4) 03/04/2025 07:36:15.1551 578 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-03 07:36:14','V',5035698559894900,2025,'2025-04-03 07:36:14','457482557700327005012999',2,2,2,'O','',0,'2025-04-03 07:36:14',1,'','',0) 03/04/2025 07:36:18.7405 537 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 03/04/2025 07:36:19.8733 1030 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 07:43:10.4094 3770 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 03/04/2025 07:47:52.9476 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 07:55:38.1860 650 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 03/04/2025 07:57:39.5329 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 08:04:00.7233 562 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',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-03 08:03:49',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-03 08:03:49',5,3,42101,0,100,-32,-3200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',5,3,42101,0,100,32,3200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',5,3,42101,0,200,-10,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',5,3,42101,0,200,10,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:03:49',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 03/04/2025 08:04:08.8787 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:04:51.6473 525 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 08:04:52.6980 608 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 08:04:51' where traUID = 5122610797914900 and traStatus='V' and traEnabled=1 03/04/2025 08:10:29.1997 942 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:10:24',5,3,42101,0,50,16,800,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+16,5),curAmount=round(curAmount+800,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:10:24',5,3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 08:10:24',5,3,42101,0,100,10,1000,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+10,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 03/04/2025 08:18:06.8825 811 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 03/04/2025 08:22:07.5144 581 ms. EXEC: update paycash set casCreation = '2025-04-03 08:22:06',casModify = '2025-04-03 08:22:06',casUseId=0,casStatus='V' where casId = 216180 03/04/2025 08:22:09.2125 1352 ms. EXEC: update payInventory set invCreation = '2025-04-03 08:22:07',invModify = '2025-04-03 08:22:07',invUseId=0,invStatus='V' where invId = 244765 03/04/2025 08:25:38.2402 1018 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:30:20.5421 530 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/04/2025 08:35:47.3896 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:36:05.8530 864 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 03/04/2025 08:36:43.5342 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:38:01.1641 1634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:38:29.1168 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:39:34.2197 512 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 03/04/2025 08:39:34.3678 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:41:34.4121 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:46:54.4312 840 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0810007086215' order by traId desc limit 1 03/04/2025 08:46:56.0183 1223 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/04/2025 08:47:16.8072 1764 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-03 08:47:15',0,16,'2025-04-03 08:47:15','','Unauthorized Transit Entry 2') 03/04/2025 08:48:55.7054 1874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:49:21.9439 851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:50:28.1422 1271 ms. EXECSCALAR: select traId from movtransit where traUID = 4963756218756350 and traStatus='V' nr: 897885 03/04/2025 08:52:13.2215 539 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 08:52:12',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'; 03/04/2025 08:54:54.2652 1083 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 08:56:12.0012 1016 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5650619891864970,4748187340571430,2025,'2025-04-03 08:56:10','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/3/2025 8:46:32 AM Date : 4/3/2025 8:56:08 AM Code : 457483159200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 03/04/2025 08:56:13.8235 991 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 08:56:12',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'; 03/04/2025 08:59:18.9095 536 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 03/04/2025 09:01:31.1360 695 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); 03/04/2025 09:03:32.9268 1249 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 03/04/2025 09:04:26.6096 1008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:05:17.9750 1525 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 156 order by traDateTime desc,traId desc 03/04/2025 09:05:58.2039 1307 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-03 09:05:56',0,16,'2025-04-03 09:05:56','','Unauthorized Transit Entry 2') 03/04/2025 09:13:18.9167 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:13:23.3256 2105 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-03 09:13:19',0,'V',4802038690257890,4905574551589880,2025,'2025-04-03 09:13:19',3,1,0,4,'2025-04-03 09:28:19','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 03/04/2025 09:15:09.6188 1496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:17:20.9926 3386 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 09:17:17' where traUID = 4681521163316050 and traStatus='V' and traEnabled=1 03/04/2025 09:18:30.9434 818 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 142 order by traDateTime desc,traId desc 03/04/2025 09:20:44.9891 1632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:23:01.6365 1748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:23:08.7702 694 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 03/04/2025 09:25:32.1011 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:28:18.8967 3139 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 03/04/2025 09:28:20.5598 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:29:25.5543 640 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/04/2025 09:32:17.9878 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:41:22.7527 805 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 09:41:29.8265 1208 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:41:35.4782 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:44:05.8528 1769 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 92 order by traDateTime desc,traId desc 03/04/2025 09:44:07.1516 968 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-03 09:44:06','V',5505730435983760,2025,'2025-04-03 09:44:02','457483504200327005012999',1,2,16,'I','',1,0,1,'','0750009437080',92,4) 03/04/2025 09:44:20.1323 1603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:45:53.5868 1933 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 09:45:51' where traUID = 4906987800978880 and traStatus='V' and traEnabled=1 03/04/2025 09:47:01.1169 675 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/04/2025 09:47:16.9725 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 09:50:48.6240 2517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:52:31.9060 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 09:52:38.3774 537 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 09:54:23.6196 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 09:57:46.3929 563 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 10:07:32.4218 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:07:36.8097 1533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:10:25.0493 1378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:10:35.8906 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:12:02.1203 1844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:16:26.3972 923 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 41 order by traDateTime desc,traId desc 03/04/2025 10:16:41.8476 1539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:17:13.5148 2784 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 03/04/2025 10:17:19.7590 848 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 10:17:23.3373 2273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:17:25.6039 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:18:14.2885 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:18:20.0483 1123 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:18:22.3679 8176 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 03/04/2025 10:18:23.6717 974 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0230003944064' order by traId desc limit 1 03/04/2025 10:18:32.8049 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:18:37.1718 1306 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:19:47.2697 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:22:41.8987 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:22:57.5671 1368 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:26:17.2489 852 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 10:26:16',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'; 03/04/2025 10:27:36.2098 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:28:07.3876 2274 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 10:28:04',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'; 03/04/2025 10:28:07.9510 561 ms. EXEC: update payInventory set invCreation = '2025-04-03 10:28:07',invModify = '2025-04-03 10:28:07',invUseId=0,invStatus='V' where invId = 244788 03/04/2025 10:34:28.7129 615 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 10:34: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'; 03/04/2025 10:34:29.5014 698 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 03/04/2025 10:36:29.0725 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 10:36:34.0768 896 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-03 10:36:33','V',4995824634048860,2025,'2025-04-03 10:36:32','457483717900327005012999',2,2,2,'O','',0,'2025-04-03 10:36:33',1,'','',0) 03/04/2025 10:36:34.6692 549 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 10:37:57.4857 514 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-03 10:37:56',0,16,'2025-04-03 10:37:56','','Unauthorized Transit Entry 2') 03/04/2025 10:38:02.4570 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 10:41:56.0264 804 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/04/2025 10:46:10.3048 1645 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-03 10:46:08','V',4617329539441580,2025,'2025-04-03 10:46:03','457483817000327001012999',2,2,2,'O','',0,'2025-04-03 10:46:08',1,'','',0) 03/04/2025 10:46:11.8419 700 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 10:46:10' where traUID = 5268760903108750 and traStatus='V' and traEnabled=1 03/04/2025 10:46:22.7802 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 10:46:51.8377 2996 ms. EXEC: update paycash set casCreation = '2025-04-03 10:46:48',casModify = '2025-04-03 10:46:48',casUseId=0,casStatus='V' where casId = 216207 03/04/2025 10:46:51.9037 951 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-03 10:46:50',0,'V',4909383984919910,5457020334157920,2025,'2025-04-03 10:46:50',18,1,0,4,'2025-04-03 11:01:50','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/04/2025 10:47:13.9305 789 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-03 10:47:13','V',5484665543235220,2025,'2025-04-03 10:47:11','457483709500327001012999',2,2,2,'O','',0,'2025-04-03 10:47:13',1,'','',0) 03/04/2025 10:58:53.8145 1259 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 03/04/2025 11:07:16.6182 704 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 03/04/2025 11:14:30.4442 1711 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 03/04/2025 11:17:06.4158 10018 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 03/04/2025 12:39:22.9973 624 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 12:39:22' where traUID = 5324108909894840 and traStatus='V' and traEnabled=1 03/04/2025 16:06:28.2476 548 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/04/2025 16:07:02.4645 510 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/04/2025 16:07:05.3504 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 16:12:17.6587 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 16:13:52.1242 825 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-03 16:13:51','V',5333714766411560,2025,'2025-04-03 16:13:49','457485569800327001012999',2,2,2,'O','',0,'2025-04-03 16:13:51',1,'','',0) 03/04/2025 16:20:12.0539 526 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/04/2025 16:28:00.9850 1155 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 16:30:42.5850 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 16:34:15.6444 737 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 16:34:14',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'; 03/04/2025 16:34:54.1782 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 16:37:51.8770 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 16:48:46.6627 588 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-03 16:48:46','0560008336102',0,0,5392652081779970,185,'0000-00-00 00:00:00','0000-00-00 00:00:00') 03/04/2025 16:48:47.6313 959 ms. OPEN: select * from tmppay where tmpcode = '457482450900327005012999' 03/04/2025 16:53:59.0538 587 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-03 16:53:58','V',5057712225730230,2025,'2025-04-03 16:53:57','457485754800327005012999',2,2,2,'O','',0,'2025-04-03 16:53:58',1,'','',0) 03/04/2025 16:54:51.1427 627 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-03 16:54:50','V',5301482693760180,2025,'2025-04-03 16:54:49','457480000700327003229999',22,22,3,'I','',1,0,1,'','',2) 03/04/2025 16:54:51.1928 693 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-03 16:54:50','V',5740603601718720,2025,'2025-04-03 16:54:48','457486088800327005012999',1,2,16,'I','',1,0,1,'','',4) 03/04/2025 17:00:16.9920 2474 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:00:41.7295 732 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-04-03 17:00:40',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 03/04/2025 17:00:54.5401 2142 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-03 17:00:52',0,2,'2025-04-03 17:00:52','','Unauthorized Transit Exit 1') (WAIT TIME 286 ms.) 03/04/2025 17:03:49.7874 638 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/04/2025 17:05:11.1699 879 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/04/2025 17:06:48.6681 1521 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 17:07:20.1442 1577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:08:04.0536 535 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5343710836100200,5329808454683630,2025,'2025-04-03 17:08:03','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/3/2025 4:59:51 PM Date : 4/3/2025 5:08:02 PM Code : 457486119100327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 03/04/2025 17:08:05.7257 826 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 17:08:04',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 17:08:04',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'; 03/04/2025 17:12:04.8508 1169 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 03/04/2025 17:13:48.8850 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/04/2025 17:16:47.6217 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:23:00.0830 610 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13549, trcLastPrinted = '2500713549', trcLastDate = '2025-04-03 17:22:59' where trcStatus='V' and trcTerId = 18 03/04/2025 17:24:22.7544 551 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 17:24:44.7401 1461 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 17:24:43' where traUID = 5221077823325800 and traStatus='V' and traEnabled=1 03/04/2025 17:26:15.6441 1039 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 03/04/2025 17:26:46.9420 794 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-03 17:26:46','V',5349473860725580,2025,'2025-04-03 17:26:45','457486160600327005012999',2,2,2,'O','',0,'2025-04-03 17:26:46',1,'','',0) 03/04/2025 17:27:30.8315 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:27:45.8625 508 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-03 17:27:45','0230004101194',0,0,4982829970934050,30,'0000-00-00 00:00:00','0000-00-00 00:00:00') 03/04/2025 17:27:46.6200 754 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 30 03/04/2025 17:27:51.7855 657 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/04/2025 17:28:02.6648 838 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/04/2025 17:28:02.6728 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:34:14.2248 1537 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 17:38:11.3537 885 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 17:38:13.1129 576 ms. EXEC: update payReceipt set recCreation = '2025-04-03 17:38:12',recModify = '2025-04-03 17:38:12',recUseId=0,recStatus='V' where recId = 367199 03/04/2025 17:38:27.5045 969 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/04/2025 17:38:36.6196 622 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/04/2025 17:44:16.5997 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:44:16.6428 1315 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/04/2025 17:45:18.3131 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 17:45:21.5553 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:45:38.7778 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:46:43.2760 868 ms. OPEN: select useParkAccess from tabUser where (useBadId = '457485974700327005012999' or useBadId = '457485974700327005012999') 03/04/2025 17:46:47.5399 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 17:47:09.8268 1473 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:47:41.2708 531 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-03 17:47:40' where payTraUID = 5666438810797310 and payStatus='V' and payEnabled=1 03/04/2025 17:50:01.9821 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:52:00.3714 1772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 17:54:12.1416 2312 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/04/2025 17:59:35.5883 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 18:05:52.9430 529 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-03 18:05:52' where payTraUID = 5379460770117420 and payStatus='V' and payEnabled=1 03/04/2025 18:10:09.8514 1295 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 18:13:49.7376 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 18:13:51.3017 1537 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 03/04/2025 18:16:31.7081 1094 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 18:17:19.2880 1334 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 18:18:36.2635 662 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-03 18:18:35','V',4826471615962860,2025,'2025-04-03 18:18:34','457486476800327005012999',2,2,2,'O','',0,'2025-04-03 18:18:35',1,'','',0) 03/04/2025 18:22:56.4728 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 18:23:01.8594 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 18:25:33.4179 520 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-03 18:25:32',0,'V',4667400180753590,5630514340146170,2025,'2025-04-03 18:25:32',2,1,0,-1,'2025-04-03 19:25:32','S','KES',0,0,0,'','','',3,0,0) 03/04/2025 18:27:23.2124 1211 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 03/04/2025 18:32:20.1113 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 18:41:14.3273 1457 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 18:42:14.3845 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 18:47:06.5120 1565 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-03 18:47:04',0,0,'V',4892802614574980,5490635034217680,2025,'2025-04-03 18:47:04',3,'KES',1,50,50,'N',''); 03/04/2025 18:47:07.0483 535 ms. EXEC: update paycash set casCreation = '2025-04-03 18:47:06',casModify = '2025-04-03 18:47:06',casUseId=0,casStatus='V' where casId = 216344 03/04/2025 18:48:38.1193 1109 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-03 18:48:37','V',4855533906762990,2025,'2025-04-03 18:48:35','457486771500327005012999',1,2,16,'I','',1,0,1,'','',4) 03/04/2025 18:48:46.5709 1216 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 18:50:08.2556 1869 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-03 18:50:03',0,'V',5630657054212140,4735945267853070,2025,'2025-04-03 18:50:03',3,1,0,4,'2025-04-03 19:05:03','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 42 ms.) 03/04/2025 18:50:10.9334 2627 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4735945267853070,5630657054212140,2025,'2025-04-03 18:50:08','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/3/2025 6:15:22 PM Date : 4/3/2025 6:50:03 PM Code : 457486572200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 03/04/2025 18:50:11.7999 861 ms. EXEC: update payReceipt set recCreation = '2025-04-03 18:50:10',recModify = '2025-04-03 18:50:10',recUseId=0,recStatus='V' where recId = 367222 03/04/2025 18:50:12.6465 688 ms. EXEC: update paycash set casCreation = '2025-04-03 18:50:11',casModify = '2025-04-03 18:50:11',casUseId=0,casStatus='V' where casId = 216345 03/04/2025 18:50:13.2589 611 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-03 18:50:11',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'; 03/04/2025 18:51:22.5183 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 18:53:16.7097 594 ms. EXEC: update abbCards set carLastDate = '2025-04-03 18:53:16',carLastDirection='I' where carStatus='V' and carId = 206 03/04/2025 18:53:23.6203 945 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 18:55:53.3415 1062 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5301940011092990,5544865222024920,2025,'2025-04-03 18:55:52',' Date: 4/3/2025 6:55:51 PM Code: 457486758000327005012999 Entry Date: 4/3/2025 6:46:20 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 # 2500713564 ',0) 03/04/2025 18:56:54.4324 624 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-03 18:56:52',0,'V',5494647305932340,4615249288305040,2025,'2025-04-03 18:56:52',3,1,0,4,'2025-04-03 19:11:52','C','KES',50,500,450,'',' ',' ',1,50,0,0,'',0,0) 03/04/2025 18:57:11.8070 825 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 18:57:11.8101 827 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 03/04/2025 18:57:27.6477 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 18:59:06.1536 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 19:09:13.1918 1579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:10:13.6132 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:10:36.7036 523 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/04/2025 19:14:59.4052 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:15:25.0274 2878 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/04/2025 19:16:42.3130 1522 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); 03/04/2025 19:18:05.4376 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:18:31.7472 1101 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:21:14.5129 1977 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 03/04/2025 19:21:15.5716 1045 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 19:22:32.1606 830 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 19:22:31' where traUID = 4861712760616070 and traStatus='V' and traEnabled=1 03/04/2025 19:24:05.8240 1250 ms. EXEC: update abbCards set carLastDate = '2025-04-03 19:24:04',carLastDirection='O' where carStatus='V' and carId = 82 03/04/2025 19:24:53.5498 2506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 19:24:54.7756 827 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 03/04/2025 19:25:28.9143 1551 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-03 19:25:27','V',5382098543060360,2025,'2025-04-03 19:25:26','457486992600327005012999',1,2,16,'I','',1,0,1,'','',4) 03/04/2025 19:26:17.6948 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:26:45.6695 959 ms. EXEC: update payReceipt set recCreation = '2025-04-03 19:26:44',recModify = '2025-04-03 19:26:44',recUseId=0,recStatus='V' where recId = 367234 03/04/2025 19:29:02.8539 1285 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/04/2025 19:30:43.2129 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:31:02.6909 1630 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/04/2025 19:31:08.2876 2146 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-03 19:31:06','V',4817720071546930,2025,'2025-04-03 19:31:05','457487026500327005012999',1,2,16,'I','',1,0,1,'','',4) 03/04/2025 19:36:15.8506 1256 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:36:59.4698 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:41:52.6360 875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:42:34.4419 1077 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-03 19:42:33','V',5034281248735300,2025,'2025-04-03 19:42:32','457486592100327005012999',2,2,2,'O','',0,'2025-04-03 19:42:33',1,'','',0) 03/04/2025 19:43:14.7418 1727 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/04/2025 19:43:26.0344 795 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/04/2025 19:43:26.0474 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:43:46.2208 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:53:24.7465 2919 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 03/04/2025 19:53:26.8289 1561 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/04/2025 19:55:04.1160 1040 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/04/2025 19:55:04.1660 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 19:57:52.4597 530 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 20:03:22.4524 750 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/04/2025 20:05:31.4377 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:10:09.7816 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:13:03.8502 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:14:44.5329 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:18:10.9586 723 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 20:18:10.9596 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:21:34.7965 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:22:57.7692 2343 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 03/04/2025 20:22:57.8743 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:23:47.0894 751 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 20:23:57.8116 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:24:28.1689 2177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:26:00.4477 1039 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:26:22.4734 1228 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:30:57.7203 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:32:38.3598 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:32:44.9522 903 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/04/2025 20:32:46.8355 693 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/04/2025 20:33:49.7676 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:36:04.3028 3241 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:36:04.4019 2075 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 03/04/2025 20:39:19.7377 838 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 20:40:09.7632 4085 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 03/04/2025 20:48:07.4570 1661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 20:58:20.0823 1534 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/04/2025 20:59:06.1571 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 21:06:27.5947 823 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-03 21:06:24',0,'V',5619789491286080,4829342306758870,2025,'2025-04-03 21:06:24',3,1,0,4,'2025-04-03 21:21:24','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 03/04/2025 21:20:26.6574 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 21:23:33.0619 645 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13582, trcLastPrinted = '2500713582', trcLastDate = '2025-04-03 21:23:32' where trcStatus='V' and trcTerId = 18 03/04/2025 21:27:57.7702 2132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 21:28:15.0417 2867 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-03 21:28:12',0,'V',4701687220579820,4812568649248900,2025,'2025-04-03 21:28:12',18,1,0,4,'2025-04-03 21:43:12','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 03/04/2025 21:31:26.6691 15510 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 03/04/2025 21:31:29.3149 619 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 21:31:28' where traUID = 5619668155268030 and traStatus='V' and traEnabled=1 03/04/2025 21:33:17.5334 1143 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 21:35:30.3994 650 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13585, trcLastPrinted = '2500713585', trcLastDate = '2025-04-03 21:35:29' where trcStatus='V' and trcTerId = 18 03/04/2025 21:37:15.2326 833 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/04/2025 21:39:36.3521 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 21:41:20.0896 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 21:41:38.1767 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 21:43:00.0085 514 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 21:44:02.1771 1172 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 03/04/2025 21:44:04.9100 860 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 21:44:03' where traUID = 5127752008502630 and traStatus='V' and traEnabled=1 03/04/2025 21:44:10.9931 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 21:46:06.7586 741 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/04/2025 21:46:07.4961 733 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/04/2025 21:46:57.6867 667 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 03/04/2025 21:47:01.4793 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 21:54:27.0306 561 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4147, trcLastPrinted = '2500404147', trcLastDate = '2025-04-03 21:54:26' where trcStatus='V' and trcTerId = 4 03/04/2025 21:54:28.0513 1019 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5243234675655940,5482391481617930,2025,'2025-04-03 21:54:27',' Date: 4/3/2025 9:54:22 PM Code: 457487039300327005012999 Entry Date: 4/3/2025 7:33:13 PM 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 # 2500404147 ',0) 03/04/2025 21:56:48.1461 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:04:03.0877 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:04:29.0150 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:05:54.3572 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:10:23.8827 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:10:34.7119 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:12:07.2669 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:22:22.2868 530 ms. EXEC: update payReceipt set recCreation = '2025-04-03 22:22:21',recModify = '2025-04-03 22:22:21',recUseId=0,recStatus='V' where recId = 367284 03/04/2025 22:24:40.6174 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/04/2025 22:32:24.9263 889 ms. EXEC: update paycash set casCreation = '2025-04-03 22:32:24',casModify = '2025-04-03 22:32:24',casUseId=0,casStatus='V' where casId = 216370 03/04/2025 22:32:25.5367 610 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-03 22:32:24',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'; 03/04/2025 22:34:17.5047 724 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/04/2025 22:37:08.1930 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:50:48.4772 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:51:34.1068 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:51:36.3913 1078 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:51:49.8023 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:51:57.5955 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:53:04.1060 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:53:39.2556 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 22:54:13.9518 1384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:00:26.4599 1898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:00:48.0894 564 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13605, trcLastPrinted = '2500713605', trcLastDate = '2025-04-03 23:00:47' where trcStatus='V' and trcTerId = 18 03/04/2025 23:03:18.0517 706 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-03 23:03:17' where traUID = 5450767705669370 and traStatus='V' and traEnabled=1 03/04/2025 23:04:26.5085 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/04/2025 23:09:38.5108 1455 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/04/2025 23:13:49.0253 772 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-03 23:13:48',0,'V',5090107353366840,5751521649996680,2025,'2025-04-03 23:13:48',2,1,0,-1,'2025-04-04 00:13:48','S','KES',0,0,0,'','','',3,0,0) 03/04/2025 23:22:43.0045 1690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:23:31.5710 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:25:32.1476 835 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/04/2025 23:25:55.5363 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:27:17.1218 1045 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:27:58.0622 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:30:55.5879 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:30:57.7634 1217 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13609, trcLastPrinted = '2500713609', trcLastDate = '2025-04-03 23:30:56' where trcStatus='V' and trcTerId = 18 03/04/2025 23:32:07.9403 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:32:53.4808 1694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/04/2025 23:53:15.3636 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1