Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.username AS username_4,
  t0.created_at AS created_at_5,
  t0.locale AS locale_6
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.username AS username_4, t0.created_at AS created_at_5, t0.locale AS locale_6 FROM app_user t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.dance AS dance_2,
  c0_.level AS level_3,
  c0_.metadata AS metadata_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.is_public AS is_public_7,
  f1_.id AS id_8,
  f1_.name AS name_9,
  f1_.created_at AS created_at_10,
  f1_.updated_at AS updated_at_11,
  c2_.id AS id_12,
  c2_.position AS position_13,
  c2_.repeat_count AS repeat_count_14,
  c2_.start_at_step AS start_at_step_15,
  c2_.end_at_step AS end_at_step_16,
  f3_.id AS id_17,
  f3_.name AS name_18,
  f3_.slug AS slug_19,
  f3_.dance AS dance_20,
  f3_.duration AS duration_21,
  f3_.steps AS steps_22,
  f3_.rythm AS rythm_23,
  f3_.rhythms AS rhythms_24,
  f3_.international_level AS international_level_25,
  f3_.ffd_level AS ffd_level_26,
  f3_.role AS role_27,
  f3_.tempo AS tempo_28,
  f3_.created_at AS created_at_29,
  f3_.updated_at AS updated_at_30,
  c4_.id AS id_31,
  c4_.content AS content_32,
  c4_.created_at AS created_at_33,
  c4_.updated_at AS updated_at_34,
  c0_.owner_id AS owner_id_35,
  c0_.folder_id AS folder_id_36,
  f1_.owner_id AS owner_id_37,
  c2_.choreography_id AS choreography_id_38,
  c2_.figure_id AS figure_id_39,
  c4_.step_id AS step_id_40
FROM
  choreography c0_
  LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id
  LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id
  LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id
  LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id
WHERE
  c0_.id IN (?, ?, ?)
  AND c0_.is_public = 1
ORDER BY
  c0_.created_at DESC,
  c2_.position ASC,
  c4_.created_at DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.dance AS dance_2, c0_.level AS level_3, c0_.metadata AS metadata_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.is_public AS is_public_7, f1_.id AS id_8, f1_.name AS name_9, f1_.created_at AS created_at_10, f1_.updated_at AS updated_at_11, c2_.id AS id_12, c2_.position AS position_13, c2_.repeat_count AS repeat_count_14, c2_.start_at_step AS start_at_step_15, c2_.end_at_step AS end_at_step_16, f3_.id AS id_17, f3_.name AS name_18, f3_.slug AS slug_19, f3_.dance AS dance_20, f3_.duration AS duration_21, f3_.steps AS steps_22, f3_.rythm AS rythm_23, f3_.rhythms AS rhythms_24, f3_.international_level AS international_level_25, f3_.ffd_level AS ffd_level_26, f3_.role AS role_27, f3_.tempo AS tempo_28, f3_.created_at AS created_at_29, f3_.updated_at AS updated_at_30, c4_.id AS id_31, c4_.content AS content_32, c4_.created_at AS created_at_33, c4_.updated_at AS updated_at_34, c0_.owner_id AS owner_id_35, c0_.folder_id AS folder_id_36, f1_.owner_id AS owner_id_37, c2_.choreography_id AS choreography_id_38, c2_.figure_id AS figure_id_39, c4_.step_id AS step_id_40 FROM choreography c0_ LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id WHERE c0_.id IN ('177491af-6141-4bd4-b418-caf374ea0548', '97e30211-93d9-41b6-8429-b4c95c1eddbd', 'bea49b0b-1f4f-4f14-8ea6-235bd13e2927') AND c0_.is_public = 1 ORDER BY c0_.created_at DESC, c2_.position ASC, c4_.created_at DESC;

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.created_at AS created_at_2,
  p0_.revoked_at AS revoked_at_3,
  p0_.choreography_id AS choreography_id_4
FROM
  public_choreography_links p0_
