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
Loading...
Average Time ms
Loading...
Calls
Loading...
Tables
| Name |
Rows |
Indexes |
| appointment_details |
815494 |
-
id
PRIMARY
-
appointment_id, id DESC
|
| appointments |
204059 |
-
id
PRIMARY
-
app_start_date, app_end_date, app_start_time, app_end_time
-
app_start_date_time
-
app_start_date_time, app_end_date_time
-
patient_criticality_id
-
patient_id
-
pre_id
-
service_request_detail_id
-
visit_id
|