Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.intro AS intro_4,
  t0.state AS state_5,
  t0.meta_keywords AS meta_keywords_6,
  t0.meta_description AS meta_description_7,
  t0.tags AS tags_8,
  t0.publish_at AS publish_at_9,
  t0.publish_end AS publish_end_10,
  t0.position AS position_11,
  t0.is_title_show AS is_title_show_12,
  t0.is_menu AS is_menu_13,
  t0.is_intro_show AS is_intro_show_14,
  t0.is_publish AS is_publish_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.author_id AS author_id_18
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.intro AS intro_4, t0.state AS state_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.tags AS tags_8, t0.publish_at AS publish_at_9, t0.publish_end AS publish_end_10, t0.position AS position_11, t0.is_title_show AS is_title_show_12, t0.is_menu AS is_menu_13, t0.is_intro_show AS is_intro_show_14, t0.is_publish AS is_publish_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.author_id AS author_id_18 FROM page t0 WHERE t0.slug = 'les_medias_collegiens' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.address AS address_2,
  c0_.complement AS complement_3,
  c0_.zipcode AS zipcode_4,
  c0_.city AS city_5,
  c0_.college_email AS college_email_6,
  c0_.group_email AS group_email_7,
  c0_.college_phone AS college_phone_8,
  c0_.group_phone AS group_phone_9,
  c0_.animateur AS animateur_10,
  c0_.group_description AS group_description_11,
  c0_.logo_name AS logo_name_12,
  c0_.logo_size AS logo_size_13,
  c0_.header_name AS header_name_14,
  c0_.header_size AS header_size_15,
  c0_.work_meeting AS work_meeting_16,
  c0_.is_active AS is_active_17,
  c0_.created_at AS created_at_18,
  c0_.updated_at AS updated_at_19,
  c0_.id AS id_20,
  c0_.name AS name_21,
  c0_.city AS city_22,
  c0_.is_active AS is_active_23,
  c0_.logo_name AS logo_name_24,
  s1_.id AS id_25,
  c0_.user_id AS user_id_26
FROM
  college c0_
  LEFT JOIN college_section c2_ ON c0_.id = c2_.college_id
  LEFT JOIN section s1_ ON s1_.id = c2_.section_id
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.city ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.complement AS complement_3, c0_.zipcode AS zipcode_4, c0_.city AS city_5, c0_.college_email AS college_email_6, c0_.group_email AS group_email_7, c0_.college_phone AS college_phone_8, c0_.group_phone AS group_phone_9, c0_.animateur AS animateur_10, c0_.group_description AS group_description_11, c0_.logo_name AS logo_name_12, c0_.logo_size AS logo_size_13, c0_.header_name AS header_name_14, c0_.header_size AS header_size_15, c0_.work_meeting AS work_meeting_16, c0_.is_active AS is_active_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.id AS id_20, c0_.name AS name_21, c0_.city AS city_22, c0_.is_active AS is_active_23, c0_.logo_name AS logo_name_24, s1_.id AS id_25, c0_.user_id AS user_id_26 FROM college c0_ LEFT JOIN college_section c2_ ON c0_.id = c2_.college_id LEFT JOIN section s1_ ON s1_.id = c2_.section_id WHERE c0_.is_active = 1 ORDER BY c0_.city ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.class_name AS class_name_3,
  s0_.content AS content_4,
  s0_.descriptif AS descriptif_5,
  s0_.fluid AS fluid_6,
  s0_.intro AS intro_7,
  s0_.priority AS priority_8,
  s0_.is_activ AS is_activ_9,
  s0_.favorites AS favorites_10,
  s0_.position AS position_11,
  s0_.is_show_title AS is_show_title_12,
  s0_.is_showdescription AS is_showdescription_13,
  s0_.created_at AS created_at_14,
  s0_.updated_at AS updated_at_15,
  s0_.single_college_id AS single_college_id_16,
  s0_.page_id AS page_id_17,
  s0_.ressources_cat_id AS ressources_cat_id_18,
  s0_.category_id AS category_id_19,
  s0_.one_article_id AS one_article_id_20
FROM
  section s0_
  LEFT JOIN page p1_ ON s0_.page_id = p1_.id
WHERE
  p1_.id = ?
  AND s0_.is_activ = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.class_name AS class_name_3, s0_.content AS content_4, s0_.descriptif AS descriptif_5, s0_.fluid AS fluid_6, s0_.intro AS intro_7, s0_.priority AS priority_8, s0_.is_activ AS is_activ_9, s0_.favorites AS favorites_10, s0_.position AS position_11, s0_.is_show_title AS is_show_title_12, s0_.is_showdescription AS is_showdescription_13, s0_.created_at AS created_at_14, s0_.updated_at AS updated_at_15, s0_.single_college_id AS single_college_id_16, s0_.page_id AS page_id_17, s0_.ressources_cat_id AS ressources_cat_id_18, s0_.category_id AS category_id_19, s0_.one_article_id AS one_article_id_20 FROM section s0_ LEFT JOIN page p1_ ON s0_.page_id = p1_.id WHERE p1_.id = 5 AND s0_.is_activ = 1 ORDER BY s0_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.intro AS intro_3,
  p0_.state AS state_4,
  p0_.meta_keywords AS meta_keywords_5,
  p0_.meta_description AS meta_description_6,
  p0_.tags AS tags_7,
  p0_.publish_at AS publish_at_8,
  p0_.publish_end AS publish_end_9,
  p0_.position AS position_10,
  p0_.is_title_show AS is_title_show_11,
  p0_.is_menu AS is_menu_12,
  p0_.is_intro_show AS is_intro_show_13,
  p0_.is_publish AS is_publish_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p0_.author_id AS author_id_17
FROM
  page p0_
WHERE
  p0_.is_menu = ?
  AND p0_.title <> ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.intro AS intro_3, p0_.state AS state_4, p0_.meta_keywords AS meta_keywords_5, p0_.meta_description AS meta_description_6, p0_.tags AS tags_7, p0_.publish_at AS publish_at_8, p0_.publish_end AS publish_end_9, p0_.position AS position_10, p0_.is_title_show AS is_title_show_11, p0_.is_menu AS is_menu_12, p0_.is_intro_show AS is_intro_show_13, p0_.is_publish AS is_publish_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.author_id AS author_id_17 FROM page p0_ WHERE p0_.is_menu = 1 AND p0_.title <> 'accueil' ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_offline AS is_offline_4,
  t0.logo_name AS logo_name_5,
  t0.logo_size AS logo_size_6,
  t0.header_name AS header_name_7,
  t0.header_size AS header_size_8,
  t0.is_header_show AS is_header_show_9,
  t0.is_show_title_site_home AS is_show_title_site_home_10,
  t0.vignette_name AS vignette_name_11,
  t0.vignette_size AS vignette_size_12,
  t0.is_suppr_vignette AS is_suppr_vignette_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_offline AS is_offline_4, t0.logo_name AS logo_name_5, t0.logo_size AS logo_size_6, t0.header_name AS header_name_7, t0.header_size AS header_size_8, t0.is_header_show AS is_header_show_9, t0.is_show_title_site_home AS is_show_title_site_home_10, t0.vignette_name AS vignette_name_11, t0.vignette_size AS vignette_size_12, t0.is_suppr_vignette AS is_suppr_vignette_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM config t0 WHERE t0.id = 1;