Symfony Profiler

<?php
namespace Aviatur\SearchBundle\Controller;
use Aviatur\AgencyBundle\Entity\Agency;
use Aviatur\EditionBundle\Entity\HomePromo;
use Aviatur\EditionBundle\Entity\HomePromoList;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Doctrine\Persistence\ManagerRegistry;
use Symfony\Component\HttpFoundation\RequestStack;
use Aviatur\TwigBundle\Services\TwigFolder;
use Aviatur\CarBundle\Services\SearchCarCookie;
class CarController extends AbstractController
{
public function indexAction(RequestStack $requestStack, ManagerRegistry $registry, SearchCarCookie $searchCarCookie, TwigFolder $twigFolder)
{
$em = $registry->getManager();
$session = $requestStack->getSession();
$cookieLastSearch = $searchCarCookie->searchCarCookie();
$agencyId = $session->get('agencyId');
$agency = $em->getRepository(Agency::class)->find($agencyId);
$promoType = '';
$promoTypeMain = '-main';
$promoTypeRecommendations = '-recommendations';
if ($session->has('whitemark') === true) {
$promoType = '_' . $session->get('whitemark');
}
$agenciesExcluded = ['Aviatur S.A.S.', 'Aviatur S.A.S. Metasearch', 'Aval', 'Aviacaribbean', 'Aviatur - WorldPay', 'Aviatur Carnaval BAQ MB', 'Aviatur Colombia', 'Aviatur Colombia EN', 'Aviatur Colombia ES', 'Aviatur Ecoturismo', 'Aviatur Kioskos', 'Aviatur Metasearch Mexico', 'Aviatur Mexico', 'Aviatur Mexico QA', 'Aviatur Mobile', 'Aviatur PinBus', 'Aviatur - Pruebas', 'BabyMarket', 'Buceo Colombia', 'Cielos Abiertos', 'Corona Aviatur', 'Directo a la Playa', 'Experiencias Jet-Set', 'Great Vibes', 'Landing visa', 'Lufthansa City Center', 'Megatours', 'Octopus Agents', 'Octopus Marcas Blancas', 'Octopus Travel QA', 'Panturismo Marcas Blancas', 'Parque Tayrona', 'Representaciones Pasabordo WM', 'Rokatur Marcas Blancas', 'RollingTrips', 'Star World', 'Swissandina', 'Takentours', 'TerraNet Marcas Blancas', 'Turiscol Ltda.', 'Aviatur S.A.', 'Union de Representaciones', 'Union de Representaciones - Whitemark', 'Virtuoso', 'Claro', 'WeCare', 'Octopus Travel Ltda.', 'Aviatur Site', 'Aviatur S.A.S. - BBVA', 'Aviatur Welcome Beds'];
$agencyPromoId = 172;
$validationAgencyFolder = false;
foreach ($agenciesExcluded as $agencyExcluded) {
if ($agencyExcluded === $agency->getName()) {
$agencyPromoId = $session->get('agencyId');
$validationAgencyFolder = true;
}
}
$homePromoList = $em->getRepository(HomePromoList::class)->findOneBy([
'type' => sprintf('__autos%s', $promoType),
'agency' => $agencyPromoId,
]);
if ($homePromoList != null) {
$homePromoTitle = $homePromoList->getTitle();
$homePromoSubtitle = $homePromoList->getSubtitle();
$homePromos = $em->getRepository(HomePromo::class)->findByHomePromoList($homePromoList, ['date' => 'DESC']);
} else {
$homePromoTitle = null;
$homePromoSubtitle = null;
$homePromos = [];
}
$homePromoListMain = $em->getRepository(HomePromoList::class)->findOneBy(["type" => '__autos' . $promoTypeMain, "agency" => $agencyPromoId]);
if ($homePromoListMain != null) {
$homePromoMainTitle = $homePromoListMain->getTitle();
$homePromoMainSubtitle = $homePromoListMain->getSubtitle();
$homePromosMain = $em->getRepository(HomePromo::class)->findByHomePromoList($homePromoListMain, ['date' => 'DESC']);
} else {
$homePromoMainTitle = null;
$homePromoMainSubtitle = null;
$homePromosMain = [];
}
$homePromoListRecommendations = $em->getRepository(HomePromoList::class)->findOneBy([
'type' => sprintf('__autos%s', $promoTypeRecommendations),
'agency' => $agencyPromoId,
]);
if ($homePromoListRecommendations != null) {
$homePromoRecommendationsTitle = $homePromoListRecommendations->getTitle();
$homePromoRecommendationsSubtitle = $homePromoListRecommendations->getSubtitle();
$homePromosRecommendations = $em->getRepository(HomePromo::class)->findByHomePromoList($homePromoListRecommendations, ['date' => 'DESC']);
} else {
$homePromoRecommendationsTitle = null;
$homePromoRecommendationsSubtitle = null;
$homePromosRecommendations = [];
}
$agencyFolder = $twigFolder->twigFlux();
return $this->render($twigFolder->twigExists(sprintf('@AviaturTwig/%s/Search/Car/carSearch_index.html.twig', $agencyFolder)), [
'cookieLastSearch' => $cookieLastSearch,
'homePromos' => $homePromos,
'titlePromo' => $homePromoTitle,
'subtitlePromo' => $homePromoSubtitle,
'promoType' => '__autos',
'homePromosMain' => $homePromosMain,
'titlePromoMain' => $homePromoMainTitle,
'subtitlePromoMain' => $homePromoMainSubtitle,
'promoTypeMain' => sprintf('__autos%s', $promoTypeMain),
'homePromosRecommendations' => $homePromosRecommendations,
'titlePromoRecommendations' => $homePromoRecommendationsTitle,
'subtitlePromoRecommendations' => $homePromoRecommendationsSubtitle,
'promoTypeRecommendations' => sprintf('__autos%s', $promoTypeRecommendations),
'validationAgencyFolder' => $validationAgencyFolder,
]);
}
}

src/Aviatur/SearchBundle/Controller/CarController.php line 23