Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 0.49 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.20 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:
[
  "finance-comptabilite-audit-et-controle"
]
3 0.39 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:
[
  "sap-mm-gestion-des-achats-et-des-stocks"
]
4 0.09 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:
[
  "finance-comptabilite-audit-et-controle"
]
5 0.40 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:
[
  "sap-mm-gestion-des-achats-et-des-stocks"
  "finance-comptabilite-audit-et-controle"
]
6 0.18 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:
[
  284
]
7 0.15 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
  • 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.