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

Query Metrics

38 Database Queries
11 Different statements
70.69 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.20 ms
(18.67%)
1
SELECT n0_.id AS id_0, n0_.caption AS caption_1, n0_.subtitle AS subtitle_2, n0_.preview AS preview_3, n0_.text AS text_4, n0_.published AS published_5, n0_.publish_at AS publish_at_6, n0_.pinned AS pinned_7, n0_.deleted AS deleted_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.uuid AS uuid_11, n0_.owner_uuid AS owner_uuid_12, n0_.owner_active AS owner_active_13, n0_.owner_deleted AS owner_deleted_14, n0_.interval_from AS interval_from_15, n0_.interval_to AS interval_to_16, n1_.id AS id_17, n1_.caption AS caption_18, n1_.subtitle AS subtitle_19, n1_.preview AS preview_20, n1_.text AS text_21, n1_.locale AS locale_22, f2_.id AS id_23, f2_.public AS public_24, f2_.created_at AS created_at_25, f2_.data_name AS data_name_26, f2_.data_original_name AS data_original_name_27, f2_.data_mime_type AS data_mime_type_28, f2_.data_dimensions AS data_dimensions_29, f2_.data_size AS data_size_30, f2_.owner_uuid AS owner_uuid_31, f2_.owner_active AS owner_active_32, f2_.owner_deleted AS owner_deleted_33, n3_.id AS id_34, n3_.caption AS caption_35, n3_.slug AS slug_36, n3_.type AS type_37, n3_.deleted AS deleted_38, n3_.active AS active_39, n0_.image_id AS image_id_40, n0_.type_id AS type_id_41, n0_.created_by_id AS created_by_id_42, n0_.updated_by_id AS updated_by_id_43, n1_.translatable_id AS translatable_id_44, f2_.created_by_id AS created_by_id_45 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 n3_.type = ? AND n0_.owner_uuid = ? AND n0_.publish_at <= ? AND n1_.locale = ? ORDER BY n0_.pinned DESC, n0_.publish_at DESC, n0_.id DESC LIMIT 4
Parameters:
[
  "news"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "2024-11-21 08:06:30"
  "ru"
]
12.42 ms
(17.57%)
15
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"
]
9.78 ms
(13.84%)
1
SELECT o0_.id AS id_0, o0_.caption AS caption_1, o0_.subtitle AS subtitle_2, o0_.mainpage AS mainpage_3, o0_.description AS description_4, o0_.results AS results_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_.subtitle AS subtitle_15, o1_.description AS description_16, o1_.results AS results_17, o1_.date_string AS date_string_18, o1_.locale AS locale_19, o0_.level_id AS level_id_20, o0_.logo_id AS logo_id_21, o0_.created_by_id AS created_by_id_22, o0_.updated_by_id AS updated_by_id_23, o1_.translatable_id AS translatable_id_24 FROM olympiad o0_ LEFT JOIN olympiad_translation o1_ ON o0_.id = o1_.translatable_id WHERE (o0_.active = 1 AND o0_.deleted = 0) AND o0_.id = ?
Parameters:
[
  60
]
9.40 ms
(13.30%)
2
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.71 ms
(10.91%)
13
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"
]
5.23 ms
(7.40%)
1
SELECT s0_.id AS id_0, s0_.link AS link_1, s0_.publish_at AS publish_at_2, s0_.deleted AS deleted_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.weight AS weight_6, s0_.active AS active_7, s0_.owner_uuid AS owner_uuid_8, s0_.owner_active AS owner_active_9, s0_.owner_deleted AS owner_deleted_10, s1_.id AS id_11, s1_.caption AS caption_12, s1_.short_text AS short_text_13, s1_.text AS text_14, s1_.locale AS locale_15, s0_.created_by_id AS created_by_id_16, s0_.updated_by_id AS updated_by_id_17, s1_.translatable_id AS translatable_id_18 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 LIMIT 2
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "ru"
]
4.26 ms
(6.03%)
1
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
]
3.84 ms
(5.44%)
1
SELECT g0_.id AS id_0, g0_.weight AS weight_1, g0_.type AS type_2, g0_.data AS data_3, g0_.deleted AS deleted_4, g0_.created_at AS created_at_5, g0_.updated_at AS updated_at_6, g0_.active AS active_7, f1_.id AS id_8, f1_.public AS public_9, f1_.created_at AS created_at_10, f1_.data_name AS data_name_11, f1_.data_original_name AS data_original_name_12, f1_.data_mime_type AS data_mime_type_13, f1_.data_dimensions AS data_dimensions_14, f1_.data_size AS data_size_15, f1_.owner_uuid AS owner_uuid_16, f1_.owner_active AS owner_active_17, f1_.owner_deleted AS owner_deleted_18, g0_.file_id AS file_id_19, g0_.album_id AS album_id_20, g0_.created_by_id AS created_by_id_21, g0_.updated_by_id AS updated_by_id_22, f1_.created_by_id AS created_by_id_23 FROM gallery_photo g0_ INNER JOIN files f1_ ON g0_.file_id = f1_.id WHERE g0_.album_id = ? AND g0_.deleted = 0 AND g0_.active = 1 ORDER BY g0_.weight DESC, g0_.created_at ASC
Parameters:
[
  18
]
3.44 ms
(4.86%)
1
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"
]
0.80 ms
(1.12%)
1
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-11-21 08:06:30"
  "ru"
]
0.60 ms
(0.85%)
1
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"
]

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\OlympiadTranslation 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\Common\Contact 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.
App\Entity\Site\Config No errors.
App\Entity\Gallery\Photo No errors.
App\Entity\Gallery\Album 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\Content\Parts\TextBlock No errors.
App\Entity\Content\Parts\TextBlockTranslation No errors.