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.name AS name_2,
  t0.slug AS slug_3,
  t0.email AS email_4,
  t0.site AS site_5,
  t0.you_tube_movie AS you_tube_movie_6,
  t0.description AS description_7,
  t0.manager_info AS manager_info_8,
  t0.contact_info AS contact_info_9,
  t0.closing_condition AS closing_condition_10,
  t0.closing_condition_comment AS closing_condition_comment_11,
  t0.address AS address_12,
  t0.latitude AS latitude_13,
  t0.longitude AS longitude_14,
  t0.expired_at AS expired_at_15,
  t0.placement_period AS placement_period_16,
  t0.placement_date AS placement_date_17,
  t0.min_price AS min_price_18,
  t0.min_capacity AS min_capacity_19,
  t0.max_capacity AS max_capacity_20,
  t0.view AS view_21,
  t0.phone_view AS phone_view_22,
  t0.site_view AS site_view_23,
  t0.address_view AS address_view_24,
  t0.booking_count AS booking_count_25,
  t0.award_participating AS award_participating_26,
  t0.paid AS paid_27,
  t0.display AS display_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.image_id AS image_id_31,
  t0.appearance_image_id AS appearance_image_id_32,
  t0.interior_image_id AS interior_image_id_33,
  t0.menu_id AS menu_id_34,
  t0.presentation_id AS presentation_id_35,
  t0.manager_id AS manager_id_36,
  t0.region_id AS region_id_37,
  t0.city_id AS city_id_38,
  t0.district_id AS district_id_39
FROM
  area t0
