Laravel

What is the N+1 query problem and how do you solve it in Eloquent?

December 3, 2025

download ready
Thank You
Your submission has been received.
We will be in touch and contact you soon!

The N+1 query problem occurs when fetching a collection of parent models (1 query) triggers lazy-loading of relationships for each item (N additional queries), causing severe performance degradation in loops. Eloquent solves this through eager loading with with(), reducing queries from N+1 to typically 2 regardless of collection size.

Step 1:- Identify the Problem (Lazy Loading)

Code

// N+1 PROBLEM: 1 + N queries (disaster at scale)
$users = User::all(); // 1 query
foreach ($users as $user) {
    echo $user->posts->count(); // N queries! One per user
}

Step 2:-Apply Eager Loading with with()

Code

// SOLUTION: 2 queries total (scales perfectly)
$users = User::with('posts')->get(); // 1 query users + 1 query all posts
foreach ($users as $user) {
    echo $user->posts->count(); // 0 queries - pre-loaded!
}

Step 3:-Eager Load Multiple/Nested Relationships

Code

// Multiple relationships
$users = User::with(['posts', 'profile', 'roles'])->get(); // 4 queries total

// Nested (posts + each post's comments)
$users = User::with('posts.comments')->get(); // Users + Posts + Comments (3 queries)

// Constrained eager loading
$users = User::with(['posts' => function ($query) {
    $query->where('published', true)->latest();
}])->get();

Step 4:-Lazy Eager Loading (Existing Collections)

Code

// Already have $users collection? Load later:
$users = User::all(); // 1 query
$users->load('posts'); // 1 more query - now eager loaded!
foreach ($users as $user) {
    echo $user->posts->count(); // 0 queries
}

Stpe 5:-Optimize with withCount() (No Full Relation Needed)

Code

// Just need COUNT? Avoid loading full relation:
$users = User::withCount('posts')->get();
foreach ($users as $user) {
    echo $user->posts_count; // 0 queries - just integer!
}
Arrow icon

Previous

Next

Arrow icon
Hire Now!

Need Help with Laravel Development ?

Work with our skilled laravel developers to accelerate your project and boost its performance.
**Hire now**Hire Now**Hire Now**Hire now**Hire now

Related Q&A

blog-banner-img
calender
March 19, 2026

How to implement real-time database CDC with Debezium Kafka for Laravel microservices?

Laravel
All
blog-banner-img
calender
March 20, 2026

What is Laravel Octane and how does it improve performance?

Laravel
All
blog-banner-img
calender
March 20, 2026

What is Laravel Job Batching and what problem does it solve?

Laravel
All
Ready to Build
Something Amazing?
Got an Idea?
We got you.
Need a Tech Partner
You Can Trust?
Got Challenges?
We’ve Got Solutions.
Your Vision,
Our Mission.
Let’s talk.
Project Inquiry
Email iconhello@zignuts.com
Call icon+49 3056837888
Call icon+1 4088728242
Career Inquiry
Email icontalent@zignuts.com
Call icon+91 9427726620
India
A-409, Siddhraj Zori, Gandhinagar, 382421, Gujarat, India
Germany
Rheinsberger Str. 76,10115 Berlin, Germany
USA
611 Gateway Blvd, South San francisco, CA 94080, USA
Company Deck

Company Deck

PDF, 3MB

© 2026 Zignuts Technolab. All Rights Reserved.

Facebook iconTwitter iconInstagram iconYoutube iconLinkedIn iconSocial icon

What is the N+1 query problem and how do you solve it in Eloquent?

The N+1 query problem occurs when fetching a collection of parent models (1 query) triggers lazy-loading of relationships for each item (N additional queries), causing severe performance degradation in loops. Eloquent solves this through eager loading with with(), reducing queries from N+1 to typically 2 regardless of collection size.

Step 1:- Identify the Problem (Lazy Loading)

Code

// N+1 PROBLEM: 1 + N queries (disaster at scale)
$users = User::all(); // 1 query
foreach ($users as $user) {
    echo $user->posts->count(); // N queries! One per user
}

Step 2:-Apply Eager Loading with with()

Code

// SOLUTION: 2 queries total (scales perfectly)
$users = User::with('posts')->get(); // 1 query users + 1 query all posts
foreach ($users as $user) {
    echo $user->posts->count(); // 0 queries - pre-loaded!
}

Step 3:-Eager Load Multiple/Nested Relationships

Code

// Multiple relationships
$users = User::with(['posts', 'profile', 'roles'])->get(); // 4 queries total

// Nested (posts + each post's comments)
$users = User::with('posts.comments')->get(); // Users + Posts + Comments (3 queries)

// Constrained eager loading
$users = User::with(['posts' => function ($query) {
    $query->where('published', true)->latest();
}])->get();

Step 4:-Lazy Eager Loading (Existing Collections)

Code

// Already have $users collection? Load later:
$users = User::all(); // 1 query
$users->load('posts'); // 1 more query - now eager loaded!
foreach ($users as $user) {
    echo $user->posts->count(); // 0 queries
}

Stpe 5:-Optimize with withCount() (No Full Relation Needed)

Code

// Just need COUNT? Avoid loading full relation:
$users = User::withCount('posts')->get();
foreach ($users as $user) {
    echo $user->posts_count; // 0 queries - just integer!
}