https://cimef-international.org/nos-thematiques

Query Metrics

6 Database Queries
6 Different statements
13.26 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.79 ms
(58.71%)
1
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.slug AS slug_2, t0_.description AS description_3, COUNT(t1_.id) AS sclr_4 FROM thematiques t0_ INNER JOIN themes t1_ ON (t0_.id = t1_.thematique_id) GROUP BY t0_.id, t0_.nom, t0_.slug, t0_.description
Parameters:
[]
2.83 ms
(21.32%)
1
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.slug AS slug_2, t0_.description AS description_3, COUNT(t1_.id) AS sclr_4 FROM thematiques t0_ INNER JOIN themes t1_ ON (t0_.id = t1_.thematique_id) WHERE t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY t0_.id, t0_.nom, t0_.slug, t0_.description
Parameters:
[
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
  11
  12
]
1.08 ms
(8.14%)
1
SELECT DISTINCT t0_.id AS id_0 FROM thematiques t0_ INNER JOIN themes t1_ ON (t0_.id = t1_.thematique_id) GROUP BY t0_.id, t0_.nom, t0_.slug, t0_.description LIMIT 12
Parameters:
[]
0.74 ms
(5.61%)
1
SELECT count(DISTINCT t0_.id) AS sclr_0 FROM thematiques t0_ INNER JOIN themes t1_ ON (t0_.id = t1_.thematique_id) GROUP BY t0_.id, t0_.nom, t0_.slug, t0_.description
Parameters:
[]
0.56 ms
(4.25%)
1
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:
[]
0.26 ms
(1.97%)
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:
[]

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\Managements No errors.
App\Entity\Thematiques No errors.
App\Entity\Themes No errors.
App\Entity\Mentions No errors.