Redirect 302 redirect from GET @op_webapp_home (7d10e9)

GET https://www.collegiens-citoyens.francas40.fr/home

Query Metrics

14 Database Queries
10 Different statements
10.63 ms Query time
0 Invalid entities
25 Managed entities

Queries

Group similar statements

# Time Info
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 = ?
Parameters:
[
  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
Parameters:
[
  1
]
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
]
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"
]
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
Parameters:
[
  1
  0
]
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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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"
]
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
]
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
Parameters:
[
  69
  0
]
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
Parameters:
[
  704
]
13 0.73 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
Parameters:
[
  70
  0
]
14 0.48 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:
[
  705
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Webapp\Article 7
App\Entity\Admin\User 4
App\Entity\Admin\Etablissement 4
App\Entity\Webapp\Section 3
App\Entity\Webapp\Page 3
App\Entity\Admin\Config 1
App\Entity\Webapp\Category 1
App\Entity\Gestapp\Support 1
App\Entity\Admin\TypeEtablissement 1