WHERE
  p0_.revoked_at IS NULL
  AND p0_.choreography_id IN (?)
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.created_at AS created_at_2, p0_.revoked_at AS revoked_at_3, p0_.choreography_id AS choreography_id_4 FROM public_choreography_links p0_ WHERE p0_.revoked_at IS NULL AND p0_.choreography_id IN ('177491af-6141-4bd4-b418-caf374ea0548') ORDER BY p0_.created_at DESC;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  license l0_
WHERE
  l0_.user_id = ?

SELECT COUNT(l0_.id) AS sclr_0 FROM license l0_ WHERE l0_.user_id = 1;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  choreography c0_
WHERE
  c0_.owner_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM choreography c0_ WHERE c0_.owner_id = 1;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.dance AS dance_2,
  c0_.level AS level_3,
  c0_.metadata AS metadata_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.is_public AS is_public_7,
  f1_.id AS id_8,
  f1_.name AS name_9,
  f1_.created_at AS created_at_10,
  f1_.updated_at AS updated_at_11,
  c2_.id AS id_12,
  c2_.position AS position_13,
  c2_.repeat_count AS repeat_count_14,
  c2_.start_at_step AS start_at_step_15,
  c2_.end_at_step AS end_at_step_16,
  f3_.id AS id_17,
  f3_.name AS name_18,
  f3_.slug AS slug_19,
  f3_.dance AS dance_20,
  f3_.duration AS duration_21,
  f3_.steps AS steps_22,
  f3_.rythm AS rythm_23,
  f3_.rhythms AS rhythms_24,
  f3_.international_level AS international_level_25,
  f3_.ffd_level AS ffd_level_26,
  f3_.role AS role_27,
  f3_.tempo AS tempo_28,
  f3_.created_at AS created_at_29,
  f3_.updated_at AS updated_at_30,
  c4_.id AS id_31,
  c4_.content AS content_32,
  c4_.created_at AS created_at_33,
  c4_.updated_at AS updated_at_34,
  c0_.owner_id AS owner_id_35,
  c0_.folder_id AS folder_id_36,
  f1_.owner_id AS owner_id_37,
  c2_.choreography_id AS choreography_id_38,
  c2_.figure_id AS figure_id_39,
  c4_.step_id AS step_id_40
FROM
  choreography c0_
  LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id
  LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id
  LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id
  LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id
WHERE
  c0_.owner_id = ?
ORDER BY
  c0_.created_at DESC,
  c2_.position ASC,
  c4_.created_at DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.dance AS dance_2, c0_.level AS level_3, c0_.metadata AS metadata_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.is_public AS is_public_7, f1_.id AS id_8, f1_.name AS name_9, f1_.created_at AS created_at_10, f1_.updated_at AS updated_at_11, c2_.id AS id_12, c2_.position AS position_13, c2_.repeat_count AS repeat_count_14, c2_.start_at_step AS start_at_step_15, c2_.end_at_step AS end_at_step_16, f3_.id AS id_17, f3_.name AS name_18, f3_.slug AS slug_19, f3_.dance AS dance_20, f3_.duration AS duration_21, f3_.steps AS steps_22, f3_.rythm AS rythm_23, f3_.rhythms AS rhythms_24, f3_.international_level AS international_level_25, f3_.ffd_level AS ffd_level_26, f3_.role AS role_27, f3_.tempo AS tempo_28, f3_.created_at AS created_at_29, f3_.updated_at AS updated_at_30, c4_.id AS id_31, c4_.content AS content_32, c4_.created_at AS created_at_33, c4_.updated_at AS updated_at_34, c0_.owner_id AS owner_id_35, c0_.folder_id AS folder_id_36, f1_.owner_id AS owner_id_37, c2_.choreography_id AS choreography_id_38, c2_.figure_id AS figure_id_39, c4_.step_id AS step_id_40 FROM choreography c0_ LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id WHERE c0_.owner_id = 1 ORDER BY c0_.created_at DESC, c2_.position ASC, c4_.created_at DESC;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.dance AS dance_2,
  c0_.level AS level_3,
  c0_.metadata AS metadata_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.is_public AS is_public_7,
  f1_.id AS id_8,
  f1_.name AS name_9,
  f1_.created_at AS created_at_10,
  f1_.updated_at AS updated_at_11,
  c2_.id AS id_12,
  c2_.position AS position_13,
  c2_.repeat_count AS repeat_count_14,
  c2_.start_at_step AS start_at_step_15,
  c2_.end_at_step AS end_at_step_16,
  f3_.id AS id_17,
  f3_.name AS name_18,
  f3_.slug AS slug_19,
  f3_.dance AS dance_20,
  f3_.duration AS duration_21,
  f3_.steps AS steps_22,
  f3_.rythm AS rythm_23,
  f3_.rhythms AS rhythms_24,
  f3_.international_level AS international_level_25,
  f3_.ffd_level AS ffd_level_26,
  f3_.role AS role_27,
  f3_.tempo AS tempo_28,
  f3_.created_at AS created_at_29,
  f3_.updated_at AS updated_at_30,
  c4_.id AS id_31,
  c4_.content AS content_32,
  c4_.created_at AS created_at_33,
  c4_.updated_at AS updated_at_34,
  c0_.owner_id AS owner_id_35,
  c0_.folder_id AS folder_id_36,
  f1_.owner_id AS owner_id_37,
  c2_.choreography_id AS choreography_id_38,
  c2_.figure_id AS figure_id_39,
  c4_.step_id AS step_id_40
