Query Metrics

20 Database Queries
17 Different statements
10.75 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 0.31 ms
"START TRANSACTION"
Parameters:
[]
2 0.54 ms
INSERT INTO form_logs (method, path, ip, user_agent, headers, query_data, request_data, referer, user_id, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "GET"
  "/%D7%91%D7%97%D7%99%D7%A8%D7%AA-%D7%AA%D7%A9%D7%9C%D7%95%D7%9D/%D7%AA%D7%95%D7%9B%D7%A0%D7%99%D7%AA"
  "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":"guitar"}"
  null
  null
  null
  "2026-04-16 09:06:52"
]
3 1.24 ms
"COMMIT"
Parameters:
[]
4 0.37 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"
]
5 1.15 ms
SELECT r0_.id AS id_0, r0_.author AS author_1, r0_.rating AS rating_2, r0_.date AS date_3, r0_.text AS text_4, r0_.type AS type_5, r0_.entity_id AS entity_id_6, r0_.image_name AS image_name_7, r0_.image_unique_name AS image_unique_name_8, r0_.updated_at AS updated_at_9 FROM reviews r0_ WHERE r0_.type = ? ORDER BY r0_.date DESC
Parameters:
[
  "all"
]
6 0.31 ms
SELECT r0_.id AS id_0, r0_.author AS author_1, r0_.rating AS rating_2, r0_.date AS date_3, r0_.text AS text_4, r0_.type AS type_5, r0_.entity_id AS entity_id_6, r0_.image_name AS image_name_7, r0_.image_unique_name AS image_unique_name_8, r0_.updated_at AS updated_at_9 FROM reviews r0_ WHERE r0_.type = ? ORDER BY r0_.date DESC LIMIT 3
Parameters:
[
  "all"
]
7 0.53 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.description_mobile AS description_mobile_3, p0_.price AS price_4, p0_.duration AS duration_5, i1_.name AS name_6, i1_.id AS id_7, p0_.pelecard_installments AS pelecard_installments_8, p0_.is_featured AS is_featured_9, p0_.is_auto_renew AS is_auto_renew_10 FROM plans p0_ LEFT JOIN instruments i1_ ON (p0_.instrument_id = i1_.id) WHERE (p0_.is_custom = ? AND p0_.count_less = -1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.duration DESC
Parameters:
[
  0
]
8 0.98 ms
SELECT r0_.id AS id_0, r0_.author AS author_1, r0_.rating AS rating_2, r0_.date AS date_3, r0_.text AS text_4, r0_.type AS type_5, r0_.entity_id AS entity_id_6, r0_.image_name AS image_name_7, r0_.image_unique_name AS image_unique_name_8, r0_.updated_at AS updated_at_9 FROM reviews r0_ INNER JOIN review_instruments r2_ ON r0_.id = r2_.review_id INNER JOIN instruments i1_ ON i1_.id = r2_.instrument_id WHERE i1_.id = ? ORDER BY r0_.date DESC
Parameters:
[
  1
]
9 0.41 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.description_mobile AS description_mobile_3, p0_.price AS price_4, p0_.duration AS duration_5, i1_.name AS name_6, i1_.id AS id_7, p0_.pelecard_installments AS pelecard_installments_8, p0_.is_featured AS is_featured_9, p0_.is_auto_renew AS is_auto_renew_10 FROM plans p0_ LEFT JOIN instruments i1_ ON (p0_.instrument_id = i1_.id) WHERE (p0_.is_custom = ? AND p0_.count_less = -1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.duration DESC
Parameters:
[
  0
]
10 0.43 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.description_mobile AS description_mobile_3, p0_.instrument_id AS instrument_id_4, p0_.gift_plan_id AS gift_plan_id_5, p0_.price AS price_6, p0_.duration AS duration_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.is_auto_renew AS is_auto_renew_11, p0_.is_custom AS is_custom_12, p0_.pelecard_installments AS pelecard_installments_13, p0_.count_less AS count_less_14, p0_.has_song_access AS has_song_access_15, p0_.has_feature_access AS has_feature_access_16, p0_.is_featured AS is_featured_17, p0_.is_promotion AS is_promotion_18, p0_.is_gift AS is_gift_19, p0_.summary_text AS summary_text_20, p0_.invoice_text AS invoice_text_21, p0_.invoice_item_name AS invoice_item_name_22, p0_.duration_text AS duration_text_23, p0_.is_free AS is_free_24 FROM plans p0_ INNER JOIN instruments i1_ ON (p0_.instrument_id = i1_.id) WHERE ((p0_.has_feature_access = 1 AND p0_.is_auto_renew = 1 AND p0_.duration = 1) AND i1_.name = ?) AND (p0_.deleted_at IS NULL) LIMIT 1
Parameters:
[
  "Chords-feature"
]
11 0.40 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.description_mobile AS description_mobile_3, p0_.instrument_id AS instrument_id_4, p0_.gift_plan_id AS gift_plan_id_5, p0_.price AS price_6, p0_.duration AS duration_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.is_auto_renew AS is_auto_renew_11, p0_.is_custom AS is_custom_12, p0_.pelecard_installments AS pelecard_installments_13, p0_.count_less AS count_less_14, p0_.has_song_access AS has_song_access_15, p0_.has_feature_access AS has_feature_access_16, p0_.is_featured AS is_featured_17, p0_.is_promotion AS is_promotion_18, p0_.is_gift AS is_gift_19, p0_.summary_text AS summary_text_20, p0_.invoice_text AS invoice_text_21, p0_.invoice_item_name AS invoice_item_name_22, p0_.duration_text AS duration_text_23, p0_.is_free AS is_free_24 FROM plans p0_ INNER JOIN instruments i1_ ON (p0_.instrument_id = i1_.id) WHERE ((p0_.has_feature_access = 1 AND p0_.is_auto_renew = 1 AND p0_.duration = 12) AND i1_.name = ?) AND (p0_.deleted_at IS NULL) LIMIT 1
Parameters:
[
  "Chords-feature"
]
12 0.36 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.description_mobile AS description_mobile_3, p0_.instrument_id AS instrument_id_4, p0_.gift_plan_id AS gift_plan_id_5, p0_.price AS price_6, p0_.duration AS duration_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.is_auto_renew AS is_auto_renew_11, p0_.is_custom AS is_custom_12, p0_.pelecard_installments AS pelecard_installments_13, p0_.count_less AS count_less_14, p0_.has_song_access AS has_song_access_15, p0_.has_feature_access AS has_feature_access_16, p0_.is_featured AS is_featured_17, p0_.is_promotion AS is_promotion_18, p0_.is_gift AS is_gift_19, p0_.summary_text AS summary_text_20, p0_.invoice_text AS invoice_text_21, p0_.invoice_item_name AS invoice_item_name_22, p0_.duration_text AS duration_text_23, p0_.is_free AS is_free_24 FROM plans p0_ INNER JOIN instruments i1_ ON (p0_.instrument_id = i1_.id) WHERE ((p0_.has_song_access = 1 AND p0_.has_feature_access = 1 AND p0_.is_auto_renew = 1 AND p0_.duration = 1) AND i1_.name = ?) AND (p0_.deleted_at IS NULL) LIMIT 1
Parameters:
[
  "Piano-songs-only"
]
13 0.37 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.description_mobile AS description_mobile_3, p0_.instrument_id AS instrument_id_4, p0_.gift_plan_id AS gift_plan_id_5, p0_.price AS price_6, p0_.duration AS duration_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.is_auto_renew AS is_auto_renew_11, p0_.is_custom AS is_custom_12, p0_.pelecard_installments AS pelecard_installments_13, p0_.count_less AS count_less_14, p0_.has_song_access AS has_song_access_15, p0_.has_feature_access AS has_feature_access_16, p0_.is_featured AS is_featured_17, p0_.is_promotion AS is_promotion_18, p0_.is_gift AS is_gift_19, p0_.summary_text AS summary_text_20, p0_.invoice_text AS invoice_text_21, p0_.invoice_item_name AS invoice_item_name_22, p0_.duration_text AS duration_text_23, p0_.is_free AS is_free_24 FROM plans p0_ INNER JOIN instruments i1_ ON (p0_.instrument_id = i1_.id) WHERE ((p0_.has_song_access = 1 AND p0_.has_feature_access = 1 AND p0_.is_auto_renew = 1 AND p0_.duration = 12) AND i1_.name = ?) AND (p0_.deleted_at IS NULL) LIMIT 1
Parameters:
[
  "Piano-songs-only"
]
14 0.57 ms
SELECT p0_.title AS title_0, p0_.options AS options_1, i1_.name AS name_2 FROM plans_group_descriptions p0_ LEFT JOIN instruments i1_ ON (p0_.instrument_id = i1_.id)
Parameters:
[]
15 0.23 ms
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.hebrew_name AS hebrew_name_2 FROM instruments i0_
Parameters:
[]
16 0.43 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:
[]
17 0.54 ms
SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.image_unique_name AS image_unique_name_2, s0_.mobile_image_name AS mobile_image_name_3, s0_.mobile_image_unique_name AS mobile_image_unique_name_4, s0_.type AS type_5, s0_.is_for_paid AS is_for_paid_6, s0_.is_for_free AS is_for_free_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.deleted_at AS deleted_at_10, s0_.url AS url_11, s0_.opens_purchase_popup AS opens_purchase_popup_12, s0_.sale_banner_type_id AS sale_banner_type_id_13 FROM sales_banners s0_ INNER JOIN sales_banners_type s1_ ON s0_.sale_banner_type_id = s1_.id WHERE (s0_.deleted_at IS NULL AND s1_.slug = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.created_at DESC LIMIT 1
Parameters:
[
  "payment-page"
]
18 0.32 ms
SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.image_unique_name AS image_unique_name_2, s0_.mobile_image_name AS mobile_image_name_3, s0_.mobile_image_unique_name AS mobile_image_unique_name_4, s0_.type AS type_5, s0_.is_for_paid AS is_for_paid_6, s0_.is_for_free AS is_for_free_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.deleted_at AS deleted_at_10, s0_.url AS url_11, s0_.opens_purchase_popup AS opens_purchase_popup_12, s0_.sale_banner_type_id AS sale_banner_type_id_13 FROM sales_banners s0_ INNER JOIN sales_banners_type s1_ ON s0_.sale_banner_type_id = s1_.id WHERE (s0_.deleted_at IS NULL AND s1_.slug = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.created_at DESC LIMIT 1
Parameters:
[
  "payment-page"
]
19 0.30 ms
SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.image_unique_name AS image_unique_name_2, s0_.mobile_image_name AS mobile_image_name_3, s0_.mobile_image_unique_name AS mobile_image_unique_name_4, s0_.type AS type_5, s0_.is_for_paid AS is_for_paid_6, s0_.is_for_free AS is_for_free_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.deleted_at AS deleted_at_10, s0_.url AS url_11, s0_.opens_purchase_popup AS opens_purchase_popup_12, s0_.sale_banner_type_id AS sale_banner_type_id_13 FROM sales_banners s0_ INNER JOIN sales_banners_type s1_ ON s0_.sale_banner_type_id = s1_.id WHERE (s0_.deleted_at IS NULL AND s1_.slug = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.created_at DESC LIMIT 1
Parameters:
[
  "payment-page"
]
20 0.98 ms
SELECT v0_.id AS id_0, v0_.vimeo_video_id AS vimeo_video_id_1, v0_.title AS title_2, v0_.person_name AS person_name_3, v0_.person_age AS person_age_4, v0_.person_city AS person_city_5, v0_.position AS position_6, v0_.is_enabled AS is_enabled_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9 FROM video_testimonials v0_ INNER JOIN video_testimonial_instruments v2_ ON v0_.id = v2_.video_testimonial_id INNER JOIN instruments i1_ ON i1_.id = v2_.instrument_id WHERE LOWER(i1_.name) = ? AND v0_.is_enabled = ? ORDER BY v0_.position ASC
Parameters:
[
  "guitar"
  1
]

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\Course No errors.
App\Entity\SongInstrument No errors.
App\Entity\Review No errors.
App\Entity\Accompaniment No errors.
App\Entity\Plan No errors.
App\Entity\Coupon No errors.
App\Entity\PlansGroupDescription No errors.
App\Entity\Permission No errors.
App\Entity\Exercise No errors.
App\Entity\Faq No errors.
App\Entity\LessonFaq No errors.
App\Entity\SaleBannerType
  • The association App\Entity\SaleBannerType#salesBanners refers to the owning side field App\Entity\SaleBanner#sale_banner_type which does not exist.
App\Entity\Song No errors.
App\Entity\SongAccompaniment 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\SalePage No errors.
App\Entity\Order No errors.
App\Entity\UserLogin No errors.
App\Entity\AnonymousEasyVersionAccess No errors.
App\Entity\CrossSaleDiscount No errors.
App\Entity\LegacyData No errors.
App\Entity\ReportLogs No errors.
App\Entity\SongLyricsVersionHistory No errors.
App\Entity\Statistic No errors.
App\Entity\UserAcceptance No errors.
App\Entity\SendInBlueTask No errors.
App\Entity\UserLog No errors.
App\Entity\VideoClick No errors.
App\Entity\StaticPage No errors.
App\Entity\TempPaymentData No errors.
App\Entity\StartedToRegister No errors.
App\Entity\FreeViewTimer No errors.
App\Entity\Subscription
  • The mappings App\Entity\Subscription#freezedData and App\Entity\FreezedData#subscription are inconsistent with each other.
App\Entity\FailedSearch No errors.
App\Entity\FreezedData
  • The association App\Entity\FreezedData#user refers to the inverse side field App\Entity\User#users which does not exist.
  • The association App\Entity\FreezedData#subscription refers to the inverse side field App\Entity\Subscription#subscriptions which does not exist.
App\Entity\FailedPelecardPayment No errors.
App\Entity\WatermarkLog No errors.
App\Entity\UserTracker No errors.
App\Entity\UserProfile No errors.
App\Entity\CrossSaleDiscountReligious No errors.
App\Entity\UserSongAccess No errors.
App\Entity\Chord No errors.
App\Entity\User
  • The mappings App\Entity\User#freezedData and App\Entity\FreezedData#user are inconsistent with each other.
  • The association App\Entity\User#course refers to the inverse side field App\Entity\Course#users which does not exist.
App\Entity\CustomPaymentPage No errors.
App\Entity\UserEasyVersionAccess No errors.
App\Entity\UserFavoriteList
  • The association App\Entity\UserFavoriteList#user refers to the inverse side field App\Entity\User#userFavoriteLists which does not exist.
App\Entity\StoreRegistrationSurvey No errors.
App\Entity\ChordEditorSave No errors.
App\Entity\SearchMatch No errors.
Vich\UploaderBundle\Entity\File No errors.