Symfony Profiler

SELECT
  t0.title AS title_1,
  t0.me_on_map_name AS me_on_map_name_2,
  t0.explanation_text AS explanation_text_3,
  t0.price AS price_4,
  t0.old_price AS old_price_5,
  t0.regular_price AS regular_price_6,
  t0.offer_price AS offer_price_7,
  t0.discount AS discount_8,
  t0.active_since AS active_since_9,
  t0.active_till AS active_till_10,
  t0.code_active_till AS code_active_till_11,
  t0.active AS active_12,
  t0.hidden AS hidden_13,
  t0.free AS free_14,
  t0.without_codes AS without_codes_15,
  t0.online_order_allowed AS online_order_allowed_16,
  t0.buy_code_disable AS buy_code_disable_17,
  t0.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_18,
  t0.online_order_allowed_removed_at AS online_order_allowed_removed_at_19,
  t0.show_price_in_conditions AS show_price_in_conditions_20,
  t0.show_alt_offers AS show_alt_offers_21,
  t0.show_currencies AS show_currencies_22,
  t0.additional_percents AS additional_percents_23,
  t0.address AS address_24,
  t0.caption_name AS caption_name_25,
  t0.caption_color AS caption_color_26,
  t0.regional_caption_name AS regional_caption_name_27,
  t0.regional_caption_color AS regional_caption_color_28,
  t0.search_position AS search_position_29,
  t0.active_search_position AS active_search_position_30,
  t0.hint AS hint_31,
  t0.bank_currency_id AS bank_currency_id_32,
  t0.active_currency_calculator AS active_currency_calculator_33,
  t0.last_modified AS last_modified_34,
  t0.teaser_logo_width AS teaser_logo_width_35,
  t0.teaser_logo_height AS teaser_logo_height_36,
  t0.lucene_reindex AS lucene_reindex_37,
  t0.code_cost AS code_cost_38,
  t0.code_cost_by_count AS code_cost_by_count_39,
  t0.default_category_id AS default_category_id_40,
  t0.company_name AS company_name_41,
  t0.renewed_on AS renewed_on_42,
  t0.hide_novelty_label AS hide_novelty_label_43,
  t0.hide_banners_in_comments AS hide_banners_in_comments_44,
  t0.sum_for_free_delivery AS sum_for_free_delivery_45,
  t0.delivery_price AS delivery_price_46,
  t0.created_on AS created_on_47,
  t0.allowed_buy_only_code AS allowed_buy_only_code_48,
  t0.buy_code_button_text AS buy_code_button_text_49,
  t0.buy_items_button_text AS buy_items_button_text_50,
  t0.purchase_koeff AS purchase_koeff_51,
  t0.telegram_bot_show AS telegram_bot_show_52,
  t0.telegram_bot_position AS telegram_bot_position_53,
  t0.version AS version_54,
  t0.hide_in_app AS hide_in_app_55,
  t0.brandbox_enabled AS brandbox_enabled_56,
  t0.hide_features AS hide_features_57,
  t0.discount_delivery_popup AS discount_delivery_popup_58,
  t0.discount_pickup_popup AS discount_pickup_popup_59,
  t0.delivery_time_teaser AS delivery_time_teaser_60,
  t0.external_offer_link AS external_offer_link_61,
  t0.is_show_external_offer_link AS is_show_external_offer_link_62,
  t0.is_included_in_beauty AS is_included_in_beauty_63,
  t0.qr_codes AS qr_codes_64,
  t0.recurrent_disabled AS recurrent_disabled_65,
  t0.available_on_food AS available_on_food_66,
  t0.online_auto_opened AS online_auto_opened_67,
  t0.foodcourt_logo_enabled AS foodcourt_logo_enabled_68,
  t0.rating AS rating_69,
  t0.foodcourt_info_teaser AS foodcourt_info_teaser_70,
  t0.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_71,
  t0.online_order_gift_enabled AS online_order_gift_enabled_72,
  t0.buy_code_in_app_only AS buy_code_in_app_only_73,
  t0.show_products_in_offer_description AS show_products_in_offer_description_74,
  t0.check_address_in_offer_menu AS check_address_in_offer_menu_75,
  t0.show_map_icon_in_app AS show_map_icon_in_app_76,
  t0.viber AS viber_77,
  t0.telegram AS telegram_78,
  t0.messenger_callback AS messenger_callback_79,
  t0.allowed_online_order_types AS allowed_online_order_types_80,
  t0.title_font_color AS title_font_color_81,
  t0.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_82,
  t0.map_price AS map_price_83,
  t0.map_rating AS map_rating_84,
  t0.review AS review_85,
  t0.on_review AS on_review_86,
  t0.id AS id_87,
  t0.bank_currency_id AS bank_currency_id_88,
  t0.manager_id AS manager_id_89,
  t0.creator_id AS creator_id_90,
  t0.default_city_id AS default_city_id_91
