GET https://xm7.skiyurt.kg/lesson/view/18/2

Query Metrics

10 Database Queries
9 Different statements
79.84 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 71.94 ms
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/view/18/2"
]
2 1.37 ms
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"
]
3 1.36 ms
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:
[
  2
]
4 1.02 ms
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 = ? LIMIT 1
Parameters:
[
  18
]
5 0.96 ms
SELECT t0.id AS id_1, t0.announce AS announce_2, t0.edu_field_class_id AS edu_field_class_id_3, t0.lesson_id AS lesson_id_4 FROM edu_field_classes_lessons t0 WHERE t0.edu_field_class_id = ?
Parameters:
[
  2
]
6 0.77 ms
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/view/18/2"
]
7 0.71 ms
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"
]
8 0.42 ms
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"
]
9 0.68 ms
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
]
10 0.60 ms
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
]

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