SELECT     a.*,e.id as encounter_id FROM       "appointments"  as a inner join visits as v on a.visit_id=v.id inner join encounters as e on v.id = e.visit_id
                                                                                inner join service_request_details as srd on srd.id=a.service_request_detail_id                                                                                                         inner join service_requests as sq on sq.id=srd.service_request_id WHERE     (a.check1 is null and e.status = $1 and e.name !=$2 and v.patient_type =$3 and date(a.app_start_date_time) >= $4 and  date(a.app_start_date_time) <= $5 and a.app_status = $6  and srd.billing_status != $7 and srd.billing_status = $8 and sq.clinician_id in ($9) and sq.location_id = $10 and a.is_telemedicine is null) ORDER BY  a.patient_criticality_id desc

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
appointments	60129	id PRIMARY app_start_date, app_end_date, app_start_time, app_end_time app_start_date_time, app_end_date_time patient_criticality_id patient_id pre_id service_request_detail_id visit_id
encounters	59721	id PRIMARY patient_id visit_id
service_request_details	173245	id PRIMARY placer_order_number UNIQUE service_request_id
service_requests	123402	id PRIMARY visit_id
visits	107838	id PRIMARY patient_id