FROM
  offer t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.me_on_map_name AS me_on_map_name_2, t0.explanation_text AS explanation_text_3, t0.price AS price_4, t0.old_price AS old_price_5, t0.regular_price AS regular_price_6, t0.offer_price AS offer_price_7, t0.discount AS discount_8, t0.active_since AS active_since_9, t0.active_till AS active_till_10, t0.code_active_till AS code_active_till_11, t0.active AS active_12, t0.hidden AS hidden_13, t0.free AS free_14, t0.without_codes AS without_codes_15, t0.online_order_allowed AS online_order_allowed_16, t0.buy_code_disable AS buy_code_disable_17, t0.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_18, t0.online_order_allowed_removed_at AS online_order_allowed_removed_at_19, t0.show_price_in_conditions AS show_price_in_conditions_20, t0.show_alt_offers AS show_alt_offers_21, t0.show_currencies AS show_currencies_22, t0.additional_percents AS additional_percents_23, t0.address AS address_24, t0.caption_name AS caption_name_25, t0.caption_color AS caption_color_26, t0.regional_caption_name AS regional_caption_name_27, t0.regional_caption_color AS regional_caption_color_28, t0.search_position AS search_position_29, t0.active_search_position AS active_search_position_30, t0.hint AS hint_31, t0.bank_currency_id AS bank_currency_id_32, t0.active_currency_calculator AS active_currency_calculator_33, t0.last_modified AS last_modified_34, t0.teaser_logo_width AS teaser_logo_width_35, t0.teaser_logo_height AS teaser_logo_height_36, t0.lucene_reindex AS lucene_reindex_37, t0.code_cost AS code_cost_38, t0.code_cost_by_count AS code_cost_by_count_39, t0.default_category_id AS default_category_id_40, t0.company_name AS company_name_41, t0.renewed_on AS renewed_on_42, t0.hide_novelty_label AS hide_novelty_label_43, t0.hide_banners_in_comments AS hide_banners_in_comments_44, t0.sum_for_free_delivery AS sum_for_free_delivery_45, t0.delivery_price AS delivery_price_46, t0.created_on AS created_on_47, t0.allowed_buy_only_code AS allowed_buy_only_code_48, t0.buy_code_button_text AS buy_code_button_text_49, t0.buy_items_button_text AS buy_items_button_text_50, t0.purchase_koeff AS purchase_koeff_51, t0.telegram_bot_show AS telegram_bot_show_52, t0.telegram_bot_position AS telegram_bot_position_53, t0.version AS version_54, t0.hide_in_app AS hide_in_app_55, t0.brandbox_enabled AS brandbox_enabled_56, t0.hide_features AS hide_features_57, t0.discount_delivery_popup AS discount_delivery_popup_58, t0.discount_pickup_popup AS discount_pickup_popup_59, t0.delivery_time_teaser AS delivery_time_teaser_60, t0.external_offer_link AS external_offer_link_61, t0.is_show_external_offer_link AS is_show_external_offer_link_62, t0.is_included_in_beauty AS is_included_in_beauty_63, t0.qr_codes AS qr_codes_64, t0.recurrent_disabled AS recurrent_disabled_65, t0.available_on_food AS available_on_food_66, t0.online_auto_opened AS online_auto_opened_67, t0.foodcourt_logo_enabled AS foodcourt_logo_enabled_68, t0.rating AS rating_69, t0.foodcourt_info_teaser AS foodcourt_info_teaser_70, t0.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_71, t0.online_order_gift_enabled AS online_order_gift_enabled_72, t0.buy_code_in_app_only AS buy_code_in_app_only_73, t0.show_products_in_offer_description AS show_products_in_offer_description_74, t0.check_address_in_offer_menu AS check_address_in_offer_menu_75, t0.show_map_icon_in_app AS show_map_icon_in_app_76, t0.viber AS viber_77, t0.telegram AS telegram_78, t0.messenger_callback AS messenger_callback_79, t0.allowed_online_order_types AS allowed_online_order_types_80, t0.title_font_color AS title_font_color_81, t0.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_82, t0.map_price AS map_price_83, t0.map_rating AS map_rating_84, t0.review AS review_85, t0.on_review AS on_review_86, t0.id AS id_87, t0.bank_currency_id AS bank_currency_id_88, t0.manager_id AS manager_id_89, t0.creator_id AS creator_id_90, t0.default_city_id AS default_city_id_91 FROM offer t0 WHERE t0.id = 134034;

