Symfony Profiler

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  (
    u0_.is_verified LIKE ?
    AND u0_.first_access LIKE ?
    AND u0_.id <> ?
  )
  AND (u0_.deleted_at IS NULL)

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ WHERE (u0_.is_verified LIKE 1 AND u0_.first_access LIKE 0 AND u0_.id <> 75) AND (u0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.instrument AS instrument_2
FROM
  instruments t0
  INNER JOIN user_instruments ON t0.id = user_instruments.instruments_id
WHERE
  user_instruments.user_id = ?

SELECT t0.id AS id_1, t0.instrument AS instrument_2 FROM instruments t0 INNER JOIN user_instruments ON t0.id = user_instruments.instruments_id WHERE user_instruments.user_id = 896;

SELECT
  t0.id AS id_1,
  t0.style AS style_2,
  t0.music_genre_id AS music_genre_id_3
FROM
  music_styles t0
WHERE
  t0.music_genre_id = ?

SELECT t0.id AS id_1, t0.style AS style_2, t0.music_genre_id AS music_genre_id_3 FROM music_styles t0 WHERE t0.music_genre_id = 5;

SELECT
  t0.id AS id_1,
  t0.style AS style_2,
  t0.music_genre_id AS music_genre_id_3
FROM
  music_styles t0
  INNER JOIN user_music_styles ON t0.id = user_music_styles.music_styles_id
WHERE
  user_music_styles.user_id = ?

SELECT t0.id AS id_1, t0.style AS style_2, t0.music_genre_id AS music_genre_id_3 FROM music_styles t0 INNER JOIN user_music_styles ON t0.id = user_music_styles.music_styles_id WHERE user_music_styles.user_id = 896;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.flag AS flag_4
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.flag AS flag_4 FROM country t0 WHERE t0.id = 91;

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.score AS score_1,
  u0_.created_at AS created_at_2
FROM
  user u0_
WHERE
  (
    u0_.is_verified LIKE ?
    AND u0_.first_access LIKE ?
    AND u0_.id <> ?
  )
  AND (u0_.deleted_at IS NULL)
ORDER BY
  u0_.score DESC,
  u0_.created_at DESC
LIMIT
  10

SELECT DISTINCT u0_.id AS id_0, u0_.score AS score_1, u0_.created_at AS created_at_2 FROM user u0_ WHERE (u0_.is_verified LIKE 1 AND u0_.first_access LIKE 0 AND u0_.id <> 75) AND (u0_.deleted_at IS NULL) ORDER BY u0_.score DESC, u0_.created_at DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.description AS description_2
FROM
  project_status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2 FROM project_status t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.duration AS duration_3,
  p0_.measures AS measures_4,
  p0_.private AS private_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.color AS color_8,
  p0_.user_id AS user_id_9,
  p0_.status_id AS status_id_10
FROM
  project p0_
  INNER JOIN project_participants p1_ ON p0_.id = p1_.project_id
WHERE
  p1_.user_id = ?
  AND p0_.status_id = ?
  AND (
    (
      p1_.waiting = ?
      OR p1_.waiting IS NULL
    )
  )

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.duration AS duration_3, p0_.measures AS measures_4, p0_.private AS private_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.color AS color_8, p0_.user_id AS user_id_9, p0_.status_id AS status_id_10 FROM project p0_ INNER JOIN project_participants p1_ ON p0_.id = p1_.project_id WHERE p1_.user_id = NULL AND p0_.status_id = 1 AND ((p1_.waiting = 0 OR p1_.waiting IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.duration AS duration_4,
  t0.measures AS measures_5,
  t0.private AS private_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.color AS color_9,
  t0.user_id AS user_id_10,
  t0.status_id AS status_id_11
FROM
  project t0
WHERE
  t0.status_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.duration AS duration_4, t0.measures AS measures_5, t0.private AS private_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.color AS color_9, t0.user_id AS user_id_10, t0.status_id AS status_id_11 FROM project t0 WHERE t0.status_id = 1;

SELECT
  i0_.id AS id_0,
  i0_.instrument AS instrument_1
FROM
  instruments i0_

SELECT i0_.id AS id_0, i0_.instrument AS instrument_1 FROM instruments i0_;

SELECT
  m0_.id AS id_0,
  m0_.style AS style_1,
  m0_.music_genre_id AS music_genre_id_2
FROM
  music_styles m0_

SELECT m0_.id AS id_0, m0_.style AS style_1, m0_.music_genre_id AS music_genre_id_2 FROM music_styles m0_;

SELECT
  m0_.id AS id_0,
  m0_.genre AS genre_1
FROM
  music_genre m0_
ORDER BY
  m0_.genre ASC

SELECT m0_.id AS id_0, m0_.genre AS genre_1 FROM music_genre m0_ ORDER BY m0_.genre ASC;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.username AS username_2,
  u0_.roles AS roles_3,
  u0_.confirmation_token AS confirmation_token_4,
  u0_.color AS color_5,
  u0_.gender AS gender_6,
  u0_.registration_ip AS registration_ip_7,
  u0_.password AS password_8,
  u0_.is_verified AS is_verified_9,
  u0_.is_verified_ads AS is_verified_ads_10,
  u0_.school_admin AS school_admin_11,
  u0_.first_access AS first_access_12,
  u0_.score AS score_13,
  u0_.first_access_ads AS first_access_ads_14,
  u0_.accept_email AS accept_email_15,
  u0_.show_email_ads AS show_email_ads_16,
  u0_.profile_picture AS profile_picture_17,
  u0_.profile_picture_small AS profile_picture_small_18,
  u0_.created_at AS created_at_19,
  u0_.updated_at AS updated_at_20,
  u0_.deleted_at AS deleted_at_21,
  u0_.country_id AS country_id_22,
  u0_.school_id AS school_id_23,
  u0_.code_premium_id AS code_premium_id_24
FROM
  user u0_
WHERE
  (
    u0_.is_verified LIKE ?
    AND u0_.first_access LIKE ?
    AND u0_.id <> ?
    AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (u0_.deleted_at IS NULL)
ORDER BY
  u0_.score DESC,
  u0_.created_at DESC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.roles AS roles_3, u0_.confirmation_token AS confirmation_token_4, u0_.color AS color_5, u0_.gender AS gender_6, u0_.registration_ip AS registration_ip_7, u0_.password AS password_8, u0_.is_verified AS is_verified_9, u0_.is_verified_ads AS is_verified_ads_10, u0_.school_admin AS school_admin_11, u0_.first_access AS first_access_12, u0_.score AS score_13, u0_.first_access_ads AS first_access_ads_14, u0_.accept_email AS accept_email_15, u0_.show_email_ads AS show_email_ads_16, u0_.profile_picture AS profile_picture_17, u0_.profile_picture_small AS profile_picture_small_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.deleted_at AS deleted_at_21, u0_.country_id AS country_id_22, u0_.school_id AS school_id_23, u0_.code_premium_id AS code_premium_id_24 FROM user u0_ WHERE (u0_.is_verified LIKE 1 AND u0_.first_access LIKE 0 AND u0_.id <> 75 AND u0_.id IN (896, 895, 894, 890, 889, 888, 886, 885, 884, 882)) AND (u0_.deleted_at IS NULL) ORDER BY u0_.score DESC, u0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.instrument AS instrument_2
FROM
  instruments t0

SELECT t0.id AS id_1, t0.instrument AS instrument_2 FROM instruments t0;