SELECT     sr.id as Request_id ,sr.request_date, sg.name as Service_group,s.name ,srd.billing_status,ltrd.id as ltrdid,inv.id as invid,ltrd.status as Lab_Status,inv.status As Imaging_Status,srd.id as ser_req_lab 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) and sr.Patient_id =$2) ORDER BY  sr.id desc

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
investigation_request_details	19269	id PRIMARY
lab_test_request_details	46435	id PRIMARY
service_groups	100	id PRIMARY
service_request_details	258902	id PRIMARY placer_order_number UNIQUE service_request_id
service_requests	185850	id PRIMARY visit_id
services	3348	id PRIMARY