Query Metrics
3
Database Queries
3
Different statements
9.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.77 ms |
SELECT a0_.id AS id_0, COALESCE(t1_.content, a0_.titre) AS titre_1, COALESCE(t2_.content, a0_.description_courte) AS description_courte_2, COALESCE(t3_.content, a0_.contenu) AS contenu_3, COALESCE(t4_.content, a0_.contenu2) AS contenu2_4, COALESCE(t5_.content, a0_.meta_description) AS meta_description_5, a0_.img_s AS img_s_6, a0_.img_xl AS img_xl_7, a0_.img_contenu AS img_contenu_8, a0_.date_creation AS date_creation_9, a0_.date_update AS date_update_10, a0_.date_delete AS date_delete_11, a0_.publication AS publication_12, c6_.id AS id_13, COALESCE(t7_.content, c6_.nom) AS nom_14, c6_.active AS active_15, c6_.date_creation AS date_creation_16, c6_.slug AS slug_17 FROM articles_blog a0_ LEFT JOIN articles_blog_categorie a8_ ON a0_.id = a8_.articles_blog_id LEFT JOIN categorie c6_ ON c6_.id = a8_.categorie_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'titre' AND t1_.object_class = 'App\\Entity\\ArticlesBlog' AND t1_.foreign_key = a0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'description_courte' AND t2_.object_class = 'App\\Entity\\ArticlesBlog' AND t2_.foreign_key = a0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'contenu' AND t3_.object_class = 'App\\Entity\\ArticlesBlog' AND t3_.foreign_key = a0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'contenu2' AND t4_.object_class = 'App\\Entity\\ArticlesBlog' AND t4_.foreign_key = a0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'meta_description' AND t5_.object_class = 'App\\Entity\\ArticlesBlog' AND t5_.foreign_key = a0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'nom' AND t7_.object_class = 'App\\Entity\\Categorie' AND t7_.foreign_key = c6_.id WHERE a0_.id = ?
Parameters:
[
9
]
|
| 2 | 6.17 ms |
SELECT a0_.id AS id_0, COALESCE(t1_.content, a0_.titre) AS titre_1, COALESCE(t2_.content, a0_.description_courte) AS description_courte_2, COALESCE(t3_.content, a0_.contenu) AS contenu_3, COALESCE(t4_.content, a0_.contenu2) AS contenu2_4, COALESCE(t5_.content, a0_.meta_description) AS meta_description_5, a0_.img_s AS img_s_6, a0_.img_xl AS img_xl_7, a0_.img_contenu AS img_contenu_8, a0_.date_creation AS date_creation_9, a0_.date_update AS date_update_10, a0_.date_delete AS date_delete_11, a0_.publication AS publication_12, c6_.id AS id_13, COALESCE(t7_.content, c6_.nom) AS nom_14, c6_.active AS active_15, c6_.date_creation AS date_creation_16, c6_.slug AS slug_17 FROM articles_blog a0_ INNER JOIN articles_blog_categorie a8_ ON a0_.id = a8_.articles_blog_id INNER JOIN categorie c6_ ON c6_.id = a8_.categorie_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'titre' AND t1_.object_class = 'App\\Entity\\ArticlesBlog' AND t1_.foreign_key = a0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'description_courte' AND t2_.object_class = 'App\\Entity\\ArticlesBlog' AND t2_.foreign_key = a0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'contenu' AND t3_.object_class = 'App\\Entity\\ArticlesBlog' AND t3_.foreign_key = a0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'contenu2' AND t4_.object_class = 'App\\Entity\\ArticlesBlog' AND t4_.foreign_key = a0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'meta_description' AND t5_.object_class = 'App\\Entity\\ArticlesBlog' AND t5_.foreign_key = a0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'nom' AND t7_.object_class = 'App\\Entity\\Categorie' AND t7_.foreign_key = c6_.id WHERE a0_.publication = ? AND a0_.id <> ? ORDER BY a0_.date_creation DESC LIMIT 2
Parameters:
[ 1 9 ] |
| 3 | 0.31 ms |
SELECT DISTINCT c0_.id AS id_0, COALESCE(t1_.content, c0_.nom) AS nom_1, c0_.active AS active_2, c0_.date_creation AS date_creation_3, c0_.slug AS slug_4 FROM categorie c0_ INNER JOIN articles_blog_categorie a8_ ON c0_.id = a8_.categorie_id INNER JOIN articles_blog a2_ ON a2_.id = a8_.articles_blog_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'nom' AND t1_.object_class = 'App\\Entity\\Categorie' AND t1_.foreign_key = c0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'titre' AND t3_.object_class = 'App\\Entity\\ArticlesBlog' AND t3_.foreign_key = a2_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'description_courte' AND t4_.object_class = 'App\\Entity\\ArticlesBlog' AND t4_.foreign_key = a2_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'contenu' AND t5_.object_class = 'App\\Entity\\ArticlesBlog' AND t5_.foreign_key = a2_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'contenu2' AND t6_.object_class = 'App\\Entity\\ArticlesBlog' AND t6_.foreign_key = a2_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'meta_description' AND t7_.object_class = 'App\\Entity\\ArticlesBlog' AND t7_.foreign_key = a2_.id WHERE a2_.publication = ? ORDER BY COALESCE(t1_.content, c0_.nom) ASC
Parameters:
[
1
]
|
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\ArticlesBlog | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Translation | No errors. |
| App\Entity\Reference | No errors. |