Symfony Profiler

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.class_name AS class_name_4,
  t0.content AS content_5,
  t0.descriptif AS descriptif_6,
  t0.fluid AS fluid_7,
  t0.intro AS intro_8,
  t0.priority AS priority_9,
  t0.is_activ AS is_activ_10,
  t0.favorites AS favorites_11,
  t0.position AS position_12,
  t0.is_show_title AS is_show_title_13,
  t0.is_showdescription AS is_showdescription_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.single_college_id AS single_college_id_17,
  t0.page_id AS page_id_18,
  t0.ressources_cat_id AS ressources_cat_id_19,
  t0.category_id AS category_id_20,
  t0.one_article_id AS one_article_id_21
FROM
  section t0
WHERE
  t0.favorites = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.class_name AS class_name_4, t0.content AS content_5, t0.descriptif AS descriptif_6, t0.fluid AS fluid_7, t0.intro AS intro_8, t0.priority AS priority_9, t0.is_activ AS is_activ_10, t0.favorites AS favorites_11, t0.position AS position_12, t0.is_show_title AS is_show_title_13, t0.is_showdescription AS is_showdescription_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.single_college_id AS single_college_id_17, t0.page_id AS page_id_18, t0.ressources_cat_id AS ressources_cat_id_19, t0.category_id AS category_id_20, t0.one_article_id AS one_article_id_21 FROM section t0 WHERE t0.favorites = 1 ORDER BY t0.position 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 = ?
LIMIT
  1

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 LIMIT 1;

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
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.content AS content_3,
  a0_.image_name AS image_name_4,
  a0_.image_size AS image_size_5,
  a0_.doc AS doc_6,
  a0_.intro AS intro_7,
  a0_.is_code AS is_code_8,
  a0_.is_title_show AS is_title_show_9,
  a0_.is_show_intro AS is_show_intro_10,
  a0_.is_archived AS is_archived_11,
  a0_.is_show_created AS is_show_created_12,
  a0_.is_show_read_more AS is_show_read_more_13,
  a0_.is_show_category AS is_show_category_14,
  a0_.is_show_support AS is_show_support_15,
  a0_.is_show_theme AS is_show_theme_16,
  a0_.created_at AS created_at_17,
  a0_.updated_at AS updated_at_18,
  a0_.id AS id_19,
  a0_.slug AS slug_20,
  a0_.title AS title_21,
  a0_.content AS content_22,
  a0_.image_name AS image_name_23,
  a0_.updated_at AS updated_at_24,
  c1_.id AS id_25,
  c1_.logo_name AS logo_name_26,
  u2_.typeuser AS typeuser_27,
  t3_.name AS name_28,
  a0_.author_id AS author_id_29,
  a0_.college_id AS college_id_30,
  a0_.theme_id AS theme_id_31,
  a0_.support_id AS support_id_32
FROM
  article a0_
  LEFT JOIN college c1_ ON a0_.college_id = c1_.id
  LEFT JOIN `user` u2_ ON a0_.author_id = u2_.id
  LEFT JOIN theme t3_ ON a0_.theme_id = t3_.id
WHERE
  u2_.typeuser = ?
ORDER BY
  a0_.updated_at DESC
