Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_main AS is_main_4,
  t0.image_id AS image_id_5,
  t6.id AS id_7,
  t6.alt AS alt_8,
  t6.file_name AS file_name_9,
  t6.dimensions AS dimensions_10,
  t6.updated_at AS updated_at_11
FROM
  language t0
  LEFT JOIN language_image t6 ON t0.image_id = t6.id
WHERE
  t0.is_main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.is_main = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_main AS is_main_4,
  t0.image_id AS image_id_5,
  t6.id AS id_7,
  t6.alt AS alt_8,
  t6.file_name AS file_name_9,
  t6.dimensions AS dimensions_10,
  t6.updated_at AS updated_at_11
FROM
  language t0
  LEFT JOIN language_image t6 ON t0.image_id = t6.id
WHERE
  t0.is_main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.is_main = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_main AS is_main_4,
  t0.image_id AS image_id_5,
  t6.id AS id_7,
  t6.alt AS alt_8,
  t6.file_name AS file_name_9,
  t6.dimensions AS dimensions_10,
  t6.updated_at AS updated_at_11
FROM
  language t0
  LEFT JOIN language_image t6 ON t0.image_id = t6.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.created_at AS created_at_3,
  t0.title_id AS title_id_4,
  t0.subtitle_id AS subtitle_id_5,
  t0.process_section_title_id AS process_section_title_id_6,
  t0.process_section_subtitle_id AS process_section_subtitle_id_7,
  t0.popular_dest_section_title_id AS popular_dest_section_title_id_8,
  t0.popular_dest_section_subtitle_id AS popular_dest_section_subtitle_id_9,
  t0.why_section_title_id AS why_section_title_id_10,
  t0.why_section_subtitle_id AS why_section_subtitle_id_11,
  t0.faq_section_title_id AS faq_section_title_id_12,
  t0.register_section_title_id AS register_section_title_id_13,
  t0.register_section_subtitle_id AS register_section_subtitle_id_14,
  t0.seo_id AS seo_id_15
FROM
  home_page t0
LIMIT
  1

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.title_id AS title_id_4, t0.subtitle_id AS subtitle_id_5, t0.process_section_title_id AS process_section_title_id_6, t0.process_section_subtitle_id AS process_section_subtitle_id_7, t0.popular_dest_section_title_id AS popular_dest_section_title_id_8, t0.popular_dest_section_subtitle_id AS popular_dest_section_subtitle_id_9, t0.why_section_title_id AS why_section_title_id_10, t0.why_section_subtitle_id AS why_section_subtitle_id_11, t0.faq_section_title_id AS faq_section_title_id_12, t0.register_section_title_id AS register_section_title_id_13, t0.register_section_subtitle_id AS register_section_subtitle_id_14, t0.seo_id AS seo_id_15 FROM home_page t0 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.updated_at AS updated_at_2,
  p0_.enabled AS enabled_3,
  p0_.publication_start_date AS publication_start_date_4,
  p0_.publication_end_date AS publication_end_date_5,
  p0_.is_nav_back_button_enabled AS is_nav_back_button_enabled_6,
  p0_.title_id AS title_id_7,
  p0_.slug_id AS slug_id_8,
  p0_.template_id AS template_id_9,
  p0_.internal_template_id AS internal_template_id_10,
  p0_.article_template_id AS article_template_id_11,
  p0_.list_articles_template_id AS list_articles_template_id_12,
  p0_.switch_home_template_id AS switch_home_template_id_13,
  p0_.switch_home_location_template_id AS switch_home_location_template_id_14,
  p0_.seo_id AS seo_id_15,
  p0_.contact_template_id AS contact_template_id_16,
  p0_.sitemap_template_id AS sitemap_template_id_17,
  p0_.landing_template_id AS landing_template_id_18,
  p0_.nav_back_button_title_id AS nav_back_button_title_id_19,
  p0_.nav_back_button_page_id AS nav_back_button_page_id_20,
  p0_.parent_id AS parent_id_21
FROM
  page p0_
  INNER JOIN seo s1_ ON p0_.seo_id = s1_.id