SELECT
  t0.name AS name_1,
  t0.path AS path_2,
  t0.description AS description_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.size AS size_6,
  t0.sort_order AS sort_order_7,
  t0.checked AS checked_8,
  t0.youtube AS youtube_9,
  t0.id AS id_10,
  t0.type_id AS type_id_11,
  t0.entity_id AS entity_id_12,
  t0.type_id AS type_id_13,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order ASC

SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.id AS id_10, t0.type_id AS type_id_11, t0.entity_id AS entity_id_12, t0.type_id AS type_id_13, t0.type FROM media t0 WHERE t0.entity_id = 134034 AND t0.type_id = 18072 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;

SELECT
  t0.name AS name_1,
  t0.path AS path_2,
  t0.description AS description_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.size AS size_6,
  t0.sort_order AS sort_order_7,
  t0.checked AS checked_8,
  t0.youtube AS youtube_9,
  t0.id AS id_10,
  t0.type_id AS type_id_11,
  t0.entity_id AS entity_id_12,
  t0.type_id AS type_id_13,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order ASC

SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.id AS id_10, t0.type_id AS type_id_11, t0.entity_id AS entity_id_12, t0.type_id AS type_id_13, t0.type FROM media t0 WHERE t0.entity_id = 134034 AND t0.type_id = 18073 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;

SELECT
  codes_by_period.offer_id,
  sum (
    case when codes_by_period.subscription_period_start_at is null then codes_by_period.codes_count when codes_by_period.previous_period_codes_count > :codesFromSameSubscription then 0 when (
      codes_by_period.previous_period_codes_count + codes_by_period.codes_count
    ) <= :codesFromSameSubscription then codes_by_period.codes_count when (
      codes_by_period.codes_count - codes_by_period.previous_period_codes_count
    ) > :codesFromSameSubscription then (
      :codesFromSameSubscription - codes_by_period.previous_period_codes_count
    ) else codes_by_period.codes_count - codes_by_period.previous_period_codes_count end
  ) as codes_count
FROM
  (
    SELECT
      offer_order.offer_id,
      offer_order.user_id,
      offer_order.subscription_period_start_at,
      coalesce(
        previous_count.count_by_subscription,
        0
      ) as previous_period_codes_count,
      count(*) as codes_count
    FROM
      offer_code
      INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id
      LEFT JOIN (
        SELECT
          offer_order.offer_id,
          offer_order.user_id,
          offer_order.subscription_period_start_at,
          count(*) as count_by_subscription
        FROM
          offer_code
          INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id
        WHERE
          (
            offer_order.created_on < :dateFrom
          )
          AND (
            (
              offer_order.user_id, subscription_period_start_at
            ) IN (
              SELECT
                DISTINCT offer_order.user_id,
                offer_order.subscription_period_start_at
              FROM
                offer_code
                INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id
              WHERE
                (
                  offer_order.created_on between :dateFrom
                  and :dateTo
                )
                AND (
                  offer_order.subscription_period_start_at IS NOT NULL
                )
            )
          )
        GROUP BY
          offer_order.offer_id,
          offer_order.user_id,
          offer_order.subscription_period_start_at
      ) previous_count ON (
        previous_count.offer_id = offer_order.offer_id
      )
      AND (
        previous_count.user_id = offer_order.user_id
      )
      AND (
        previous_count.subscription_period_start_at = offer_order.subscription_period_start_at
      )
    WHERE
      offer_order.created_on between :dateFrom
      and :dateTo
    GROUP BY
      offer_order.offer_id,
      offer_order.user_id,
      offer_order.subscription_period_start_at,
      coalesce(
        previous_count.count_by_subscription,
        0
      )
  ) codes_by_period
WHERE
  codes_by_period.offer_id = :offerId
GROUP BY
  codes_by_period.offer_id

