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/136419/masters_with_filter' 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/136419/masters_with_filter' ORDER BY t0.id DESC;

SELECT
  count(DISTINCT b0_.id) AS sclr_0
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 (
    SELECT
      g3_.id
    FROM
      geo_location g3_
      INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id
      INNER JOIN offer o4_ ON o4_.id = g5_.entity_id
    WHERE
      (o4_.id = ?)
      AND g3_.type IN ('1')
  )
  AND b0_.position IS NULL
GROUP BY
  b0_.id

SELECT count(DISTINCT b0_.id) AS sclr_0 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 (SELECT g3_.id FROM geo_location g3_ INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id INNER JOIN offer o4_ ON o4_.id = g5_.entity_id WHERE (o4_.id = 136419) AND g3_.type IN ('1')) AND b0_.position IS NULL GROUP BY b0_.id;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.id AS id_1
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 (
    SELECT
      g3_.id
    FROM
      geo_location g3_
      INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id
      INNER JOIN offer o4_ ON o4_.id = g5_.entity_id
    WHERE
      (o4_.id = ?)
      AND g3_.type IN ('1')
  )
  AND b0_.position IS NULL
GROUP BY
  b0_.id
ORDER BY
  b0_.id ASC
LIMIT
  20

SELECT DISTINCT b0_.id AS id_0, b0_.id AS id_1 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 (SELECT g3_.id FROM geo_location g3_ INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id INNER JOIN offer o4_ ON o4_.id = g5_.entity_id WHERE (o4_.id = 136419) AND g3_.type IN ('1')) AND b0_.position IS NULL GROUP BY b0_.id ORDER BY b0_.id ASC LIMIT 20;

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_.position AS position_4,
  b0_.telegram AS telegram_5,
  b0_.viber AS viber_6,
  b0_.salon AS salon_7,
  b0_.online_order_url AS online_order_url_8,
  b0_.level AS level_9,
  b0_.yclient_staff_id AS yclient_staff_id_10,
  b0_.yclient_company_id AS yclient_company_id_11,
  b0_.id AS id_12
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 (
    SELECT
      g3_.id
    FROM
      geo_location g3_
      INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id
      INNER JOIN offer o4_ ON o4_.id = g5_.entity_id
    WHERE
      (o4_.id = ?)
      AND g3_.type IN ('1')
  )
  AND b0_.position IS NULL
  AND b0_.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_.position AS position_4, b0_.telegram AS telegram_5, b0_.viber AS viber_6, b0_.salon AS salon_7, b0_.online_order_url AS online_order_url_8, b0_.level AS level_9, b0_.yclient_staff_id AS yclient_staff_id_10, b0_.yclient_company_id AS yclient_company_id_11, b0_.id AS id_12 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 (SELECT g3_.id FROM geo_location g3_ INNER JOIN geo_location_relation g5_ ON g3_.id = g5_.location_id INNER JOIN offer o4_ ON o4_.id = g5_.entity_id WHERE (o4_.id = 136419) AND g3_.type IN ('1')) AND b0_.position IS NULL AND b0_.id IN (51) GROUP BY b0_.id ORDER BY b0_.id ASC;

