23/10/2024 09:50:18.8267 4775 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 23/10/2024 10:37:46.9935 532 ms. EXEC: update paycash set casCreation = '2024-10-23 10:37:46',casModify = '2024-10-23 10:37:46',casUseId=0,casStatus='V' where casId = 190953 23/10/2024 11:07:12.8157 677 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-23 11:07:12',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'; 23/10/2024 12:05:39.3774 566 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-23 12:05:38' where traUID = 5197821752930100 and traStatus='V' and traEnabled=1 23/10/2024 13:45:55.1283 618 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-23 13:45:54' where traUID = 5109515500891080 and traStatus='V' and traEnabled=1 23/10/2024 14:34:10.8669 645 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-23 14:34:10',0,0,'V',5390668224146780,5055850786294120,2024,'2024-10-23 14:34:10',3,'KES',1,50,50,'N','');