Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.highlight_disclaimer AS highlight_disclaimer_2,
  t0.resources_main_cta AS resources_main_cta_3,
  t0.resources_main_cta_text AS resources_main_cta_text_4,
  t0.subtitle AS subtitle_5,
  t0.resource_date AS resource_date_6,
  t0.brief_description AS brief_description_7,
  t0.embedded_video AS embedded_video_8,
  t0.embedded_video_text AS embedded_video_text_9,
  t0.full_description AS full_description_10,
  t0.secondary_external_links AS secondary_external_links_11,
  t0.autor_source AS autor_source_12,
  t0.publication_date AS publication_date_13,
  t0.original_publication_year AS original_publication_year_14,
  t0.publication_type AS publication_type_15,
  t0.spatial_scale AS spatial_scale_16,
  t0.type_of_tool AS type_of_tool_17,
  t0.license AS license_18,
  t0.license_extra AS license_extra_19,
  t0.project_id AS project_id_20,
  t0.website AS website_21,
  t0.degradation_driver AS degradation_driver_22,
  t0.context AS context_23,
  t0.problem_description AS problem_description_24,
  t0.implementation_steps AS implementation_steps_25,
  t0.stakeholder_engagement AS stakeholder_engagement_26,
  t0.knowledge_types AS knowledge_types_27,
  t0.scale_area AS scale_area_28,
  t0.replicability AS replicability_29,
  t0.replicability_details AS replicability_details_30,
  t0.key_success_factors AS key_success_factors_31,
  t0.common_constraints AS common_constraints_32,
  t0.lessons_learnt AS lessons_learnt_33,
  t0.positive_impact_explanation AS positive_impact_explanation_34,
  t0.negative_impact_explanation AS negative_impact_explanation_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.title AS title_38,
  t0.slug AS slug_39,
  t0.language AS language_40,
  t0.original_language AS original_language_41,
  t0.status AS status_42,
  t0.locked_at AS locked_at_43,
  t0.frg_resource_content_type_id AS frg_resource_content_type_id_44,
  t0.image_id AS image_id_45,
  t0.resources_Main_cta_internal_id AS resources_Main_cta_internal_id_46,
  t0.created_by_id AS created_by_id_47,
  t0.modified_by_id AS modified_by_id_48,
  t0.locked_by_id AS locked_by_id_49
FROM
  frg_resource t0
WHERE
  t0.slug = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.highlight_disclaimer AS highlight_disclaimer_2, t0.resources_main_cta AS resources_main_cta_3, t0.resources_main_cta_text AS resources_main_cta_text_4, t0.subtitle AS subtitle_5, t0.resource_date AS resource_date_6, t0.brief_description AS brief_description_7, t0.embedded_video AS embedded_video_8, t0.embedded_video_text AS embedded_video_text_9, t0.full_description AS full_description_10, t0.secondary_external_links AS secondary_external_links_11, t0.autor_source AS autor_source_12, t0.publication_date AS publication_date_13, t0.original_publication_year AS original_publication_year_14, t0.publication_type AS publication_type_15, t0.spatial_scale AS spatial_scale_16, t0.type_of_tool AS type_of_tool_17, t0.license AS license_18, t0.license_extra AS license_extra_19, t0.project_id AS project_id_20, t0.website AS website_21, t0.degradation_driver AS degradation_driver_22, t0.context AS context_23, t0.problem_description AS problem_description_24, t0.implementation_steps AS implementation_steps_25, t0.stakeholder_engagement AS stakeholder_engagement_26, t0.knowledge_types AS knowledge_types_27, t0.scale_area AS scale_area_28, t0.replicability AS replicability_29, t0.replicability_details AS replicability_details_30, t0.key_success_factors AS key_success_factors_31, t0.common_constraints AS common_constraints_32, t0.lessons_learnt AS lessons_learnt_33, t0.positive_impact_explanation AS positive_impact_explanation_34, t0.negative_impact_explanation AS negative_impact_explanation_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.title AS title_38, t0.slug AS slug_39, t0.language AS language_40, t0.original_language AS original_language_41, t0.status AS status_42, t0.locked_at AS locked_at_43, t0.frg_resource_content_type_id AS frg_resource_content_type_id_44, t0.image_id AS image_id_45, t0.resources_Main_cta_internal_id AS resources_Main_cta_internal_id_46, t0.created_by_id AS created_by_id_47, t0.modified_by_id AS modified_by_id_48, t0.locked_by_id AS locked_by_id_49 FROM frg_resource t0 WHERE t0.slug = 'assessment-of-initial-success-and-restoration-efforts' AND t0.status = 'PUBLISHED' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id IS NULL
  AND t0.menu_active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id IS NULL AND t0.menu_active = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = 3;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = 3883;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = 3886;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = 3885;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.language AS language_3,
  t0.original_language AS original_language_4,
  t0.original_menu_id AS original_menu_id_5,
  t0.route AS route_6,
  t0.link AS link_7,
  t0.icon AS icon_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.parent_id AS parent_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.modified_by_id AS modified_by_id_17
