N+1 Query (ARCH7050)

Key php.orm.n-plus-one-query · Severity warning · Category orm

Accessing related data inside a loop fires a separate query each iteration, causing the N+1 problem. One database round-trip per row adds up to severe latency.

Incorrect

<?php
$posts = Post::all();
foreach ($posts as $post) {
    // every iteration runs a new query
    echo $post->author->name;
}

Correct

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

Fix

Eager load the relation before the loop with with() in a single query.