WHERE
  p0_.enabled = 1
  AND s1_.hide_on_sitemap = 0

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.enabled AS enabled_3, p0_.publication_start_date AS publication_start_date_4, p0_.publication_end_date AS publication_end_date_5, p0_.is_nav_back_button_enabled AS is_nav_back_button_enabled_6, p0_.title_id AS title_id_7, p0_.slug_id AS slug_id_8, p0_.template_id AS template_id_9, p0_.internal_template_id AS internal_template_id_10, p0_.article_template_id AS article_template_id_11, p0_.list_articles_template_id AS list_articles_template_id_12, p0_.switch_home_template_id AS switch_home_template_id_13, p0_.switch_home_location_template_id AS switch_home_location_template_id_14, p0_.seo_id AS seo_id_15, p0_.contact_template_id AS contact_template_id_16, p0_.sitemap_template_id AS sitemap_template_id_17, p0_.landing_template_id AS landing_template_id_18, p0_.nav_back_button_title_id AS nav_back_button_title_id_19, p0_.nav_back_button_page_id AS nav_back_button_page_id_20, p0_.parent_id AS parent_id_21 FROM page p0_ INNER JOIN seo s1_ ON p0_.seo_id = s1_.id WHERE p0_.enabled = 1 AND s1_.hide_on_sitemap = 0;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.enabled AS enabled_4,
  t0.publication_start_date AS publication_start_date_5,
  t0.publication_end_date AS publication_end_date_6,
  t0.is_nav_back_button_enabled AS is_nav_back_button_enabled_7,
  t0.title_id AS title_id_8,
  t0.slug_id AS slug_id_9,
  t0.template_id AS template_id_10,
  t0.internal_template_id AS internal_template_id_11,
  t0.article_template_id AS article_template_id_12,
  t0.list_articles_template_id AS list_articles_template_id_13,
  t0.switch_home_template_id AS switch_home_template_id_14,
  t0.switch_home_location_template_id AS switch_home_location_template_id_15,
  t0.seo_id AS seo_id_16,
  t0.contact_template_id AS contact_template_id_17,
  t0.sitemap_template_id AS sitemap_template_id_18,
  t0.landing_template_id AS landing_template_id_19,
  t0.nav_back_button_title_id AS nav_back_button_title_id_20,
  t0.nav_back_button_page_id AS nav_back_button_page_id_21,
  t22.id AS id_23,
  t22.created_at AS created_at_24,
  t22.updated_at AS updated_at_25,
  t22.enabled AS enabled_26,
  t22.publication_start_date AS publication_start_date_27,
  t22.publication_end_date AS publication_end_date_28,
  t22.is_nav_back_button_enabled AS is_nav_back_button_enabled_29,
  t22.title_id AS title_id_30,
  t22.slug_id AS slug_id_31,
  t22.template_id AS template_id_32,
  t22.internal_template_id AS internal_template_id_33,
  t22.article_template_id AS article_template_id_34,
  t22.list_articles_template_id AS list_articles_template_id_35,
  t22.switch_home_template_id AS switch_home_template_id_36,
  t22.switch_home_location_template_id AS switch_home_location_template_id_37,
  t22.seo_id AS seo_id_38,
  t22.contact_template_id AS contact_template_id_39,
  t22.sitemap_template_id AS sitemap_template_id_40,
  t22.landing_template_id AS landing_template_id_41,
  t22.nav_back_button_title_id AS nav_back_button_title_id_42,
  t22.nav_back_button_page_id AS nav_back_button_page_id_43,
  t22.parent_id AS parent_id_44,
  t0.parent_id AS parent_id_45
