Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 235
• Events
• Routing
• Cache
• Translation 12
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• VichUploader
• JMS Serializer 0 + 0
• Blocks 0
• Configuration

Query Metrics

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM songs s0_ LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id AND (s1_.deleted_at IS NULL) WHERE (s1_.instrument_id = ?) AND (s0_.deleted_at IS NULL)

[
  2
]

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  songs s0_
  LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id
  AND (s1_.deleted_at IS NULL)
WHERE
  (s1_.instrument_id = ?)
  AND (s0_.deleted_at IS NULL)

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM songs s0_ LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id AND (s1_.deleted_at IS NULL) WHERE (s1_.instrument_id = 2) AND (s0_.deleted_at IS NULL);

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM songs s0_ LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id AND (s1_.deleted_at IS NULL) WHERE (s1_.instrument_id = ?) AND (s0_.deleted_at IS NULL) HAVING SUM(s1_.stat_week) >= 1

[
  2
]

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  songs s0_
  LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id
  AND (s1_.deleted_at IS NULL)
WHERE
  (s1_.instrument_id = ?)
  AND (s0_.deleted_at IS NULL)
HAVING
  SUM(s1_.stat_week) >= 1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM songs s0_ LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id AND (s1_.deleted_at IS NULL) WHERE (s1_.instrument_id = 2) AND (s0_.deleted_at IS NULL) HAVING SUM(s1_.stat_week) >= 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.hebrew_name AS hebrew_name_3 FROM instruments t0 WHERE t0.name = ? LIMIT 1

[
  "Piano"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hebrew_name AS hebrew_name_3
FROM
  instruments t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.hebrew_name AS hebrew_name_3 FROM instruments t0 WHERE t0.name = 'Piano' LIMIT 1;

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM songs s0_ LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id AND (s1_.deleted_at IS NULL) INNER JOIN songs_lyrics s2_ ON s0_.id = s2_.song_id WHERE (s2_.original_desktop_content IS NOT NULL AND s2_.simple_desktop_content IS NOT NULL AND s2_.is_enabled = ?) AND (s0_.deleted_at IS NULL) HAVING SUM(s1_.stat_week) >= 1

[
  1
]

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  songs s0_
  LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id
  AND (s1_.deleted_at IS NULL)
  INNER JOIN songs_lyrics s2_ ON s0_.id = s2_.song_id
WHERE
  (
    s2_.original_desktop_content IS NOT NULL
    AND s2_.simple_desktop_content IS NOT NULL
    AND s2_.is_enabled = ?
  )
  AND (s0_.deleted_at IS NULL)
HAVING
  SUM(s1_.stat_week) >= 1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM songs s0_ LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id AND (s1_.deleted_at IS NULL) INNER JOIN songs_lyrics s2_ ON s0_.id = s2_.song_id WHERE (s2_.original_desktop_content IS NOT NULL AND s2_.simple_desktop_content IS NOT NULL AND s2_.is_enabled = 1) AND (s0_.deleted_at IS NULL) HAVING SUM(s1_.stat_week) >= 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.header AS header_4, t0.subheader AS subheader_5, t0.incentives AS incentives_6, t0.content AS content_7, t0.description AS description_8, t0.description_mobile AS description_mobile_9, t0.rating AS rating_10, t0.reviews_count AS reviews_count_11, t0.students_count AS students_count_12, t0.video AS video_13, t0.title_seo AS title_seo_14, t0.meta_title_seo AS meta_title_seo_15, t0.meta_description_seo AS meta_description_seo_16, t0.title_breadcrumb AS title_breadcrumb_17, t0.updated_at AS updated_at_18, t0.instrument_id AS instrument_id_19 FROM courses t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.header AS header_4,
  t0.subheader AS subheader_5,
  t0.incentives AS incentives_6,
  t0.content AS content_7,
  t0.description AS description_8,
  t0.description_mobile AS description_mobile_9,
  t0.rating AS rating_10,
  t0.reviews_count AS reviews_count_11,
  t0.students_count AS students_count_12,
  t0.video AS video_13,
  t0.title_seo AS title_seo_14,
  t0.meta_title_seo AS meta_title_seo_15,
  t0.meta_description_seo AS meta_description_seo_16,
  t0.title_breadcrumb AS title_breadcrumb_17,
  t0.updated_at AS updated_at_18,
  t0.instrument_id AS instrument_id_19
FROM
  courses t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.header AS header_4, t0.subheader AS subheader_5, t0.incentives AS incentives_6, t0.content AS content_7, t0.description AS description_8, t0.description_mobile AS description_mobile_9, t0.rating AS rating_10, t0.reviews_count AS reviews_count_11, t0.students_count AS students_count_12, t0.video AS video_13, t0.title_seo AS title_seo_14, t0.meta_title_seo AS meta_title_seo_15, t0.meta_description_seo AS meta_description_seo_16, t0.title_breadcrumb AS title_breadcrumb_17, t0.updated_at AS updated_at_18, t0.instrument_id AS instrument_id_19 FROM courses t0;

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM songs s0_ LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id AND (s1_.deleted_at IS NULL) INNER JOIN songs_lyrics s2_ ON s0_.id = s2_.song_id WHERE (s2_.original_desktop_content IS NOT NULL AND s2_.simple_desktop_content IS NOT NULL AND s2_.is_enabled = ?) AND (s0_.deleted_at IS NULL)

[
  1
]

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  songs s0_
  LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id
  AND (s1_.deleted_at IS NULL)
  INNER JOIN songs_lyrics s2_ ON s0_.id = s2_.song_id
WHERE
  (
    s2_.original_desktop_content IS NOT NULL
    AND s2_.simple_desktop_content IS NOT NULL
    AND s2_.is_enabled = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM songs s0_ LEFT JOIN songs_instruments s1_ ON s0_.id = s1_.song_id AND (s1_.deleted_at IS NULL) INNER JOIN songs_lyrics s2_ ON s0_.id = s2_.song_id WHERE (s2_.original_desktop_content IS NOT NULL AND s2_.simple_desktop_content IS NOT NULL AND s2_.is_enabled = 1) AND (s0_.deleted_at IS NULL);