29/10/2024 03:06:49.8519 886 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/10/2024 03:07:21.1923 1109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 03:11:49.4682 1163 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 03:14:26.9606 665 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/10/2024 03:25:55.8641 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 03:34:48.4520 528 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 29/10/2024 03:49:45.6998 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 03:50:22.9155 686 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 29/10/2024 04:01:35.0095 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:02:19.2925 502 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 04:02:18' where traUID = 5063340380727110 and traStatus='V' and traEnabled=1 29/10/2024 04:03:11.2952 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:12:21.6554 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:17:22.7298 2493 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 29/10/2024 04:17:25.7081 2976 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 04:17:26.3485 640 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 29/10/2024 04:18:50.5243 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:18:54.6223 3274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:18:56.5968 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:21:25.7210 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:21:26.8108 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:29:32.5418 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:29:32.5428 642 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/10/2024 04:44:12.3436 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 04:46:14.5747 717 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 04:46:13' where traUID = 4969848740470110 and traStatus='V' and traEnabled=1 29/10/2024 04:46:24.3710 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 05:00:23.3333 1164 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 05:45:32.2083 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 06:06:04.5878 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 06:20:02.5915 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 06:32:15.8220 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 06:42:57.6914 906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 07:02:42.8507 3533 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 29/10/2024 07:04:20.3634 3004 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 29/10/2024 07:13:47.2249 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 07:20:11.0440 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 07:21:51.2797 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 07:39:57.5583 1657 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 29/10/2024 07:43:48.8938 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 07:54:03.7941 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 08:03:56.6820 662 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 29/10/2024 08:03:57.7247 658 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/10/2024 08:04:12.3827 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 08:04:30.4081 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 08:04:42.8524 1450 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 08:12:04.7658 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 08:26:02.7043 1828 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 18 order by traDateTime desc,traId desc 29/10/2024 08:26:03.5599 528 ms. EXEC: update abbCards set carLastDate = '2024-10-29 08:26:03',carLastDirection='I' where carStatus='V' and carId = 18 29/10/2024 08:26:13.9157 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 08:30:07.3557 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 08:35:51.1399 2000 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 29/10/2024 08:37:17.1420 680 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/10/2024 08:42:27.7615 822 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 165 order by traDateTime desc,traId desc 29/10/2024 08:43:11.4531 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 08:45:42.8639 1280 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 29/10/2024 08:48:15.0514 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 08:52:58.5607 711 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 09:02:08.0883 664 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 102 order by traDateTime desc,traId desc 29/10/2024 09:04:35.8764 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 09:06:42.1715 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 09:12:53.9837 1225 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 09:13:20.5945 980 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,50,-3,-150,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,50,3,150,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,100,-13,-1300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,100,13,1300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,200,-5,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,200,5,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-29 09:11:49',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 29/10/2024 09:14:26.0123 1348 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/10/2024 09:14:26.2444 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 09:14:37.5679 1189 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-10-29 09:14:36','V',5409370751097860,2024,'2024-10-29 09:14:35','455923327500327005012999',1,2,16,'I','',1,0,1,'','',4) 29/10/2024 09:15:03.1359 507 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-29 09:15:02',0,3,'2024-10-29 09:15:02','0230003944086','POF - User Transit Supervisor Supervisor') 29/10/2024 09:17:39.7256 764 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 29/10/2024 09:21:04.2491 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 09:28:49.9232 611 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/10/2024 09:28:51.5684 1574 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 125 order by traDateTime desc,traId desc 29/10/2024 09:29:07.8205 1240 ms. OPEN: show columns from tabParameters where Field = 'parForce24Hours' 29/10/2024 09:29:08.6461 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 09:36:49.4686 640 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-29 09:36:48',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-10-29 09:36:48',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'; 29/10/2024 09:37:36.2785 7013 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 29/10/2024 09:43:32.9824 1260 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 29/10/2024 09:49:34.8090 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 09:51:48.6678 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 09:54:18.2473 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 09:54:19.1560 865 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/10/2024 09:54:19.2080 987 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/10/2024 10:03:46.8861 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 10:05:26.6945 1540 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 29/10/2024 10:10:28.1872 824 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 10:28:24.5935 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 10:29:46.8708 680 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 10:29:47.5814 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 10:32:13.7443 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 10:32:57.0666 572 ms. EXEC: update payInventory set invCreation = '2024-10-29 10:32:56',invModify = '2024-10-29 10:32:56',invUseId=0,invStatus='V' where invId = 215984 29/10/2024 10:35:55.4336 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 10:36:34.1084 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 10:42:02.5132 533 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-29 10:42:01',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 29/10/2024 10:43:34.0143 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 10:43:51.0561 1631 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 10:43:51.8607 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 10:46:25.4251 502 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-10-29 10:46:24','V',5448999409627900,2024,'2024-10-29 10:46:23','455923878300327005012999',1,2,16,'I','',1,0,1,'','0750009518612',99,0) 29/10/2024 10:48:42.0930 857 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-29 10:48:41',0,0,'V',4988005477618710,4909825348703020,2024,'2024-10-29 10:48:41',3,'KES',-1,100,-100,'N',''); 29/10/2024 10:50:28.8656 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 10:50:42.2275 1225 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 10:50:48.8525 856 ms. EXEC: update paycash set casCreation = '2024-10-29 10:50:47',casModify = '2024-10-29 10:50:47',casUseId=0,casStatus='V' where casId = 192040 29/10/2024 10:54:14.4597 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 10:54:18.5377 672 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 10:54:17' where traUID = 5129413355236460 and traStatus='V' and traEnabled=1 29/10/2024 10:54:30.3395 771 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 10:54:32.7273 1304 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/10/2024 10:59:11.1008 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 11:03:15.4359 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 11:08:52.6653 1626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 11:13:46.6414 539 ms. EXEC: update payReceipt set recCreation = '2024-10-29 11:13:46',recModify = '2024-10-29 11:13:46',recUseId=0,recStatus='V' where recId = 317087 29/10/2024 11:15:47.0931 836 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 11:15:46' where traUID = 4932458080684720 and traStatus='V' and traEnabled=1 29/10/2024 11:21:26.3930 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 11:27:26.2272 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 11:28:19.2398 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 11:41:39.5943 1132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 11:45:36.3297 1166 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 11:49:34.1550 1258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 11:49:53.7066 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 11:50:14.7723 1460 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 11:53:54.1358 605 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/10/2024 11:56:00.9843 659 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-10-29 11:56:00',0,'V',5068369699599810,5581384550608610,2024,'2024-10-29 11:56:00',2,1,0,-1,'2024-10-29 12:56:00','S','KES',0,0,0,'','','',3,0,0) 29/10/2024 11:56:02.2783 786 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 11:56:01' where traUID = 5581384550608610 and traStatus='V' and traEnabled=1 29/10/2024 11:56:10.4524 780 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 11:58:30.2125 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 11:58:30.4817 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 11:59:58.2902 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 12:05:20.3172 798 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 12:05:19' where traUID = 5458220415810600 and traStatus='V' and traEnabled=1 29/10/2024 12:09:46.9339 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 12:11:14.6243 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 12:12:20.2192 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 12:14:20.4618 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 12:15:34.6381 855 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-10-29 12:15:33','V',5429870207944820,2024,'2024-10-29 12:15:32','455924413200327005012999',1,2,16,'I','',1,0,1,'','0230003950896',20,0) 29/10/2024 12:15:43.0364 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 12:17:45.6758 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 12:18:07.2859 719 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 29/10/2024 12:18:08.2626 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 12:18:08.5788 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 12:19:12.5245 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 12:19:39.5366 823 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 12:22:00.3116 810 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-10-29 12:21:50',0,'V',5544798249423850,5317780921894900,2024,'2024-10-29 12:21:50',3,1,0,4,'2024-10-29 12:36:50','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 29/10/2024 12:30:07.4026 998 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-10-29 12:30:06','V',4660935674029080,2024,'2024-10-29 12:30:06','455924500600327005012999',1,2,16,'I','',1,0,1,'','',4) 29/10/2024 12:35:20.1817 2590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 12:36:54.8533 745 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 12:39:37.0992 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 12:46:32.3727 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 12:46:55.3439 538 ms. EXEC: update tabTerminalReceipt set trcProgressive = 47504, trcLastPrinted = '2400747504', trcLastDate = '2024-10-29 12:46:54' where trcStatus='V' and trcTerId = 18 29/10/2024 12:46:56.8930 628 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/10/2024 12:48:19.8609 510 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-29 12:48:19' where payTraUID = 5159591447323770 and payStatus='V' and payEnabled=1 29/10/2024 12:51:57.9324 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 12:52:26.6948 573 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/10/2024 12:56:16.0628 964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:00:17.2966 641 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-29 13:00:16' where payTraUID = 5094988212780160 and payStatus='V' and payEnabled=1 29/10/2024 13:00:27.0679 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:02:03.3326 643 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 13:02:04.2263 831 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:02:32.4393 1001 ms. EXEC: update paycash set casCreation = '2024-10-29 13:02:31',casModify = '2024-10-29 13:02:31',casUseId=0,casStatus='V' where casId = 192079 29/10/2024 13:02:32.4974 721 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-10-29 13:02:31','V',5751598566607580,2024,'2024-10-29 13:02:30','455924429100327005012999',2,2,2,'O','',0,'2024-10-29 13:02:31',1,'','',0) 29/10/2024 13:06:02.1947 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:06:26.2376 599 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-10-29 13:06:25','V',4735332713638290,2024,'2024-10-29 13:06:25','455924718500327005012999',1,2,16,'I','',1,0,1,'','',4) 29/10/2024 13:07:11.3052 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:09:00.2644 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:11:04.0266 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:11:48.7069 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:12:54.8662 645 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 13:14:09.5669 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:14:32.4350 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:17:02.7070 778 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 13:17:05.0427 583 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5675956566331700,4882584203537150,2024,'2024-10-29 13:17:04',' Date: 10/29/2024 1:17:02 PM Code: 455923763000327005012999 Entry Date: 10/29/2024 10:27:10 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400747512 ',0) 29/10/2024 13:19:37.5504 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:24:24.0949 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:24:42.3185 1375 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:27:59.7807 680 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5135166477952860,5058984439914020,2024,'2024-10-29 13:27:59',' Data: 10/29/2024 1:26:08 PM Codice: 455924726100327005012999 Ingresso: 10/29/2024 1:07:41 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400606653 ',0) 29/10/2024 13:30:52.8347 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:33:58.4610 670 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-29 13:33:57',0,0,'V',4822293507010080,5483080282711910,2024,'2024-10-29 13:33:57',3,'KES',1,50,50,'N',''); 29/10/2024 13:35:41.2727 855 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:36:17.1664 741 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:37:35.0305 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:45:07.1124 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:45:28.1681 1888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 13:49:38.4236 603 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-29 13:49:37','V',4757424111988410,2024,'2024-10-29 13:49:37','455924977700327001012999',1,2,1,'I','',1,0,1,'','',4) 29/10/2024 13:49:39.2142 562 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/10/2024 13:52:01.2711 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 13:55:35.1205 695 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/10/2024 13:58:33.8417 1638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:01:10.6466 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:03:35.0162 576 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 14:03:35.7948 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:04:47.4131 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 14:05:43.5230 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 14:07:50.8589 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 14:08:36.1316 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:09:01.5986 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:09:13.0451 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:09:14.3051 526 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5312453336179660,5500274374626910,2024,'2024-10-29 14:09:13',' Date: 10/29/2024 2:09:12 PM Code: 455924959100327005012999 Entry Date: 10/29/2024 1:46:31 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 # 2400747525 ',0) 29/10/2024 14:09:25.3293 591 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4795142641964940,4685554982370960,2024,'2024-10-29 14:09:24',' Date: 10/29/2024 2:09:24 PM Code: 455925014900327005012999 Entry Date: 10/29/2024 1:55:49 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 # 2400747526 ',0) 29/10/2024 14:09:43.8211 613 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 14:09:44.6477 781 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:10:37.8714 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 14:11:06.4447 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:15:57.8098 841 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/10/2024 14:16:07.3509 557 ms. EXEC: update paycash set casCreation = '2024-10-29 14:16:06',casModify = '2024-10-29 14:16:06',casUseId=0,casStatus='V' where casId = 192092 29/10/2024 14:16:08.2606 549 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-29 14:16:07',0,0,'V',4667557449018980,4974328909170050,2024,'2024-10-29 14:16:07',3,'KES',-1,50,-50,'N',''); 29/10/2024 14:17:17.5022 734 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:19:00.0897 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:19:20.0496 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 14:20:06.7263 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 14:26:03.5653 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:30:52.0023 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 14:32:41.2117 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:41:04.1466 548 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-29 14:41:03',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'; 29/10/2024 14:41:41.1721 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:42:20.7336 1321 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:45:12.2575 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:49:14.9203 903 ms. OPEN: select * from tabParameters order by parId desc limit 1 29/10/2024 14:49:25.3982 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:52:23.9542 813 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 29/10/2024 14:59:06.2651 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 14:59:14.5253 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:01:01.4760 656 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5431936956581240,5266199231296010,2024,'2024-10-29 15:01:00',' Date: 10/29/2024 2:58:41 PM Code: 455925220600327005012999 Entry Date: 10/29/2024 2:30:06 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415228 ',0) 29/10/2024 15:01:37.3907 824 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-10-29 15:01:36','0230004098588',0,0,4908390515844840,183,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/10/2024 15:08:55.6234 624 ms. EXEC: update paycash set casCreation = '2024-10-29 15:08:54',casModify = '2024-10-29 15:08:54',casUseId=0,casStatus='V' where casId = 192112 29/10/2024 15:13:00.9302 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:13:01.3205 894 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 15:19:34.8568 565 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/10/2024 15:19:49.2115 623 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 29/10/2024 15:20:39.5931 507 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/10/2024 15:20:45.1542 844 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 15:20:44' where traUID = 5460472889374930 and traStatus='V' and traEnabled=1 29/10/2024 15:20:54.4992 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:22:15.9819 1808 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/10/2024 15:22:34.4517 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 15:22:39.5185 4346 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 15:23:08.1898 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:36:51.7326 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:37:07.0040 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 15:38:30.8535 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 504 ms.) 29/10/2024 15:39:17.0520 897 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-10-29 15:39:16','V',4975468469040340,2024,'2024-10-29 15:39:14','455925635400327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 29/10/2024 15:41:59.9644 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:42:25.0801 549 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 15:42:24' where traUID = 5618707943350490 and traStatus='V' and traEnabled=1 29/10/2024 15:45:43.1527 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:54:22.6369 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 15:55:19.3572 812 ms. OPEN: select * from tabParameters order by parId desc limit 1 29/10/2024 15:55:19.3692 518 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 29/10/2024 15:55:19.4202 874 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/10/2024 15:55:19.5053 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 15:55:19.9977 585 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/10/2024 15:55:20.9454 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:55:33.5618 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 15:56:54.5472 759 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-10-29 15:56:53','V',4795385696042370,2024,'2024-10-29 15:56:52','455925066100327001012999',2,2,2,'O','',0,'2024-10-29 15:56:53',1,'','',0) 29/10/2024 15:57:35.5437 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:58:54.7297 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 15:58:56.9614 677 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 29/10/2024 16:00:50.7782 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:05:05.2619 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 16:10:54.2820 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:11:17.6975 976 ms. EXEC: update payReceipt set recCreation = '2024-10-29 16:11:16',recModify = '2024-10-29 16:11:16',recUseId=0,recStatus='V' where recId = 317241 29/10/2024 16:12:35.7146 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 16:12:50.1954 697 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:15:46.2056 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 16:21:18.5473 1693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:25:38.6022 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:26:23.3085 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:27:17.9502 740 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:27:17.9892 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 16:29:41.2700 802 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:29:58.9492 730 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:33:22.3448 751 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 16:33:21' where traUID = 5137652991391330 and traStatus='V' and traEnabled=1 29/10/2024 16:33:29.7233 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:38:42.1111 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:38:55.8234 626 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-10-29 16:38:55','V',5705002760180010,2024,'2024-10-29 16:38:54','455925993400327005012999',1,2,16,'I','',1,0,1,'','',4) 29/10/2024 16:40:59.7567 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 16:43:28.5576 547 ms. OPEN: select * from movtransit where trastatus='V' and traCode = '455925827400327005012999' order by traId desc limit 1 29/10/2024 16:57:28.7128 1412 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 29/10/2024 17:02:14.3397 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 17:03:53.7208 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 17:10:14.0193 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 17:14:11.6624 694 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/10/2024 17:14:56.2276 807 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 17:19:52.1311 559 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-10-29 17:19:51','0230004100121',0,0,5069281029975840,147,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/10/2024 17:20:49.7161 1730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 17:22:53.3052 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 17:23:53.1638 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 17:37:32.3774 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 17:38:34.7839 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 17:38:35.5975 961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 17:41:22.5850 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 17:42:47.9866 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 17:42:49.4327 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 17:51:32.1103 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 17:52:40.3321 1203 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-29 17:52:39',0,16,'2024-10-29 17:52:39','','Unauthorized Transit Entry 2') 29/10/2024 17:56:44.7173 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:08:25.3245 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:08:44.5108 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:08:59.9903 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:17:42.5448 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 18:22:40.7090 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 18:22:47.0407 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 18:30:21.7466 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:31:14.9543 733 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 29/10/2024 18:31:15.4677 951 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 178 ms.) 29/10/2024 18:31:16.1392 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:31:32.3193 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:32:34.5767 644 ms. EXEC: update paycash set casCreation = '2024-10-29 18:32:33',casModify = '2024-10-29 18:32:33',casUseId=0,casStatus='V' where casId = 192152 29/10/2024 18:34:36.5185 1642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:34:52.0591 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 18:36:15.1941 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:36:26.2623 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:39:36.2019 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 18:40:25.4286 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:41:36.8899 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 18:43:41.9791 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 18:45:44.1432 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 18:47:24.2548 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 18:53:15.1503 861 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-10-29 18:53:14','V',5292574184930220,2024,'2024-10-29 18:53:13','455926642200327005012999',2,2,2,'O','',0,'2024-10-29 18:53:14',1,'','',0) 29/10/2024 18:59:41.0880 573 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 18:59:40' where traUID = 5163786060539540 and traStatus='V' and traEnabled=1 29/10/2024 19:09:03.4431 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 19:11:38.1184 1022 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 19:20:16.7119 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 19:20:17.4415 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 19:23:49.7367 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 19:30:53.1113 547 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 19:30:52' where traUID = 5278891647647800 and traStatus='V' and traEnabled=1 29/10/2024 19:32:00.5185 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 19:37:29.1795 1374 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/10/2024 19:39:54.8871 2426 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/10/2024 19:40:03.3304 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 19:40:26.8759 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 19:40:28.4511 2121 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 29/10/2024 19:44:59.5622 704 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-29 19:44:58',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 29/10/2024 19:45:54.3740 730 ms. EXEC: update tabTerminalReceipt set trcProgressive = 47577, trcLastPrinted = '2400747577', trcLastDate = '2024-10-29 19:45:53' where trcStatus='V' and trcTerId = 18 29/10/2024 19:46:25.8925 1246 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/10/2024 19:49:59.3636 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 19:53:15.8400 671 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-10-29 19:53:13',0,'V',4652719443814940,5012656090938100,2024,'2024-10-29 19:53:13',3,1,0,4,'2024-10-29 20:08:13','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 29/10/2024 19:53:16.8988 806 ms. EXEC: update paycash set casCreation = '2024-10-29 19:53:16',casModify = '2024-10-29 19:53:16',casUseId=0,casStatus='V' where casId = 192165 29/10/2024 19:54:30.9781 942 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-29 19:54:30' where payTraUID = 5546467431401950 and payStatus='V' and payEnabled=1 29/10/2024 19:55:16.4960 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 19:56:41.5624 563 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-10-29 19:56:40',0,'V',5325604048538890,5505689544708840,2024,'2024-10-29 19:56:40',18,1,0,4,'2024-10-29 20:11:40','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/10/2024 19:57:18.9412 909 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/10/2024 19:57:19.4596 510 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/10/2024 19:57:20.0481 563 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-29 19:57:19' where payTraUID = 5450895827855950 and payStatus='V' and payEnabled=1 29/10/2024 19:58:45.7730 508 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-29 19:58:45' where traUID = 5505689544708840 and traStatus='V' and traEnabled=1 29/10/2024 19:58:56.0476 1193 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:02:14.1092 503 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 29/10/2024 20:02:14.1162 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 20:03:47.2687 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:07:40.0512 538 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 29/10/2024 20:07:41.4322 651 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-10-29 20:07:40','V',5263598876506140,2024,'2024-10-29 20:07:38','455926884700327001012999',2,2,2,'O','',0,'2024-10-29 20:07:40',1,'','0230004098588',183,0) 29/10/2024 20:07:51.2906 1162 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/10/2024 20:08:16.5504 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 20:08:55.4774 567 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 29/10/2024 20:19:16.1390 1779 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-10-29 20:19:14','V',5611535840897280,2024,'2024-10-29 20:19:13','455927202400327001012999',2,2,2,'O','',0,'2024-10-29 20:19:14',1,'','',0) 29/10/2024 20:24:24.9051 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 20:25:19.8881 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 20:26:33.6551 614 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 29/10/2024 20:31:29.5737 2370 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:33:52.9475 1073 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 29/10/2024 20:34:37.3326 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:35:48.8599 554 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/10/2024 20:38:42.7085 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:38:45.8789 578 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/10/2024 20:38:45.8989 974 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 29/10/2024 20:43:00.2555 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:47:27.7488 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:47:33.7953 5436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:48:19.8917 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:48:23.9867 630 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/10/2024 20:51:16.7665 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:56:58.9175 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:58:57.6430 1396 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 20:59:10.8539 1015 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-10-29 20:59:09','V',5158223894242850,2024,'2024-10-29 20:59:08','455927554800327005012999',1,2,16,'I','',1,0,1,'','',4) 29/10/2024 20:59:28.1618 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 20:59:45.9580 1666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:00:31.2278 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:01:47.6778 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 21:02:56.5261 542 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 29/10/2024 21:03:27.6263 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:04:27.8331 634 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 29/10/2024 21:04:28.0663 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 21:04:31.2297 2666 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); (WAIT TIME 464 ms.) 29/10/2024 21:05:23.8539 860 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-10-29 21:05:22',0,'V',5589896962084710,4957308033589600,2024,'2024-10-29 21:05:22',18,1,0,4,'2024-10-29 21:20:22','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/10/2024 21:06:34.5336 703 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 21:08:05.7936 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 21:08:17.3932 521 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/10/2024 21:08:18.8083 1320 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '455927004700327005012999' 29/10/2024 21:08:19.5609 748 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-29 21:08:17' where payTraUID = 5338110408722370 and payStatus='V' and payEnabled=1 29/10/2024 21:08:23.9231 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 21:08:30.8282 505 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '455927010000327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 (WAIT TIME 1 ms.) 29/10/2024 21:09:46.4366 5012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:09:52.3730 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 21:10:01.7320 1658 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/10/2024 21:11:03.8293 2835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:11:23.3218 4712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:11:30.8544 3422 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:11:37.2392 1769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:12:26.9262 515 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-29 21:12:26',0,0,'V',5404995877988210,5595209429565510,2024,'2024-10-29 21:12:26',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-29 21:12:26',0,0,'V',5404995877988210,5595209429565510,2024,'2024-10-29 21:12:26',3,'KES',-2,200,-400,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-29 21:12:26',0,0,'V',5404995877988210,5595209429565510,2024,'2024-10-29 21:12:26',3,'KES',-1,500,-500,'N',''); 29/10/2024 21:12:29.4441 2396 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-29 21:12:26',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-10-29 21:12:26',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-29 21:12:26',3,42101,0,500,-1,-500,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 29/10/2024 21:15:08.9010 532 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4999178646525550,5392877575004330,2024,'2024-10-29 21:15:08',' Date: 10/29/2024 9:15:07 PM Code: 455927556800327005012999 Entry Date: 10/29/2024 8:59:28 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 # 2400747590 ',0) 29/10/2024 21:15:10.0158 1112 ms. EXEC: update payReceipt set recCreation = '2024-10-29 21:15:08',recModify = '2024-10-29 21:15:08',recUseId=0,recStatus='V' where recId = 317338 29/10/2024 21:18:53.1141 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:21:48.0835 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:21:56.6299 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:22:18.8094 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:22:54.2178 672 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/10/2024 21:26:51.7718 2889 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/10/2024 21:28:23.9065 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:29:19.5129 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:29:37.3923 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:33:02.5242 593 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5600407524912440,5041055320785580,2024,'2024-10-29 21:33:01','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/29/2024 8:52:55 PM Date : 10/29/2024 9:33:01 PM Code : 455927517500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 29/10/2024 21:37:17.2760 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:43:13.2844 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:45:23.9938 805 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 21:45:44.0087 886 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-29 21:45:42',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 29/10/2024 21:48:14.6580 2481 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 21:52:21.3639 547 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/10/2024 21:53:46.9737 1457 ms. EXEC: update payReceipt set recCreation = '2024-10-29 21:53:45',recModify = '2024-10-29 21:53:45',recUseId=0,recStatus='V' where recId = 317343 29/10/2024 22:06:59.7096 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:08:28.1595 545 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-29 22:08:27' where payTraUID = 4974692432510290 and payStatus='V' and payEnabled=1 29/10/2024 22:09:23.2546 1635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:10:10.2406 1246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:12:55.6138 1961 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:13:07.3005 2226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:13:07.3015 2398 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/10/2024 22:13:20.8396 771 ms. OPEN: select * from tabDevice where devId = 4 and devStatus = 'V' 29/10/2024 22:13:42.7109 1228 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/10/2024 22:14:03.9438 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:14:55.2130 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:16:35.2015 573 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 29/10/2024 22:18:22.6116 1734 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-10-29 22:18:20','V',5419016588542140,2024,'2024-10-29 22:18:19','455928029900327005012999',1,2,16,'I','',1,0,1,'','0230003943530',44,0) 29/10/2024 22:18:24.2668 591 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 44 29/10/2024 22:18:27.6473 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 22:18:36.9573 617 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-10-29 22:18:36','V',5333809082317880,2024,'2024-10-29 22:18:34','455928031400327005012999',1,2,16,'I','',1,0,1,'','',4) 29/10/2024 22:22:58.7974 15945 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 29/10/2024 22:23:00.9610 1019 ms. OPEN: select * from payFiscalReport where fsrStatus='V' and fsrType = 2 and fsrUseId = 12 order by fsrDateTime desc (WAIT TIME 1140 ms.) 29/10/2024 22:26:19.9273 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:29:13.0343 559 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 29/10/2024 22:34:19.9741 570 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-10-29 22:34:19','V',5017705392500860,2024,'2024-10-29 22:34:17','455928125700327005012999',1,2,16,'I','',1,0,1,'','',4) 29/10/2024 22:35:53.7160 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:36:45.0302 521 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-29 22:36:44' where payTraUID = 5333809082317880 and payStatus='V' and payEnabled=1 29/10/2024 22:36:56.5989 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 22:41:59.4036 1100 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:54:34.7766 568 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/10/2024 22:54:35.4250 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 22:54:54.1470 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:56:09.1729 812 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-29 22:56:08',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'; 29/10/2024 22:57:47.0018 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 22:58:28.7660 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 22:59:06.9845 645 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-29 22:59:06' where payTraUID = 5432753801836110 and payStatus='V' and payEnabled=1 29/10/2024 22:59:13.7215 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 23:03:01.3391 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:09:52.5716 1083 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:09:55.5749 1372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:11:03.5756 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:12:50.1730 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/10/2024 23:12:50.3241 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:16:42.6213 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:23:22.7665 818 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 29/10/2024 23:24:16.5256 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:24:59.2454 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:25:07.1813 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:27:57.7014 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:41:42.6953 1918 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/10/2024 23:43:54.1943 678 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 29/10/2024 23:45:48.7877 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:48:52.3446 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:58:39.2370 1714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/10/2024 23:59:42.9865 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1