Eloquent N+1 Elimination & Eager Loading at Scale | Mohamed Said [ ![Mohamed Said](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MH.png) Mohamed Said Laravel Backend Engineer ](https://www.msaied.com) [ Home ](https://www.msaied.com) [ Projects ](https://www.msaied.com/projects) [ Articles ](https://www.msaied.com/articles) [ Certificates ](https://www.msaied.com/certificates) [ Contact ](https://www.msaied.com#contact-section) [ ](https://github.com/EG-Mohamed) [ Home ](https://www.msaied.com) [ Projects ](https://www.msaied.com/projects) [ Articles ](https://www.msaied.com/articles) [ Certificates ](https://www.msaied.com/certificates) [ Contact ](https://www.msaied.com#contact-section) [ home ](https://www.msaied.com) [ articles ](https://www.msaied.com/articles) Eloquent N+1 Elimination: Eager Loading Strategies and Query Deduplication at Scale On this page 1. [ The N+1 Problem Is Not Just a Beginner Mistake ](#the-n1-problem-is-not-just-a-beginner-mistake) 2. [ How Eloquent's Relationship Cache Works ](#how-eloquents-relationship-cache-works) 3. [ Eager Loading: with() vs load() vs loadMissing() ](#eager-loading-codewithcode-vs-codeloadcode-vs-codeloadmissingcode) 4. [ Nested Eager Loading and Constraint Closures ](#nested-eager-loading-and-constraint-closures) 5. [ The withCount and withExists Shortcuts ](#the-codewithcountcode-and-codewithexistscode-shortcuts) 6. [ Detecting N+1 in CI with Telescope and preventLazyLoading() ](#detecting-n1-in-ci-with-telescope-and-codepreventlazyloadingcode) 7. [ Load-Once Guards in Service Classes ](#load-once-guards-in-service-classes) 8. [ Chunked Processing and Eager Loading ](#chunked-processing-and-eager-loading) 9. [ Takeaways ](#takeaways) ![Eloquent N+1 Elimination: Eager Loading Strategies and Query Deduplication at Scale](https://cdn.msaied.com/636/87a71d1826f8c6cce958da8377a0bdb9.png) #laravel #eloquent #performance #database #optimization Eloquent N+1 Elimination: Eager Loading Strategies and Query Deduplication at Scale ===================================================================================== 6 Sep 2026 4 min read ![Mohamed Said](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MJ.jpg) Mohamed Said Table of contents 9 sections 1. [ 01 The N+1 Problem Is Not Just a Beginner Mistake ](#the-n1-problem-is-not-just-a-beginner-mistake) 2. [ 02 How Eloquent's Relationship Cache Works ](#how-eloquents-relationship-cache-works) 3. [ 03 Eager Loading: with() vs load() vs loadMissing() ](#eager-loading-codewithcode-vs-codeloadcode-vs-codeloadmissingcode) 4. [ 04 Nested Eager Loading and Constraint Closures ](#nested-eager-loading-and-constraint-closures) 5. [ 05 The withCount and withExists Shortcuts ](#the-codewithcountcode-and-codewithexistscode-shortcuts) 6. [ 06 Detecting N+1 in CI with Telescope and preventLazyLoading() ](#detecting-n1-in-ci-with-telescope-and-codepreventlazyloadingcode) 7. [ 07 Load-Once Guards in Service Classes ](#load-once-guards-in-service-classes) 8. [ 08 Chunked Processing and Eager Loading ](#chunked-processing-and-eager-loading) 9. [ 09 Takeaways ](#takeaways) The N+1 Problem Is Not Just a Beginner Mistake ---------------------------------------------- Every Laravel developer learns about N+1 queries early. Yet in production codebases with layered services, Blade components, and Livewire, they creep back in — often invisibly. The fix is not just slapping `with()` everywhere. It requires understanding *when* Eloquent fires queries, how the relationship cache works, and where deduplication breaks down. How Eloquent's Relationship Cache Works --------------------------------------- When you call `$post->comments`, Eloquent checks `$this->relations` on the model. If the key exists (even as an empty collection), it returns the cached result. If not, it fires a query. This means: ```php $post->comments; // fires query, caches result $post->comments; // returns cached collection — no query $post->load('comments'); // re-queries and overwrites cache $post->setRelation('comments', collect()); // manually set, prevents any query ``` Understanding this cache is the foundation of every optimization below. Eager Loading: `with()` vs `load()` vs `loadMissing()` ------------------------------------------------------ `with()` is for query-time loading. `load()` re-queries unconditionally. `loadMissing()` is the underused hero — it only fires a query if the relation is not already cached. ```php // Bad: always re-queries even if already loaded $posts->each(fn($p) => $p->load('author')); // Good: skips already-loaded relations $posts->loadMissing('author'); ``` In service classes that receive models from different call sites, `loadMissing()` is the safe default. Nested Eager Loading and Constraint Closures -------------------------------------------- Dot notation handles nesting, but constraints require closures: ```php Post::with([ 'comments' => fn($q) => $q->where('approved', true)->latest()->limit(5), 'comments.author:id,name,avatar', ])->get(); ``` Note the column selection on `comments.author` — always select the foreign key (`id`) plus only what you need. Omitting the FK breaks the relation hydration silently. The `withCount` and `withExists` Shortcuts ------------------------------------------ Avoid loading full collections just to count them: ```php // Bad: loads all comments into memory to count $post->comments->count(); // Good: single subquery, adds comments_count attribute Post::withCount('comments')->get(); // Even cheaper when you only need a boolean Post::withExists('comments')->get(); // adds comments_exists ``` `withExists` compiles to a correlated `EXISTS` subquery, which the query planner can short-circuit on the first matching row. Detecting N+1 in CI with Telescope and `preventLazyLoading()` ------------------------------------------------------------- Laravel ships a first-class guard: ```php // AppServiceProvider::boot() Model::preventLazyLoading(! app()->isProduction()); ``` This throws a `LazyLoadingViolationException` the moment any unloaded relation is accessed outside production. Pair it with a Pest architecture test: ```php it('does not lazy load in feature tests', function () { Model::preventLazyLoading(); // run your feature test suite — any violation throws }); ``` For production observability, Telescope's query panel groups duplicate queries. If you see the same query repeated with different bindings, that is your N+1. Load-Once Guards in Service Classes ----------------------------------- When a service method is called from multiple entry points, guard against redundant loads: ```php class PostEnricher { public function enrich(Post $post): Post { $post->loadMissing(['author', 'tags', 'category']); // safe to access now — no extra queries if already loaded return $post; } } ``` This pattern is especially valuable in Filament resource pages where the same model flows through multiple actions and infolist entries. Chunked Processing and Eager Loading ------------------------------------ When iterating large datasets, `chunk()` with `with()` is correct; `cursor()` is not — cursor returns a lazy generator of individual models with no batch context, so every relation access fires a query. ```php // Good: each chunk of 500 eager-loads relations in 2 queries Post::with('author')->chunk(500, function ($posts) { $posts->each(fn($p) => ProcessPost::dispatch($p)); }); // Dangerous for relations: each model is hydrated alone Post::cursor()->each(fn($p) => $p->author->name); // N+1 ``` Use `cursor()` only when you need memory efficiency on flat, relation-free queries. Takeaways --------- - Use `loadMissing()` in services — it is the safe, idempotent alternative to `load()`. - Always select the FK column when constraining nested eager loads. - Prefer `withCount` / `withExists` over loading collections for aggregates. - Enable `Model::preventLazyLoading()` in non-production environments and enforce it in CI. - `chunk()` + `with()` is the correct pattern for large dataset iteration; `cursor()` is not relation-safe. - Profile with Telescope query grouping before optimizing — measure first. Found this useful? [ ](https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.msaied.com%2Farticles%2Feloquent-n1-elimination-eager-loading-strategies-and-query-deduplication-at-scale&text=Eloquent+N%2B1+Elimination%3A+Eager+Loading+Strategies+and+Query+Deduplication+at+Scale) [ ](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fwww.msaied.com%2Farticles%2Feloquent-n1-elimination-eager-loading-strategies-and-query-deduplication-at-scale) Frequently Asked Questions ---------------------------- 3 questions Q01 Does `loadMissing()` work on Eloquent collections as well as individual models? Yes. Calling `$collection->loadMissing('relation')` inspects each model in the collection, groups those missing the relation, and fires a single batched query for them — the same efficiency as `with()` at query time. Q02 Will `Model::preventLazyLoading()` break existing tests that don't eager-load? It will throw exceptions for any lazy-loaded relation access, which is the point. Treat each violation as a bug to fix by adding the appropriate `with()` or `loadMissing()` call. Start with it enabled only in feature tests, then expand coverage. Q03 When should I use `withAggregate()` instead of `withCount()`? `withCount()` is a convenience wrapper around `withAggregate()`. Use `withAggregate()` directly when you need `sum`, `avg`, `min`, or `max` on a related column — for example, `Post::withAggregate('comments', 'rating', 'avg')` adds a `comments_avg_rating` attribute. Continue reading More Articles --------------- [ View all ](https://www.msaied.com/articles) [ ![Laravel Job Middleware: Rate Limiting, Throttling, and Skipping Jobs Without Hacks](https://cdn.msaied.com/635/e10d72c500d7a25f077552f3098478e8.png) laravel queues job-middleware ### Laravel Job Middleware: Rate Limiting, Throttling, and Skipping Jobs Without Hacks Job middleware in Laravel lets you wrap queue job execution with reusable logic. Learn how to build rate-limit... ![Mohamed Said](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MJ.jpg) Mohamed Said 6 Sep 2026 4 min read Read ](https://www.msaied.com/articles/laravel-job-middleware-rate-limiting-throttling-and-skipping-jobs-without-hacks) [ ![Filament v3 Infolist Entries: Building Rich Read-Only Detail Pages Without Blade Sprawl](https://cdn.msaied.com/634/13a8abbaba187864d69a5790a448ed46.png) filament laravel infolist ### Filament v3 Infolist Entries: Building Rich Read-Only Detail Pages Without Blade Sprawl Filament's Infolist API lets you compose structured, read-only detail views entirely in PHP. Learn how to buil... ![Mohamed Said](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MJ.jpg) Mohamed Said 5 Sep 2026 3 min read Read ](https://www.msaied.com/articles/filament-v3-infolist-entries-building-rich-read-only-detail-pages-without-blade-sprawl) [ ![Filament v3 Custom Field Plugins: Building a Reusable Signature Pad Component](https://cdn.msaied.com/633/6d6839e7007d1cb38f0421594a4557bf.png) filament laravel livewire ### Filament v3 Custom Field Plugins: Building a Reusable Signature Pad Component Learn how to build a production-ready Filament v3 custom field plugin — a signature pad — covering Alpine.js s... ![Mohamed Said](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MJ.jpg) Mohamed Said 5 Sep 2026 3 min read Read ](https://www.msaied.com/articles/filament-v3-custom-field-plugins-building-a-reusable-signature-pad-component) [ ![Mohamed Said](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MH.png) Mohamed Said Laravel Backend Engineer ](https://www.msaied.com)Senior Backend Engineer specializing in Laravel, scalable SaaS platforms, APIs, and cloud infrastructure. I build secure, high-performance web applications that help businesses grow. Explore - [Home](https://www.msaied.com) - [Projects](https://www.msaied.com/projects) - [Articles](https://www.msaied.com/articles) - [Certificates](https://www.msaied.com/certificates) - [Contact](https://www.msaied.com#contact-section) Connect - [ hello@msaied.com ](mailto:hello@msaied.com) - [ +20 109 461 9204 ](tel:+201094619204) © 2026 Mohamed Said. All rights reserved. [ ](https://github.com/EG-Mohamed) [ ](https://www.linkedin.com/in/msaiedm/) [ ](https://wa.me/201094619204) [ ](mailto:hello@msaied.com) [ ](https://drive.google.com/file/u/0/d/1MF20IPRJyzfy32mhEutjL5EpSls0w2Q8/view)