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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
80.40 ms
(86.38%)
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/3?page=1"
]
2.59 ms
(2.78%)
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:
[
  1
]
1.86 ms
(2.00%)
1
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM edu_field_classes_lessons e0_ WHERE e0_.edu_field_class_id = ?
Parameters:
[
  3
]
1.62 ms
(1.74%)
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.52 ms
(1.63%)
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:
[
  3
]
1.46 ms
(1.56%)
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"
]
0.85 ms
(0.92%)
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:
[
  1
]
0.82 ms
(0.88%)
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/3"
]
0.70 ms
(0.75%)
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:
[
  3
  6
  1
  3
]
0.69 ms
(0.74%)
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:
[
  1
]
0.57 ms
(0.61%)
1
SELECT DISTINCT e0_.id AS id_0 FROM edu_field_classes_lessons e0_ WHERE e0_.edu_field_class_id = ? LIMIT 3
Parameters:
[
  3
]

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