Query Metrics

3 Database Queries
3 Different statements
2.55 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.57 ms
SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.prix AS prix_2, f0_.devise AS devise_3, f0_.annee AS annee_4, t1_.nom AS nom_5, t2_.nom AS nom_6, v3_.nom AS nom_7, v3_.pays AS pays_8, f0_.created_at AS created_at_9, t1_.slug AS slug_10, t1_.description AS description_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 t1_.slug = ? AND f0_.id = ?
Parameters:
[
  "cyber-securite-and-gestion-de-la-fraude-en-telecom"
  "4335"
]
2 1.78 ms
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, v3_.longitude AS longitude_11, v3_.latitude AS latitude_12, f0_.image AS image_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 t1_.slug = ? AND f0_.id <> ?
Parameters:
[
  "cyber-securite-and-gestion-de-la-fraude-en-telecom"
  "4335"
]
3 0.21 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\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\Themes No errors.
App\Entity\Villes No errors.
App\Entity\Thematiques No errors.
App\Entity\Mentions No errors.