SELECT     COUNT(lts.id) AS count_id FROM       "lab_test_requests"  as ltr inner join lab_test_request_details as ltrd on ltr.id = ltrd.lab_test_request_id inner join lab_test_results as lts on lts.lab_test_request_detail_id = ltrd.id WHERE     (ltr.patient_id =$1  and lts.service_unit_id=$2 and ltrd.created_at <$3 and ltrd.id !=$4 and ltrd.status=$5)

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
lab_test_request_details	96936	id PRIMARY
lab_test_requests	44946	id PRIMARY
lab_test_results	394637	id PRIMARY lab_test_request_detail_id