Does the ->with() construct cause a memory leak in Laravel?

Question

Laravel

Hello.
There is a request like this:

$products->joinRelations('categories')->with('products')->whereNotNull('category_id')->groupBy('category_id')->getCache(['product_categories.*']);

The results of his work are as follows:

Accordingly, without the ->with('products')

construct, the memory consumption is obviously less (but still in excess), but there are more requests (because a new request is executed with each output of products).
Need advice on how best to optimize this business?
I do not ask for ready-made code, please push in the right direction.

Answer 1

Rewrote it like this:

public function scopeGetCategories($query){
      $categories = clone $query;
      return $categories->joinRelations('categories')
            ->selectRaw('*, count(`product_category_values`.`product_id`) as products_count')
            ->whereNotNull('category_id')->groupBy('category_id')
            ->getCache(['product_categories.*']);
    }

To determine the number of products in a category, I used selectRaw .
Accordingly, instead of counting links, I immediately take the value of products_count.
The result, as they say, on the face. Memory consumption is within the normal range.