07/02/2023 07:50:59.3044   521 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-07 07:50:51',4,3,42101,0,50,-24,-1200,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-07 07:50:51',4,3,42101,0,50,24,1200,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-07 07:50:51',4,3,42101,0,100,-47,-4700,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-07 07:50:51',4,3,42101,0,100,47,4700,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-07 07:50:51',4,3,42101,0,200,-17,-3400,1,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-07 07:50:51',4,3,42101,0,200,17,3400,2,'I','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-02-07 07:50:51',4,3,42101,1,0,0,0,1,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

07/02/2023 11:13:42.8255   517 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-02-07 11:13:42' where traUID = 5420068840199970 and traStatus='V' and traEnabled=1
07/02/2023 13:44:28.3541   548 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-07 13:44:23',6,'V',5225230331872560,5143914279166230,2023,'2023-02-07 13:44:23',4,1,0,4,'2023-02-07 13:59:23','P','KES',100,100,0,'','','',1,100,0,0,'',0,0)
07/02/2023 14:41:28.3247   545 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-07 14:41:27','V',5646222970083000,2023,'2023-02-07 14:41:27','449624921300327005012999',2,2,2,'O','',0,'2023-02-07 14:41:27',1,'','',0)
07/02/2023 15:21:05.8185   550 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
07/02/2023 17:01:50.4984   621 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-02-07 17:01:49',3,42101,0,200,1,200,1,'I','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';

07/02/2023 17:41:57.4569   757 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