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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.96 ms
(84.01%)
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/13?page=2"
]
1.86 ms
(2.75%)
1
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM edu_field_classes_lessons e0_ WHERE e0_.edu_field_class_id = ?
Parameters:
[
  13
]
1.49 ms
(2.20%)
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:
[
  20
]
1.48 ms
(2.19%)
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.42 ms
(2.09%)
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.21 ms
(1.79%)
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:
[
  13
]
0.83 ms
(1.22%)
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:
[
  4
]
0.70 ms
(1.03%)
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/13"
]
0.64 ms
(0.95%)
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.60 ms
(0.88%)
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:
[
  13
]
0.60 ms
(0.88%)
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:
[
  13
  105
  106
]

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