Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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

[
  "SLOW_WALTZ_FALLAWAY_NATURAL_TURN"
  "SLOW_WALTZ_NATURAL_SPIN_TURN"
  "SLOW_WALTZ_HESITATION_CHANGE"
  "SLOW_WALTZ_LEFT_WHISK"
  "SLOW_WALTZ_CHASSE_FROM_PP"
  "SLOW_WALTZ_CROSS_HESITATION_FROM_PP"
  "SLOW_WALTZ_WING"
  "SLOW_WALTZ_PASSING_NATURAL_TURN"
  "SLOW_WALTZ"
]

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

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 ('SLOW_WALTZ_FALLAWAY_NATURAL_TURN', 'SLOW_WALTZ_NATURAL_SPIN_TURN', 'SLOW_WALTZ_HESITATION_CHANGE', 'SLOW_WALTZ_LEFT_WHISK', 'SLOW_WALTZ_CHASSE_FROM_PP', 'SLOW_WALTZ_CROSS_HESITATION_FROM_PP', 'SLOW_WALTZ_WING', 'SLOW_WALTZ_PASSING_NATURAL_TURN') AND f0_.dance = 'SLOW_WALTZ' ORDER BY sclr_14 ASC, f0_.name ASC;

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

[
  "slow-waltz-weave-in-waltz-time"
]

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

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 = 'slow-waltz-weave-in-waltz-time' LIMIT 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

[
  1100
]

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

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 = 1100 ORDER BY t0.position ASC, t0.id ASC;