06/01/2023 10:12:42.1885 616 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 06/01/2023 14:40:08.2785 530 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-01-06 14:40:07' where payTraUID = 5690032268257690 and payStatus='V' and payEnabled=1 06/01/2023 15:07:13.4013 600 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-01-06 15:07:12','V',5046018732784100,2023,'2023-01-06 15:07:12','449305443200327005012999',1,2,16,'I','',1,0,1,'','',4) 06/01/2023 17:26:59.2308 531 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-01-06 17:26:58' where payTraUID = 5479759358949680 and payStatus='V' and payEnabled=1 06/01/2023 20:58:44.5147 594 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-50,5),subLastDebit = '2023-01-06 20:58:43' where subId = 72 06/01/2023 21:50:29.0629 596 ms. EXEC: update payInventory set invCreation = '2023-01-06 21:50:28',invModify = '2023-01-06 21:50:28',invUseId=0,invStatus='V' where invId = 44142