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
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.title AS title_1,
          p0_.slug AS slug_2,
          p0_.description AS description_3,
          p0_.publish_at AS publish_at_4,
          p0_.type AS type_5,
          p0_.display AS display_6,
          p0_.created_at AS created_at_7,
          p0_.updated_at AS updated_at_8
        FROM
          publication p0_
          LEFT JOIN area a1_ ON p0_.area_id = a1_.id
          AND (a1_.region_id = '1')
        WHERE
          p0_.type = 'promotion'
          AND p0_.display = 1
          AND (
            a1_.id IS NULL
            OR (
              a1_.paid = 1
              AND a1_.display = 1
            )
          )
        ORDER BY
          p0_.publish_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.publish_at AS publish_at_4, p0_.type AS type_5, p0_.display AS display_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM publication p0_ LEFT JOIN area a1_ ON p0_.area_id = a1_.id AND (a1_.region_id = '1') WHERE p0_.type = 'promotion' AND p0_.display = 1 AND (a1_.id IS NULL OR (a1_.paid = 1 AND a1_.display = 1)) ORDER BY p0_.publish_at DESC) 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/publication/promotion/' 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
  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

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;

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
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.link AS link_2,
  a0_.display AS display_3,
  a0_.created_at AS created_at_4,
  a0_.updated_at AS updated_at_5,
  f1_.id AS id_6,
  f1_.hash AS hash_7,
  f1_.path AS path_8,
  f1_.link AS link_9,
  f1_.name AS name_10,
  f1_.file_name AS file_name_11,
  f1_.mime_type AS mime_type_12,
  f1_.size AS size_13,
  f1_.created_at AS created_at_14,
  f1_.updated_at AS updated_at_15,
  a0_.image_id AS image_id_16
FROM
  advertising_homepage_tag a0_
  LEFT JOIN file f1_ ON a0_.image_id = f1_.id
WHERE
  a0_.display = 1
ORDER BY
  RAND() ASC
LIMIT
  14

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.link AS link_2, a0_.display AS display_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, f1_.id AS id_6, f1_.hash AS hash_7, f1_.path AS path_8, f1_.link AS link_9, f1_.name AS name_10, f1_.file_name AS file_name_11, f1_.mime_type AS mime_type_12, f1_.size AS size_13, f1_.created_at AS created_at_14, f1_.updated_at AS updated_at_15, a0_.image_id AS image_id_16 FROM advertising_homepage_tag a0_ LEFT JOIN file f1_ ON a0_.image_id = f1_.id WHERE a0_.display = 1 ORDER BY RAND() ASC LIMIT 14;

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
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_.created_at AS created_at_4,
  a0_.updated_at AS updated_at_5,
  a0_.event_id AS event_id_6
FROM
  area_event_selection a0_

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.event_id AS event_id_6 FROM area_event_selection a0_;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      publish_at_4
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.title AS title_1,
          p0_.slug AS slug_2,
          p0_.description AS description_3,
          p0_.publish_at AS publish_at_4,
          p0_.type AS type_5,
          p0_.display AS display_6,
          p0_.created_at AS created_at_7,
          p0_.updated_at AS updated_at_8,
          a1_.id AS id_9,
          a1_.name AS name_10,
          a1_.slug AS slug_11,
          a1_.email AS email_12,
          a1_.site AS site_13,
          a1_.you_tube_movie AS you_tube_movie_14,
          a1_.description AS description_15,
          a1_.manager_info AS manager_info_16,
          a1_.contact_info AS contact_info_17,
          a1_.closing_condition AS closing_condition_18,
          a1_.closing_condition_comment AS closing_condition_comment_19,
          a1_.address AS address_20,
          a1_.latitude AS latitude_21,
          a1_.longitude AS longitude_22,
          a1_.expired_at AS expired_at_23,
          a1_.placement_period AS placement_period_24,
          a1_.placement_date AS placement_date_25,
          a1_.min_price AS min_price_26,
          a1_.min_capacity AS min_capacity_27,
          a1_.max_capacity AS max_capacity_28,
          a1_.view AS view_29,
          a1_.phone_view AS phone_view_30,
          a1_.site_view AS site_view_31,
          a1_.address_view AS address_view_32,
          a1_.booking_count AS booking_count_33,
          a1_.award_participating AS award_participating_34,
          a1_.paid AS paid_35,
          a1_.display AS display_36,
          a1_.created_at AS created_at_37,
          a1_.updated_at AS updated_at_38
        FROM
          publication p0_
          LEFT JOIN area a1_ ON p0_.area_id = a1_.id
          AND (a1_.region_id = '1')
        WHERE
          p0_.type = 'promotion'
          AND p0_.display = 1
          AND (
            a1_.id IS NULL
            OR (
              a1_.paid = 1
              AND a1_.display = 1
            )
          )
      ) dctrn_result_inner
    ORDER BY
      publish_at_4 DESC
  ) dctrn_result
