Query Metrics
7
Database Queries
7
Different statements
6.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.11 ms (33.10%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte AS texte_6, t0.statut AS statut_7, t0.adminsid AS adminsid_8, t0.createdat AS createdat_9, t0.updatedat AS updatedat_10 FROM actualites t0 WHERE t0.statut = ? ORDER BY t0.createdat DESC
Parameters:
[
"Publié"
]
|
|
1.00 ms (15.72%) |
1 |
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM actualites a0_ WHERE a0_.statut = ?
Parameters:
[
"Publié"
]
|
|
0.83 ms (13.09%) |
1 |
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.slug AS slug_2, a0_.image AS image_3, a0_.resume AS resume_4, a0_.texte AS texte_5, a0_.statut AS statut_6, a0_.adminsid AS adminsid_7, a0_.createdat AS createdat_8, a0_.updatedat AS updatedat_9 FROM actualites a0_ WHERE a0_.statut = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.createdat DESC
Parameters:
[ "Publié" 12 7 2 10 4 3 6 5 8 9 11 13 ] |
|
0.70 ms (10.93%) |
1 |
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:
[] |
|
0.65 ms (10.20%) |
1 |
SELECT DISTINCT a0_.id AS id_0, a0_.createdat AS createdat_1 FROM actualites a0_ WHERE a0_.statut = ? ORDER BY a0_.createdat DESC LIMIT 12
Parameters:
[
"Publié"
]
|
|
0.59 ms (9.33%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte AS texte_6, t0.statut AS statut_7, t0.adminsid AS adminsid_8, t0.createdat AS createdat_9, t0.updatedat AS updatedat_10 FROM actualites t0 WHERE t0.statut = ? ORDER BY t0.createdat DESC LIMIT 4
Parameters:
[
"Publié"
]
|
|
0.49 ms (7.63%) |
1 |
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\Actualites | No errors. |
| App\Entity\Managements | No errors. |
| App\Entity\Mentions | No errors. |