| 1 |
1.69 ms |
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
Parameters: [
"les_medias_collegiens"
]
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;
|
| 2 |
0.63 ms |
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;
|
| 3 |
0.64 ms |
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
Parameters: [
1
"accueil"
]
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;
|
| 4 |
0.92 ms |
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;
|
| 5 |
0.95 ms |
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;
|