Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.genitive_title AS genitive_title_4,
  t0.dative_title AS dative_title_5,
  t0.accusative_title AS accusative_title_6,
  t0.instrumental_title AS instrumental_title_7,
  t0.prepositional_title AS prepositional_title_8,
  t0.default AS default_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  region t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0 WHERE t0.slug = 'msk' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.active AS active_3,
  t0.archive AS archive_4,
  t0.about AS about_5,
  t0.destinations AS destinations_6,
  t0.start AS start_7,
  t0.end AS end_8,
  t0.application_end AS application_end_9,
  t0.voting_start AS voting_start_10,
  t0.voting_end AS voting_end_11,
  t0.create_short_list_start AS create_short_list_start_12,
  t0.create_short_list_end AS create_short_list_end_13,
  t0.adjudicator_voting_start AS adjudicator_voting_start_14,
  t0.adjudicator_voting_end AS adjudicator_voting_end_15,
  t0.rewarding AS rewarding_16,
  t0.phone AS phone_17,
  t0.email AS email_18,
  t0.whats_app AS whats_app_19,
  t0.website AS website_20,
  t0.position AS position_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.about_image_id AS about_image_id_24,
  t0.destinations_image_id AS destinations_image_id_25,
  t0.stages_image_id AS stages_image_id_26,
  t0.banner_image_id AS banner_image_id_27,
  t0.presentation_id AS presentation_id_28,
  t0.regulations_id AS regulations_id_29
FROM
  award t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.archive AS archive_4, t0.about AS about_5, t0.destinations AS destinations_6, t0.start AS start_7, t0.end AS end_8, t0.application_end AS application_end_9, t0.voting_start AS voting_start_10, t0.voting_end AS voting_end_11, t0.create_short_list_start AS create_short_list_start_12, t0.create_short_list_end AS create_short_list_end_13, t0.adjudicator_voting_start AS adjudicator_voting_start_14, t0.adjudicator_voting_end AS adjudicator_voting_end_15, t0.rewarding AS rewarding_16, t0.phone AS phone_17, t0.email AS email_18, t0.whats_app AS whats_app_19, t0.website AS website_20, t0.position AS position_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.about_image_id AS about_image_id_24, t0.destinations_image_id AS destinations_image_id_25, t0.stages_image_id AS stages_image_id_26, t0.banner_image_id AS banner_image_id_27, t0.presentation_id AS presentation_id_28, t0.regulations_id AS regulations_id_29 FROM award t0 WHERE t0.active = 1 LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.active AS active_2,
  a0_.archive AS archive_3,
  a0_.about AS about_4,
  a0_.destinations AS destinations_5,
  a0_.start AS start_6,
  a0_.end AS end_7,
  a0_.application_end AS application_end_8,
  a0_.voting_start AS voting_start_9,
  a0_.voting_end AS voting_end_10,
  a0_.create_short_list_start AS create_short_list_start_11,
  a0_.create_short_list_end AS create_short_list_end_12,
  a0_.adjudicator_voting_start AS adjudicator_voting_start_13,
  a0_.adjudicator_voting_end AS adjudicator_voting_end_14,
  a0_.rewarding AS rewarding_15,
  a0_.phone AS phone_16,
  a0_.email AS email_17,
  a0_.whats_app AS whats_app_18,
  a0_.website AS website_19,
  a0_.position AS position_20,
  a0_.created_at AS created_at_21,
  a0_.updated_at AS updated_at_22,
  a0_.about_image_id AS about_image_id_23,
  a0_.destinations_image_id AS destinations_image_id_24,
  a0_.stages_image_id AS stages_image_id_25,
  a0_.banner_image_id AS banner_image_id_26,
  a0_.presentation_id AS presentation_id_27,
  a0_.regulations_id AS regulations_id_28
FROM
  award a0_
