https://ns2.cimef-international.org/public/index.php/formations/shanghai

Query Metrics

4 Database Queries
4 Different statements
5.81 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.96 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.slug AS slug_3, t0.ville AS ville_4, t0.session AS session_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 FROM themeshanghai t0
Parameters:
[]
2 0.90 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 1.50 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_.image AS image_4, f0_.created_at AS created_at_5, t1_.id AS id_6, t1_.nom AS nom_7, t1_.slug AS slug_8, t1_.description AS description_9, t2_.id AS id_10, t2_.nom AS nom_11, t2_.slug AS slug_12, t2_.description AS description_13, v3_.id AS id_14, v3_.nom AS nom_15, v3_.slug AS slug_16, v3_.image AS image_17, v3_.pays AS pays_18, v3_.texte AS texte_19, v3_.longitude AS longitude_20, v3_.latitude AS latitude_21, v3_.adminsid AS adminsid_22, v3_.created_at AS created_at_23, v3_.updated_at AS updated_at_24, f0_.theme_id AS theme_id_25, f0_.ville_id AS ville_id_26, t1_.thematique_id AS thematique_id_27 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN thematiques t2_ ON t1_.thematique_id = t2_.id INNER JOIN villes v3_ ON f0_.ville_id = v3_.id WHERE v3_.id = ?
Parameters:
[
  "SHANGHAI"
]
4 0.46 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\Themeshanghai No errors.
App\Entity\Managements No errors.
App\Entity\Formations No errors.
App\Entity\Themes No errors.
App\Entity\Thematiques No errors.
App\Entity\Villes No errors.
App\Entity\Mentions No errors.