GET https://olymp-test.k-m-v.su/documents

Query Metrics

39 Database Queries
12 Different statements
87.52 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.80 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.subtitle AS subtitle_3, t0.mainpage AS mainpage_4, t0.description AS description_5, t0.results AS results_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.uuid AS uuid_11, t0.interval_from AS interval_from_12, t0.interval_to AS interval_to_13, t0.level_id AS level_id_14, t0.logo_id AS logo_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM olympiad t0 WHERE t0.id = ?
Parameters:
[
  60
]
2 0.71 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c0_.created_by_id AS created_by_id_14, c0_.updated_by_id AS updated_by_id_15 FROM content_textblock c0_ WHERE c0_.deleted = 0 AND c0_.owner_uuid = ? AND c0_.slug = ? LIMIT 1
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "documents"
]
3 67.32 ms
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.category AS category_2, m0_.data AS data_3, m0_.caption AS caption_4, m0_.weight AS weight_5, m0_.published AS published_6, m0_.deleted AS deleted_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9, m0_.owner_uuid AS owner_uuid_10, m0_.owner_active AS owner_active_11, m0_.owner_deleted AS owner_deleted_12, m1_.id AS id_13, m1_.caption AS caption_14, m1_.locale AS locale_15, m0_.created_by_id AS created_by_id_16, m0_.updated_by_id AS updated_by_id_17, m1_.translatable_id AS translatable_id_18 FROM material m0_ LEFT JOIN material_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.deleted = 0 AND m0_.published = 1 AND m0_.owner_uuid = ? AND m0_.category IN (?) ORDER BY m0_.weight DESC, m0_.created_at ASC
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "for_participants"
]
4 0.96 ms
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.category AS category_2, m0_.data AS data_3, m0_.caption AS caption_4, m0_.weight AS weight_5, m0_.published AS published_6, m0_.deleted AS deleted_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9, m0_.owner_uuid AS owner_uuid_10, m0_.owner_active AS owner_active_11, m0_.owner_deleted AS owner_deleted_12, m1_.id AS id_13, m1_.caption AS caption_14, m1_.locale AS locale_15, m0_.created_by_id AS created_by_id_16, m0_.updated_by_id AS updated_by_id_17, m1_.translatable_id AS translatable_id_18 FROM material m0_ LEFT JOIN material_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.deleted = 0 AND m0_.published = 1 AND m0_.owner_uuid = ? AND m0_.category IN (?) ORDER BY m0_.weight DESC, m0_.created_at ASC
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "for_participants_standing_order"
]
5 0.57 ms
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.category AS category_2, m0_.data AS data_3, m0_.caption AS caption_4, m0_.weight AS weight_5, m0_.published AS published_6, m0_.deleted AS deleted_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9, m0_.owner_uuid AS owner_uuid_10, m0_.owner_active AS owner_active_11, m0_.owner_deleted AS owner_deleted_12, m1_.id AS id_13, m1_.caption AS caption_14, m1_.locale AS locale_15, m0_.created_by_id AS created_by_id_16, m0_.updated_by_id AS updated_by_id_17, m1_.translatable_id AS translatable_id_18 FROM material m0_ LEFT JOIN material_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.deleted = 0 AND m0_.published = 1 AND m0_.owner_uuid = ? AND m0_.category IN (?) ORDER BY m0_.weight DESC, m0_.created_at ASC
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "for_participants_vuz"
]
6 0.79 ms
SELECT o0_.id AS id_0, o0_.callback_email AS callback_email_1, o0_.deleted AS deleted_2, o0_.created_at AS created_at_3, o0_.updated_at AS updated_at_4, o0_.active AS active_5, o0_.owner_uuid AS owner_uuid_6, o0_.owner_active AS owner_active_7, o0_.owner_deleted AS owner_deleted_8, o0_.ri_from AS ri_from_9, o0_.ri_to AS ri_to_10, o0_.interval_from AS interval_from_11, o0_.interval_to AS interval_to_12, o1_.id AS id_13, o1_.caption AS caption_14, o1_.apply_button AS apply_button_15, o1_.force_locale AS force_locale_16, o1_.registration_enable AS registration_enable_17, o1_.apply_description AS apply_description_18, o1_.participant_types AS participant_types_19, o1_.countries AS countries_20, o1_.federal_districts AS federal_districts_21, o1_.deleted AS deleted_22, o1_.created_at AS created_at_23, o1_.updated_at AS updated_at_24, o1_.weight AS weight_25, o1_.active AS active_26, o1_.ro_from AS ro_from_27, o1_.ro_to AS ro_to_28, o1_.di_from AS di_from_29, o1_.di_to AS di_to_30, o1_.ti_from AS ti_from_31, o1_.ti_to AS ti_to_32, o2_.id AS id_33, o2_.caption AS caption_34, o2_.apply_button AS apply_button_35, o2_.apply_description AS apply_description_36, o2_.locale AS locale_37, o0_.created_by_id AS created_by_id_38, o0_.updated_by_id AS updated_by_id_39, o1_.event_id AS event_id_40, o1_.created_by_id AS created_by_id_41, o1_.updated_by_id AS updated_by_id_42, o2_.translatable_id AS translatable_id_43 FROM olymp_online o0_ LEFT JOIN olymp_online_category o1_ ON o0_.id = o1_.event_id AND (o1_.active = 1 AND o1_.deleted = 0) LEFT JOIN olymp_online_category_translation o2_ ON o1_.id = o2_.translatable_id WHERE o0_.deleted = 0 AND o0_.active = 1 AND o0_.owner_uuid = ? ORDER BY o1_.weight DESC
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
]
7 0.59 ms
SELECT o0_.id AS id_0, o0_.caption AS caption_1, o0_.description AS description_2, o0_.place AS place_3, o0_.place_short AS place_short_4, o0_.contacts AS contacts_5, o0_.deleted AS deleted_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.active AS active_9, o0_.uuid AS uuid_10, o0_.interval_from AS interval_from_11, o0_.interval_to AS interval_to_12, o1_.id AS id_13, o1_.caption AS caption_14, o1_.description AS description_15, o1_.place AS place_16, o1_.place_short AS place_short_17, o1_.contacts AS contacts_18, o1_.locale AS locale_19, o0_.olympiad_id AS olympiad_id_20, o0_.created_by_id AS created_by_id_21, o0_.updated_by_id AS updated_by_id_22, o1_.translatable_id AS translatable_id_23 FROM olympiad_stage o0_ LEFT JOIN olympiad_stage_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.olympiad_id = ? AND (o0_.active = 1 AND o0_.deleted = 0) ORDER BY o0_.interval_from ASC, o0_.interval_to ASC
Parameters:
[
  60
]
8 0.64 ms
SELECT o0_.id AS id_0, o0_.callback_email AS callback_email_1, o0_.deleted AS deleted_2, o0_.created_at AS created_at_3, o0_.updated_at AS updated_at_4, o0_.active AS active_5, o0_.owner_uuid AS owner_uuid_6, o0_.owner_active AS owner_active_7, o0_.owner_deleted AS owner_deleted_8, o0_.ri_from AS ri_from_9, o0_.ri_to AS ri_to_10, o0_.interval_from AS interval_from_11, o0_.interval_to AS interval_to_12, o1_.id AS id_13, o1_.caption AS caption_14, o1_.apply_button AS apply_button_15, o1_.force_locale AS force_locale_16, o1_.registration_enable AS registration_enable_17, o1_.apply_description AS apply_description_18, o1_.participant_types AS participant_types_19, o1_.countries AS countries_20, o1_.federal_districts AS federal_districts_21, o1_.deleted AS deleted_22, o1_.created_at AS created_at_23, o1_.updated_at AS updated_at_24, o1_.weight AS weight_25, o1_.active AS active_26, o1_.ro_from AS ro_from_27, o1_.ro_to AS ro_to_28, o1_.di_from AS di_from_29, o1_.di_to AS di_to_30, o1_.ti_from AS ti_from_31, o1_.ti_to AS ti_to_32, o2_.id AS id_33, o2_.caption AS caption_34, o2_.apply_button AS apply_button_35, o2_.apply_description AS apply_description_36, o2_.locale AS locale_37, o0_.created_by_id AS created_by_id_38, o0_.updated_by_id AS updated_by_id_39, o1_.event_id AS event_id_40, o1_.created_by_id AS created_by_id_41, o1_.updated_by_id AS updated_by_id_42, o2_.translatable_id AS translatable_id_43 FROM olymp_online o0_ LEFT JOIN olymp_online_category o1_ ON o0_.id = o1_.event_id AND (o1_.active = 1 AND o1_.deleted = 0) LEFT JOIN olymp_online_category_translation o2_ ON o1_.id = o2_.translatable_id WHERE o0_.deleted = 0 AND o0_.active = 1 AND o0_.owner_uuid = ? ORDER BY o1_.weight DESC
Parameters:
[
  "f06c74ad-bd0e-4cf0-b736-fdd6758908b3"
]
9 0.46 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM content_textblock_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  26
]
10 0.41 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.subtitle AS subtitle_3, t0.description AS description_4, t0.results AS results_5, t0.date_string AS date_string_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM olympiad_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  60
]
11 0.40 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "mainpage"
]
12 0.64 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "info"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
13 0.50 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "stages"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
14 0.45 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "for-participants"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
15 0.45 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "benefits"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
16 0.44 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "partners"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
17 0.44 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "jury"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
18 0.46 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "execute"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
19 0.43 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "organising"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
20 1.96 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ?
Parameters:
[
  "documents"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
]
21 0.55 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "enrollment"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
22 0.47 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "prepare"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
23 0.42 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "previous-years-assignments"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
24 0.42 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "rating"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
25 0.82 ms
SELECT count(n0_.id) AS sclr_0 FROM news n0_ LEFT JOIN news_translation n1_ ON n0_.id = n1_.translatable_id LEFT JOIN files f2_ ON n0_.image_id = f2_.id LEFT JOIN news_type n3_ ON n0_.type_id = n3_.id WHERE n0_.deleted = 0 AND n0_.published = 1 AND n0_.owner_active = 1 AND n0_.publish_at <= ? AND n1_.locale = ?
Parameters:
[
  "2024-12-12 17:40:22"
  "ru"
]
26 0.64 ms
SELECT count(s0_.id) AS sclr_0 FROM smi_item s0_ LEFT JOIN smi_item_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.owner_uuid = ? AND s0_.deleted = 0 AND s0_.active = 1 AND s0_.owner_active = 1 AND s1_.locale = ? ORDER BY s0_.weight DESC, s0_.publish_at DESC, s0_.id DESC
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
27 0.46 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.caption AS caption_2, c0_.content AS content_3, c0_.show_caption AS show_caption_4, c0_.main_menu AS main_menu_5, c0_.deleted AS deleted_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.active AS active_9, c0_.weight AS weight_10, c0_.owner_uuid AS owner_uuid_11, c0_.owner_active AS owner_active_12, c0_.owner_deleted AS owner_deleted_13, c1_.id AS id_14, c1_.caption AS caption_15, c1_.content AS content_16, c1_.locale AS locale_17, c0_.created_by_id AS created_by_id_18, c0_.updated_by_id AS updated_by_id_19, c1_.translatable_id AS translatable_id_20 FROM content_textblock c0_ LEFT JOIN content_textblock_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.deleted = 0 AND c0_.active = 1) AND c0_.slug = ? AND c0_.owner_uuid = ? AND c1_.locale = ?
Parameters:
[
  "program"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
28 0.48 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "olymp-right-block"
]
29 0.39 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "olymp-right-block"
]
30 0.39 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "olymp-right-block"
]
31 0.36 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "olymp-right-block"
]
32 0.35 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "olymp-right-block"
]
33 0.37 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "trial-test"
]
34 0.34 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "trial-test"
]
35 0.33 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "trial-test"
]
36 0.33 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "trial-test"
]
37 0.32 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "trial-test"
]
38 0.33 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "footer"
]
39 0.34 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.caption AS caption_2, s0_.value AS value_3, s0_.schema_array AS schema_array_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by_id AS created_by_id_8, s0_.updated_by_id AS updated_by_id_9 FROM site_config s0_ WHERE s0_.deleted = 0 AND s0_.slug = ?
Parameters:
[
  "footer"
]

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

