GET https://xm7.skiyurt.kg/lesson/class/10?page=1

Query Metrics

14 Database Queries
11 Different statements
108.73 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
91.83 ms
(84.46%)
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/10?page=1"
]
3.39 ms
(3.12%)
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:
[
  10
]
2.67 ms
(2.46%)
1
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM edu_field_classes_lessons e0_ WHERE e0_.edu_field_class_id = ?
Parameters:
[
  10
]
2.16 ms
(1.98%)
3
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:
[
  12
]
2.13 ms
(1.96%)
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.50 ms
(1.38%)
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.39 ms
(1.28%)
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:
[
  3
]
1.33 ms
(1.22%)
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:
[
  10
  88
  91
  92
]
0.86 ms
(0.79%)
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/10"
]
0.74 ms
(0.68%)
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:
[
  2
]
0.73 ms
(0.67%)
1
SELECT DISTINCT e0_.id AS id_0 FROM edu_field_classes_lessons e0_ WHERE e0_.edu_field_class_id = ? LIMIT 3
Parameters:
[
  10
]

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