Symfony Profiler

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

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 = 'navbar_docs' AND n0_.published = 1 ORDER BY n0_.position ASC;

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

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;

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 = ?

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 = 'en';

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

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;

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

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;

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

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 = 'footer_legal' AND n0_.published = 1 ORDER BY n0_.position ASC;

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

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 = 'footer_quick_links' AND n0_.published = 1 ORDER BY n0_.position ASC;