Class Mapping errors
App\Entity\User\User No errors.
App\Entity\Common\DateInterval No errors.
App\Entity\Olympiad\Olympiad No errors.
App\Entity\Olympiad\Level No errors.
App\Entity\Common\UploadedData No errors.
App\Entity\Common\Owner No errors.
App\Entity\Common\File No errors.
App\Entity\Olympiad\Discipline No errors.
App\Entity\Olympiad\Grade No errors.
App\Entity\Olympiad\Stage No errors.
App\Entity\Common\Coord No errors.
App\Entity\Organisation\Organisation No errors.
App\Entity\Organisation\University\OlympPrivilegy No errors.
App\Entity\Scholar\Profile No errors.
App\Entity\Organisation\SuccessHistory No errors.
App\Entity\Olympiad\OlympiadTranslation No errors.
App\Entity\Content\Parts\TextBlock No errors.
App\Entity\Content\Parts\TextBlockTranslation No errors.
App\Entity\Content\Material No errors.
App\Entity\Content\MaterialTranslation No errors.
App\Entity\Olympiad\Online\Event No errors.
App\Entity\Common\DateTimeInterval No errors.
App\Entity\Common\TimeInterval No errors.
App\Entity\Olympiad\Online\Category No errors.
App\Entity\Olympiad\Online\CategoryTranslation No errors.
App\Entity\Olympiad\StageTranslation No errors.
App\Entity\Olympiad\Online\Direction No errors.
App\Entity\Olympiad\Online\CourseOverride No errors.
App\Entity\Site\Config No errors.
App\Entity\Content\News No errors.
App\Entity\Content\NewsTranslation No errors.
App\Entity\Content\NewsType No errors.
App\Entity\Content\SMI\SmiItem No errors.
App\Entity\Content\SMI\SmiItemTranslation No errors.