09/12/2023 11:35:18.9253 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,'2023-12-09 11:35:18','V',5610346709562780,2023,'2023-12-09 11:35:18','452674171800327005012999',1,2,16,'I','',1,0,1,'','',4) 09/12/2023 12:23:20.4138 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,'2023-12-09 12:23:19','V',5727571480781230,2023,'2023-12-09 12:23:19','452674459900327005012999',1,2,16,'I','',1,0,1,'','',4) 09/12/2023 17:21:22.2016 546 ms. EXEC: update paycash set casCreation = '2023-12-09 17:21:21',casModify = '2023-12-09 17:21:21',casUseId=0,casStatus='V' where casId = 132420 09/12/2023 17:32:48.3814 610 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-12-09 17:32:47','V',4969102310772980,2023,'2023-12-09 17:32:46','452675947600327005012999',2,2,2,'O','',0,'2023-12-09 17:32:47',1,'','',0) 09/12/2023 20:23:45.9807 609 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-12-09 20:23:45' where payTraUID = 4877157159704140 and payStatus='V' and payEnabled=1 09/12/2023 23:58:09.3076 796 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