Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• Doctrine 1
• HTTP Client
• Debug
• Emails
• Notifications
• Configuration

Log Messages

"list_residential_complexes_on_map"

[
  "route" => "list_residential_complexes_on_map"
  "route_parameters" => [
    "_route" => "list_residential_complexes_on_map"
    "_controller" => "App\Controller\ResidentialComplexController::listResidentialComplexesOnMap"
    "_locale" => "en"
  ]
  "request_uri" => "https://imobiliare.n46.net/en/residential-complexes-on-map"
  "method" => "GET"
]

[
  "firewall_name" => "user_secured_area"
  "authenticators" => 2
]

[
  "firewall_name" => "user_secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "user_secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "user_secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "user_secured_area"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "driver" => "pdo_mysql"
  "charset" => "utf8mb4"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "1007-imobiliare"
  "password" => "<redacted>"
  "driverOptions" => []
  "serverVersion" => "mariadb-10.11.15"
  "defaultTableOptions" => [
    "charset" => "utf8mb4"
    "collation" => "utf8mb4_unicode_ci"
    "engine" => "InnoDB"
  ]
  "dbname" => "1007-imobiliare"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "1007-imobiliare"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "mariadb-10.11.15"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collation" => "utf8mb4_unicode_ci"
      "engine" => "InnoDB"
    ]
    "dbname" => "1007-imobiliare"
  ]
]

"SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3, ST_AsText(t0.multipolygon) AS multipolygon_4, ST_AsText(t0.centroid) AS centroid_5, t0.land_area AS land_area_6, t0.name AS name_7, t0.rcslug AS rcslug_8, t0.address AS address_9, t0.instagram_reel_id AS instagram_reel_id_10, t0.price_per_square_meter AS price_per_square_meter_11, t0.completion_date AS completion_date_12, t0.is_sold_out AS is_sold_out_13, t0.client_status AS client_status_14, t0.server_status AS server_status_15, t0.views AS views_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.locality_id AS locality_id_20 FROM ax_residential_complex t0 WHERE t0.client_status = ? AND t0.server_status = ? ORDER BY t0.name ASC"

[
  1 => "active"
  2 => "ok"
]

[
  1 => Doctrine\DBAL\ParameterType {#1333
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#1333}
]

[
  "sql" => "SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3, ST_AsText(t0.multipolygon) AS multipolygon_4, ST_AsText(t0.centroid) AS centroid_5, t0.land_area AS land_area_6, t0.name AS name_7, t0.rcslug AS rcslug_8, t0.address AS address_9, t0.instagram_reel_id AS instagram_reel_id_10, t0.price_per_square_meter AS price_per_square_meter_11, t0.completion_date AS completion_date_12, t0.is_sold_out AS is_sold_out_13, t0.client_status AS client_status_14, t0.server_status AS server_status_15, t0.views AS views_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.locality_id AS locality_id_20 FROM ax_residential_complex t0 WHERE t0.client_status = ? AND t0.server_status = ? ORDER BY t0.name ASC"
  "params" => [
    1 => "active"
    2 => "ok"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1333
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1333}
  ]
]

"SELECT COUNT(a0_.id) AS sclr_0 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ?"

[
  1 => "active"
  2 => "ok"
]

[
  1 => Doctrine\DBAL\ParameterType {#1333
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#1333}
]

[
  "sql" => "SELECT COUNT(a0_.id) AS sclr_0 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ?"
  "params" => [
    1 => "active"
    2 => "ok"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1333
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1333}
  ]
]

"SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2 FROM ax_district a0_"

[
  "sql" => "SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2 FROM ax_district a0_"
]

