Query Metrics
26
Database Queries
10
Different statements
30.05 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.image_name AS image_name_4, t0.introduction AS introduction_5, t0.insert_html AS insert_html_6, t0.description AS description_7, t0.date_create AS date_create_8, t0.date_update AS date_update_9, t0.commentaire_accepte AS commentaire_accepte_10, t0.reserve_adherent AS reserve_adherent_11, t0.signature AS signature_12, t0.date_publication AS date_publication_13, t0.filename AS filename_14, t0.filename2 AS filename2_15, t0.filename3 AS filename3_16, t0.type_id AS type_id_17, t0.auteur_id AS auteur_id_18, t0.statut_id AS statut_id_19 FROM article t0 WHERE t0.statut_id = ? ORDER BY t0.date_publication DESC LIMIT 12
Parameters:
[
2
]
|
2 | 1.01 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.introduction AS introduction_4, t0.description AS description_5, t0.date_publication AS date_publication_6, t0.date_update AS date_update_7, t0.illustration_liste_name AS illustration_liste_name_8, t0.illustration_detail_name AS illustration_detail_name_9, t0.meta_description AS meta_description_10, t0.user_create_id AS user_create_id_11 FROM communique t0 ORDER BY t0.date_publication DESC LIMIT 12
Parameters:
[] |
3 | 2.55 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date_debut AS date_debut_3, e0_.date_fin AS date_fin_4, e0_.pays AS pays_5, e0_.adresse1 AS adresse1_6, e0_.adresse2 AS adresse2_7, e0_.code_postal AS code_postal_8, e0_.ville AS ville_9, e0_.alias AS alias_10, e0_.latitude AS latitude_11, e0_.longitude AS longitude_12, e0_.date_create AS date_create_13, e0_.date_update AS date_update_14, e0_.introduction AS introduction_15, e0_.insert_html AS insert_html_16, e0_.image_name AS image_name_17, e0_.commentaire_accepte AS commentaire_accepte_18, e0_.horaires AS horaires_19, e0_.reserve_adherent AS reserve_adherent_20, e0_.signature AS signature_21, e0_.filename AS filename_22, e0_.date_publication AS date_publication_23, e0_.filename2 AS filename2_24, e0_.filename3 AS filename3_25, e0_.rubrique_id AS rubrique_id_26, e0_.user_create_id AS user_create_id_27, e0_.user_update_id AS user_update_id_28, e0_.statut_id AS statut_id_29, e0_.auteur_id AS auteur_id_30 FROM evenement e0_ WHERE e0_.date_debut >= ? AND e0_.statut_id = 2 ORDER BY e0_.date_debut ASC LIMIT 12
Parameters:
[
"2024-11-21 06:04:02"
]
|
4 | 0.78 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"thematiques"
]
|
5 | 0.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"regionaux"
]
|
6 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"sectoriels"
]
|
7 | 0.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM groupe_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"outils"
]
|
8 | 1.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.type_id = ? AND t0.actif = ? ORDER BY t0.date_update DESC LIMIT 8
Parameters:
[ 1093 1 ] |
9 | 0.89 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.type_id = ? AND t0.actif = ? ORDER BY t0.date_update DESC LIMIT 8
Parameters:
[ 6 1 ] |
10 | 0.82 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.type_id = ? AND t0.actif = ? ORDER BY t0.date_update DESC LIMIT 8
Parameters:
[ 1095 1 ] |
11 | 0.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 WHERE t0.type_id = ? ORDER BY t0.date_update DESC LIMIT 8
Parameters:
[
1097
]
|
12 | 2.11 ms |
SELECT f0_.date_debut AS date_debut_0, f0_.date_fin AS date_fin_1, f1_.name AS name_2, f1_.alias AS alias_3, f0_.modalites AS modalites_4, f0_.lieu AS lieu_5 FROM formation_session f0_ INNER JOIN formation f1_ ON f0_.formation_id = f1_.id WHERE f0_.date_debut >= ? GROUP BY f0_.id LIMIT 4
Parameters:
[
"2024-11-21 06:04:02"
]
|
13 | 2.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.intro AS intro_3, t0.image_name AS image_name_4, t0.lien_libelle AS lien_libelle_5, t0.lien_url AS lien_url_6, t0.couleur AS couleur_7, t0.ordre AS ordre_8, t0.date_update AS date_update_9 FROM slider_accueil t0 ORDER BY t0.ordre ASC
Parameters:
[] |
14 | 0.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN evenement_groupe ON t0.id = evenement_groupe.groupe_id WHERE evenement_groupe.evenement_id = ?
Parameters:
[
292419
]
|
15 | 1.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
184
]
|
16 | 1.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
183
]
|
17 | 1.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
181
]
|
18 | 1.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
180
]
|
19 | 1.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
182
]
|
20 | 1.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
148
]
|
21 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
169
]
|
22 | 0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
172
]
|
23 | 0.65 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
176
]
|
24 | 0.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
171
]
|
25 | 0.78 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
175
]
|
26 | 0.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.reference AS reference_5, t0.description AS description_6, t0.logoname AS logoname_7, t0.alias AS alias_8, t0.introduction AS introduction_9, t0.actif AS actif_10, t0.type_id AS type_id_11, t0.responsable_id AS responsable_id_12 FROM groupe t0 INNER JOIN article_groupe ON t0.id = article_groupe.groupe_id WHERE article_groupe.article_id = ?
Parameters:
[
177
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Article | No errors. |
App\Entity\ArticleType | No errors. |
App\Entity\User | No errors. |
App\Entity\Statut | No errors. |
App\Entity\Groupe | No errors. |
App\Entity\Thematique | No errors. |
App\Entity\ArticleLien | No errors. |
App\Entity\ArticleCommentaire | No errors. |
App\Entity\Communique | No errors. |
App\Entity\Evenement | No errors. |
App\Entity\EvenementRubrique | No errors. |
App\Entity\EvenementType | No errors. |
App\Entity\Metier |
|
App\Entity\EvenementCommentaire | No errors. |
App\Entity\EvenementLien | No errors. |
App\Entity\GroupeType | No errors. |
App\Entity\Segment | No errors. |
App\Entity\UserGroupeException | No errors. |
App\Entity\Partenaire | No errors. |
App\Entity\CompteRenduReunion | No errors. |
App\Entity\FormationSession | No errors. |
App\Entity\Formation | No errors. |
App\Entity\SliderAccueil | No errors. |