SELECT
  t0.name AS name_1,
  t0.h1 AS h1_2,
  t0.active AS active_3,
  t0.sort_order AS sort_order_4,
  t0.api_sort_order AS api_sort_order_5,
  t0.map_pin_color AS map_pin_color_6,
  t0.id AS id_7,
  t0.type_id AS type_id_8,
  t0.domain_object_id AS domain_object_id_9,
  t0.past AS past_10,
  t0.code AS code_11,
  t0.top_count AS top_count_12,
  t0.description AS description_13,
  t0.mobile_api_hash AS mobile_api_hash_14,
  t0.entity_count AS entity_count_15,
  t0.last_modified AS last_modified_16,
  t0.in_menu_bottom AS in_menu_bottom_17,
  t0.hot_feed_name AS hot_feed_name_18,
  t0.unpopular AS unpopular_19,
  t0.featured_in_menu AS featured_in_menu_20,
  t0.position AS position_21,
  t0.telegram_bot_show AS telegram_bot_show_22,
  t0.telegram_bot_name AS telegram_bot_name_23,
  t0.telegram_bot_position AS telegram_bot_position_24,
  t0.split_offers_with_same_categories AS split_offers_with_same_categories_25,
  t0.utm_campaign AS utm_campaign_26,
  t0.me_on_map_active AS me_on_map_active_27,
  t0.me_on_map_position AS me_on_map_position_28,
  t0.me_on_map_featured_active AS me_on_map_featured_active_29,
  t0.me_on_map_featured_position AS me_on_map_featured_position_30,
  t0.show_items_catalog AS show_items_catalog_31,
  t0.active_in_best_offers_category AS active_in_best_offers_category_32,
  t0.hide_work_examples AS hide_work_examples_33,
  t0.is_bonus_code AS is_bonus_code_34,
  t0.city_id AS city_id_35,
  t0.type_id AS type_id_36,
  t0.type
FROM
  category t0
  INNER JOIN beauty_master_category ON t0.id = beauty_master_category.category_id
WHERE
  beauty_master_category.master_id = ?
  AND t0.type IN ('0')

SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.type_id AS type_id_8, t0.domain_object_id AS domain_object_id_9, t0.past AS past_10, t0.code AS code_11, t0.top_count AS top_count_12, t0.description AS description_13, t0.mobile_api_hash AS mobile_api_hash_14, t0.entity_count AS entity_count_15, t0.last_modified AS last_modified_16, t0.in_menu_bottom AS in_menu_bottom_17, t0.hot_feed_name AS hot_feed_name_18, t0.unpopular AS unpopular_19, t0.featured_in_menu AS featured_in_menu_20, t0.position AS position_21, t0.telegram_bot_show AS telegram_bot_show_22, t0.telegram_bot_name AS telegram_bot_name_23, t0.telegram_bot_position AS telegram_bot_position_24, t0.split_offers_with_same_categories AS split_offers_with_same_categories_25, t0.utm_campaign AS utm_campaign_26, t0.me_on_map_active AS me_on_map_active_27, t0.me_on_map_position AS me_on_map_position_28, t0.me_on_map_featured_active AS me_on_map_featured_active_29, t0.me_on_map_featured_position AS me_on_map_featured_position_30, t0.show_items_catalog AS show_items_catalog_31, t0.active_in_best_offers_category AS active_in_best_offers_category_32, t0.hide_work_examples AS hide_work_examples_33, t0.is_bonus_code AS is_bonus_code_34, t0.city_id AS city_id_35, t0.type_id AS type_id_36, t0.type FROM category t0 INNER JOIN beauty_master_category ON t0.id = beauty_master_category.category_id WHERE beauty_master_category.master_id = 51 AND t0.type IN ('0');