LIMIT
  5

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.image_name AS image_name_4, a0_.image_size AS image_size_5, a0_.doc AS doc_6, a0_.intro AS intro_7, a0_.is_code AS is_code_8, a0_.is_title_show AS is_title_show_9, a0_.is_show_intro AS is_show_intro_10, a0_.is_archived AS is_archived_11, a0_.is_show_created AS is_show_created_12, a0_.is_show_read_more AS is_show_read_more_13, a0_.is_show_category AS is_show_category_14, a0_.is_show_support AS is_show_support_15, a0_.is_show_theme AS is_show_theme_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.id AS id_19, a0_.slug AS slug_20, a0_.title AS title_21, a0_.content AS content_22, a0_.image_name AS image_name_23, a0_.updated_at AS updated_at_24, c1_.id AS id_25, c1_.logo_name AS logo_name_26, u2_.typeuser AS typeuser_27, t3_.name AS name_28, a0_.author_id AS author_id_29, a0_.college_id AS college_id_30, a0_.theme_id AS theme_id_31, a0_.support_id AS support_id_32 FROM article a0_ LEFT JOIN college c1_ ON a0_.college_id = c1_.id LEFT JOIN `user` u2_ ON a0_.author_id = u2_.id LEFT JOIN theme t3_ ON a0_.theme_id = t3_.id WHERE u2_.typeuser = 'college' ORDER BY a0_.updated_at DESC LIMIT 5;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.content AS content_3,
  a0_.image_name AS image_name_4,
  a0_.image_size AS image_size_5,
  a0_.doc AS doc_6,
  a0_.intro AS intro_7,
  a0_.is_code AS is_code_8,
  a0_.is_title_show AS is_title_show_9,
  a0_.is_show_intro AS is_show_intro_10,
  a0_.is_archived AS is_archived_11,
  a0_.is_show_created AS is_show_created_12,
  a0_.is_show_read_more AS is_show_read_more_13,
  a0_.is_show_category AS is_show_category_14,
  a0_.is_show_support AS is_show_support_15,
  a0_.is_show_theme AS is_show_theme_16,
  a0_.created_at AS created_at_17,
  a0_.updated_at AS updated_at_18,
  a0_.id AS id_19,
  a0_.slug AS slug_20,
  a0_.title AS title_21,
  a0_.is_title_show AS is_title_show_22,
  a0_.is_show_read_more AS is_show_read_more_23,
  a0_.content AS content_24,
  a0_.is_archived AS is_archived_25,
  a0_.is_show_created AS is_show_created_26,
  t1_.id AS id_27,
  t1_.name AS name_28,
  a0_.image_name AS image_name_29,
  a0_.created_at AS created_at_30,
  a0_.doc AS doc_31,
  s2_.id AS id_32,
  s2_.name AS name_33,
  c3_.id AS id_34,
  a0_.author_id AS author_id_35,
  a0_.college_id AS college_id_36,
  a0_.theme_id AS theme_id_37,
  a0_.support_id AS support_id_38
FROM
  article a0_
  LEFT JOIN section s4_ ON a0_.id = s4_.one_article_id
  LEFT JOIN college c3_ ON a0_.college_id = c3_.id
  LEFT JOIN theme t1_ ON a0_.theme_id = t1_.id
  LEFT JOIN support s2_ ON a0_.support_id = s2_.id