FROM
  frg_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = 3884;

SELECT
  f0_.id AS id_0,
  f0_.original_id AS original_id_1,
  f0_.short_description AS short_description_2,
  f0_.introduction AS introduction_3,
  f0_.created_at AS created_at_4,
  f0_.updated_at AS updated_at_5,
  f0_.title AS title_6,
  f0_.slug AS slug_7,
  f0_.language AS language_8,
  f0_.original_language AS original_language_9,
  f0_.position AS position_10,
  f0_.menu_level AS menu_level_11,
  f0_.menu_index AS menu_index_12,
  f0_.menu_active AS menu_active_13,
  f0_.status AS status_14,
  f0_.parent_id AS parent_id_15,
  f0_.image_id AS image_id_16,
  f0_.created_by_id AS created_by_id_17,
  f0_.modified_by_id AS modified_by_id_18
FROM
  frg_guidelines f0_
WHERE
  f0_.parent_id IS NULL
  AND f0_.status IN (?)
ORDER BY
  f0_.menu_index ASC

SELECT f0_.id AS id_0, f0_.original_id AS original_id_1, f0_.short_description AS short_description_2, f0_.introduction AS introduction_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.title AS title_6, f0_.slug AS slug_7, f0_.language AS language_8, f0_.original_language AS original_language_9, f0_.position AS position_10, f0_.menu_level AS menu_level_11, f0_.menu_index AS menu_index_12, f0_.menu_active AS menu_active_13, f0_.status AS status_14, f0_.parent_id AS parent_id_15, f0_.image_id AS image_id_16, f0_.created_by_id AS created_by_id_17, f0_.modified_by_id AS modified_by_id_18 FROM frg_guidelines f0_ WHERE f0_.parent_id IS NULL AND f0_.status IN ('PUBLISHED') ORDER BY f0_.menu_index ASC;

SELECT
  t0.id AS id_1,
  t0.original_id AS original_id_2,
  t0.short_description AS short_description_3,
  t0.introduction AS introduction_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.language AS language_9,
  t0.original_language AS original_language_10,
  t0.position AS position_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.status AS status_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.modified_by_id AS modified_by_id_19
FROM
  frg_guidelines t0
WHERE
  t0.parent_id IN (?, ?, ?)

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (7, 66, 67);

SELECT
  t0.id AS id_1,
  t0.original_id AS original_id_2,
  t0.short_description AS short_description_3,
  t0.introduction AS introduction_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.language AS language_9,
  t0.original_language AS original_language_10,
  t0.position AS position_11,
  t0.menu_level AS menu_level_12,
  t0.menu_index AS menu_index_13,
  t0.menu_active AS menu_active_14,
  t0.status AS status_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.modified_by_id AS modified_by_id_19
FROM
  frg_guidelines t0
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (8, 10, 11, 12, 13, 16, 17, 18, 19, 20, 21, 108, 110, 115, 120, 68, 73, 79);