GET https://wpe.jeromelaguel.fr/tournois/fr?page=1

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
90.57 ms
(68.18%)
1
SELECT DISTINCT e0_.id AS id_0, e0_.titre AS titre_1, e0_.description AS description_2, e0_.creation AS creation_3, e0_.termine AS termine_4, e0_.date_creation AS date_creation_5, e0_.encours AS encours_6, e0_.publier AS publier_7, e0_.config_id AS config_id_8, e0_.style_id AS style_id_9 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id LEFT JOIN selection s2_ ON c1_.id = s2_.config_id WHERE e0_.publier = ? ORDER BY c1_.date_debut ASC LIMIT 6
Parameters:
[
  1
]
27.19 ms
(20.47%)
1
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.indicatif AS indicatif_2, p0_.continent_id AS continent_id_3, p0_.langue_id AS langue_id_4 FROM pays p0_ INNER JOIN langue l1_ ON p0_.langue_id = l1_.id WHERE l1_.id = ?
Parameters:
[
  1
]
10.16 ms
(7.65%)
1
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id LEFT JOIN selection s2_ ON c1_.id = s2_.config_id WHERE e0_.encours = 1 AND e0_.publier = 1
Parameters:
[]
1.84 ms
(1.39%)
1
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.langue_id AS langue_id_2 FROM continent c0_ INNER JOIN langue l1_ ON c0_.langue_id = l1_.id WHERE l1_.id = ?
Parameters:
[
  1
]
1.67 ms
(1.26%)
1
SELECT l0_.id AS id_0 FROM langue l0_ WHERE l0_.code = ?
Parameters:
[
  "fr"
]
1.40 ms
(1.05%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM niveau 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\Langue No errors.
App\Entity\Pays No errors.
App\Entity\Continent No errors.
App\Entity\Niveau No errors.
App\Entity\Evenement No errors.
App\Entity\Config No errors.
App\Entity\Selection No errors.
App\Entity\Style No errors.