GET http://dev.coach-dance.lefief-cachan.fr/figures/slow-waltz-backward-lock-step

Query Metrics

3 Database Queries
3 Different statements
0.85 ms Query time
0 Invalid entities
11 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.41 ms
(48.45%)
1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.dance AS dance_3, f0_.duration AS duration_4, f0_.steps AS steps_5, f0_.rythm AS rythm_6, f0_.rhythms AS rhythms_7, f0_.international_level AS international_level_8, f0_.ffd_level AS ffd_level_9, f0_.role AS role_10, f0_.tempo AS tempo_11, f0_.created_at AS created_at_12, f0_.updated_at AS updated_at_13, CASE f0_.ffd_level WHEN 'jaune' THEN 1 WHEN 'orange' THEN 2 WHEN 'vert' THEN 3 WHEN 'violet' THEN 4 WHEN 'bleu' THEN 5 WHEN 'rouge' THEN 6 ELSE 999 END AS sclr_14 FROM figure f0_ WHERE f0_.name IN (?, ?, ?, ?, ?) AND f0_.dance = ? ORDER BY sclr_14 ASC, f0_.name ASC
Parameters:
[
  "SLOW_WALTZ_OPEN_IMPETUS"
  "SLOW_WALTZ_BACK_WHISK"
  "SLOW_WALTZ_UNDERTURNED_OUTSIDE_SPIN"
  "SLOW_WALTZ_HESITATION_CHANGE"
  "SLOW_WALTZ_FALLAWAY_WHISK"
  "SLOW_WALTZ"
]
0.23 ms
(27.01%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.dance AS dance_4, t0.duration AS duration_5, t0.steps AS steps_6, t0.rythm AS rythm_7, t0.rhythms AS rhythms_8, t0.international_level AS international_level_9, t0.ffd_level AS ffd_level_10, t0.role AS role_11, t0.tempo AS tempo_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM figure t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "slow-waltz-backward-lock-step"
]
0.21 ms
(24.54%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.target_name AS target_name_3, t0.start_at_step AS start_at_step_4, t0.follow_step AS follow_step_5, t0.position AS position_6, t0.figure_id AS figure_id_7 FROM figure_next_rule t0 WHERE t0.figure_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  1096
]

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\Figure 6
App\Entity\FigureNextRule 5

Entities Mapping

Class Mapping errors
App\Entity\Figure No errors.
App\Entity\FigureNextRule No errors.