Как правильно создать запрос в доктрине?

public function indexAction()
    {
        $query = $this->entityManager->getRepository(Products::class)
                      ->findAllProductsWithCategory();
//              var_dump($query); die();
        $page = $this->params()->fromQuery('page', 1);
        
        $adapter = new DoctrineAdapter(new ORMPaginator($query, false));
        $paginator = new Paginator($adapter);
        $paginator->setDefaultItemCountPerPage(1);        
        $paginator->setCurrentPageNumber($page);
        // Визуализируем шаблон представления.
        return new ViewModel([
            'products' => $paginator,
        ]);
    }

<table class="table table-striped table-hover">
    <tbody>
        <tr>
            <th>ID</th>
            <th>Название</th>
            <th>Цена</th>
            <th>Категория</th>
            <th>Описание</th>
            <th>Изображение</th>
            <th>Действие</th>
        </tr>
        <?php foreach($products as $product):?>
            <tr>
                <td><?php echo $this->escapeHtml($product->getId());?></td>
                <td><?php echo $this->escapeHtml($product->getName());?></td>
                <td><?php echo $this->escapeHtml($product->getPrice());?></td>
                <td><?php echo $this->escapeHtml($product->getCategory());?></td>
                <td><?php echo $this->escapeHtml($product->getDescription());?></td>
                <td><?php echo $this->escapeHtml($product->getImage());?></td>
                <td>
                    <a class="btn btn-success" href="<?= $this->url('admin/products', ['action' => 'edit', 'id' => $product->getId()]);?>"><span class="glyphicon glyphicon-pencil" ></span> Редактировать</a><?php echo '&nbsp;&nbsp;'?>
                    <a class="btn btn-danger" href="<?= $this->url('admin/products', ['action' => 'delete', 'id' => $product->getId()]);?>" onclick="if(confirm(\'Удалить запись?\'))  {document.location = this.href;} return false;"><span class="glyphicon glyphicon-remove"></span> Удалить</a>
                </td>
            </tr>
        <?php endforeach;?>      
    </tbody>
</table>
<?= $this->paginationControl($products,
            'Sliding',
            'application/partial/paginator', 
            ['route' => 'admin/products']); ?>

public function findAllProductsWithCategory()
    {
    $entityManager = $this->getEntityManager();    
    $queryBuilder = $entityManager->createQueryBuilder();    
    $queryBuilder->select('p')
        ->from(Products::class, 'p')
        ->join('p.category', 'c')
        ->where('p.category_id = ?1')
        ->orderBy('p.id', 'DESC')
        ->setParameter('1', 'c.id');
           
    return $queryBuilder->getQuery();
    }