SELECT "lab_test_requests".* FROM "lab_test_requests" join lab_test_request_details as ltrd on lab_test_requests.id = ltrd.lab_test_request_id join lab_test_results as ltre on ltre.lab_test_request_detail_id = ltrd.id join service_requests as sr on sr.id = lab_test_requests.service_request_id join service_request_details as srd on srd.service_request_id= sr.id WHERE (lab_test_requests.patient_id=$1 and srd.service_id in ($2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21)
and ltre.result_value ilike $22 )
Total Time ms
Loading...
Average Time ms
Loading...
Calls
Loading...
Tables
| Name |
Rows |
Indexes |
| lab_test_request_details |
96936 |
|
| lab_test_requests |
44946 |
|
| lab_test_results |
394637 |
-
id
PRIMARY
-
lab_test_request_detail_id
|
| service_request_details |
516676 |
-
id
PRIMARY
-
placer_order_number
UNIQUE
-
service_request_id
|
| service_requests |
360370 |
|