GET https://collegiens-citoyens.openpixl.fr/app/les_medias_collegiens

Query Metrics

5 Database Queries
5 Different statements
6.19 ms Query time
0 Invalid entities
625 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.32 ms
(69.91%)
1
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_.updated_at AS updated_at_29, a0_.doc AS doc_30, t1_.id AS id_31, t1_.name AS name_32, a0_.image_name AS image_name_33, s2_.id AS id_34, s2_.name AS name_35, e3_.id AS id_36, e3_.name AS name_37, e3_.logo_name AS logo_name_38, t4_.id AS id_39, t4_.libelle AS libelle_40, a0_.author_id AS author_id_41, a0_.etablissement_id AS etablissement_id_42, a0_.theme_id AS theme_id_43, a0_.support_id AS support_id_44 FROM article a0_ LEFT JOIN etablissement e3_ ON a0_.etablissement_id = e3_.id LEFT JOIN type_etablissement t4_ ON e3_.type_etablissement_id = t4_.id LEFT JOIN theme t1_ ON a0_.theme_id = t1_.id LEFT JOIN support s2_ ON a0_.support_id = s2_.id WHERE a0_.is_archived = ? AND a0_.etablissement_id IS NOT NULL ORDER BY a0_.updated_at DESC
Parameters:
[
  0
]
0.53 ms
(8.60%)
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_.state = ? AND p0_.is_menu = ? AND p0_.is_publish = ? AND p0_.title <> ? ORDER BY p0_.id ASC
Parameters:
[
  "finished"
  1
  1
  "accueil"
]
0.51 ms
(8.21%)
1
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_etablissement_id AS single_etablissement_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
Parameters:
[
  5
  1
]
0.44 ms
(7.08%)
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 = ?
Parameters:
[
  1
]
0.38 ms
(6.21%)
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 = ? LIMIT 1
Parameters:
[
  "les_medias_collegiens"
]

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 541
App\Entity\Admin\Etablissement 38
App\Entity\Admin\User 31
App\Entity\Gestapp\Theme 6
App\Entity\Gestapp\Support 4
App\Entity\Webapp\Page 3
App\Entity\Admin\Config 1
App\Entity\Webapp\Section 1