22/12/2024 00:43:00.1842   538 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-22 00:42:59' where traUID = 4899015327593660 and traStatus='V' and traEnabled=1
22/12/2024 00:55:08.9723  1085 ms.           EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001);
22/12/2024 01:01:41.2614   750 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 01:19:32.7771   558 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 01:23:20.4723   775 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 01:48:47.0052   506 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)
22/12/2024 01:49:22.6911  1135 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 02:03:00.7188   774 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 02:09:04.0253   547 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 02:11:59.6802   575 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-22 02:11:59' where traUID = 4645031930409810 and traStatus='V' and traEnabled=1
22/12/2024 04:28:17.0275   549 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 05:57:34.4656   833 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 06:26:30.8593   558 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 06:29:08.7678   513 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-22 06:29:08','V',5462400223427300,2024,'2024-12-22 06:29:07','456462220600327005012999',2,2,2,'O','',0,'2024-12-22 06:29:08',1,'','',0)
22/12/2024 06:37:25.5181   871 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
22/12/2024 06:37:30.0891   771 ms.           EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001);
22/12/2024 06:37:30.1041   635 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 06:37:45.6815   521 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1
22/12/2024 06:37:54.2583   586 ms.           OPEN: select * from tabarea where areStatus='V' and areId = 1
22/12/2024 06:40:37.5666   703 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 06:43:24.1213   534 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-22 06:43:23' where payTraUID = 4905566743280880 and payStatus='V' and payEnabled=1
22/12/2024 06:44:15.8779   570 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 06:44:24.1696   543 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 06:50:14.0658   514 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-22 06:50:13','V',5450993262633590,2024,'2024-12-22 06:50:12','456462461200327005012999',1,2,16,'I','',1,0,1,'','',4)
22/12/2024 06:52:01.0139  1052 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 08:00:45.8087   761 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-22 08:00:45' where payTraUID = 5674482646263070 and payStatus='V' and payEnabled=1
22/12/2024 08:15:49.8952   661 ms.           OPEN: select * from tabarea where areStatus='V' and areId = 1
22/12/2024 08:21:20.6173   546 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 08:26:06.0786   583 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 09:07:37.7435   790 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 09:14:22.4604   671 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 09:16:11.6444   516 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/12/2024 10:47:29.2570   535 ms.           EXEC: update paycash set casCreation = '2024-12-22 10:47:28',casModify = '2024-12-22 10:47:28',casUseId=0,casStatus='V' where casId = 201371
22/12/2024 11:20:54.8936   550 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-22 11:20:54' where traUID = 5339687732507980 and traStatus='V' and traEnabled=1
22/12/2024 11:53:36.4972   574 ms.           EXEC: update payReceipt set recCreation = '2024-12-22 11:53:35',recModify = '2024-12-22 11:53:35',recUseId=0,recStatus='V' where recId = 335056
22/12/2024 12:06:15.4383   516 ms.           EXEC: update payInventory set invCreation = '2024-12-22 12:06:14',invModify = '2024-12-22 12:06:14',invUseId=0,invStatus='V' where invId = 226932
22/12/2024 13:04:56.6299   827 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-22 13:04:55',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-22 13:04:55',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';

22/12/2024 14:20:44.1645   519 ms.           EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 385924 else acvFstPayId end),acvLstPayId = 385924 where acvSftId = 866 and acvCodeId = 3
22/12/2024 14:36:50.2315   726 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-22 14:36:49' where payTraUID = 4771540501033350 and payStatus='V' and payEnabled=1
22/12/2024 14:48:47.2851   514 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-22 14:48:46',0,'V',5106100227422810,5354066177339300,2024,'2024-12-22 14:48:46',18,1,0,4,'2024-12-22 15:03:46','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
22/12/2024 16:25:54.8909   543 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-22 16:25:54','V',4766848600442030,2024,'2024-12-22 16:25:53','456465915300327005012999',1,2,16,'I','',1,0,1,'','',4)
22/12/2024 16:25:55.7284   690 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 14 ms.)
22/12/2024 19:55:14.4851   502 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-22 19:55:13' where traUID = 5024572535021560 and traStatus='V' and traEnabled=1