01/05/2024 12:07:52.4104 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/05/2024 12:07:52.4104 687 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/05/2024 14:37:40.3320 593 ms. EXEC: update paycash set casCreation = '2024-05-01 14:37:39',casModify = '2024-05-01 14:37:39',casUseId=0,casStatus='V' where casId = 162682 01/05/2024 14:39:54.9841 671 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-05-01 14:39:54',3,42101,0,50,1,50,1,'I','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'; 01/05/2024 17:20:44.0065 531 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/05/2024 19:24:54.2122 578 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5757948204881800,4681251560675470,2024,'2024-05-01 19:24:53','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 5/1/2024 6:41:14 PM Date : 5/1/2024 7:24:52 PM Code : 454116727400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0)