Query Metrics
6
Database Queries
6
Different statements
1.47 ms
Query time
1
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.32 ms |
SELECT COUNT(t0_.id) AS sclr_0 FROM thematique t0_ WHERE t0_.slug = ?
Parameters:
[
"developpement"
]
|
| 2 | 0.19 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM sous_thematique s0_ WHERE s0_.slug = ?
Parameters:
[
"java"
]
|
| 3 | 0.35 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.breadcrumb AS breadcrumb_2, b0_.slug AS slug_3, b0_.keywords AS keywords_4, b0_.description AS description_5, b0_.rt_time AS rt_time_6, b0_.view AS view_7, b0_.content AS content_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.bigtitle AS bigtitle_11, b0_.blogimage_id AS blogimage_id_12 FROM blog b0_ INNER JOIN blog_thematique b2_ ON b0_.id = b2_.blog_id INNER JOIN thematique t1_ ON t1_.id = b2_.thematique_id INNER JOIN blog_sous_thematique b4_ ON b0_.id = b4_.blog_id INNER JOIN sous_thematique s3_ ON s3_.id = b4_.sous_thematique_id WHERE t1_.slug = ? AND s3_.slug = ?
Parameters:
[ "developpement" "java" ] |
| 4 | 0.29 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM sous_thematique s0_ INNER JOIN thematique_sous_thematique t2_ ON s0_.id = t2_.sous_thematique_id INNER JOIN thematique t1_ ON t1_.id = t2_.thematique_id WHERE t1_.slug = ? AND s0_.slug <> ?
Parameters:
[ "developpement" "java" ] |
| 5 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM sous_thematique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"java"
]
|
| 6 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM thematique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"developpement"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| formation | doctrine.dbal.formation_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\Thematique | No errors. |
| App\Entity\SousThematique | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\PublicationImage |
|