08/06/2023 08:26:39.7391   510 ms.           EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-08 08:26:35',5,3,42101,0,50,-79,-3950,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-08 08:26:35',5,3,42101,0,100,-157,-15700,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-08 08:26:35',5,3,42101,0,200,-20,-4000,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-08 08:26:35',5,3,42101,0,500,-5,-2500,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-08 08:26:35',5,3,42101,0,1000,-4,-4000,2,'O','N');
insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-06-08 08:26:35',5,3,42101,1,0,0,0,2,'O','');
update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0;

08/06/2023 09:21:52.3309   563 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-06-08 09:21:51','V',4665806585547710,2023,'2023-06-08 09:21:51','450832816800327005012999',2,2,2,'O','',0,'2023-06-08 09:21:51',1,'','',0)
08/06/2023 12:21:18.5636   559 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
08/06/2023 13:53:08.8473   537 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
08/06/2023 16:29:43.5499   766 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-06-08 16:29:42',3,42101,0,100,-1,-100,1,'O','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';
Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-06-08 16:29: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';

08/06/2023 16:35:39.2627   969 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-06-08 16:35:38',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 ('2023-06-08 16:35:38',3,42101,0,100,-1,-100,1,'O','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/06/2023 16:48:24.5264   574 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-06-08 16:48:23' where traUID = 5160831074025170 and traStatus='V' and traEnabled=1
08/06/2023 19:43:52.3317   666 ms.           EXEC: update abbCards set carLastDate = '2023-06-08 19:43:51',carLastDirection='O' where carStatus='V' and carId = 15
08/06/2023 22:11:46.5018   985 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-06-08 22:11:45',0,0,'V',5037232945224470,4738834608247160,2023,'2023-06-08 22:11:45',3,'KES',1,100,100,'N','');
insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-06-08 22:11:45',0,0,'V',5037232945224470,4738834608247160,2023,'2023-06-08 22:11:45',3,'KES',1,100,100,'N','');