Symfony Profiler

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.domain = ?
  AND t0.main_alias = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/mobile/api/v2/beauty/offer/134458/masters' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.main_alias = ?
ORDER BY
  t0.id DESC

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = '/mobile/api/v2/beauty/offer/134458/masters' ORDER BY t0.id DESC;

SELECT
  o0_.title AS title_0,
  o0_.me_on_map_name AS me_on_map_name_1,
  o0_.explanation_text AS explanation_text_2,
  o0_.price AS price_3,
  o0_.old_price AS old_price_4,
  o0_.regular_price AS regular_price_5,
  o0_.offer_price AS offer_price_6,
  o0_.discount AS discount_7,
  o0_.active_since AS active_since_8,
  o0_.active_till AS active_till_9,
  o0_.code_active_till AS code_active_till_10,
  o0_.active AS active_11,
  o0_.hidden AS hidden_12,
  o0_.free AS free_13,
  o0_.without_codes AS without_codes_14,
  o0_.online_order_allowed AS online_order_allowed_15,
  o0_.buy_code_disable AS buy_code_disable_16,
  o0_.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_17,
  o0_.online_order_allowed_removed_at AS online_order_allowed_removed_at_18,
  o0_.show_price_in_conditions AS show_price_in_conditions_19,
  o0_.show_alt_offers AS show_alt_offers_20,
  o0_.show_currencies AS show_currencies_21,
  o0_.additional_percents AS additional_percents_22,
  o0_.address AS address_23,
  o0_.caption_name AS caption_name_24,
  o0_.caption_color AS caption_color_25,
  o0_.regional_caption_name AS regional_caption_name_26,
  o0_.regional_caption_color AS regional_caption_color_27,
  o0_.search_position AS search_position_28,
  o0_.active_search_position AS active_search_position_29,
  o0_.hint AS hint_30,
  o0_.bank_currency_id AS bank_currency_id_31,
  o0_.active_currency_calculator AS active_currency_calculator_32,
  o0_.last_modified AS last_modified_33,
  o0_.teaser_logo_width AS teaser_logo_width_34,
  o0_.teaser_logo_height AS teaser_logo_height_35,
  o0_.lucene_reindex AS lucene_reindex_36,
  o0_.code_cost AS code_cost_37,
  o0_.code_cost_by_count AS code_cost_by_count_38,
  o0_.default_category_id AS default_category_id_39,
  o0_.company_name AS company_name_40,
  o0_.renewed_on AS renewed_on_41,
  o0_.hide_novelty_label AS hide_novelty_label_42,
  o0_.hide_banners_in_comments AS hide_banners_in_comments_43,
  o0_.sum_for_free_delivery AS sum_for_free_delivery_44,
  o0_.delivery_price AS delivery_price_45,
  o0_.created_on AS created_on_46,
  o0_.allowed_buy_only_code AS allowed_buy_only_code_47,
  o0_.buy_code_button_text AS buy_code_button_text_48,
  o0_.buy_items_button_text AS buy_items_button_text_49,
  o0_.purchase_koeff AS purchase_koeff_50,
  o0_.telegram_bot_show AS telegram_bot_show_51,
  o0_.telegram_bot_position AS telegram_bot_position_52,
  o0_.version AS version_53,
  o0_.hide_in_app AS hide_in_app_54,
  o0_.brandbox_enabled AS brandbox_enabled_55,
  o0_.hide_features AS hide_features_56,
  o0_.discount_delivery_popup AS discount_delivery_popup_57,
  o0_.discount_pickup_popup AS discount_pickup_popup_58,
  o0_.delivery_time_teaser AS delivery_time_teaser_59,
  o0_.external_offer_link AS external_offer_link_60,
  o0_.is_show_external_offer_link AS is_show_external_offer_link_61,
  o0_.is_included_in_beauty AS is_included_in_beauty_62,
  o0_.qr_codes AS qr_codes_63,
  o0_.recurrent_disabled AS recurrent_disabled_64,
  o0_.available_on_food AS available_on_food_65,
  o0_.online_auto_opened AS online_auto_opened_66,
  o0_.foodcourt_logo_enabled AS foodcourt_logo_enabled_67,
  o0_.rating AS rating_68,
  o0_.foodcourt_info_teaser AS foodcourt_info_teaser_69,
  o0_.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_70,
  o0_.online_order_gift_enabled AS online_order_gift_enabled_71,
  o0_.buy_code_in_app_only AS buy_code_in_app_only_72,
  o0_.show_products_in_offer_description AS show_products_in_offer_description_73,
  o0_.check_address_in_offer_menu AS check_address_in_offer_menu_74,
  o0_.show_map_icon_in_app AS show_map_icon_in_app_75,
  o0_.viber AS viber_76,
  o0_.telegram AS telegram_77,
  o0_.messenger_callback AS messenger_callback_78,
  o0_.allowed_online_order_types AS allowed_online_order_types_79,
  o0_.title_font_color AS title_font_color_80,
  o0_.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_81,
  o0_.map_price AS map_price_82,
  o0_.map_rating AS map_rating_83,
  o0_.review AS review_84,
  o0_.on_review AS on_review_85,
  o0_.id AS id_86,
  o0_.bank_currency_id AS bank_currency_id_87,
  o0_.manager_id AS manager_id_88,
  o0_.creator_id AS creator_id_89,
  o0_.default_city_id AS default_city_id_90
