21/11/2023 08:55:03.5705   687 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,50,-3,-150,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,50,3,150,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,100,-37,-3700,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,100,37,3700,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,200,-10,-2000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,200,10,2000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,500,-3,-1500,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,500,3,1500,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,1000,-2,-2000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,0,1000,2,2000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 08:54:53',5,3,42101,1,0,0,0,1,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

21/11/2023 09:51:45.2063  2390 ms.           OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal
21/11/2023 10:38:24.2537  1437 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-11-21 10:38:22',3,42101,0,50,-1,-50,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';
Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-11-21 10:38:22',3,42101,0,100,-2,-200,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';
Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-11-21 10:38:22',3,42101,0,200,-1,-200,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';
 (WAIT TIME 46 ms.)
21/11/2023 14:04:57.4790   562 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-11-21 14:04:56' where traUID = 4909353973128430 and traStatus='V' and traEnabled=1
21/11/2023 16:50:53.8178   687 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-11-21 16:50:53',3,42101,0,50,1,50,2,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N';

21/11/2023 20:17:11.4206   625 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-11-21 20:17:10','V',4783180055176800,2023,'2023-11-21 20:17:09','452497302900327001012999',1,2,1,'I','',1,0,1,'','',4)