Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.locale AS locale_1,
  s0_.name AS name_2,
  s0_.slug AS slug_3,
  s0_.stylesheet AS stylesheet_4,
  s0_.in_main_nav AS in_main_nav_5,
  s0_.is_active AS is_active_6,
  s0_.position AS position_7,
  s0_.oneliner AS oneliner_8,
  s0_.welcome_text AS welcome_text_9,
  s0_.directory AS directory_10,
  s0_.page_title AS page_title_11,
  s0_.type AS type_12,
  s0_.meta_id AS meta_id_13,
  s0_.language_link_subsite_id AS language_link_subsite_id_14
FROM
  subsite s0_
WHERE
  s0_.locale = ?
  AND s0_.slug = ?
  AND s0_.is_active = 1

SELECT s0_.id AS id_0, s0_.locale AS locale_1, s0_.name AS name_2, s0_.slug AS slug_3, s0_.stylesheet AS stylesheet_4, s0_.in_main_nav AS in_main_nav_5, s0_.is_active AS is_active_6, s0_.position AS position_7, s0_.oneliner AS oneliner_8, s0_.welcome_text AS welcome_text_9, s0_.directory AS directory_10, s0_.page_title AS page_title_11, s0_.type AS type_12, s0_.meta_id AS meta_id_13, s0_.language_link_subsite_id AS language_link_subsite_id_14 FROM subsite s0_ WHERE s0_.locale = 'fr' AND s0_.slug = 'famille' AND s0_.is_active = 1;

SELECT
  s0_.id AS id_0,
  s0_.position AS position_1,
  s0_.position_num AS position_num_2,
  s0_.title AS title_3,
  s0_.text AS text_4,
  s0_.created AS created_5,
  s0_.updated AS updated_6,
  s0_.is_active AS is_active_7,
  s0_.pub_date AS pub_date_8,
  s0_.slug AS slug_9,
  s0_.locale AS locale_10,
  s0_.subsite_id AS subsite_id_11,
  s0_.user_id AS user_id_12,
  s0_.asset_id AS asset_id_13
FROM
  subsite_module s0_
WHERE
  s0_.subsite_id = ?
  AND s0_.locale = ?
  AND s0_.position = 'CENTER'
  AND s0_.pub_date <= ?
  AND s0_.is_active = 1
ORDER BY
  s0_.position_num ASC

SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.position_num AS position_num_2, s0_.title AS title_3, s0_.text AS text_4, s0_.created AS created_5, s0_.updated AS updated_6, s0_.is_active AS is_active_7, s0_.pub_date AS pub_date_8, s0_.slug AS slug_9, s0_.locale AS locale_10, s0_.subsite_id AS subsite_id_11, s0_.user_id AS user_id_12, s0_.asset_id AS asset_id_13 FROM subsite_module s0_ WHERE s0_.subsite_id = 71 AND s0_.locale = 'fr' AND s0_.position = 'CENTER' AND s0_.pub_date <= '2026-10-22 08:05:43' AND s0_.is_active = 1 ORDER BY s0_.position_num ASC;

SELECT
  s0_.id AS id_0,
  s0_.position AS position_1,
  s0_.position_num AS position_num_2,
  s0_.title AS title_3,
  s0_.text AS text_4,
  s0_.created AS created_5,
  s0_.updated AS updated_6,
  s0_.is_active AS is_active_7,
  s0_.pub_date AS pub_date_8,
  s0_.slug AS slug_9,
  s0_.locale AS locale_10,
  s0_.subsite_id AS subsite_id_11,
  s0_.user_id AS user_id_12,
  s0_.asset_id AS asset_id_13
FROM
  subsite_module s0_
WHERE
  s0_.subsite_id = ?
  AND s0_.locale = ?
  AND s0_.position = 'RIGHT'
  AND s0_.pub_date <= ?
  AND s0_.is_active = 1
ORDER BY
  s0_.position_num ASC

SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.position_num AS position_num_2, s0_.title AS title_3, s0_.text AS text_4, s0_.created AS created_5, s0_.updated AS updated_6, s0_.is_active AS is_active_7, s0_.pub_date AS pub_date_8, s0_.slug AS slug_9, s0_.locale AS locale_10, s0_.subsite_id AS subsite_id_11, s0_.user_id AS user_id_12, s0_.asset_id AS asset_id_13 FROM subsite_module s0_ WHERE s0_.subsite_id = 71 AND s0_.locale = 'fr' AND s0_.position = 'RIGHT' AND s0_.pub_date <= '2026-10-22 08:05:43' AND s0_.is_active = 1 ORDER BY s0_.position_num ASC;

SELECT
  g0_.id AS id_0,
  g0_.created AS created_1,
  g0_.updated AS updated_2,
  g0_.locale AS locale_3,
  g0_.term AS term_4,
  g0_.description AS description_5,
  g0_.is_active AS is_active_6,
  g0_.pub_date AS pub_date_7,
  g0_.letter AS letter_8,
  g0_.slug AS slug_9,
  g0_.user_id AS user_id_10
FROM
  glossary g0_
  INNER JOIN glossary_subsite g2_ ON g0_.id = g2_.glossary_id
  INNER JOIN subsite s1_ ON s1_.id = g2_.subsite_id
  AND (s1_.id = ?)
WHERE
  g0_.locale = ?
  AND g0_.is_active = 1
  AND g0_.pub_date <= ?
ORDER BY
  g0_.term ASC

SELECT g0_.id AS id_0, g0_.created AS created_1, g0_.updated AS updated_2, g0_.locale AS locale_3, g0_.term AS term_4, g0_.description AS description_5, g0_.is_active AS is_active_6, g0_.pub_date AS pub_date_7, g0_.letter AS letter_8, g0_.slug AS slug_9, g0_.user_id AS user_id_10 FROM glossary g0_ INNER JOIN glossary_subsite g2_ ON g0_.id = g2_.glossary_id INNER JOIN subsite s1_ ON s1_.id = g2_.subsite_id AND (s1_.id = 71) WHERE g0_.locale = 'fr' AND g0_.is_active = 1 AND g0_.pub_date <= '2026-10-22 08:05:43' ORDER BY g0_.term ASC;

SELECT
  f0_.id AS id_0,
  f0_.created AS created_1,
  f0_.updated AS updated_2,
  f0_.locale AS locale_3,
  f0_.title AS title_4,
  f0_.subtitle AS subtitle_5,
  f0_.answer AS answer_6,
  f0_.is_active AS is_active_7,
  f0_.pub_date AS pub_date_8,
  f0_.is_general AS is_general_9,
  f0_.count_clicked AS count_clicked_10,
  f0_.slug AS slug_11,
  f0_.show_in_subsite AS show_in_subsite_12,
  f0_.user_id AS user_id_13,
  f0_.asset_id AS asset_id_14,
  f0_.news_id AS news_id_15,
  f0_.meta_id AS meta_id_16
FROM
  faq f0_
  INNER JOIN faq_subsite f1_ ON (f1_.faq_id = f0_.id)
WHERE
  f0_.locale = ?
  AND f1_.subsite_id = ?
  AND f0_.is_active = 1
  AND f0_.pub_date <= ?
ORDER BY
  f1_.position ASC,
  f0_.pub_date DESC

SELECT f0_.id AS id_0, f0_.created AS created_1, f0_.updated AS updated_2, f0_.locale AS locale_3, f0_.title AS title_4, f0_.subtitle AS subtitle_5, f0_.answer AS answer_6, f0_.is_active AS is_active_7, f0_.pub_date AS pub_date_8, f0_.is_general AS is_general_9, f0_.count_clicked AS count_clicked_10, f0_.slug AS slug_11, f0_.show_in_subsite AS show_in_subsite_12, f0_.user_id AS user_id_13, f0_.asset_id AS asset_id_14, f0_.news_id AS news_id_15, f0_.meta_id AS meta_id_16 FROM faq f0_ INNER JOIN faq_subsite f1_ ON (f1_.faq_id = f0_.id) WHERE f0_.locale = 'fr' AND f1_.subsite_id = 71 AND f0_.is_active = 1 AND f0_.pub_date <= '2026-10-22 08:05:43' ORDER BY f1_.position ASC, f0_.pub_date DESC;

