SELECT     COUNT(*) AS count_id FROM       "appointments"  INNER JOIN "appointment_details" ON "appointments".id = "appointment_details".appointment_id WHERE     (("appointment_details".schedulable_entity_id = $1)) AND (((app_start_date_time >= $2 and app_start_date_time < $3) or (app_end_date_time >= $4 and app_end_date_time < $5))) AND (status = $6)

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
appointment_details	712098	id PRIMARY
appointments	178210	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