Symfony Profiler

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.created_at AS created_at_2,
  f0_.deleted AS deleted_3,
  f0_.type AS type_4,
  f0_.status AS status_5,
  f0_.extension AS extension_6,
  f0_.mime_type AS mime_type_7,
  f0_.real_name AS real_name_8,
  f0_.description AS description_9,
  f0_.url AS url_10,
  f0_.folder_id AS folder_id_11,
  f0_.project_id AS project_id_12,
  f0_.playable_id AS playable_id_13,
  f0_.picture_id AS picture_id_14
FROM
  file f0_
  INNER JOIN file_band_member f1_ ON f0_.id = f1_.file_id
  INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id
  INNER JOIN `user` u3_ ON b2_.user_id = u3_.id
  INNER JOIN action a4_ ON f0_.id = a4_.file_id
  AND a4_.discr IN ('file_action')
WHERE
  u3_.id = ?
  AND f0_.deleted = 0
  AND a4_.action = ?
  AND f0_.type = ?
GROUP BY
  a4_.id
ORDER BY
  a4_.created_at DESC
LIMIT
  4

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.created_at AS created_at_2, f0_.deleted AS deleted_3, f0_.type AS type_4, f0_.status AS status_5, f0_.extension AS extension_6, f0_.mime_type AS mime_type_7, f0_.real_name AS real_name_8, f0_.description AS description_9, f0_.url AS url_10, f0_.folder_id AS folder_id_11, f0_.project_id AS project_id_12, f0_.playable_id AS playable_id_13, f0_.picture_id AS picture_id_14 FROM file f0_ INNER JOIN file_band_member f1_ ON f0_.id = f1_.file_id INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id INNER JOIN `user` u3_ ON b2_.user_id = u3_.id INNER JOIN action a4_ ON f0_.id = a4_.file_id AND a4_.discr IN ('file_action') WHERE u3_.id = 194 AND f0_.deleted = 0 AND a4_.action = 'publish' AND f0_.type = 'music' GROUP BY a4_.id ORDER BY a4_.created_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.story AS story_2,
  t0.role AS role_3,
  t0.band_id AS band_id_4,
  t0.user_id AS user_id_5
FROM
  band_member t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.story AS story_2, t0.role AS role_3, t0.band_id AS band_id_4, t0.user_id AS user_id_5 FROM band_member t0 WHERE t0.user_id = 194;

SELECT
  t0.id AS id_1,
  t0.inscription_date AS inscription_date_2,
  t0.story AS story_3,
  t0.experience AS experience_4,
  t0.country AS country_5,
  t0.views_number AS views_number_6,
  t0.profile_picture_id AS profile_picture_id_7,
  t0.cover_picture_id AS cover_picture_id_8
FROM
  common_information t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.inscription_date AS inscription_date_2, t0.story AS story_3, t0.experience AS experience_4, t0.country AS country_5, t0.views_number AS views_number_6, t0.profile_picture_id AS profile_picture_id_7, t0.cover_picture_id AS cover_picture_id_8 FROM common_information t0 WHERE t0.id = 469;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  music_style t0
  INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id
WHERE
  common_information_music_style.common_information_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM music_style t0 INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id WHERE common_information_music_style.common_information_id = 469;

SELECT
  u0_.first_name AS first_name_0,
  u0_.last_name AS last_name_1,
  u0_.birthday AS birthday_2,
  u0_.influential_artists AS influential_artists_3,
  u0_.id AS id_4,
  u0_.username AS username_5,
  u0_.email AS email_6,
  u0_.enabled AS enabled_7,
  u0_.available_to_collaborate AS available_to_collaborate_8,
  u0_.salt AS salt_9,
  u0_.password AS password_10,
  u0_.last_login AS last_login_11,
  u0_.roles AS roles_12,
  u0_.common_information_id AS common_information_id_13
FROM
  `user` u0_
  LEFT JOIN common_information c1_ ON u0_.common_information_id = c1_.id
  LEFT JOIN common_information_music_style c3_ ON c1_.id = c3_.common_information_id
  LEFT JOIN music_style m2_ ON m2_.id = c3_.music_style_id
  LEFT JOIN user_instrument u5_ ON u0_.id = u5_.user_id
  LEFT JOIN instrument i4_ ON i4_.id = u5_.instrument_id
  LEFT JOIN action a6_ ON u0_.id = a6_.user_id
  AND a6_.discr IN (
    'file_action', 'people_action', 'share',
    'event_action', 'event_participation'
  )
  AND (a6_.action = 'like')
WHERE
  u0_.available_to_collaborate = 1
GROUP BY
  u0_.id
ORDER BY
  u0_.id DESC
LIMIT
  7

SELECT u0_.first_name AS first_name_0, u0_.last_name AS last_name_1, u0_.birthday AS birthday_2, u0_.influential_artists AS influential_artists_3, u0_.id AS id_4, u0_.username AS username_5, u0_.email AS email_6, u0_.enabled AS enabled_7, u0_.available_to_collaborate AS available_to_collaborate_8, u0_.salt AS salt_9, u0_.password AS password_10, u0_.last_login AS last_login_11, u0_.roles AS roles_12, u0_.common_information_id AS common_information_id_13 FROM `user` u0_ LEFT JOIN common_information c1_ ON u0_.common_information_id = c1_.id LEFT JOIN common_information_music_style c3_ ON c1_.id = c3_.common_information_id LEFT JOIN music_style m2_ ON m2_.id = c3_.music_style_id LEFT JOIN user_instrument u5_ ON u0_.id = u5_.user_id LEFT JOIN instrument i4_ ON i4_.id = u5_.instrument_id LEFT JOIN action a6_ ON u0_.id = a6_.user_id AND a6_.discr IN ('file_action', 'people_action', 'share', 'event_action', 'event_participation') AND (a6_.action = 'like') WHERE u0_.available_to_collaborate = 1 GROUP BY u0_.id ORDER BY u0_.id DESC LIMIT 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.family AS family_3,
  t0.default AS default_4
FROM
  instrument t0
  INNER JOIN user_instrument ON t0.id = user_instrument.instrument_id
WHERE
  user_instrument.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.family AS family_3, t0.default AS default_4 FROM instrument t0 INNER JOIN user_instrument ON t0.id = user_instrument.instrument_id WHERE user_instrument.user_id = 194;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1
FROM
  music_style m0_
ORDER BY
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1 FROM music_style m0_ ORDER BY m0_.name ASC;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.family AS family_2,
  i0_.default AS default_3
FROM
  instrument i0_
ORDER BY
  i0_.name ASC

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.family AS family_2, i0_.default AS default_3 FROM instrument i0_ ORDER BY i0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.extension AS extension_2,
  t0.sub_path AS sub_path_3,
  t0.alt AS alt_4
FROM
  picture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.extension AS extension_2, t0.sub_path AS sub_path_3, t0.alt AS alt_4 FROM picture t0 WHERE t0.id = 469;