Symfony Profiler

<?php
namespace App\Repository;
use App\Entity\Tenders;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;
class TendersRepository extends ServiceEntityRepository
{
public function __construct(ManagerRegistry $registry)
{
parent::__construct($registry, Tenders::class);
}
/**
* @return Tenders[]
*/
public function getTendersClosing():array
{
$now = new \DateTime();
$closing_soon = $this->createQueryBuilder('t')
->andWhere('t.closingDate <= :close')
->setParameter('close', new \DateTime('+14 days'))
->andWhere('t.closingDate > :now')
->setParameter('now', $now)
->orderBy('t.closingDate', 'DESC')
->setMaxResults(3)
->getQuery()->execute();
return $closing_soon;
}
public function getTenders($status,$region):array
{
$tenders = $this->createQueryBuilder('t')
->andWhere('t.status = :status')
->setParameter('status', $status)
->andWhere('t.region = :region')
->setParameter('region', $region)
->orderBy('t.closingDate', 'DESC')
->setMaxResults(3)
->getQuery()->execute();
return $tenders;
}
public function getTendersByStatus($status):array
{
$tenders = $this->createQueryBuilder('t')
->andWhere('t.status = :status')
->setParameter('status', $status)
->orderBy('t.closingDate', 'DESC')
->getQuery()->execute();
return $tenders;
}
public function getTendersByRegion($region):array
{
$tenders = $this->createQueryBuilder('t')
->andWhere('t.region = :region')
->setParameter('region', $region)
->orderBy('t.closingDate', 'DESC')
->getQuery()->execute();
return $tenders;
}
public function getTenderSearchResults($region = null, $category = null, $status = null):array
{
$queryBuilder = $this->createQueryBuilder('t');
$queryBuilder->select('t','c','r')
->leftJoin('t.category', 'c')
->leftJoin('t.region', 'r');
if($region != null){
$queryBuilder->andWhere('t.region = :region')
->setParameter('region', $region);
}
if($category != null){
$queryBuilder->andWhere('t.category = :category')
->setParameter('category', $category);
}
if($status != null){
$queryBuilder->andWhere('t.status = :status')
->setParameter('status', $status);
}
$queryBuilder->orderBy('t.closingDate', 'DESC');
$results = $queryBuilder->getQuery()->execute();
return $results;
}
public function getActiveTenders(): array
{
$queryBuilder = $this->createQueryBuilder('t')
->andWhere('t.status = :status')
->setParameter('status', 1)
->getQuery()->execute();
return $queryBuilder;
}
public function getClosedTenders():array
{
$queryBuilder = $this->createQueryBuilder('t')
->andWhere('t.status = :status')
->setParameter('status', 4)
->getQuery()->execute();
return $queryBuilder;
}
public function getTenderById($tender_id): array
{
$queryBuilder = $this->createQueryBuilder('t')
->andWhere('t.id = :tender_id')
->setParameter('tender_id', $tender_id)
->getQuery()->execute();
return $queryBuilder;
}
}

src/Repository/TendersRepository.php line 50