Optimizing Queries with Eloquent Eager Loading

// Bad Example (N+1 Problem):
foreach (App\Models\Post::all() as $post) {
    echo $post->user->name; // Each user access makes a new query
}

// Good Example (Eager Loading):
foreach (App\Models\Post::with('user')->get() as $post) {
    echo $post->user->name; // All users loaded in a single additional query
}

// Eager loading multiple relationships:
$posts = App\Models\Post::with(['user', 'comments'])->get();

// Eager loading with constraints:
$posts = App\Models\Post::with(['comments' => function ($query) {
    $query->where('is_approved', true);
}])->get();

How it works: Eager loading is a crucial optimization technique in Laravel Eloquent to prevent the N+1 query problem. Instead of performing a separate database query for each related model accessed within a loop, the `with()` method instructs Eloquent to load all specified relationships for the primary models in advance, typically using one or two additional queries. This significantly reduces the total number of database queries, leading to better application performance. You can eager load single or multiple relationships and even add constraints to the eager-loaded relationships.