0063-laravel-performance-select-columns

Select specific columns in Laravel Eloquent by applying the `select()` method to your base queries and relation constraints, which reduces payload size and application memory pressure by avoiding `*`.

Laravel API memory usage spikes when returning paginated Eloquent models because unfiltered database selects transfer and hydrate more data than needed, increasing memory pressure and slowing responses.

Apply column selection to eager-loaded relations in Laravel by adding `select()` constraints inside your `with()` calls to avoid unnecessary data transfer and keep N+1 issues under control.

The best way to optimize Laravel Eloquent queries for large payloads is selecting only required fields on base models and eager-loaded relations, ensuring returned DTOs or resources match the fetched data.

Yes, you can use `select()` with Laravel eager loading without breaking DTOs by keeping your resources aligned with the selected fields, ensuring you do not rely on unfetched attributes.

Avoid selective column fetching in Laravel Eloquent when your DTOs or resources require attributes you did not include in the `select()` statement, as accessing unfetched columns will cause errors.