SELECT
  n0_.id AS id_0,
  n0_.created AS created_1,
  n0_.updated AS updated_2,
  n0_.title AS title_3,
  n0_.subtitle AS subtitle_4,
  n0_.introduction AS introduction_5,
  n0_.text AS text_6,
  n0_.source AS source_7,
  n0_.author AS author_8,
  n0_.is_active AS is_active_9,
  n0_.pub_date AS pub_date_10,
  n0_.home AS home_11,
  n0_.in_newsletter AS in_newsletter_12,
  n0_.in_kabinetsmail AS in_kabinetsmail_13,
  n0_.newsletter_sended AS newsletter_sended_14,
  n0_.is_izimi AS is_izimi_15,
  n0_.spotlight AS spotlight_16,
  n0_.locale AS locale_17,
  n0_.is_pers AS is_pers_18,
  n0_.slug AS slug_19,
  n0_.is_reduced AS is_reduced_20,
  n0_.count_clicked AS count_clicked_21,
  n0_.user_id AS user_id_22,
  n0_.asset_id AS asset_id_23,
  n0_.meta_id AS meta_id_24,
  n0_.first_paragraph_asset_id AS first_paragraph_asset_id_25
FROM
  news n0_
  INNER JOIN news_subsite n2_ ON n0_.id = n2_.news_id
  INNER JOIN subsite s1_ ON s1_.id = n2_.subsite_id
  AND (s1_.id = ?)
WHERE
  n0_.locale = ?
  AND n0_.is_active = 1
  AND n0_.pub_date <= ?
ORDER BY
  n0_.pub_date DESC,
  n0_.id DESC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.created AS created_1, n0_.updated AS updated_2, n0_.title AS title_3, n0_.subtitle AS subtitle_4, n0_.introduction AS introduction_5, n0_.text AS text_6, n0_.source AS source_7, n0_.author AS author_8, n0_.is_active AS is_active_9, n0_.pub_date AS pub_date_10, n0_.home AS home_11, n0_.in_newsletter AS in_newsletter_12, n0_.in_kabinetsmail AS in_kabinetsmail_13, n0_.newsletter_sended AS newsletter_sended_14, n0_.is_izimi AS is_izimi_15, n0_.spotlight AS spotlight_16, n0_.locale AS locale_17, n0_.is_pers AS is_pers_18, n0_.slug AS slug_19, n0_.is_reduced AS is_reduced_20, n0_.count_clicked AS count_clicked_21, n0_.user_id AS user_id_22, n0_.asset_id AS asset_id_23, n0_.meta_id AS meta_id_24, n0_.first_paragraph_asset_id AS first_paragraph_asset_id_25 FROM news n0_ INNER JOIN news_subsite n2_ ON n0_.id = n2_.news_id INNER JOIN subsite s1_ ON s1_.id = n2_.subsite_id AND (s1_.id = 71) WHERE n0_.locale = 'fr' AND n0_.is_active = 1 AND n0_.pub_date <= '2026-10-22 00:00:00' ORDER BY n0_.pub_date DESC, n0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.locale AS locale_4,
  t0.title AS title_5,
  t0.subtitle AS subtitle_6,
  t0.answer AS answer_7,
  t0.is_active AS is_active_8,
  t0.pub_date AS pub_date_9,
  t0.is_general AS is_general_10,
  t0.count_clicked AS count_clicked_11,
  t0.slug AS slug_12,
  t0.show_in_subsite AS show_in_subsite_13,
  t0.user_id AS user_id_14,
  t0.asset_id AS asset_id_15,
  t0.news_id AS news_id_16,
  t0.meta_id AS meta_id_17