WHERE
  t0.slug = ?
  AND t0.display = ?
  AND (
    (t0.region_id = '1')
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.email AS email_4, t0.site AS site_5, t0.you_tube_movie AS you_tube_movie_6, t0.description AS description_7, t0.manager_info AS manager_info_8, t0.contact_info AS contact_info_9, t0.closing_condition AS closing_condition_10, t0.closing_condition_comment AS closing_condition_comment_11, t0.address AS address_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.expired_at AS expired_at_15, t0.placement_period AS placement_period_16, t0.placement_date AS placement_date_17, t0.min_price AS min_price_18, t0.min_capacity AS min_capacity_19, t0.max_capacity AS max_capacity_20, t0.view AS view_21, t0.phone_view AS phone_view_22, t0.site_view AS site_view_23, t0.address_view AS address_view_24, t0.booking_count AS booking_count_25, t0.award_participating AS award_participating_26, t0.paid AS paid_27, t0.display AS display_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.image_id AS image_id_31, t0.appearance_image_id AS appearance_image_id_32, t0.interior_image_id AS interior_image_id_33, t0.menu_id AS menu_id_34, t0.presentation_id AS presentation_id_35, t0.manager_id AS manager_id_36, t0.region_id AS region_id_37, t0.city_id AS city_id_38, t0.district_id AS district_id_39 FROM area t0 WHERE t0.slug = 'ponton-hall' AND t0.display = 1 AND ((t0.region_id = '1')) LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  area
SET
  view = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE area SET view = 6636, updated_at = '2024-11-26 16:44:06' WHERE id = 1926;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.token AS token_3,
  t0.source AS source_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.area_id AS area_id_7
FROM
  integration_crm t0
WHERE
  t0.area_id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.token AS token_3, t0.source AS source_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.area_id AS area_id_7 FROM integration_crm t0 WHERE t0.area_id = 1926;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.email AS email_3,
  a0_.site AS site_4,
  a0_.you_tube_movie AS you_tube_movie_5,
  a0_.description AS description_6,
  a0_.manager_info AS manager_info_7,
  a0_.contact_info AS contact_info_8,
  a0_.closing_condition AS closing_condition_9,
  a0_.closing_condition_comment AS closing_condition_comment_10,
  a0_.address AS address_11,
  a0_.latitude AS latitude_12,
  a0_.longitude AS longitude_13,
  a0_.expired_at AS expired_at_14,
  a0_.placement_period AS placement_period_15,
  a0_.placement_date AS placement_date_16,
  a0_.min_price AS min_price_17,
  a0_.min_capacity AS min_capacity_18,
  a0_.max_capacity AS max_capacity_19,
  a0_.view AS view_20,
  a0_.phone_view AS phone_view_21,
  a0_.site_view AS site_view_22,
  a0_.address_view AS address_view_23,
  a0_.booking_count AS booking_count_24,
  a0_.award_participating AS award_participating_25,
  a0_.paid AS paid_26,
  a0_.display AS display_27,
  a0_.created_at AS created_at_28,
  a0_.updated_at AS updated_at_29,
  f1_.id AS id_30,
  f1_.title AS title_31,
  f1_.slug AS slug_32,
  f1_.genitive_title AS genitive_title_33,
  f1_.dative_title AS dative_title_34,
  f1_.accusative_title AS accusative_title_35,
  f1_.instrumental_title AS instrumental_title_36,
  f1_.prepositional_title AS prepositional_title_37,
  f1_.created_at AS created_at_38,
  f1_.updated_at AS updated_at_39,
  f2_.id AS id_40,
  f2_.title AS title_41,
  f2_.slug AS slug_42,
  f2_.genitive_title AS genitive_title_43,
  f2_.dative_title AS dative_title_44,
  f2_.accusative_title AS accusative_title_45,
  f2_.instrumental_title AS instrumental_title_46,
  f2_.prepositional_title AS prepositional_title_47,
  f2_.created_at AS created_at_48,
  f2_.updated_at AS updated_at_49,
  a0_.image_id AS image_id_50,
  a0_.appearance_image_id AS appearance_image_id_51,
  a0_.interior_image_id AS interior_image_id_52,
  a0_.menu_id AS menu_id_53,
  a0_.presentation_id AS presentation_id_54,
  a0_.manager_id AS manager_id_55,
  a0_.region_id AS region_id_56,
  a0_.city_id AS city_id_57,
  a0_.district_id AS district_id_58,
  f1_.region_id AS region_id_59,
  f2_.city_id AS city_id_60
FROM
  area a0_
  INNER JOIN filter_city f1_ ON a0_.city_id = f1_.id
  AND (f1_.region_id = '1')
  LEFT JOIN filter_metro_area f3_ ON a0_.id = f3_.area_id
  LEFT JOIN filter_metro f2_ ON f2_.id = f3_.filter_metro_id
WHERE
  (
    a0_.display = 1
    AND a0_.paid = 1
  )
  AND (a0_.region_id = '1')
ORDER BY
  RAND() ASC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.email AS email_3, a0_.site AS site_4, a0_.you_tube_movie AS you_tube_movie_5, a0_.description AS description_6, a0_.manager_info AS manager_info_7, a0_.contact_info AS contact_info_8, a0_.closing_condition AS closing_condition_9, a0_.closing_condition_comment AS closing_condition_comment_10, a0_.address AS address_11, a0_.latitude AS latitude_12, a0_.longitude AS longitude_13, a0_.expired_at AS expired_at_14, a0_.placement_period AS placement_period_15, a0_.placement_date AS placement_date_16, a0_.min_price AS min_price_17, a0_.min_capacity AS min_capacity_18, a0_.max_capacity AS max_capacity_19, a0_.view AS view_20, a0_.phone_view AS phone_view_21, a0_.site_view AS site_view_22, a0_.address_view AS address_view_23, a0_.booking_count AS booking_count_24, a0_.award_participating AS award_participating_25, a0_.paid AS paid_26, a0_.display AS display_27, a0_.created_at AS created_at_28, a0_.updated_at AS updated_at_29, f1_.id AS id_30, f1_.title AS title_31, f1_.slug AS slug_32, f1_.genitive_title AS genitive_title_33, f1_.dative_title AS dative_title_34, f1_.accusative_title AS accusative_title_35, f1_.instrumental_title AS instrumental_title_36, f1_.prepositional_title AS prepositional_title_37, f1_.created_at AS created_at_38, f1_.updated_at AS updated_at_39, f2_.id AS id_40, f2_.title AS title_41, f2_.slug AS slug_42, f2_.genitive_title AS genitive_title_43, f2_.dative_title AS dative_title_44, f2_.accusative_title AS accusative_title_45, f2_.instrumental_title AS instrumental_title_46, f2_.prepositional_title AS prepositional_title_47, f2_.created_at AS created_at_48, f2_.updated_at AS updated_at_49, a0_.image_id AS image_id_50, a0_.appearance_image_id AS appearance_image_id_51, a0_.interior_image_id AS interior_image_id_52, a0_.menu_id AS menu_id_53, a0_.presentation_id AS presentation_id_54, a0_.manager_id AS manager_id_55, a0_.region_id AS region_id_56, a0_.city_id AS city_id_57, a0_.district_id AS district_id_58, f1_.region_id AS region_id_59, f2_.city_id AS city_id_60 FROM area a0_ INNER JOIN filter_city f1_ ON a0_.city_id = f1_.id AND (f1_.region_id = '1') LEFT JOIN filter_metro_area f3_ ON a0_.id = f3_.area_id LEFT JOIN filter_metro f2_ ON f2_.id = f3_.filter_metro_id WHERE (a0_.display = 1 AND a0_.paid = 1) AND (a0_.region_id = '1') ORDER BY RAND() ASC LIMIT 4;

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.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/area/ponton-hall' 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.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  filter_type t0
  INNER JOIN filter_type_area ON t0.id = filter_type_area.filter_type_id
WHERE
  filter_type_area.area_id = ?

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.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM filter_type t0 INNER JOIN filter_type_area ON t0.id = filter_type_area.filter_type_id WHERE filter_type_area.area_id = 1926;

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;