21/10/2023 08:16:41.0946 515 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-21 08:16:34',5,3,42101,0,50,4,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+200,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-10-21 08:16:34',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-10-21 08:16:34',5,3,42101,0,100,9,900,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+9,5),curAmount=round(curAmount+900,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; 21/10/2023 09:56:59.0051 557 ms. EXEC: update abbCards set carLastDate = '2023-10-21 09:56:58',carLastDirection='O' where carStatus='V' and carId = 44 21/10/2023 11:16:45.5155 578 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-10-21 11:16:44',0,0,'V',4618563027280260,5531217927174230,2023,'2023-10-21 11:16:44',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-10-21 11:16:44',0,0,'V',4618563027280260,5531217927174230,2023,'2023-10-21 11:16:44',3,'KES',-1,100,-100,'N',''); 21/10/2023 15:30:29.1789 734 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/10/2023 16:42:43.4558 515 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-10-21 16:42:42',0,0,'V',5249587394738910,4844266697151410,2023,'2023-10-21 16:42:42',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-10-21 16:42:42',0,0,'V',5249587394738910,4844266697151410,2023,'2023-10-21 16:42:42',3,'KES',1,50,50,'N',''); 21/10/2023 22:53:29.6289 546 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-10-21 22:53:29' where payTraUID = 4898585703153170 and payStatus='V' and payEnabled=1