GET https://xm7.skiyurt.kg/lesson/class/8?page=2

Query Metrics

13 Database Queries
11 Different statements
72.03 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
62.08 ms
(86.18%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.last_modified AS last_modified_3, t0.enabled AS enabled_4 FROM sitemap_url t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "https://xm7.skiyurt.kg/lesson/class/8?page=2"
]
1.48 ms
(2.05%)
1
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM edu_field_classes_lessons e0_ WHERE e0_.edu_field_class_id = ?
Parameters:
[
  8
]
1.34 ms
(1.86%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.enable_announce AS enable_announce_4, t0.published AS published_5, t0.icon AS icon_6, t0.editable AS editable_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.sysname AS sysname_10, t0.announce_text AS announce_text_11, t0.route AS route_12, t0.options AS options_13 FROM section t0 WHERE t0.sysname = ? LIMIT 1
Parameters:
[
  "lessons"
]
1.30 ms
(1.81%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.published AS published_4, t0.icon AS icon_5, t0.media_files AS media_files_6 FROM lesson t0 WHERE t0.id = ?
Parameters:
[
  7
]
1.27 ms
(1.76%)
2
SELECT t0.id AS id_1, t0.sysname AS sysname_2, t0.sysaval AS sysaval_3 FROM seo_settings t0 WHERE t0.sysname = ? LIMIT 1
Parameters:
[
  "ym"
]
1.20 ms
(1.66%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.announce AS announce_3, t0.edufield_id AS edufield_id_4, t0.scholar_class_id AS scholar_class_id_5 FROM edu_field_classes t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  8
]
0.86 ms
(1.19%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.description AS description_4, t0.published AS published_5, t0.sort AS sort_6 FROM edu_field t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.71 ms
(0.99%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5 FROM seo_meta t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "/lesson/class/8"
]
0.62 ms
(0.86%)
1
SELECT e0_.id AS id_0, e0_.announce AS announce_1, e0_.edu_field_class_id AS edu_field_class_id_2, e0_.lesson_id AS lesson_id_3 FROM edu_field_classes_lessons e0_ WHERE e0_.edu_field_class_id = ? AND e0_.id IN (?, ?)
Parameters:
[
  8
  85
  80
]
0.62 ms
(0.86%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.published AS published_4 FROM scholar_class t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.56 ms
(0.77%)
1
SELECT DISTINCT e0_.id AS id_0 FROM edu_field_classes_lessons e0_ WHERE e0_.edu_field_class_id = ? LIMIT 3 OFFSET 3
Parameters:
[
  8
]

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