How to get related data in one request?

Question

Laravel

There is:

class YarnController extends Controller
{
    public function show($manufacturer, $collection = null)
    {
        if (!$collection) {
            $collections = Collection::whereHas('manufacturer', function($query) use ($manufacturer) {
                $query->where('id', $manufacturer);
            })->get();
        } else {
            $collections = Collection::whereHas('manufacturer', function($query) use ($manufacturer) {
                $query->where('id', $manufacturer);
            })->where('id', $collection)->get();
        }

        return view('yarn', compact('collections'));
    }
}

And

@foreach ($collections as $collection)
    <p>{{ $collection->manufacturer->name }} - {{ $collection->name }}</p>
@endforeach

It turns out:

select * from `collections` where exists (select * from `manufacturers` where `collections`.`manufacturer_id` = `manufacturers`.`id` and `id` = '2')
select * from `manufacturers` where `manufacturers`.`id` = 2 limit 1
select * from `manufacturers` where `manufacturers`.`id` = 2 limit 1
select * from `manufacturers` where `manufacturers`.`id` = 2 limit 1

Producer collections are displayed in one request, but a new request is made each time to get the producer.

Answer 1

Collection:: with('manufacturer') ->whereHas...
https://laravel.com/docs/8.x/eloquent-relationship...