SELECT
  t0.name AS name_1,
  t0.h1 AS h1_2,
  t0.active AS active_3,
  t0.sort_order AS sort_order_4,
  t0.api_sort_order AS api_sort_order_5,
  t0.map_pin_color AS map_pin_color_6,
  t0.id AS id_7,
  t0.city_id AS city_id_8,
  t0.type,
  t0.type_id AS type_id_9,
  t0.domain_object_id AS domain_object_id_10,
  t0.past AS past_11,
  t0.code AS code_12,
  t0.top_count AS top_count_13,
  t0.description AS description_14,
  t0.mobile_api_hash AS mobile_api_hash_15,
  t0.entity_count AS entity_count_16,
  t0.last_modified AS last_modified_17,
  t0.in_menu_bottom AS in_menu_bottom_18,
  t0.hot_feed_name AS hot_feed_name_19,
  t0.unpopular AS unpopular_20,
  t0.featured_in_menu AS featured_in_menu_21,
  t0.position AS position_22,
  t0.telegram_bot_show AS telegram_bot_show_23,
  t0.telegram_bot_name AS telegram_bot_name_24,
  t0.telegram_bot_position AS telegram_bot_position_25,
  t0.split_offers_with_same_categories AS split_offers_with_same_categories_26,
  t0.utm_campaign AS utm_campaign_27,
  t0.me_on_map_active AS me_on_map_active_28,
  t0.me_on_map_position AS me_on_map_position_29,
  t0.me_on_map_featured_active AS me_on_map_featured_active_30,
  t0.me_on_map_featured_position AS me_on_map_featured_position_31,
  t0.show_items_catalog AS show_items_catalog_32,
  t0.active_in_best_offers_category AS active_in_best_offers_category_33,
  t0.hide_work_examples AS hide_work_examples_34,
  t0.is_bonus_code AS is_bonus_code_35,
  t0.type_id AS type_id_36
FROM
  category t0
  INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id
WHERE
  category_child_relation.parent_id = ?
  AND t0.type IN ('0', '1', '3', '4', '5', '6')
ORDER BY
  t0.sort_order ASC

SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type, t0.type_id AS type_id_9, t0.domain_object_id AS domain_object_id_10, t0.past AS past_11, t0.code AS code_12, t0.top_count AS top_count_13, t0.description AS description_14, t0.mobile_api_hash AS mobile_api_hash_15, t0.entity_count AS entity_count_16, t0.last_modified AS last_modified_17, t0.in_menu_bottom AS in_menu_bottom_18, t0.hot_feed_name AS hot_feed_name_19, t0.unpopular AS unpopular_20, t0.featured_in_menu AS featured_in_menu_21, t0.position AS position_22, t0.telegram_bot_show AS telegram_bot_show_23, t0.telegram_bot_name AS telegram_bot_name_24, t0.telegram_bot_position AS telegram_bot_position_25, t0.split_offers_with_same_categories AS split_offers_with_same_categories_26, t0.utm_campaign AS utm_campaign_27, t0.me_on_map_active AS me_on_map_active_28, t0.me_on_map_position AS me_on_map_position_29, t0.me_on_map_featured_active AS me_on_map_featured_active_30, t0.me_on_map_featured_position AS me_on_map_featured_position_31, t0.show_items_catalog AS show_items_catalog_32, t0.active_in_best_offers_category AS active_in_best_offers_category_33, t0.hide_work_examples AS hide_work_examples_34, t0.is_bonus_code AS is_bonus_code_35, t0.type_id AS type_id_36 FROM category t0 INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id WHERE category_child_relation.parent_id = 8 AND t0.type IN ('0', '1', '3', '4', '5', '6') ORDER BY t0.sort_order ASC;

SELECT
  t0.name AS name_1,
  t0.h1 AS h1_2,
  t0.active AS active_3,
  t0.sort_order AS sort_order_4,
  t0.api_sort_order AS api_sort_order_5,
  t0.map_pin_color AS map_pin_color_6,
  t0.id AS id_7,
  t0.city_id AS city_id_8,
  t0.type,
  t0.type_id AS type_id_9,
  t0.domain_object_id AS domain_object_id_10,
  t0.past AS past_11,
  t0.code AS code_12,
  t0.top_count AS top_count_13,
  t0.description AS description_14,
  t0.mobile_api_hash AS mobile_api_hash_15,
  t0.entity_count AS entity_count_16,
  t0.last_modified AS last_modified_17,
  t0.in_menu_bottom AS in_menu_bottom_18,
  t0.hot_feed_name AS hot_feed_name_19,
  t0.unpopular AS unpopular_20,
  t0.featured_in_menu AS featured_in_menu_21,
  t0.position AS position_22,
  t0.telegram_bot_show AS telegram_bot_show_23,
  t0.telegram_bot_name AS telegram_bot_name_24,
  t0.telegram_bot_position AS telegram_bot_position_25,
  t0.split_offers_with_same_categories AS split_offers_with_same_categories_26,
  t0.utm_campaign AS utm_campaign_27,
  t0.me_on_map_active AS me_on_map_active_28,
  t0.me_on_map_position AS me_on_map_position_29,
  t0.me_on_map_featured_active AS me_on_map_featured_active_30,
  t0.me_on_map_featured_position AS me_on_map_featured_position_31,
  t0.show_items_catalog AS show_items_catalog_32,
  t0.active_in_best_offers_category AS active_in_best_offers_category_33,
  t0.hide_work_examples AS hide_work_examples_34,
  t0.is_bonus_code AS is_bonus_code_35,
  t0.type_id AS type_id_36
