Symfony Profiler

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 = ?

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 = '172';

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

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 = 'news' AND n0_.publish_at <= '2024-11-21 09:46:55' AND n1_.locale = 'en' AND n0_.id NOT IN (172) ORDER BY n0_.pinned DESC, n0_.publish_at DESC, n0_.id DESC LIMIT 6;

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 = ?

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 = 172;

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 = ?

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 = 'mainpage';

SELECT
  u0_.type AS type_0
FROM
  uuid_owners u0_
WHERE
  u0_.uuid = ?

SELECT u0_.type AS type_0 FROM uuid_owners u0_ WHERE u0_.uuid = '01caeded-51df-41fa-949f-ffef642f9fc5';

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 = ?

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 = '01caeded-51df-41fa-949f-ffef642f9fc5';

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 = ?

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 = 60;

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 = ?

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 = 'footer';

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 = ?

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 = 'footer';