Laravel Performance Eager Loading

Prevent N+1 queries by eager loading; enable lazy-loading protection in non-production; choose selective fields

noartem Updated 13 repo stars

File contents

Eager Loading and N+1 Prevention

Load Relations Explicitly

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):

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

noartem/laravel-vue-skills commit 5e247ca96a

Frequently asked questions

npx get-skill add noartem/laravel-performance-eager-loading