29/12/2024 00:03:24.7739 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 00:17:34.4551 664 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 00:18:38.7371 1514 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-29 00:18:37','V',5693991290628820,2024,'2024-12-29 00:18:35','456528448600327005012999',2,2,2,'O','',0,'2024-12-29 00:18:37',1,'','',0) 29/12/2024 00:18:39.7848 544 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 00:18:39' where traUID = 4861241861805230 and traStatus='V' and traEnabled=1 29/12/2024 00:24:31.1257 1189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 00:25:36.5125 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 00:32:46.1314 636 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 388176 else acvFstPayId end),acvLstPayId = 388176 where acvSftId = 869 and acvCodeId = 3 29/12/2024 00:36:37.4353 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 00:40:01.8135 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 00:41:46.3480 1728 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 00:42:41.1677 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 00:42:48.0873 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 00:43:25.2051 1543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 29/12/2024 00:44:21.2656 1905 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 00:47:13.2577 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 00:48:12.5514 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 01:00:05.0624 994 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 01:07:44.7253 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 01:15:25.5120 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 01:16:38.5118 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 01:17:53.5624 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 01:17:57.5210 1194 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 01:18:20.2742 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 01:20:16.0700 2517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 01:22:48.9466 1119 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 01:25:20.8481 1065 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/12/2024 01:35:13.5538 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 01:43:59.8409 1203 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 01:49:52.7748 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 02:05:38.3878 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 02:34:26.6359 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 02:37:10.3295 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 02:42:55.4705 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 03:14:43.3096 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 03:23:17.0269 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 104 ms.) 29/12/2024 03:23:28.6116 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 03:24:04.4656 768 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 03:24:46.9904 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 04:03:50.4271 1505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 04:10:54.9539 1136 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 05:06:03.5894 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 05:06:37.5912 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 05:09:29.8003 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 05:14:23.0098 1469 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 05:14:51.2757 564 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 29/12/2024 06:03:02.3437 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 06:32:46.5992 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 06:35:18.0592 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 06:56:41.8994 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 06:58:06.2689 636 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 29/12/2024 07:07:51.3403 667 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-29 07:07:50','V',5110326533665960,2024,'2024-12-29 07:07:49','456532566900327005012999',1,2,16,'I','',1,0,1,'','',4) 29/12/2024 07:08:11.3393 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 07:22:47.8871 1092 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 388197 else acvFstPayId end),acvLstPayId = 388197 where acvSftId = 869 and acvCodeId = 3 29/12/2024 07:27:13.4758 562 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 07:27:12' where traUID = 5496717006889570 and traStatus='V' and traEnabled=1 29/12/2024 07:31:52.5879 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 07:41:56.7853 1020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 07:45:51.7611 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 07:57:33.4499 1073 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 08:01:32.4009 564 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/12/2024 08:06:03.1229 1429 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 08:07:18.1800 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 08:10:24.1703 700 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 29/12/2024 08:44:55.4672 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 08:44:55.5903 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 08:47:44.7874 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 08:50:55.8351 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 09:04:16.3842 1222 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 09:06:24.6549 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 09:14:19.2378 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 09:39:06.8192 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 09:39:28.2215 1438 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 09:44:56.3979 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 09:44:58.7524 920 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-29 09:44:57',0,0,'V',4784687991727240,4700907704336140,2024,'2024-12-29 09:44:57',3,'KES',-1,50,-50,'N',''); 29/12/2024 09:44:59.5690 758 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-29 09:44:57',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/12/2024 09:45:00.9049 1334 ms. EXEC: update payInventory set invCreation = '2024-12-29 09:44:59',invModify = '2024-12-29 09:44:59',invUseId=0,invStatus='V' where invId = 228112 29/12/2024 09:47:05.1029 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 09:50:27.6204 677 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 10:01:33.3353 534 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 10:01:32' where traUID = 5619473735790900 and traStatus='V' and traEnabled=1 29/12/2024 10:04:36.5448 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 10:05:12.0750 588 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:00:09',5,3,42101,0,50,-14,-700,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:00:09',5,3,42101,0,50,14,700,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:00:09',5,3,42101,0,100,-29,-2900,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:00:09',5,3,42101,0,100,29,2900,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:00:09',5,3,42101,0,200,-4,-800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:00:09',5,3,42101,0,200,4,800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:00:09',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-29 10:00:09',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-29 10:00:09',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 29/12/2024 10:05:12.9045 551 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:05:05',5,3,42101,0,50,-21,-1050,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:05:05',5,3,42101,0,100,-31,-3100,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:05:05',5,3,42101,0,200,-5,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:05:05',5,3,42101,0,500,-2,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 10:05:05',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 29/12/2024 10:11:22.3661 742 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-29 10:11:21',0,'V',5561040234082640,5347482532052110,2024,'2024-12-29 10:11:21',18,1,0,4,'2024-12-29 10:26:21','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/12/2024 10:30:40.3316 657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 10:31:01.6009 603 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 10:31:01.6099 619 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/12/2024 10:31:01.7620 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 10:32:03.5603 513 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-29 10:32:06',6,'V',5583306413092480,5063927413058350,2024,'2024-12-29 10:32:06',4,1,0,4,'2024-12-29 10:47:06','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/12/2024 10:32:18.1040 569 ms. EXEC: update tabArea set areFreePark = areTotalPark where areStatus='V' and areTotalPark > 0 and areFreePark>areTotalPark 29/12/2024 10:37:30.8033 551 ms. EXEC: update abbCards set carLastDate = '2024-12-29 10:37:30',carLastDirection='O' where carStatus='V' and carId = 181 29/12/2024 10:37:32.2653 1327 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-29 10:37:30' where payTraUID = 5365558970644090 and payStatus='V' and payEnabled=1 29/12/2024 10:44:56.3129 799 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/12/2024 10:45:01.4403 615 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 29/12/2024 10:45:01.6835 617 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/12/2024 10:45:02.7802 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 10:45:07.6635 616 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 29/12/2024 10:54:47.8416 1202 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 10:56:08.2594 884 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/12/2024 11:01:27.7159 838 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/12/2024 11:04:08.7776 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 11:17:50.8117 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:18:04.9852 790 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4754659806020030,4993503990679380,2024,'2024-12-29 11:18:04','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/29/2024 10:01:49 AM Date : 12/29/2024 11:18:02 AM Code : 456533610900327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 29/12/2024 11:22:19.0670 940 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:24:08.7924 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 11:25:59.3533 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:28:28.8630 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:30:08.8469 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:33:00.8388 2357 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 11:33:01.6853 814 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/12/2024 11:35:51.2480 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:42:04.7757 823 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-29 11:42:02',0,'V',5733932426860550,5403969855277700,2024,'2024-12-29 11:42:02',3,1,0,4,'2024-12-29 11:57:02','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 29/12/2024 11:43:36.8652 1195 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:45:11.8547 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:47:12.2332 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 11:51:25.2984 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 12:08:26.1366 579 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-29 12:08:25' where payTraUID = 4957782826947560 and payStatus='V' and payEnabled=1 29/12/2024 12:21:11.5507 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 12:35:50.2656 1076 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-29 12:35:49' where payTraUID = 5023238970593290 and payStatus='V' and payEnabled=1 29/12/2024 12:35:56.2826 777 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/12/2024 12:36:07.8554 643 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/12/2024 12:36:48.5085 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 12:38:28.7495 741 ms. EXEC: update payReceipt set recCreation = '2024-12-29 12:38:28',recModify = '2024-12-29 12:38:28',recUseId=0,recStatus='V' where recId = 337143 29/12/2024 12:40:11.8435 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 12:42:23.5571 599 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 29/12/2024 12:45:44.5700 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 12:45:53.8773 700 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/12/2024 12:45:53.8863 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 12:53:48.9216 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 12:57:45.4417 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 12:57:47.2489 559 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 29/12/2024 13:03:17.5918 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 13:05:19.2681 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 13:07:39.7930 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 13:14:13.1850 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 13:29:13.3780 552 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/12/2024 13:31:09.9547 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 13:33:01.1293 1283 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 13:34:24.4392 584 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-29 13:34:23' where payTraUID = 4957430974369990 and payStatus='V' and payEnabled=1 29/12/2024 13:34:29.3424 516 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/12/2024 13:34:30.2991 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 13:38:27.2241 1598 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-29 13:38:25','0810007108790',-50,7600,5741365267659180,194,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/12/2024 13:38:27.9536 633 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-29 13:38:27',0,'V',5741365267659180,5468313852749730,2024,'2024-12-29 13:38:27',2,1,0,-1,'2024-12-29 14:38:27','S','KES',50,50,0,'','','',3,50,0,0,'',0,0) 29/12/2024 13:38:29.6537 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 13:39:11.2545 555 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 13:47:51.4277 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 13:47:52.2953 839 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/12/2024 13:49:24.2117 614 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-29 13:49:23',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 29/12/2024 13:53:00.3732 570 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-12-29 12:52:59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-29 13:52:59' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-29 13:52:59' and (resAreId = 1 or resAreId <= 0) nr: 0 29/12/2024 13:53:23.5847 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 13:55:41.0074 587 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-29 13:55:40','V',5132852079546490,2024,'2024-12-29 13:55:38','456534944400327005012999',2,2,2,'O','',0,'2024-12-29 13:55:40',1,'','',0) 29/12/2024 13:55:45.2322 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 13:55:45.6064 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 13:59:27.6178 587 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-29 13:59:27','V',5443075614419110,2024,'2024-12-29 13:59:25','456535036500327005012999',1,2,16,'I','',1,0,1,'','',4) 29/12/2024 14:14:23.3506 532 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55553, trcLastPrinted = '2400755553', trcLastDate = '2024-12-29 14:14:22' where trcStatus='V' and trcTerId = 18 29/12/2024 14:15:46.1361 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 14:22:31.6970 552 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/12/2024 14:25:46.9205 1003 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/12/2024 14:27:58.2843 516 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/12/2024 14:29:30.1467 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 14:30:04.9440 1032 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/12/2024 14:30:41.0541 1447 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 14:30:39' where traUID = 5619482265449050 and traStatus='V' and traEnabled=1 29/12/2024 14:30:47.1332 823 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 14:40:20.2739 971 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-29 14:40:19' where payTraUID = 5693071504812110 and payStatus='V' and payEnabled=1 29/12/2024 14:40:22.5694 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 14:49:42.2946 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 14:49:50.5391 2482 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 29/12/2024 14:49:50.5431 2470 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 14:54:42.6724 1245 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 29/12/2024 14:57:01.6743 786 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 14:57:00' where traUID = 5276989867861580 and traStatus='V' and traEnabled=1 29/12/2024 14:57:53.9132 1333 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-29 14:57:52' where payTraUID = 5614795065312950 and payStatus='V' and payEnabled=1 29/12/2024 15:00:11.5792 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 15:28:27.4322 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 15:54:37.6225 734 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/12/2024 15:54:38.7232 765 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 15:54:37' where traUID = 5061369900868310 and traStatus='V' and traEnabled=1 29/12/2024 15:58:53.2023 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 16:01:15.9548 706 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-29 16:01:15','V',5049704522992490,2024,'2024-12-29 16:01:14','456535036500327005012999',2,2,2,'O','',0,'2024-12-29 16:01:15',1,'','',0) 29/12/2024 16:01:23.7400 1112 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 16:03:24.3009 802 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 29/12/2024 16:04:49.5839 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 16:23:46.5466 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 16:27:37.1207 1064 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 16:31:13.9476 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 16:34:28.6128 747 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-29 16:34:27',0,0,'V',4748331629166340,5065566772282310,2024,'2024-12-29 16:34:27',3,'KES',1,100,100,'N',''); 29/12/2024 16:34:29.7265 778 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 16:34:28',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-29 16:34:28',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'; 29/12/2024 16:37:00.5583 926 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 16:36:59' where traUID = 5065566772282310 and traStatus='V' and traEnabled=1 29/12/2024 16:39:49.6023 2217 ms. EXEC: update payReceipt set recCreation = '2024-12-29 16:39:47',recModify = '2024-12-29 16:39:47',recUseId=0,recStatus='V' where recId = 337203 29/12/2024 16:45:07.4339 517 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/12/2024 16:48:24.3401 676 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 29/12/2024 16:54:18.6855 837 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5407489779920690,4987566797621770,2024,'2024-12-29 16:54:17',' Date: 12/29/2024 4:54:16 PM Code: 456536029400327005012999 Entry Date: 12/29/2024 4:44:54 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 # 2400755578 ',0) 29/12/2024 16:58:07.9933 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 16:59:20.8319 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 17:03:04.5439 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 17:05:26.9455 563 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/12/2024 17:05:28.0622 678 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 17:05:26' where traUID = 5281067606145840 and traStatus='V' and traEnabled=1 29/12/2024 17:05:59.1090 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 17:09:22.9146 575 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/12/2024 17:16:27.5124 689 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 17:20:08.7753 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 17:20:09.3768 1199 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/12/2024 17:27:52.0652 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 17:31:45.4613 613 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-29 17:31:44',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/12/2024 17:33:30.8447 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 17:34:44.6200 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 17:43:58.9866 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 17:47:49.9370 911 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/12/2024 17:51:04.8713 1494 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 17:57:06.6989 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 17:57:06.8560 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 18:05:12.7638 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 18:07:57.8951 570 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 18:07:57' where traUID = 4872860157889930 and traStatus='V' and traEnabled=1 29/12/2024 18:08:03.9252 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 18:17:29.4433 1956 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/12/2024 18:17:30.8202 1196 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 18:17:29' where traUID = 5138811306778670 and traStatus='V' and traEnabled=1 29/12/2024 18:17:35.5103 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 18:18:54.9915 1111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 18:18:59.0762 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 18:19:14.0712 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 18:20:31.7692 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-29 18:20:31','V',5341697937368200,2024,'2024-12-29 18:20:30','456536603000327005012999',1,2,16,'I','',1,0,1,'','',4) 29/12/2024 18:27:33.4641 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 18:28:37.0706 523 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 18:30:48.8557 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 18:46:40.9626 962 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 18:50:56.3433 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 18:51:06.8874 740 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 19:10:43.1038 794 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 19:17:01.3139 751 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/12/2024 19:21:51.6840 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 19:21:58.2804 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 19:22:33.7501 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 19:25:02.7260 818 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-29 19:25:01',0,'V',5459516893696380,4720555574839330,2024,'2024-12-29 19:25:01',18,1,0,4,'2024-12-29 19:40:01','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 49 ms.) 29/12/2024 19:25:17.5889 753 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 29/12/2024 19:33:47.3612 543 ms. EXEC: update payReceipt set recCreation = '2024-12-29 19:33:46',recModify = '2024-12-29 19:33:46',recUseId=0,recStatus='V' where recId = 337241 29/12/2024 19:40:41.5330 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 19:41:39.5208 6143 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 29/12/2024 19:44:53.7716 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 19:45:29.6336 1174 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 = 9 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/12/2024 19:46:47.8979 1037 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/12/2024 19:51:20.0729 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 19:54:35.8527 612 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 19:58:03.7698 544 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/12/2024 20:04:13.2334 520 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5432813477243330,5185872836260600,2024,'2024-12-29 20:04:12','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/29/2024 6:57:58 PM Date : 12/29/2024 8:04:11 PM Code : 456536827800327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 29/12/2024 20:09:02.6029 675 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-29 20:09:01','V',5422351783022400,2024,'2024-12-29 20:08:59','456536827800327005012999',2,2,2,'O','',0,'2024-12-29 20:09:01',1,'','',0) 29/12/2024 20:14:19.1580 714 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 20:17:51.2250 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 20:24:52.2052 1053 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 20:35:58.3508 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 20:37:01.1687 1068 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/12/2024 20:37:03.3712 861 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 29/12/2024 20:37:54.5214 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 20:42:03.2647 890 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 20:49:05.7435 530 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/12/2024 20:52:15.2432 505 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-29 20:52:14',0,'V',5304269675376430,5583251623295230,2024,'2024-12-29 20:52:14',18,1,0,4,'2024-12-29 21:07:14','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 29/12/2024 20:52:41.8745 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 21:02:16.9605 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 21:06:11.0569 504 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 21:06:10' where traUID = 5583251623295230 and traStatus='V' and traEnabled=1 29/12/2024 21:06:18.8191 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 21:07:47.8976 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 21:07:54.5241 659 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 21:07:53' where traUID = 5228355851290660 and traStatus='V' and traEnabled=1 29/12/2024 21:08:02.3043 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 21:11:09.0141 872 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-29 21:11:08',17,1,'2024-12-29 21:11:08','456536903800327005012999','Pagato (Contanti ) Biglietto ') 29/12/2024 21:18:03.7752 1080 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-29 21:18:02' where traUID = 5178264537564770 and traStatus='V' and traEnabled=1 29/12/2024 21:18:17.3733 580 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/12/2024 21:18:17.5384 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 21:28:09.0819 664 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 29/12/2024 21:29:40.4299 885 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 21:30:34.5211 1756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 21:32:55.5297 562 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/12/2024 21:33:09.1968 507 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-29 21:33:08',4,9,'2024-12-29 21:33:08','456537367900327005012999','Payed (Credit Card ) Ticket ') 29/12/2024 21:36:16.2142 1005 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 21:36:17.1598 936 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 29/12/2024 21:45:20.1263 890 ms. EXEC: update abbCards set carLastDate = '2024-12-29 21:45:19',carLastDirection='O' where carStatus='V' and carId = 14 29/12/2024 21:56:05.0773 592 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-29 21:56:04','V',5259683251759660,2024,'2024-12-29 21:56:02','456537896200327005012999',1,2,16,'I','',1,0,1,'','',4) 29/12/2024 21:58:21.2824 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 22:07:23.6960 1335 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55615, trcLastPrinted = '2400755615', trcLastDate = '2024-12-29 22:07:22' where trcStatus='V' and trcTerId = 18 29/12/2024 22:12:10.5590 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 22:12:13.8842 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 22:12:14.4276 542 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/12/2024 22:21:34.6153 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 22:36:34.3022 1296 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 22:36:58.8886 583 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 29/12/2024 22:37:48.7410 1082 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-29 22:37:47' where subId = 16 29/12/2024 22:44:03.4520 628 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 22:50:53.9262 676 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 22:51:51.4676 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 22:55:25.4784 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 22:57:42.3719 638 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/12/2024 22:57:54.9773 1051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 23:08:55.3340 817 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/12/2024 23:14:56.6915 552 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-29 23:14:55',0,'V',5166661024789530,4739261162719610,2024,'2024-12-29 23:14:55',18,1,0,4,'2024-12-29 23:29:55','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 29/12/2024 23:17:00.9776 2136 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 29/12/2024 23:17:06.4563 700 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 29/12/2024 23:24:13.7667 1654 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 29/12/2024 23:29:49.6966 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 23:31:05.1362 1522 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 23:32:24.8515 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 23:37:11.3558 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 23:51:08.9112 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 29/12/2024 23:51:12.5827 546 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 29/12/2024 23:51:12.7137 678 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 29/12/2024 23:51:13.5593 785 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/12/2024 23:58:47.8768 1092 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)