Query Metrics
3
Database Queries
3
Different statements
0.69 ms
Query time
0
Invalid entities
13
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.19 ms |
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-cross-hesitation-from-pp"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.16 ms |
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:
[
1101
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.34 ms |
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_BACK_WHISK" "SLOW_WALTZ_OUTSIDE_SPIN" "SLOW_WALTZ_OUTSIDE_CHANGE" "SLOW_WALTZ_OPEN_IMPETUS" "SLOW_WALTZ_BACKWARD_LOCK_STEP" "SLOW_WALTZ_HESITATION_CHANGE" "SLOW_WALTZ" ]
|
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 | 7 |
| App\Entity\FigureNextRule | 6 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Figure | No errors. |
| App\Entity\FigureNextRule | No errors. |