ORDER BY
  a0_.position ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.archive AS archive_3, a0_.about AS about_4, a0_.destinations AS destinations_5, a0_.start AS start_6, a0_.end AS end_7, a0_.application_end AS application_end_8, a0_.voting_start AS voting_start_9, a0_.voting_end AS voting_end_10, a0_.create_short_list_start AS create_short_list_start_11, a0_.create_short_list_end AS create_short_list_end_12, a0_.adjudicator_voting_start AS adjudicator_voting_start_13, a0_.adjudicator_voting_end AS adjudicator_voting_end_14, a0_.rewarding AS rewarding_15, a0_.phone AS phone_16, a0_.email AS email_17, a0_.whats_app AS whats_app_18, a0_.website AS website_19, a0_.position AS position_20, a0_.created_at AS created_at_21, a0_.updated_at AS updated_at_22, a0_.about_image_id AS about_image_id_23, a0_.destinations_image_id AS destinations_image_id_24, a0_.stages_image_id AS stages_image_id_25, a0_.banner_image_id AS banner_image_id_26, a0_.presentation_id AS presentation_id_27, a0_.regulations_id AS regulations_id_28 FROM award a0_ ORDER BY a0_.position ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          f0_.id AS id_0,
          f0_.hash AS hash_1,
          f0_.path AS path_2,
          f0_.link AS link_3,
          f0_.name AS name_4,
          f0_.file_name AS file_name_5,
          f0_.mime_type AS mime_type_6,
          f0_.size AS size_7,
          f0_.created_at AS created_at_8,
          f0_.updated_at AS updated_at_9
        FROM
          file f0_
          INNER JOIN award_image a2_ ON f0_.id = a2_.file_id
          INNER JOIN award a1_ ON a1_.id = a2_.award_id
        WHERE
          a1_.id = 1
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.hash AS hash_1, f0_.path AS path_2, f0_.link AS link_3, f0_.name AS name_4, f0_.file_name AS file_name_5, f0_.mime_type AS mime_type_6, f0_.size AS size_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9 FROM file f0_ INNER JOIN award_image a2_ ON f0_.id = a2_.file_id INNER JOIN award a1_ ON a1_.id = a2_.award_id WHERE a1_.id = 1) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.link AS link_2,
  t0.title AS title_3,
  t0.h1 AS h1_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  seo_static_meta t0
WHERE
  t0.link = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.link AS link_2, t0.title AS title_3, t0.h1 AS h1_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM seo_static_meta t0 WHERE t0.link = '/msk/award/photo-report' LIMIT 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      f0_.id AS id_0,
      f0_.hash AS hash_1,
      f0_.path AS path_2,
      f0_.link AS link_3,
      f0_.name AS name_4,
      f0_.file_name AS file_name_5,
      f0_.mime_type AS mime_type_6,
      f0_.size AS size_7,
      f0_.created_at AS created_at_8,
      f0_.updated_at AS updated_at_9
    FROM
      file f0_
      INNER JOIN award_image a2_ ON f0_.id = a2_.file_id
      INNER JOIN award a1_ ON a1_.id = a2_.award_id
    WHERE
      a1_.id = 1
  ) dctrn_result
LIMIT
  16 OFFSET 48

SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.hash AS hash_1, f0_.path AS path_2, f0_.link AS link_3, f0_.name AS name_4, f0_.file_name AS file_name_5, f0_.mime_type AS mime_type_6, f0_.size AS size_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9 FROM file f0_ INNER JOIN award_image a2_ ON f0_.id = a2_.file_id INNER JOIN award a1_ ON a1_.id = a2_.award_id WHERE a1_.id = 1) dctrn_result LIMIT 16 OFFSET 48;

SELECT
  f0_.id AS id_0,
  f0_.hash AS hash_1,
  f0_.path AS path_2,
  f0_.link AS link_3,
  f0_.name AS name_4,
  f0_.file_name AS file_name_5,
  f0_.mime_type AS mime_type_6,
  f0_.size AS size_7,
  f0_.created_at AS created_at_8,
  f0_.updated_at AS updated_at_9
FROM
  file f0_
  INNER JOIN award_image a2_ ON f0_.id = a2_.file_id
  INNER JOIN award a1_ ON a1_.id = a2_.award_id
WHERE
  a1_.id = 1
  AND f0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT f0_.id AS id_0, f0_.hash AS hash_1, f0_.path AS path_2, f0_.link AS link_3, f0_.name AS name_4, f0_.file_name AS file_name_5, f0_.mime_type AS mime_type_6, f0_.size AS size_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9 FROM file f0_ INNER JOIN award_image a2_ ON f0_.id = a2_.file_id INNER JOIN award a1_ ON a1_.id = a2_.award_id WHERE a1_.id = 1 AND f0_.id IN (23887, 23888, 23889, 23890, 23891, 23892, 23893, 23894, 23895, 23896, 23897, 23898, 23899, 23900, 23901, 23902);

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.path AS path_3,
  t0.link AS link_4,
  t0.name AS name_5,
  t0.file_name AS file_name_6,
  t0.mime_type AS mime_type_7,
  t0.size AS size_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.path AS path_3, t0.link AS link_4, t0.name AS name_5, t0.file_name AS file_name_6, t0.mime_type AS mime_type_7, t0.size AS size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM file t0 WHERE t0.id = 23838;