26/08/2023 08:13:23.6699   550 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 ('2023-08-26 08:12:08',10,'V',5390898437637500,5229404157557300,2023,'2023-08-26 08:12:08',4,1,0,4,'2023-08-26 08:27:08','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
26/08/2023 08:58:19.8201   714 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-08-26 08:58:19' where traUID = 4996545059975340 and traStatus='V' and traEnabled=1
26/08/2023 10:24:59.3312   660 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,'2023-08-26 10:24:58','V',4838065904674480,2023,'2023-08-26 10:24:58','451623749800327005012999',1,2,16,'I','',1,0,1,'','',4)
26/08/2023 11:02:32.5480   613 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-08-26 11:02:31' where traUID = 4650767976860310 and traStatus='V' and traEnabled=1
26/08/2023 12:21:32.7417   571 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,'2023-08-26 12:21:32','V',5582775456710750,2023,'2023-08-26 12:21:32','451624216600327005012999',2,2,2,'O','',0,'2023-08-26 12:21:32',1,'','',0)
26/08/2023 12:24:50.7769   592 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
26/08/2023 13:11:52.2473   590 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
26/08/2023 13:35:43.5905   558 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-08-26 13:35:42' where traUID = 4667613159592420 and traStatus='V' and traEnabled=1
26/08/2023 13:42:55.1411   766 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
26/08/2023 14:58:30.4522   928 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,'2023-08-26 14:58:29','V',5629888934380520,2023,'2023-08-26 14:58:29','451625390900327001012999',1,2,1,'I','',1,0,1,'','',4)
26/08/2023 17:38:10.1869   574 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,'2023-08-26 17:38:09','V',5121049643476260,2023,'2023-08-26 17:38:09','451626049800327005012999',2,2,2,'O','',0,'2023-08-26 17:38:09',1,'','',0)
26/08/2023 19:30:28.9994  1351 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1