FROM
  category t0
  INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id
WHERE
  category_child_relation.parent_id = ?
  AND t0.type IN ('0', '1', '3', '4', '5', '6')
ORDER BY
  t0.sort_order ASC

SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type, t0.type_id AS type_id_9, t0.domain_object_id AS domain_object_id_10, t0.past AS past_11, t0.code AS code_12, t0.top_count AS top_count_13, t0.description AS description_14, t0.mobile_api_hash AS mobile_api_hash_15, t0.entity_count AS entity_count_16, t0.last_modified AS last_modified_17, t0.in_menu_bottom AS in_menu_bottom_18, t0.hot_feed_name AS hot_feed_name_19, t0.unpopular AS unpopular_20, t0.featured_in_menu AS featured_in_menu_21, t0.position AS position_22, t0.telegram_bot_show AS telegram_bot_show_23, t0.telegram_bot_name AS telegram_bot_name_24, t0.telegram_bot_position AS telegram_bot_position_25, t0.split_offers_with_same_categories AS split_offers_with_same_categories_26, t0.utm_campaign AS utm_campaign_27, t0.me_on_map_active AS me_on_map_active_28, t0.me_on_map_position AS me_on_map_position_29, t0.me_on_map_featured_active AS me_on_map_featured_active_30, t0.me_on_map_featured_position AS me_on_map_featured_position_31, t0.show_items_catalog AS show_items_catalog_32, t0.active_in_best_offers_category AS active_in_best_offers_category_33, t0.hide_work_examples AS hide_work_examples_34, t0.is_bonus_code AS is_bonus_code_35, t0.type_id AS type_id_36 FROM category t0 INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id WHERE category_child_relation.parent_id = 160 AND t0.type IN ('0', '1', '3', '4', '5', '6') ORDER BY t0.sort_order ASC;

SELECT
  t0.name AS name_1,
  t0.h1 AS h1_2,
  t0.active AS active_3,
  t0.sort_order AS sort_order_4,
  t0.api_sort_order AS api_sort_order_5,
  t0.map_pin_color AS map_pin_color_6,
  t0.id AS id_7,
  t0.city_id AS city_id_8,
  t0.type,
  t0.type_id AS type_id_9,
  t0.domain_object_id AS domain_object_id_10,
  t0.past AS past_11,
  t0.code AS code_12,
  t0.top_count AS top_count_13,
  t0.description AS description_14,
  t0.mobile_api_hash AS mobile_api_hash_15,
  t0.entity_count AS entity_count_16,
  t0.last_modified AS last_modified_17,
  t0.in_menu_bottom AS in_menu_bottom_18,
  t0.hot_feed_name AS hot_feed_name_19,
  t0.unpopular AS unpopular_20,
  t0.featured_in_menu AS featured_in_menu_21,
  t0.position AS position_22,
  t0.telegram_bot_show AS telegram_bot_show_23,
  t0.telegram_bot_name AS telegram_bot_name_24,
  t0.telegram_bot_position AS telegram_bot_position_25,
  t0.split_offers_with_same_categories AS split_offers_with_same_categories_26,
  t0.utm_campaign AS utm_campaign_27,
  t0.me_on_map_active AS me_on_map_active_28,
  t0.me_on_map_position AS me_on_map_position_29,
  t0.me_on_map_featured_active AS me_on_map_featured_active_30,
  t0.me_on_map_featured_position AS me_on_map_featured_position_31,
  t0.show_items_catalog AS show_items_catalog_32,
  t0.active_in_best_offers_category AS active_in_best_offers_category_33,
  t0.hide_work_examples AS hide_work_examples_34,
  t0.is_bonus_code AS is_bonus_code_35,
  t0.type_id AS type_id_36
