PgHero
SELECT     "bills".* FROM       "bills"  WHERE     (date(bill_date) >= $1 and date(bill_date) <= $2) AND (narration != $3) AND (is_discount_approved = $4) AND (bills.location_id = $5)

Total Time ms

Loading...

Average Time ms

Loading...

Calls

Loading...

Tables

Name Rows Indexes
bills 100853
  • id PRIMARY
  • created_at
  • extid UNIQUE
  • form_token UNIQUE
  • ip_supplementary_bill_id
  • luxury_type_id
  • narration
  • visit_id