| 1 |
0.57 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;
|
| 2 |
0.54 ms |
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_etablissement_id AS single_etablissement_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_etablissement_id AS single_etablissement_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;
|
| 3 |
0.52 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.intro AS intro_4, t0.image AS image_5, t0.under_nav_hidden AS under_nav_hidden_6, t0.under_nav_type AS under_nav_type_7, t0.state AS state_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.tags AS tags_11, t0.publish_at AS publish_at_12, t0.publish_end AS publish_end_13, t0.position AS position_14, t0.is_title_show AS is_title_show_15, t0.is_menu AS is_menu_16, t0.is_intro_show AS is_intro_show_17, t0.is_publish AS is_publish_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.author_id AS author_id_21 FROM page t0 WHERE t0.slug = ? AND t0.is_publish = ? LIMIT 1
Parameters: [
"radio-francas-40"
1
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.intro AS intro_4, t0.image AS image_5, t0.under_nav_hidden AS under_nav_hidden_6, t0.under_nav_type AS under_nav_type_7, t0.state AS state_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.tags AS tags_11, t0.publish_at AS publish_at_12, t0.publish_end AS publish_end_13, t0.position AS position_14, t0.is_title_show AS is_title_show_15, t0.is_menu AS is_menu_16, t0.is_intro_show AS is_intro_show_17, t0.is_publish AS is_publish_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.author_id AS author_id_21 FROM page t0 WHERE t0.slug = 'radio-francas-40' AND t0.is_publish = 1 LIMIT 1;
|
| 4 |
0.61 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.intro AS intro_3, p0_.image AS image_4, p0_.under_nav_hidden AS under_nav_hidden_5, p0_.under_nav_type AS under_nav_type_6, p0_.state AS state_7, p0_.meta_keywords AS meta_keywords_8, p0_.meta_description AS meta_description_9, p0_.tags AS tags_10, p0_.publish_at AS publish_at_11, p0_.publish_end AS publish_end_12, p0_.position AS position_13, p0_.is_title_show AS is_title_show_14, p0_.is_menu AS is_menu_15, p0_.is_intro_show AS is_intro_show_16, p0_.is_publish AS is_publish_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.author_id AS author_id_20 FROM page p0_ WHERE p0_.state = ? AND p0_.is_menu = ? AND p0_.is_publish = ? AND p0_.title <> ? ORDER BY p0_.id ASC
Parameters: [
"finished"
1
1
"accueil"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.intro AS intro_3, p0_.image AS image_4, p0_.under_nav_hidden AS under_nav_hidden_5, p0_.under_nav_type AS under_nav_type_6, p0_.state AS state_7, p0_.meta_keywords AS meta_keywords_8, p0_.meta_description AS meta_description_9, p0_.tags AS tags_10, p0_.publish_at AS publish_at_11, p0_.publish_end AS publish_end_12, p0_.position AS position_13, p0_.is_title_show AS is_title_show_14, p0_.is_menu AS is_menu_15, p0_.is_intro_show AS is_intro_show_16, p0_.is_publish AS is_publish_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.author_id AS author_id_20 FROM page p0_ WHERE p0_.state = 'finished' AND p0_.is_menu = 1 AND p0_.is_publish = 1 AND p0_.title <> 'accueil' ORDER BY p0_.id ASC;
|
| 5 |
2.47 ms |
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_.is_suppr_image AS is_suppr_image_19, a0_.is_suppr_doc AS is_suppr_doc_20, s1_.id AS id_21, s1_.name AS name_22, s1_.image_name AS image_name_23, s1_.image_size AS image_size_24, s1_.created_at AS created_at_25, s1_.updated_at AS updated_at_26, e2_.id AS id_27, e2_.name AS name_28, e2_.address AS address_29, e2_.complement AS complement_30, e2_.zipcode AS zipcode_31, e2_.city AS city_32, e2_.etablissement_email AS etablissement_email_33, e2_.group_email AS group_email_34, e2_.etablissement_phone AS etablissement_phone_35, e2_.group_phone AS group_phone_36, e2_.animateur AS animateur_37, e2_.group_description AS group_description_38, e2_.logo_name AS logo_name_39, e2_.logo_size AS logo_size_40, e2_.header_name AS header_name_41, e2_.header_size AS header_size_42, e2_.work_meeting AS work_meeting_43, e2_.is_active AS is_active_44, e2_.created_at AS created_at_45, e2_.updated_at AS updated_at_46, a0_.author_id AS author_id_47, a0_.etablissement_id AS etablissement_id_48, a0_.support_id AS support_id_49, e2_.type_etablissement_id AS type_etablissement_id_50 FROM article a0_ LEFT JOIN support s1_ ON a0_.support_id = s1_.id LEFT JOIN etablissement e2_ ON a0_.etablissement_id = e2_.id WHERE s1_.id = ? AND a0_.is_archived = ? AND a0_.doc IS NOT NULL AND a0_.doc <> '' ORDER BY a0_.created_at DESC, a0_.id 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_.is_suppr_image AS is_suppr_image_19,
a0_.is_suppr_doc AS is_suppr_doc_20,
s1_.id AS id_21,
s1_.name AS name_22,
s1_.image_name AS image_name_23,
s1_.image_size AS image_size_24,
s1_.created_at AS created_at_25,
s1_.updated_at AS updated_at_26,
e2_.id AS id_27,
e2_.name AS name_28,
e2_.address AS address_29,
e2_.complement AS complement_30,
e2_.zipcode AS zipcode_31,
e2_.city AS city_32,
e2_.etablissement_email AS etablissement_email_33,
e2_.group_email AS group_email_34,
e2_.etablissement_phone AS etablissement_phone_35,
e2_.group_phone AS group_phone_36,
e2_.animateur AS animateur_37,
e2_.group_description AS group_description_38,
e2_.logo_name AS logo_name_39,
e2_.logo_size AS logo_size_40,
e2_.header_name AS header_name_41,
e2_.header_size AS header_size_42,
e2_.work_meeting AS work_meeting_43,
e2_.is_active AS is_active_44,
e2_.created_at AS created_at_45,
e2_.updated_at AS updated_at_46,
a0_.author_id AS author_id_47,
a0_.etablissement_id AS etablissement_id_48,
a0_.support_id AS support_id_49,
e2_.type_etablissement_id AS type_etablissement_id_50
FROM
article a0_
LEFT JOIN support s1_ ON a0_.support_id = s1_.id
LEFT JOIN etablissement e2_ ON a0_.etablissement_id = e2_.id
WHERE
s1_.id = ?
AND a0_.is_archived = ?
AND a0_.doc IS NOT NULL
AND a0_.doc <> ''
ORDER BY
a0_.created_at DESC,
a0_.id 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_.is_suppr_image AS is_suppr_image_19, a0_.is_suppr_doc AS is_suppr_doc_20, s1_.id AS id_21, s1_.name AS name_22, s1_.image_name AS image_name_23, s1_.image_size AS image_size_24, s1_.created_at AS created_at_25, s1_.updated_at AS updated_at_26, e2_.id AS id_27, e2_.name AS name_28, e2_.address AS address_29, e2_.complement AS complement_30, e2_.zipcode AS zipcode_31, e2_.city AS city_32, e2_.etablissement_email AS etablissement_email_33, e2_.group_email AS group_email_34, e2_.etablissement_phone AS etablissement_phone_35, e2_.group_phone AS group_phone_36, e2_.animateur AS animateur_37, e2_.group_description AS group_description_38, e2_.logo_name AS logo_name_39, e2_.logo_size AS logo_size_40, e2_.header_name AS header_name_41, e2_.header_size AS header_size_42, e2_.work_meeting AS work_meeting_43, e2_.is_active AS is_active_44, e2_.created_at AS created_at_45, e2_.updated_at AS updated_at_46, a0_.author_id AS author_id_47, a0_.etablissement_id AS etablissement_id_48, a0_.support_id AS support_id_49, e2_.type_etablissement_id AS type_etablissement_id_50 FROM article a0_ LEFT JOIN support s1_ ON a0_.support_id = s1_.id LEFT JOIN etablissement e2_ ON a0_.etablissement_id = e2_.id WHERE s1_.id = 1 AND a0_.is_archived = 0 AND a0_.doc IS NOT NULL AND a0_.doc <> '' ORDER BY a0_.created_at DESC, a0_.id DESC LIMIT 5;
|
| 6 |
0.50 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.etablissement_id AS etablissement_id_21 FROM `user` t0 WHERE t0.etablissement_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.etablissement_id AS etablissement_id_21 FROM `user` t0 WHERE t0.etablissement_id = 24;
|
| 7 |
0.34 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.etablissement_id AS etablissement_id_21 FROM `user` t0 WHERE t0.etablissement_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.etablissement_id AS etablissement_id_21 FROM `user` t0 WHERE t0.etablissement_id = 10;
|
| 8 |
0.35 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.etablissement_id AS etablissement_id_21 FROM `user` t0 WHERE t0.etablissement_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.etablissement_id AS etablissement_id_21 FROM `user` t0 WHERE t0.etablissement_id = 31;
|
| 9 |
1.63 ms |
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_.is_suppr_image AS is_suppr_image_19, a0_.is_suppr_doc AS is_suppr_doc_20, a0_.id AS id_21, a0_.slug AS slug_22, a0_.title AS title_23, a0_.content AS content_24, a0_.image_name AS image_name_25, a0_.updated_at AS updated_at_26, e1_.id AS id_27, e1_.logo_name AS logo_name_28, u2_.typeuser AS typeuser_29, u2_.id AS id_30, a0_.author_id AS author_id_31, a0_.etablissement_id AS etablissement_id_32, a0_.support_id AS support_id_33 FROM article a0_ LEFT JOIN etablissement e1_ ON a0_.etablissement_id = e1_.id LEFT JOIN `user` u2_ ON a0_.author_id = u2_.id WHERE u2_.typeuser = ? ORDER BY a0_.updated_at DESC LIMIT 5
Parameters: [
"etablissement"
]
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_.is_suppr_image AS is_suppr_image_19, a0_.is_suppr_doc AS is_suppr_doc_20, a0_.id AS id_21, a0_.slug AS slug_22, a0_.title AS title_23, a0_.content AS content_24, a0_.image_name AS image_name_25, a0_.updated_at AS updated_at_26, e1_.id AS id_27, e1_.logo_name AS logo_name_28, u2_.typeuser AS typeuser_29, u2_.id AS id_30, a0_.author_id AS author_id_31, a0_.etablissement_id AS etablissement_id_32, a0_.support_id AS support_id_33 FROM article a0_ LEFT JOIN etablissement e1_ ON a0_.etablissement_id = e1_.id LEFT JOIN `user` u2_ ON a0_.author_id = u2_.id WHERE u2_.typeuser = 'etablissement' ORDER BY a0_.updated_at DESC LIMIT 5;
|
| 10 |
0.60 ms |
SELECT a0_.id AS id_0, t1_.name AS name_1 FROM article a0_ INNER JOIN article_theme a2_ ON a0_.id = a2_.article_id INNER JOIN theme t1_ ON t1_.id = a2_.theme_id WHERE a0_.id IN (?, ?, ?, ?, ?) ORDER BY t1_.name ASC
Parameters: [
702
703
700
699
698
]
SELECT a0_.id AS id_0, t1_.name AS name_1 FROM article a0_ INNER JOIN article_theme a2_ ON a0_.id = a2_.article_id INNER JOIN theme t1_ ON t1_.id = a2_.theme_id WHERE a0_.id IN (702, 703, 700, 699, 698) ORDER BY t1_.name ASC;
|
| 11 |
0.82 ms |
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_.is_suppr_image AS is_suppr_image_19, a0_.is_suppr_doc AS is_suppr_doc_20, a0_.id AS id_21, a0_.slug AS slug_22, a0_.title AS title_23, a0_.is_title_show AS is_title_show_24, a0_.is_show_read_more AS is_show_read_more_25, a0_.content AS content_26, a0_.is_archived AS is_archived_27, a0_.is_show_created AS is_show_created_28, a0_.image_name AS image_name_29, a0_.created_at AS created_at_30, a0_.doc AS doc_31, s1_.id AS id_32, s1_.name AS name_33, e2_.id AS id_34, u3_.id AS id_35, a0_.author_id AS author_id_36, a0_.etablissement_id AS etablissement_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 etablissement e2_ ON a0_.etablissement_id = e2_.id LEFT JOIN support s1_ ON a0_.support_id = s1_.id LEFT JOIN `user` u3_ ON a0_.author_id = u3_.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_.is_suppr_image AS is_suppr_image_19, a0_.is_suppr_doc AS is_suppr_doc_20, a0_.id AS id_21, a0_.slug AS slug_22, a0_.title AS title_23, a0_.is_title_show AS is_title_show_24, a0_.is_show_read_more AS is_show_read_more_25, a0_.content AS content_26, a0_.is_archived AS is_archived_27, a0_.is_show_created AS is_show_created_28, a0_.image_name AS image_name_29, a0_.created_at AS created_at_30, a0_.doc AS doc_31, s1_.id AS id_32, s1_.name AS name_33, e2_.id AS id_34, u3_.id AS id_35, a0_.author_id AS author_id_36, a0_.etablissement_id AS etablissement_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 etablissement e2_ ON a0_.etablissement_id = e2_.id LEFT JOIN support s1_ ON a0_.support_id = s1_.id LEFT JOIN `user` u3_ ON a0_.author_id = u3_.id WHERE s4_.id = 69 AND a0_.is_archived = 0 ORDER BY a0_.id ASC;
|
| 12 |
0.46 ms |
SELECT a0_.id AS id_0, t1_.name AS name_1 FROM article a0_ INNER JOIN article_theme a2_ ON a0_.id = a2_.article_id INNER JOIN theme t1_ ON t1_.id = a2_.theme_id WHERE a0_.id IN (?) ORDER BY t1_.name ASC
SELECT a0_.id AS id_0, t1_.name AS name_1 FROM article a0_ INNER JOIN article_theme a2_ ON a0_.id = a2_.article_id INNER JOIN theme t1_ ON t1_.id = a2_.theme_id WHERE a0_.id IN (704) ORDER BY t1_.name ASC;
|