22/08/2024 09:31:46.8497   507 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-22 09:31:46' where traUID = 5551766951279980 and traStatus='V' and traEnabled=1
22/08/2024 10:42:56.8866   668 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-22 10:42:56',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';

22/08/2024 11:19:27.1488  3600 ms.           OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal
22/08/2024 14:23:36.8034   639 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-22 14:23:36' where traUID = 4889623521250360 and traStatus='V' and traEnabled=1
22/08/2024 15:01:41.6292   535 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 ('2024-08-22 15:01:39',0,'V',4893102207299850,4788448933050030,2024,'2024-08-22 15:01:39',3,1,0,4,'2024-08-22 15:16:39','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0)
22/08/2024 15:03:45.8264   561 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,'2024-08-22 15:03:45','V',5515368910860150,2024,'2024-08-22 15:03:44','455245098800327005012999',2,2,2,'O','',0,'2024-08-22 15:03:45',1,'','',0)
22/08/2024 18:01:44.3175   850 ms.           EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-22 18:01:42',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 ('2024-08-22 18:01:42',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';
Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-22 18:01:42',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';

22/08/2024 18:45:38.1198   519 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-22 18:45:37' where payTraUID = 5355430894354550 and payStatus='V' and payEnabled=1
22/08/2024 19:26:10.7152   611 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-08-22 19:26:10','V',4693547247673930,2024,'2024-08-22 19:26:09','455242700200327005012999',2,2,2,'O','',0,'2024-08-22 19:26:10',1,'','0230003950907',19,0)