Write SQL query to solve given problem: What is the total production of the product that is ordered in the highest quantity in order no. 10248?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT T1.UnitsInStock + T1.UnitsOnOrder FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T2.OrderID = 10248 ORDER BY T2.Quantity DESC LIMIT 1