GET https://new.negina.co.il/homepage/songs/components?instrument=piano&onlyWithLyrics=0&page=62

Query Metrics

31 Database Queries
9 Different statements
55.91 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.23 ms
"START TRANSACTION"
Parameters:
[]
2 0.64 ms
INSERT INTO form_logs (method, path, ip, user_agent, headers, query_data, request_data, referer, user_id, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "GET"
  "/homepage/songs/components"
  "216.73.216.170"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "{"user-agent":"Mozilla\/5.0 AppleWebKit\/537.36 (KHTML, like Gecko; compatible; ClaudeBot\/1.0; +claudebot@anthropic.com)"}"
  "{"instrument":"piano","onlyWithLyrics":"0","page":"62"}"
  null
  null
  null
  "2026-04-16 01:44:20"
]
3 2.81 ms
"COMMIT"
Parameters:
[]
4 0.61 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"
]
5 23.55 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.composer AS composer_3, s0_.lyrics AS lyrics_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.deleted_at AS deleted_at_7, s0_.is_show_notes AS is_show_notes_8, s0_.no_notes_message AS no_notes_message_9, s0_.is_promoted AS is_promoted_10, s0_.long_rows_checked_at AS long_rows_checked_at_11, a1_.id AS id_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, a1_.image_name AS image_name_16, a1_.image_unique_name AS image_unique_name_17, a1_.created_at AS created_at_18, a1_.updated_at AS updated_at_19, a1_.deleted_at AS deleted_at_20, a1_.stat_week AS stat_week_21, a1_.stat_all AS stat_all_22 FROM songs s0_ LEFT JOIN songs_instruments s2_ ON s0_.id = s2_.song_id AND (s2_.deleted_at IS NULL) LEFT JOIN artists a1_ ON s0_.artist_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (s2_.instrument_id = ?) AND (s0_.deleted_at IS NULL) GROUP BY s0_.id, s0_.name, s0_.slug, s0_.composer, s0_.lyrics, s0_.created_at, s0_.updated_at, s0_.deleted_at, s0_.is_show_notes, s0_.no_notes_message, s0_.is_promoted, s0_.long_rows_checked_at, s0_.artist_id, s0_.genre_id ORDER BY CASE WHEN s0_.is_promoted = 1 THEN 0 ELSE 1 END ASC, SUM(s2_.stat_week) DESC, s0_.id ASC) dctrn_table
Parameters:
[
  2
]
6 20.73 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.composer AS composer_3, s0_.lyrics AS lyrics_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.deleted_at AS deleted_at_7, s0_.is_show_notes AS is_show_notes_8, s0_.no_notes_message AS no_notes_message_9, s0_.is_promoted AS is_promoted_10, s0_.long_rows_checked_at AS long_rows_checked_at_11, a1_.id AS id_12, a1_.name AS name_13, a1_.description AS description_14, a1_.slug AS slug_15, a1_.image_name AS image_name_16, a1_.image_unique_name AS image_unique_name_17, a1_.created_at AS created_at_18, a1_.updated_at AS updated_at_19, a1_.deleted_at AS deleted_at_20, a1_.stat_week AS stat_week_21, a1_.stat_all AS stat_all_22, s0_.artist_id AS artist_id_23, s0_.genre_id AS genre_id_24 FROM songs s0_ LEFT JOIN songs_instruments s2_ ON s0_.id = s2_.song_id AND (s2_.deleted_at IS NULL) LEFT JOIN artists a1_ ON s0_.artist_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (s2_.instrument_id = ?) AND (s0_.deleted_at IS NULL) GROUP BY s0_.id, s0_.name, s0_.slug, s0_.composer, s0_.lyrics, s0_.created_at, s0_.updated_at, s0_.deleted_at, s0_.is_show_notes, s0_.no_notes_message, s0_.is_promoted, s0_.long_rows_checked_at, s0_.artist_id, s0_.genre_id ORDER BY CASE WHEN s0_.is_promoted = 1 THEN 0 ELSE 1 END ASC, SUM(s2_.stat_week) DESC, s0_.id ASC LIMIT 12 OFFSET 732
Parameters:
[
  2
]
7 0.44 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  75
]
8 0.31 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  86
]
9 0.28 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  90
]
10 0.28 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  140
]
11 0.30 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  144
]
12 0.26 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  148
]
13 0.28 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  240
]
14 0.27 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  272
]
15 0.26 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  275
]
16 0.29 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  276
]
17 0.26 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  282
]
18 0.26 ms
SELECT t0.id AS id_1, t0.original_desktop_text AS original_desktop_text_2, t0.original_desktop_content AS original_desktop_content_3, t0.original_desktop_updated_at AS original_desktop_updated_at_4, t0.original_mobile_text AS original_mobile_text_5, t0.original_mobile_content AS original_mobile_content_6, t0.original_mobile_updated_at AS original_mobile_updated_at_7, t0.simple_desktop_text AS simple_desktop_text_8, t0.simple_desktop_content AS simple_desktop_content_9, t0.simple_desktop_updated_at AS simple_desktop_updated_at_10, t0.simple_mobile_text AS simple_mobile_text_11, t0.simple_mobile_content AS simple_mobile_content_12, t0.simple_mobile_updated_at AS simple_mobile_updated_at_13, t0.direction AS direction_14, t0.is_enabled AS is_enabled_15, t0.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_16, t0.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_17, t0.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_18, t0.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_19, t0.stat_week AS stat_week_20, t0.stat_all AS stat_all_21, t0.song_id AS song_id_22 FROM songs_lyrics t0 WHERE t0.song_id = ?
Parameters:
[
  296
]
19 0.38 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  75
]
20 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hebrew_name AS hebrew_name_3 FROM instruments t0 WHERE t0.id = ?
Parameters:
[
  1
]
21 0.36 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  86
]
22 0.28 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  90
]
23 0.30 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  140
]
24 0.29 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  144
]
25 0.30 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  148
]
26 0.27 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  240
]
27 0.30 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  272
]
28 0.27 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  275
]
29 0.29 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  276
]
30 0.27 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  282
]
31 0.29 ms
SELECT t0.id AS id_1, t0.difficulty AS difficulty_2, t0.video AS video_3, t0.first_file_name AS first_file_name_4, t0.first_file_unique_name AS first_file_unique_name_5, t0.second_file_name AS second_file_name_6, t0.second_file_unique_name AS second_file_unique_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.stat_week AS stat_week_11, t0.stat_all AS stat_all_12, t0.song_id AS song_id_13, t0.instrument_id AS instrument_id_14, t0.permission_id AS permission_id_15 FROM songs_instruments t0 WHERE t0.song_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  296
]

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\FormLog 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\Artist No errors.
App\Entity\Genre No errors.
App\Entity\SongGenre No errors.
App\Entity\SongLyrics No errors.
App\Entity\UserFavoriteSongs No errors.
App\Entity\SongAccompaniment No errors.
App\Entity\Permission No errors.