GET http://dev.coach-dance.lefief-cachan.fr/figures/slow-waltz-hesitation-change

Query Metrics

3 Database Queries
3 Different statements
1.77 ms Query time
0 Invalid entities
21 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.74 ms
(41.51%)
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_REVERSE_TURN"
  "SLOW_WALTZ_PROGRESSIVE_CHASSE_TO_RIGHT"
  "SLOW_WALTZ_DOUBLE_REVERSE_SPIN"
  "SLOW_WALTZ_OPEN_TELEMARK"
  "SLOW_WALTZ_TELEMARK"
  "SLOW_WALTZ_FALLAWAY_REVERSE_AND_SLIP_PIVOT"
  "SLOW_WALTZ_DRAG_HESITATION"
  "SLOW_WALTZ_CLOSED_CHANGE_ON_LEFT_FOOT"
  "SLOW_WALTZ_WHISK"
  "SLOW_WALTZ_CONTRA_CHECK"
  "SLOW_WALTZ"
]
0.57 ms
(32.15%)
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:
[
  1090
]
0.47 ms
(26.33%)
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-hesitation-change"
]

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 11
App\Entity\FigureNextRule 10

Entities Mapping

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