FROM
  faq t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.subtitle AS subtitle_6, t0.answer AS answer_7, t0.is_active AS is_active_8, t0.pub_date AS pub_date_9, t0.is_general AS is_general_10, t0.count_clicked AS count_clicked_11, t0.slug AS slug_12, t0.show_in_subsite AS show_in_subsite_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.news_id AS news_id_16, t0.meta_id AS meta_id_17 FROM faq t0 WHERE t0.news_id = 2491;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.locale AS locale_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.description AS description_7,
  t0.minutes AS minutes_8,
  t0.source AS source_9,
  t0.is_active AS is_active_10,
  t0.pub_date AS pub_date_11,
  t0.is_varia AS is_varia_12,
  t0.is_varia_primary AS is_varia_primary_13,
  t0.varia_position AS varia_position_14,
  t0.is_izimi AS is_izimi_15,
  t0.count_clicked AS count_clicked_16,
  t0.user_id AS user_id_17,
  t0.asset_id AS asset_id_18,
  t0.news_id AS news_id_19,
  t0.news_izimi_info_id AS news_izimi_info_id_20,
  t0.primary_subsite AS primary_subsite_21,
  t0.meta_id AS meta_id_22
FROM
  video t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.slug AS slug_6, t0.description AS description_7, t0.minutes AS minutes_8, t0.source AS source_9, t0.is_active AS is_active_10, t0.pub_date AS pub_date_11, t0.is_varia AS is_varia_12, t0.is_varia_primary AS is_varia_primary_13, t0.varia_position AS varia_position_14, t0.is_izimi AS is_izimi_15, t0.count_clicked AS count_clicked_16, t0.user_id AS user_id_17, t0.asset_id AS asset_id_18, t0.news_id AS news_id_19, t0.news_izimi_info_id AS news_izimi_info_id_20, t0.primary_subsite AS primary_subsite_21, t0.meta_id AS meta_id_22 FROM video t0 WHERE t0.news_id = 2491;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.locale AS locale_4,
  t0.title AS title_5,
  t0.description AS description_6,
  t0.pages AS pages_7,
  t0.edition AS edition_8,
  t0.count_clicked AS count_clicked_9,
  t0.publisher AS publisher_10,
  t0.is_active AS is_active_11,
  t0.pub_date AS pub_date_12,
  t0.is_general AS is_general_13,
  t0.general_position AS general_position_14,
  t0.is_general_primary AS is_general_primary_15,
  t0.is_izimi AS is_izimi_16,
  t0.brochureType AS brochureType_17,
  t0.user_id AS user_id_18,
  t0.asset_id AS asset_id_19,
  t0.primary_subsite AS primary_subsite_20,
  t0.news_id AS news_id_21
FROM
  brochure t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.locale AS locale_4, t0.title AS title_5, t0.description AS description_6, t0.pages AS pages_7, t0.edition AS edition_8, t0.count_clicked AS count_clicked_9, t0.publisher AS publisher_10, t0.is_active AS is_active_11, t0.pub_date AS pub_date_12, t0.is_general AS is_general_13, t0.general_position AS general_position_14, t0.is_general_primary AS is_general_primary_15, t0.is_izimi AS is_izimi_16, t0.brochureType AS brochureType_17, t0.user_id AS user_id_18, t0.asset_id AS asset_id_19, t0.primary_subsite AS primary_subsite_20, t0.news_id AS news_id_21 FROM brochure t0 WHERE t0.news_id = 2491;

SELECT
  v0_.id AS id_0,
  v0_.created AS created_1,
  v0_.updated AS updated_2,
  v0_.locale AS locale_3,
  v0_.title AS title_4,
  v0_.slug AS slug_5,
  v0_.description AS description_6,
  v0_.minutes AS minutes_7,
  v0_.source AS source_8,
  v0_.is_active AS is_active_9,
  v0_.pub_date AS pub_date_10,
  v0_.is_varia AS is_varia_11,
  v0_.is_varia_primary AS is_varia_primary_12,
  v0_.varia_position AS varia_position_13,
  v0_.is_izimi AS is_izimi_14,
  v0_.count_clicked AS count_clicked_15,
  v0_.user_id AS user_id_16,
  v0_.asset_id AS asset_id_17,
  v0_.news_id AS news_id_18,
  v0_.news_izimi_info_id AS news_izimi_info_id_19,
  v0_.primary_subsite AS primary_subsite_20,
  v0_.meta_id AS meta_id_21
