GET https://www.collegiens-citoyens.francas40.fr/app/les-groupes-jeunes

Query Metrics

26 Database Queries
6 Different statements
10.15 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

# Time Info
1 0.42 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.41 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-groupes-jeunes"
]
3 0.54 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_.state = ? AND p0_.is_menu = ? AND p0_.is_publish = ? AND p0_.title <> ? ORDER BY p0_.id ASC
Parameters:
[
  "finished"
  1
  1
  "accueil"
]
4 0.66 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_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:
[
  12
  1
]
5 1.27 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.address AS address_2, e0_.complement AS complement_3, e0_.zipcode AS zipcode_4, e0_.city AS city_5, e0_.etablissement_email AS etablissement_email_6, e0_.group_email AS group_email_7, e0_.etablissement_phone AS etablissement_phone_8, e0_.group_phone AS group_phone_9, e0_.animateur AS animateur_10, e0_.group_description AS group_description_11, e0_.logo_name AS logo_name_12, e0_.logo_size AS logo_size_13, e0_.header_name AS header_name_14, e0_.header_size AS header_size_15, e0_.work_meeting AS work_meeting_16, e0_.is_active AS is_active_17, e0_.created_at AS created_at_18, e0_.updated_at AS updated_at_19, e0_.id AS id_20, e0_.name AS name_21, e0_.city AS city_22, e0_.is_active AS is_active_23, e0_.logo_name AS logo_name_24, s1_.id AS id_25, t2_.id AS id_26, t2_.libelle AS libelle_27, e0_.type_etablissement_id AS type_etablissement_id_28 FROM etablissement e0_ LEFT JOIN etablissement_section e3_ ON e0_.id = e3_.etablissement_id LEFT JOIN section s1_ ON s1_.id = e3_.section_id LEFT JOIN type_etablissement t2_ ON e0_.type_etablissement_id = t2_.id WHERE e0_.is_active = ? ORDER BY t2_.libelle ASC, e0_.city ASC
Parameters:
[
  1
]
6 0.36 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:
[
  1
]
7 0.36 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:
[
  34
]
8 0.33 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:
[
  55
]
9 0.28 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:
[
  4
]
10 0.32 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:
[
  5
]
11 0.36 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:
[
  51
]
12 0.37 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:
[
  8
]
13 0.32 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
]
14 0.25 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:
[
  11
]
15 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:
[
  13
]
16 0.32 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:
[
  14
]
17 0.32 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:
[
  15
]
18 0.31 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:
[
  18
]
19 0.27 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:
[
  19
]
20 0.30 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:
[
  20
]
21 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:
[
  24
]
22 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:
[
  25
]
23 0.31 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
]
24 0.37 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:
[
  26
]
25 0.30 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:
[
  49
]
26 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:
[
  32
]

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\Admin\User 22
App\Entity\Admin\Etablissement 21
App\Entity\Webapp\Page 3
App\Entity\Admin\TypeEtablissement 2
App\Entity\Admin\Config 1
App\Entity\Webapp\Section 1