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

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
patients	46604	id PRIMARY blood_group_id photograph_id
visits	107838	id PRIMARY patient_id