Query Metrics
14
Database Queries
6
Different statements
30.59 ms
Query time
1
Invalid entities
Queries
| #▲ | 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 |
|
| 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. |