08/02/2023 10:00:06.4816   539 ms.           EXEC: update payInventory set invCreation = '2023-02-08 10:00:05',invModify = '2023-02-08 10:00:05',invUseId=0,invStatus='V' where invId = 55654 (WAIT TIME 57 ms.)
08/02/2023 11:02:01.5987   523 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-02-08 11:02:00',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';

08/02/2023 12:47:30.8801   508 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-02-08 12:47:30' where payTraUID = 5290899167533660 and payStatus='V' and payEnabled=1
08/02/2023 13:37:30.9780   535 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-02-08 13:37:30',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';

08/02/2023 13:44:00.1962   506 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-02-08 13:43:59',0,'V',5059479478996840,5606847128165510,2023,'2023-02-08 13:43:59',18,1,0,4,'2023-02-08 13:58:59','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
08/02/2023 14:05:48.5163   621 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-02-08 14:05:47',0,'V',5455938193293900,5374709858643130,2023,'2023-02-08 14:05:47',18,1,0,4,'2023-02-08 14:20:47','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
08/02/2023 14:45:52.3981   516 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-02-08 14:45:51',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';

08/02/2023 15:20:34.6150   706 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-02-08 15:20:33' where traUID = 4820861746252360 and traStatus='V' and traEnabled=1
08/02/2023 15:38:28.0400   683 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-02-08 15:38:27',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';

08/02/2023 15:43:01.3650   566 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-02-08 15:43:00' where traUID = 4622793411770540 and traStatus='V' and traEnabled=1
08/02/2023 15:56:47.1665   866 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-02-08 15:56:45',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';

08/02/2023 16:13:25.9501   575 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-02-08 16:13:25',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';

08/02/2023 17:20:06.4530   684 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,'2023-02-08 17:20:05','V',5529707325144250,2023,'2023-02-08 17:20:05','449636240500327005012999',1,2,16,'I','',1,0,1,'','',4)
08/02/2023 17:55:42.0940   728 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