Query Metrics

7 Database Queries
6 Different statements
1.59 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
0.53 ms
(33.13%)
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 10
Parameters:
[]
0.39 ms
(24.26%)
1
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-administrative-financiere-et-comptable-des-projets-et-programmes"
  "gestion-de-projets-et-programme"
]
0.23 ms
(14.57%)
2
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.17 ms
(11.00%)
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:
[
  51
]
0.15 ms
(9.43%)
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:
[
  "gestion-administrative-financiere-et-comptable-des-projets-et-programmes"
]
0.12 ms
(7.61%)
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
  • The field 'App\Entity\Formations#annee' has the property type 'int' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\Villes No errors.
App\Entity\Mentions No errors.