SELECT     itd.* FROM       "inv_tran_details"  as itd inner join inventory_transactions as it on it.id = itd.inventory_transaction_id inner join item_with_details as iwd on itd.item_with_detail_id = iwd.id WHERE     (it.reference2 = ? and iwd.item_id = ?) ORDER BY  it.id desc LIMIT ?

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
inv_tran_details	16769944	id PRIMARY inventory_transaction_id item_with_detail_id
inventory_transactions	2782064	id PRIMARY extid from_inventory_head_id reference1 reference2, from_inventory_head_id reference2, to_inventory_head_id transaction_date
item_with_details	64808	id PRIMARY expiry_date item_id