23/09/2024 00:10:36.2551  4736 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V'
23/09/2024 00:10:36.2781  4761 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1)
23/09/2024 00:10:41.0533  4785 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
23/09/2024 00:10:45.7845  3224 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5
23/09/2024 00:10:50.5047  1039 ms.           OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1
23/09/2024 00:14:15.2512  4571 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 77 ms.)
23/09/2024 01:06:09.2291  5341 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
23/09/2024 01:06:43.6141  7115 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
23/09/2024 01:06:53.4587  1471 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
23/09/2024 01:07:26.3807  1549 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
23/09/2024 01:07:37.1399  6711 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
23/09/2024 01:07:43.0048  5567 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2
23/09/2024 09:35:52.9247   568 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
23/09/2024 09:43:26.6939   566 ms.           EXEC: update paycash set casCreation = '2024-09-23 09:43:26',casModify = '2024-09-23 09:43:26',casUseId=0,casStatus='V' where casId = 185965
23/09/2024 10:48:35.3340   524 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-23 10:48:34' where payTraUID = 4793515842017700 and payStatus='V' and payEnabled=1
23/09/2024 10:54:41.7210  2449 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
23/09/2024 11:10:39.6800   657 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
23/09/2024 11:43:08.0161   632 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-09-23 11:43:07' where traUID = 5505594165258710 and traStatus='V' and traEnabled=1
23/09/2024 11:46:43.7626   656 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-09-23 11:46:43' where traUID = 4980787490566280 and traStatus='V' and traEnabled=1
23/09/2024 12:39:25.0377   552 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-23 12:39:24' where payTraUID = 5465622323893470 and payStatus='V' and payEnabled=1
23/09/2024 13:29:36.6364   533 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-09-23 13:29:36',3,42101,0,200,1,200,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';

23/09/2024 14:00:53.1342   504 ms.           EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-09-23 14:00:52',0,16,'2024-09-23 14:00:52','','Unauthorized Transit  Entry 2')
23/09/2024 14:51:20.6615   502 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-09-23 14:51:20',0,'V',5244685737539470,4824971313195120,2024,'2024-09-23 14:51:20',18,1,0,4,'2024-09-23 15:06:20','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)