FROM
  category t0
  INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id
WHERE
  category_child_relation.parent_id = ?
  AND t0.type IN ('0', '1', '3', '4', '5', '6')
ORDER BY
  t0.sort_order ASC

SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type, t0.type_id AS type_id_9, t0.domain_object_id AS domain_object_id_10, t0.past AS past_11, t0.code AS code_12, t0.top_count AS top_count_13, t0.description AS description_14, t0.mobile_api_hash AS mobile_api_hash_15, t0.entity_count AS entity_count_16, t0.last_modified AS last_modified_17, t0.in_menu_bottom AS in_menu_bottom_18, t0.hot_feed_name AS hot_feed_name_19, t0.unpopular AS unpopular_20, t0.featured_in_menu AS featured_in_menu_21, t0.position AS position_22, t0.telegram_bot_show AS telegram_bot_show_23, t0.telegram_bot_name AS telegram_bot_name_24, t0.telegram_bot_position AS telegram_bot_position_25, t0.split_offers_with_same_categories AS split_offers_with_same_categories_26, t0.utm_campaign AS utm_campaign_27, t0.me_on_map_active AS me_on_map_active_28, t0.me_on_map_position AS me_on_map_position_29, t0.me_on_map_featured_active AS me_on_map_featured_active_30, t0.me_on_map_featured_position AS me_on_map_featured_position_31, t0.show_items_catalog AS show_items_catalog_32, t0.active_in_best_offers_category AS active_in_best_offers_category_33, t0.hide_work_examples AS hide_work_examples_34, t0.is_bonus_code AS is_bonus_code_35, t0.type_id AS type_id_36 FROM category t0 INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id WHERE category_child_relation.parent_id = 18367 AND t0.type IN ('0', '1', '3', '4', '5', '6') ORDER BY t0.sort_order ASC;

SELECT
  t0.domain_object_id AS domain_object_id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.legal_email AS legal_email_4,
  t0.legal_entity AS legal_entity_5,
  t0.tax_id AS tax_id_6,
  t0.receive_letters AS receive_letters_7,
  t0.transition_id AS transition_id_8,
  t0.teaser_logo_width AS teaser_logo_width_9,
  t0.teaser_logo_height AS teaser_logo_height_10,
  t0.status AS status_11,
  t0.punished AS punished_12,
  t0.last_code_number AS last_code_number_13,
  t0.about AS about_14,
  t0.created_on AS created_on_15,
  t0.modified_on AS modified_on_16,
  t0.extra_emails AS extra_emails_17,
  t0.phone_number AS phone_number_18,
  t0.site AS site_19,
  t0.legal_address AS legal_address_20,
  t0.account_number AS account_number_21,
  t0.tax_registration_date AS tax_registration_date_22,
  t0.trade_registration_date AS trade_registration_date_23,
  t0.registration_authority AS registration_authority_24,
  t0.working_hours AS working_hours_25,
  t0.footer_info AS footer_info_26,
  t0.company_link AS company_link_27,
  t0.id AS id_28,
  t0.page_offer_id AS page_offer_id_29,
  t0.manager_id AS manager_id_30
FROM
  director t0
  INNER JOIN beauty_master_director ON t0.id = beauty_master_director.director_id
WHERE
  beauty_master_director.master_id = ?

