Symfony Profiler

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

Log Messages

"list_residential_complexes"

[
  "route" => "list_residential_complexes"
  "route_parameters" => [
    "_route" => "list_residential_complexes"
    "_controller" => "App\Controller\ResidentialComplexController::listResidentialComplexes"
    "_locale" => "en"
  ]
  "request_uri" => "https://imobiliare.n46.net/en/residential-complexes"
  "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 a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10"

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

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

[
  "sql" => "SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10"
  "params" => [
    1 => "active"
    2 => "ok"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1141
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1141}
  ]
]

[
  "exception" => Doctrine\DBAL\Exception\InvalidFieldNameException {#992
    #message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.instagram_reel_id' in 'SELECT'"
    #code: 1054
    #file: "/var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
    #line: 63
    -previous: Doctrine\DBAL\Driver\PDO\Exception {#1140 …}
    -query: Doctrine\DBAL\Query {#1277 …}
    trace: {
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63 {
        Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
        › 1166,
        › 1611 => new InvalidFieldNameException($exception, $query),
        › 1052,
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Connection.php:1460 {
        Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
        › $this->exceptionConverter ??= $this->driver->getExceptionConverter();
        › $exception                  = $this->exceptionConverter->convert($driverException, $query);
        › 
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Connection.php:1396 {
        Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
        › ): DriverException {
        ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Connection.php:809 {
        Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
        › } catch (Driver\Exception $e) {
        ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27 {
        Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(Connection $conn, array $params, array $types): Result …
        › {
        ›     return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/Query.php:296 {
        Doctrine\ORM\Query->_doExecute(): Result|int …
        › 
        ›     return $executor->execute($this->em->getConnection(), $sqlParams, $types);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/AbstractQuery.php:930 {
        Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
        › 
        › $stmt = $this->_doExecute();
        › 
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/AbstractQuery.php:886 {
        Doctrine\ORM\AbstractQuery->execute(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
        › 
        ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/AbstractQuery.php:688 {
        Doctrine\ORM\AbstractQuery->getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed …
        › {
        ›     return $this->execute(null, $hydrationMode);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:151 {
        Doctrine\ORM\Tools\Pagination\Paginator->getIterator(): Traversable …
        ›         ->setCacheable($this->query->isCacheable())
        ›         ->getResult($this->query->getHydrationMode());
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/src/Pagination/Paginator.php:56 {
        App\Pagination\Paginator->paginate(int $page): Paginator …
        › 
        › $this->results = $paginator->getIterator();
        › $this->numResults = $paginator->count();
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/src/Repository/ResidentialComplexRepository.php:61 {
        App\Repository\ResidentialComplexRepository->findAllOrderByName(int $page): Paginator …
        › 
        ›     return (new Paginator($qb))->paginate($page);
        › }
      }
      /var/www/vhosts/1007/domains/n46.net/imobiliare/src/Controller/ResidentialComplexController.php:59 {
        App\Controller\ResidentialComplexController->listResidentialComplexes(ResidentialComplexRepository $residentialComplexes, Request $request): Response …
        › $page = $request->query->getInt('page', 1);
        › $result = $residentialComplexes->findAllOrderByName($page);
        › 
      }
      /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/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63 {
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
    › 1166,
    › 1611 => new InvalidFieldNameException($exception, $query),
    › 1052,
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Connection.php:1460 {
    Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
    › $this->exceptionConverter ??= $this->driver->getExceptionConverter();
    › $exception                  = $this->exceptionConverter->convert($driverException, $query);
    › 
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Connection.php:1396 {
    Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
    › ): DriverException {
    ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/dbal/src/Connection.php:809 {
    Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
    › } catch (Driver\Exception $e) {
    ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27 {
    Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(Connection $conn, array $params, array $types): Result …
    › {
    ›     return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/Query.php:296 {
    Doctrine\ORM\Query->_doExecute(): Result|int …
    › 
    ›     return $executor->execute($this->em->getConnection(), $sqlParams, $types);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/AbstractQuery.php:930 {
    Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
    › 
    › $stmt = $this->_doExecute();
    › 
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/AbstractQuery.php:886 {
    Doctrine\ORM\AbstractQuery->execute(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
    › 
    ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/AbstractQuery.php:688 {
    Doctrine\ORM\AbstractQuery->getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed …
    › {
    ›     return $this->execute(null, $hydrationMode);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:151 {
    Doctrine\ORM\Tools\Pagination\Paginator->getIterator(): Traversable …
    ›         ->setCacheable($this->query->isCacheable())
    ›         ->getResult($this->query->getHydrationMode());
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/src/Pagination/Paginator.php:56 {
    App\Pagination\Paginator->paginate(int $page): Paginator …
    › 
    › $this->results = $paginator->getIterator();
    › $this->numResults = $paginator->count();
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/src/Repository/ResidentialComplexRepository.php:61 {
    App\Repository\ResidentialComplexRepository->findAllOrderByName(int $page): Paginator …
    › 
    ›     return (new Paginator($qb))->paginate($page);
    › }
  }
  /var/www/vhosts/1007/domains/n46.net/imobiliare/src/Controller/ResidentialComplexController.php:59 {
    App\Controller\ResidentialComplexController->listResidentialComplexes(ResidentialComplexRepository $residentialComplexes, Request $request): Response …
    › $page = $request->query->getInt('page', 1);
    › $result = $residentialComplexes->findAllOrderByName($page);
    › 
  }
  /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"
    }
  }
}