05/07/2023 08:00:17.9648   690 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-05 08:00:09',5,3,42101,0,50,20,1000,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+20,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-05 08:00:09',5,3,42101,0,200,2,400,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-05 08:00:09',5,3,42101,0,100,11,1100,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+11,5),curAmount=round(curAmount+1100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

05/07/2023 10:03:42.6600   516 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-07-05 10:03:42' where traUID = 4809592944947210 and traStatus='V' and traEnabled=1
05/07/2023 10:29:15.7265   513 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-07-05 22:29:05',12,'V',5601640065858640,5283665248876580,2023,'2023-07-05 22:29:05',4,1,0,4,'2023-07-05 22:44:05','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
05/07/2023 11:40:46.3010   553 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
05/07/2023 13:14:17.7985   550 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-05 13:14:17',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';

05/07/2023 14:26:39.3625   614 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-07-05 14:26:38','V',5153222427103320,2023,'2023-07-05 14:26:38','451105199800327005012999',1,2,16,'I','',1,0,1,'','',4)
05/07/2023 15:46:21.0068   505 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
05/07/2023 16:40:03.0890  1569 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/07/2023 17:25:43.1051   506 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
05/07/2023 17:42:02.8756   642 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-05 17:42:02',0,0,'V',4838104619396580,4669192973229740,2023,'2023-07-05 17:42:02',3,'KES',-1,50,-50,'N','');
insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-05 17:42:02',0,0,'V',4838104619396580,4669192973229740,2023,'2023-07-05 17:42:02',3,'KES',-2,200,-400,'N','');