SELECT t0.domain_object_id AS domain_object_id_1, t0.name AS name_2, t0.email AS email_3, t0.legal_email AS legal_email_4, t0.legal_entity AS legal_entity_5, t0.tax_id AS tax_id_6, t0.receive_letters AS receive_letters_7, t0.transition_id AS transition_id_8, t0.teaser_logo_width AS teaser_logo_width_9, t0.teaser_logo_height AS teaser_logo_height_10, t0.status AS status_11, t0.punished AS punished_12, t0.last_code_number AS last_code_number_13, t0.about AS about_14, t0.created_on AS created_on_15, t0.modified_on AS modified_on_16, t0.extra_emails AS extra_emails_17, t0.phone_number AS phone_number_18, t0.site AS site_19, t0.legal_address AS legal_address_20, t0.account_number AS account_number_21, t0.tax_registration_date AS tax_registration_date_22, t0.trade_registration_date AS trade_registration_date_23, t0.registration_authority AS registration_authority_24, t0.working_hours AS working_hours_25, t0.footer_info AS footer_info_26, t0.company_link AS company_link_27, t0.id AS id_28, t0.page_offer_id AS page_offer_id_29, t0.manager_id AS manager_id_30 FROM director t0 INNER JOIN beauty_master_director ON t0.id = beauty_master_director.director_id WHERE beauty_master_director.master_id = 51;

SELECT
  category.id as category_id,
  category.name as category_name,
  seo.main_alias as category_url,
  purchases.director_id as director_id,
  coalesce(
    director_comment.comment_count,
    0
  ) as comment_count,
  coalesce(
    director_comment.comment_rating,
    0
  ) as comment_rating,
  sum(purchases.codes_count) as codes_count
FROM
  category category
  INNER JOIN seo seo ON (category.id = seo.entity_id)
  AND (
    seo.resource_url = :seoResourceUrl
  )
  AND (seo.active = :active)
  INNER JOIN (
    SELECT
      purchase_count.entity_id as offer_id,
      purchase_count.purchase_count_last_month_with_correction as codes_count,
      (
        SELECT
          category2entity.category_id
        FROM
          category2entity
          INNER JOIN category category ON (
            category2entity.category_id = category.id
          )
          AND (
            category.type_id = :supplierCategoryType
          )
        WHERE
          category2entity.entity_id = purchase_count.entity_id
        ORDER BY
          category2entity.category_id ASC
        LIMIT
          1
      ) as director_category_id,
      (
        SELECT
          offer2director.director_id
        FROM
          offer2director
        WHERE
          offer2director.offer_id = purchase_count.entity_id
        ORDER BY
          offer2director.director_id ASC
        LIMIT
          1
      ) as director_id
    FROM
      purchase_count
    WHERE
      (
        purchase_count.entity_id IN (
          SELECT
            DISTINCT offer_order.offer_id
          FROM
            offer_code
            INNER JOIN offer_order offer_order ON offer_order.id = offer_code.offer_order_id
          WHERE
            (
              offer_code.created_on > :purchaseRatingPeriodInDays
            )
            AND (
              offer_order.offer_id IN (
                SELECT
                  category2entity.entity_id
                FROM
                  category2entity
                WHERE
                  category2entity.category_id = :categoryId
              )
            )
        )
      )
      AND (
        purchase_count.purchase_count_last_month_with_correction > 0
      )
  ) purchases ON purchases.director_category_id = category.id
  INNER JOIN director director ON purchases.director_id = director.id
  LEFT JOIN (
    SELECT
      coalesce(
        (
          SELECT
            offer2director.director_id
          FROM
            offer2director
          WHERE
            offer2director.offer_id = comment.entity_id
          ORDER BY
            offer2director.director_id ASC
          LIMIT
            1
        ), (
          SELECT
            sale2director.director_id
          FROM
            sale2director
          WHERE
            sale2director.sale_id = comment.entity_id
          ORDER BY
            sale2director.director_id ASC
          LIMIT
            1
        )
      ) as director_id,
      count(*) as comment_count,
      avg(rating) as comment_rating
    FROM
      comment
    WHERE
      (
        (
          comment.entity_id IN (
            SELECT
              offer.id
            FROM
              offer
            WHERE
              (
                now() between active_since
                and active_till
              )
              AND (
                offer.id IN (
                  SELECT
                    category2entity.entity_id
                  FROM
                    category2entity
                  WHERE
                    category2entity.category_id = :categoryId
                )
              )
              AND (offer.active = :active)
          )
        )
        OR (
          comment.entity_id IN (
            SELECT
              sale.id
            FROM
              sale
            WHERE
              (
                now() between since
                and till
              )
              AND (sale.active = :active)
          )
        )
      )
      AND (comment.hidden = :commentHidden)
      AND (
        (
          comment.type_id = :typeOfferComment
        )
        OR (
          comment.type_id = :typeSaleComment
        )
      )
      AND (comment.rating > :commentRating)
      AND (
        comment.confirmed_phone = :commentConfirmedPhone
      )
      AND (
        comment.created_on > :commentRatingPeriodInDays
      )
    GROUP BY
      1
  ) director_comment ON director.id = director_comment.director_id
