Query Metrics

54 Database Queries
10 Different statements
20.14 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 1.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.header AS header_5, t0.title_seo AS title_seo_6, t0.meta_title_seo AS meta_title_seo_7, t0.meta_description_seo AS meta_description_seo_8, t0.title_breadcrumb AS title_breadcrumb_9, t0.info AS info_10, t0.video AS video_11, t0.duration AS duration_12, t0.position AS position_13, t0.day AS day_14, t0.week AS week_15, t0.month AS month_16, t0.blocked_for_days AS blocked_for_days_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.group_id AS group_id_20, t0.group_title AS group_title_21, t0.course_id AS course_id_22, t0.permission_id AS permission_id_23 FROM lessons t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "איך-מכוונים-גיטרה"
]
2 0.57 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  5
]
3 0.39 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 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.93 ms
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.slug AS slug_3, l0_.header AS header_4, l0_.title_seo AS title_seo_5, l0_.meta_title_seo AS meta_title_seo_6, l0_.meta_description_seo AS meta_description_seo_7, l0_.title_breadcrumb AS title_breadcrumb_8, l0_.info AS info_9, l0_.video AS video_10, l0_.duration AS duration_11, l0_.position AS position_12, l0_.day AS day_13, l0_.week AS week_14, l0_.month AS month_15, l0_.blocked_for_days AS blocked_for_days_16, l0_.created_at AS created_at_17, l0_.updated_at AS updated_at_18, l0_.group_id AS group_id_19, l0_.group_title AS group_title_20, l0_.course_id AS course_id_21, l0_.permission_id AS permission_id_22 FROM lessons l0_ WHERE l0_.course_id = ? ORDER BY l0_.position ASC, l0_.group_id ASC
Parameters:
[
  1
]
5 0.34 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  1
]
6 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  2
]
7 0.27 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  6
]
8 0.31 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  4
]
9 0.27 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  7
]
10 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  8
]
11 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  9
]
12 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  10
]
13 0.27 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  11
]
14 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  12
]
15 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  14
]
16 0.27 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  15
]
17 0.71 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  16
]
18 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  17
]
19 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  18
]
20 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  19
]
21 0.31 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  20
]
22 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  21
]
23 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  22
]
24 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  23
]
25 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  24
]
26 0.34 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  25
]
27 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  26
]
28 0.31 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  27
]
29 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  28
]
30 0.32 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  29
]
31 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  30
]
32 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  31
]
33 0.32 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  32
]
34 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  33
]
35 0.31 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  34
]
36 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  35
]
37 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  144
]
38 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  145
]
39 0.27 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  146
]
40 0.34 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  147
]
41 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  148
]
42 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  149
]
43 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  150
]
44 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  3
]
45 0.34 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_id AS entity_id_3, t0.entity FROM faq t0 WHERE t0.entity_id = ? AND t0.entity IN ('lesson_faq')
Parameters:
[
  13
]
46 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM permissions t0 WHERE t0.id = ?
Parameters:
[
  3
]
47 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.header AS header_5, t0.title_seo AS title_seo_6, t0.meta_title_seo AS meta_title_seo_7, t0.meta_description_seo AS meta_description_seo_8, t0.title_breadcrumb AS title_breadcrumb_9, t0.info AS info_10, t0.video AS video_11, t0.duration AS duration_12, t0.position AS position_13, t0.day AS day_14, t0.week AS week_15, t0.month AS month_16, t0.blocked_for_days AS blocked_for_days_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.group_id AS group_id_20, t0.group_title AS group_title_21, t0.course_id AS course_id_22, t0.permission_id AS permission_id_23 FROM lessons t0 WHERE t0.course_id = ? AND t0.position = ? LIMIT 1
Parameters:
[
  1
  3
]
48 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.header AS header_5, t0.title_seo AS title_seo_6, t0.meta_title_seo AS meta_title_seo_7, t0.meta_description_seo AS meta_description_seo_8, t0.title_breadcrumb AS title_breadcrumb_9, t0.info AS info_10, t0.video AS video_11, t0.duration AS duration_12, t0.position AS position_13, t0.day AS day_14, t0.week AS week_15, t0.month AS month_16, t0.blocked_for_days AS blocked_for_days_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.group_id AS group_id_20, t0.group_title AS group_title_21, t0.course_id AS course_id_22, t0.permission_id AS permission_id_23 FROM lessons t0 WHERE t0.course_id = ? AND t0.position = ? LIMIT 1
Parameters:
[
  1
  5
]
49 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:
[
  1
]
50 0.65 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:
[
  "all-except-main-and-payment-pages"
]
51 0.41 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:
[
  "all-except-main-and-payment-pages"
]
52 0.37 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:
[
  "all-except-main-and-payment-pages"
]
53 0.42 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:
[]
54 1.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.file_name AS file_name_5, t0.file_unique_name AS file_unique_name_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.group_id AS group_id_11, t0.group_title AS group_title_12, t0.lesson_id AS lesson_id_13 FROM exercises t0 WHERE t0.lesson_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
  5
]

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\Course No errors.
App\Entity\Permission No errors.
App\Entity\Faq No errors.
App\Entity\LessonFaq No errors.
App\Entity\Exercise No errors.
App\Entity\SongInstrument No errors.
App\Entity\Review No errors.
App\Entity\Accompaniment 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\Plan 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\Coupon No errors.
App\Entity\TempPaymentData No errors.
App\Entity\StartedToRegister No errors.
App\Entity\PlansGroupDescription 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.
App\Entity\FormLog No errors.
Vich\UploaderBundle\Entity\File No errors.