https://cimef-international.org/public/index.php/formations/seminaires/internationaux?page=91

Query Metrics

4 Database Queries
4 Different statements
105.77 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
102.47 ms
(96.89%)
1
SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.annee AS annee_2, f0_.prix AS prix_3, f0_.devise AS devise_4, f0_.image AS image_5, f0_.created_at AS created_at_6, t1_.id AS id_7, t1_.nom AS nom_8, t1_.slug AS slug_9, t1_.description AS description_10, t2_.id AS id_11, t2_.nom AS nom_12, t2_.slug AS slug_13, t2_.description AS description_14, v3_.id AS id_15, v3_.nom AS nom_16, v3_.slug AS slug_17, v3_.image AS image_18, v3_.pays AS pays_19, v3_.texte AS texte_20, v3_.longitude AS longitude_21, v3_.latitude AS latitude_22, v3_.adminsid AS adminsid_23, v3_.created_at AS created_at_24, v3_.updated_at AS updated_at_25, f0_.theme_id AS theme_id_26, f0_.ville_id AS ville_id_27, t1_.thematique_id AS thematique_id_28 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_.nom <> ? ORDER BY f0_.created_at DESC
Parameters:
[
  "SHANGHAI"
]
2.54 ms
(2.40%)
1
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.slug AS slug_2, t0_.description AS description_3, t0_.thematique_id AS thematique_id_4 FROM themes t0_
Parameters:
[]
0.48 ms
(0.45%)
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:
[]
0.27 ms
(0.25%)
1
SELECT v0_.id AS id_0, v0_.nom AS nom_1, v0_.slug AS slug_2, v0_.image AS image_3, v0_.pays AS pays_4, v0_.texte AS texte_5, v0_.longitude AS longitude_6, v0_.latitude AS latitude_7, v0_.adminsid AS adminsid_8, v0_.created_at AS created_at_9, v0_.updated_at AS updated_at_10 FROM villes v0_ ORDER BY v0_.nom ASC
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\Themes No errors.
App\Entity\Villes No errors.
App\Entity\Mentions 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\Thematiques No errors.