24/09/2022 04:39:02.3852 682 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-09-24 04:38:46',4,3,42101,0,100,-38,-3800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-09-24 04:38:46',4,3,42101,0,100,38,3800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-09-24 04:38:46',4,3,42101,0,200,-1,-200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-09-24 04:38:46',4,3,42101,0,200,1,200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-09-24 04:38:46',4,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-09-24 04:38:46',4,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-09-24 04:38:46',4,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 24/09/2022 11:58:10.0671 538 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2022-09-24 11:58:09' where traUID = 4799379266237190 and traStatus='V' and traEnabled=1 24/09/2022 12:42:58.3508 576 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2022-09-24 12:42:57' where traUID = 5721458452665360 and traStatus='V' and traEnabled=1 24/09/2022 15:36:35.5476 501 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/09/2022 17:21:13.2249 545 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,'2022-09-24 17:21:12','V',5425541639479830,2022,'2022-09-24 17:21:12','448266006600327005012999',2,2,2,'O','',0,'2022-09-24 17:21:12',1,'','',0) 24/09/2022 17:55:31.6978 542 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-09-24 17:55:31',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'; 24/09/2022 19:19:41.2680 558 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2022-09-24 19:19:40',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 ('2022-09-24 19:19:40',3,41003,0,40,1,40,2,'I','C'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+40,5) where curTerId = 3 and curDevCode = 41003 and curChannelId = 2 and curValue = 40 and curType = 'C';