Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\PageController::home"
  ]
  "request_uri" => "https://ambire.iridian.co/"
  "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" => "86.48.17.154"
    "port" => 3306
    "user" => "ambireusr"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ambire"
    "serverVersion" => "11.4.10-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC"
  "params" => [
    1 => "navbar_docs"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#992
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.badge_label AS badge_label_1, a0_.title AS title_2, a0_.body AS body_3, a0_.date AS date_4, a0_.published AS published_5, a0_.position AS position_6 FROM announcement a0_ WHERE a0_.published = 1 ORDER BY a0_.position ASC, a0_.date DESC LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content_key AS content_key_2, t0.locale AS locale_3, t0.value AS value_4 FROM content_block t0 WHERE t0.locale = ?"
  "params" => [
    1 => "en"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#992
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.code AS code_1, e0_.name AS name_2, e0_.slug AS slug_3, e0_.short_description AS short_description_4, e0_.icon AS icon_5, e0_.tone_color AS tone_color_6, e0_.enabled AS enabled_7, e0_.position AS position_8 FROM environmental_objective e0_ ORDER BY e0_.position ASC"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.number AS number_1, p0_.icon AS icon_2, p0_.title AS title_3, p0_.text AS text_4, p0_.position AS position_5 FROM process_step p0_ ORDER BY p0_.position ASC"
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC"
  "params" => [
    1 => "footer_legal"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#992
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.location AS location_1, n0_.label AS label_2, n0_.url AS url_3, n0_.published AS published_4, n0_.position AS position_5, p1_.id AS id_6, p1_.label AS label_7, p1_.file_name AS file_name_8, p1_.file_path AS file_path_9, p1_.published AS published_10, p1_.position AS position_11, n0_.pdf_document_id AS pdf_document_id_12 FROM navigation_item n0_ LEFT JOIN pdf_document p1_ ON n0_.pdf_document_id = p1_.id WHERE n0_.location = ? AND n0_.published = 1 ORDER BY n0_.position ASC"
  "params" => [
    1 => "footer_quick_links"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#992
      +name: "STRING"
    }
  ]
]