SELECT     "patients".* FROM       "patients"  WHERE     (patients.id in (select patient_id from visits where location_id = $1)) AND (RIGHT(patients.extid, $2) = $3) AND (patients.id in (select patient_id from visits where location_id = $4)) LIMIT $5 OFFSET $6

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
patients	128968	id PRIMARY blood_group_id extid photograph_id
visits	378042	id PRIMARY extid patient_id