11/12/2024 00:10:36.9777 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 00:13:31.6632 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 00:27:29.4915 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 00:27:31.7110 1666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 00:31:28.7284 1150 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 00:40:42.1044 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 00:49:43.9508 1213 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 00:50:47.6906 1999 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 11/12/2024 00:59:39.1560 1834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:05:18.0508 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:16:24.7811 1480 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/12/2024 01:20:37.1448 955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:27:03.0163 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:37:45.9496 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:38:51.1464 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:39:02.2479 1320 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:54:32.6124 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:56:44.4571 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 01:56:46.8567 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 02:21:24.0689 778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 02:28:31.5454 965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 02:34:52.7747 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 03:08:41.5878 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 03:27:13.7906 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 03:28:49.6721 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 03:29:28.4602 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 03:40:06.9615 1052 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 03:41:21.0213 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 03:42:08.7724 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 03:43:20.0904 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 03:56:34.5015 805 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/12/2024 03:59:03.9090 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 04:03:10.0004 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 04:04:01.9334 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 04:09:48.5614 528 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/12/2024 04:11:30.7301 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 04:13:05.8681 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 04:15:03.8044 1278 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 04:16:00.4935 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 04:23:56.0332 679 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/12/2024 04:29:14.2112 586 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 04:29:15.1778 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 04:31:00.1484 966 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 04:31:02.2848 1177 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 04:33:26.6349 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 05:02:38.8661 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 05:16:16.5909 505 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/12/2024 05:18:13.2553 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 05:39:30.2279 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 05:39:30.2289 554 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/12/2024 05:40:32.8010 1545 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/12/2024 05:55:04.6612 604 ms. EXEC: update payInventory set invCreation = '2024-12-11 05:55:04',invModify = '2024-12-11 05:55:04',invUseId=0,invStatus='V' where invId = 224447 11/12/2024 05:56:36.0677 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 05:57:50.9891 879 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 06:38:11.5756 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 06:42:35.4270 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:00:22.1593 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:00:30.6210 998 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/12/2024 07:01:30.0149 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:01:31.7581 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 07:11:07.6943 1887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:11:15.1213 628 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/12/2024 07:17:11.6991 867 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/12/2024 07:19:02.2194 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:19:26.7619 591 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 07:21:47.0502 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:22:02.5366 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:22:35.8260 966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:23:36.0835 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:32:06.5147 1083 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/12/2024 07:35:58.1915 627 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/12/2024 07:46:09.0502 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 07:48:50.0245 895 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 07:49:33.0564 536 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 797983 11/12/2024 07:51:08.3975 799 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 07:59:12.8024 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 08:00:51.3016 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 08:01:14.7664 2038 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/12/2024 08:07:57.9135 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 08:09:07.5713 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 08:14:15.6464 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 08:17:16.1008 677 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/12/2024 08:21:35.2490 833 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 08:22:56.9069 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 08:27:03.5307 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 08:35:25.8045 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 08:38:42.2285 1344 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-11 08:38:40',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-11 08:38:40',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/12/2024 08:40:42.2703 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 08:49:00.9355 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 08:50:41.7353 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 08:51:33.9905 1369 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 08:57:52.1197 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 09:09:16.8041 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 09:10:28.9416 1112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 09:25:30.6378 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 09:26:39.8674 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 09:26:54.9696 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 09:32:50.3865 687 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 09:37:49.2575 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 09:38:11.1302 728 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 09:38:13.1435 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 09:42:46.4443 774 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 09:44:26.8168 655 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4869831560094970,5558199592124970,2024,'2024-12-11 09:44:26',' Date: 12/11/2024 9:44:25 AM Code: 456353255200327005012999 Entry Date: 12/11/2024 9:02:32 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400752982 ',0) 11/12/2024 09:44:40.0887 698 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,'2024-12-11 09:44:39','V',5648540906177270,2024,'2024-12-11 09:44:38','456353507800327001012999',1,2,1,'I','',1,0,1,'','',4) 11/12/2024 09:44:43.3579 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 09:47:34.5630 856 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 09:47:33' where traUID = 4863903342770400 and traStatus='V' and traEnabled=1 11/12/2024 09:47:53.7900 1040 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 09:48:20.1127 715 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,'2024-12-11 09:48:19','V',5428144448289200,2024,'2024-12-11 09:48:18','456353394900327005012999',2,2,2,'O','',0,'2024-12-11 09:48:19',1,'','',0) 11/12/2024 09:52:59.0722 792 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 09:55:23.4363 602 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 09:55:22' where traUID = 4728408306101260 and traStatus='V' and traEnabled=1 11/12/2024 09:59:21.7125 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:00:44.9425 640 ms. OPEN: select * from movtransit where traCode = '456353452800327005012999' and traStatus='V' ORDER BY traId DESC 11/12/2024 10:00:47.6563 1907 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 11/12/2024 10:02:32.5168 1164 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:05:11.2425 731 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:07:55.4069 569 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 11/12/2024 10:13:29.0002 654 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',5,3,42101,0,50,-26,-1300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',5,3,42101,0,50,26,1300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',5,3,42101,0,100,-45,-4500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',5,3,42101,0,100,45,4500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',5,3,42101,0,200,-7,-1400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',5,3,42101,0,200,7,1400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',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 ('2024-12-11 10:12:44',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 ('2024-12-11 10:12:44',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:12:44',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 11/12/2024 10:13:54.7045 1123 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/12/2024 10:14:06.4664 574 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-11 10:14:05',0,3,'2024-12-11 10:14:05','0230003944086','POF - User Transit Supervisor Supervisor') 11/12/2024 10:14:07.9504 1104 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 10:14:06',5,3,0,2,0,0,0,0,'2','') 11/12/2024 10:15:53.9807 677 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,'2024-12-11 10:15:53','V',5169984772214840,2024,'2024-12-11 10:15:52','456345297700327005029999',2,2,2,'O','',0,'2024-12-11 10:15:53',1,'','0230004098567',165,0) 11/12/2024 10:16:48.5254 643 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 10:18:32.4572 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:19:02.8827 878 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/12/2024 10:19:15.0269 577 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/12/2024 10:19:16.1056 1015 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:19:31.4749 533 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,'2024-12-11 10:19:30','V',5240932166874880,2024,'2024-12-11 10:19:30','456353717000327005012999',1,2,16,'I','',1,0,1,'','',4) 11/12/2024 10:20:17.6310 990 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17605, trcLastPrinted = '2400417605', trcLastDate = '2024-12-11 10:20:16' where trcStatus='V' and trcTerId = 4 11/12/2024 10:20:37.8876 564 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 10:26:23.3439 744 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:27:09.8791 1002 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,'2024-12-11 10:27:08','V',5501078999542160,2024,'2024-12-11 10:27:08','456353762800327005012999',1,2,16,'I','',1,0,1,'','',4) 11/12/2024 10:28:44.7629 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:28:44.7860 639 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 10:28:50.8901 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:28:50.8931 1222 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/12/2024 10:29:10.2531 864 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,'2024-12-11 10:29:09','V',4834687709054360,2024,'2024-12-11 10:29:08','456353713200327005012999',2,2,2,'O','',0,'2024-12-11 10:29:09',1,'','',0) 11/12/2024 10:32:28.7576 1020 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 10:32:28.8666 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:32:32.7092 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:33:42.7873 1217 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 10:33:41' where traUID = 5012354301372340 and traStatus='V' and traEnabled=1 11/12/2024 10:34:17.5397 1026 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-11 10:34:16',0,0,'V',5280378541710770,5703757445683450,2024,'2024-12-11 10:34:16',3,'KES',1,50,50,'N',''); 11/12/2024 10:37:18.5644 709 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,'2024-12-11 10:37:17','V',5730226756082440,2024,'2024-12-11 10:37:16','456353823600327005012999',1,2,16,'I','',1,0,1,'','0810007106930',88,0) 11/12/2024 10:39:19.6879 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:40:44.4979 729 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 381313 else acvFstPayId end),acvLstPayId = 381313 where acvSftId = 836 and acvCodeId = 3 11/12/2024 10:42:42.9015 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:45:54.0900 1147 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/12/2024 10:50:12.8660 941 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,'2024-12-11 10:50:11','V',5027550295630630,2024,'2024-12-11 10:50:11','456353901100327005012999',1,2,16,'I','',1,0,1,'','',4) 11/12/2024 10:51:12.1419 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:51:55.8603 675 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:52:30.6457 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:53:42.7492 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:55:30.8078 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 10:55:32.3278 592 ms. OPEN: SELECT COALESCE(mliReceiptMessage,'') as mliReceiptMessage FROM movLinks WHERE mliStatus='V' AND mliTraUID = 5364302605322580 11/12/2024 10:55:32.3308 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:55:32.9262 596 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5364302605322580,5732005559916510,2024,'2024-12-11 10:55:32',' Date: 12/11/2024 10:55:31 AM Code: 456353673700327001012999 Entry Date: 12/11/2024 10:12:17 AM 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 # 2400752995 ',0) 11/12/2024 10:56:53.4214 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,'2024-12-11 10:56:52','V',5487865624790390,2024,'2024-12-11 10:56:52','456353817500327005012999',2,2,2,'O','',0,'2024-12-11 10:56:52',1,'','',0) 11/12/2024 10:58:25.7424 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 10:58:51.1285 517 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/12/2024 11:05:48.2600 1369 ms. OPEN: show columns from tabParameters where Field = 'parOfflineAmount' 11/12/2024 11:11:29.6195 712 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 11:18:48.2554 1025 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 11:21:02.8899 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 11:21:06.6875 640 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-11 11:21:05',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 11/12/2024 11:23:04.7359 606 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 11/12/2024 11:26:13.5718 795 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 11:27:11.0305 943 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/12/2024 11:31:22.1914 511 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 11:34:29.1931 703 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-11 11:34:28' where payTraUID = 4873628446553730 and payStatus='V' and payEnabled=1 11/12/2024 11:36:32.1117 1083 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 11:36:33.5347 565 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 11:39:55.8647 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 11:42:17.6861 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 11:45:08.6951 507 ms. EXEC: update payReceipt set recCreation = '2024-12-11 11:45:08',recModify = '2024-12-11 11:45:08',recUseId=0,recStatus='V' where recId = 331191 11/12/2024 11:47:24.8156 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 11:48:17.3239 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 11:49:21.3920 501 ms. EXEC: update payReceipt set recCreation = '2024-12-11 11:49:20',recModify = '2024-12-11 11:49:20',recUseId=0,recStatus='V' where recId = 331193 11/12/2024 11:50:43.0109 610 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,'2024-12-11 11:50:42','V',4703315391558290,2024,'2024-12-11 11:50:41','456354264100327005012999',1,2,16,'I','',1,0,1,'','',4) 11/12/2024 11:52:43.0716 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 11:54:12.8350 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 11:54:30.9701 657 ms. EXEC: update payReceipt set recCreation = '2024-12-11 11:54:30',recModify = '2024-12-11 11:54:30',recUseId=0,recStatus='V' where recId = 331195 11/12/2024 11:54:35.8965 748 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/12/2024 11:54:50.1851 2441 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,'2024-12-11 11:54:47','V',5074749547040950,2024,'2024-12-11 11:54:46','456354288600327005012999',1,2,16,'I','',1,0,1,'','',4) 11/12/2024 11:54:51.9162 1296 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 11:55:06.5180 750 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 11:55:06.5671 857 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 11:55:14.5915 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 11:56:57.7318 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 11:59:13.3050 1635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:00:45.4619 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 13 ms.) 11/12/2024 12:01:15.2230 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 12:07:33.5924 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,'2024-12-11 12:07:33','V',5364088449068580,2024,'2024-12-11 12:07:32','456354288600327005012999',2,2,2,'O','',0,'2024-12-11 12:07:33',1,'','',0) 11/12/2024 12:07:37.8572 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:13:39.2732 812 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 12:19:31.3570 569 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 12:19:30' where traUID = 5467890836006130 and traStatus='V' and traEnabled=1 11/12/2024 12:22:47.4518 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 12:27:25.7680 571 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 12:27:28.0065 518 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 12:27:42.6143 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 12:27:58.4029 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 12:29:55.4446 987 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:30:49.1647 758 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:32:01.2732 652 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 ('2024-12-11 12:31:59',0,'V',5116182060908260,5130407984098000,2024,'2024-12-11 12:31:59',3,1,0,4,'2024-12-11 12:46:59','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 11/12/2024 12:37:27.0663 650 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-11 12:37:26' where payTraUID = 4702045832754160 and payStatus='V' and payEnabled=1 11/12/2024 12:37:27.6206 553 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 12:37:26' where traUID = 4702045832754160 and traStatus='V' and traEnabled=1 11/12/2024 12:37:32.4529 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:38:53.0751 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 12:38:53.0761 568 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/12/2024 12:39:15.2390 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:39:16.2507 596 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 11/12/2024 12:46:58.2783 941 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 ('2024-12-11 12:44:18',1,'V',4877377180915880,5208954517884550,2024,'2024-12-11 12:44:18',17,1,0,4,'2024-12-11 12:59:18','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/12/2024 12:48:10.5329 917 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:50:36.8403 565 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 12:50:35' where traUID = 4679848101303640 and traStatus='V' and traEnabled=1 11/12/2024 12:50:44.6125 584 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 83 ms.) 11/12/2024 12:50:45.2950 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:51:05.2784 796 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53008, trcLastPrinted = '2400753008', trcLastDate = '2024-12-11 12:51:04' where trcStatus='V' and trcTerId = 18 11/12/2024 12:52:41.6712 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 12:53:06.4549 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:54:36.3813 895 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 12:54:42.8447 1078 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-11 12:54:41',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 11/12/2024 12:54:43.6002 677 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 12:54:42',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 12:54:42',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 11/12/2024 12:56:34.4027 1021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 12:59:53.3825 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 13:02:10.9230 734 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/12/2024 13:02:37.4408 946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 13:02:48.3251 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 13:03:43.7204 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 13:03:51.7928 623 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/12/2024 13:07:34.2294 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 30 ms.) 11/12/2024 13:07:57.7962 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 13:08:31.3658 758 ms. EXEC: update paycash set casCreation = '2024-12-11 13:08:30',casModify = '2024-12-11 13:08:30',casUseId=0,casStatus='V' where casId = 199436 11/12/2024 13:11:35.9219 732 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 13:11:35' where traUID = 4636494656166890 and traStatus='V' and traEnabled=1 11/12/2024 13:11:40.3628 925 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 13:11:40.5470 858 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 13:19:25.5957 506 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 ('2024-12-11 13:16:46',1,'V',5643204165902230,4805429816087690,2024,'2024-12-11 13:16:46',17,1,0,4,'2024-12-11 13:31:46','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/12/2024 13:21:32.0337 506 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 11/12/2024 13:25:02.0439 897 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 13:25:26.2161 550 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,'2024-12-11 13:25:25','V',5507919261916780,2024,'2024-12-11 13:25:23','456354517700327001012999',2,2,2,'O','',0,'2024-12-11 13:25:25',1,'','',0) 11/12/2024 13:31:53.6086 921 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-11 13:31:52','V',5077013526372960,2024,'2024-12-11 13:31:52','456354871200327005012999',1,2,16,'I','',1,0,1,'','',4) 11/12/2024 13:32:32.3467 1503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 13:33:46.1773 825 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/12/2024 13:34:04.2705 826 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5052735601070070,5370077518280380,2024,'2024-12-11 13:34:03','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/11/2024 1:07:49 PM Date : 12/11/2024 1:34:00 PM Code : 456354726900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) (WAIT TIME 253 ms.) 11/12/2024 13:34:05.6494 787 ms. EXEC: update payInventory set invCreation = '2024-12-11 13:34:04',invModify = '2024-12-11 13:34:04',invUseId=0,invStatus='V' where invId = 224538 11/12/2024 13:34:26.5735 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 13:35:17.2605 915 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 13:37:06.1117 770 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 13:37:06.8632 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 13:38:25.2900 882 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-11 13:38:24',0,0,'V',5013278509348350,5366802857590530,2024,'2024-12-11 13:38:24',3,'KES',1,50,50,'N',''); 11/12/2024 13:39:44.1700 652 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/12/2024 13:39:44.4652 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 13:39:53.6134 756 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 13:45:47.5693 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 13:46:00.5761 538 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 11/12/2024 13:46:00.6151 848 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 39 ms.) 11/12/2024 13:46:00.6962 876 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/12/2024 13:47:23.0335 572 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5572740199357000,5620558736011220,2024,'2024-12-11 13:47:22','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/11/2024 1:29:15 PM Date : 12/11/2024 1:47:21 PM Code : 456354855500327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 11/12/2024 13:47:24.0132 564 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-11 13:47:23',0,0,'V',5693345976480430,5572740199357000,2024,'2024-12-11 13:47:23',3,'KES',1,100,100,'N',''); 11/12/2024 13:48:57.8973 1277 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 = 6 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 11/12/2024 13:50:01.7963 526 ms. EXEC: update payReceipt set recCreation = '2024-12-11 13:50:01',recModify = '2024-12-11 13:50:01',recUseId=0,recStatus='V' where recId = 331265 11/12/2024 13:50:28.4092 549 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 11/12/2024 13:51:38.5073 502 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 13:51:39.3089 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 13:51:57.2199 688 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 13:52:17.2984 681 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-11 13:52:16','V',4693398454346580,2024,'2024-12-11 13:52:15','456354933000327005012999',2,2,2,'O','',0,'2024-12-11 13:52:16',1,'','',0) 11/12/2024 13:52:34.5840 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 13:56:09.1783 737 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 14:00:38.4544 708 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:03:33.6131 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:05:05.8001 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:05:15.1864 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 1 ms.) 11/12/2024 14:06:26.3363 2392 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:06:55.2067 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:07:20.6768 1113 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 14:07:19' where traUID = 4623981567149920 and traStatus='V' and traEnabled=1 11/12/2024 14:12:08.8746 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:13:11.3236 2063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:17:26.9224 823 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:17:32.3281 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:17:32.3381 628 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/12/2024 14:20:16.7096 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:20:51.7151 1263 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 14:22:01.5771 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:23:49.6328 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:25:52.6905 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:30:17.1253 585 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 14:30:17.7657 632 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-11 14:30:17' where payTraUID = 4731289676989990 and payStatus='V' and payEnabled=1 11/12/2024 14:30:18.3771 610 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 14:30:17' where traUID = 4731289676989990 and traStatus='V' and traEnabled=1 11/12/2024 14:31:48.6178 858 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 14:35:19.5887 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:35:57.5332 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:36:30.5524 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:36:51.2483 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:40:07.3301 840 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:43:45.9772 1422 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:44:23.5454 1252 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7979, trcLastPrinted = '2400607979', trcLastDate = '2024-12-11 14:44:22' where trcStatus='V' and trcTerId = 17 11/12/2024 14:48:47.2027 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:50:11.8556 1534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:50:49.5440 1055 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 14:51:41.0406 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:53:03.2839 661 ms. EXEC: update payReceipt set recCreation = '2024-12-11 14:53:02',recModify = '2024-12-11 14:53:02',recUseId=0,recStatus='V' where recId = 331302 11/12/2024 14:53:09.9253 1265 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 14:53:19.2996 2235 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/12/2024 14:53:19.3807 1707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 14:53:52.1227 1881 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 14:54:56.3609 627 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17636, trcLastPrinted = '2400417636', trcLastDate = '2024-12-11 14:54:55' where trcStatus='V' and trcTerId = 4 11/12/2024 14:56:23.5896 1046 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:04:08.8224 589 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-11 15:04:08','V',5746495062597580,2024,'2024-12-11 15:04:07','456355092400327005012999',2,2,2,'O','',0,'2024-12-11 15:04:08',1,'','',0) 11/12/2024 15:06:31.5213 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 15:09:47.3470 755 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 15:13:17.6404 1262 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4619869624740630,4913840100831740,2024,'2024-12-11 15:13:16',' Date: 12/11/2024 3:13:16 PM Code: 456355154800327005012999 Entry Date: 12/11/2024 2:19:08 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 # 2400753038 ',0) 11/12/2024 15:13:58.7870 597 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 15:14:00.0909 1006 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 15:21:15.6918 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:25:18.3610 1081 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,'2024-12-11 15:25:17','V',5568032786329980,2024,'2024-12-11 15:25:15','456355551500327005012999',1,2,16,'I','',1,0,1,'','',4) 11/12/2024 15:25:38.2814 503 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53044, trcLastPrinted = '2400753044', trcLastDate = '2024-12-11 15:25:37' where trcStatus='V' and trcTerId = 18 11/12/2024 15:25:39.3231 1037 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4815479217746020,5308796946341790,2024,'2024-12-11 15:25:38',' Date: 12/11/2024 3:25:36 PM Code: 456355157300327005012999 Entry Date: 12/11/2024 2:19:33 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400753044 ',0) 11/12/2024 15:26:59.4730 1218 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/12/2024 15:27:46.6907 1421 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 15:29:20.1446 771 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:31:33.1790 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 15:32:01.2098 830 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:36:18.6840 668 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-11 15:36:18',17,1,'2024-12-11 15:36:18','456354695600327001012999','Pagato (Contanti ) Biglietto ') 11/12/2024 15:36:57.6021 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:39:55.0715 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:46:05.4805 707 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:50:15.4956 630 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 15:54:09.3228 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:55:41.7750 593 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 11/12/2024 15:55:46.2820 3295 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 11/12/2024 15:55:48.7577 834 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 11/12/2024 15:56:26.7052 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:58:37.7063 817 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 15:59:47.9165 736 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:03:03.4390 627 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 16:03:02' where traUID = 5367190095620590 and traStatus='V' and traEnabled=1 11/12/2024 16:06:15.0318 504 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 16:06:14' where traUID = 4910185999624730 and traStatus='V' and traEnabled=1 11/12/2024 16:07:02.8379 1123 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 11/12/2024 16:07:07.0888 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:09:39.8165 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:11:20.9955 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:13:53.6001 567 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 16:13:52' where traUID = 5747100194928170 and traStatus='V' and traEnabled=1 11/12/2024 16:13:57.2526 1230 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 ('2024-12-11 16:10:37',12,'V',4827026769776600,4919543659720890,2024,'2024-12-11 16:10:37',4,1,0,4,'2024-12-11 16:25:37','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/12/2024 16:15:36.4723 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:15:36.5053 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:16:00.1972 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:16:05.4688 1194 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 ('2024-12-11 16:16:04',0,'V',5203476941193900,5281342336544050,2024,'2024-12-11 16:16:04',18,1,0,4,'2024-12-11 16:31:04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/12/2024 16:16:06.2013 632 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53061, trcLastPrinted = '2400753061', trcLastDate = '2024-12-11 16:16:05' where trcStatus='V' and trcTerId = 18 11/12/2024 16:16:07.5902 1264 ms. EXEC: update payReceipt set recCreation = '2024-12-11 16:16:06',recModify = '2024-12-11 16:16:06',recUseId=0,recStatus='V' where recId = 331364 11/12/2024 16:16:10.6873 2295 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:16:47.8733 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:16:48.1545 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:17:58.1856 1184 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,'2024-12-11 16:17:57','V',5083332968712440,2024,'2024-12-11 16:17:56','456355867600327005012999',1,2,16,'I','',1,0,1,'','',4) 11/12/2024 16:18:49.2109 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:19:10.6503 651 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 11/12/2024 16:20:38.1922 1356 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:22:01.9875 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:22:22.3142 620 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-11 16:22:21' where payTraUID = 5207294180743970 and payStatus='V' and payEnabled=1 11/12/2024 16:25:39.5708 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:27:36.1182 797 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:29:27.7542 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:30:02.5356 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:32:33.3010 553 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 11/12/2024 16:32:34.1466 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:36:10.8293 723 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 16:36:12.3072 630 ms. EXEC: update payReceipt set recCreation = '2024-12-11 16:36:11',recModify = '2024-12-11 16:36:11',recUseId=0,recStatus='V' where recId = 331380 11/12/2024 16:37:03.1214 771 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 16:37:02' where traUID = 4792771800051410 and traStatus='V' and traEnabled=1 11/12/2024 16:38:00.0297 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:40:15.2946 1363 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:42:36.7457 511 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53072, trcLastPrinted = '2400753072', trcLastDate = '2024-12-11 16:42:36' where trcStatus='V' and trcTerId = 18 11/12/2024 16:43:14.0778 611 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 16:43:14.9955 656 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 16:43:14' where traUID = 5119221667049790 and traStatus='V' and traEnabled=1 11/12/2024 16:44:46.3949 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:47:20.1153 858 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 ('2024-12-11 16:47:19',0,'V',5296083068508670,5234764516156200,2024,'2024-12-11 16:47:19',18,1,0,4,'2024-12-11 17:02:19','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/12/2024 16:47:39.6954 828 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 16:47:41.4496 625 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 ('2024-12-11 16:47:40',0,'V',4917687912157410,4744047763213470,2024,'2024-12-11 16:47:40',18,1,0,4,'2024-12-11 17:02:40','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/12/2024 16:49:37.1924 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:50:12.5382 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:50:38.5117 1508 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 16:51:18.8648 950 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 16:52:02.9044 1286 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 16:56:51.5265 1380 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 17:01:27.6952 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:02:36.4974 625 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 17:02:35' where traUID = 4681975749455250 and traStatus='V' and traEnabled=1 11/12/2024 17:04:46.7770 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:08:14.6228 1176 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 17:10:06.4159 861 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:12:12.6268 551 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 17:12:13.3063 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:15:08.5681 718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:15:20.6432 902 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:18:23.5422 512 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-11 17:18:22' where payTraUID = 4648119298391450 and payStatus='V' and payEnabled=1 11/12/2024 17:18:30.0646 793 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:18:41.5223 527 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 ('2024-12-11 17:15:22',12,'V',4661714979271860,5636998117313330,2024,'2024-12-11 17:15:22',4,1,0,4,'2024-12-11 17:30:22','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 11/12/2024 17:21:32.8395 756 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:22:37.0506 560 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 11/12/2024 17:25:21.8044 987 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-11 17:25:20' where subId = 11 11/12/2024 17:26:51.5268 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:31:56.7850 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:32:26.9073 914 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 11/12/2024 17:32:49.5515 581 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 17:32:48' where traUID = 5383005624146390 and traStatus='V' and traEnabled=1 11/12/2024 17:32:51.1606 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:33:11.0950 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:33:11.7674 636 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/12/2024 17:33:44.1542 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:34:02.3014 1149 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:35:18.5927 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:42:27.1579 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:42:27.8443 605 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/12/2024 17:42:35.0111 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:44:57.2788 597 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 11/12/2024 17:46:31.4121 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:46:51.1444 974 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/12/2024 17:48:13.2586 1401 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 11/12/2024 17:50:55.8069 745 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 11/12/2024 17:51:59.1545 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:52:26.0575 1604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 17:55:07.9484 611 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 17:55:13.4981 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 17:56:27.6560 1029 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 18:00:47.1094 774 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 18:08:42.5121 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:09:17.8749 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:09:46.0778 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 18:11:30.1798 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:12:15.3972 664 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 18:12:34.1508 539 ms. EXEC: update abbCards set carLastDate = '2024-12-11 18:12:33',carLastDirection='I' where carStatus='V' and carId = 14 11/12/2024 18:12:46.6362 1226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:14:21.0907 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:14:51.2790 559 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 18:14:50' where traUID = 5604360307957010 and traStatus='V' and traEnabled=1 11/12/2024 18:18:14.3816 707 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 18:18:17.5557 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:20:16.9630 692 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,'2024-12-11 18:20:16','V',5750945197142700,2024,'2024-12-11 18:20:13','456356601300327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 11/12/2024 18:22:22.5885 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:28:10.3243 564 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 18:34:24.1336 680 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/12/2024 18:34:39.0707 570 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5385703226307680,4637150961313710,2024,'2024-12-11 18:34:38','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/11/2024 5:51:55 PM Date : 12/11/2024 6:34:37 PM Code : 456356431500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 11/12/2024 18:36:08.3127 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 18:37:26.1610 804 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 18:38:20.3124 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:39:09.6596 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:39:25.6774 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 18:44:03.7694 869 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-11 18:44:02' where payTraUID = 4718297845039450 and payStatus='V' and payEnabled=1 11/12/2024 18:44:05.5196 1750 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 18:44:02' where traUID = 4718297845039450 and traStatus='V' and traEnabled=1 11/12/2024 18:45:19.9516 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 19:01:24.4421 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 19:08:15.8387 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 19:09:03.5658 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 19:16:43.3540 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 19:30:28.2776 507 ms. EXEC: update payReceipt set recCreation = '2024-12-11 19:30:27',recModify = '2024-12-11 19:30:27',recUseId=0,recStatus='V' where recId = 331428 11/12/2024 19:34:04.1007 895 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 19:34:31.3421 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 12 ms.) 11/12/2024 19:44:59.5344 912 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 19:47:31.8669 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 19:48:16.0306 502 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,'2024-12-11 19:48:15','V',4847384652441430,2024,'2024-12-11 19:48:15','456356648800327001012999',2,2,2,'O','',0,'2024-12-11 19:48:15',1,'','',0) 11/12/2024 19:48:17.2604 565 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 19:48:21.2651 846 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 19:49:24.4105 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 19:49:38.0627 818 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 19:49:37' where traUID = 5041096779737260 and traStatus='V' and traEnabled=1 11/12/2024 19:50:37.1835 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 19:50:38.9126 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 19:53:49.3177 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 19:53:59.6396 521 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/12/2024 20:03:39.0552 1103 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 20:04:16.6705 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 20:12:35.2267 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 20:23:11.8738 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 20:23:22.2557 683 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 20:23:21',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-11 20:23:21',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 11/12/2024 20:24:50.6292 1502 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 20:26:54.5175 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 20:31:39.5271 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 20:35:26.0614 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 20:42:46.3234 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 20:48:34.6947 754 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 20:49:06.1548 602 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 20:49:34.8401 567 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 20:49:35.4965 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 20:51:55.9430 835 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 11/12/2024 20:56:06.0241 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 20:58:04.1045 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 21:02:09.5816 1154 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 21:05:06.9148 507 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-11 21:05:06',0,16,'2024-12-11 21:05:06','','Unauthorized Transit Entry 2') 11/12/2024 21:05:42.1235 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 21:05:42.7249 571 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 11/12/2024 21:09:43.2396 1135 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53108, trcLastPrinted = '2400753108', trcLastDate = '2024-12-11 21:09:42' where trcStatus='V' and trcTerId = 18 11/12/2024 21:11:27.1675 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 21:11:39.1626 1174 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 21:12:38.0281 796 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 21:16:12.5574 522 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 21:17:09.9340 522 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 21:17:09' where traUID = 5356139425134520 and traStatus='V' and traEnabled=1 11/12/2024 21:24:16.8240 577 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,'2024-12-11 21:24:16','V',4623072071070750,2024,'2024-12-11 21:24:15','456355867600327005012999',2,2,2,'O','',0,'2024-12-11 21:24:16',1,'','',0) 11/12/2024 21:24:17.6435 551 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 11/12/2024 21:24:24.5962 715 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 21:24:53.7348 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 21:26:03.2976 1805 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 ('2024-12-11 21:26:01',0,'V',5322897716107620,4652828748320890,2024,'2024-12-11 21:26:01',18,1,0,4,'2024-12-11 21:41:01','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 11/12/2024 21:27:03.0137 1208 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-11 21:27:01' where traUID = 4652828748320890 and traStatus='V' and traEnabled=1 11/12/2024 21:31:06.7296 743 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 11/12/2024 21:33:20.2264 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 184 ms.) 11/12/2024 21:33:20.9148 509 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-12-11 21:33:20',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','') 11/12/2024 21:34:17.6400 626 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/12/2024 21:38:11.5492 595 ms. OPEN: select sum(payPayed) as vTot from payPayment inner join tabTerminal on terId = payIdTerminal where payStatus='V' and terType=4 and terStatus='V' and payTraUID = 5746554393953770 11/12/2024 21:40:42.4747 849 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 21:40:54.6769 1122 ms. EXEC: update payInventory set invCreation = '2024-12-11 21:40:53',invModify = '2024-12-11 21:40:53',invUseId=0,invStatus='V' where invId = 224634 11/12/2024 21:42:21.8525 759 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 11/12/2024 21:42:21.8545 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 21:42:40.1679 708 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/12/2024 21:42:45.0772 1313 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/12/2024 21:42:45.9177 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 21:43:04.8404 714 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/12/2024 21:43:31.5194 510 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 11/12/2024 21:43:42.7710 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 21:47:32.9277 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 21:47:41.4234 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 22:03:54.7719 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:13:01.9188 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:15:01.2490 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 22:19:41.9257 1101 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:23:04.6120 558 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 11/12/2024 22:29:22.6112 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:32:44.3828 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 22:33:26.3991 522 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-11 22:33:25',4,12,'2024-12-11 22:33:25','456357014300327001012999','Payed (Credit Card ) Ticket ') 11/12/2024 22:34:06.0007 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:35:15.6345 783 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 22:37:19.4878 682 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 11/12/2024 22:44:52.6915 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:45:49.9931 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:45:54.0318 537 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-11 22:45:53','V',4739575588658750,2024,'2024-12-11 22:45:53','456357014300327001012999',2,2,2,'O','',0,'2024-12-11 22:45:53',1,'','',0) 11/12/2024 22:46:16.8381 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 22:47:09.4155 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:50:24.6978 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 22:51:31.7218 874 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4968242691421570,4933306500468260,2024,'2024-12-11 22:51:30',' Date: 12/11/2024 10:51:30 PM Code: 456358191600327005012999 Entry Date: 12/11/2024 10:45:16 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 # 2400753116 ',0) 11/12/2024 22:53:06.5646 744 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/12/2024 23:01:56.8201 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 23:13:15.2293 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 23:20:33.7201 2340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 23:21:43.9764 1498 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 23:22:18.3224 971 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-11 23:22: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'; 11/12/2024 23:22:18.4085 664 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 86 ms.) 11/12/2024 23:30:54.1443 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 23:39:14.3446 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 11/12/2024 23:41:26.8887 528 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 11/12/2024 23:41:26.8887 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1