SELECT itd.* FROM "inv_tran_details" as itd inner join inventory_transactions as it on it.id = itd.inventory_transaction_id inner join item_with_details as iwd on itd.item_with_detail_id = iwd.id WHERE (it.reference2 = $1 and iwd.item_id = $2) ORDER BY it.id desc LIMIT $3
Total Time ms
Loading...
Average Time ms
Loading...
Calls
Loading...
Tables
| Name |
Rows |
Indexes |
| inv_tran_details |
114321 |
-
id
PRIMARY
-
drug_prescription_detail_id
|
| inventory_transactions |
57521 |
-
id
PRIMARY
-
extid
UNIQUE
-
reference1, reference3, from_reference3
|
| item_with_details |
4730 |
|