Attempt to limit quantity of loaded relationships (eg. only load 5 presentations with the Category)

CategoryRepository.php

<?php

namespace AppBundle\Repository;



use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Tools\Pagination\Paginator;

class CategoryRepository extends EntityRepository
{


    function getCategoryWithGivenAmountOfPresentations($limit = 5, $offset = 0){

        $em = $this->getEntityManager();

        $dql = <<< EOF
        SELECT cat,prezis  FROM AppBundle:Category cat
           JOIN cat.presentations prezis
EOF;

        $query = $em->createQuery($dql)
                    ->setFirstResult($offset)
                    ->setMaxResults($limit);
        $paginator = new Paginator($query, $fetchJoinCollection = true);

//        $c = count($paginator);

        return $paginator;
    }

}