Query Metrics

14 Database Queries
6 Different statements
30.59 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.75 ms
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
Parameters:
[
  "Piano"
]
2 8.56 ms
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
Parameters:
[
  2
]
3 0.41 ms
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
Parameters:
[
  "Piano"
]
4 12.03 ms
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)
Parameters:
[
  2
]
5 0.38 ms
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
Parameters:
[
  "Guitar"
]
6 2.43 ms
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
Parameters:
[
  1
]
7 0.28 ms
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
Parameters:
[
  "Guitar"
]
8 1.57 ms
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)
Parameters:
[
  1
]
9 0.25 ms
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
Parameters:
[
  ""
]
10 1.48 ms
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
Parameters:
[
  1
]
11 0.29 ms
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
Parameters:
[
  ""
]
12 1.05 ms
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)
Parameters:
[
  1
]
13 0.62 ms
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
Parameters:
[]
14 0.49 ms
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
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\Lesson No errors.
App\Entity\Instrument No errors.
App\Entity\SaleBanner
  • The association App\Entity\SaleBanner#saleBannerType refers to the inverse side field App\Entity\SaleBannerType#sales_banners which does not exist.
App\Entity\VideoTestimonial No errors.
App\Entity\Song No errors.
App\Entity\Course No errors.
App\Entity\SongInstrument No errors.
App\Entity\Review No errors.
App\Entity\Accompaniment No errors.
App\Entity\SongLyrics No errors.