Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.public_id AS public_id_1,
  a0_.title AS title_2,
  a0_.sl_no AS sl_no_3,
  a0_.business_model AS business_model_4,
  a0_.published AS published_5,
  a0_.position AS position_6,
  s1_.id AS id_7,
  s1_.name AS name_8,
  s1_.position AS position_9,
  a2_.id AS id_10,
  a2_.in_scope AS in_scope_11,
  a2_.has_green AS has_green_12,
  a2_.has_amber AS has_amber_13,
  a2_.has_red AS has_red_14,
  a2_.tsc_heading AS tsc_heading_15,
  a2_.dnsh_statuses AS dnsh_statuses_16,
  e3_.id AS id_17,
  e3_.code AS code_18,
  e3_.name AS name_19,
  e3_.slug AS slug_20,
  e3_.short_description AS short_description_21,
  e3_.icon AS icon_22,
  e3_.tone_color AS tone_color_23,
  e3_.enabled AS enabled_24,
  e3_.position AS position_25,
  a4_.id AS id_26,
  a4_.title AS title_27,
  a4_.body AS body_28,
  a4_.position AS position_29,
  c5_.id AS id_30,
  c5_.tone AS tone_31,
  c5_.title AS title_32,
  c5_.body AS body_33,
  c5_.position AS position_34,
  a0_.sector_id AS sector_id_35,
  a2_.activity_id AS activity_id_36,
  a2_.objective_id AS objective_id_37,
  a4_.activity_objective_id AS activity_objective_id_38,
  c5_.activity_objective_id AS activity_objective_id_39
FROM
  activity a0_
  INNER JOIN sector s1_ ON a0_.sector_id = s1_.id
  INNER JOIN activity_objective a2_ ON a0_.id = a2_.activity_id
  INNER JOIN environmental_objective e3_ ON a2_.objective_id = e3_.id
  LEFT JOIN activity_detail a4_ ON a2_.id = a4_.activity_objective_id
  LEFT JOIN criterion c5_ ON a2_.id = c5_.activity_objective_id
WHERE
  a0_.public_id = ?
  AND a0_.published = 1
ORDER BY
  a4_.position ASC,
  c5_.position ASC

SELECT a0_.id AS id_0, a0_.public_id AS public_id_1, a0_.title AS title_2, a0_.sl_no AS sl_no_3, a0_.business_model AS business_model_4, a0_.published AS published_5, a0_.position AS position_6, s1_.id AS id_7, s1_.name AS name_8, s1_.position AS position_9, a2_.id AS id_10, a2_.in_scope AS in_scope_11, a2_.has_green AS has_green_12, a2_.has_amber AS has_amber_13, a2_.has_red AS has_red_14, a2_.tsc_heading AS tsc_heading_15, a2_.dnsh_statuses AS dnsh_statuses_16, e3_.id AS id_17, e3_.code AS code_18, e3_.name AS name_19, e3_.slug AS slug_20, e3_.short_description AS short_description_21, e3_.icon AS icon_22, e3_.tone_color AS tone_color_23, e3_.enabled AS enabled_24, e3_.position AS position_25, a4_.id AS id_26, a4_.title AS title_27, a4_.body AS body_28, a4_.position AS position_29, c5_.id AS id_30, c5_.tone AS tone_31, c5_.title AS title_32, c5_.body AS body_33, c5_.position AS position_34, a0_.sector_id AS sector_id_35, a2_.activity_id AS activity_id_36, a2_.objective_id AS objective_id_37, a4_.activity_objective_id AS activity_objective_id_38, c5_.activity_objective_id AS activity_objective_id_39 FROM activity a0_ INNER JOIN sector s1_ ON a0_.sector_id = s1_.id INNER JOIN activity_objective a2_ ON a0_.id = a2_.activity_id INNER JOIN environmental_objective e3_ ON a2_.objective_id = e3_.id LEFT JOIN activity_detail a4_ ON a2_.id = a4_.activity_objective_id LEFT JOIN criterion c5_ ON a2_.id = c5_.activity_objective_id WHERE a0_.public_id = 'demolition-and-wrecking-of-buildings-and-other-structures' AND a0_.published = 1 ORDER BY a4_.position ASC, c5_.position ASC;

SELECT
  t0.id AS id_1,
  t0.local_number AS local_number_2,
  t0.body AS body_3,
  t0.position AS position_4,
  t0.activity_objective_id AS activity_objective_id_5
FROM
  footnote t0
WHERE
  t0.activity_objective_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.local_number AS local_number_2, t0.body AS body_3, t0.position AS position_4, t0.activity_objective_id AS activity_objective_id_5 FROM footnote t0 WHERE t0.activity_objective_id = 375 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.objective_key AS objective_key_2,
  t0.sector_id AS sector_id_3,
  t0.pdf_document_id AS pdf_document_id_4
FROM
  dnsh_document t0
