Merge pull request #40577 from barredterra/one-item-price

perf: query one item price only
diff --git a/erpnext/stock/get_item_details.py b/erpnext/stock/get_item_details.py
index d7baad9..d09282d 100644
--- a/erpnext/stock/get_item_details.py
+++ b/erpnext/stock/get_item_details.py
@@ -913,6 +913,7 @@
 		.orderby(ip.valid_from, order=frappe.qb.desc)
 		.orderby(IfNull(ip.batch_no, ""), order=frappe.qb.desc)
 		.orderby(ip.uom, order=frappe.qb.desc)
+		.limit(1)
 	)
 
 	if not ignore_party: