Symfony Profiler

[
  "route" => "app_home_index"
  "route_parameters" => [
    "_route" => "app_home_index"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://137.74.44.182/"
  "method" => "GET"
]

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "dev_mhconseilhse"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dev_db_mh_conseil_hse"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.icon AS icon_2, a0_.position AS position_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5 FROM advantages a0_ ORDER BY a0_.position ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.internal_slug AS internal_slug_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.og_title AS og_title_5, t0.og_description AS og_description_6, t0.og_image AS og_image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM seo_page t0 WHERE t0.internal_slug = ? LIMIT 1"
  "params" => [
    1 => "home"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#959
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM home_about t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.button1 AS button1_4, t0.button_link1 AS button_link1_5, t0.button_style1 AS button_style1_6, t0.button2 AS button2_7, t0.button_link2 AS button_link2_8, t0.button_style2 AS button_style2_9, t0.description AS description_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM hero t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.img AS img_2, t0.description AS description_3, t0.seo AS seo_4, t0.path AS path_5 FROM qui_suis_je t0"
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.icon AS icon_2, m0_.color AS color_3, m0_.link AS link_4, m0_.position AS position_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.content AS content_8 FROM methodology m0_ ORDER BY m0_.position ASC"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.img AS img_2, t0_.seo AS seo_3, t0_.description AS description_4, t0_.path AS path_5, t0_.is_active AS is_active_6 FROM testimonials t0_ WHERE t0_.is_active = ? ORDER BY t0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.icon AS icon_3, s0_.button AS button_4, s0_.button_link AS button_link_5, s0_.position AS position_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.img AS img_9, s0_.path AS path_10, s0_.seo AS seo_11 FROM services s0_ ORDER BY s0_.position ASC"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.img AS img_2, a0_.seo AS seo_3, a0_.description AS description_4, a0_.button AS button_5, a0_.slug AS slug_6, a0_.path AS path_7, a0_.position AS position_8, a0_.meta AS meta_9, a0_.is_active AS is_active_10 FROM analyses_risques a0_ WHERE a0_.is_active = ? ORDER BY a0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.img AS img_2, a0_.seo AS seo_3, a0_.description AS description_4, a0_.button AS button_5, a0_.slug AS slug_6, a0_.path AS path_7, a0_.position AS position_8, a0_.meta AS meta_9, a0_.is_active AS is_active_10 FROM audit_incendie a0_ WHERE a0_.is_active = ? ORDER BY a0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.is_active AS is_active_3 FROM type t0_ WHERE t0_.is_active = ? ORDER BY t0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.seo AS seo_4, t0.description AS description_5, t0.slug AS slug_6, t0.path AS path_7, t0.position AS position_8, t0.meta AS meta_9, t0.is_active AS is_active_10, t0.type_id AS type_id_11 FROM formations t0 WHERE t0.type_id = ? AND t0.is_active = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.seo AS seo_4, t0.description AS description_5, t0.slug AS slug_6, t0.path AS path_7, t0.position AS position_8, t0.meta AS meta_9, t0.is_active AS is_active_10, t0.type_id AS type_id_11 FROM formations t0 WHERE t0.type_id = ? AND t0.is_active = ?"
  "params" => [
    1 => 2
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1192
      +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 {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.img AS img_2, a0_.seo AS seo_3, a0_.description AS description_4, a0_.button AS button_5, a0_.slug AS slug_6, a0_.path AS path_7, a0_.position AS position_8, a0_.meta AS meta_9, a0_.is_active AS is_active_10 FROM analyses_risques a0_ WHERE a0_.is_active = ? ORDER BY a0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.img AS img_2, a0_.seo AS seo_3, a0_.description AS description_4, a0_.button AS button_5, a0_.slug AS slug_6, a0_.path AS path_7, a0_.position AS position_8, a0_.meta AS meta_9, a0_.is_active AS is_active_10 FROM audit_incendie a0_ WHERE a0_.is_active = ? ORDER BY a0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.is_active AS is_active_3 FROM type t0_ WHERE t0_.is_active = ? ORDER BY t0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.seo AS seo_4, t0.description AS description_5, t0.slug AS slug_6, t0.path AS path_7, t0.position AS position_8, t0.meta AS meta_9, t0.is_active AS is_active_10, t0.type_id AS type_id_11 FROM formations t0 WHERE t0.type_id = ? AND t0.is_active = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.seo AS seo_4, t0.description AS description_5, t0.slug AS slug_6, t0.path AS path_7, t0.position AS position_8, t0.meta AS meta_9, t0.is_active AS is_active_10, t0.type_id AS type_id_11 FROM formations t0 WHERE t0.type_id = ? AND t0.is_active = ?"
  "params" => [
    1 => 2
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.link AS link_2, r0_.slug AS slug_3, r0_.is_active AS is_active_4 FROM ressources r0_ WHERE r0_.is_active = ? ORDER BY r0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1192
      +name: "BOOLEAN"
    }
  ]
]