30/05/2024 07:46:29.9665 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/05/2024 11:24:05.3079 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-05-30 11:24:04' where traUID = 5113500834043750 and traStatus='V' and traEnabled=1 30/05/2024 11:29:11.2555 546 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-05-30 11:29:10',3,42101,0,100,1,100,1,'I','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'; 30/05/2024 11:30:25.9192 597 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-05-30 11:30:25' where traUID = 5488003269293150 and traStatus='V' and traEnabled=1 30/05/2024 12:48:00.9764 3234 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 30/05/2024 14:00:03.6037 625 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-05-30 14:00:02' where payTraUID = 4703526335944730 and payStatus='V' and payEnabled=1 30/05/2024 15:59:18.5984 531 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-05-30 15:59:17',3,42101,0,100,1,100,1,'I','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'; 30/05/2024 18:17:40.7958 593 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-05-30 18:17:40' where payTraUID = 5675796438235290 and payStatus='V' and payEnabled=1