Query Metrics

7 Database Queries
6 Different statements
1.47 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.46 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 10
Parameters:
[]
2 0.17 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:
[
  "finances-publiques"
]
3 0.14 ms
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:
[
  "gestion-des-finances-publiques-et-cartographie-des-risques-dans-le-nouveau-cadre-harmonise-des-finances-publiques-uemoa-cemac"
]
4 0.07 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:
[
  "finances-publiques"
]
5 0.34 ms
SELECT t0_.nom AS nom_0, t0_.slug AS slug_1, t1_.slug AS slug_2, t0_.description AS description_3, v2_.longitude AS longitude_4, v2_.latitude AS latitude_5 FROM formations f3_ INNER JOIN themes t0_ ON (f3_.theme_id = t0_.id) INNER JOIN thematiques t1_ ON (t0_.thematique_id = t1_.id) INNER JOIN villes v2_ ON (f3_.ville_id = v2_.id) WHERE t0_.slug = ? AND t1_.slug = ? ORDER BY f3_.created_at DESC LIMIT 1
Parameters:
[
  "gestion-des-finances-publiques-et-cartographie-des-risques-dans-le-nouveau-cadre-harmonise-des-finances-publiques-uemoa-cemac"
  "finances-publiques"
]
6 0.16 ms
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:
[
  17
]
7 0.14 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\Formations No errors.
App\Entity\Villes No errors.
App\Entity\Mentions No errors.