13/10/2023 10:10:22.4912 609 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-10-13 10:10:21',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 13/10/2023 13:18:28.1442 578 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-10-13 13:18:27' where traUID = 5430661882074020 and traStatus='V' and traEnabled=1 13/10/2023 14:19:34.4337 531 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18268, trcLastPrinted = '2300418268', trcLastDate = '2023-10-13 14:19:33' where trcStatus='V' and trcTerId = 4 13/10/2023 15:07:34.5134 558 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-10-13 15:07:33','V',5175657583645590,2023,'2023-10-13 15:07:33','452104993600327005012999',2,2,2,'O','',0,'2023-10-13 15:07:33',1,'','',0) (WAIT TIME 13 ms.) 13/10/2023 19:01:28.0622 609 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-10-13 19:01:27','V',5432989382802110,2023,'2023-10-13 19:01:26','452106477100327005012999',2,2,2,'O','',0,'2023-10-13 19:01:27',1,'','',0) 13/10/2023 21:50:04.4517 812 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