N+1 query detection for pull requests
Find the N+1 query in the pull request, not in production.
IonWarp flags N+1 and unbounded queries and blocking calls on request paths, on the line that adds them.
14 days free, no cardPro is $49/mo for 5 seatsRead-only code access
IonWarp Review — PR #640
| # Sev | Issue | File |
|---|---|---|
| 1 | N+1 query in GET /orders | app/api/orders/route.ts |
| 2 | Unbounded SELECT on events | lib/events/list.ts |
| 3 | Three awaits run one after another | lib/dashboard/load.ts |
33for (const o of orders) {34+o.items = await db.query.items.findMany({ where: eq(items.orderId, o.id) });35}
A page of 50 orders runs 51 queries. Load the items in one query with inArray(items.orderId, ids) and group them in memory.
How it works
Install the GitHub App
Pick the repositories. IonWarp reads the code and comments on pull requests. It never pushes a commit.
Open a pull request
API Performance reads the diff. Flags N+1 and unbounded queries and blocking calls on request paths.
Fix it with your agent
Every finding has a fix prompt for Claude Code, Cursor or Codex. Push the fix and IonWarp checks it again.
Specialist reviewers
Add SOC 2 Review
to your pull requests.
IonWarp is a next-gen AI code reviewer for GitHub pull requests, built on open models.
IonWarp SOC 2 Review on DeepSeek V4.1 Flash: about 4¢ a reviewthe benchmark →
IonWarp Review — PR #219
| # Sev | Issue | File |
|---|---|---|
| 1 | Role change writes no audit log | app/api/admin/roles.ts |
| 2 | Required CI check disabled | .github/workflows/ci.yml |
| 3 | Token printed in a debug log | lib/auth/session.ts |
44test:45+if: false46runs-on: ubuntu-latest
if: false skips the job, but branch protection still shows it as passing. That breaks change-management control CC8.1.




What API Performance catches
N+1 and unbounded reads
Loops that query, list reads with no limit, filters no index can serve.
Work that waits in line
Serial awaits, blocking calls and sync I/O on a request path.
Responses that keep growing
Endpoints returning whole tables or nested objects nobody reads.
How each reviewer scores.
On 18 real pull requests with 13 known issues, API Performance runs on DeepSeek V4.1 Flash: F1 53.3%, 6m 27s a review at the median, $0.043 in model cost. IonWarp · Muse Spark 1.3 leads on F1 at 56.0%, at $0.063 a review. This lane is provisional until its case set grows and its labels are reviewed.
| Model / App | Reviewer Score | F1 | Latency | $/run |
|---|---|---|---|---|
| IonWarp · Muse Spark 1.3 | 77.8 | 56.0% | 42s | $0.063 |
| IonWarp · GLM 5.3 Flash | 63.4 | 48.3% | 49s | $0.0049 |
| Greptile v4.112 of 18 PRs | — | 76.9% | 4m 59s | ~$1.75 |
| IonWarp · GPT 5.6 Luna Pro | 61.3 | 50.0% | 28s | $0.030 |
| Qodo v212 of 18 PRs | — | 66.7% | 5m 43s | ~$1.67 |
| Cursor Bugbot12 of 18 PRs | — | 71.4% | 7m 57s | ~$1.25 |
| IonWarp · DeepSeek V4 Pro | 59.7 | 52.2% | 1m 21s | $0.042 |
| IonWarp · DeepSeek V4.1 FlashRuns on your PRs | 52.6 | 53.3% | 6m 27s | $0.043 |
| IonWarp · Gemini 3.8 Flash | 15.9 | 41.7% | 47s | $0.071 |
| CodeRabbit12 of 18 PRs | — | 44.4% | 6m 00s | ~$1.50 |
Reviewer Score = (3 × F1 + time + $/run) ÷ 5, each part 0 to 100 within this table. IonWarp rows cost the model’s inference; ~$ is each app’s list price for 5 seats at 100 reviews a month. Rows measured on part of the PRs get no Score. Provisional scoped-label matching. Release 2026-10-12, CC BY 4.0.
API Performance
IonWarp inferenceApp price estimatesF1 on the same 18 open-source pull requests for every reviewer
Pricing
Simple pricing for your whole team.
One workspace price with seats included. Every agent on every plan, and a monthly budget IonWarp stays inside. 14 days free, no card.
ProMost popular
One team, every agent from day one.
- 5 seats included
- All eight agents, every repo you connect
- $25 of review spend a month
- A monthly budget you set
Max
Bigger teams and a bigger review budget.
- 10 seats included
- All eight agents, every repo you connect
- $100 of review spend a month
- A monthly budget you set
- Priority models and support
More than 10 people?
Tell us how many seats and how much review spend you need, and we will set up the workspace.
FAQ
Frequently asked questions
What is the N+1 query problem?
Code loads a list with one query, then runs one more query for each item in it: 1 + N round trips where 1 or 2 would do. It hides in loops and in ORM relations that load lazily, and it gets slower as the list grows.
How do you fix an N+1 query?
Load the related rows in one query (a join, or WHERE id IN (…)) and group them in memory, or use your ORM’s eager loading. IonWarp suggests the version that fits the code in the PR.
Is this an APM?
No. It reviews the code before it ships. Keep your APM for production; IonWarp stops the regression from reaching it.
Does it need access to my database?
No. It reads the code in the pull request and the files that code calls.
How accurate is API Performance?
On 18 real pull requests with 13 known issues, API Performance runs on DeepSeek V4.1 Flash: F1 53.3%, 6m 27s a review at the median, $0.043 in model cost. IonWarp · Muse Spark 1.3 leads on F1 at 56.0%, at $0.063 a review. This lane is provisional: its case set is small and still under review, so read it as a direction, not a ranking. Every row, PR and judge verdict is public.
What does it cost?
Pro is $49 a month per workspace with 5 seats and $25 of review spend included. Max is $149 with 10 seats and $100. Every agent is in both. Start with a 14-day trial, no card.
More on api performance
More on api performance

Fast endpoints, PR after PR.
Try for free14 days free, no card. Then Pro is $49 a month per workspace with 5 seats, or Max $149 with 10.
