Symfony rest api

Я разрабатываю приложение rest api с symfony в бэкэнде. Моя проблема в том, что когда я пытаюсь запустить запрос GET, приложение запускается, не давая никакого ответа даже через десять минут.

это метод запроса:

/**
 * CounterRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class CounterRepository extends \Doctrine\ORM\EntityRepository
{

    /**
     * @param string $name
     * @param int $date
     * @return mixed
     * @throws \Exception
     */
    public function getValuesByNameAndDate(string $name, int $date)
    {
        $query = $this
            ->createQueryBuilder('c')
            ->leftJoin('c.values', 'v', 'WITH')
            ->addSelect('v')
            ->where('c.name = :name')
            ->andWhere('v.date = :date')
            ->setParameters(
                array(
                    'date' => $date,
                    'name' => $name
                )
            )
            ->getQuery();
        return $query->getResult();
    }

}

Сущность CounterValue:

/**
 * CounterValue
 *
 * @ORM\Table(name = "counter_value")
 * @ORM\Entity(repositoryClass = "AppBundle\Repository\CounterValueRepository")
 */
class CounterValue
{

    /**
     * @var int
     *
     * @ORM\Column(name = "id", type = "integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy = "AUTO")
     */
    private $id;

    /**
     * @var float
     *
     * @ORM\Column(name = "value", type = "float")
     */
    private $value;

    /**
     * @var int
     *
     * @ORM\Column(name = "date", type = "integer")
     */
    private $date;

    /**
     * @var Counter
     *
     * @ORM\ManyToOne(targetEntity = "Counter", inversedBy = "values")
     * @ORM\JoinColumn()
     */
    private $counter;

    /**
     * @var City
     *
     * @ORM\ManyToOne(targetEntity = "City", inversedBy = "values"))
     * @ORM\JoinColumn()
     */
    protected $city;

    public function __construct()
    {
        $date = new \DateTime('-1 day');
        $this->date = strtotime($date->format('d-m-Y'));
    }

    /**
     * Get id.
     *
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * Set value.
     *
     * @param float $value
     *
     * @return CounterValue
     */
    public function setValue($value)
    {
        $this->value = $value;

        return $this;
    }

    /**
     * Get value.
     *
     * @return float
     */
    public function getValue()
    {
        return $this->value;
    }

    /**
     * Set date.
     *
     * @param int $date
     *
     * @return CounterValue
     */
    public function setDate($date)
    {
        $this->date = $date;

        return $this;
    }

    /**
     * Get date.
     *
     * @return int
     */
    public function getDate()
    {
        return $this->date;
    }

    /**
     * @return Counter
     */
    public function getCounter(): Counter
    {
        return $this->counter;
    }

    /**
     * @param Counter $counter
     */
    public function setCounter(Counter $counter): void
    {
        $this->counter = $counter;
    }

    /**
     * @return City
     */
    public function getCity(): City
    {
        return $this->city;
    }

    /**
     * @param City $city
     */
    public function setCity(City $city): void
    {
        $this->city = $city;
    }

}

/**
 * Counter
 *
 * @ORM\Table(name = "counter")
 * @ORM\Entity(repositoryClass = "AppBundle\Repository\CounterRepository")
 */
class Counter
{

    /**
     * @var int
     *
     * @ORM\Column(name = "id", type = "integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy = "AUTO")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(name = "name", type = "string", length=255, unique=false)
     */
    private $name;

    /**
     * @var XmlFile
     *
     * @ORM\ManyToOne(targetEntity = "XmlFile", inversedBy = "counters", cascade = {"remove"})
     * @ORM\JoinColumn(nullable=false)
     */
    private $xmlFile;

    /**
     * @var ArrayCollection
     *
     * @ORM\OneToMany(targetEntity = "CounterValue", mappedBy = "counter", cascade = {"persist"})
     */
    private $values;

    public function __construct()
    {
        $this->values = new ArrayCollection();
    }

    /**
     * Get id.
     *
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * Set name.
     *
     * @param string $name
     *
     * @return Counter
     */
    public function setName($name)
    {
        $this->name = $name;

        return $this;
    }

    /**
     * Get name.
     *
     * @return string
     */
    public function getName()
    {
        return $this->name;
    }

    /**
     * Set xmlFile
     *
     * @param XmlFile $xmlFile
     */
    public function setXmlFile(XmlFile $xmlFile)
    {
        $this->xmlFile = $xmlFile;
    }

    /**
     * Get xmlFile
     *
     * @return XmlFile
     */
    public function getXmlFile(): XmlFile
    {
        return $this->xmlFile;
    }

    /**
     * @return ArrayCollection
     */
    public function getValues(): ArrayCollection
    {
        return $this->values;
    }

    /**
     * @param ArrayCollection $values
     */
    public function setValues(ArrayCollection $values): void
    {
        $this->values = $values;
    }

    /**
     * Add $value
     *
     * @param CounterValue $value
     */
    public function addValue(CounterValue $value)
    {
        $value->setCounter($this);
        if (!$this->values->contains($value)){
            $this->values->add($value);
        }
    }

}

И, наконец, мой метод в контроллере

$em = $this->get('doctrine.orm.entity_manager');
$counterRep = $em->getRepository('AppBundle:Counter');
return $counterRep->getValuesByNameAndDate('L.IRATHO.E2G.CSFB.ExecSuccOut', 1533600000);