11/01/2023 07:38:33.3973   830 ms.           OPEN: select 1 as Tot,payUID,payPayed,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 = 7 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
11/01/2023 08:19:14.8281   546 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-01-11 08:19:10',5,3,42101,0,500,1,500,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-01-11 08:19:10',5,3,42101,0,50,10,500,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+10,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-01-11 08:19:10',5,3,42101,0,200,4,800,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+800,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-01-11 08:19:10',5,3,42101,0,100,12,1200,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+12,5),curAmount=round(curAmount+1200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

11/01/2023 13:34:19.1718   503 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-11 13:34:18','V',5493300677021620,2023,'2023-01-11 13:34:18','449354885800327005012999',1,2,16,'I','',1,0,1,'','',4)
11/01/2023 15:17:22.9409   685 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-11 15:17:22','V',5739644756137980,2023,'2023-01-11 15:17:21','449355288300327005012999',2,2,2,'O','',0,'2023-01-11 15:17:22',1,'','',0)
11/01/2023 18:20:19.6644   548 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-01-11 18:20:18',3,41101,0,10,1,10,1,'I','C');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+10,5) where curTerId = 3 and curDevCode = 41101 and curChannelId = 1 and curValue = 10 and curType = 'C';
Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-01-11 18:20:18',3,41101,0,20,2,40,1,'I','C');
update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+40,5) where curTerId = 3 and curDevCode = 41101 and curChannelId = 1 and curValue = 20 and curType = 'C';