POST http://preview.new.negina.co.il/piano/song

Query Metrics

6 Database Queries
6 Different statements
2.85 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.25 ms
"START TRANSACTION"
Parameters:
[]
2 0.58 ms
INSERT INTO form_logs (method, path, ip, user_agent, headers, query_data, request_data, referer, user_id, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "POST"
  "/piano/song"
  "17.22.245.20"
  "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)"
  "{"user-agent":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/17.4 Safari\/605.1.15 (Applebot\/0.1; +http:\/\/www.apple.com\/go\/applebot)","referer":"http:\/\/preview.new.negina.co.il\/%D7%9C%D7%A4%D7%AA%D7%95%D7%97-%D7%90%D7%AA-%D7%94%D7%9C%D7%91\/%D7%99%D7%95%D7%91%D7%9C-%D7%93%D7%99%D7%99%D7%9F\/%D7%A9%D7%99%D7%A2%D7%95%D7%A8-%D7%A4%D7%A1%D7%A0%D7%AA%D7%A8","origin":"http:\/\/preview.new.negina.co.il","content-type":"application\/x-www-form-urlencoded; charset=UTF-8"}"
  null
  "{"level":"1","id":"2471","csrf":"8b9c322b9d5084aef9f23ed859e0e.fOzZAUrjtcfvJhEbsJYiM8WBpsc5lwPZzIBRQfrfnYk.FrOgNDuJ26bWXmRY_99SHoLL34p68nvvovoYC5ubsPlLjbtSDI74lL4QYg"}"
  "http://preview.new.negina.co.il/%D7%9C%D7%A4%D7%AA%D7%95%D7%97-%D7%90%D7%AA-%D7%94%D7%9C%D7%91/%D7%99%D7%95%D7%91%D7%9C-%D7%93%D7%99%D7%99%D7%9F/%D7%A9%D7%99%D7%A2%D7%95%D7%A8-%D7%A4%D7%A1%D7%A0%D7%AA%D7%A8"
  null
  "2026-04-23 05:30:48"
]
3 0.69 ms
"COMMIT"
Parameters:
[]
4 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.composer AS composer_4, t0.lyrics AS lyrics_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.is_show_notes AS is_show_notes_9, t0.no_notes_message AS no_notes_message_10, t0.is_promoted AS is_promoted_11, t0.long_rows_checked_at AS long_rows_checked_at_12, t0.artist_id AS artist_id_13, t0.genre_id AS genre_id_14, t15.id AS id_16, t15.original_desktop_text AS original_desktop_text_17, t15.original_desktop_content AS original_desktop_content_18, t15.original_desktop_updated_at AS original_desktop_updated_at_19, t15.original_mobile_text AS original_mobile_text_20, t15.original_mobile_content AS original_mobile_content_21, t15.original_mobile_updated_at AS original_mobile_updated_at_22, t15.simple_desktop_text AS simple_desktop_text_23, t15.simple_desktop_content AS simple_desktop_content_24, t15.simple_desktop_updated_at AS simple_desktop_updated_at_25, t15.simple_mobile_text AS simple_mobile_text_26, t15.simple_mobile_content AS simple_mobile_content_27, t15.simple_mobile_updated_at AS simple_mobile_updated_at_28, t15.direction AS direction_29, t15.is_enabled AS is_enabled_30, t15.align_leading_chords_original_desktop AS align_leading_chords_original_desktop_31, t15.align_leading_chords_original_mobile AS align_leading_chords_original_mobile_32, t15.align_leading_chords_simple_desktop AS align_leading_chords_simple_desktop_33, t15.align_leading_chords_simple_mobile AS align_leading_chords_simple_mobile_34, t15.stat_week AS stat_week_35, t15.stat_all AS stat_all_36, t15.song_id AS song_id_37 FROM songs t0 LEFT JOIN songs_lyrics t15 ON t15.song_id = t0.id WHERE t0.id = ?
Parameters:
[
  2471
]
5 0.44 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 = ?
Parameters:
[
  2471
]
6 0.35 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:
[
  2
]

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