18/08/2024 06:24:53.1004   508 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
18/08/2024 10:08:32.5577   758 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,0,50,-20,-1000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,0,50,20,1000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,0,100,-50,-5000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,0,100,50,5000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,0,200,-3,-600,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,0,200,3,600,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,0,1000,-1,-1000,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,0,1000,1,1000,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-18 10:08:11',5,3,42101,1,0,0,0,1,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

18/08/2024 15:43:34.6925   510 ms.           EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-08-18 15:43:34',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','')
18/08/2024 17:03:44.0064   532 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-18 17:03:43' where traUID = 4907714282975020 and traStatus='V' and traEnabled=1
18/08/2024 19:19:25.2168   508 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-18 19:19:24',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';