LIMIT
  15 OFFSET 225

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publish_at_4 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.publish_at AS publish_at_4, p0_.type AS type_5, p0_.display AS display_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, a1_.id AS id_9, a1_.name AS name_10, a1_.slug AS slug_11, a1_.email AS email_12, a1_.site AS site_13, a1_.you_tube_movie AS you_tube_movie_14, a1_.description AS description_15, a1_.manager_info AS manager_info_16, a1_.contact_info AS contact_info_17, a1_.closing_condition AS closing_condition_18, a1_.closing_condition_comment AS closing_condition_comment_19, a1_.address AS address_20, a1_.latitude AS latitude_21, a1_.longitude AS longitude_22, a1_.expired_at AS expired_at_23, a1_.placement_period AS placement_period_24, a1_.placement_date AS placement_date_25, a1_.min_price AS min_price_26, a1_.min_capacity AS min_capacity_27, a1_.max_capacity AS max_capacity_28, a1_.view AS view_29, a1_.phone_view AS phone_view_30, a1_.site_view AS site_view_31, a1_.address_view AS address_view_32, a1_.booking_count AS booking_count_33, a1_.award_participating AS award_participating_34, a1_.paid AS paid_35, a1_.display AS display_36, a1_.created_at AS created_at_37, a1_.updated_at AS updated_at_38 FROM publication p0_ LEFT JOIN area a1_ ON p0_.area_id = a1_.id AND (a1_.region_id = '1') WHERE p0_.type = 'promotion' AND p0_.display = 1 AND (a1_.id IS NULL OR (a1_.paid = 1 AND a1_.display = 1))) dctrn_result_inner ORDER BY publish_at_4 DESC) dctrn_result LIMIT 15 OFFSET 225;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.publish_at AS publish_at_4,
  p0_.type AS type_5,
  p0_.display AS display_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.image_id AS image_id_9,
  p0_.area_id AS area_id_10
FROM
  publication p0_
  LEFT JOIN area a1_ ON p0_.area_id = a1_.id
  AND (a1_.region_id = '1')
WHERE
  p0_.type = 'promotion'
  AND p0_.display = 1
  AND (
    a1_.id IS NULL
    OR (
      a1_.paid = 1
      AND a1_.display = 1
    )
  )
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.publish_at DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.publish_at AS publish_at_4, p0_.type AS type_5, p0_.display AS display_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.image_id AS image_id_9, p0_.area_id AS area_id_10 FROM publication p0_ LEFT JOIN area a1_ ON p0_.area_id = a1_.id AND (a1_.region_id = '1') WHERE p0_.type = 'promotion' AND p0_.display = 1 AND (a1_.id IS NULL OR (a1_.paid = 1 AND a1_.display = 1)) AND p0_.id IN (557, 558, 540, 33, 122, 34, 123, 124, 307, 252, 59, 125, 321, 60, 126) ORDER BY p0_.publish_at DESC;

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

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

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

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