27/01/2025 07:59:43.3264 992 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-01-27 07:59:42','V',5234784354633580,2025,'2025-01-27 07:59:41','456822878100327005012999',1,2,16,'I','',1,0,1,'','0230003950863',158,0) 27/01/2025 08:00:20.8114 612 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 08:01:15.4278 526 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-01-27 08:01:14','V',5372586226434280,2025,'2025-01-27 08:01:14','456822887400327005012999',1,2,16,'I','',1,0,1,'','0560008421774',187,0) 27/01/2025 08:01:46.8558 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:02:05.1450 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:06:31.9698 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 08:08:07.0922 532 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-01-27 08:08:06','V',4992279049592890,2025,'2025-01-27 08:08:05','456822593100327005012999',2,2,2,'O','',0,'2025-01-27 08:08:06',1,'','',0) 27/01/2025 08:08:08.4862 759 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 08:08:07' where payTraUID = 4933103363424220 and payStatus='V' and payEnabled=1 27/01/2025 08:08:15.2897 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 08:09:08.3611 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:10:01.7557 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:16:30.7802 1032 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,0,50,-10,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,0,50,10,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,0,100,-40,-4000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,0,100,40,4000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,0,200,-8,-1600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,0,200,8,1600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-27 08:16:17',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 27/01/2025 08:17:19.1695 715 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 08:17:34.6748 1033 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 08:17:33' where traUID = 5654854046509810 and traStatus='V' and traEnabled=1 27/01/2025 08:29:02.8885 551 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/01/2025 08:33:48.8441 1154 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 08:35:02.0239 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:35:23.4462 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:37:27.3278 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:39:38.6013 613 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-01-27 08:39:37','V',4720942759247060,2025,'2025-01-27 08:39:36','456823117600327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 08:40:32.9916 1212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:51:14.5633 1173 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/01/2025 08:53:38.9065 547 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 27/01/2025 08:54:38.5663 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 08:55:03.2957 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 08:55:55.5986 647 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 09:02:16.2964 687 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-01-27 09:02:15','V',4869608299564640,2025,'2025-01-27 09:02:15','456823080100327005012999',2,2,2,'O','',0,'2025-01-27 09:02:15',1,'','',0) 27/01/2025 09:02:32.1860 1060 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/01/2025 09:02:41.5502 1654 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 27/01/2025 09:02:43.7857 1094 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 09:02:44.6473 860 ms. EXEC: update abbCards set carLastDate = '2025-01-27 09:02:43',carLastDirection='I' where carStatus='V' and carId = 106 27/01/2025 09:02:51.1166 1148 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:08:01.9498 1276 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:08:14.6033 1336 ms. EXEC: update payReceipt set recCreation = '2025-01-27 09:08:13',recModify = '2025-01-27 09:08:13',recUseId=0,recStatus='V' where recId = 346208 27/01/2025 09:08:14.7824 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:08:17.0189 661 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/01/2025 09:10:55.9148 2444 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:11:48.2907 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:12:43.4095 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:13:42.3027 564 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 27/01/2025 09:16:29.1229 596 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 09:17:46.6626 933 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-01-27 09:17:45','V',5273376162033210,2025,'2025-01-27 09:17:44','456823225400327005012999',2,2,2,'O','',0,'2025-01-27 09:17:45',1,'','',0) 27/01/2025 09:17:47.5942 928 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 09:17:48.3497 752 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 09:17:50.4061 2032 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 09:17:48' where payTraUID = 5497650262162740 and payStatus='V' and payEnabled=1 27/01/2025 09:17:52.0552 1648 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 09:17:48' where traUID = 5497650262162740 and traStatus='V' and traEnabled=1 27/01/2025 09:20:57.0996 1434 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:21:02.1820 531 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-01-27 09:21:01','V',5629379545574590,2025,'2025-01-27 09:21:00','456823235100327005012999',2,2,2,'O','',0,'2025-01-27 09:21:01',1,'','',0) 27/01/2025 09:21:05.1880 2262 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 09:21:02' where traUID = 4979151564240890 and traStatus='V' and traEnabled=1 27/01/2025 09:21:51.2126 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:23:49.1593 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:24:17.0759 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:25:42.9992 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:28:09.1026 848 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/01/2025 09:29:11.5862 952 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:31:20.1669 715 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 09:39:16.0906 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:39:22.9932 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:40:04.8091 867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:41:35.9809 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:45:16.8101 1986 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-27 09:45:14',0,16,'2025-01-27 09:45:14','','Unauthorized Transit Entry 2') 27/01/2025 09:46:37.7511 777 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:47:03.8985 836 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/01/2025 09:48:26.6186 706 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-27 09:48:25' where subId = 200 27/01/2025 09:48:27.1700 544 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-27 09:48:26','0560008336102',0,0,5337492544449670,185,'0000-00-00 00:00:00','0000-00-00 00:00:00') 27/01/2025 09:48:32.2634 909 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:51:23.2164 859 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-01-27 09:51:22','V',4984092927009760,2025,'2025-01-27 09:51:21','456823468700327005012999',2,2,2,'O','',0,'2025-01-27 09:51:22',1,'','',0) 27/01/2025 09:51:24.8885 1084 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 09:51:23' where payTraUID = 4973272338787980 and payStatus='V' and payEnabled=1 27/01/2025 09:51:28.9562 748 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 09:51:28.9822 1018 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:53:49.9082 629 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-01-27 09:53:49','V',5292958980418630,2025,'2025-01-27 09:53:47','456823562700327005012999',1,2,16,'I','',1,0,1,'','0230004098588',183,0) 27/01/2025 09:53:55.4208 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:54:49.0396 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 09:55:33.9585 534 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 09:55:34.5950 1134 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:58:32.4355 696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 09:58:37.4459 5009 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); 27/01/2025 09:58:38.8348 1374 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/01/2025 10:00:21.0960 4592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 10:02:57.2785 796 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 10:02:56' where payTraUID = 4728832209156660 and payStatus='V' and payEnabled=1 27/01/2025 10:03:03.4586 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 10:05:21.7828 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:06:03.4906 1421 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/01/2025 10:08:44.7511 1897 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1131, trcLastPrinted = '2500401131', trcLastDate = '2025-01-27 10:08:42' where trcStatus='V' and trcTerId = 4 27/01/2025 10:10:05.1407 543 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 10:10:29.1177 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 10:11:04.7364 3313 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 10:11:04.7945 2823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:11:11.0557 797 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/01/2025 10:11:11.2668 797 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/01/2025 10:12:00.1374 3171 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 27/01/2025 10:12:59.8142 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:17:42.3535 950 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:19:35.8802 544 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 10:20:00.4426 595 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 10:20:00.5176 868 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 10:20:00.5827 760 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 10:21:13.4142 3178 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 27/01/2025 10:22:11.5820 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 10:22:12.2144 687 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 10:23:00.9689 1399 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/01/2025 10:23:01.3532 1755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:23:32.8922 1082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:24:56.0256 1318 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/01/2025 10:25:58.7154 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 10:28:49.1090 655 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 27/01/2025 10:29:40.1140 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 10:30:09.3045 694 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-01-27 10:30:07',0,'V',5608266790063650,5146869948472130,2025,'2025-01-27 10:30:07',3,1,0,4,'2025-01-27 10:45:07','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 27/01/2025 10:30:19.2041 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:32:23.2568 597 ms. EXEC: update tabTerminalExtraMem SET extLoop2 = 0 where extStatus='V' and extTerId = 2 AND extPlateWaitOperator=0 27/01/2025 10:32:23.2578 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:32:30.0723 706 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 10:33:19.7774 1611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:33:24.5496 55517 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 27/01/2025 10:33:34.8985 968 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4897577183608070,5530019299861220,2025,'2025-01-27 10:33:33','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/27/2025 8:55:54 AM Date : 1/27/2025 10:33:31 AM Code : 456823215400327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 500.00 KES Coin changed : 0.00 KES Note changed : 400.00 KES',0) 27/01/2025 10:34:14.8331 605 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 10:34:15.5176 675 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 10:34:14' where payTraUID = 5013075334791880 and payStatus='V' and payEnabled=1 27/01/2025 10:34:25.7254 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:35:13.6493 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:36:55.6433 11413 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 27/01/2025 10:36:56.2117 563 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 13 order by traDateTime desc,traId desc 27/01/2025 10:37:00.5986 16307 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 27/01/2025 10:37:01.2411 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 10:39:15.2674 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-01-27 10:39:14','V',5402441420381680,2025,'2025-01-27 10:39:13','456823707100327005012999',2,2,2,'O','',0,'2025-01-27 10:39:14',1,'','',0) 27/01/2025 10:39:15.9879 578 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 10:39:32.1527 655 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 27/01/2025 10:39:35.6980 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 10:41:05.9025 793 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 27/01/2025 10:43:44.1550 1220 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 10:45:55.0463 792 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 27/01/2025 10:46:02.6353 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 11:01:36.1131 783 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 11:06:30.8856 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:10:11.2935 951 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitPlates' nr: 1 27/01/2025 11:16:13.0910 1572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:19:41.4789 549 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-27 11:19:40','V',5703654902220950,2025,'2025-01-27 11:19:40','456824078000327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 11:22:31.4342 1072 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 11:22:30' where payTraUID = 4852273083713150 and payStatus='V' and payEnabled=1 27/01/2025 11:26:22.4002 1761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:29:09.5816 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:29:18.2284 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 11:31:19.8665 1477 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:34:50.7290 725 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 11:38:11.8381 591 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-01-27 11:38:11','V',5527024647421960,2025,'2025-01-27 11:38:09','456824188900327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 11:38:14.3157 1539 ms. EXEC: update payReceipt set recCreation = '2025-01-27 11:38:12',recModify = '2025-01-27 11:38:12',recUseId=0,recStatus='V' where recId = 346255 27/01/2025 11:38:15.8458 549 ms. EXEC: update payInventory set invCreation = '2025-01-27 11:38:15',invModify = '2025-01-27 11:38:15',invUseId=0,invStatus='V' where invId = 233547 27/01/2025 11:38:25.0769 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:40:15.5055 1026 ms. EXEC: update payReceipt set recCreation = '2025-01-27 11:40:14',recModify = '2025-01-27 11:40:14',recUseId=0,recStatus='V' where recId = 346256 27/01/2025 11:40:43.6063 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:42:25.4632 1670 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-01-27 11:42:23','V',5682427329602410,2025,'2025-01-27 11:42:22','456824214200327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 11:42:51.0612 524 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 11:46:13.4442 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:46:53.9091 539 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 11:47:52.0309 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 11:47:53.9051 721 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-01-27 11:47:53','V',4872460500887950,2025,'2025-01-27 11:47:45','456824246500327005012999',1,2,16,'I','',1,0,1,'','0230003943508',39,0) 27/01/2025 11:47:58.5722 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:47:59.4538 576 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 165 order by traDateTime desc,traId desc 27/01/2025 11:48:01.4001 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:48:01.4472 1040 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 11:48:01.6023 624 ms. OPEN: select * from movtransit where traUID = 4765841339941510 and traStatus='V' 27/01/2025 11:48:12.3264 929 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:48:36.5686 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:48:54.7667 796 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 11:48:59.6329 4816 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/01/2025 11:50:53.7560 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:51:38.3077 2097 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:52:52.3701 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 11:53:19.9935 646 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/01/2025 11:54:44.6800 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 11:56:26.4778 909 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4717483752059670,5759679442829070,2025,'2025-01-27 11:56:25',' Date: 1/27/2025 11:55:57 AM Code: 456824240200327005012999 Entry Date: 1/27/2025 11:46:42 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500401143 ',0) 27/01/2025 11:59:24.1223 620 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/01/2025 11:59:49.1159 2182 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/01/2025 12:00:17.0836 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 12:00:31.6623 517 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/01/2025 12:03:46.4561 1321 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 27/01/2025 12:03:48.2013 534 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 15 27/01/2025 12:03:48.7757 574 ms. OPEN: show columns from tabAbbGroups where Field = 'abgTarId' 27/01/2025 12:03:50.1406 880 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-27 12:03:49' where subId = 16 27/01/2025 12:03:53.4068 2453 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 12:04:48.4655 910 ms. EXEC: update tabTerminalReceipt set trcProgressive = 592, trcLastPrinted = '2500600592', trcLastDate = '2025-01-27 12:04:47' where trcStatus='V' and trcTerId = 17 27/01/2025 12:05:45.8297 861 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 12:05:49.6403 3605 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 12:05:45' where traUID = 5237864408532290 and traStatus='V' and traEnabled=1 27/01/2025 12:05:53.0445 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 12:06:25.1089 501 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 12:13:07.3180 1228 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/01/2025 12:13:08.0495 675 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5296012071814160,4671076399518140,2025,'2025-01-27 12:13:07','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/27/2025 12:00:29 PM Date : 1/27/2025 12:13:04 PM Code : 456824322900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 27/01/2025 12:15:21.2633 510 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 12:15:21.8667 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 12:19:33.7835 750 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 12:19:49.5671 673 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/01/2025 12:21:52.6905 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-01-27 12:21:52',0,'V',5065370403938240,5207011769785830,2025,'2025-01-27 12:21:52',18,1,0,4,'2025-01-27 12:36:52','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 27/01/2025 12:24:34.4857 895 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-27 12:24:33',0,16,'2025-01-27 12:24:33','','Unauthorized Transit Entry 2') 27/01/2025 12:26:17.4866 750 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 12:26:16' where payTraUID = 4717531348322700 and payStatus='V' and payEnabled=1 27/01/2025 12:26:25.5770 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 12:28:25.5822 1607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 12:28:44.3187 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 12:28:47.5038 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 12:31:12.5867 1089 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 139 ms.) 27/01/2025 12:33:47.0719 1408 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 12:34:09.6980 1364 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 12:34:09.7840 1841 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 12:34:07' where traUID = 4702572362452880 and traStatus='V' and traEnabled=1 27/01/2025 12:35:29.5623 1090 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/01/2025 12:37:33.2078 1041 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-27 12:37:32' where subId = 108 27/01/2025 12:37:33.8493 630 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-27 12:37:33','0750009518612',0,0,5221985666962250,99,'0000-00-00 00:00:00','0000-00-00 00:00:00') 27/01/2025 12:37:38.6024 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 49 ms.) 27/01/2025 12:38:39.3250 754 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-01-27 12:38:38','V',5277962616780200,2025,'2025-01-27 12:38:36','456824551600327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 12:39:07.5248 1529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 12:40:34.2027 1056 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/01/2025 12:41:34.3239 637 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/01/2025 12:46:26.7724 1984 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3819, trcLastPrinted = '2500703819', trcLastDate = '2025-01-27 12:46:24' where trcStatus='V' and trcTerId = 18 27/01/2025 12:49:32.2094 1890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 12:55:56.2367 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-01-27 12:55:55','V',5550806408111400,2025,'2025-01-27 12:55:55','456824655500327001012999',1,2,1,'I','',1,0,1,'','',4) 27/01/2025 12:56:11.1758 1120 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/01/2025 12:58:14.9148 518 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-01-27 12:58:14','V',5101449758228680,2025,'2025-01-27 12:58:13','456824466000327005012999',2,2,2,'O','',0,'2025-01-27 12:58:14',1,'','',0) 27/01/2025 12:58:37.5039 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 12:58:40.9482 591 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 12:59:13.3840 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 12:59:31.4501 3234 ms. EXEC: update payInventory set invCreation = '2025-01-27 12:59:28',invModify = '2025-01-27 12:59:28',invUseId=0,invStatus='V' where invId = 233567 27/01/2025 12:59:44.4248 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:00:44.0398 783 ms. EXEC: update payInventory set invCreation = '2025-01-27 13:00:43',invModify = '2025-01-27 13:00:43',invUseId=0,invStatus='V' where invId = 233569 27/01/2025 13:00:44.1979 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:04:22.1912 531 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4727140813565590,5521161833822320,2025,'2025-01-27 13:04:21','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/27/2025 11:51:33 AM Date : 1/27/2025 1:04:20 PM Code : 456824269300327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 27/01/2025 13:05:33.5106 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1 ms.) 27/01/2025 13:06:55.6767 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:06:59.5663 1103 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 13:07:07.4376 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:07:46.9570 1493 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 1 ms.) 27/01/2025 13:10:18.0013 1070 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 27/01/2025 13:10:18.0063 929 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:10:18.1243 1148 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 13:12:13.2266 658 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-27 13:12:12',0,0,'V',4888021321230410,5277962616780200,2025,'2025-01-27 13:12:12',3,'KES',1,50,50,'N',''); 27/01/2025 13:12:51.8705 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:12:52.4669 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:13:14.9480 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:13:48.8467 891 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-01-27 13:13:47','V',4703684385205710,2025,'2025-01-27 13:13:42','456824762200327001012999',1,2,1,'I','',1,0,1,'','',4) 27/01/2025 13:16:56.8839 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:18:54.6669 1322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:20:21.0047 1037 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5301487846747680,5223331970614560,2025,'2025-01-27 13:20:19',' Date: 1/27/2025 1:20:19 PM Code: 456823956000327005012999 Entry Date: 1/27/2025 10:59:20 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 # 2500703824 ',0) 27/01/2025 13:21:13.1056 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-01-27 13:21:12','V',4714798544344210,2025,'2025-01-27 13:21:10','456824807000327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 13:21:14.5186 770 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/01/2025 13:21:21.0660 618 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 13:25:01.0034 895 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-01-27 13:25:00',0,'V',4793101862251210,4872682042803260,2025,'2025-01-27 13:25:00',18,1,0,4,'2025-01-27 13:40:00','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 27/01/2025 13:25:17.7026 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:27:05.0257 682 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 13:27:05.7962 513 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 13:27:05' where traUID = 4872682042803260 and traStatus='V' and traEnabled=1 27/01/2025 13:30:45.9868 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:31:56.8373 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:32:01.8367 2751 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 27/01/2025 13:32:51.9452 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:35:57.4955 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:36:38.9343 913 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/01/2025 13:36:46.1231 909 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3828, trcLastPrinted = '2500703828', trcLastDate = '2025-01-27 13:36:45' where trcStatus='V' and trcTerId = 18 27/01/2025 13:36:46.7375 610 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5612594437548370,5318969606449000,2025,'2025-01-27 13:36:46',' Date: 1/27/2025 1:36:45 PM Code: 456824565800327005012999 Entry Date: 1/27/2025 12:40:58 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 # 2500703828 ',0) 27/01/2025 13:37:00.2665 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:37:28.0101 507 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 27/01/2025 13:37:38.5652 2001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:39:48.1470 671 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4810464804179630,5478142667854060,2025,'2025-01-27 13:39:47',' Data: 1/27/2025 1:36:23 PM Codice: 456824371100327005012999 Ingresso: 1/27/2025 12:08:31 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500600596 ',0) 27/01/2025 13:40:36.6946 553 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 13:40:36' where payTraUID = 4810464804179630 and payStatus='V' and payEnabled=1 27/01/2025 13:40:41.5828 817 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:41:02.9632 645 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 13:41:02' where payTraUID = 5612594437548370 and payStatus='V' and payEnabled=1 27/01/2025 13:41:08.3138 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:42:03.0384 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:42:32.8114 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:48:03.0607 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:50:40.8885 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:50:43.3301 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:51:17.8593 541 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-01-27 13:51:17','V',4653357154248720,2025,'2025-01-27 13:51:16','456824858200327005012999',2,2,2,'O','',0,'2025-01-27 13:51:17',1,'','',0) 27/01/2025 13:51:25.7496 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 13:51:41.7163 752 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-27 13:51:40' where subId = 14 27/01/2025 13:51:43.7686 1437 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 13:51:42' where payTraUID = 5015078503944230 and payStatus='V' and payEnabled=1 27/01/2025 13:52:18.5800 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:52:18.6580 1931 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-27 13:52:16',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 27/01/2025 13:52:39.5720 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:53:27.6052 1113 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:53:52.0266 1376 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-01-27 13:50:26',12,'V',4672985449164620,5530739444908350,2025,'2025-01-27 13:50:26',17,1,0,4,'2025-01-27 14:05:26','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 27/01/2025 13:55:17.7169 1342 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 13:55:43.4852 1071 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/01/2025 13:56:08.1177 817 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-01-27 13:56:07','V',4628192151923560,2025,'2025-01-27 13:56:06','456825016600327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 13:56:23.0517 684 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/01/2025 13:56:37.1621 941 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 398966 else acvFstPayId end),acvLstPayId = 398966 where acvSftId = 889 and acvCodeId = 3 27/01/2025 13:58:27.2959 1759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:00:13.9834 687 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1153, trcLastPrinted = '2500401153', trcLastDate = '2025-01-27 14:00:13' where trcStatus='V' and trcTerId = 4 27/01/2025 14:00:14.7279 740 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5406651347255080,5606624622549200,2025,'2025-01-27 14:00:13',' Date: 1/27/2025 1:59:43 PM Code: 456824832900327005012999 Entry Date: 1/27/2025 1:25:29 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 # 2500401153 ',0) 27/01/2025 14:06:28.8635 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:07:50.7764 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 14:08:52.9090 985 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 27/01/2025 14:10:57.1914 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 14:13:53.6766 532 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-01-27 14:13:52',0,'V',5043641032800840,4874001020101610,2025,'2025-01-27 14:13:52',3,1,0,4,'2025-01-27 14:28:52','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 27/01/2025 14:14:11.2884 1613 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-01-27 14:14:09',0,'V',5691783946407390,4816869768431340,2025,'2025-01-27 14:14:09',18,1,0,4,'2025-01-27 14:29:09','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 81 ms.) 27/01/2025 14:14:12.1850 654 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4816869768431340,5691783946407390,2025,'2025-01-27 14:14:11',' Date: 1/27/2025 2:14:09 PM Code: 456824818900327001012999 Entry Date: 1/27/2025 1:23:09 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500703836 ',0) 27/01/2025 14:15:18.5755 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 14:16:30.3045 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:16:32.2708 1696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:17:02.3920 811 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-01-27 14:17:01','V',4752875012244460,2025,'2025-01-27 14:16:53','456825141300327001012999',1,2,1,'I','',1,0,1,'','',4) 27/01/2025 14:17:15.2696 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:17:15.3536 1113 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 14:17:16.4064 704 ms. OPEN: select * from opeShifts where sftId = 889 and sftStatus = 'V' 27/01/2025 14:18:14.5823 719 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-01-27 14:18:13',0,'V',5545115109707170,5219543169101170,2025,'2025-01-27 14:18:13',18,1,0,4,'2025-01-27 14:33:13','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 27/01/2025 14:18:28.2205 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 14:19:02.8347 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:20:16.0768 1415 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 14:22:20.2960 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 14:22:27.1536 651 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/01/2025 14:24:29.1284 1193 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:24:51.4574 626 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1156, trcLastPrinted = '2500401156', trcLastDate = '2025-01-27 14:24:50' where trcStatus='V' and trcTerId = 4 27/01/2025 14:27:12.7811 896 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 14:30:37.4033 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 14:31:31.2984 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:31:40.9279 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:31:48.7011 1051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:32:36.5521 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 14:33:24.7005 1550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:33:45.3343 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:33:55.1809 979 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-27 14:33:54',0,0,'V',5271434657955200,4838850207489230,2025,'2025-01-27 14:33:54',3,'KES',-1,50,-50,'N',''); 27/01/2025 14:34:25.3311 753 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 14:34:26.2327 898 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 14:34:27.3244 973 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 14:34:26' where traUID = 5525060544924540 and traStatus='V' and traEnabled=1 27/01/2025 14:37:25.1355 865 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-01-27 14:37:24','V',5294695407925270,2025,'2025-01-27 14:37:23','456824497100327005012999',2,2,2,'O','',0,'2025-01-27 14:37:24',1,'','',0) 27/01/2025 14:37:26.0241 717 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 14:37:25' where payTraUID = 5673119821191720 and payStatus='V' and payEnabled=1 27/01/2025 14:37:29.5735 866 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 14:38:15.2041 1360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:38:37.2699 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 14:41:02.9585 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:41:44.9787 1471 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/01/2025 14:45:51.2282 798 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-01-27 14:45:50','V',5453719135200320,2025,'2025-01-27 14:45:49','456825180500327005012999',2,2,2,'O','',0,'2025-01-27 14:45:50',1,'','',0) 27/01/2025 14:46:07.7753 1481 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:46:38.4939 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-01-27 14:46:37','V',5327231362026780,2025,'2025-01-27 14:46:37','456825319700327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 14:47:38.2259 529 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 14:47:37' where payTraUID = 5563132958066430 and payStatus='V' and payEnabled=1 27/01/2025 14:48:17.8864 2189 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-27 14:48:15',4,1,'2025-01-27 14:48:15','456825243200327005012999','Payed (Credit Card ) Ticket ') 27/01/2025 14:51:56.0485 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:54:10.2515 1367 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:54:16.7088 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:58:23.5363 770 ms. EXEC: update payInventory set invCreation = '2025-01-27 14:58:22',invModify = '2025-01-27 14:58:22',invUseId=0,invStatus='V' where invId = 233586 27/01/2025 14:58:36.4159 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 14:59:48.8535 1743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:00:53.5928 1796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:01:59.5610 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:08:06.0728 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:09:48.6584 1185 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-27 15:09:47',0,16,'2025-01-27 15:09:47','','Unauthorized Transit Entry 2') 27/01/2025 15:14:25.7032 562 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-27 15:14:25',0,0,'V',5319716119581430,5104888162465610,2025,'2025-01-27 15:14:25',3,'KES',1,50,50,'N',''); 27/01/2025 15:15:01.2950 1753 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 15:14:59' where traUID = 5752711823483150 and traStatus='V' and traEnabled=1 27/01/2025 15:17:01.0188 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:17:05.2056 993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:21:37.2291 847 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-01-27 15:21:36','V',5001050455024530,2025,'2025-01-27 15:21:35','456825529500327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 15:21:47.5810 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:22:01.4162 1685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:22:03.2725 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:23:39.2385 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:24:26.3920 1763 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-01-27 15:24:24','V',5057795626587540,2025,'2025-01-27 15:24:23','456825546300327001012999',1,2,1,'I','',1,0,1,'','',4) (WAIT TIME 18 ms.) 27/01/2025 15:26:11.8783 779 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-01-27 15:26:11','V',5076385824892110,2025,'2025-01-27 15:26:10','456825557000327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 15:26:50.8833 880 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 15:27:51.2496 2115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:29:25.2203 1183 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:31:26.6983 3146 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 15:31:51.2457 1509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:34:29.8926 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:36:05.5324 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:40:11.5406 519 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-01-27 15:40:10',0,'V',5079324383425900,5171515912959590,2025,'2025-01-27 15:40:10',2,1,0,-1,'2025-01-27 16:40:10','S','KES',0,0,0,'','','',3,0,0) 27/01/2025 15:40:12.3962 737 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-01-27 15:40:11','V',4812635242954730,2025,'2025-01-27 15:40:10','456822537900327005012999',2,2,2,'O','',0,'2025-01-27 15:40:11',1,'','0230003957444',26,0) 27/01/2025 15:40:13.9452 1100 ms. EXEC: update abbCards set carLastDate = '2025-01-27 15:40:12',carLastDirection='O' where carStatus='V' and carId = 26 27/01/2025 15:40:14.5036 555 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 15:40:46.9532 857 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-01-27 15:37:21',12,'V',5148966093229500,5620736142387550,2025,'2025-01-27 15:37:21',17,1,0,4,'2025-01-27 15:52:21','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 27/01/2025 15:40:48.5303 994 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399021 else acvFstPayId end),acvLstPayId = 399021 where acvSftId = 892 and acvCodeId = 3 27/01/2025 15:41:50.2314 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:42:32.8479 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:44:03.8316 701 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 15:44:22.5260 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:44:50.3956 1185 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-01-27 15:44:49','V',4659150886199590,2025,'2025-01-27 15:44:47','456825016600327005012999',2,2,2,'O','',0,'2025-01-27 15:44:49',1,'','',0) 27/01/2025 15:45:00.8356 3636 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-27 15:44:57',0,0,'V',5419741385871850,4643241647119520,2025,'2025-01-27 15:44:57',3,'KES',1,50,50,'N',''); 27/01/2025 15:45:29.0754 683 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 15:45:28' where traUID = 5057795626587540 and traStatus='V' and traEnabled=1 27/01/2025 15:47:14.5648 1641 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-01-27 15:47:11',0,'V',5243296071664930,5295902508703780,2025,'2025-01-27 15:47:11',3,1,0,4,'2025-01-27 16:02:11','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 27/01/2025 15:47:15.9797 895 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5295902508703780,5243296071664930,2025,'2025-01-27 15:47:15','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/27/2025 2:45:43 PM Date : 1/27/2025 3:47:11 PM Code : 456825314300327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 27/01/2025 15:47:16.8653 884 ms. EXEC: update payReceipt set recCreation = '2025-01-27 15:47:15',recModify = '2025-01-27 15:47:15',recUseId=0,recStatus='V' where recId = 346373 27/01/2025 15:47:18.2483 995 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-27 15:47:16',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 27/01/2025 15:48:13.0598 892 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:49:15.6116 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:49:40.9024 1264 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 15:58:04.6435 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 15:58:46.5554 3531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:02:50.2281 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 16:02:55.0063 729 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 16:07:49.9191 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:10:44.9699 690 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 16:15:43.0716 1393 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:16:13.5169 1730 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-01-27 16:16:11','V',5061679186137950,2025,'2025-01-27 16:16:10','456825663900327005012999',2,2,2,'O','',0,'2025-01-27 16:16:11',1,'','',0) 27/01/2025 16:16:16.2117 2649 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 16:16:16.4729 1199 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:16:17.0683 696 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 16:16:16' where traUID = 5276360331172390 and traStatus='V' and traEnabled=1 27/01/2025 16:16:25.1476 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 16:17:26.7728 517 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5669081374864850,5332332009180340,2025,'2025-01-27 16:17:26',' Date: 1/27/2025 4:17:25 PM Code: 456825697400327005012999 Entry Date: 1/27/2025 3:49:34 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 # 2500703859 ',0) 27/01/2025 16:18:21.7975 686 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 16:18:26.1984 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 16:19:21.1971 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:19:28.4579 2349 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 16:19:25' where traUID = 5725978905810830 and traStatus='V' and traEnabled=1 27/01/2025 16:20:52.2798 1033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:20:54.3732 542 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-27 16:20:53',3,42101,0,50,2,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 27/01/2025 16:22:19.7482 1964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:22:38.4777 704 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1164, trcLastPrinted = '2500401164', trcLastDate = '2025-01-27 16:22:37' where trcStatus='V' and trcTerId = 4 27/01/2025 16:22:46.9193 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 16:24:46.4401 1212 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 16:24:45' where traUID = 4968683524196080 and traStatus='V' and traEnabled=1 27/01/2025 16:24:53.0755 2299 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:25:01.1759 827 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 16:27:02.2407 1845 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-01-27 16:27:00','V',4893854017970940,2025,'2025-01-27 16:26:59','456825250500327005012999',2,2,2,'O','',0,'2025-01-27 16:27:00',1,'','',0) 27/01/2025 16:28:49.4692 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:28:49.9165 1431 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 16:29:52.7894 1710 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/01/2025 16:32:51.6958 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 16:40:18.5679 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:45:02.4113 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:46:43.8890 790 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 27/01/2025 16:46:43.8890 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:47:00.8333 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:47:14.3493 623 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-01-27 16:47:13','V',5623884101126040,2025,'2025-01-27 16:47:12','456825675400327005012999',2,2,2,'O','',0,'2025-01-27 16:47:13',1,'','',0) 27/01/2025 16:47:16.5407 1563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:47:55.7129 1310 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 16:50:27.2240 570 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 16:51:44.0132 575 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 27/01/2025 16:52:49.9682 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:02:08.2980 722 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 17:03:49.0282 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 17:03:50.7123 1306 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 17:03:51.3287 605 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 17:04:08.3221 971 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 17:07:07.4956 584 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-01-27 17:07:06','V',5629425535099680,2025,'2025-01-27 17:07:05','456823727000327005012999',2,2,2,'O','',0,'2025-01-27 17:07:06',1,'','0230004101179',8,0) 27/01/2025 17:07:11.0900 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 17:07:11.5103 511 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 17:08:47.0150 567 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 27/01/2025 17:09:25.2045 625 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-27 17:09:24',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'; 27/01/2025 17:10:02.8306 794 ms. EXEC: update payReceipt set recCreation = '2025-01-27 17:10:02',recModify = '2025-01-27 17:10:02',recUseId=0,recStatus='V' where recId = 346414 27/01/2025 17:11:14.0471 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:11:21.0988 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 17:11:51.0107 516 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 17:11:50' where payTraUID = 5657954890925820 and payStatus='V' and payEnabled=1 27/01/2025 17:11:56.3713 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 17:13:05.6225 1213 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:14:22.2176 2027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:14:28.2656 785 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-01-27 17:14:27','V',5383862477951250,2025,'2025-01-27 17:14:26','456826013800327005012999',2,2,2,'O','',0,'2025-01-27 17:14:27',1,'','',0) 27/01/2025 17:14:34.5888 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 17:15:35.1783 832 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:16:36.9495 651 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/01/2025 17:19:18.0800 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:21:35.2565 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:27:12.4858 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:36:41.9823 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 17:36:57.2755 644 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 17:36:58.8125 1363 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:37:24.2365 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:37:27.6848 907 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-27 17:37:26','0230003943861',0,0,5561328543914670,31,'0000-00-00 00:00:00','0000-00-00 00:00:00') 27/01/2025 17:37:42.2955 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:38:10.7375 1129 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:39:01.8756 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 17:39:01.9897 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:39:08.8993 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:39:18.6628 542 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/01/2025 17:42:48.7239 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:48:15.8569 633 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456826247800327005012999' 27/01/2025 17:49:51.8419 1839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:53:28.3244 1846 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-01-27 17:53:26',0,'V',5547854203323560,5732248433128600,2025,'2025-01-27 17:53:26',18,1,0,4,'2025-01-27 18:08:26','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 27/01/2025 17:53:36.1556 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:55:14.5822 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:56:20.3751 1092 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:57:00.0706 1156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 17:58:33.8812 1490 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:01:02.6014 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:01:17.9967 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:02:44.8586 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 18:03:44.2693 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:10:42.1911 968 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 18:10:41' where traUID = 5744323311611800 and traStatus='V' and traEnabled=1 27/01/2025 18:14:36.4128 595 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 27/01/2025 18:14:38.0939 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:17:22.1694 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:17:39.9192 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:25:17.0542 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:27:35.8398 1320 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:30:05.2284 624 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 18:30:07.7671 590 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 27/01/2025 18:30:15.6714 1390 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:31:07.1848 529 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 27/01/2025 18:31:07.8392 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:31:57.8916 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:33:09.0501 632 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-01-27 18:33:08','V',4816378461940050,2025,'2025-01-27 18:33:07','456826678700327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 18:34:43.5371 2314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:35:45.5965 1145 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:36:10.7983 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:37:17.2887 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:38:34.5912 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 18:38:39.1923 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:39:54.6667 510 ms. EXEC: update payReceipt set recCreation = '2025-01-27 18:39:54',recModify = '2025-01-27 18:39:54',recUseId=0,recStatus='V' where recId = 346432 27/01/2025 18:43:54.0824 994 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 18:44:45.1434 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:44:58.7415 607 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-27 18:44:58',0,16,'2025-01-27 18:44:58','','Unauthorized Transit Entry 2') 27/01/2025 18:52:15.7851 1168 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/01/2025 18:54:33.4949 511 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 18:54:32' where traUID = 4745642830803410 and traStatus='V' and traEnabled=1 27/01/2025 18:57:48.2329 1491 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:58:01.2695 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:59:55.3547 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 18:59:59.2923 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:00:09.4110 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:01:06.7203 1391 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:01:46.0185 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:03:40.6009 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:05:03.6343 551 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 27/01/2025 19:08:47.1544 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:11:18.8556 1151 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 19:11:17' where traUID = 5070645881582790 and traStatus='V' and traEnabled=1 27/01/2025 19:16:32.3868 566 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 19:18:09.1664 1180 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3891, trcLastPrinted = '2500703891', trcLastDate = '2025-01-27 19:18:07' where trcStatus='V' and trcTerId = 18 27/01/2025 19:18:53.0967 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 19:19:56.0206 661 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/01/2025 19:20:08.8072 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 19:20:09.7138 1471 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:21:17.0677 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 19:22:39.5217 899 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5647717094609180,5688566380022080,2025,'2025-01-27 19:22:38','---------------------------------- %The Mall P0006032390 Canceled payment ---------------------------------- POF Entry : 1/27/2025 6:49:41 PM Date : 1/27/2025 7:22:37 PM Code : 456826778100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 0.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',1) 27/01/2025 19:22:51.5938 964 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-01-27 19:22:50','V',5106328078556280,2025,'2025-01-27 19:22:48','456820000600327003229999',22,22,3,'I','',1,0,1,'','',2) 27/01/2025 19:23:10.0321 615 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-01-27 19:23:06',0,'V',5193176808065210,5106328078556280,2025,'2025-01-27 19:23:06',3,1,0,2,'2025-01-27 19:38:06','C','KES',500,0,0,'',' ',' ',98,500,0,0,'',0,0) 27/01/2025 19:24:28.9807 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:26:42.9181 553 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/01/2025 19:27:07.6956 1436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:27:47.0629 1587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:29:58.2284 1592 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5347156589459390,4835557780014070,2025,'2025-01-27 19:29:56',' Date: 1/27/2025 7:29:56 PM Code: 456826555000327005012999 Entry Date: 1/27/2025 6:12:30 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500703892 ',0) 27/01/2025 19:31:21.1557 934 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-27 19:31:20' where payTraUID = 5347156589459390 and payStatus='V' and payEnabled=1 27/01/2025 19:31:26.7855 684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 19:33:28.5007 2028 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-01-27 19:33:26',0,'V',5213327768045250,4816378461940050,2025,'2025-01-27 19:33:26',18,1,0,4,'2025-01-27 19:48:26','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 27/01/2025 19:33:29.2922 742 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3894, trcLastPrinted = '2500703894', trcLastDate = '2025-01-27 19:33:28' where trcStatus='V' and trcTerId = 18 27/01/2025 19:33:42.0787 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:33:49.2735 1093 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 19:35:39.5318 523 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/01/2025 19:38:45.9964 756 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 19:38:45' where traUID = 5694433567572900 and traStatus='V' and traEnabled=1 27/01/2025 19:38:46.3316 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:41:46.3697 815 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 19:42:05.4004 629 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-01-27 19:42:04',0,'V',4763418200120670,5528620446998890,2025,'2025-01-27 19:42:04',18,1,0,4,'2025-01-27 19:57:04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 4 ms.) 27/01/2025 19:43:45.4292 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:44:23.4275 552 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1172, trcLastPrinted = '2500401172', trcLastDate = '2025-01-27 19:44:22' where trcStatus='V' and trcTerId = 4 27/01/2025 19:44:56.6797 1398 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/01/2025 19:45:03.2391 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:45:11.7938 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 19:45:34.3058 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 19:50:08.4797 1463 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399141 else acvFstPayId end),acvLstPayId = 399141 where acvSftId = 892 and acvCodeId = 3 27/01/2025 19:50:11.3226 924 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100 27/01/2025 19:51:55.9804 1142 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-27 19:51:54','0750009372622',0,0,5114843839791570,112,'0000-00-00 00:00:00','0000-00-00 00:00:00') 27/01/2025 19:54:34.0819 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:06:10.6753 642 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-01-27 20:06:09',0,'V',4765123644309300,4737094874810800,2025,'2025-01-27 20:06:09',2,1,0,-1,'2025-01-27 21:06:09','S','KES',0,0,0,'','','',3,0,0) 27/01/2025 20:08:33.9189 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:10:05.1318 670 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 20:10:05.1318 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:10:23.1598 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 20:10:55.2822 821 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-01-27 20:10:53',0,'V',4879847495903910,5730933488141730,2025,'2025-01-27 20:10:53',3,1,0,4,'2025-01-27 20:25:53','C','KES',50,0,0,'',' ',' ',98,50,0,0,'',0,0) 27/01/2025 20:14:02.1869 1009 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399156 else acvFstPayId end),acvLstPayId = 399156 where acvSftId = 889 and acvCodeId = 3 27/01/2025 20:21:11.6546 1020 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-27 20:21:10' where subId = 198 27/01/2025 20:21:12.2670 574 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-27 20:21:11','0230004098588',0,0,5721678008807440,183,'0000-00-00 00:00:00','0000-00-00 00:00:00') 27/01/2025 20:21:20.3163 749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 20:25:54.9105 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:28:31.9593 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 20:32:42.1322 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:35:08.9281 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 20:35:16.2850 1738 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-01-27 20:35:14',0,'V',4673928319869790,5475462228082060,2025,'2025-01-27 20:35:14',18,1,0,4,'2025-01-27 20:50:14','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 27/01/2025 20:35:17.0295 616 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3906, trcLastPrinted = '2500703906', trcLastDate = '2025-01-27 20:35:16' where trcStatus='V' and trcTerId = 18 27/01/2025 20:39:06.3695 1000 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/01/2025 20:40:06.8439 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:40:40.3032 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:43:10.2853 2941 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-01-27 20:43:07','V',4774350048247720,2025,'2025-01-27 20:43:06','456827370200327005012999',2,2,2,'O','',0,'2025-01-27 20:43:07',1,'','0230003939927',164,0) (WAIT TIME 13 ms.) 27/01/2025 20:43:12.5538 1887 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 20:43:10' where traUID = 4752146312664730 and traStatus='V' and traEnabled=1 27/01/2025 20:44:23.3050 1936 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 20:44:43.1062 1643 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 27/01/2025 20:45:35.3130 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 20:45:50.0478 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:48:18.3868 1209 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 20:48:31.3615 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 20:49:59.2551 1219 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:52:03.4519 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:52:25.2715 1344 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-01-27 20:52:23','V',5244079923892210,2025,'2025-01-27 20:52:21','456827514100327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 20:52:45.1257 1631 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 27/01/2025 20:54:20.6635 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:56:16.4868 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:57:03.3980 1074 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 20:57:55.3847 1536 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-01-27 20:57:53','V',5679869172473910,2025,'2025-01-27 20:57:53','456827547300327005012999',1,2,16,'I','',1,0,1,'','',4) 27/01/2025 20:59:16.5058 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 20:59:59.6006 868 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 21:05:33.9226 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:08:08.2716 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:11:01.8564 1092 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/01/2025 21:11:03.3144 1941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:11:03.3164 1060 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-01-27 21:11:02','V',5726310825602460,2025,'2025-01-27 21:11:00','456827430800327001012999',2,2,2,'O','',0,'2025-01-27 21:11:02',1,'','',0) 27/01/2025 21:11:03.8367 508 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 21:11:05.1366 1291 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 27/01/2025 21:12:39.6016 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:13:03.4855 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:13:29.6090 1287 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/01/2025 21:18:34.7405 595 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/01/2025 21:19:12.9360 575 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-27 21:19:12','V',5146355054537630,2025,'2025-01-27 21:19:11','456827547300327005012999',2,2,2,'O','',0,'2025-01-27 21:19:12',1,'','',0) 27/01/2025 21:19:26.5401 574 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/01/2025 21:23:52.7847 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:23:55.5836 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:25:35.2421 633 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 21:25:51.2447 693 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-27 21:25:50','V',4934541226015830,2025,'2025-01-27 21:25:49','456827559800327005012999',2,2,2,'O','',0,'2025-01-27 21:25:50',1,'','',0) 27/01/2025 21:29:58.3436 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:31:07.7839 545 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 27/01/2025 21:31:44.6005 1378 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 21:32:11.0901 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:33:30.1679 698 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 21:33:29' where traUID = 5612736955721300 and traStatus='V' and traEnabled=1 27/01/2025 21:40:52.7201 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 21:40:53.4716 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:42:29.0194 562 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 27/01/2025 21:43:02.1645 916 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 27/01/2025 21:44:48.6835 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:53:26.3529 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:56:35.4881 1021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:58:33.8420 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 21:58:37.7736 652 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-27 20:58:37') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-27 21:58:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-27 21:58:36' and (resAreId = 1 or resAreId <= 0) nr: 0 27/01/2025 22:04:57.3719 2291 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/01/2025 22:06:24.6421 536 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 399194 else acvFstPayId end),acvLstPayId = 399194 where acvSftId = 892 and acvCodeId = 3 27/01/2025 22:06:43.2755 966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:08:02.1652 1139 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 22:08:10.9260 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:09:57.8934 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:10:13.8310 1263 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/01/2025 22:11:15.5081 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 22:11:15.6022 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:12:00.4671 1641 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 22:12:34.3447 975 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:14:22.0736 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:14:29.7537 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:20:21.1932 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:20:33.2092 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:20:37.9454 1100 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:22:26.2436 997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:23:57.6466 2334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:24:04.9324 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 22:25:00.1543 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 22:25:49.8234 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 22:26:42.6046 2247 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:26:58.8775 637 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/01/2025 22:27:11.8391 1466 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:27:40.8825 739 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5344890424666440,5327568519201240,2025,'2025-01-27 22:27:40',' Date: 1/27/2025 10:27:39 PM Code: 456827718100327005012999 Entry Date: 1/27/2025 9:26:21 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 150.00 KES ______________________________ Paid: 150.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500703926 ',0) 27/01/2025 22:27:50.7031 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 22:29:59.6601 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:32:01.3723 604 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/01/2025 22:32:05.0918 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 22:32:20.1108 554 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 27/01/2025 22:32:39.3656 2498 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 22:32:44.9343 1039 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:39:29.8239 591 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 22:40:05.7899 1758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:42:15.1072 607 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 22:42:14' where traUID = 4831627605298660 and traStatus='V' and traEnabled=1 27/01/2025 22:46:57.4666 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:48:33.4186 2880 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 27/01/2025 22:49:09.7748 1378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:50:53.6782 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:51:49.3593 1006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:54:38.6172 1345 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:54:53.9244 1489 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:00.1076 2500 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:00.1086 1768 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/01/2025 22:55:06.7830 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:17.6893 3851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:17.6903 3290 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 22:55:23.3251 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:28.0162 2115 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:30.3267 1603 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 27/01/2025 22:55:45.3137 1360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:47.9385 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:51.4488 2798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:55:55.6936 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:56:24.7871 3565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:57:37.0643 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:59:07.2284 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 22:59:41.4082 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:05:51.3890 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:06:27.2860 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:06:44.5015 541 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 23:08:19.8981 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:11:02.2474 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:13:08.1544 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:13:11.3846 1138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:17:23.4788 932 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 23:17:22' where traUID = 5195635849216310 and traStatus='V' and traEnabled=1 27/01/2025 23:17:31.3470 2038 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:17:49.8804 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:18:22.4901 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 23:18:48.9097 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:18:50.1576 749 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/01/2025 23:18:50.1576 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:19:31.3811 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:19:44.5239 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:20:20.3648 919 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-27 23:20:19' where traUID = 4684746228222790 and traStatus='V' and traEnabled=1 27/01/2025 23:20:21.0042 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:20:25.9045 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/01/2025 23:22:13.5243 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:22:54.2004 950 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 27/01/2025 23:25:10.2922 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:26:34.8606 1803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:26:34.8646 1602 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/01/2025 23:26:40.4984 1513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:26:42.3606 1151 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:26:57.9210 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:27:05.1208 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:28:17.1418 1904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:29:45.4918 1410 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:30:40.2903 621 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 27/01/2025 23:34:29.8154 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:34:48.9972 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:34:51.1167 617 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 27/01/2025 23:34:57.6790 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:35:17.5223 2830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:37:09.4599 1694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:38:31.1334 5085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:41:36.4501 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:48:22.1359 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:48:23.7910 1364 ms. EXEC: update payReceipt set recCreation = '2025-01-27 23:48:22',recModify = '2025-01-27 23:48:22',recUseId=0,recStatus='V' where recId = 346519 (WAIT TIME 213 ms.) 27/01/2025 23:49:20.1566 650 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-01-27 23:49:18',0,'V',5332040115797960,5448730435881920,2025,'2025-01-27 23:49:18',3,1,0,4,'2025-01-28 00:04:18','C','KES',100,0,0,'',' ',' ',98,100,0,0,'',0,0) 27/01/2025 23:52:18.5886 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:55:17.8342 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:55:46.5013 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:56:17.0437 2387 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 27/01/2025 23:59:50.3450 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1