https://nouveau.cimef-international.com/seminaires-internationaux

Query Metrics

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

Queries

Group similar statements

# Time Info
1 11.52 ms
SELECT count(DISTINCT f0_.id) AS sclr_0 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN villes v2_ ON f0_.ville_id = v2_.id INNER JOIN thematiques t3_ ON t1_.thematique_id = t3_.id WHERE f0_.id IN (SELECT MAX(f4_.id) AS sclr_1 FROM formations f4_ GROUP BY f4_.theme_id)
Parameters:
[]
2 3.60 ms
SELECT DISTINCT f0_.id AS id_0, f0_.created_at AS created_at_1 FROM formations f0_ INNER JOIN themes t1_ ON f0_.theme_id = t1_.id INNER JOIN villes v2_ ON f0_.ville_id = v2_.id INNER JOIN thematiques t3_ ON t1_.thematique_id = t3_.id WHERE f0_.id IN (SELECT MAX(f4_.id) AS sclr_2 FROM formations f4_ GROUP BY f4_.theme_id) ORDER BY f0_.created_at DESC LIMIT 12
Parameters:
[]
3 2.42 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 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 f0_.id IN (SELECT MAX(f4_.id) AS sclr_10 FROM formations f4_ GROUP BY f4_.theme_id) AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.created_at DESC
Parameters:
[
  35
  50
  30
  40
  45
  5
  15
  25
  10
  20
]
4 1.11 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 No errors.
App\Entity\Themes No errors.
App\Entity\Villes No errors.
App\Entity\Thematiques No errors.
App\Entity\Mentions No errors.