Query Metrics
7
Database Queries
7
Different statements
12.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.95 ms (24.21%) |
1 |
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.alias = ? LIMIT 1
Parameters:
[
"test-video"
]
|
|
2.01 ms (16.52%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lien AS lien_3 FROM article_lien t0 INNER JOIN article_article_lien ON t0.id = article_article_lien.article_lien_id WHERE article_article_lien.article_id = ?
Parameters:
[
177
]
|
|
1.99 ms (16.32%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.alias AS alias_6 FROM thematique t0 INNER JOIN article_thematique ON t0.id = article_thematique.thematique_id WHERE article_thematique.article_id = ?
Parameters:
[
177
]
|
|
1.66 ms (13.60%) |
1 |
SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.date AS date_3, t0.visible AS visible_4, t0.auteur_id AS auteur_id_5, t0.parent_id AS parent_id_6, t0.article_id AS article_id_7 FROM article_commentaire t0 WHERE t0.article_id = ?
Parameters:
[
177
]
|
|
1.42 ms (11.66%) |
1 |
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.alias = ? LIMIT 1
Parameters:
[
"null"
]
|
|
1.08 ms (8.87%) |
1 |
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
]
|
|
1.07 ms (8.81%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.libelle AS libelle_3, t0.ordre AS ordre_4 FROM article_type t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\GroupeType | No errors. |