WHERE
  (
    category.id IN (
      SELECT
        DISTINCT category.id
      FROM
        category2entity
        INNER JOIN category category ON category2entity.category_id = category.id
      WHERE
        category2entity.entity_id IN (
          SELECT
            offer.id
          FROM
            offer
          WHERE
            (
              offer.id IN (
                SELECT
                  entity_id
                FROM
                  category2entity
                WHERE
                  category2entity.category_id = :categoryId
              )
            )
            AND (offer.active = :offerActive)
            AND (
              now() between offer.active_since
              and offer.active_till
            )
        )
    )
  )
  AND (
    category.type_id = :supplierCategoryType
  )
  AND (category.active = :active)
  AND (category.past = :past)
  AND (director.punished = :punished)
GROUP BY
  category.id,
  category.name,
  seo.main_alias,
  purchases.director_id,
  director_comment.comment_count,
  director_comment.comment_rating
ORDER BY
  sum(purchases.codes_count) desc

SELECT category.id as category_id, category.name as category_name, seo.main_alias as category_url, purchases.director_id as director_id, coalesce(director_comment.comment_count, 0) as comment_count, coalesce(director_comment.comment_rating, 0) as comment_rating, sum(purchases.codes_count) as codes_count FROM category category INNER JOIN seo seo ON (category.id = seo.entity_id) AND (seo.resource_url = 'Slivki:Default:category') AND (seo.active = 'true') INNER JOIN (SELECT purchase_count.entity_id as offer_id, purchase_count.purchase_count_last_month_with_correction as codes_count, (SELECT category2entity.category_id FROM category2entity INNER JOIN category category ON (category2entity.category_id = category.id) AND (category.type_id = 3) WHERE category2entity.entity_id = purchase_count.entity_id ORDER BY category2entity.category_id ASC LIMIT 1) as director_category_id, (SELECT offer2director.director_id FROM offer2director WHERE offer2director.offer_id = purchase_count.entity_id ORDER BY offer2director.director_id ASC LIMIT 1) as director_id FROM purchase_count WHERE (purchase_count.entity_id IN (SELECT DISTINCT offer_order.offer_id FROM offer_code INNER JOIN offer_order offer_order ON offer_order.id = offer_code.offer_order_id WHERE (offer_code.created_on > '2025-04-10') AND (offer_order.offer_id IN (SELECT category2entity.entity_id FROM category2entity WHERE category2entity.category_id = 18367)))) AND (purchase_count.purchase_count_last_month_with_correction > 0)) purchases ON purchases.director_category_id = category.id INNER JOIN director director ON purchases.director_id = director.id LEFT JOIN (SELECT coalesce((SELECT offer2director.director_id FROM offer2director WHERE offer2director.offer_id = comment.entity_id ORDER BY offer2director.director_id ASC LIMIT 1), (SELECT sale2director.director_id FROM sale2director WHERE sale2director.sale_id = comment.entity_id ORDER BY sale2director.director_id ASC LIMIT 1)) as director_id, count(*) as comment_count, avg(rating) as comment_rating FROM comment WHERE ((comment.entity_id IN (SELECT offer.id FROM offer WHERE (now() between active_since and active_till) AND (offer.id IN (SELECT category2entity.entity_id FROM category2entity WHERE category2entity.category_id = 18367)) AND (offer.active = 'true'))) OR (comment.entity_id IN (SELECT sale.id FROM sale WHERE (now() between since and till) AND (sale.active = 'true')))) AND (comment.hidden = 'false') AND ((comment.type_id = 1) OR (comment.type_id = 2)) AND (comment.rating > 0) AND (comment.confirmed_phone = 'true') AND (comment.created_on > '2025-02-09') GROUP BY 1) director_comment ON director.id = director_comment.director_id WHERE (category.id IN (SELECT DISTINCT category.id FROM category2entity INNER JOIN category category ON category2entity.category_id = category.id WHERE category2entity.entity_id IN (SELECT offer.id FROM offer WHERE (offer.id IN (SELECT entity_id FROM category2entity WHERE category2entity.category_id = 18367)) AND (offer.active = 'true') AND (now() between offer.active_since and offer.active_till)))) AND (category.type_id = 3) AND (category.active = 'true') AND (category.past = 'false') AND (director.punished = 'false') GROUP BY category.id, category.name, seo.main_alias, purchases.director_id, director_comment.comment_count, director_comment.comment_rating ORDER BY sum(purchases.codes_count) desc;