FROM
  offer o0_
WHERE
  o0_.id = ?

SELECT o0_.title AS title_0, o0_.me_on_map_name AS me_on_map_name_1, o0_.explanation_text AS explanation_text_2, o0_.price AS price_3, o0_.old_price AS old_price_4, o0_.regular_price AS regular_price_5, o0_.offer_price AS offer_price_6, o0_.discount AS discount_7, o0_.active_since AS active_since_8, o0_.active_till AS active_till_9, o0_.code_active_till AS code_active_till_10, o0_.active AS active_11, o0_.hidden AS hidden_12, o0_.free AS free_13, o0_.without_codes AS without_codes_14, o0_.online_order_allowed AS online_order_allowed_15, o0_.buy_code_disable AS buy_code_disable_16, o0_.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_17, o0_.online_order_allowed_removed_at AS online_order_allowed_removed_at_18, o0_.show_price_in_conditions AS show_price_in_conditions_19, o0_.show_alt_offers AS show_alt_offers_20, o0_.show_currencies AS show_currencies_21, o0_.additional_percents AS additional_percents_22, o0_.address AS address_23, o0_.caption_name AS caption_name_24, o0_.caption_color AS caption_color_25, o0_.regional_caption_name AS regional_caption_name_26, o0_.regional_caption_color AS regional_caption_color_27, o0_.search_position AS search_position_28, o0_.active_search_position AS active_search_position_29, o0_.hint AS hint_30, o0_.bank_currency_id AS bank_currency_id_31, o0_.active_currency_calculator AS active_currency_calculator_32, o0_.last_modified AS last_modified_33, o0_.teaser_logo_width AS teaser_logo_width_34, o0_.teaser_logo_height AS teaser_logo_height_35, o0_.lucene_reindex AS lucene_reindex_36, o0_.code_cost AS code_cost_37, o0_.code_cost_by_count AS code_cost_by_count_38, o0_.default_category_id AS default_category_id_39, o0_.company_name AS company_name_40, o0_.renewed_on AS renewed_on_41, o0_.hide_novelty_label AS hide_novelty_label_42, o0_.hide_banners_in_comments AS hide_banners_in_comments_43, o0_.sum_for_free_delivery AS sum_for_free_delivery_44, o0_.delivery_price AS delivery_price_45, o0_.created_on AS created_on_46, o0_.allowed_buy_only_code AS allowed_buy_only_code_47, o0_.buy_code_button_text AS buy_code_button_text_48, o0_.buy_items_button_text AS buy_items_button_text_49, o0_.purchase_koeff AS purchase_koeff_50, o0_.telegram_bot_show AS telegram_bot_show_51, o0_.telegram_bot_position AS telegram_bot_position_52, o0_.version AS version_53, o0_.hide_in_app AS hide_in_app_54, o0_.brandbox_enabled AS brandbox_enabled_55, o0_.hide_features AS hide_features_56, o0_.discount_delivery_popup AS discount_delivery_popup_57, o0_.discount_pickup_popup AS discount_pickup_popup_58, o0_.delivery_time_teaser AS delivery_time_teaser_59, o0_.external_offer_link AS external_offer_link_60, o0_.is_show_external_offer_link AS is_show_external_offer_link_61, o0_.is_included_in_beauty AS is_included_in_beauty_62, o0_.qr_codes AS qr_codes_63, o0_.recurrent_disabled AS recurrent_disabled_64, o0_.available_on_food AS available_on_food_65, o0_.online_auto_opened AS online_auto_opened_66, o0_.foodcourt_logo_enabled AS foodcourt_logo_enabled_67, o0_.rating AS rating_68, o0_.foodcourt_info_teaser AS foodcourt_info_teaser_69, o0_.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_70, o0_.online_order_gift_enabled AS online_order_gift_enabled_71, o0_.buy_code_in_app_only AS buy_code_in_app_only_72, o0_.show_products_in_offer_description AS show_products_in_offer_description_73, o0_.check_address_in_offer_menu AS check_address_in_offer_menu_74, o0_.show_map_icon_in_app AS show_map_icon_in_app_75, o0_.viber AS viber_76, o0_.telegram AS telegram_77, o0_.messenger_callback AS messenger_callback_78, o0_.allowed_online_order_types AS allowed_online_order_types_79, o0_.title_font_color AS title_font_color_80, o0_.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_81, o0_.map_price AS map_price_82, o0_.map_rating AS map_rating_83, o0_.review AS review_84, o0_.on_review AS on_review_85, o0_.id AS id_86, o0_.bank_currency_id AS bank_currency_id_87, o0_.manager_id AS manager_id_88, o0_.creator_id AS creator_id_89, o0_.default_city_id AS default_city_id_90 FROM offer o0_ WHERE o0_.id = 134458;

