# Laravel Performance Eager Loading

> Eager Loading and N+1 Prevention

- Skill: `comeonoliver/laravel-performance-eager-loading` (Agent Skill)
- Install (CLI): `npx skillmds@latest add comeonoliver/laravel-performance-eager-loading`
- Raw SKILL.md: https://api.skillmd.com/api/skills/comeonoliver/laravel-performance-eager-loading/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ComeOnOliver (https://skillmd.com/u/comeonoliver)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/comeonoliver/laravel-performance-eager-loading

---

# Eager Loading and N+1 Prevention

## Load Relations Explicitly

```php
Post::with(['author', 'comments'])->paginate();
```

- Use `load()`/`loadMissing()` after fetching models when needed
- Select only required columns for both base query and relations

## Guard Against Lazy Loading in Dev/Test

Add to a service provider (non-production):

```php
Model::preventLazyLoading(! app()->isProduction());
```

## Verify

- Use a query logger or debugbar to confirm relation queries are minimized
- Add tests that assert counts or avoid unexpected query spikes