SELECT codes_by_period.offer_id, sum (case when codes_by_period.subscription_period_start_at is null then codes_by_period.codes_count when codes_by_period.previous_period_codes_count > 0 then 0 when (codes_by_period.previous_period_codes_count + codes_by_period.codes_count) <= 0 then codes_by_period.codes_count when (codes_by_period.codes_count - codes_by_period.previous_period_codes_count) > 0 then (0 - codes_by_period.previous_period_codes_count) else codes_by_period.codes_count - codes_by_period.previous_period_codes_count end) as codes_count FROM (SELECT offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at, coalesce(previous_count.count_by_subscription, 0) as previous_period_codes_count, count(*) as codes_count FROM offer_code INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id LEFT JOIN (SELECT offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at, count(*) as count_by_subscription FROM offer_code INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id WHERE (offer_order.created_on < '2025-05-14 08:37:19') AND ((offer_order.user_id, subscription_period_start_at) IN (SELECT DISTINCT offer_order.user_id, offer_order.subscription_period_start_at FROM offer_code INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id WHERE (offer_order.created_on between '2025-05-14 08:37:19' and '2025-05-15 08:37:19') AND (offer_order.subscription_period_start_at IS NOT NULL))) GROUP BY offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at) previous_count ON (previous_count.offer_id = offer_order.offer_id) AND (previous_count.user_id = offer_order.user_id) AND (previous_count.subscription_period_start_at = offer_order.subscription_period_start_at) WHERE offer_order.created_on between '2025-05-14 08:37:19' and '2025-05-15 08:37:19' GROUP BY offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at, coalesce(previous_count.count_by_subscription, 0)) codes_by_period WHERE codes_by_period.offer_id = 134034 GROUP BY codes_by_period.offer_id;

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 = 134034 AND t0.type IN ('1') ORDER BY t0.sort_order ASC;

SELECT
  COUNT(*)
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type IN ('10')

SELECT COUNT(*) FROM media t0 WHERE t0.entity_id = 134034 AND t0.type IN ('10');

SELECT
  t0.name AS name_1,
  t0.path AS path_2,
  t0.description AS description_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.size AS size_6,
  t0.sort_order AS sort_order_7,
  t0.checked AS checked_8,
  t0.youtube AS youtube_9,
  t0.id AS id_10,
  t0.entity_id AS entity_id_11,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type IN ('10')
ORDER BY
  t0.id DESC

SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.entity_id = 134034 AND t0.type IN ('10') ORDER BY t0.id DESC;

SELECT
  t0.created_on AS created_on_1,
  t0.name AS name_2,
  t0.short_description AS short_description_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.offer_price AS offer_price_6,
  t0.code_price AS code_price_7,
  t0.price_description AS price_description_8,
  t0.code_prefix AS code_prefix_9,
  t0.products_per_code AS products_per_code_10,
  t0.dish_delivery_price AS dish_delivery_price_11,
  t0.pickup_price AS pickup_price_12,
  t0.price_delivery_type AS price_delivery_type_13,
  t0.weight AS weight_14,
  t0.components_count AS components_count_15,
  t0.active AS active_16,
  t0.hidden AS hidden_17,
  t0.special123 AS special123_18,
  t0.partner_image_url AS partner_image_url_19,
  t0.additional_info AS additional_info_20,
  t0.sauce_need AS sauce_need_21,
  t0.modified_on AS modified_on_22,
  t0.is_delivery AS is_delivery_23,
  t0.is_pickup AS is_pickup_24,
  t0.position AS position_25,
  t0.id AS id_26,
  t0.offer_id AS offer_id_27,
  t0.type,
  t0.price_by_time AS price_by_time_28,
  t0.partner_item_id AS partner_item_id_29,
  t0.partner_modifier_id AS partner_modifier_id_30,
  t0.partner_modifier_group_id AS partner_modifier_group_id_31,
  t0.long_code AS long_code_32,
  t0.parameter_int_0 AS parameter_int_0_33,
  t0.parameter_int_1 AS parameter_int_1_34
FROM
  offer_extension t0
WHERE
  t0.offer_id = ?
  AND t0.type IN ('0', '1', '2', '3')

