05/10/2023 07:59:17.6915  1044 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-05 07:59:03',5,3,42101,0,50,-62,-3100,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-05 07:59:03',5,3,42101,0,100,-129,-12900,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-05 07:59:03',5,3,42101,0,200,-19,-3800,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-05 07:59:03',5,3,42101,0,500,-11,-5500,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-05 07:59:03',5,3,42101,0,1000,-3,-3000,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-05 07:59:03',5,3,42101,1,0,0,0,2,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

05/10/2023 12:37:33.7369  1265 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-10-05 12:37:31',0,'V',5453275280251830,4869522278981690,2023,'2023-10-05 12:37:31',3,1,0,4,'2023-10-05 12:52:31','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)
05/10/2023 12:37:35.2213  1234 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-10-05 12:37:33',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';

05/10/2023 13:38:54.6031   515 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-10-05 13:38:54' where traUID = 4648209084421250 and traStatus='V' and traEnabled=1
05/10/2023 13:48:40.1936   562 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-10-05 13:48:39' where payTraUID = 4746644430663060 and payStatus='V' and payEnabled=1
05/10/2023 14:37:46.2311   515 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
05/10/2023 16:23:20.4693   546 ms.           EXEC: update payInventory set invCreation = '2023-10-05 16:23:19',invModify = '2023-10-05 16:23:19',invUseId=0,invStatus='V' where invId = 130062
05/10/2023 16:39:48.4612   609 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-10-05 16:39:47',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';

05/10/2023 18:26:43.5113   609 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,'2023-10-05 18:26:42','V',5560742028776470,2023,'2023-10-05 18:26:41','452023242800327005012999',2,2,2,'O','',0,'2023-10-05 18:26:42',1,'','0230003957463',25,0)
05/10/2023 19:08:35.0435  1781 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
05/10/2023 19:24:30.8724   610 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-10-05 19:24:30' where traUID = 5163574274149680 and traStatus='V' and traEnabled=1
05/10/2023 20:04:17.8816   734 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
05/10/2023 20:32:15.1710   609 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-10-05 20:32:14','V',5423748938981460,2023,'2023-10-05 20:32:13','452027266500327005012999',2,2,2,'O','',0,'2023-10-05 20:32:14',1,'','',0)