SELECT     "items".* FROM       "items"  WHERE     ((name) ilike $1 and is_medicine=$2 and status=$3) ORDER BY  name LIMIT $4

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
items	28566	id PRIMARY dispensing_unit_id expiry_date_present generic_name is_asset is_consignment item_subtype_id name name gist_trgm_ops GIST rc_code status