SELECT
  t0.description AS description_1,
  t0.city AS city_2,
  t0.street AS street_3,
  t0.house AS house_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  ST_AsEWKT(t0.point : :geometry) AS point_7,
  t0.label AS label_8,
  t0.working_hours AS working_hours_9,
  t0.big_map_marker AS big_map_marker_10,
  t0.schedule AS schedule_11,
  t0.schedule_modified_at AS schedule_modified_at_12,
  t0.id AS id_13,
  t0.sort_order AS sort_order_14,
  t0.pickup_point_partner_id AS pickup_point_partner_id_15,
  t0.pickup_point_bel_trans_sat_depot_id AS pickup_point_bel_trans_sat_depot_id_16,
  t0.pickup_point_schedule AS pickup_point_schedule_17,
  t0.active AS active_18,
  t0.bepaid_credentials AS bepaid_credentials_19,
  t0.city_area_id AS city_area_id_20,
  t0.type
FROM
  geo_location t0
  INNER JOIN geo_location_relation ON t0.id = geo_location_relation.location_id
WHERE
  geo_location_relation.entity_id = ?
  AND t0.type IN ('1')
ORDER BY
  t0.sort_order ASC

SELECT t0.description AS description_1, t0.city AS city_2, t0.street AS street_3, t0.house AS house_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, ST_AsEWKT(t0.point::geometry) AS point_7, t0.label AS label_8, t0.working_hours AS working_hours_9, t0.big_map_marker AS big_map_marker_10, t0.schedule AS schedule_11, t0.schedule_modified_at AS schedule_modified_at_12, t0.id AS id_13, t0.sort_order AS sort_order_14, t0.pickup_point_partner_id AS pickup_point_partner_id_15, t0.pickup_point_bel_trans_sat_depot_id AS pickup_point_bel_trans_sat_depot_id_16, t0.pickup_point_schedule AS pickup_point_schedule_17, t0.active AS active_18, t0.bepaid_credentials AS bepaid_credentials_19, t0.city_area_id AS city_area_id_20, t0.type FROM geo_location t0 INNER JOIN geo_location_relation ON t0.id = geo_location_relation.location_id WHERE geo_location_relation.entity_id = 134458 AND t0.type IN ('1') ORDER BY t0.sort_order ASC;

SELECT
  b0_.first_name AS first_name_0,
  b0_.last_name AS last_name_1,
  b0_.description AS description_2,
  b0_.status AS status_3,
  b0_.id AS id_4
FROM
  beauty_master b0_
  INNER JOIN beauty_master_location b2_ ON b0_.id = b2_.master_id
  INNER JOIN geo_location g1_ ON g1_.id = b2_.location_id
  AND g1_.type IN ('1')
WHERE
  g1_.id IN (?)
GROUP BY
  b0_.id
ORDER BY
  b0_.id ASC

SELECT b0_.first_name AS first_name_0, b0_.last_name AS last_name_1, b0_.description AS description_2, b0_.status AS status_3, b0_.id AS id_4 FROM beauty_master b0_ INNER JOIN beauty_master_location b2_ ON b0_.id = b2_.master_id INNER JOIN geo_location g1_ ON g1_.id = b2_.location_id AND g1_.type IN ('1') WHERE g1_.id IN (7554) GROUP BY b0_.id ORDER BY b0_.id ASC;