SELECT     "transaction_details".* FROM       "transaction_details"  WHERE     (narration = $1 and cast(reference_2 as int) = $2 and location_id = $3) LIMIT $4

Total Time ms

Average Time ms

Calls

Tables

Name	Rows	Indexes
transaction_details	5829281	id PRIMARY amount created_at created_by credit_account_id credit_account_type, credit_account_id debit_account_id debit_account_type, debit_account_id debit_reference_1 extid inventory_transaction_id location_id narration reference_2 reference_4 transaction_date, narration