15/10/2022 13:26:30.6745 510 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2022-10-15 13:26:29',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 ('2022-10-15 13:26:29',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2022-10-15 13:26:29',3,42101,0,500,-1,-500,1,'O','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'; 15/10/2022 15:27:44.2411 649 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-10-15 15:27:43',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N';