Query Metrics
7
Database Queries
7
Different statements
4.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.63 ms |
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.slug AS slug_3, t0.image AS image_4, t0.ville AS ville_5, t0.devise AS devise_6, t0.datedebut AS datedebut_7, t0.datefin AS datefin_8, t0.prix AS prix_9, t0.texte AS texte_10, t0.adminsid AS adminsid_11, t0.createdat AS createdat_12, t0.updatedat AS updatedat_13 FROM managements t0 ORDER BY t0.id DESC LIMIT 5
Parameters:
[] |
| 2 | 0.29 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4 FROM thematiques t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"mine-petrole"
]
|
| 3 | 1.15 ms |
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.slug AS slug_2, t0_.description AS description_3 FROM themes t0_ WHERE t0_.thematique_id = ?
Parameters:
[
"6"
]
|
| 4 | 1.03 ms |
SELECT count(DISTINCT t0_.id) AS sclr_0 FROM themes t0_ WHERE t0_.thematique_id = ?
Parameters:
[
"6"
]
|
| 5 | 0.68 ms |
SELECT DISTINCT t0_.id AS id_0 FROM themes t0_ WHERE t0_.thematique_id = ? LIMIT 12 OFFSET 96
Parameters:
[
"6"
]
|
| 6 | 0.22 ms |
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.slug AS slug_2, t0_.description AS description_3 FROM themes t0_ WHERE t0_.thematique_id = ? AND t0_.id IN (?)
Parameters:
[ "6" 840 ] |
| 7 | 0.30 ms |
SELECT t0.id AS id_1, t0.titremen AS titremen_2, t0.slug AS slug_3, t0.detailmen AS detailmen_4, t0.statutmen AS statutmen_5, t0.adminsid AS adminsid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mentions t0
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\Managements | No errors. |
| App\Entity\Thematiques | No errors. |
| App\Entity\Themes | No errors. |
| App\Entity\Mentions | No errors. |