N+1 queries SQL Origin: Data OSI layer 7 · Application Last updated 13 Oct 2026

Performance: N+1 query problem (one query per row in a loop)

Code runs one query to load a list, then one more query per item — hundreds of queries per page.

Exact message you may see too many queries
Seen on: SQL

Meaning

Not an error message, but the most common cause of slow pages and connection pool exhaustion with ORMs. Lazy-loaded relations accessed in a loop trigger a query each time.

Common causes

  • Lazy relations accessed in loops/templates
  • Missing eager loading (include/with/select_related/JOIN FETCH)

⚡ Quick fix

  1. Eager-load relations (Laravel with(), Django select_related/prefetch_related, Rails includes, EF Include)
  2. Log query counts per request in development

Detailed fix by platform

SQL

  1. SELECT o.*, u.email FROM orders o JOIN users u ON u.id = o.user_id WHERE o.status = 'paid';

How to diagnose

  1. Count — Queries per request?
  2. Pattern — Same query repeated with different ids?

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

103 — HTTP 103 Early Hints (HTTP)1031200 — Cloudflare Error 1200: Cache connection limit (Cloudflare)1200304 — HTTP 304 Not Modified (HTTP)304504 — HTTP 504 Gateway Timeout (HTTP)504524 — Cloudflare Error 524: A Timeout Occurred (Cloudflare)524ANR — ANR: Application Not Responding (Input dispatching timed out) (Android)ANRcartesian — Query returns far too many rows: accidental Cartesian product (missing JOIN condition) (SQL)cartesiancf-cache-status: DYNAMIC — Cloudflare not caching: cf-cache-status DYNAMIC / BYPASS / MISS every time (Cloudflare)cf-cache-status: DYNA…N+1 queri…

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.