SELECT     "patients".* FROM       "patients"  WHERE     (patients.extid not ilike $1) AND (lower(patients.name) iLIKE $2) AND (lower(patients.last_name) iLIKE $3) AND (patients.id in (select patient_id from visits where location_id = $4)) ORDER BY  patients.id LIMIT $5 OFFSET $6

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
patients	65828	id PRIMARY blood_group_id extid photograph_id
visits	159714	id PRIMARY extid patient_id