FROM
  choreography c0_
  INNER JOIN choreography_share c5_ ON c0_.id = c5_.choreography_id
  LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id
  LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id
  LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id
  LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id
WHERE
  c5_.user_id = ?
ORDER BY
  c0_.created_at DESC,
  c2_.position ASC,
  c4_.created_at DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.dance AS dance_2, c0_.level AS level_3, c0_.metadata AS metadata_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.is_public AS is_public_7, f1_.id AS id_8, f1_.name AS name_9, f1_.created_at AS created_at_10, f1_.updated_at AS updated_at_11, c2_.id AS id_12, c2_.position AS position_13, c2_.repeat_count AS repeat_count_14, c2_.start_at_step AS start_at_step_15, c2_.end_at_step AS end_at_step_16, f3_.id AS id_17, f3_.name AS name_18, f3_.slug AS slug_19, f3_.dance AS dance_20, f3_.duration AS duration_21, f3_.steps AS steps_22, f3_.rythm AS rythm_23, f3_.rhythms AS rhythms_24, f3_.international_level AS international_level_25, f3_.ffd_level AS ffd_level_26, f3_.role AS role_27, f3_.tempo AS tempo_28, f3_.created_at AS created_at_29, f3_.updated_at AS updated_at_30, c4_.id AS id_31, c4_.content AS content_32, c4_.created_at AS created_at_33, c4_.updated_at AS updated_at_34, c0_.owner_id AS owner_id_35, c0_.folder_id AS folder_id_36, f1_.owner_id AS owner_id_37, c2_.choreography_id AS choreography_id_38, c2_.figure_id AS figure_id_39, c4_.step_id AS step_id_40 FROM choreography c0_ INNER JOIN choreography_share c5_ ON c0_.id = c5_.choreography_id LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id WHERE c5_.user_id = 1 ORDER BY c0_.created_at DESC, c2_.position ASC, c4_.created_at DESC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.created_at AS created_at_2,
  f0_.updated_at AS updated_at_3,
  f0_.owner_id AS owner_id_4
FROM
  folder f0_
WHERE
  f0_.owner_id = ?
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.owner_id AS owner_id_4 FROM folder f0_ WHERE f0_.owner_id = 1 ORDER BY f0_.name ASC;

SELECT
  c0_.folder_id AS sclr_0,
  COUNT(c0_.id) AS sclr_1
FROM
  choreography_folder_assignment c0_
WHERE
  c0_.user_id = ?
GROUP BY
  c0_.folder_id

SELECT c0_.folder_id AS sclr_0, COUNT(c0_.id) AS sclr_1 FROM choreography_folder_assignment c0_ WHERE c0_.user_id = 1 GROUP BY c0_.folder_id;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  license l0_
WHERE
  l0_.user_id = ?

SELECT COUNT(l0_.id) AS sclr_0 FROM license l0_ WHERE l0_.user_id = 1;