GET http://sport.nktec.fr/exercice/approche-et-frappe-en-zone

Query Metrics

7 Database Queries
7 Different statements
23.12 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 5.59 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.instructions AS instructions_5, t0.video_url AS video_url_6, t0.thumbnail AS thumbnail_7, t0.duration AS duration_8, t0.players_min AS players_min_9, t0.players_max AS players_max_10, t0.difficulty AS difficulty_11, t0.published AS published_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM exercise t0 WHERE t0.slug = ? AND t0.published = ? LIMIT 1
Parameters:
[
  "approche-et-frappe-en-zone"
  1
]
2 4.79 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM exercise_category t0 INNER JOIN exercise_exercise_category ON t0.id = exercise_exercise_category.exercise_category_id WHERE exercise_exercise_category.exercise_id = ?
Parameters:
[
  4
]
3 5.47 ms
SELECT DISTINCT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.instructions AS instructions_4, e0_.video_url AS video_url_5, e0_.thumbnail AS thumbnail_6, e0_.duration AS duration_7, e0_.players_min AS players_min_8, e0_.players_max AS players_max_9, e0_.difficulty AS difficulty_10, e0_.published AS published_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13 FROM exercise e0_ INNER JOIN exercise_exercise_category e2_ ON e0_.id = e2_.exercise_id INNER JOIN exercise_category e1_ ON e1_.id = e2_.exercise_category_id WHERE e1_.id IN (?) AND e0_.id <> ? AND e0_.published = true LIMIT 3
Parameters:
[
  4
  4
]
4 1.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM exercise_level t0 INNER JOIN exercise_exercise_level ON t0.id = exercise_exercise_level.exercise_level_id WHERE exercise_exercise_level.exercise_id = ?
Parameters:
[
  4
]
5 1.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM age_group t0 INNER JOIN exercise_age_group ON t0.id = exercise_age_group.age_group_id WHERE exercise_age_group.exercise_id = ?
Parameters:
[
  4
]
6 1.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM skill t0 INNER JOIN exercise_skill ON t0.id = exercise_skill.skill_id WHERE exercise_skill.exercise_id = ?
Parameters:
[
  4
]
7 1.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM equipment t0 INNER JOIN exercise_equipment ON t0.id = exercise_equipment.equipment_id WHERE exercise_equipment.exercise_id = ?
Parameters:
[
  4
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Exercise 1
App\Entity\ExerciseCategory 1
App\Entity\ExerciseLevel 1
App\Entity\AgeGroup 1
App\Entity\Skill 1
App\Entity\Equipment 1

Entities Mapping

Class Mapping errors
App\Entity\Exercise No errors.
App\Entity\ExerciseCategory No errors.
App\Entity\ExerciseLevel No errors.
App\Entity\AgeGroup No errors.
App\Entity\Skill No errors.
App\Entity\Equipment No errors.