WHERE
  s4_.id = ?
  AND a0_.is_archived = ?
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.image_name AS image_name_4, a0_.image_size AS image_size_5, a0_.doc AS doc_6, a0_.intro AS intro_7, a0_.is_code AS is_code_8, a0_.is_title_show AS is_title_show_9, a0_.is_show_intro AS is_show_intro_10, a0_.is_archived AS is_archived_11, a0_.is_show_created AS is_show_created_12, a0_.is_show_read_more AS is_show_read_more_13, a0_.is_show_category AS is_show_category_14, a0_.is_show_support AS is_show_support_15, a0_.is_show_theme AS is_show_theme_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.id AS id_19, a0_.slug AS slug_20, a0_.title AS title_21, a0_.is_title_show AS is_title_show_22, a0_.is_show_read_more AS is_show_read_more_23, a0_.content AS content_24, a0_.is_archived AS is_archived_25, a0_.is_show_created AS is_show_created_26, t1_.id AS id_27, t1_.name AS name_28, a0_.image_name AS image_name_29, a0_.created_at AS created_at_30, a0_.doc AS doc_31, s2_.id AS id_32, s2_.name AS name_33, c3_.id AS id_34, a0_.author_id AS author_id_35, a0_.college_id AS college_id_36, a0_.theme_id AS theme_id_37, a0_.support_id AS support_id_38 FROM article a0_ LEFT JOIN section s4_ ON a0_.id = s4_.one_article_id LEFT JOIN college c3_ ON a0_.college_id = c3_.id LEFT JOIN theme t1_ ON a0_.theme_id = t1_.id LEFT JOIN support s2_ ON a0_.support_id = s2_.id WHERE s4_.id = 34 AND a0_.is_archived = 0 ORDER BY a0_.id ASC;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.content AS content_3,
  a0_.image_name AS image_name_4,
  a0_.image_size AS image_size_5,
  a0_.doc AS doc_6,
  a0_.intro AS intro_7,
  a0_.is_code AS is_code_8,
  a0_.is_title_show AS is_title_show_9,
  a0_.is_show_intro AS is_show_intro_10,
  a0_.is_archived AS is_archived_11,
  a0_.is_show_created AS is_show_created_12,
  a0_.is_show_read_more AS is_show_read_more_13,
  a0_.is_show_category AS is_show_category_14,
  a0_.is_show_support AS is_show_support_15,
  a0_.is_show_theme AS is_show_theme_16,
  a0_.created_at AS created_at_17,
  a0_.updated_at AS updated_at_18,
  a0_.id AS id_19,
  a0_.slug AS slug_20,
  a0_.title AS title_21,
  a0_.is_title_show AS is_title_show_22,
  a0_.is_show_read_more AS is_show_read_more_23,
  a0_.content AS content_24,
  a0_.is_archived AS is_archived_25,
  a0_.is_show_created AS is_show_created_26,
  t1_.id AS id_27,
  t1_.name AS name_28,
  a0_.image_name AS image_name_29,
  a0_.created_at AS created_at_30,
  a0_.doc AS doc_31,
  s2_.id AS id_32,
  s2_.name AS name_33,
  c3_.id AS id_34,
  a0_.author_id AS author_id_35,
  a0_.college_id AS college_id_36,
  a0_.theme_id AS theme_id_37,
  a0_.support_id AS support_id_38
FROM
  article a0_
  LEFT JOIN section s4_ ON a0_.id = s4_.one_article_id
  LEFT JOIN college c3_ ON a0_.college_id = c3_.id
  LEFT JOIN theme t1_ ON a0_.theme_id = t1_.id
  LEFT JOIN support s2_ ON a0_.support_id = s2_.id
WHERE
  s4_.id = ?
  AND a0_.is_archived = ?
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.image_name AS image_name_4, a0_.image_size AS image_size_5, a0_.doc AS doc_6, a0_.intro AS intro_7, a0_.is_code AS is_code_8, a0_.is_title_show AS is_title_show_9, a0_.is_show_intro AS is_show_intro_10, a0_.is_archived AS is_archived_11, a0_.is_show_created AS is_show_created_12, a0_.is_show_read_more AS is_show_read_more_13, a0_.is_show_category AS is_show_category_14, a0_.is_show_support AS is_show_support_15, a0_.is_show_theme AS is_show_theme_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.id AS id_19, a0_.slug AS slug_20, a0_.title AS title_21, a0_.is_title_show AS is_title_show_22, a0_.is_show_read_more AS is_show_read_more_23, a0_.content AS content_24, a0_.is_archived AS is_archived_25, a0_.is_show_created AS is_show_created_26, t1_.id AS id_27, t1_.name AS name_28, a0_.image_name AS image_name_29, a0_.created_at AS created_at_30, a0_.doc AS doc_31, s2_.id AS id_32, s2_.name AS name_33, c3_.id AS id_34, a0_.author_id AS author_id_35, a0_.college_id AS college_id_36, a0_.theme_id AS theme_id_37, a0_.support_id AS support_id_38 FROM article a0_ LEFT JOIN section s4_ ON a0_.id = s4_.one_article_id LEFT JOIN college c3_ ON a0_.college_id = c3_.id LEFT JOIN theme t1_ ON a0_.theme_id = t1_.id LEFT JOIN support s2_ ON a0_.support_id = s2_.id WHERE s4_.id = 37 AND a0_.is_archived = 0 ORDER BY a0_.id ASC;