ORM N+1 query (ARCH7079)

Key php.performance.orm-n-plus-one · Severity error · Category performance

Retired

This rule has been retired and is no longer checked: the collector does not run it and no new finding carries this code. The page is kept for reference and for findings recorded before it was retired.

Looping over a query result and accessing a related model on each element runs a separate query per row (N+1). Eager load the relationship upfront.

Incorrect

<?php
$posts = Post::all();
foreach ($posts as $post) {
    echo $post->author->name;
}

Correct

<?php
$posts = Post::with('author')->get();
foreach ($posts as $post) {
    echo $post->author->name;
}

Fix

Eager load relationships accessed in the loop with with() to collapse them into one extra query.