12/01/2024 09:41:56.3678   531 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-01-12 09:41:55','V',5209484963419570,2024,'2024-01-12 09:41:55','453013196900327005012999',2,2,2,'O','',0,'2024-01-12 09:41:55',1,'','0230003943486',139,0)
12/01/2024 10:45:03.6835   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-01-12 10:45:03','V',5170064105329970,2024,'2024-01-12 10:45:01','453013870100327001012999',1,2,1,'I','',1,0,1,'','',4)
12/01/2024 12:15:46.4638   578 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-01-12 12:15:45','V',5243793709853020,2024,'2024-01-12 12:15:45','453014414500327005012999',1,2,16,'I','',1,0,1,'','',4)
12/01/2024 13:28:35.0069   502 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-01-12 13:28:34','V',4693088869556580,2024,'2024-01-12 13:28:33','453014076800327005012999',2,2,2,'O','',0,'2024-01-12 13:28:34',1,'','',0)
12/01/2024 13:49:20.0093   625 ms.           EXEC: update abbCards set carLastDate = '2024-01-12 13:49:19',carLastDirection='I' where carStatus='V' and carId = 103
12/01/2024 15:47:35.1161   531 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
12/01/2024 20:58:39.7729   515 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-01-12 20:58:39','V',5692693062447650,2024,'2024-01-12 20:58:38','453016981800327005012999',2,2,2,'O','',0,'2024-01-12 20:58:39',1,'','',0)
12/01/2024 21:16:48.9721   780 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