Query Metrics
4
Database Queries
4
Different statements
1.69 ms
Query time
1
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 ms |
SELECT COUNT(t0_.id) AS sclr_0 FROM thematique t0_ WHERE t0_.slug = ?
Parameters:
[
"cloud-computing"
]
|
| 2 | 0.40 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 LEFT JOIN blog_sous_thematique b4_ ON b0_.id = b4_.blog_id LEFT JOIN sous_thematique s3_ ON s3_.id = b4_.sous_thematique_id WHERE t1_.slug = ? AND s3_.id IS NULL
Parameters:
[
"cloud-computing"
]
|
| 3 | 0.69 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 = ?
Parameters:
[
"cloud-computing"
]
|
| 4 | 0.22 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:
[
"cloud-computing"
]
|
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\Blog | No errors. |
| App\Entity\SousThematique | No errors. |
| App\Entity\PublicationImage |
|