Query Metrics
6
Database Queries
6
Different statements
4.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.36 ms (27.73%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.thematique_id AS thematique_id_5 FROM themes t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"maitrise-des-systemes-d-information-geographique-sig-sig-bureautique-arcgis-gps-base-de-donnees-et-geoportail"
]
|
|
1.15 ms (23.47%) |
1 |
SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.prix AS prix_2, f0_.devise AS devise_3, t1_.nom AS nom_4, t2_.nom AS nom_5, v3_.nom AS nom_6, v3_.pays AS pays_7, f0_.created_at AS created_at_8, t1_.slug AS slug_9, t1_.description AS description_10, f0_.devise AS devise_11, v3_.longitude AS longitude_12, v3_.latitude AS latitude_13 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v3_ ON (f0_.ville_id = v3_.id) INNER JOIN thematiques t2_ ON (t1_.thematique_id = t2_.id) WHERE f0_.theme_id = ? GROUP BY f0_.id ORDER BY f0_.created_at DESC LIMIT 1
Parameters:
[
41
]
|
|
0.93 ms (19.02%) |
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.53 ms (10.81%) |
1 |
SELECT f0_.id AS id_0, v1_.nom AS nom_1, v1_.pays AS pays_2 FROM formations f0_ INNER JOIN themes t2_ ON (f0_.theme_id = t2_.id) INNER JOIN villes v1_ ON (f0_.ville_id = v1_.id) INNER JOIN thematiques t3_ ON (t2_.thematique_id = t3_.id) WHERE f0_.theme_id = ?
Parameters:
[
41
]
|
|
0.48 ms (9.70%) |
1 |
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:
[
"gestion-de-projets-et-programme"
]
|
|
0.46 ms (9.28%) |
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\Managements | No errors. |
| App\Entity\Thematiques | No errors. |
| App\Entity\Themes | No errors. |
| App\Entity\Formations | No errors. |
| App\Entity\Villes | No errors. |
| App\Entity\Mentions | No errors. |