04/04/2025 00:06:01.8453 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:06:35.8490 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:15:57.4187 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:32:26.4130 1072 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:36:05.7496 1871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:40:53.3379 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:40:57.1164 1051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:50:26.1713 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:51:01.5610 965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:58:22.7584 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 00:58:32.2158 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 01:33:51.7065 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 01:37:47.1224 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 01:39:25.1790 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 01:39:34.1600 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 01:39:44.7151 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 01:41:38.7014 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 01:52:27.8286 639 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 04/04/2025 02:08:35.9758 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 02:10:41.1585 1022 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 04/04/2025 02:17:41.5455 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 02:20:23.3648 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 02:25:11.0013 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 02:26:56.3788 518 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 04/04/2025 02:30:48.4962 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 02:32:01.9564 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 02:46:20.2027 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 02:54:41.6843 1000 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 04/04/2025 02:58:31.0399 858 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 04/04/2025 03:00:02.0431 930 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 03:11:03.3490 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 03:15:44.0950 505 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 03:47:28.6583 915 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 03:47:32.1066 1090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 03:52:59.6099 547 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 04/04/2025 03:53:15.3164 1336 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 04:04:40.8915 563 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 04:04:52.0189 940 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 04:12:00.4397 4001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 04:15:48.0140 1308 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 04/04/2025 04:20:58.9751 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 04:21:11.5576 589 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 04/04/2025 04:24:49.8937 1912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 04:39:45.2370 1621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 04:44:18.7260 1721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 04:55:02.7350 870 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 04/04/2025 04:55:15.7847 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 05:01:19.4450 1140 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:01:53.9251 982 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 05:06:18.6022 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:06:24.5963 4291 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 04/04/2025 05:09:41.6712 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:15:51.7809 1580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:17:30.9003 867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:23:15.7216 1641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:23:15.7236 823 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 04/04/2025 05:23:19.3450 1693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:23:33.0592 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:23:34.3060 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:23:46.2590 1099 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:23:50.7370 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:24:01.6603 4290 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:24:05.9102 1009 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:27:06.4110 2582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:29:45.5805 1784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:33:31.9811 1513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:34:04.7130 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:34:04.7510 640 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 05:37:35.7073 1302 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:42:04.5632 1145 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:56:24.4290 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:57:00.9364 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:58:08.5897 1771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 05:59:16.1329 999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:00:19.7765 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:04:55.8723 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:09:32.1223 2551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:16:02.6240 533 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 06:16:42.8289 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 06:18:49.5126 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:19:20.7696 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:20:49.2128 2484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:20:58.7822 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:24:24.6219 690 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 06:25:37.3706 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:35:27.4474 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:42:21.0985 886 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 06:46:58.5982 531 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 04/04/2025 06:46:58.9134 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:52:15.5373 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:52:56.3986 895 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 06:53:43.4210 1816 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 04/04/2025 06:59:31.5129 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 07:00:55.0308 2596 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-04 07:00:52','V',5673290619114950,2025,'2025-04-04 07:00:51','457492525100327001012999',1,2,1,'I','',1,0,1,'','',4) 04/04/2025 07:00:55.0318 2423 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-04 07:00:52','V',5339637231238040,2025,'2025-04-04 07:00:51','457492525100327005012999',1,2,16,'I','',1,0,1,'','0560008336102',185,0) 04/04/2025 07:02:42.8840 1903 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 07:14:05.9931 3842 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 04/04/2025 07:14:06.0241 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 07:19:48.4763 3639 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 07:20:03.9307 12871 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 04/04/2025 07:20:05.0294 520 ms. EXEC: update abbCards set carLastDate = '2025-04-04 07:20:04',carLastDirection='I' where carStatus='V' and carId = 21 04/04/2025 07:27:06.1970 1021 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/04/2025 07:27:08.0803 1439 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 07:29:48.8298 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 07:40:34.0211 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 07:42:41.6024 1033 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 04/04/2025 07:54:59.6853 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 07:54:59.6853 709 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 07:56:34.1455 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 07:59:51.8306 562 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-04 07:59:51','V',4728627515415510,2025,'2025-04-04 07:59:49','457492878900327005012999',1,2,16,'I','',1,0,1,'','0230003950907',19,0) 04/04/2025 07:59:53.3436 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:06:10.2329 1949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:07:11.5449 720 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,0,50,-3,-150,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,0,50,3,150,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,0,100,-30,-3000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,0,100,30,3000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 08:06:57',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 04/04/2025 08:09:06.4468 943 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:12:26.3456 724 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 04/04/2025 08:12:46.3080 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:16:21.0977 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:17:34.7629 837 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-04 08:17:33',0,'V',5526440327037290,5597819596715830,2025,'2025-04-04 08:17:33',2,1,0,-1,'2025-04-04 09:17:33','S','KES',0,0,0,'','','',3,0,0) 04/04/2025 08:17:37.4858 990 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 08:17:36' where traUID = 5597819596715830 and traStatus='V' and traEnabled=1 04/04/2025 08:17:38.3343 1562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:18:14.4765 1449 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 04/04/2025 08:19:28.2559 2588 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 04/04/2025 08:19:29.8900 592 ms. OPEN: show columns from tabAbbGroups where Field = 'abgTarId' 04/04/2025 08:19:30.8496 956 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-04 08:19:29','V',4612199199739730,2025,'2025-04-04 08:19:25','457492996500327005012999',1,2,16,'I','',1,0,1,'','0750009518612',99,0) 04/04/2025 08:21:39.3786 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:22:19.9838 643 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 04/04/2025 08:30:26.4602 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:31:36.8272 965 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 08:34:08.3856 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:34:47.2326 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:36:09.4495 1505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:36:19.4282 955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:36:31.3712 1486 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-04 08:36:29','V',4689580920019910,2025,'2025-04-04 08:36:28','457493098800327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 08:42:03.5104 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:43:32.9872 597 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 04/04/2025 08:44:01.2061 675 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 08:48:47.6498 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:53:29.9727 613 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 08:53:29',0,16,'2025-04-04 08:53:29','','Unauthorized Transit Entry 2') 04/04/2025 08:57:40.3212 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 08:58:43.2223 1680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:00:26.5053 1144 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:00:44.4773 1385 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:00:54.1758 1386 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:03:17.9619 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:03:53.8950 5522 ms. EXECSCALAR: select traId from movtransit where traUID = 5525854046799150 and traStatus='V' nr: 898773 04/04/2025 09:03:54.1151 1867 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/04/2025 09:04:03.2662 4925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:09:20.0963 1049 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 09:09:32.0253 591 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); 04/04/2025 09:09:44.7998 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:10:15.2452 1012 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/04/2025 09:10:33.8456 603 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-04 09:10:33','V',4686842214649280,2025,'2025-04-04 09:10:31','457493303100327001012999',1,2,1,'I','',1,0,1,'','',4) 04/04/2025 09:10:36.1111 993 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-04 09:10:35','V',4867313548975400,2025,'2025-04-04 09:10:33','457493303300327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 09:10:58.5522 584 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/04/2025 09:15:04.6811 935 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-04 08:15:03') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-04 09:15:03' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-04 09:15:03' and (resAreId = 1 or resAreId <= 0) nr: 0 04/04/2025 09:15:07.3780 513 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-04-04 09:15:06','V',5714684490299720,2025,'2025-04-04 09:15:06','457493330600327005012999',1,2,16,'I','',1,0,1,'','0230004100082',142,0) 04/04/2025 09:21:10.5358 571 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 09:21:54.4262 521 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-04 09:21:53',0,'V',4841355103834060,5471407903966250,2025,'2025-04-04 09:21:53',18,1,0,4,'2025-04-04 09:36:53','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 04/04/2025 09:21:55.1607 650 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5471407903966250,4841355103834060,2025,'2025-04-04 09:21:54',' Date: 4/4/2025 9:21:53 AM Code: 457492821600327005012999 Entry Date: 4/4/2025 7:50:16 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 # 2500713617 ',0) 04/04/2025 09:23:59.9220 2051 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 09:23:57',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 04/04/2025 09:25:06.0282 1264 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 09:28:30.3258 808 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 09:30:51.6753 672 ms. EXEC: update abbCards set carLastDate = '2025-04-04 09:30:51',carLastDirection='I' where carStatus='V' and carId = 202 04/04/2025 09:30:55.1936 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:31:03.9915 577 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-04 09:31:03',0,'V',5698479435973280,4703115458353870,2025,'2025-04-04 09:31:03',18,1,0,4,'2025-04-04 09:46:03','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 04/04/2025 09:32:09.1921 1213 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 09:32:07' where payTraUID = 5493094778596310 and payStatus='V' and payEnabled=1 04/04/2025 09:32:09.6834 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:36:17.0192 1074 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-04 09:36:15','V',5376736892722700,2025,'2025-04-04 09:36:14','457493457400327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 09:36:43.0026 665 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 04/04/2025 09:36:44.7608 878 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 09:38:50.6229 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:39:09.6546 557 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 09:39:09' where payTraUID = 4689580920019910 and payStatus='V' and payEnabled=1 04/04/2025 09:39:10.3020 646 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 09:39:09' where traUID = 4689580920019910 and traStatus='V' and traEnabled=1 04/04/2025 09:39:23.7780 1742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:39:31.2820 517 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-04 09:39:30',0,'V',5097789624895930,4734083489430720,2025,'2025-04-04 09:39:30',3,1,0,4,'2025-04-04 09:54:30','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 09:39:32.7980 566 ms. EXEC: update payInventory set invCreation = '2025-04-04 09:39:32',invModify = '2025-04-04 09:39:32',invUseId=0,invStatus='V' where invId = 245005 04/04/2025 09:41:24.3767 2118 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 09:41:25.5355 613 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 09:41:24' where traUID = 4734083489430720 and traStatus='V' and traEnabled=1 04/04/2025 09:45:53.4798 760 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-04 09:45:50',1,'V',5197624518616690,5649179768916470,2025,'2025-04-04 09:45:50',4,1,0,4,'2025-04-04 10:00:50','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 04/04/2025 09:45:54.8968 1168 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 423707 else acvFstPayId end),acvLstPayId = 423707 where acvSftId = 952 and acvCodeId = 3 04/04/2025 09:47:02.4040 2098 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-04 09:47:00','V',5282089025501980,2025,'2025-04-04 09:46:59','457493184300327005012999',2,2,2,'O','',0,'2025-04-04 09:47:00',1,'','',0) 04/04/2025 09:47:03.0554 640 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 09:47:04.1441 1079 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 09:47:05.5581 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 09:47:47.0048 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:49:00.4440 701 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-04 09:48:59',0,'V',4809744320486580,4672069267908290,2025,'2025-04-04 09:48:59',18,1,0,4,'2025-04-04 10:03:59','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 09:49:01.1645 503 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13624, trcLastPrinted = '2500713624', trcLastDate = '2025-04-04 09:49:00' where trcStatus='V' and trcTerId = 18 04/04/2025 09:49:29.6676 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:50:36.2892 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:51:02.4997 5853 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 04/04/2025 09:52:45.0033 1158 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:53:44.9944 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:53:53.8854 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 09:56:35.3334 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 09:56:38.6306 676 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 09:56: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'; 04/04/2025 09:56:42.3872 2929 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 09:57:04.8752 1247 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 09:57:10.1568 682 ms. EXEC: update paycash set casCreation = '2025-04-04 09:57:09',casModify = '2025-04-04 09:57:09',casUseId=0,casStatus='V' where casId = 216400 04/04/2025 09:58:02.4988 545 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); 04/04/2025 10:01:18.1707 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 10:03:30.3532 612 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 04/04/2025 10:07:49.3335 826 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 10:08:47.9392 5766 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 04/04/2025 10:11:10.1133 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:17:11.0599 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:24:32.2862 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:25:39.8805 504 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 04/04/2025 10:29:24.4998 624 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-04 10:29:23','V',4970652352130430,2025,'2025-04-04 10:29:23','457493776300327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 10:29:33.7010 534 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 04/04/2025 10:29:35.0349 660 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '457486727400327001012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 04/04/2025 10:29:47.8805 720 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 10:33:19.0138 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:37:15.2179 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:44:10.1187 2192 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:44:56.3306 1561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:45:10.2710 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:45:13.0288 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 10:52:02.6521 984 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 10:52:02.6711 976 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 10:52:01',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'; 04/04/2025 10:54:49.9775 628 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-04 10:54:49','V',5474402901927580,2025,'2025-04-04 10:54:48','457493776300327005012999',2,2,2,'O','',0,'2025-04-04 10:54:49',1,'','',0) 04/04/2025 10:54:50.8341 688 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 10:54:54.6376 874 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 10:55:56.0688 596 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13635, trcLastPrinted = '2500713635', trcLastDate = '2025-04-04 10:55:55' where trcStatus='V' and trcTerId = 18 04/04/2025 10:55:56.7572 686 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4776955670742750,4772855796908060,2025,'2025-04-04 10:55:56',' Date: 4/4/2025 10:55:55 AM Code: 457493815700327005012999 Entry Date: 4/4/2025 10:35:57 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 # 2500713635 ',0) 04/04/2025 10:57:13.9849 654 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-04 10:57:12',0,'V',4614142137326000,5189600537003490,2025,'2025-04-04 10:57:12',3,1,0,4,'2025-04-04 11:12:12','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 10:57:15.3348 1003 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 10:57:14',0,0,'V',5519173205500500,5189600537003490,2025,'2025-04-04 10:57:14',3,'KES',1,100,100,'N',''); 04/04/2025 10:57:15.9553 619 ms. EXEC: update paycash set casCreation = '2025-04-04 10:57:15',casModify = '2025-04-04 10:57:15',casUseId=0,casStatus='V' where casId = 216405 04/04/2025 10:57:17.4533 1498 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 10:57:14',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 04/04/2025 10:57:18.5820 1003 ms. EXEC: update payInventory set invCreation = '2025-04-04 10:57:17',invModify = '2025-04-04 10:57:17',invUseId=0,invStatus='V' where invId = 245023 04/04/2025 10:57:19.2925 708 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 10:57:18',0,0,'V',5519173205500500,5189600537003490,2025,'2025-04-04 10:57:18',3,'KES',-1,50,-50,'N',''); 04/04/2025 10:57:20.1341 623 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 10:57:18',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'; 04/04/2025 10:57:25.4286 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 10:58:59.7388 1066 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-04 10:58:58','V',4694856658284220,2025,'2025-04-04 10:58:57','457493867200327005012999',2,2,2,'O','',0,'2025-04-04 10:58:58',1,'','',0) 04/04/2025 11:03:52.5832 1197 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5678366242796020,5324237949384980,2025,'2025-04-04 11:03:51',' Date: 4/4/2025 11:03:50 AM Code: 457493832300327005012999 Entry Date: 4/4/2025 10:38: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 # 2500713637 ',0) 04/04/2025 11:03:53.1096 781 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-04 11:03:52',0,'V',5013644384625430,5574302417688700,2025,'2025-04-04 11:03:52',18,1,0,4,'2025-04-04 11:18:52','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 11:04:32.3749 698 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 11:06:46.6738 1181 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4162, trcLastPrinted = '2500404162', trcLastDate = '2025-04-04 11:06:45' where trcStatus='V' and trcTerId = 4 04/04/2025 11:08:50.1805 602 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-04 11:08:48',0,'V',5686132292317690,5257488452435310,2025,'2025-04-04 11:08:48',3,1,0,4,'2025-04-04 11:23:48','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 11:09:42.5956 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:10:53.7163 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:13:56.9440 2825 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 04/04/2025 11:17:26.0010 1442 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:19:11.7910 1441 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-04 11:19:09',0,'V',5271441655354710,4620187372936650,2025,'2025-04-04 11:19:09',3,1,0,4,'2025-04-04 11:34:09','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 11:19:14.5819 1672 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 11:19:12',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'; 04/04/2025 11:21:52.0906 912 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-04 11:21:51','V',4702241708080830,2025,'2025-04-04 11:21:51','457494091100327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 11:25:08.5712 624 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 11:30:45.8331 921 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-04 11:30:44','V',5754845388497950,2025,'2025-04-04 11:30:44','457493990800327001012999',2,2,2,'O','',0,'2025-04-04 11:30:44',1,'','',0) 04/04/2025 11:30:59.4202 979 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 11:32:31.2597 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:33:19.0257 2046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:33:21.1901 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:34:06.0762 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:35:36.3796 502 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 11:36:52.1674 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:38:07.1076 577 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 11:38:06' where payTraUID = 5719598484721030 and payStatus='V' and payEnabled=1 04/04/2025 11:38:12.4802 1101 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 11:38:24.4422 562 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 11:38:26.3915 576 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-04 11:38:25','V',5192995332951060,2025,'2025-04-04 11:38:25','457494190500327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 11:41:34.3004 964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:41:38.6022 1157 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 11:42:28.6718 600 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 11:42:28.7098 761 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 04/04/2025 11:44:00.8785 518 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-04 11:44:00','V',4914376705701330,2025,'2025-04-04 11:43:59','457494223900327005012999',1,2,16,'I','',1,0,1,'','0230003945386',205,0) 04/04/2025 11:44:12.8636 557 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-04 11:44:12','V',5744292211859920,2025,'2025-04-04 11:44:11','457494225100327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 11:45:22.2801 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:45:30.6547 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:45:32.7741 3703 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); 04/04/2025 11:46:35.0508 511 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/04/2025 11:47:16.8028 572 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 11:47:16' where traUID = 5308891642213230 and traStatus='V' and traEnabled=1 04/04/2025 11:49:46.1158 645 ms. EXEC: update abbCards set carLastDate = '2025-04-04 11:49:45',carLastDirection='I' where carStatus='V' and carId = 165 04/04/2025 11:49:51.0130 2138 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 04/04/2025 11:49:59.6088 2049 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 04/04/2025 11:50:07.4831 657 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 11:50:06' where payTraUID = 5325111344706870 and payStatus='V' and payEnabled=1 04/04/2025 11:50:08.4467 963 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 11:50:06' where traUID = 5325111344706870 and traStatus='V' and traEnabled=1 04/04/2025 11:50:12.4444 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 11:50:13.4060 1061 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 04/04/2025 11:50:17.0725 3406 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-04 11:50:13','V',4865410731323110,2025,'2025-04-04 11:50:06','457494260600327001012999',1,2,1,'I','',1,0,1,'','0230004101216',10,0) 04/04/2025 11:55:43.2419 796 ms. EXEC: update payReceipt set recCreation = '2025-04-04 11:55:42',recModify = '2025-04-04 11:55:42',recUseId=0,recStatus='V' where recId = 367395 04/04/2025 11:57:19.7666 1185 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-04 11:57:18',0,'V',4946502663915420,5231477019273450,2025,'2025-04-04 11:57:18',18,1,0,4,'2025-04-04 12:12:18','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 11:57:36.1956 2011 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 11:58:54.0237 867 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 11:58:53',0,16,'2025-04-04 11:58:53','','Unauthorized Transit Entry 2') 04/04/2025 12:00:07.7011 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:00:35.0484 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:02:20.0947 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 12:03:49.5767 937 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-04 12:03:48',0,'V',5254195623593940,5063926813027810,2025,'2025-04-04 12:03:48',2,1,0,-1,'2025-04-04 13:03:48','S','KES',0,0,0,'','','',3,0,0) 04/04/2025 12:05:36.9916 772 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 12:21:45.3251 1210 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 12:21:44',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 04/04/2025 12:22:29.5277 558 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-04 12:22:28','V',5400253380403710,2025,'2025-04-04 12:22:28','457494334500327005012999',2,2,2,'O','',0,'2025-04-04 12:22:28',1,'','',0) 04/04/2025 12:22:30.4283 820 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 12:23:59.4910 2206 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13654, trcLastPrinted = '2500713654', trcLastDate = '2025-04-04 12:23:57' where trcStatus='V' and trcTerId = 18 04/04/2025 12:27:50.4236 1151 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 12:27:48',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'; 04/04/2025 12:29:07.9275 938 ms. OPEN: select * from opeShifts where sftId = 952 and sftStatus = 'V' 04/04/2025 12:29:20.5460 683 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-04 12:29:17',1,'V',4681183806230940,5581963334203240,2025,'2025-04-04 12:29:17',4,1,0,4,'2025-04-04 12:44:17','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 04/04/2025 12:29:21.7578 938 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 12:29:20',4,1,'2025-04-04 12:29:20','457493724300327005012999','Payed (Credit Card ) Ticket ') 04/04/2025 12:31:20.1091 541 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 12:31:19',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'; 04/04/2025 12:31:21.9003 1638 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='457493764300327005012999' 04/04/2025 12:32:05.6155 609 ms. EXEC: update payInventory set invCreation = '2025-04-04 12:32:05',invModify = '2025-04-04 12:32:05',invUseId=0,invStatus='V' where invId = 245047 04/04/2025 12:32:21.2080 721 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); 04/04/2025 12:33:16.0097 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:35:35.8533 2858 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 12:36:53.9466 834 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-04 12:36:53','V',5386516631062160,2025,'2025-04-04 12:36:52','457493764300327005012999',2,2,2,'O','',0,'2025-04-04 12:36:53',1,'','',0) 04/04/2025 12:38:45.9927 542 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 12:38:46.7302 730 ms. OPEN: show columns from tabParameters where Field = 'parTicketCustomLine1' 04/04/2025 12:39:08.2486 1348 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-04 12:39:06','V',4777935791823470,2025,'2025-04-04 12:38:51','457494553100327005031999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 12:43:24.4012 3650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 12:43:37.1317 545 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 12:43:37.1347 548 ms. OPEN: show columns from tabArea where Field = 'areType' 04/04/2025 12:43:37.1377 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 12:43:53.6577 597 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-04 12:42:38',12,'V',4698231329389030,5646624683981440,2025,'2025-04-04 12:42:38',17,1,0,4,'2025-04-04 12:57:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 12:46:42.0800 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:48:40.8886 828 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 12:49:28.0902 546 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13658, trcLastPrinted = '2500713658', trcLastDate = '2025-04-04 12:49:27' where trcStatus='V' and trcTerId = 18 04/04/2025 12:51:04.1445 585 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-04 12:51:03',0,'V',5659066746878460,5192995332951060,2025,'2025-04-04 12:51:03',18,1,0,4,'2025-04-04 13:06:03','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 04/04/2025 12:51:28.8140 1396 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:52:06.7224 2007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:52:26.9470 954 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 12:52:27.5734 598 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 12:52:52.4700 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:54:26.2679 708 ms. EXEC: update paycash set casCreation = '2025-04-04 12:54:25',casModify = '2025-04-04 12:54:25',casUseId=0,casStatus='V' where casId = 216435 04/04/2025 12:54:26.8643 596 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 12:54:25',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'; 04/04/2025 12:54:51.8260 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 12:54:53.9094 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:55:46.6077 1300 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 51 ms.) 04/04/2025 12:57:47.7278 3092 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 12:59:17.3949 1589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 13:02:41.5516 975 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/04/2025 13:06:46.9770 544 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 13:08:34.8512 662 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-04 13:08:34',0,'V',5500336988877910,4647561044589210,2025,'2025-04-04 13:08:34',18,1,0,4,'2025-04-04 13:23:34','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 13:11:17.4943 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 13:14:09.2741 1050 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-04 13:14:06',0,'V',5500654062202660,5499107062622730,2025,'2025-04-04 13:14:06',3,1,0,4,'2025-04-04 13:29:06','C','KES',100,50,50,'',' ',' ',98,100,0,0,'',0,0) 04/04/2025 13:14:51.3833 783 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 13:14:51.4823 632 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-04 13:14:49',0,'V',5551552939350860,5256211225194940,2025,'2025-04-04 13:14:49',3,1,0,4,'2025-04-04 13:29:49','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 13:15:45.8187 994 ms. EXEC: update payInventory set invCreation = '2025-04-04 13:15:44',invModify = '2025-04-04 13:15:44',invUseId=0,invStatus='V' where invId = 245060 04/04/2025 13:18:05.1640 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 13:18:23.6734 2244 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-04 13:18:21','V',5021691676119270,2025,'2025-04-04 13:18:21','457494790100327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 13:24:20.6065 867 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 13:26:34.8174 1326 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 13:28:52.2855 647 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 13:28:53.0690 781 ms. EXEC: update abbCards set carLastDate = '2025-04-04 13:28:52',carLastDirection='I' where carStatus='V' and carId = 9 04/04/2025 13:28:58.9759 1725 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 04/04/2025 13:28:59.0150 1814 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 13:30:58.7622 663 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 13:31:42.4664 1049 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-04 13:31:41','V',5377360012203780,2025,'2025-04-04 13:31:38','457490000400327003229999',22,22,3,'I','',1,0,1,'','',2) 04/04/2025 13:31:44.9381 901 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5005175224340100,4671149857772560,2025,'2025-04-04 13:31:44',' Date: 4/4/2025 1:31:41 PM Code: 457494580700327005012999 Entry Date: 4/4/2025 12:43:27 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500404177 ',0) 04/04/2025 13:31:45.8977 957 ms. EXEC: update payReceipt set recCreation = '2025-04-04 13:31:44',recModify = '2025-04-04 13:31:44',recUseId=0,recStatus='V' where recId = 367441 04/04/2025 13:32:50.9643 956 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 13:33:35.9925 2113 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 13:33:36.0285 2660 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 423833 else acvFstPayId end),acvLstPayId = 423833 where acvSftId = 953 and acvCodeId = 3 04/04/2025 13:34:30.2588 536 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 13:34:31.3295 1060 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 13:34:37.9510 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 13:38:56.4391 1182 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 13:38:55',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'; 04/04/2025 13:39:37.0663 536 ms. EXEC: update payReceipt set recCreation = '2025-04-04 13:39:36',recModify = '2025-04-04 13:39:36',recUseId=0,recStatus='V' where recId = 367447 04/04/2025 13:39:37.8949 815 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 13:39:37',0,0,'V',5640885246963350,5445359045621280,2025,'2025-04-04 13:39:37',3,'KES',1,200,200,'N',''); 04/04/2025 13:39:38.7494 530 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 13:39:37',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'; 04/04/2025 13:40:51.0018 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 13:40:57.7423 570 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 13:41:15.9165 986 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-04 13:41:14','V',5682391990495850,2025,'2025-04-04 13:41:14','457494778800327005012999',2,2,2,'O','',0,'2025-04-04 13:41:14',1,'','',0) 04/04/2025 13:41:22.1237 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 13:41:37.1537 901 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 13:42:05.7199 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 13:42:41.4368 2322 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-04 13:42:39','V',5507605817644710,2025,'2025-04-04 13:42:37','457494720500327005012999',2,2,2,'O','',0,'2025-04-04 13:42:39',1,'','',0) 04/04/2025 13:48:22.9315 534 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 13:49:27.3767 817 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 13:49:54.4078 587 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 13:49:53',17,12,'2025-04-04 13:49:53','457494082500327005012999','Pagato (Contanti ) Biglietto ') 04/04/2025 13:49:55.2543 735 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2471, trcLastPrinted = '2500602471', trcLastDate = '2025-04-04 13:49:54' where trcStatus='V' and trcTerId = 17 04/04/2025 13:50:49.6067 4724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 13:51:00.2208 936 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 13:50:59' where payTraUID = 5256563659082800 and payStatus='V' and payEnabled=1 04/04/2025 13:51:01.0534 832 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 13:50:59' where traUID = 5256563659082800 and traStatus='V' and traEnabled=1 04/04/2025 13:51:13.7639 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 13:53:35.4508 1419 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 13:53:34' where payTraUID = 5731121355527490 and payStatus='V' and payEnabled=1 04/04/2025 13:54:12.5456 684 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 13:55:31.0792 640 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-04 13:55:29',0,'V',5413445862132280,5758899464602200,2025,'2025-04-04 13:55:29',3,1,0,4,'2025-04-04 14:10:29','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 13:58:49.3210 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 13:59:27.9359 852 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 13:59:34.4402 1017 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 04/04/2025 13:59:35.1067 610 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/04/2025 14:00:20.2359 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:06:27.1046 1601 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 14:06:25' where traUID = 4823324154161210 and traStatus='V' and traEnabled=1 04/04/2025 14:06:44.2231 521 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 14:08:59.4126 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:09:11.1935 855 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 14:09:09',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'; 04/04/2025 14:09:15.2923 2469 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 14:09:18.5024 1282 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:11:22.9448 631 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/04/2025 14:12:32.8075 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 14:12:36.7342 1973 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-04 14:12:34','V',5553832007578900,2025,'2025-04-04 14:12:34','457494930000327001012999',2,2,2,'O','',0,'2025-04-04 14:12:34',1,'','',0) 04/04/2025 14:12:40.1805 1313 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 14:13:39.6753 784 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 14:13:38',0,16,'2025-04-04 14:13:38','','Unauthorized Transit Entry 2') 04/04/2025 14:15:14.9702 972 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-04 14:15:13','V',4819202348853560,2025,'2025-04-04 14:15:11','457494916200327001012999',2,2,2,'O','',0,'2025-04-04 14:15:13',1,'','',0) 04/04/2025 14:15:16.1349 550 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 14:15:15' where payTraUID = 4965320108558850 and payStatus='V' and payEnabled=1 04/04/2025 14:16:07.6294 1140 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 14:16:15.6578 1326 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-04 14:16:14','V',5406098257573970,2025,'2025-04-04 14:16:13','457495002700327005012999',2,2,2,'O','',0,'2025-04-04 14:16:14',1,'','',0) 04/04/2025 14:17:08.2650 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:18:11.3943 719 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 14:18:23.1812 798 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 14:19:09.6363 784 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4183, trcLastPrinted = '2500404183', trcLastDate = '2025-04-04 14:19:08' where trcStatus='V' and trcTerId = 4 04/04/2025 14:21:23.8872 1195 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 14:21:56.1689 594 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 14:22:02.6042 870 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 14:22:57.3909 619 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-04 14:22:56','V',5046145911163510,2025,'2025-04-04 14:22:56','457495177600327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 14:23:01.6847 579 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 14:28:09.0176 2694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:28:11.2931 916 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 14:28:10' where payTraUID = 5694653596646520 and payStatus='V' and payEnabled=1 04/04/2025 14:31:55.6760 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:32:57.7966 960 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 14:32:56' where traUID = 5411219478889860 and traStatus='V' and traEnabled=1 04/04/2025 14:39:13.8405 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:41:19.8348 659 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 14:41:19' where payTraUID = 4953952534770920 and payStatus='V' and payEnabled=1 04/04/2025 14:41:25.4246 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:41:25.7378 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 14:41:44.1691 611 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 14:41:45.7202 1472 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 14:41:44' where payTraUID = 5647561071079930 and payStatus='V' and payEnabled=1 04/04/2025 14:42:04.2796 815 ms. OPEN: select useParkAccess from tabUser where (useBadId = '457491810100327005012999' or useBadId = '457491810100327005012999') 04/04/2025 14:42:04.2826 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:42:06.9214 873 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 14:42:22.5118 843 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-04 14:42:19',0,'V',5227300350217860,4710693905249240,2025,'2025-04-04 14:42:19',3,1,0,4,'2025-04-04 14:57:19','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 04/04/2025 14:42:23.2783 714 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4710693905249240,5227300350217860,2025,'2025-04-04 14:42:22','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/4/2025 1:41:57 PM Date : 4/4/2025 2:42:19 PM Code : 457494931700327001012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 04/04/2025 14:42:23.8817 601 ms. EXEC: update payReceipt set recCreation = '2025-04-04 14:42:23',recModify = '2025-04-04 14:42:23',recUseId=0,recStatus='V' where recId = 367483 04/04/2025 14:42:24.7673 873 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 14:42:23',0,0,'V',5514880633654470,4710693905249240,2025,'2025-04-04 14:42:23',3,'KES',1,100,100,'N',''); 04/04/2025 14:42:25.8791 900 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 14:42:23',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'; 04/04/2025 14:45:22.5964 970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:45:32.0027 684 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 14:45:31',17,12,'2025-04-04 14:45:31','457495023100327001012999','Pagato (Contanti ) Biglietto ') 04/04/2025 14:47:37.3719 833 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 14:49:01.1320 2031 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:49:08.0266 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:49:31.6915 731 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-04 14:49:30','V',4727259134329340,2025,'2025-04-04 14:49:30','457495196400327005012999',2,2,2,'O','',0,'2025-04-04 14:49:30',1,'','',0) 04/04/2025 14:49:46.6685 1370 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 14:49:49.1982 1303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:49:58.6105 853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:50:04.0562 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:50:23.0719 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 14:50:41.3431 531 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 423882 else acvFstPayId end),acvLstPayId = 423882 where acvSftId = 952 and acvCodeId = 3 04/04/2025 14:50:42.4909 1103 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4185, trcLastPrinted = '2500404185', trcLastDate = '2025-04-04 14:50:41' where trcStatus='V' and trcTerId = 4 04/04/2025 14:50:43.0213 526 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5620938999689990,5546498774853180,2025,'2025-04-04 14:50:42',' Date: 4/4/2025 2:50:37 PM Code: 457494578800327005012999 Entry Date: 4/4/2025 12:43:08 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 # 2500404185 ',0) 04/04/2025 14:51:58.5589 996 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 14:52:05.6496 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 14:57:46.4271 1642 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 14:59:59.6083 950 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5108549501774410,5282796907712460,2025,'2025-04-04 14:59:58',' Date: 4/4/2025 2:59:56 PM Code: 457495123200327005012999 Entry Date: 4/4/2025 2:13:52 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500404186 ',0) 04/04/2025 15:00:18.7311 691 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-04 15:00:18','V',5216432607627240,2025,'2025-04-04 15:00:17','457495401700327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 15:01:16.1626 778 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 15:01:35.1373 1220 ms. EXEC: delete from movInside where insTraUID = 5482257610626490 04/04/2025 15:03:13.5602 2382 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 15:07:06.1259 1390 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 15:07:04' where traUID = 4697267724996760 and traStatus='V' and traEnabled=1 04/04/2025 15:07:08.5656 1112 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 15:07:45.5373 727 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 15:07:45.5894 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:07:47.9850 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:08:56.6240 608 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-04 15:08:53',0,'V',5003423749368180,5492796087692980,2025,'2025-04-04 15:08:53',3,1,0,4,'2025-04-04 15:23:53','C','KES',100,500,400,'',' ',' ',1,100,0,0,'',0,0) 04/04/2025 15:09:17.3979 2330 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 15:12:14.8747 653 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 15:12:14' where traUID = 5701299704870960 and traStatus='V' and traEnabled=1 04/04/2025 15:14:46.7217 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:14:53.7104 1418 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 15:15:42.7032 683 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 15:15:42.7302 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:16:52.5650 782 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 15:16:51',0,0,'V',4843173238504720,5473203362270530,2025,'2025-04-04 15:16:51',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 15:16:51',0,0,'V',4843173238504720,5473203362270530,2025,'2025-04-04 15:16:51',3,'KES',-1,100,-100,'N',''); 04/04/2025 15:18:12.2544 1938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:18:24.5466 1128 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 15:18:23' where payTraUID = 5473203362270530 and payStatus='V' and payEnabled=1 04/04/2025 15:18:25.6093 1062 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 15:18:23' where traUID = 5473203362270530 and traStatus='V' and traEnabled=1 04/04/2025 15:19:59.5142 607 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-04 15:19:58','V',5568178066889580,2025,'2025-04-04 15:19:58','457495037300327005012999',2,2,2,'O','',0,'2025-04-04 15:19:58',1,'','',0) 04/04/2025 15:23:42.4544 561 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-04 15:23:41','V',5396870981118620,2025,'2025-04-04 15:23:41','457495374100327005012999',2,2,2,'O','',0,'2025-04-04 15:23:41',1,'','',0) 04/04/2025 15:23:42.9878 530 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 15:24:01.3411 838 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 15:24:00',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'; 04/04/2025 15:25:46.7967 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 15:25:58.8047 818 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 15:31:16.0882 935 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); 04/04/2025 15:32:10.0734 1019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:32:54.3711 717 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-04 15:32:52',0,'V',4743414558874610,4712501306610310,2025,'2025-04-04 15:32:52',3,1,0,4,'2025-04-04 15:47:52','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 15:33:06.2670 661 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 15:34:47.0205 885 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-04 15:34:43',0,'V',5051974534127030,5340573823369620,2025,'2025-04-04 15:34:43',3,1,0,4,'2025-04-04 15:49:43','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 15:34:47.8621 645 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 15:34:47',0,0,'V',4766457395302680,5340573823369620,2025,'2025-04-04 15:34:47',3,'KES',1,100,100,'N',''); 04/04/2025 15:34:48.6356 689 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 15:34:47',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'; 04/04/2025 15:34:50.1236 1386 ms. EXEC: update paycash set casCreation = '2025-04-04 15:34:48',casModify = '2025-04-04 15:34:48',casUseId=0,casStatus='V' where casId = 216499 04/04/2025 15:35:57.4867 1584 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 15:36:29.2080 2597 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 15:37:36.5971 1321 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 15:37:35' where payTraUID = 5340573823369620 and payStatus='V' and payEnabled=1 04/04/2025 15:38:02.5595 1138 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-04 15:36:46',12,'V',5428252920647320,4878344261819780,2025,'2025-04-04 15:36:46',17,1,0,4,'2025-04-04 15:51:46','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 15:38:03.0788 511 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 15:38:02',17,12,'2025-04-04 15:38:02','457495420300327005012999','Pagato (Contanti ) Biglietto ') 04/04/2025 15:38:08.0231 3656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:38:41.1603 1782 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 04/04/2025 15:39:55.0898 631 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-04 15:39:54','V',5356587927736860,2025,'2025-04-04 15:39:53','457495639300327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 15:40:22.4892 635 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 423918 else acvFstPayId end),acvLstPayId = 423918 where acvSftId = 953 and acvCodeId = 3 04/04/2025 15:40:50.7231 1117 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:41:13.2112 957 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 15:41:11',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 04/04/2025 15:42:58.8109 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:44:45.1021 1098 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:45:55.7434 1114 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 15:45:54',0,0,'V',4665894705351780,5575182271817160,2025,'2025-04-04 15:45:54',3,'KES',1,100,100,'N',''); 04/04/2025 15:45:57.2414 984 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 15:45:56',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 04/04/2025 15:46:25.0610 536 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 15:50:11.5559 516 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 04/04/2025 15:50:24.6977 608 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 15:50:43.1181 673 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 15:50:42' where payTraUID = 4729740309465290 and payStatus='V' and payEnabled=1 04/04/2025 15:50:43.8496 730 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 15:50:42' where traUID = 4729740309465290 and traStatus='V' and traEnabled=1 04/04/2025 15:51:14.6452 888 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-04 15:51:13','V',5123572221199720,2025,'2025-04-04 15:51:08','457495706800327001012999',1,2,1,'I','',1,0,1,'','',4) 04/04/2025 15:51:47.9435 668 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 15:51:48.1626 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:51:49.8588 879 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-04 15:51:48','V',5167681572740070,2025,'2025-04-04 15:51:47','457495710700327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 15:52:08.4122 526 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 15:52:36.5080 1199 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 15:52:35',0,2,'2025-04-04 15:52:35','','Unauthorized Transit Exit 1') 04/04/2025 15:52:42.6761 2783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:52:55.3256 905 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 04/04/2025 15:56:49.1252 835 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 15:56:48',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'; 04/04/2025 15:56:51.3037 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 15:58:14.4053 1667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 15:58:43.7900 779 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 16:01:34.8456 2693 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 16:02:06.5258 534 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-04 16:02:05','V',5445179108039500,2025,'2025-04-04 16:02:01','457490001000327003229999',22,22,3,'I','',1,0,1,'','',2) 04/04/2025 16:02:37.9478 914 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2490, trcLastPrinted = '2500602490', trcLastDate = '2025-04-04 16:02:37' where trcStatus='V' and trcTerId = 17 04/04/2025 16:03:52.5078 779 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 423931 else acvFstPayId end),acvLstPayId = 423931 where acvSftId = 953 and acvCodeId = 3 04/04/2025 16:04:15.3971 747 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 16:07:39.5801 720 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-04 16:06:24',12,'V',4632245601915740,5411826143038880,2025,'2025-04-04 16:06:24',17,1,0,4,'2025-04-04 16:21:24','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 16:07:50.4534 845 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-04 16:07:49','V',5153996600907370,2025,'2025-04-04 16:07:48','457495333700327001012999',2,2,2,'O','',0,'2025-04-04 16:07:49',1,'','',0) 04/04/2025 16:07:51.8623 1399 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 16:08:17.0742 568 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='457495599000327001012999' 04/04/2025 16:08:53.8708 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:10:15.2954 1013 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 16:10:14',0,0,'V',5754832055980820,5243463715229600,2025,'2025-04-04 16:10:14',3,'KES',1,50,50,'N',''); 04/04/2025 16:10:16.2580 601 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 16:10: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'; 04/04/2025 16:11:01.0570 2308 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); 04/04/2025 16:11:44.5612 572 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-04 16:10:28',12,'V',4722685704558020,5606527511104820,2025,'2025-04-04 16:10:28',17,1,0,4,'2025-04-04 16:25:28','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 16:12:32.3261 1993 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 16:12:32.3792 2044 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 16:12:30',17,12,'2025-04-04 16:12:30','457495338400327005012999','Pagato (Contanti ) Biglietto ') 04/04/2025 16:12:40.9449 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:12:42.4960 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:19:25.2845 941 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 16:23:30.1435 1057 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 16:24:58.6168 1274 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-04 16:24:57','V',5751933203142100,2025,'2025-04-04 16:24:56','457495909600327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 16:24:59.1822 557 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 16:26:33.4883 2234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:26:54.5905 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:27:35.7260 508 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-04 16:27:35',0,'V',5491019316548820,5748421445959880,2025,'2025-04-04 16:27:35',18,1,0,4,'2025-04-04 16:42:35','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 16:28:10.6084 1574 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 04/04/2025 16:29:06.2987 1286 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 16:29: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'; 04/04/2025 16:29:39.5569 1818 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5159356560492430,4747611021222610,2025,'2025-04-04 16:29:37',' Date: 4/4/2025 4:29:37 PM Code: 457495773200327005012999 Entry Date: 4/4/2025 4:02:12 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 # 2500713673 ',0) 04/04/2025 16:30:43.0585 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-04 16:30:42','V',5708327079712100,2025,'2025-04-04 16:30:41','457495773200327005012999',2,2,2,'O','',0,'2025-04-04 16:30:42',1,'','',0) 04/04/2025 16:33:25.3171 662 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 16:33:24' where traUID = 4769950274921090 and traStatus='V' and traEnabled=1 04/04/2025 16:33:49.8826 655 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-04-04 16:33:49' where subId = 20 04/04/2025 16:33:51.9390 2051 ms. OPEN: show columns from abbPayment where Field = 'payDateTo' 04/04/2025 16:34:11.3900 589 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-04 16:34:10','V',5053241431661070,2025,'2025-04-04 16:34:09','457495684600327005012999',2,2,2,'O','',0,'2025-04-04 16:34:10',1,'','',0) 04/04/2025 16:34:12.8230 992 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 16:34:41.9335 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:34:41.9655 762 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 16:35:00.1687 1459 ms. EXEC: update payInventory set invCreation = '2025-04-04 16:34:58',invModify = '2025-04-04 16:34:58',invUseId=0,invStatus='V' where invId = 245143 04/04/2025 16:35:22.4856 745 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 16:35:21' where payTraUID = 5748421445959880 and payStatus='V' and payEnabled=1 04/04/2025 16:37:05.8655 1135 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 16:37:09.1557 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 16:37:54.1638 778 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 16:43:28.2786 553 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-04 16:43:27',0,'V',5140531358844190,4708139987677440,2025,'2025-04-04 16:43:27',2,1,0,-1,'2025-04-04 17:43:27','S','KES',0,0,0,'','','',3,0,0) 04/04/2025 16:45:28.9284 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 16:46:49.0751 650 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 16:46:49.8466 720 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 16:48:08.0720 524 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 16:49:58.0837 660 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 16:49:57',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 04/04/2025 16:50:50.2596 1097 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:51:23.7570 776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:52:00.4926 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:52:21.1285 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:54:44.3804 1103 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:55:44.1334 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 16:56:14.5558 1184 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 16:58:37.7047 955 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 16:58:38.6493 685 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 16:58:37' where payTraUID = 5236163447857490 and payStatus='V' and payEnabled=1 04/04/2025 16:59:07.2104 937 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-04 16:57:51',12,'V',5540151530357290,5267140117903550,2025,'2025-04-04 16:57:51',17,1,0,4,'2025-04-04 17:12:51','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 16:59:25.1685 582 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-04 16:59:24',0,'V',5258500130499200,5330917097566710,2025,'2025-04-04 16:59:24',2,1,0,-1,'2025-04-04 17:59:24','S','KES',0,0,0,'','','',3,0,0) 04/04/2025 16:59:57.2800 1193 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 17:00:08.4675 964 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 04/04/2025 17:00:18.6813 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:00:19.1756 9392 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 04/04/2025 17:02:38.7931 772 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 17:04:22.1394 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:04:29.7815 837 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 17:04:34.8609 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:09:10.5965 662 ms. EXECSCALAR: select terAddress from tabTerminal where terId = 16 nr: 5 04/04/2025 17:09:10.6035 636 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 04/04/2025 17:12:31.9563 635 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 04/04/2025 17:15:41.7144 1156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:17:03.3021 667 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-04 17:17:02','V',4918625243095520,2025,'2025-04-04 17:17:01','457496222100327001012999',1,2,1,'I','',1,0,1,'','',4) 04/04/2025 17:17:03.8374 525 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 17:18:14.1545 658 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5139368628913460,4895467515540720,2025,'2025-04-04 17:18:13',' Date: 4/4/2025 5:18:13 PM Code: 457496132900327005012999 Entry Date: 4/4/2025 5:02:09 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 # 2500713680 ',0) 04/04/2025 17:19:39.2035 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:19:52.4303 775 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 17:19:51' where traUID = 5139368628913460 and traStatus='V' and traEnabled=1 04/04/2025 17:21:46.4357 861 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 04/04/2025 17:21:46.4547 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:23:48.1012 1494 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:25:27.8190 1100 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:25:51.7600 695 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 04/04/2025 17:27:59.2245 1302 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-04 17:27:57','V',4863443979162770,2025,'2025-04-04 17:27:57','457496287700327001012999',1,2,1,'I','',1,0,1,'','',4) 04/04/2025 17:28:13.4100 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:29:58.8166 984 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 17:30:02.1178 672 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 17:30:12.5448 2332 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:30:44.0419 1011 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:35:09.3395 1202 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-04-04 17:35:08' where subId = 31 04/04/2025 17:35:11.3699 1608 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 17:36:41.7044 2677 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4908846234948740,4805371926897740,2025,'2025-04-04 17:36:39',' Date: 4/4/2025 5:36:38 PM Code: 457496299600327005012999 Entry Date: 4/4/2025 5:29:56 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 # 2500713684 ',0) 04/04/2025 17:36:42.7000 995 ms. EXEC: update payReceipt set recCreation = '2025-04-04 17:36:41',recModify = '2025-04-04 17:36:41',recUseId=0,recStatus='V' where recId = 367575 04/04/2025 17:37:14.9817 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:39:25.2719 622 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-04 17:39:24',0,'V',5677004161760100,4846069472764440,2025,'2025-04-04 17:39:24',2,1,0,-1,'2025-04-04 18:39:24','S','KES',0,0,0,'','','',3,0,0) 04/04/2025 17:39:28.5541 760 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 17:39:45.9978 612 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 17:39:57.2794 654 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 17:39:57.3394 676 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13685, trcLastPrinted = '2500713685', trcLastDate = '2025-04-04 17:39:56' where trcStatus='V' and trcTerId = 18 04/04/2025 17:40:22.1040 621 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 17:40:21' where payTraUID = 4844136399280520 and payStatus='V' and payEnabled=1 04/04/2025 17:40:23.0736 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:40:25.4092 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:44:37.6741 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:46:14.7702 805 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 17:46:46.7776 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:49:36.3352 530 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 17:49:35',0,0,'V',4937874197862700,5480375321894570,2025,'2025-04-04 17:49:35',3,'KES',1,200,200,'N',''); 04/04/2025 17:49:37.6711 574 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 04/04/2025 17:51:33.8339 583 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 17:51:33',0,16,'2025-04-04 17:51:33','','Unauthorized Transit Entry 2') 04/04/2025 17:51:39.6698 780 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-04 17:51:38','V',5158380436440610,2025,'2025-04-04 17:51:37','457496429700327005012999',1,2,16,'I','',1,0,1,'','0810007117807',204,4) 04/04/2025 17:52:03.0765 598 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 424002 else acvFstPayId end),acvLstPayId = 424002 where acvSftId = 952 and acvCodeId = 3 04/04/2025 17:56:16.6753 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 17:56:30.1944 641 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 04/04/2025 17:56:30.7667 546 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 17:56:30',0,2,'2025-04-04 17:56:30','','Unauthorized Transit Exit 1') 04/04/2025 18:00:31.1320 1110 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 04/04/2025 18:00:41.9603 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:02:15.6240 875 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 18:02:14' where payTraUID = 5276623468857150 and payStatus='V' and payEnabled=1 04/04/2025 18:02:17.1330 1503 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 18:02:14' where traUID = 5276623468857150 and traStatus='V' and traEnabled=1 04/04/2025 18:03:02.1402 1295 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:03:18.3520 1956 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-04 18:03:16',0,'V',5065237394545200,4863443979162770,2025,'2025-04-04 18:03:16',18,1,0,4,'2025-04-04 18:18:16','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 18:08:52.3677 1787 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 04/04/2025 18:08:57.8374 680 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-04 18:08:57','V',5366942866517250,2025,'2025-04-04 18:08:56','457496018400327005012999',2,2,2,'O','',0,'2025-04-04 18:08:57',1,'','',0) 04/04/2025 18:10:58.6353 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:13:42.9293 736 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 18:13:42' where traUID = 4612508426302860 and traStatus='V' and traEnabled=1 04/04/2025 18:16:37.8375 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:17:12.4867 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:17:50.6753 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 18:30:59.5423 845 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:36:58.6949 1374 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-50,5),subLastDebit = '2025-04-04 18:36:57' where subId = 220 04/04/2025 18:37:00.9914 797 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 04/04/2025 18:37:02.7106 1549 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 18:37:01' where payTraUID = 5158380436440610 and payStatus='V' and payEnabled=1 04/04/2025 18:43:37.4439 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:45:05.3978 705 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-04 18:45:04','V',5456140810781670,2025,'2025-04-04 18:45:03','457496750300327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 18:46:53.8034 1126 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:47:47.6205 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:51:03.1629 587 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 18:51:02' where payTraUID = 4684428313417350 and payStatus='V' and payEnabled=1 04/04/2025 18:54:59.9455 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:55:51.4810 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:56:22.1925 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 18:57:03.8074 1397 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-04 18:57:02','V',5260809603249190,2025,'2025-04-04 18:57:01','457496605600327005012999',2,2,2,'O','',0,'2025-04-04 18:57:02',1,'','',0) 04/04/2025 18:57:29.1884 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:02:48.0570 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:02:48.5513 1304 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 04/04/2025 19:02:52.5200 1260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:02:59.0583 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:03:04.3829 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:03:14.4797 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:03:26.5407 787 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 19:03:28.0868 1516 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 19:04:27.4375 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:08:24.9399 1225 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 19:08:34.9296 707 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 19:08:59.9764 3118 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 19:11:45.6343 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 19:11:46.2667 851 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-04 19:11:45','V',5203677588620370,2025,'2025-04-04 19:11:40','457496910000327005012999',1,2,16,'I','',1,0,1,'','0230003944059',13,0) 04/04/2025 19:11:52.1277 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:12:08.6217 1424 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13702, trcLastPrinted = '2500713702', trcLastDate = '2025-04-04 19:12:07' where trcStatus='V' and trcTerId = 18 04/04/2025 19:13:06.2843 675 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-04 19:13:05','V',4859462571430010,2025,'2025-04-04 19:13:04','457496771800327001012999',2,2,2,'O','',0,'2025-04-04 19:13:05',1,'','',0) 04/04/2025 19:13:40.2551 811 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 19:17:40.4424 551 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 19:20:06.8285 710 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-04 19:20:06','V',5404680730388570,2025,'2025-04-04 19:20:04','457496960400327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 19:20:07.6050 580 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 19:20:08.9859 875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:23:39.9392 811 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 04/04/2025 19:23:55.3976 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:24:56.8127 1321 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 19:26:44.8901 805 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 19:28:48.2527 701 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 19:28:49.1453 684 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 19:28:48' where payTraUID = 5444785672533640 and payStatus='V' and payEnabled=1 04/04/2025 19:32:46.8915 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:32:50.8292 820 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-04 19:32:50','V',4888115872972530,2025,'2025-04-04 19:32:47','457496562200327005012999',2,2,2,'O','',0,'2025-04-04 19:32:50',1,'','',0) 04/04/2025 19:32:51.7498 691 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 19:32:51' where payTraUID = 5554141050260220 and payStatus='V' and payEnabled=1 04/04/2025 19:33:04.0450 665 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 04/04/2025 19:33:08.1788 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:34:04.9998 526 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-04 19:34:04','V',5299855703176470,2025,'2025-04-04 19:34:04','457497044400327005012999',1,2,16,'I','',1,0,1,'','',4) 04/04/2025 19:35:33.0768 1110 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 04/04/2025 19:36:00.5242 622 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 04/04/2025 19:37:39.7206 648 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-04 19:37:38',0,'V',4809212359644720,5456140810781670,2025,'2025-04-04 19:37:38',18,1,0,4,'2025-04-04 19:52:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 19:37:39.7667 655 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-04 19:37:38',0,'V',5395625039306380,5012858111896220,2025,'2025-04-04 19:37:38',18,1,0,4,'2025-04-04 19:52:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/04/2025 19:37:48.8928 1347 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 2 ms.) 04/04/2025 19:37:49.4822 571 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 19:37:48' where payTraUID = 5456140810781670 and payStatus='V' and payEnabled=1 04/04/2025 19:46:47.1394 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:49:29.6232 556 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 04/04/2025 19:51:25.7920 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:52:55.0408 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:53:27.8218 692 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-04 19:53:27',1,2,'2025-04-04 19:53:27','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 04/04/2025 19:53:52.2271 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:54:56.7353 955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 19:58:50.5709 850 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 04/04/2025 20:03:07.2839 763 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 20:05:03.7469 1602 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 04/04/2025 20:21:37.0298 1102 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-04 20:21:35','0560008516054',0,0,5515024151878140,163,'0000-00-00 00:00:00','0000-00-00 00:00:00') 04/04/2025 20:24:32.0453 2077 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 20:24:32.6687 583 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 20:25:10.4981 1454 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 20:27:01.3393 840 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 20:27:43.4445 1034 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 20:28:25.5457 751 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-04 20:28:24','V',5303376504610460,2025,'2025-04-04 20:28:24','457496170700327005012999',2,2,2,'O','',0,'2025-04-04 20:28:24',1,'','',0) 04/04/2025 20:28:32.1261 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 20:35:45.1084 550 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/04/2025 20:35:50.7802 556 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 20:35:51.7678 983 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 04/04/2025 20:36:29.4171 1417 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 20:36:27',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'; 04/04/2025 20:36:29.4181 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 20:36:50.7694 977 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 04/04/2025 20:37:27.5940 650 ms. EXEC: update payInventory set invCreation = '2025-04-04 20:37:26',invModify = '2025-04-04 20:37:26',invUseId=0,invStatus='V' where invId = 245166 04/04/2025 20:40:40.3221 1349 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-04 20:40:38','V',4953879496135970,2025,'2025-04-04 20:40:37','457497366100327005012999',2,2,2,'O','',0,'2025-04-04 20:40:38',1,'','',0) 04/04/2025 20:43:53.3814 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 20:44:07.6660 808 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-04 20:44:06',0,'V',5622715897387320,5702229657705630,2025,'2025-04-04 20:44:06',3,1,0,4,'2025-04-04 20:59:06','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 04/04/2025 20:44:31.1157 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 20:45:32.4718 1370 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 20:46:02.6850 947 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-04 20:45:58',0,'V',5600080172326220,5710602585128220,2025,'2025-04-04 20:45:58',3,1,0,4,'2025-04-04 21:00:58','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 04/04/2025 20:47:01.4514 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 20:49:51.7264 572 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 20:49:50',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'; 04/04/2025 20:51:39.4105 659 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-04 20:51:38',0,0,'V',5096714242203830,5751933203142100,2025,'2025-04-04 20:51:38',3,'KES',1,500,500,'N',''); 04/04/2025 20:51:40.7994 785 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 20:51:39',3,42101,0,200,-1,-200,1,'O','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'; 04/04/2025 20:55:56.8770 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:00:08.6503 833 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 21:02:07.3198 702 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-04 21:02:06','V',5689206366677060,2025,'2025-04-04 21:02:05','457497390100327005012999',2,2,2,'O','',0,'2025-04-04 21:02:06',1,'','',0) 04/04/2025 21:05:23.9445 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:08:51.6646 2758 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-04 21:08:48','0230003944064',0,0,5210393294137680,14,'0000-00-00 00:00:00','0000-00-00 00:00:00') 04/04/2025 21:10:53.1099 733 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-04 21:10:52','V',4846328984147030,2025,'2025-04-04 21:10:51','457497625100327005012999',1,2,16,'I','',1,0,1,'','0230003957422',29,0) 04/04/2025 21:12:00.1708 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:16:50.7204 818 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-04 21:16:49','V',5285842039986190,2025,'2025-04-04 21:16:48','457497625100327005012999',2,2,2,'O','',0,'2025-04-04 21:16:49',1,'','0230003957422',29,0) 04/04/2025 21:27:01.4054 583 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/04/2025 21:29:19.2057 1138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:31:00.1653 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 21:31:15.5436 813 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-04 21:31:14','V',5566331702975280,2025,'2025-04-04 21:31:13','457497576200327005012999',2,2,2,'O','',0,'2025-04-04 21:31:14',1,'','',0) 04/04/2025 21:31:21.1664 1084 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 21:31:34.5414 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:33:58.6729 800 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 21:34:55.3849 1270 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:37:08.0607 953 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-04 21:37:07','V',5267733662749780,2025,'2025-04-04 21:37:06','457497782600327001012999',1,2,1,'I','',1,0,1,'','',4) 04/04/2025 21:37:08.8623 691 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/04/2025 21:41:15.4832 1136 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:41:31.7812 829 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 424083 else acvFstPayId end),acvLstPayId = 424083 where acvSftId = 952 and acvCodeId = 3 04/04/2025 21:41:32.5247 715 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2506, trcLastPrinted = '2500602506', trcLastDate = '2025-04-04 21:41:31' where trcStatus='V' and trcTerId = 17 04/04/2025 21:43:01.4572 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:43:26.8782 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:44:14.7493 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:46:00.6122 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 21:55:56.1694 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/04/2025 21:56:34.6692 1424 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 04/04/2025 21:57:04.7413 661 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/04/2025 22:07:09.1831 669 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-04 22:07:08','V',5387028075218160,2025,'2025-04-04 22:07:07','457497759600327001012999',2,2,2,'O','',0,'2025-04-04 22:07:08',1,'','',0) 04/04/2025 22:07:22.2909 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 22:28:40.1552 1228 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-04 22:28:38',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-04 22:28:38',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 22:28:38',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'; 04/04/2025 22:28:40.8927 737 ms. EXEC: update payInventory set invCreation = '2025-04-04 22:28:40',invModify = '2025-04-04 22:28:40',invUseId=0,invStatus='V' where invId = 245204 04/04/2025 22:28:50.6152 711 ms. EXEC: update tabTerminalReceipt set trcProgressive = 13729, trcLastPrinted = '2500713729', trcLastDate = '2025-04-04 22:28:49' where trcStatus='V' and trcTerId = 18 04/04/2025 22:30:16.2415 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 22:38:26.0961 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 22:38:33.8663 529 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/04/2025 22:38:35.3803 1260 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 22:38:34' where traUID = 5019259871946350 and traStatus='V' and traEnabled=1 04/04/2025 22:38:39.8353 560 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 04/04/2025 22:49:47.9584 2228 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 04/04/2025 22:55:59.6664 992 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-04 22:55:58',0,'V',4725343971209060,5035897106679830,2025,'2025-04-04 22:55:58',18,1,0,4,'2025-04-04 23:10:58','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 04/04/2025 22:57:36.1090 587 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 04/04/2025 22:59:28.6205 571 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-04 22:59:27',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'; 04/04/2025 22:59:30.3877 1685 ms. EXEC: update payInventory set invCreation = '2025-04-04 22:59:28',invModify = '2025-04-04 22:59:28',invUseId=0,invStatus='V' where invId = 245205 04/04/2025 23:01:43.6199 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:06:25.1094 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:11:27.0537 658 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-04 23:11:26' where traUID = 5670035736873170 and traStatus='V' and traEnabled=1 04/04/2025 23:11:33.8202 994 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/04/2025 23:13:27.7115 1157 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 23:13:26' where payTraUID = 5050456644590380 and payStatus='V' and payEnabled=1 04/04/2025 23:14:27.6436 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:14:57.6407 2562 ms. EXEC: update payReceipt set recCreation = '2025-04-04 23:14:54',recModify = '2025-04-04 23:14:54',recUseId=0,recStatus='V' where recId = 367673 (WAIT TIME 196 ms.) 04/04/2025 23:16:38.2181 717 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/04/2025 23:17:35.3223 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:20:17.1877 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:21:27.7480 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:21:34.2834 1092 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:26:02.1268 821 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 04/04/2025 23:26:13.2322 1585 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-04 23:26:11' where payTraUID = 4766441847311000 and payStatus='V' and payEnabled=1 04/04/2025 23:28:49.8161 919 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4685625818627180,5503472807003080,2025,'2025-04-04 23:28:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/4/2025 11:05:49 PM Date : 4/4/2025 11:28:46 PM Code : 457498314900327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 04/04/2025 23:41:21.7033 694 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 04/04/2025 23:44:24.5688 996 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-04 23:44:23',0,'V',5278979508825430,4643743356851250,2025,'2025-04-04 23:44:23',2,1,0,-1,'2025-04-05 00:44:23','S','KES',0,0,0,'','','',3,0,0) 04/04/2025 23:44:34.7816 1691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:44:39.8040 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:45:06.7661 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:45:30.1077 671 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 04/04/2025 23:45:30.1267 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:47:38.7398 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/04/2025 23:57:07.8310 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1