WHERE
  t0.objective_key = ?
  AND t0.sector_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.objective_key AS objective_key_2, t0.sector_id AS sector_id_3, t0.pdf_document_id AS pdf_document_id_4 FROM dnsh_document t0 WHERE t0.objective_key = 'ccm' AND t0.sector_id = 148 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.objective_key AS objective_key_2,
  t0.sector_id AS sector_id_3,
  t0.pdf_document_id AS pdf_document_id_4
FROM
  dnsh_document t0
WHERE
  t0.objective_key = ?
  AND t0.sector_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.objective_key AS objective_key_2, t0.sector_id AS sector_id_3, t0.pdf_document_id AS pdf_document_id_4 FROM dnsh_document t0 WHERE t0.objective_key = 'ccm' AND t0.sector_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.file_name AS file_name_3,
  t0.file_path AS file_path_4,
  t0.published AS published_5,
  t0.position AS position_6
FROM
  pdf_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.file_name AS file_name_3, t0.file_path AS file_path_4, t0.published AS published_5, t0.position AS position_6 FROM pdf_document t0 WHERE t0.id = 166;

SELECT
  t0.id AS id_1,
  t0.objective_key AS objective_key_2,
  t0.sector_id AS sector_id_3,
  t0.pdf_document_id AS pdf_document_id_4
FROM
  dnsh_document t0
WHERE
  t0.objective_key = ?
  AND t0.sector_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.objective_key AS objective_key_2, t0.sector_id AS sector_id_3, t0.pdf_document_id AS pdf_document_id_4 FROM dnsh_document t0 WHERE t0.objective_key = 'cca' AND t0.sector_id = 148 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.objective_key AS objective_key_2,
  t0.sector_id AS sector_id_3,
  t0.pdf_document_id AS pdf_document_id_4
FROM
  dnsh_document t0
WHERE
  t0.objective_key = ?
  AND t0.sector_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.objective_key AS objective_key_2, t0.sector_id AS sector_id_3, t0.pdf_document_id AS pdf_document_id_4 FROM dnsh_document t0 WHERE t0.objective_key = 'cca' AND t0.sector_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.file_name AS file_name_3,
  t0.file_path AS file_path_4,
  t0.published AS published_5,
  t0.position AS position_6
FROM
  pdf_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.file_name AS file_name_3, t0.file_path AS file_path_4, t0.published AS published_5, t0.position AS position_6 FROM pdf_document t0 WHERE t0.id = 167;

SELECT
  t0.id AS id_1,
  t0.objective_key AS objective_key_2,
  t0.sector_id AS sector_id_3,
  t0.pdf_document_id AS pdf_document_id_4
FROM
  dnsh_document t0
WHERE
  t0.objective_key = ?
  AND t0.sector_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.objective_key AS objective_key_2, t0.sector_id AS sector_id_3, t0.pdf_document_id AS pdf_document_id_4 FROM dnsh_document t0 WHERE t0.objective_key = 'ecosystems' AND t0.sector_id = 148 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.objective_key AS objective_key_2,
  t0.sector_id AS sector_id_3,
  t0.pdf_document_id AS pdf_document_id_4
FROM
  dnsh_document t0
WHERE
  t0.objective_key = ?
  AND t0.sector_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.objective_key AS objective_key_2, t0.sector_id AS sector_id_3, t0.pdf_document_id AS pdf_document_id_4 FROM dnsh_document t0 WHERE t0.objective_key = 'ecosystems' AND t0.sector_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.file_name AS file_name_3,
  t0.file_path AS file_path_4,
  t0.published AS published_5,
  t0.position AS position_6
FROM
  pdf_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.file_name AS file_name_3, t0.file_path AS file_path_4, t0.published AS published_5, t0.position AS position_6 FROM pdf_document t0 WHERE t0.id = 168;

SELECT
  t0.id AS id_1,
  t0.objective_key AS objective_key_2,
  t0.sector_id AS sector_id_3,
  t0.pdf_document_id AS pdf_document_id_4
FROM
  dnsh_document t0
WHERE
  t0.objective_key = ?
  AND t0.sector_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.objective_key AS objective_key_2, t0.sector_id AS sector_id_3, t0.pdf_document_id AS pdf_document_id_4 FROM dnsh_document t0 WHERE t0.objective_key = 'mss' AND t0.sector_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.file_name AS file_name_3,
  t0.file_path AS file_path_4,
  t0.published AS published_5,
  t0.position AS position_6
FROM
  pdf_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.file_name AS file_name_3, t0.file_path AS file_path_4, t0.published AS published_5, t0.position AS position_6 FROM pdf_document t0 WHERE t0.id = 188;

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

SELECT
  t0.id AS id_1,
  t0.logo_image AS logo_image_2,
  t0.hero_image AS hero_image_3,
  t0.quick_access_image AS quick_access_image_4,
  t0.footer_image AS footer_image_5
FROM
  site_setting t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.logo_image AS logo_image_2, t0.hero_image AS hero_image_3, t0.quick_access_image AS quick_access_image_4, t0.footer_image AS footer_image_5 FROM site_setting t0 ORDER BY t0.id ASC 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
  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;