FROM
  page t0
  LEFT JOIN page t22 ON t0.nav_back_button_page_id = t22.id
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.publication_start_date AS publication_start_date_5, t0.publication_end_date AS publication_end_date_6, t0.is_nav_back_button_enabled AS is_nav_back_button_enabled_7, t0.title_id AS title_id_8, t0.slug_id AS slug_id_9, t0.template_id AS template_id_10, t0.internal_template_id AS internal_template_id_11, t0.article_template_id AS article_template_id_12, t0.list_articles_template_id AS list_articles_template_id_13, t0.switch_home_template_id AS switch_home_template_id_14, t0.switch_home_location_template_id AS switch_home_location_template_id_15, t0.seo_id AS seo_id_16, t0.contact_template_id AS contact_template_id_17, t0.sitemap_template_id AS sitemap_template_id_18, t0.landing_template_id AS landing_template_id_19, t0.nav_back_button_title_id AS nav_back_button_title_id_20, t0.nav_back_button_page_id AS nav_back_button_page_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.enabled AS enabled_26, t22.publication_start_date AS publication_start_date_27, t22.publication_end_date AS publication_end_date_28, t22.is_nav_back_button_enabled AS is_nav_back_button_enabled_29, t22.title_id AS title_id_30, t22.slug_id AS slug_id_31, t22.template_id AS template_id_32, t22.internal_template_id AS internal_template_id_33, t22.article_template_id AS article_template_id_34, t22.list_articles_template_id AS list_articles_template_id_35, t22.switch_home_template_id AS switch_home_template_id_36, t22.switch_home_location_template_id AS switch_home_location_template_id_37, t22.seo_id AS seo_id_38, t22.contact_template_id AS contact_template_id_39, t22.sitemap_template_id AS sitemap_template_id_40, t22.landing_template_id AS landing_template_id_41, t22.nav_back_button_title_id AS nav_back_button_title_id_42, t22.nav_back_button_page_id AS nav_back_button_page_id_43, t22.parent_id AS parent_id_44, t0.parent_id AS parent_id_45 FROM page t0 LEFT JOIN page t22 ON t0.nav_back_button_page_id = t22.id WHERE t0.parent_id IN (1, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92);

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.keyname AS keyname_3
FROM
  template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.keyname AS keyname_3 FROM template t0 WHERE t0.id = 3;

SELECT
  n0_.id AS id_0,
  n0_.redirection_type AS redirection_type_1,
  n0_.redirection_video AS redirection_video_2,
  n0_.created_at AS created_at_3,
  n0_.updated_at AS updated_at_4,
  n0_.position AS position_5,
  n0_.format AS format_6,
  n0_.background_class AS background_class_7,
  n0_.page_id AS page_id_8,
  n0_.title_id AS title_id_9,
  n0_.redirection_link_id AS redirection_link_id_10,
  n0_.redirection_page_id AS redirection_page_id_11,
  n0_.nav_id AS nav_id_12,
  n0_.sub_nav_id AS sub_nav_id_13
FROM
  nav_link n0_
WHERE
  n0_.redirection_page_id = ?
  AND n0_.sub_nav_id IS NOT NULL

SELECT n0_.id AS id_0, n0_.redirection_type AS redirection_type_1, n0_.redirection_video AS redirection_video_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.position AS position_5, n0_.format AS format_6, n0_.background_class AS background_class_7, n0_.page_id AS page_id_8, n0_.title_id AS title_id_9, n0_.redirection_link_id AS redirection_link_id_10, n0_.redirection_page_id AS redirection_page_id_11, n0_.nav_id AS nav_id_12, n0_.sub_nav_id AS sub_nav_id_13 FROM nav_link n0_ WHERE n0_.redirection_page_id = 1 AND n0_.sub_nav_id IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.entity_class AS entity_class_2,
  t0.entity_id AS entity_id_3,
  t0.field_name AS field_name_4
FROM
  text_content t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.translated_text AS translated_text_2,
  t0.language_id AS language_id_3,
  t0.text_content_id AS text_content_id_4
FROM
  translation t0
