php 39 lines · 9 steps

Eager loading without N+1 in Laravel

A Laravel controller fetches posts with curated relations, counts, and conditional filters in a single efficient query batch.

Explained by highlit
Laravel Intermediate eager-loading n+1 query-builder pagination relations
1class PostController extends Controller
2{
3 public function index(Request $request)
4 {
5 $posts = Post::query()
6 ->with([
7 'author:id,name,avatar_url',
8 'category:id,name,slug',
9 'tags:id,name',
10 'comments' => fn ($query) => $query
11 ->approved()
12 ->latest()
13 ->limit(5),
14 'comments.author:id,name',
15 ])
16 ->withCount(['comments', 'likes'])
17 ->when($request->filled('category'), function ($query) use ($request) {
18 $query->whereHas('category', fn ($q) => $q->where('slug', $request->category));
19 })
20 ->published()
21 ->latest('published_at')
22 ->paginate(15)
23 ->withQueryString();
24 
25 return PostResource::collection($posts);
26 }
27 
28 public function show(Post $post)
29 {
30 $post->load([
31 'author.profile',
32 'category.parent',
33 'comments' => fn ($query) => $query->approved()->with('author:id,name')->latest(),
34 'media',
35 ])->loadCount('likes');
36 
37 return new PostResource($post);
38 }
39}
01 / 01
STEP 01

Walkthrough

Space play ←→ step click any line
Three takeaways
  1. 1Eager loading related models with `with` collapses what would be many lazy queries into a handful of batched ones.
  2. 2Selecting specific columns and constraining nested relations keeps payloads lean and queries fast.
  3. 3`when` lets you bolt conditional filters onto a query chain without breaking it into branching if statements.

Related explainers

php 
<?php
 
namespace App\Console\Commands;
 

Releasing stale document locks in Laravel

artisan-command transactions row-locking
Intermediate 6 steps
php 
<?php
 
namespace App\Providers;
 

Subdomain multi-tenancy routing in Laravel

multi-tenancy service-container route-binding
Advanced 7 steps
ruby 
module Paginatable
  extend ActiveSupport::Concern
 
  private

A reusable pagination concern in Rails

pagination concerns http-headers
Intermediate 8 steps
php 
<?php
 
namespace App\Broadcasting;
 

Authorizing presence channels in Laravel

broadcasting authorization presence-channels
Intermediate 3 steps
php 
<?php
 
namespace App\Http\Middleware;
 

Resolving the current team in Laravel middleware

middleware multi-tenancy cookies
Intermediate 8 steps
php 
<?php
 
namespace App\Http\Controllers;
 

Broadcasting typing indicators in Laravel

websockets authorization presence-channels
Intermediate 9 steps

Share this explainer

Here's the card — post it anywhere.

Eager loading without N+1 in Laravel — share card
Made with highlit — turn any snippet into a walkthrough like this in about a minute.
Explain your code