Query Metrics

50 Database Queries
9 Different statements
13.43 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.65 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.35 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:
[
  50
]
3 0.34 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:
[
  2
]
4 0.54 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:
[
  2
]
5 0.25 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:
[
  36
]
6 0.25 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:
[
  38
]
7 0.25 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:
[
  39
]
8 0.23 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:
[
  281
]
9 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:
[
  278
]
10 0.23 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:
[
  40
]
11 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:
[
  41
]
12 0.25 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:
[
  42
]
13 0.23 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:
[
  43
]
14 0.24 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:
[
  44
]
15 0.25 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:
[
  45
]
16 0.23 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:
[
  46
]
17 0.24 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:
[
  47
]
18 0.24 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:
[
  48
]
19 0.23 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:
[
  49
]
20 0.23 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:
[
  51
]
21 0.24 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:
[
  52
]
22 0.23 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:
[
  53
]
23 0.23 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:
[
  54
]
24 0.24 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:
[
  55
]
25 0.23 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:
[
  56
]
26 0.23 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:
[
  57
]
27 0.24 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:
[
  58
]
28 0.23 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:
[
  59
]
29 0.22 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:
[
  60
]
30 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:
[
  61
]
31 0.23 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:
[
  62
]
32 0.22 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:
[
  63
]
33 0.25 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:
[
  64
]
34 0.23 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:
[
  65
]
35 0.23 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:
[
  66
]
36 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:
[
  67
]
37 0.23 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:
[
  68
]
38 0.22 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:
[
  69
]
39 0.24 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:
[
  70
]
40 0.23 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:
[
  137
]
41 0.22 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:
[
  139
]
42 0.25 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:
[
  140
]
43 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM permissions t0 WHERE t0.id = ?
Parameters:
[
  3
]
44 0.34 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:
[
  2
  14
]
45 0.29 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:
[
  2
  16
]
46 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.id = ?
Parameters:
[
  2
]
47 0.43 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"
]
48 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:
[
  "all-except-main-and-payment-pages"
]
49 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:
[
  "all-except-main-and-payment-pages"
]
50 0.34 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
  • 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.