Symfony Profiler

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

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#3100
    +count: 2
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/preprod_serenia/vendor/symfony/config/Definition/ArrayNode.php:228 {
        Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
        ›     $deprecation = $child->getDeprecation($name, $this->getPath());
        ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
        › }
      }
      /var/www/preprod_serenia/vendor/symfony/config/Definition/BaseNode.php:418 {
        › 
        › $value = $this->finalizeValue($value);
        › 
      }
    }
  }
]

{
  /var/www/preprod_serenia/vendor/symfony/config/Definition/ArrayNode.php:228 {
    Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
    ›     $deprecation = $child->getDeprecation($name, $this->getPath());
    ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
    › }
  }
  /var/www/preprod_serenia/vendor/symfony/config/Definition/BaseNode.php:418 {
    › 
    › $value = $this->finalizeValue($value);
    › 
  }
}

"app_home_index"

[
  "route" => "app_home_index"
  "route_parameters" => [
    "_route" => "app_home_index"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://www.preprod.scoringbyserenia.com/"
  "method" => "GET"
]

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

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

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

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

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

[
  "driver" => "pdo_pgsql"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 5432
  "user" => "serenia"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "db_serenia"
  "serverVersion" => "18"
  "charset" => "utf8"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "serenia"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "db_serenia"
    "serverVersion" => "18"
    "charset" => "utf8"
  ]
]

"SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.img AS img_3, a0_.path AS path_4, a0_.alt AS alt_5, a0_.markup_title AS markup_title_6, a0_.button AS button_7, a0_.link AS link_8 FROM adventure a0_ ORDER BY a0_.id ASC"

[
  "sql" => "SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.img AS img_3, a0_.path AS path_4, a0_.alt AS alt_5, a0_.markup_title AS markup_title_6, a0_.button AS button_7, a0_.link AS link_8 FROM adventure a0_ ORDER BY a0_.id ASC"
]

"SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.img AS img_3, b0_.path AS path_4, b0_.alt AS alt_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.date AS date_8, b0_.slug AS slug_9, b0_.is_active AS is_active_10, b0_.markup_title AS markup_title_11, b0_.meta AS meta_12, b0_.type_id AS type_id_13, b0_.created_by_id AS created_by_id_14 FROM blog b0_ WHERE b0_.is_active = ? ORDER BY b0_.id DESC LIMIT 3"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1093
    +name: "BOOLEAN"
  }
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.img AS img_3, b0_.path AS path_4, b0_.alt AS alt_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.date AS date_8, b0_.slug AS slug_9, b0_.is_active AS is_active_10, b0_.markup_title AS markup_title_11, b0_.meta AS meta_12, b0_.type_id AS type_id_13, b0_.created_by_id AS created_by_id_14 FROM blog b0_ WHERE b0_.is_active = ? ORDER BY b0_.id DESC LIMIT 3"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1093
      +name: "BOOLEAN"
    }
  ]
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM faq t0"

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM faq t0"
]

"SELECT h0_.id AS id_0, h0_.img AS img_1, h0_.path AS path_2, h0_.title AS title_3, h0_.year AS year_4, h0_.description AS description_5, h0_.position AS position_6 FROM history h0_ ORDER BY h0_.position ASC"

[
  "sql" => "SELECT h0_.id AS id_0, h0_.img AS img_1, h0_.path AS path_2, h0_.title AS title_3, h0_.year AS year_4, h0_.description AS description_5, h0_.position AS position_6 FROM history h0_ ORDER BY h0_.position ASC"
]

"SELECT t0.id AS id_1, t0.img AS img_2, t0.path AS path_3 FROM partners t0"

[
  "sql" => "SELECT t0.id AS id_1, t0.img AS img_2, t0.path AS path_3 FROM partners t0"
]

"SELECT COUNT(*) FROM renter t0"

[
  "sql" => "SELECT COUNT(*) FROM renter t0"
]

"SELECT COUNT(*) FROM professionnal_owner t0"

[
  "sql" => "SELECT COUNT(*) FROM professionnal_owner t0"
]

"SELECT COUNT(*) FROM private_owner t0"

[
  "sql" => "SELECT COUNT(*) FROM private_owner t0"
]

"SELECT COUNT(*) FROM partners t0"

[
  "sql" => "SELECT COUNT(*) FROM partners t0"
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4 FROM categories t0 WHERE t0.slug = ? LIMIT 1"

[
  1 => "qui-sommes-nous"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4 FROM categories t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "qui-sommes-nous"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1090
      +name: "STRING"
    }
  ]
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4 FROM categories t0 WHERE t0.slug = ? LIMIT 1"

[
  1 => "pourquoi-serenia"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4 FROM categories t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "pourquoi-serenia"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1090
      +name: "STRING"
    }
  ]
]

"SELECT t0.id AS id_1, t0.content AS content_2, t0.categories_id AS categories_id_3 FROM page_content t0 WHERE t0.categories_id = ? LIMIT 1"

[
  1 => 8
]

[
  1 => Doctrine\DBAL\ParameterType {#1091
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.categories_id AS categories_id_3 FROM page_content t0 WHERE t0.categories_id = ? LIMIT 1"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1091
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.content AS content_2, t0.categories_id AS categories_id_3 FROM page_content t0 WHERE t0.categories_id = ? LIMIT 1"

[
  1 => 9
]

[
  1 => Doctrine\DBAL\ParameterType {#1091
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.categories_id AS categories_id_3 FROM page_content t0 WHERE t0.categories_id = ? LIMIT 1"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1091
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.item AS item_2, t0.code AS code_3, t0.adventure_id AS adventure_id_4 FROM features t0 WHERE t0.adventure_id = ?"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1091
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.item AS item_2, t0.code AS code_3, t0.adventure_id AS adventure_id_4 FROM features t0 WHERE t0.adventure_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1091
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.item AS item_2, t0.code AS code_3, t0.adventure_id AS adventure_id_4 FROM features t0 WHERE t0.adventure_id = ?"

[
  1 => 2
]

[
  1 => Doctrine\DBAL\ParameterType {#1091
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.item AS item_2, t0.code AS code_3, t0.adventure_id AS adventure_id_4 FROM features t0 WHERE t0.adventure_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1091
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.item AS item_2, t0.code AS code_3, t0.adventure_id AS adventure_id_4 FROM features t0 WHERE t0.adventure_id = ?"

[
  1 => 3
]

[
  1 => Doctrine\DBAL\ParameterType {#1091
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.item AS item_2, t0.code AS code_3, t0.adventure_id AS adventure_id_4 FROM features t0 WHERE t0.adventure_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1091
      +name: "INTEGER"
    }
  ]
]

"SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.content AS content_2, f0_.slug AS slug_3, f0_.is_active AS is_active_4 FROM footer f0_ WHERE f0_.is_active = ? ORDER BY f0_.id ASC"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1093
    +name: "BOOLEAN"
  }
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.content AS content_2, f0_.slug AS slug_3, f0_.is_active AS is_active_4 FROM footer f0_ WHERE f0_.is_active = ? ORDER BY f0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1093
      +name: "BOOLEAN"
    }
  ]
]