SELECT     id,name,rc_code,dispensing_unit_id,item_subtype_id FROM       "items"  WHERE     ("items"."is_consignment" = ?) AND (item_subtype_id in (select id from item_subtypes where item_type_id in(select id from item_types where item_group_id in(select id from item_groups where store_category_id = ?) ) ) and id in(select iwd.item_id from inventory_statuses as iss inner join item_with_details as iwd on iss.item_with_detail_id=iwd.id where iss.quantity > ? and iss.inventory_head_id=? and iss.flag=? and (iwd.expiry_date >= ? or iwd.expiry_date is null)) and is_asset = ? and is_consignment = ? and status = ?) ORDER BY  LOWER(name)

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
inventory_statuses	323528	id PRIMARY inventory_head_id item_with_detail_id quantity
item_groups	1	id PRIMARY
item_subtypes	26	id PRIMARY item_type_id
item_types	16	id PRIMARY
item_with_details	64808	id PRIMARY expiry_date item_id
items	3113	id PRIMARY item_subtype_id