FROM
  video v0_
  INNER JOIN video_subsite v1_ ON (v1_.video_id = v0_.id)
WHERE
  v0_.is_active = 1
  AND v0_.pub_date <= ?
  AND v1_.subsite_id = ?
ORDER BY
  v0_.pub_date DESC

SELECT v0_.id AS id_0, v0_.created AS created_1, v0_.updated AS updated_2, v0_.locale AS locale_3, v0_.title AS title_4, v0_.slug AS slug_5, v0_.description AS description_6, v0_.minutes AS minutes_7, v0_.source AS source_8, v0_.is_active AS is_active_9, v0_.pub_date AS pub_date_10, v0_.is_varia AS is_varia_11, v0_.is_varia_primary AS is_varia_primary_12, v0_.varia_position AS varia_position_13, v0_.is_izimi AS is_izimi_14, v0_.count_clicked AS count_clicked_15, v0_.user_id AS user_id_16, v0_.asset_id AS asset_id_17, v0_.news_id AS news_id_18, v0_.news_izimi_info_id AS news_izimi_info_id_19, v0_.primary_subsite AS primary_subsite_20, v0_.meta_id AS meta_id_21 FROM video v0_ INNER JOIN video_subsite v1_ ON (v1_.video_id = v0_.id) WHERE v0_.is_active = 1 AND v0_.pub_date <= '2026-10-22 08:05:43' AND v1_.subsite_id = 71 ORDER BY v0_.pub_date DESC;

SELECT
  f0_.id AS id_0,
  f0_.created AS created_1,
  f0_.updated AS updated_2,
  f0_.locale AS locale_3,
  f0_.title AS title_4,
  f0_.subtitle AS subtitle_5,
  f0_.answer AS answer_6,
  f0_.is_active AS is_active_7,
  f0_.pub_date AS pub_date_8,
  f0_.is_general AS is_general_9,
  f0_.count_clicked AS count_clicked_10,
  f0_.slug AS slug_11,
  f0_.show_in_subsite AS show_in_subsite_12,
  f0_.user_id AS user_id_13,
  f0_.asset_id AS asset_id_14,
  f0_.news_id AS news_id_15,
  f0_.meta_id AS meta_id_16
FROM
  faq f0_
  INNER JOIN faq_subsite f1_ ON (f1_.faq_id = f0_.id)
WHERE
  f0_.locale = ?
  AND f1_.subsite_id = ?
  AND f0_.is_active = 1
  AND f0_.pub_date <= ?
  AND f0_.show_in_subsite = 1
ORDER BY
  f1_.position ASC,
  f0_.pub_date DESC

SELECT f0_.id AS id_0, f0_.created AS created_1, f0_.updated AS updated_2, f0_.locale AS locale_3, f0_.title AS title_4, f0_.subtitle AS subtitle_5, f0_.answer AS answer_6, f0_.is_active AS is_active_7, f0_.pub_date AS pub_date_8, f0_.is_general AS is_general_9, f0_.count_clicked AS count_clicked_10, f0_.slug AS slug_11, f0_.show_in_subsite AS show_in_subsite_12, f0_.user_id AS user_id_13, f0_.asset_id AS asset_id_14, f0_.news_id AS news_id_15, f0_.meta_id AS meta_id_16 FROM faq f0_ INNER JOIN faq_subsite f1_ ON (f1_.faq_id = f0_.id) WHERE f0_.locale = 'fr' AND f1_.subsite_id = 71 AND f0_.is_active = 1 AND f0_.pub_date <= '2026-10-22 08:05:43' AND f0_.show_in_subsite = 1 ORDER BY f1_.position ASC, f0_.pub_date DESC;