[
  "exception" => Twig\Error\RuntimeError {#1458
    #message: "An exception has been thrown during the rendering of a template ("Some mandatory parameters are missing ("districtSlug") to generate a URL for route "show_residential_complex.en".") in "web/list_residential_complexes_on_map.html.twig" at line 144."
    #code: 0
    #file: "/var/www/vhosts/1007/domains/n46.net/imobiliare/templatesV1/web/list_residential_complexes_on_map.html.twig"
    #line: 144
    -previous: Symfony\Component\Routing\Exception\MissingMandatoryParametersException {#1936 …}
    -lineno: 144
    -rawMessage: "An exception has been thrown during the rendering of a template ("Some mandatory parameters are missing ("districtSlug") to generate a URL for route "show_residential_complex.en".")."
    -source: Twig\Source {#1938 …}
    -phpFile: "/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php"
    -phpLine: 460
    trace: {
      /var/www/vhosts/1007/domains/n46.net/imobiliare/templatesV1/web/list_residential_complexes_on_map.html.twig:144 {
        Twig\Template->yieldBlock($name, array $context, array $blocks = [], $useBlocks = true, ?Template $templateContext = null): iterable …
        › onEachFeature: function (feature, layer) {
        ›     let rcpath0 = '{{ path('show_residential_complex', {dref: 'district-ref', rcslug: 'residential-complex-slug'}) }}';
        ›     let rcpath1 = rcpath0.replace('district-ref', feature.properties.rcdistrictRef);
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/templatesV1/base.html.twig:755 {
        __TwigTemplate_92f2c6fc01b0746f436ea63c952c4402->doDisplay(array $context, array $blocks = []): iterable …
        › 
        › {% block javascripts_footer %}
        ›         {{ encore_entry_script_tags('app') }}
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php:402 {
        Twig\Template->yield(array $context, array $blocks = []): iterable …
        › try {
        ›     yield from $this->doDisplay($context, $blocks);
        › } catch (Error $e) {
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/var/cache/dev/twig/a9/a92a7ca6a8e6a8137f4de4e9b6b77bd5.php:61 {
        __TwigTemplate_14c4e022f8264ea126a51c30c97fe25b->doDisplay(array $context, array $blocks = []): iterable …
        › $this->parent = $this->load("base.html.twig", 1);
        › yield from $this->parent->unwrap()->yield($context, array_merge($this->blocks, $blocks));
        › 
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php:402 {
        Twig\Template->yield(array $context, array $blocks = []): iterable …
        › try {
        ›     yield from $this->doDisplay($context, $blocks);
        › } catch (Error $e) {
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php:358 {
        Twig\Template->display(array $context, array $blocks = []): void …
        › {
        ›     foreach ($this->yield($context, $blocks) as $data) {
        ›         echo $data;
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php:373 {
        Twig\Template->render(array $context): string …
        › try {
        ›     $this->display($context);
        › } catch (\Throwable $e) {
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/TemplateWrapper.php:51 {
        Twig\TemplateWrapper->render(array $context = []): string …
        › {
        ›     return $this->template->render($context);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Environment.php:333 {
        Twig\Environment->render($name, array $context = []): string …
        › {
        ›     return $this->load($name)->render($context);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/framework-bundle/Controller/AbstractController.php:462 {
        Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView(string $view, ?string $block, array $parameters, string $method): string …
        › 
        ›     return $this->container->get('twig')->render($view, $parameters);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/framework-bundle/Controller/AbstractController.php:467 {
        Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response …
        › {
        ›     $content = $this->doRenderView($view, $block, $parameters, $method);
        ›     $response ??= new Response();
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/framework-bundle/Controller/AbstractController.php:279 {
        Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render(string $view, array $parameters = [], ?Response $response = null): Response …
        › {
        ›     return $this->doRender($view, null, $parameters, $response, __FUNCTION__);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/src/Controller/ResidentialComplexController.php:43 {
        App\Controller\ResidentialComplexController->listResidentialComplexesOnMap(EntityManagerInterface $entityManager, ResidentialComplexRepository $residentialComplexes): Response …
        › 
        › return $this->render('web/list_residential_complexes_on_map.html.twig', [
        ›     'total_residential_complexes' => $residentialComplexes->countActiveResidentialComplexes(),
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/http-kernel/HttpKernel.php:183 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
        › // call controller
        › $response = $controller(...$arguments);
        › 
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/http-kernel/HttpKernel.php:76 {
        Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
        › try {
        ›     return $response = $this->handleRaw($request, $type);
        › } catch (\Throwable $e) {
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/http-kernel/Kernel.php:191 {
        Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
        › try {
        ›     return $this->getHttpKernel()->handle($request, $type, $catch);
        › } finally {
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
        Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
        › {
        ›     $response = $this->kernel->handle($this->request);
        › 
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php:32 {
        require_once …
        ›         ->getRunner($app)
        ›         ->run()
        › );
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/public_html/index.php:5 {
        › 
        › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
        › 
        arguments: {
          "/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php"
        }
      }
    }
  }
]

{
  /var/www/vhosts/1007/domains/n46.net/imobiliare/templatesV1/web/list_residential_complexes_on_map.html.twig:144 {
    Twig\Template->yieldBlock($name, array $context, array $blocks = [], $useBlocks = true, ?Template $templateContext = null): iterable …
    › onEachFeature: function (feature, layer) {
    ›     let rcpath0 = '{{ path('show_residential_complex', {dref: 'district-ref', rcslug: 'residential-complex-slug'}) }}';
    ›     let rcpath1 = rcpath0.replace('district-ref', feature.properties.rcdistrictRef);
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/templatesV1/base.html.twig:755 {
    __TwigTemplate_92f2c6fc01b0746f436ea63c952c4402->doDisplay(array $context, array $blocks = []): iterable …
    › 
    › {% block javascripts_footer %}
    ›         {{ encore_entry_script_tags('app') }}
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php:402 {
    Twig\Template->yield(array $context, array $blocks = []): iterable …
    › try {
    ›     yield from $this->doDisplay($context, $blocks);
    › } catch (Error $e) {
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/var/cache/dev/twig/a9/a92a7ca6a8e6a8137f4de4e9b6b77bd5.php:61 {
    __TwigTemplate_14c4e022f8264ea126a51c30c97fe25b->doDisplay(array $context, array $blocks = []): iterable …
    › $this->parent = $this->load("base.html.twig", 1);
    › yield from $this->parent->unwrap()->yield($context, array_merge($this->blocks, $blocks));
    › 
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php:402 {
    Twig\Template->yield(array $context, array $blocks = []): iterable …
    › try {
    ›     yield from $this->doDisplay($context, $blocks);
    › } catch (Error $e) {
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php:358 {
    Twig\Template->display(array $context, array $blocks = []): void …
    › {
    ›     foreach ($this->yield($context, $blocks) as $data) {
    ›         echo $data;
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Template.php:373 {
    Twig\Template->render(array $context): string …
    › try {
    ›     $this->display($context);
    › } catch (\Throwable $e) {
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/TemplateWrapper.php:51 {
    Twig\TemplateWrapper->render(array $context = []): string …
    › {
    ›     return $this->template->render($context);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/twig/twig/src/Environment.php:333 {
    Twig\Environment->render($name, array $context = []): string …
    › {
    ›     return $this->load($name)->render($context);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/framework-bundle/Controller/AbstractController.php:462 {
    Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView(string $view, ?string $block, array $parameters, string $method): string …
    › 
    ›     return $this->container->get('twig')->render($view, $parameters);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/framework-bundle/Controller/AbstractController.php:467 {
    Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response …
    › {
    ›     $content = $this->doRenderView($view, $block, $parameters, $method);
    ›     $response ??= new Response();
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/framework-bundle/Controller/AbstractController.php:279 {
    Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render(string $view, array $parameters = [], ?Response $response = null): Response …
    › {
    ›     return $this->doRender($view, null, $parameters, $response, __FUNCTION__);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/src/Controller/ResidentialComplexController.php:43 {
    App\Controller\ResidentialComplexController->listResidentialComplexesOnMap(EntityManagerInterface $entityManager, ResidentialComplexRepository $residentialComplexes): Response …
    › 
    › return $this->render('web/list_residential_complexes_on_map.html.twig', [
    ›     'total_residential_complexes' => $residentialComplexes->countActiveResidentialComplexes(),
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/http-kernel/HttpKernel.php:183 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
    › // call controller
    › $response = $controller(...$arguments);
    › 
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/http-kernel/HttpKernel.php:76 {
    Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
    › try {
    ›     return $response = $this->handleRaw($request, $type);
    › } catch (\Throwable $e) {
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/http-kernel/Kernel.php:191 {
    Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
    › try {
    ›     return $this->getHttpKernel()->handle($request, $type, $catch);
    › } finally {
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
    Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
    › {
    ›     $response = $this->kernel->handle($this->request);
    › 
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php:32 {
    require_once …
    ›         ->getRunner($app)
    ›         ->run()
    › );
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/public_html/index.php:5 {
    › 
    › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
    › 
    arguments: {
      "/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/autoload_runtime.php"
    }
  }
}