Eloquent Relationships and Loading

Model relationships express your domain; load only what you need.

Commands

Typical loading

Post::with(['author', 'tags'])->withCount('comments')->paginate(20);

Constrained eager loading

User::with(['posts' => fn($q) => $q->latest()->where('published', true)])->find($id);

Pivot ops (many-to-many)

$post->tags()->sync([1,2,3]); // atomic replace $post->tags()->syncWithoutDetaching([4]);

Chunking large reads

Order::where('status', 'open')->lazy()->each(fn($o) => ...);

Patterns

• See laravel:performance-eager-loading for N+1 detection and measurement

• Use whereHas() / has() to filter by related existence

• Prefer withCount , withSum , withMax for simple aggregates

• Apply global / local scopes for recurring constraints

• Keep relationship names consistent and pluralized where appropriate