SELECT
  b0_.id AS id_0,
  b0_.created AS created_1,
  b0_.updated AS updated_2,
  b0_.locale AS locale_3,
  b0_.title AS title_4,
  b0_.description AS description_5,
  b0_.pages AS pages_6,
  b0_.edition AS edition_7,
  b0_.count_clicked AS count_clicked_8,
  b0_.publisher AS publisher_9,
  b0_.is_active AS is_active_10,
  b0_.pub_date AS pub_date_11,
  b0_.is_general AS is_general_12,
  b0_.general_position AS general_position_13,
  b0_.is_general_primary AS is_general_primary_14,
  b0_.is_izimi AS is_izimi_15,
  b0_.brochureType AS brochureType_16,
  b0_.user_id AS user_id_17,
  b0_.asset_id AS asset_id_18,
  b0_.primary_subsite AS primary_subsite_19,
  b0_.news_id AS news_id_20
FROM
  brochure b0_
  INNER JOIN brochure_subsite b1_ ON (b1_.brochure = b0_.id)
WHERE
  b0_.locale = ?
  AND b1_.subsite_id = ?
  AND b0_.is_active = 1
  AND b0_.pub_date <= ?
ORDER BY
  b1_.position ASC,
  b0_.pub_date DESC

SELECT b0_.id AS id_0, b0_.created AS created_1, b0_.updated AS updated_2, b0_.locale AS locale_3, b0_.title AS title_4, b0_.description AS description_5, b0_.pages AS pages_6, b0_.edition AS edition_7, b0_.count_clicked AS count_clicked_8, b0_.publisher AS publisher_9, b0_.is_active AS is_active_10, b0_.pub_date AS pub_date_11, b0_.is_general AS is_general_12, b0_.general_position AS general_position_13, b0_.is_general_primary AS is_general_primary_14, b0_.is_izimi AS is_izimi_15, b0_.brochureType AS brochureType_16, b0_.user_id AS user_id_17, b0_.asset_id AS asset_id_18, b0_.primary_subsite AS primary_subsite_19, b0_.news_id AS news_id_20 FROM brochure b0_ INNER JOIN brochure_subsite b1_ ON (b1_.brochure = b0_.id) WHERE b0_.locale = 'fr' AND b1_.subsite_id = 71 AND b0_.is_active = 1 AND b0_.pub_date <= '2026-10-22 08:05:43' ORDER BY b1_.position ASC, b0_.pub_date DESC;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.stylesheet AS stylesheet_5,
  t0.in_main_nav AS in_main_nav_6,
  t0.is_active AS is_active_7,
  t0.position AS position_8,
  t0.oneliner AS oneliner_9,
  t0.welcome_text AS welcome_text_10,
  t0.directory AS directory_11,
  t0.page_title AS page_title_12,
  t0.type AS type_13,
  t0.meta_id AS meta_id_14,
  t0.language_link_subsite_id AS language_link_subsite_id_15
FROM
  subsite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.slug AS slug_4, t0.stylesheet AS stylesheet_5, t0.in_main_nav AS in_main_nav_6, t0.is_active AS is_active_7, t0.position AS position_8, t0.oneliner AS oneliner_9, t0.welcome_text AS welcome_text_10, t0.directory AS directory_11, t0.page_title AS page_title_12, t0.type AS type_13, t0.meta_id AS meta_id_14, t0.language_link_subsite_id AS language_link_subsite_id_15 FROM subsite t0 WHERE t0.id = 61;

SELECT
  t0.id AS id_1,
  t0.og_title AS og_title_2,
  t0.og_description AS og_description_3,
  t0.meta_keywords AS meta_keywords_4,
  t0.meta_description AS meta_description_5
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.og_title AS og_title_2, t0.og_description AS og_description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5 FROM meta t0 WHERE t0.id = 15439;

SELECT
  s0_.id AS id_0,
  s0_.locale AS locale_1,
  s0_.name AS name_2,
  s0_.slug AS slug_3,
  s0_.stylesheet AS stylesheet_4,
  s0_.in_main_nav AS in_main_nav_5,
  s0_.is_active AS is_active_6,
  s0_.position AS position_7,
  s0_.oneliner AS oneliner_8,
  s0_.welcome_text AS welcome_text_9,
  s0_.directory AS directory_10,
  s0_.page_title AS page_title_11,
  s0_.type AS type_12,
  s0_.meta_id AS meta_id_13,
  s0_.language_link_subsite_id AS language_link_subsite_id_14
FROM
  subsite s0_