WHERE
  (
    t0.language_id = ?
    AND t0.text_content_id = ?
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE (t0.language_id = 1 AND t0.text_content_id = 6) LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.redirection_type AS redirection_type_1,
  n0_.redirection_video AS redirection_video_2,
  n0_.created_at AS created_at_3,
  n0_.updated_at AS updated_at_4,
  n0_.position AS position_5,
  n0_.format AS format_6,
  n0_.background_class AS background_class_7,
  n0_.page_id AS page_id_8,
  n0_.title_id AS title_id_9,
  n0_.redirection_link_id AS redirection_link_id_10,
  n0_.redirection_page_id AS redirection_page_id_11,
  n0_.nav_id AS nav_id_12,
  n0_.sub_nav_id AS sub_nav_id_13
FROM
  nav_link n0_
  LEFT JOIN nav n1_ ON n0_.nav_id = n1_.id
WHERE
  n0_.redirection_page_id = ?
  AND n1_.enabled = 1

SELECT n0_.id AS id_0, n0_.redirection_type AS redirection_type_1, n0_.redirection_video AS redirection_video_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.position AS position_5, n0_.format AS format_6, n0_.background_class AS background_class_7, n0_.page_id AS page_id_8, n0_.title_id AS title_id_9, n0_.redirection_link_id AS redirection_link_id_10, n0_.redirection_page_id AS redirection_page_id_11, n0_.nav_id AS nav_id_12, n0_.sub_nav_id AS sub_nav_id_13 FROM nav_link n0_ LEFT JOIN nav n1_ ON n0_.nav_id = n1_.id WHERE n0_.redirection_page_id = 1 AND n1_.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.translated_text AS translated_text_2,
  t0.language_id AS language_id_3,
  t0.text_content_id AS text_content_id_4
FROM
  translation t0
WHERE
  t0.text_content_id = ?

SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE t0.text_content_id = 6;

SELECT
  n0_.id AS id_0,
  n0_.redirection_type AS redirection_type_1,
  n0_.redirection_video AS redirection_video_2,
  n0_.created_at AS created_at_3,
  n0_.updated_at AS updated_at_4,
  n0_.position AS position_5,
  n0_.format AS format_6,
  n0_.background_class AS background_class_7,
  n0_.page_id AS page_id_8,
  n0_.title_id AS title_id_9,
  n0_.redirection_link_id AS redirection_link_id_10,
  n0_.redirection_page_id AS redirection_page_id_11,
  n0_.nav_id AS nav_id_12,
  n0_.sub_nav_id AS sub_nav_id_13
FROM
  nav_link n0_
WHERE
  n0_.redirection_page_id = ?
  AND n0_.sub_nav_id IS NOT NULL

SELECT n0_.id AS id_0, n0_.redirection_type AS redirection_type_1, n0_.redirection_video AS redirection_video_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.position AS position_5, n0_.format AS format_6, n0_.background_class AS background_class_7, n0_.page_id AS page_id_8, n0_.title_id AS title_id_9, n0_.redirection_link_id AS redirection_link_id_10, n0_.redirection_page_id AS redirection_page_id_11, n0_.nav_id AS nav_id_12, n0_.sub_nav_id AS sub_nav_id_13 FROM nav_link n0_ WHERE n0_.redirection_page_id = 1 AND n0_.sub_nav_id IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.keyname AS keyname_3
FROM
  template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.keyname AS keyname_3 FROM template t0 WHERE t0.id = 2;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.updated_at AS updated_at_2,
  p0_.enabled AS enabled_3,
  p0_.publication_start_date AS publication_start_date_4,
  p0_.publication_end_date AS publication_end_date_5,
  p0_.is_nav_back_button_enabled AS is_nav_back_button_enabled_6,
  p0_.title_id AS title_id_7,
  p0_.slug_id AS slug_id_8,
  p0_.template_id AS template_id_9,
  p0_.internal_template_id AS internal_template_id_10,
  p0_.article_template_id AS article_template_id_11,
  p0_.list_articles_template_id AS list_articles_template_id_12,
  p0_.switch_home_template_id AS switch_home_template_id_13,
  p0_.switch_home_location_template_id AS switch_home_location_template_id_14,
  p0_.seo_id AS seo_id_15,
  p0_.contact_template_id AS contact_template_id_16,
  p0_.sitemap_template_id AS sitemap_template_id_17,
  p0_.landing_template_id AS landing_template_id_18,
  p0_.nav_back_button_title_id AS nav_back_button_title_id_19,
  p0_.nav_back_button_page_id AS nav_back_button_page_id_20,
  p0_.parent_id AS parent_id_21
FROM
  page p0_
WHERE
  p0_.list_articles_template_id IS NOT NULL
  AND p0_.enabled = ?

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.enabled AS enabled_3, p0_.publication_start_date AS publication_start_date_4, p0_.publication_end_date AS publication_end_date_5, p0_.is_nav_back_button_enabled AS is_nav_back_button_enabled_6, p0_.title_id AS title_id_7, p0_.slug_id AS slug_id_8, p0_.template_id AS template_id_9, p0_.internal_template_id AS internal_template_id_10, p0_.article_template_id AS article_template_id_11, p0_.list_articles_template_id AS list_articles_template_id_12, p0_.switch_home_template_id AS switch_home_template_id_13, p0_.switch_home_location_template_id AS switch_home_location_template_id_14, p0_.seo_id AS seo_id_15, p0_.contact_template_id AS contact_template_id_16, p0_.sitemap_template_id AS sitemap_template_id_17, p0_.landing_template_id AS landing_template_id_18, p0_.nav_back_button_title_id AS nav_back_button_title_id_19, p0_.nav_back_button_page_id AS nav_back_button_page_id_20, p0_.parent_id AS parent_id_21 FROM page p0_ WHERE p0_.list_articles_template_id IS NOT NULL AND p0_.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.entity_class AS entity_class_2,
  t0.entity_id AS entity_id_3,
  t0.field_name AS field_name_4
FROM
  text_content t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.entity_class AS entity_class_2, t0.entity_id AS entity_id_3, t0.field_name AS field_name_4 FROM text_content t0 WHERE t0.id = 249;

SELECT
  t0.id AS id_1,
  t0.translated_text AS translated_text_2,
  t0.language_id AS language_id_3,
  t0.text_content_id AS text_content_id_4
FROM
  translation t0
WHERE
  (
    t0.language_id = ?
    AND t0.text_content_id = ?
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE (t0.language_id = 1 AND t0.text_content_id = 249) LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.redirection_type AS redirection_type_1,
  n0_.redirection_video AS redirection_video_2,
  n0_.created_at AS created_at_3,
  n0_.updated_at AS updated_at_4,
  n0_.position AS position_5,
  n0_.format AS format_6,
  n0_.background_class AS background_class_7,
  n0_.page_id AS page_id_8,
  n0_.title_id AS title_id_9,
  n0_.redirection_link_id AS redirection_link_id_10,
  n0_.redirection_page_id AS redirection_page_id_11,
  n0_.nav_id AS nav_id_12,
  n0_.sub_nav_id AS sub_nav_id_13
FROM
  nav_link n0_
  LEFT JOIN nav n1_ ON n0_.nav_id = n1_.id
WHERE
  n0_.redirection_page_id = ?
  AND n1_.enabled = 1

SELECT n0_.id AS id_0, n0_.redirection_type AS redirection_type_1, n0_.redirection_video AS redirection_video_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.position AS position_5, n0_.format AS format_6, n0_.background_class AS background_class_7, n0_.page_id AS page_id_8, n0_.title_id AS title_id_9, n0_.redirection_link_id AS redirection_link_id_10, n0_.redirection_page_id AS redirection_page_id_11, n0_.nav_id AS nav_id_12, n0_.sub_nav_id AS sub_nav_id_13 FROM nav_link n0_ LEFT JOIN nav n1_ ON n0_.nav_id = n1_.id WHERE n0_.redirection_page_id = 13 AND n1_.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.created_at AS created_at_3,
  t0.publication_date AS publication_date_4,
  t0.title_id AS title_id_5,
  t0.image_id AS image_id_6,
  t0.template_id AS template_id_7,
  t8.id AS id_9,
  t8.created_at AS created_at_10,
  t8.updated_at AS updated_at_11,
  t8.enabled AS enabled_12,
  t8.publication_start_date AS publication_start_date_13,
  t8.publication_end_date AS publication_end_date_14,
  t8.is_nav_back_button_enabled AS is_nav_back_button_enabled_15,
  t8.title_id AS title_id_16,
  t8.slug_id AS slug_id_17,
  t8.template_id AS template_id_18,
  t8.internal_template_id AS internal_template_id_19,
  t8.article_template_id AS article_template_id_20,
  t8.list_articles_template_id AS list_articles_template_id_21,
  t8.switch_home_template_id AS switch_home_template_id_22,
  t8.switch_home_location_template_id AS switch_home_location_template_id_23,
  t8.seo_id AS seo_id_24,
  t8.contact_template_id AS contact_template_id_25,
  t8.sitemap_template_id AS sitemap_template_id_26,
  t8.landing_template_id AS landing_template_id_27,
  t8.nav_back_button_title_id AS nav_back_button_title_id_28,
  t8.nav_back_button_page_id AS nav_back_button_page_id_29,
  t8.parent_id AS parent_id_30
FROM
  article_template t0
  LEFT JOIN page t8 ON t8.article_template_id = t0.id
WHERE
  t0.id = ?