Query Metrics

7 Database Queries
7 Different statements
2.68 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.63 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.slug AS slug_3, t0.session AS session_4, t0.type AS type_5, t0.prix AS prix_6, t0.devise AS devise_7, t0.adminsid AS adminsid_8, t0.createdat AS createdat_9, t0.updatedat AS updatedat_10, t0.ville_id AS ville_id_11 FROM certificats t0
Parameters:
[]
2 0.33 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 5
Parameters:
[]
3 0.44 ms
SELECT c0_.id AS id_0, c0_.session AS session_1, c0_.prix AS prix_2, c0_.slug AS slug_3, c0_.devise AS devise_4, c0_.theme AS theme_5, v1_.nom AS nom_6, v1_.pays AS pays_7, c0_.createdat AS createdat_8, c0_.type AS type_9 FROM certificats c0_ INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id) WHERE c0_.slug = ?
Parameters:
[
  "Certificat-professionnel-en-PPP-Partenariats-Public-Prive-Niveau-1-Delivre-par-BEM-et-KEDGE-Business-School-Paris"
]
4 0.39 ms
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM certificats c0_ INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id) WHERE c0_.slug = ?
Parameters:
[
  "Certificat-professionnel-en-PPP-Partenariats-Public-Prive-Niveau-1-Delivre-par-BEM-et-KEDGE-Business-School-Paris"
]
5 0.29 ms
SELECT DISTINCT c0_.id AS id_0 FROM certificats c0_ INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id) WHERE c0_.slug = ? LIMIT 12
Parameters:
[
  "Certificat-professionnel-en-PPP-Partenariats-Public-Prive-Niveau-1-Delivre-par-BEM-et-KEDGE-Business-School-Paris"
]
6 0.34 ms
SELECT c0_.id AS id_0, c0_.session AS session_1, c0_.prix AS prix_2, c0_.slug AS slug_3, c0_.devise AS devise_4, c0_.theme AS theme_5, v1_.nom AS nom_6, v1_.pays AS pays_7, c0_.createdat AS createdat_8, c0_.type AS type_9 FROM certificats c0_ INNER JOIN villes v1_ ON (c0_.ville_id = v1_.id) WHERE c0_.slug = ? AND c0_.id IN (?, ?, ?, ?, ?)
Parameters:
[
  "Certificat-professionnel-en-PPP-Partenariats-Public-Prive-Niveau-1-Delivre-par-BEM-et-KEDGE-Business-School-Paris"
  1
  2
  4
  5
  6
]
7 0.25 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\Certificats No errors.
App\Entity\Villes No errors.
App\Entity\Managements No errors.
App\Entity\Mentions No errors.