WHERE
  s0_.locale = ?
  AND s0_.in_main_nav = 1
  AND s0_.is_active = 1
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.locale AS locale_1, s0_.name AS name_2, s0_.slug AS slug_3, s0_.stylesheet AS stylesheet_4, s0_.in_main_nav AS in_main_nav_5, s0_.is_active AS is_active_6, s0_.position AS position_7, s0_.oneliner AS oneliner_8, s0_.welcome_text AS welcome_text_9, s0_.directory AS directory_10, s0_.page_title AS page_title_11, s0_.type AS type_12, s0_.meta_id AS meta_id_13, s0_.language_link_subsite_id AS language_link_subsite_id_14 FROM subsite s0_ WHERE s0_.locale = 'fr' AND s0_.in_main_nav = 1 AND s0_.is_active = 1 ORDER BY s0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.navigation AS navigation_4,
  t0.slug AS slug_5,
  t0.is_active AS is_active_6,
  t0.pub_date AS pub_date_7,
  t0.show_navigation AS show_navigation_8,
  t0.title AS title_9,
  t0.description AS description_10,
  t0.position AS position_11,
  t0.not_delete AS not_delete_12,
  t0.redirect_url AS redirect_url_13,
  t0.user_id AS user_id_14,
  t0.asset_id AS asset_id_15,
  t0.subsite_id AS subsite_id_16,
  t0.parent_id AS parent_id_17,
  t0.meta_id AS meta_id_18
FROM
  section t0
WHERE
  t0.subsite_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = 71 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.navigation AS navigation_4,
  t0.slug AS slug_5,
  t0.is_active AS is_active_6,
  t0.pub_date AS pub_date_7,
  t0.show_navigation AS show_navigation_8,
  t0.title AS title_9,
  t0.description AS description_10,
  t0.position AS position_11,
  t0.not_delete AS not_delete_12,
  t0.redirect_url AS redirect_url_13,
  t0.user_id AS user_id_14,
  t0.asset_id AS asset_id_15,
  t0.subsite_id AS subsite_id_16,
  t0.parent_id AS parent_id_17,
  t0.meta_id AS meta_id_18
FROM
  section t0
WHERE
  t0.subsite_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = 67 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.navigation AS navigation_4,
  t0.slug AS slug_5,
  t0.is_active AS is_active_6,
  t0.pub_date AS pub_date_7,
  t0.show_navigation AS show_navigation_8,
  t0.title AS title_9,
  t0.description AS description_10,
  t0.position AS position_11,
  t0.not_delete AS not_delete_12,
  t0.redirect_url AS redirect_url_13,
  t0.user_id AS user_id_14,
  t0.asset_id AS asset_id_15,
  t0.subsite_id AS subsite_id_16,
  t0.parent_id AS parent_id_17,
  t0.meta_id AS meta_id_18
FROM
  section t0
WHERE
  t0.subsite_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.navigation AS navigation_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.pub_date AS pub_date_7, t0.show_navigation AS show_navigation_8, t0.title AS title_9, t0.description AS description_10, t0.position AS position_11, t0.not_delete AS not_delete_12, t0.redirect_url AS redirect_url_13, t0.user_id AS user_id_14, t0.asset_id AS asset_id_15, t0.subsite_id AS subsite_id_16, t0.parent_id AS parent_id_17, t0.meta_id AS meta_id_18 FROM section t0 WHERE t0.subsite_id = 78 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.navigation AS navigation_4,
  t0.slug AS slug_5,
  t0.is_active AS is_active_6,
  t0.pub_date AS pub_date_7,
  t0.show_navigation AS show_navigation_8,
  t0.title AS title_9,
  t0.description AS description_10,
  t0.position AS position_11,
  t0.not_delete AS not_delete_12,
  t0.redirect_url AS redirect_url_13,
  t0.user_id AS user_id_14,
  t0.asset_id AS asset_id_15,
  t0.subsite_id AS subsite_id_16,
  t0.parent_id AS parent_id_17,
  t0.meta_id AS meta_id_18
FROM
  section t0
WHERE
  t0.subsite_id = ?
ORDER BY
  t0.position ASC