SELECT     sr.id as Request_id ,sr.request_date, sr.requested_by_id, sg.name as Service_group,s.name,srd.id as request_detail_id,srd.billing_status,ltrd.id as ltrdid,inv.id as invid,ltrd.status as Lab_Status,inv.status As Imaging_Status,srd.id as inv_serv_req_det FROM       "service_requests"  as sr join service_request_details as srd on sr.id = srd.service_request_id
                               join services as s on srd.service_id = s.id
                              join service_groups as sg on s.service_group_id =sg.id
                               left join lab_test_request_details as ltrd on srd.id = ltrd.service_request_detail_id
                               left outer join investigation_request_details as inv on srd.id = inv.service_request_detail_id WHERE     (sg.clinical_system_id in ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10) and sr.Patient_id =$11) ORDER BY  sr.id desc

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
investigation_request_details	36025	id PRIMARY
lab_test_request_details	96936	id PRIMARY
service_groups	111	id PRIMARY
service_request_details	516676	id PRIMARY placer_order_number UNIQUE service_request_id
service_requests	360370	id PRIMARY visit_id
services	3976	id PRIMARY