SELECT t0.created_on AS created_on_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.price AS price_5, t0.offer_price AS offer_price_6, t0.code_price AS code_price_7, t0.price_description AS price_description_8, t0.code_prefix AS code_prefix_9, t0.products_per_code AS products_per_code_10, t0.dish_delivery_price AS dish_delivery_price_11, t0.pickup_price AS pickup_price_12, t0.price_delivery_type AS price_delivery_type_13, t0.weight AS weight_14, t0.components_count AS components_count_15, t0.active AS active_16, t0.hidden AS hidden_17, t0.special123 AS special123_18, t0.partner_image_url AS partner_image_url_19, t0.additional_info AS additional_info_20, t0.sauce_need AS sauce_need_21, t0.modified_on AS modified_on_22, t0.is_delivery AS is_delivery_23, t0.is_pickup AS is_pickup_24, t0.position AS position_25, t0.id AS id_26, t0.offer_id AS offer_id_27, t0.type, t0.price_by_time AS price_by_time_28, t0.partner_item_id AS partner_item_id_29, t0.partner_modifier_id AS partner_modifier_id_30, t0.partner_modifier_group_id AS partner_modifier_group_id_31, t0.long_code AS long_code_32, t0.parameter_int_0 AS parameter_int_0_33, t0.parameter_int_1 AS parameter_int_1_34 FROM offer_extension t0 WHERE t0.offer_id = 134034 AND t0.type IN ('0', '1', '2', '3');

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.city_id AS city_id_33,
  t0.type_id AS type_id_34,
  t0.type
FROM
  category t0
  INNER JOIN category2entity ON t0.id = category2entity.category_id
WHERE
  category2entity.entity_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.city_id AS city_id_33, t0.type_id AS type_id_34, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = 134034 AND t0.type IN ('0');

SELECT
  s0_.eligibility_rule AS eligibility_rule_0,
  s0_.id AS id_1
FROM
  server_feature_state s0_

SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_;

SELECT
  c0_.type_id AS type_id_0,
  c0_.entity_id AS entity_id_1,
  c0_.parent_id AS parent_id_2,
  c0_.user_id AS user_id_3,
  c0_.created_on AS created_on_4,
  c0_.user_ip AS user_ip_5,
  c0_.hidden AS hidden_6,
  c0_.checked AS checked_7,
  c0_.deleted AS deleted_8,
  c0_.confirmed_phone AS confirmed_phone_9,
  c0_.seen_by_supplier AS seen_by_supplier_10,
  c0_.comment AS comment_11,
  c0_.admin_comment AS admin_comment_12,
  c0_.rating AS rating_13,
  c0_.taken_by_operator_on AS taken_by_operator_on_14,
  c0_.processed_by_operator_on AS processed_by_operator_on_15,
  c0_.telegram_notify_sent AS telegram_notify_sent_16,
  c0_.allow_to_contact AS allow_to_contact_17,
  c0_.mobile_version AS mobile_version_18,
  c0_.hidden_entity AS hidden_entity_19,
  c0_.id AS id_20,
  c1_.external_id AS external_id_21,
  c1_.created_on AS created_on_22,
  c1_.city_id AS city_id_23,
  c1_.email AS email_24,
  c1_.password AS password_25,
  c1_.accept_newsletter AS accept_newsletter_26,
  c1_.transition_id AS transition_id_27,
  c1_.first_name AS first_name_28,
  c1_.last_name AS last_name_29,
  c1_.phone AS phone_30,
  c1_.status AS status_31,
  c1_.balance AS balance_32,
  c1_.registered_from_utm_source AS registered_from_utm_source_33,
  c1_.token AS token_34,
  c1_.totally_unsubscribed AS totally_unsubscribed_35,
  c1_.seen_microphone_tooltip AS seen_microphone_tooltip_36,
  c1_.not_show_rate_popup_till AS not_show_rate_popup_till_37,
  c1_.geo_location_accepted AS geo_location_accepted_38,
  c1_.geo_location AS geo_location_39,
  c1_.telegram_id AS telegram_id_40,
  c1_.site_id AS site_id_41,
  c1_.manager_name AS manager_name_42,
  c1_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_43,
  c1_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_44,
  c1_.batch_codes_count AS batch_codes_count_45,
  c1_.money_balance AS money_balance_46,
  c1_.id AS id_47,
  c0_.parent_id AS parent_id_48,
  c0_.user_id AS user_id_49,
  c0_.operator_id AS operator_id_50,
  c1_.city_id AS city_id_51
FROM
  comment c0_
  INNER JOIN customer c1_ ON c0_.user_id = c1_.id
WHERE
  c0_.entity_id = ?
  AND c0_.type_id = ?
  AND c0_.hidden <> true
  AND c0_.confirmed_phone = true
  AND c0_.parent_id IS NULL
  AND (
    c0_.deleted IS NULL
    OR c0_.deleted = false
  )
ORDER BY
  c0_.created_on DESC
LIMIT
  20 OFFSET 280