SELECT
  t0.name AS name_1,
  t0.h1 AS h1_2,
  t0.active AS active_3,
  t0.sort_order AS sort_order_4,
  t0.api_sort_order AS api_sort_order_5,
  t0.map_pin_color AS map_pin_color_6,
  t0.id AS id_7,
  t0.city_id AS city_id_8,
  t0.type,
  t0.type_id AS type_id_9,
  t0.domain_object_id AS domain_object_id_10,
  t0.past AS past_11,
  t0.code AS code_12,
  t0.top_count AS top_count_13,
  t0.description AS description_14,
  t0.mobile_api_hash AS mobile_api_hash_15,
  t0.entity_count AS entity_count_16,
  t0.last_modified AS last_modified_17,
  t0.in_menu_bottom AS in_menu_bottom_18,
  t0.hot_feed_name AS hot_feed_name_19,
  t0.unpopular AS unpopular_20,
  t0.featured_in_menu AS featured_in_menu_21,
  t0.position AS position_22,
  t0.telegram_bot_show AS telegram_bot_show_23,
  t0.telegram_bot_name AS telegram_bot_name_24,
  t0.telegram_bot_position AS telegram_bot_position_25,
  t0.split_offers_with_same_categories AS split_offers_with_same_categories_26,
  t0.utm_campaign AS utm_campaign_27,
  t0.me_on_map_active AS me_on_map_active_28,
  t0.me_on_map_position AS me_on_map_position_29,
  t0.me_on_map_featured_active AS me_on_map_featured_active_30,
  t0.me_on_map_featured_position AS me_on_map_featured_position_31,
  t0.show_items_catalog AS show_items_catalog_32,
  t0.active_in_best_offers_category AS active_in_best_offers_category_33,
  t0.hide_work_examples AS hide_work_examples_34,
  t0.is_bonus_code AS is_bonus_code_35,
  t0.type_id AS type_id_36
FROM
  category t0
  INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id
WHERE
  category_child_relation.parent_id = ?
  AND t0.type IN ('0', '1', '3', '4', '5', '6')
ORDER BY
  t0.sort_order ASC