Query Metrics

69 Database Queries
7 Different statements
19.09 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.99 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-יום-1-האף-ותפקידו-כמגבר-בשירה-נכונה"
]
2 0.87 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:
[
  211
]
3 0.40 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:
[
  12
]
4 1.05 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_.week IS NOT NULL AND l0_.course_id = ? ORDER BY l0_.week ASC, l0_.position ASC
Parameters:
[
  12
]
5 0.33 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:
[
  207
]
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:
[
  208
]
7 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:
[
  209
]
8 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:
[
  210
]
9 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:
[
  212
]
10 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:
[
  213
]
11 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:
[
  214
]
12 0.36 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:
[
  215
]
13 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:
[
  216
]
14 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:
[
  217
]
15 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:
[
  218
]
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:
[
  219
]
17 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:
[
  220
]
18 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:
[
  221
]
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:
[
  222
]
20 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:
[
  232
]
21 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:
[
  233
]
22 0.33 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:
[
  234
]
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:
[
  235
]
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:
[
  236
]
25 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:
[
  237
]
26 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:
[
  238
]
27 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:
[
  239
]
28 0.20 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:
[
  240
]
29 0.19 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:
[
  241
]
30 0.21 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:
[
  242
]
31 0.18 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:
[
  243
]
32 0.17 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:
[
  244
]
33 0.17 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:
[
  245
]
34 0.18 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:
[
  246
]
35 0.18 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:
[
  247
]
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:
[
  248
]
37 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:
[
  249
]
38 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:
[
  250
]
39 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:
[
  251
]
40 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:
[
  252
]
41 0.21 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:
[
  253
]
42 0.19 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:
[
  254
]
43 0.18 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:
[
  255
]
44 0.21 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:
[
  256
]
45 0.17 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:
[
  257
]
46 0.17 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:
[
  258
]
47 0.17 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:
[
  259
]
48 0.17 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:
[
  260
]
49 0.18 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:
[
  261
]
50 0.18 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:
[
  262
]
51 0.16 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:
[
  263
]
52 0.16 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:
[
  264
]
53 0.18 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:
[
  265
]
54 0.19 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:
[
  266
]
55 0.17 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:
[
  267
]
56 0.17 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:
[
  268
]
57 0.18 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:
[
  269
]
58 0.16 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:
[
  270
]
59 0.18 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:
[
  272
]
60 0.17 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:
[
  271
]
61 0.19 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:
[
  273
]
62 0.16 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:
[
  274
]
63 0.19 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:
[
  275
]
64 0.16 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:
[
  276
]
65 0.19 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:
[
  277
]
66 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM permissions t0 WHERE t0.id = ?
Parameters:
[
  2
]
67 0.31 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:
[
  12
  3
]
68 0.25 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:
[
  12
  5
]
69 0.39 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:
[
  4
]

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.