SELECT c0_.type_id AS type_id_0, c0_.entity_id AS entity_id_1, c0_.parent_id AS parent_id_2, c0_.user_id AS user_id_3, c0_.created_on AS created_on_4, c0_.user_ip AS user_ip_5, c0_.hidden AS hidden_6, c0_.checked AS checked_7, c0_.deleted AS deleted_8, c0_.confirmed_phone AS confirmed_phone_9, c0_.seen_by_supplier AS seen_by_supplier_10, c0_.comment AS comment_11, c0_.admin_comment AS admin_comment_12, c0_.rating AS rating_13, c0_.taken_by_operator_on AS taken_by_operator_on_14, c0_.processed_by_operator_on AS processed_by_operator_on_15, c0_.telegram_notify_sent AS telegram_notify_sent_16, c0_.allow_to_contact AS allow_to_contact_17, c0_.mobile_version AS mobile_version_18, c0_.hidden_entity AS hidden_entity_19, c0_.id AS id_20, c1_.external_id AS external_id_21, c1_.created_on AS created_on_22, c1_.city_id AS city_id_23, c1_.email AS email_24, c1_.password AS password_25, c1_.accept_newsletter AS accept_newsletter_26, c1_.transition_id AS transition_id_27, c1_.first_name AS first_name_28, c1_.last_name AS last_name_29, c1_.phone AS phone_30, c1_.status AS status_31, c1_.balance AS balance_32, c1_.registered_from_utm_source AS registered_from_utm_source_33, c1_.token AS token_34, c1_.totally_unsubscribed AS totally_unsubscribed_35, c1_.seen_microphone_tooltip AS seen_microphone_tooltip_36, c1_.not_show_rate_popup_till AS not_show_rate_popup_till_37, c1_.geo_location_accepted AS geo_location_accepted_38, c1_.geo_location AS geo_location_39, c1_.telegram_id AS telegram_id_40, c1_.site_id AS site_id_41, c1_.manager_name AS manager_name_42, c1_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_43, c1_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_44, c1_.batch_codes_count AS batch_codes_count_45, c1_.money_balance AS money_balance_46, c1_.id AS id_47, c0_.parent_id AS parent_id_48, c0_.user_id AS user_id_49, c0_.operator_id AS operator_id_50, c1_.city_id AS city_id_51 FROM comment c0_ INNER JOIN customer c1_ ON c0_.user_id = c1_.id WHERE c0_.entity_id = 134034 AND c0_.type_id = 1 AND c0_.hidden <> true AND c0_.confirmed_phone = true AND c0_.parent_id IS NULL AND (c0_.deleted IS NULL OR c0_.deleted = false) ORDER BY c0_.created_on DESC LIMIT 20 OFFSET 280;

SELECT
  t0.created_on AS created_on_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.id AS id_4,
  t0.referral_id AS referral_id_5,
  t0.user_balance_activity_id AS user_balance_activity_id_6,
  t0.referer_id AS referer_id_7
FROM
  referral t0
WHERE
  t0.referral_id = ?

SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = 17091;

SELECT
  t0.created_on AS created_on_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.id AS id_4,
  t0.referral_id AS referral_id_5,
  t0.user_balance_activity_id AS user_balance_activity_id_6,
  t0.referer_id AS referer_id_7
FROM
  referral t0
WHERE
  t0.referral_id = ?

SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = 670020;

SELECT
  t0.created_on AS created_on_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.id AS id_4,
  t0.referral_id AS referral_id_5,
  t0.user_balance_activity_id AS user_balance_activity_id_6,
  t0.referer_id AS referer_id_7
FROM
  referral t0
WHERE
  t0.referral_id = ?

SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = 256617;

SELECT
  t0.created_on AS created_on_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.id AS id_4,
  t0.referral_id AS referral_id_5,
  t0.user_balance_activity_id AS user_balance_activity_id_6,
  t0.referer_id AS referer_id_7
FROM
  referral t0
WHERE
  t0.referral_id = ?

SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = 373531;

SELECT
  t0.created_on AS created_on_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.id AS id_4,
  t0.referral_id AS referral_id_5,
  t0.user_balance_activity_id AS user_balance_activity_id_6,
  t0.referer_id AS referer_id_7
FROM
  referral t0
WHERE
  t0.referral_id = ?

SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = 412334;

SELECT
  t0.created_on AS created_on_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.id AS id_4,
  t0.referral_id AS referral_id_5,
  t0.user_balance_activity_id AS user_balance_activity_id_6,
  t0.referer_id AS referer_id_7
FROM
  referral t0
WHERE
  t0.referral_id = ?

SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = 289608;