04/06/2024 10:55:53.4989   515 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
04/06/2024 11:26:48.6018   562 ms.           EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-06-04 11:26:48',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','')
04/06/2024 11:33:04.7375  2218 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
04/06/2024 13:17:44.3843   531 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-06-04 13:17:43','V',4927896841204610,2024,'2024-06-04 13:17:42','454454786200327005012999',1,2,16,'I','',1,0,1,'','',4)
04/06/2024 16:05:01.1779   708 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 44 order by traDateTime desc,traId desc
04/06/2024 16:35:38.5239   562 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
04/06/2024 17:23:07.2259   546 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-06-04 17:23:06',0,'V',4755268989770300,5698962733194550,2024,'2024-06-04 17:23:06',18,1,0,4,'2024-06-04 17:38:06','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
04/06/2024 18:56:37.2706  1453 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3)
04/06/2024 19:06:37.2228   718 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1