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

Response
200 OK
IP
3.15.182.29
Profiled on
Token
fff38a

Query Metrics

18 Database Queries
6 Different statements
214.80 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 31.69 ms 
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, f1_.id AS id_13, f1_.public AS public_14, f1_.created_at AS created_at_15, f1_.data_name AS data_name_16, f1_.data_original_name AS data_original_name_17, f1_.data_mime_type AS data_mime_type_18, f1_.data_dimensions AS data_dimensions_19, f1_.data_size AS data_size_20, f1_.owner_uuid AS owner_uuid_21, f1_.owner_active AS owner_active_22, f1_.owner_deleted AS owner_deleted_23, o2_.id AS id_24, o2_.caption AS caption_25, o2_.subtitle AS subtitle_26, o2_.description AS description_27, o2_.results AS results_28, o2_.date_string AS date_string_29, o2_.locale AS locale_30, o0_.level_id AS level_id_31, o0_.logo_id AS logo_id_32, o0_.created_by_id AS created_by_id_33, o0_.updated_by_id AS updated_by_id_34, f1_.created_by_id AS created_by_id_35, o2_.translatable_id AS translatable_id_36 FROM olympiad o0_ LEFT JOIN files f1_ ON o0_.logo_id = f1_.id LEFT JOIN olympiad_translation o2_ ON o0_.id = o2_.translatable_id WHERE o0_.id = ? AND o0_.deleted = 0
Parameters: 
[
  60
]
View formatted query    View runnable query    Explain query
2 115.88 ms 
SELECT f0_.id AS id_0, f0_.publish_at AS publish_at_1, f0_.deleted AS deleted_2, f0_.created_at AS created_at_3, f0_.updated_at AS updated_at_4, f0_.weight AS weight_5, f0_.active AS active_6, f0_.owner_uuid AS owner_uuid_7, f0_.owner_active AS owner_active_8, f0_.owner_deleted AS owner_deleted_9, f1_.id AS id_10, f1_.caption AS caption_11, f1_.text AS text_12, f1_.locale AS locale_13, f0_.created_by_id AS created_by_id_14, f0_.updated_by_id AS updated_by_id_15, f1_.translatable_id AS translatable_id_16 FROM faq f0_ LEFT JOIN faq_translation f1_ ON f0_.id = f1_.translatable_id WHERE f0_.deleted = 0 AND f0_.active = 1 AND f0_.owner_uuid = ? AND f1_.locale = ? ORDER BY f0_.weight DESC, f0_.created_at ASC
Parameters: 
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "en"
]
View formatted query    View runnable query    Explain query
3 21.07 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"
  "en"
]
View formatted query    View runnable query    Explain query
4 0.94 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"
  "en"
]
View formatted query    View runnable query    Explain query
5 1.06 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"
  "en"
]
View formatted query    View runnable query    Explain query
6 1.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: 
[
  "benefits"
  "01caeded-51df-41fa-949f-ffef642f9fc5"
  "en"
]
View formatted query    View runnable query    Explain query
7 0.68 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"
  "en"
]
View formatted query    View runnable query    Explain query
8 0.75 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"
  "en"
]
View formatted query    View runnable query    Explain query
9 0.66 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"
  "en"
]
View formatted query    View runnable query    Explain query
10 0.98 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"
  "en"
]
View formatted query    View runnable query    Explain query
11 1.51 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"
]
View formatted query    View runnable query    Explain query
12 0.91 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"
  "en"
]
View formatted query    View runnable query    Explain query
13 1.57 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"
  "en"
]
View formatted query    View runnable query    Explain query
14 1.11 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"
  "en"
]
View formatted query    View runnable query    Explain query
15 0.98 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"
  "en"
]
View formatted query    View runnable query    Explain query
16 23.09 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-10-22 11:20:54"
  "en"
]
View formatted query    View runnable query    Explain query
17 9.54 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"
  "en"
]
View formatted query    View runnable query    Explain query
18 0.94 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"
  "en"
]
View formatted query    View runnable query    Explain query

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\Common\UploadedData No errors.
App\Entity\Common\Owner No errors.
App\Entity\Common\File No errors.
App\Entity\Olympiad\OlympiadTranslation No errors.
App\Entity\Olympiad\Level 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\Content\FAQ\Faq No errors.
App\Entity\Content\FAQ\FaqTranslation No errors.
App\Entity\Content\Parts\TextBlock No errors.
App\Entity\Content\Parts\TextBlockTranslation 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.