23/09/2023 07:52:18.4015   515 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-23 07:52:14',5,3,42101,0,50,-39,-1950,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-23 07:52:14',5,3,42101,0,100,-84,-8400,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-23 07:52:14',5,3,42101,0,200,-11,-2200,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-23 07:52:14',5,3,42101,0,500,-3,-1500,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-23 07:52:14',5,3,42101,0,1000,-1,-1000,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-23 07:52:14',5,3,42101,1,0,0,0,2,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

23/09/2023 09:28:21.3036   750 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-09-23 09:28:20',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';

23/09/2023 11:33:27.1491   578 ms.     EXECSCALAR: select traId from movTransit where traId>403977 and traIdTerminal = 2 and traDirection = 'O' and traCarId = 37 order by traId desc nr: 404011
23/09/2023 14:14:21.8894   516 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-23 14:14:21' where traUID = 5698364410860500 and traStatus='V' and traEnabled=1
23/09/2023 19:50:34.6237   515 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-23 19:50:34' where traUID = 5510853531901850 and traStatus='V' and traEnabled=1
23/09/2023 21:47:33.7840   515 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-09-23 21:45:57',12,'V',5463553601018160,4702591562798820,2023,'2023-09-23 21:45:57',17,1,0,4,'2023-09-23 22:00:57','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)