SELECT     distinct(bd.*) FROM       "bill_details"  as bd inner join bills as b on b.id=bd.bill_id inner join itemwise_corporate_coverages as iwcc on iwcc.corporate_id = b.corporate_id WHERE     (iwcc.corporate_id=$1 and bd.bill_id=$2 and bd.patient_share > $3)

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
bill_details	159491	id PRIMARY bill_id item_with_detail_id location_id narration patient_id reference_3 service_id service_request_detail_id station_id
bills	100853	id PRIMARY created_at extid UNIQUE form_token UNIQUE ip_supplementary_bill_id luxury_type_id narration visit_id
itemwise_corporate_coverages	71455	id PRIMARY item_id