29/05/2023 08:07:12.9411   587 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-05-29 08:05:26',5,3,42101,0,50,-16,-800,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-05-29 08:05:26',5,3,42101,0,50,16,800,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-05-29 08:05:26',5,3,42101,0,100,-55,-5500,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-05-29 08:05:26',5,3,42101,0,100,55,5500,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-05-29 08:05:26',5,3,42101,0,200,-7,-1400,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-05-29 08:05:26',5,3,42101,0,200,7,1400,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-05-29 08:05:26',5,3,42101,1,0,0,0,1,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

29/05/2023 15:42:44.6751   507 ms.           EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2023-05-29 15:42:43',0,'V',5534946271235030,5192225296806190,2023,'2023-05-29 15:42:43',3,1,0,4,'2023-05-29 15:57:43','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 9 ms.)
29/05/2023 15:57:29.8431   610 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-05-29 15:57:29',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-05-29 15:57:29',3,42101,0,100,-1,-100,1,'O','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';

29/05/2023 18:16:54.9625   566 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-05-29 18:16:54' where traUID = 5055534659292870 and traStatus='V' and traEnabled=1
29/05/2023 20:14:56.2582   732 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-05-29 20:14:55',3,42101,0,50,1,50,1,'I','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';