25/09/2024 03:27:53.2821   555 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
25/09/2024 04:27:18.7663   507 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-09-25 04:27:18' where traUID = 4643770491605760 and traStatus='V' and traEnabled=1
25/09/2024 09:49:29.4055  5177 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 = 12 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
25/09/2024 13:46:06.9385   593 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-09-25 13:46:06','V',5382044197374020,2024,'2024-09-25 13:46:06','455584673000327005012999',2,2,2,'O','',0,'2024-09-25 13:46:06',1,'','',0)
25/09/2024 13:46:07.9304   863 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-25 13:46:07' where payTraUID = 5549169822106200 and payStatus='V' and payEnabled=1
25/09/2024 14:25:37.6452   557 ms.           EXEC: update abbCards set carLastDate = '2024-09-25 14:25:37',carLastDirection='I' where carStatus='V' and carId = 20
25/09/2024 17:32:17.2348   504 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
25/09/2024 19:17:28.4565  1407 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 = 1 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
25/09/2024 20:39:31.3771  1019 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 = 10 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
25/09/2024 22:34:35.7213   547 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-25 22:34:35' where payTraUID = 4637135490690980 and payStatus='V' and payEnabled=1