SELECT     ltrd.id as detail_id,ltrd.lab_test_request_id as lab_test_request_id,ltrd.begin_specimen_received_time as spec_procedure_time, s.id as service_id,
     s.name as service_name,s.is_vantana, sp.name as specimen_name,lt.patient_id,ltrd.urgent_check,ltp.status as ltp_status, ltp.extid,ltp.priority_comments, ltrd.status as ltrd_status,s.report_type,
     ltp.indications,ltp.specimen_prefix as specimen_prefix,ltp.specimen_number as specimen_number,ltrd.station_id,ltrd.service_request_detail_id,(p.name||$1||p.last_name) as pat_name,p.extid as pat_extid,lt.visit_id as visit_id, v.patient_type,v.clinician_id as cli_id,
     sr.is_cpoe_request,stn.name as station_name,srd.order_remarks,p.title_id,p.id as pat_id,p.age as pat_age,p.gender_id as pat_gender, ltp.id as specimen_id,ltrd.specimen_received_time,ltrd.status FROM       "lab_test_request_details"  as ltrd
     inner join lab_test_requests as lt on lt.id =ltrd.lab_test_request_id
     inner join cross_location_orders as clo on clo.lab_test_request_detail_id=ltrd.id
     inner join services as s on s.id = ltrd.service_id
     inner join specimens as sp on sp.id = ltrd.specimen_id
     inner join lab_test_specimens as ltp on ltp.lab_test_request_detail_id = ltrd.id
     inner join patients as p on lt.patient_id = p.id
     inner join visits as v on v.id=lt.visit_id
     inner join service_request_details as srd on srd.id = ltrd.service_request_detail_id
     inner join service_requests as sr on srd.service_request_id=sr.id
     inner join stations as stn on stn.id=ltrd.station_id WHERE     (ltrd.specimen_recieved = $2 and (ltrd.status = $3  or ltrd.status = $4 or ltrd.status = $5) and ltrd.sending_approval is null and ltp.status = $6 and (date(ltrd.begin_specimen_received_time) >= $7 and date(ltrd.begin_specimen_received_time) <= $8) and s.id in(select id from services where service_group_id in(select service_group_id from service_groups_stations where (station_id = $9 ))) and ((s.report_type= $10) or (s.report_type = $11) or (s.report_type = $12) or (s.report_type = $13)) and lt.location_id = $14 and clo.to_location_id = $15 and clo.status = $16) ORDER BY  ltp.extid,lt.emergency desc,srd.is_urgent desc

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
cross_location_orders	39103	id PRIMARY lab_test_request_detail_id
lab_test_request_details	111789	id PRIMARY service_request_detail_id
lab_test_requests	51750	id PRIMARY
lab_test_specimens	42739	id PRIMARY
patients	116156	id PRIMARY blood_group_id extid photograph_id
service_groups_stations	18580	id PRIMARY
service_request_details	596796	id PRIMARY created_at placer_order_number UNIQUE service_id service_request_id service_request_id
service_requests	410926	id PRIMARY encounter_id patient_id visit_id
services	3981	id PRIMARY
specimens	13	id PRIMARY
stations	334	id PRIMARY
visits	332919	id PRIMARY extid patient_id