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

Query Metrics

9 Database Queries
7 Different statements
11.66 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.30 ms
(54.05%)
1
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.subtitle AS subtitle_3, t0.preview AS preview_4, t0.text AS text_5, t0.published AS published_6, t0.publish_at AS publish_at_7, t0.pinned AS pinned_8, t0.deleted AS deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12, t0.owner_uuid AS owner_uuid_13, t0.owner_active AS owner_active_14, t0.owner_deleted AS owner_deleted_15, t0.interval_from AS interval_from_16, t0.interval_to AS interval_to_17, t0.image_id AS image_id_18, t0.type_id AS type_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM news t0 WHERE t0.id = ?
Parameters:
[
  "172"
]
2.05 ms
(17.62%)
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_.publish_at <= ? AND n1_.locale = ? AND n0_.id NOT IN (?) ORDER BY n0_.pinned DESC, n0_.publish_at DESC, n0_.id DESC LIMIT 6
Parameters:
[
  "news"
  "2024-11-21 13:26:10"
  "ru"
  172
]
1.13 ms
(9.65%)
3
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"
]
0.78 ms
(6.71%)
1
SELECT u0_.type AS type_0 FROM uuid_owners u0_ WHERE u0_.uuid = ?
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
]
0.49 ms
(4.21%)
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, 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, o0_.level_id AS level_id_24, o0_.logo_id AS logo_id_25, o0_.created_by_id AS created_by_id_26, o0_.updated_by_id AS updated_by_id_27, f1_.created_by_id AS created_by_id_28 FROM olympiad o0_ LEFT JOIN files f1_ ON o0_.logo_id = f1_.id WHERE (o0_.active = 1 AND o0_.deleted = 0) AND o0_.uuid = ?
Parameters:
[
  "01caeded-51df-41fa-949f-ffef642f9fc5"
]
0.47 ms
(4.00%)
1
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.subtitle AS subtitle_3, t0.preview AS preview_4, t0.text AS text_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM news_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  172
]
0.44 ms
(3.75%)
1
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
]

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.