Query Metrics
23
Database Queries
9
Different statements
20.11 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
11.04 ms (54.91%) |
1 |
SELECT t0.id AS id_1, t0.bloc1 AS bloc1_2, t0.bloc_service1 AS bloc_service1_3, t0.bloc_service2 AS bloc_service2_4, t0.bloc_service3 AS bloc_service3_5, t0.bloc_service4 AS bloc_service4_6, t0.bloc_service5 AS bloc_service5_7, t0.bloc_service6 AS bloc_service6_8, t0.bloc_checkup AS bloc_checkup_9, t0.bloc_service7 AS bloc_service7_10, t0.bloc_service8 AS bloc_service8_11, t0.bloc_service9 AS bloc_service9_12, t0.bloc_temoignage1 AS bloc_temoignage1_13, t0.bloc_temoignage2 AS bloc_temoignage2_14, t0.temoignage1_titre AS temoignage1_titre_15, t0.temoignage2_titre AS temoignage2_titre_16, t0.locale AS locale_17, t0.translatable_id AS translatable_id_18 FROM medecine_generale_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
4.31 ms (21.43%) |
1 |
SELECT t0.id AS id_1 FROM medecine_generale t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
1.78 ms (8.84%) |
10 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM blog_categorie_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
29
]
|
1.17 ms (5.83%) |
3 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM blog_article_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
49
]
|
0.73 ms (3.65%) |
3 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.category_parent_id AS category_parent_id_3 FROM blog_categorie t0 INNER JOIN blog_article_blog_categorie ON t0.id = blog_article_blog_categorie.blog_categorie_id WHERE blog_article_blog_categorie.blog_article_id = ?
Parameters:
[
49
]
|
0.33 ms (1.66%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"c1dr"
]
|
0.30 ms (1.51%) |
1 |
SELECT b0_.id AS id_0, b0_.meta_titre AS meta_titre_1, b0_.meta_desc AS meta_desc_2, b0_.image AS image_3, b0_.is_active AS is_active_4, b0_.date_publication AS date_publication_5, b0_.auteur_id AS auteur_id_6 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale = ? AND b1_.slug IS NOT NULL) ORDER BY b0_.date_publication DESC LIMIT 3
Parameters:
[
"fr"
]
|
0.23 ms (1.14%) |
2 |
SELECT DATABASE()
Parameters:
[] |
0.21 ms (1.03%) |
1 |
SELECT b0_.id AS id_0, b0_.meta_titre AS meta_titre_1, b0_.meta_desc AS meta_desc_2, b0_.image AS image_3, b0_.is_active AS is_active_4, b0_.date_publication AS date_publication_5, b0_.auteur_id AS auteur_id_6 FROM blog_article b0_ ORDER BY b0_.date_publication DESC LIMIT 3
Parameters:
[] |
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\Service\MedecineGenerale | No errors. |
App\Entity\Service\MedecineGeneraleTranslation | No errors. |
App\Entity\BlogArticle | No errors. |
App\Entity\BlogArticleTranslation | No errors. |
App\Entity\User | No errors. |
App\Entity\BlogCategorie | No errors. |
App\Entity\BlogCategorieTranslation | No errors. |