name: laravel:performance-select-columns description: Select only required columns to reduce memory and transfer costs; apply to base queries and relations
Select Only Needed Columns
Reduce payloads by selecting exact fields:
User::select(['id', 'name'])->paginate();
Post::with(['author:id,name'])->select(['id','author_id','title'])->get();
- Avoid
*; keep DTOs/resources aligned with selected fields - Combine with eager loading to avoid N+1