Symfony Profiler

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-07-09 08:10:47') 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-07-09 08:10:47' and '2025-07-10 08:10:47') 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-07-09 08:10:47' and '2025-07-10 08:10:47' 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 = 288083 GROUP BY codes_by_period.offer_id;

SELECT
  sum (
    case when offer_codes.subscription_period_start_at is null then offer_codes.codes_count when offer_codes.codes_count > :codesFromSameSubscription then :codesFromSameSubscription else offer_codes.codes_count end
  ) as codes_count
FROM
  (
    SELECT
      offer_order.offer_id,
      offer_order.user_id,
      offer_order.subscription_period_start_at,
      offer_code.offer_code_pool_id as code_pool_id,
      count(*) as codes_count
    FROM
      offer_code
      INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id
    GROUP BY
      offer_order.offer_id,
      offer_order.user_id,
      offer_order.subscription_period_start_at,
      offer_code.offer_code_pool_id
  ) offer_codes
WHERE
  (offer_codes.offer_id = :offerId)
  AND (
    offer_codes.code_pool_id = :codePoolId
  )

SELECT sum (case when offer_codes.subscription_period_start_at is null then offer_codes.codes_count when offer_codes.codes_count > 0 then 0 else offer_codes.codes_count end) as codes_count FROM (SELECT offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at, offer_code.offer_code_pool_id as code_pool_id, count(*) as codes_count FROM offer_code INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id GROUP BY offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at, offer_code.offer_code_pool_id) offer_codes WHERE (offer_codes.offer_id = 288083) AND (offer_codes.code_pool_id = 171371);

SELECT
  t0.user_id AS user_id_1,
  t0.operator_id AS operator_id_2,
  t0.created_on AS created_on_3,
  t0.paid_at AS paid_at_4,
  t0.status AS status_5,
  t0.amount AS amount_6,
  t0.codes_count AS codes_count_7,
  t0.code_cost AS code_cost_8,
  t0.number AS number_9,
  t0.seen_by_user AS seen_by_user_10,
  t0.sent_to_supplier AS sent_to_supplier_11,
  t0.utm_source AS utm_source_12,
  t0.transition_id AS transition_id_13,
  t0.device_type AS device_type_14,
  t0.cookie_period AS cookie_period_15,
  t0.payment_method_id AS payment_method_id_16,
  t0.utm_data AS utm_data_17,
  t0.comment AS comment_18,
  t0.delivery_time AS delivery_time_19,
  t0.delivery_cost AS delivery_cost_20,
  t0.expired_on AS expired_on_21,
  t0.offer_id AS offer_id_22,
  t0.city_id AS city_id_23,
  t0.subscription_plan_user_relation_id AS subscription_plan_user_relation_id_24,
  t0.external_id AS external_id_25,
  t0.is_food_court AS is_food_court_26,
  t0.additional_info AS additional_info_27,
  t0.username AS username_28,
  t0.user_phone AS user_phone_29,
  t0.subscription_period_start_at AS subscription_period_start_at_30,
  t0.delivery_zone_location_id AS delivery_zone_location_id_31,
  t0.is_online_gift AS is_online_gift_32,
  t0.use_partner_cashback_balance AS use_partner_cashback_balance_33,
  t0.used_partner_cashback_sum AS used_partner_cashback_sum_34,
  t0.use_fast_delivery AS use_fast_delivery_35,
  t0.id AS id_36,
  t0.booking_id AS booking_id_37,
  t0.delivery_address_id AS delivery_address_id_38,
  t0.offer_id AS offer_id_39,
  t41.title AS title_40,
  t41.me_on_map_name AS me_on_map_name_42,
  t41.explanation_text AS explanation_text_43,
  t41.price AS price_44,
  t41.old_price AS old_price_45,
  t41.regular_price AS regular_price_46,
  t41.offer_price AS offer_price_47,
  t41.discount AS discount_48,
  t41.active_since AS active_since_49,
  t41.active_till AS active_till_50,
  t41.code_active_till AS code_active_till_51,
  t41.active AS active_52,
  t41.hidden AS hidden_53,
  t41.free AS free_54,
  t41.without_codes AS without_codes_55,
  t41.online_order_allowed AS online_order_allowed_56,
  t41.buy_code_disable AS buy_code_disable_57,
  t41.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_58,
  t41.online_order_allowed_removed_at AS online_order_allowed_removed_at_59,
  t41.show_price_in_conditions AS show_price_in_conditions_60,
  t41.show_alt_offers AS show_alt_offers_61,
  t41.show_currencies AS show_currencies_62,
  t41.additional_percents AS additional_percents_63,
  t41.address AS address_64,
  t41.caption_name AS caption_name_65,
  t41.caption_color AS caption_color_66,
  t41.regional_caption_name AS regional_caption_name_67,
  t41.regional_caption_color AS regional_caption_color_68,
  t41.search_position AS search_position_69,
  t41.active_search_position AS active_search_position_70,
  t41.hint AS hint_71,
  t41.bank_currency_id AS bank_currency_id_72,
  t41.active_currency_calculator AS active_currency_calculator_73,
  t41.last_modified AS last_modified_74,
  t41.teaser_logo_width AS teaser_logo_width_75,
  t41.teaser_logo_height AS teaser_logo_height_76,
  t41.lucene_reindex AS lucene_reindex_77,
  t41.code_cost AS code_cost_78,
  t41.code_cost_by_count AS code_cost_by_count_79,
  t41.default_category_id AS default_category_id_80,
  t41.company_name AS company_name_81,
  t41.renewed_on AS renewed_on_82,
  t41.hide_novelty_label AS hide_novelty_label_83,
  t41.hide_banners_in_comments AS hide_banners_in_comments_84,
  t41.sum_for_free_delivery AS sum_for_free_delivery_85,
  t41.delivery_price AS delivery_price_86,
  t41.created_on AS created_on_87,
  t41.allowed_buy_only_code AS allowed_buy_only_code_88,
  t41.buy_code_button_text AS buy_code_button_text_89,
  t41.buy_items_button_text AS buy_items_button_text_90,
  t41.purchase_koeff AS purchase_koeff_91,
  t41.telegram_bot_show AS telegram_bot_show_92,
  t41.telegram_bot_position AS telegram_bot_position_93,
  t41.version AS version_94,
  t41.hide_in_app AS hide_in_app_95,
  t41.brandbox_enabled AS brandbox_enabled_96,
  t41.hide_features AS hide_features_97,
  t41.discount_delivery_popup AS discount_delivery_popup_98,
  t41.discount_pickup_popup AS discount_pickup_popup_99,
  t41.delivery_time_teaser AS delivery_time_teaser_100,
  t41.external_offer_link AS external_offer_link_101,
  t41.is_show_external_offer_link AS is_show_external_offer_link_102,
  t41.is_included_in_beauty AS is_included_in_beauty_103,
  t41.qr_codes AS qr_codes_104,
  t41.recurrent_disabled AS recurrent_disabled_105,
  t41.available_on_food AS available_on_food_106,
  t41.online_auto_opened AS online_auto_opened_107,
  t41.foodcourt_logo_enabled AS foodcourt_logo_enabled_108,
  t41.rating AS rating_109,
  t41.foodcourt_info_teaser AS foodcourt_info_teaser_110,
  t41.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_111,
  t41.online_order_gift_enabled AS online_order_gift_enabled_112,
  t41.buy_code_in_app_only AS buy_code_in_app_only_113,
  t41.show_products_in_offer_description AS show_products_in_offer_description_114,
  t41.check_address_in_offer_menu AS check_address_in_offer_menu_115,
  t41.show_map_icon_in_app AS show_map_icon_in_app_116,
  t41.viber AS viber_117,
  t41.telegram AS telegram_118,
  t41.messenger_callback AS messenger_callback_119,
  t41.allowed_online_order_types AS allowed_online_order_types_120,
  t41.title_font_color AS title_font_color_121,
  t41.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_122,
  t41.map_price AS map_price_123,
  t41.map_rating AS map_rating_124,
  t41.review AS review_125,
  t41.on_review AS on_review_126,
  t41.id AS id_127,
  t41.bank_currency_id AS bank_currency_id_128,
  t41.manager_id AS manager_id_129,
  t41.creator_id AS creator_id_130,
  t41.default_city_id AS default_city_id_131,
  t0.user_id AS user_id_132,
  t0.operator_id AS operator_id_133,
  t0.type,
  t0.parameter_varchar_0 AS parameter_varchar_0_134,
  t0.parameter_int_0 AS parameter_int_0_135,
  t0.delivery_status AS delivery_status_136,
  t0.parameter_int_0 AS parameter_int_0_137,
  t0.parameter_int_0 AS parameter_int_0_138,
  t0.parameter_int_0 AS parameter_int_0_139
FROM
  offer_order t0
  LEFT JOIN offer t41 ON t0.offer_id = t41.id
WHERE
  (
    t0.offer_id = ?
    AND t0.user_id = ?
  )
  AND t0.type IN ('0', '3', '4', '5', '6', '7')
ORDER BY
  t0.created_on DESC

SELECT t0.user_id AS user_id_1, t0.operator_id AS operator_id_2, t0.created_on AS created_on_3, t0.paid_at AS paid_at_4, t0.status AS status_5, t0.amount AS amount_6, t0.codes_count AS codes_count_7, t0.code_cost AS code_cost_8, t0.number AS number_9, t0.seen_by_user AS seen_by_user_10, t0.sent_to_supplier AS sent_to_supplier_11, t0.utm_source AS utm_source_12, t0.transition_id AS transition_id_13, t0.device_type AS device_type_14, t0.cookie_period AS cookie_period_15, t0.payment_method_id AS payment_method_id_16, t0.utm_data AS utm_data_17, t0.comment AS comment_18, t0.delivery_time AS delivery_time_19, t0.delivery_cost AS delivery_cost_20, t0.expired_on AS expired_on_21, t0.offer_id AS offer_id_22, t0.city_id AS city_id_23, t0.subscription_plan_user_relation_id AS subscription_plan_user_relation_id_24, t0.external_id AS external_id_25, t0.is_food_court AS is_food_court_26, t0.additional_info AS additional_info_27, t0.username AS username_28, t0.user_phone AS user_phone_29, t0.subscription_period_start_at AS subscription_period_start_at_30, t0.delivery_zone_location_id AS delivery_zone_location_id_31, t0.is_online_gift AS is_online_gift_32, t0.use_partner_cashback_balance AS use_partner_cashback_balance_33, t0.used_partner_cashback_sum AS used_partner_cashback_sum_34, t0.use_fast_delivery AS use_fast_delivery_35, t0.id AS id_36, t0.booking_id AS booking_id_37, t0.delivery_address_id AS delivery_address_id_38, t0.offer_id AS offer_id_39, t41.title AS title_40, t41.me_on_map_name AS me_on_map_name_42, t41.explanation_text AS explanation_text_43, t41.price AS price_44, t41.old_price AS old_price_45, t41.regular_price AS regular_price_46, t41.offer_price AS offer_price_47, t41.discount AS discount_48, t41.active_since AS active_since_49, t41.active_till AS active_till_50, t41.code_active_till AS code_active_till_51, t41.active AS active_52, t41.hidden AS hidden_53, t41.free AS free_54, t41.without_codes AS without_codes_55, t41.online_order_allowed AS online_order_allowed_56, t41.buy_code_disable AS buy_code_disable_57, t41.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_58, t41.online_order_allowed_removed_at AS online_order_allowed_removed_at_59, t41.show_price_in_conditions AS show_price_in_conditions_60, t41.show_alt_offers AS show_alt_offers_61, t41.show_currencies AS show_currencies_62, t41.additional_percents AS additional_percents_63, t41.address AS address_64, t41.caption_name AS caption_name_65, t41.caption_color AS caption_color_66, t41.regional_caption_name AS regional_caption_name_67, t41.regional_caption_color AS regional_caption_color_68, t41.search_position AS search_position_69, t41.active_search_position AS active_search_position_70, t41.hint AS hint_71, t41.bank_currency_id AS bank_currency_id_72, t41.active_currency_calculator AS active_currency_calculator_73, t41.last_modified AS last_modified_74, t41.teaser_logo_width AS teaser_logo_width_75, t41.teaser_logo_height AS teaser_logo_height_76, t41.lucene_reindex AS lucene_reindex_77, t41.code_cost AS code_cost_78, t41.code_cost_by_count AS code_cost_by_count_79, t41.default_category_id AS default_category_id_80, t41.company_name AS company_name_81, t41.renewed_on AS renewed_on_82, t41.hide_novelty_label AS hide_novelty_label_83, t41.hide_banners_in_comments AS hide_banners_in_comments_84, t41.sum_for_free_delivery AS sum_for_free_delivery_85, t41.delivery_price AS delivery_price_86, t41.created_on AS created_on_87, t41.allowed_buy_only_code AS allowed_buy_only_code_88, t41.buy_code_button_text AS buy_code_button_text_89, t41.buy_items_button_text AS buy_items_button_text_90, t41.purchase_koeff AS purchase_koeff_91, t41.telegram_bot_show AS telegram_bot_show_92, t41.telegram_bot_position AS telegram_bot_position_93, t41.version AS version_94, t41.hide_in_app AS hide_in_app_95, t41.brandbox_enabled AS brandbox_enabled_96, t41.hide_features AS hide_features_97, t41.discount_delivery_popup AS discount_delivery_popup_98, t41.discount_pickup_popup AS discount_pickup_popup_99, t41.delivery_time_teaser AS delivery_time_teaser_100, t41.external_offer_link AS external_offer_link_101, t41.is_show_external_offer_link AS is_show_external_offer_link_102, t41.is_included_in_beauty AS is_included_in_beauty_103, t41.qr_codes AS qr_codes_104, t41.recurrent_disabled AS recurrent_disabled_105, t41.available_on_food AS available_on_food_106, t41.online_auto_opened AS online_auto_opened_107, t41.foodcourt_logo_enabled AS foodcourt_logo_enabled_108, t41.rating AS rating_109, t41.foodcourt_info_teaser AS foodcourt_info_teaser_110, t41.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_111, t41.online_order_gift_enabled AS online_order_gift_enabled_112, t41.buy_code_in_app_only AS buy_code_in_app_only_113, t41.show_products_in_offer_description AS show_products_in_offer_description_114, t41.check_address_in_offer_menu AS check_address_in_offer_menu_115, t41.show_map_icon_in_app AS show_map_icon_in_app_116, t41.viber AS viber_117, t41.telegram AS telegram_118, t41.messenger_callback AS messenger_callback_119, t41.allowed_online_order_types AS allowed_online_order_types_120, t41.title_font_color AS title_font_color_121, t41.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_122, t41.map_price AS map_price_123, t41.map_rating AS map_rating_124, t41.review AS review_125, t41.on_review AS on_review_126, t41.id AS id_127, t41.bank_currency_id AS bank_currency_id_128, t41.manager_id AS manager_id_129, t41.creator_id AS creator_id_130, t41.default_city_id AS default_city_id_131, t0.user_id AS user_id_132, t0.operator_id AS operator_id_133, t0.type, t0.parameter_varchar_0 AS parameter_varchar_0_134, t0.parameter_int_0 AS parameter_int_0_135, t0.delivery_status AS delivery_status_136, t0.parameter_int_0 AS parameter_int_0_137, t0.parameter_int_0 AS parameter_int_0_138, t0.parameter_int_0 AS parameter_int_0_139 FROM offer_order t0 LEFT JOIN offer t41 ON t0.offer_id = t41.id WHERE (t0.offer_id = 288083 AND t0.user_id = 1281565) AND t0.type IN ('0', '3', '4', '5', '6', '7') ORDER BY t0.created_on DESC;

SELECT
  t0.user_id AS user_id_1,
  t0.operator_id AS operator_id_2,
  t0.created_on AS created_on_3,
  t0.paid_at AS paid_at_4,
  t0.status AS status_5,
  t0.amount AS amount_6,
  t0.codes_count AS codes_count_7,
  t0.code_cost AS code_cost_8,
  t0.number AS number_9,
  t0.seen_by_user AS seen_by_user_10,
  t0.sent_to_supplier AS sent_to_supplier_11,
  t0.utm_source AS utm_source_12,
  t0.transition_id AS transition_id_13,
  t0.device_type AS device_type_14,
  t0.cookie_period AS cookie_period_15,
  t0.payment_method_id AS payment_method_id_16,
  t0.utm_data AS utm_data_17,
  t0.comment AS comment_18,
  t0.delivery_time AS delivery_time_19,
  t0.delivery_cost AS delivery_cost_20,
  t0.expired_on AS expired_on_21,
  t0.offer_id AS offer_id_22,
  t0.city_id AS city_id_23,
  t0.subscription_plan_user_relation_id AS subscription_plan_user_relation_id_24,
  t0.external_id AS external_id_25,
  t0.is_food_court AS is_food_court_26,
  t0.additional_info AS additional_info_27,
  t0.username AS username_28,
  t0.user_phone AS user_phone_29,
  t0.subscription_period_start_at AS subscription_period_start_at_30,
  t0.delivery_zone_location_id AS delivery_zone_location_id_31,
  t0.is_online_gift AS is_online_gift_32,
  t0.use_partner_cashback_balance AS use_partner_cashback_balance_33,
  t0.used_partner_cashback_sum AS used_partner_cashback_sum_34,
  t0.use_fast_delivery AS use_fast_delivery_35,
  t0.id AS id_36,
  t0.booking_id AS booking_id_37,
  t0.delivery_address_id AS delivery_address_id_38,
  t0.offer_id AS offer_id_39,
  t41.title AS title_40,
  t41.me_on_map_name AS me_on_map_name_42,
  t41.explanation_text AS explanation_text_43,
  t41.price AS price_44,
  t41.old_price AS old_price_45,
  t41.regular_price AS regular_price_46,
  t41.offer_price AS offer_price_47,
  t41.discount AS discount_48,
  t41.active_since AS active_since_49,
  t41.active_till AS active_till_50,
  t41.code_active_till AS code_active_till_51,
  t41.active AS active_52,
  t41.hidden AS hidden_53,
  t41.free AS free_54,
  t41.without_codes AS without_codes_55,
  t41.online_order_allowed AS online_order_allowed_56,
  t41.buy_code_disable AS buy_code_disable_57,
  t41.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_58,
  t41.online_order_allowed_removed_at AS online_order_allowed_removed_at_59,
  t41.show_price_in_conditions AS show_price_in_conditions_60,
  t41.show_alt_offers AS show_alt_offers_61,
  t41.show_currencies AS show_currencies_62,
  t41.additional_percents AS additional_percents_63,
  t41.address AS address_64,
  t41.caption_name AS caption_name_65,
  t41.caption_color AS caption_color_66,
  t41.regional_caption_name AS regional_caption_name_67,
  t41.regional_caption_color AS regional_caption_color_68,
  t41.search_position AS search_position_69,
  t41.active_search_position AS active_search_position_70,
  t41.hint AS hint_71,
  t41.bank_currency_id AS bank_currency_id_72,
  t41.active_currency_calculator AS active_currency_calculator_73,
  t41.last_modified AS last_modified_74,
  t41.teaser_logo_width AS teaser_logo_width_75,
  t41.teaser_logo_height AS teaser_logo_height_76,
  t41.lucene_reindex AS lucene_reindex_77,
  t41.code_cost AS code_cost_78,
  t41.code_cost_by_count AS code_cost_by_count_79,
  t41.default_category_id AS default_category_id_80,
  t41.company_name AS company_name_81,
  t41.renewed_on AS renewed_on_82,
  t41.hide_novelty_label AS hide_novelty_label_83,
  t41.hide_banners_in_comments AS hide_banners_in_comments_84,
  t41.sum_for_free_delivery AS sum_for_free_delivery_85,
  t41.delivery_price AS delivery_price_86,
  t41.created_on AS created_on_87,
  t41.allowed_buy_only_code AS allowed_buy_only_code_88,
  t41.buy_code_button_text AS buy_code_button_text_89,
  t41.buy_items_button_text AS buy_items_button_text_90,
  t41.purchase_koeff AS purchase_koeff_91,
  t41.telegram_bot_show AS telegram_bot_show_92,
  t41.telegram_bot_position AS telegram_bot_position_93,
  t41.version AS version_94,
  t41.hide_in_app AS hide_in_app_95,
  t41.brandbox_enabled AS brandbox_enabled_96,
  t41.hide_features AS hide_features_97,
  t41.discount_delivery_popup AS discount_delivery_popup_98,
  t41.discount_pickup_popup AS discount_pickup_popup_99,
  t41.delivery_time_teaser AS delivery_time_teaser_100,
  t41.external_offer_link AS external_offer_link_101,
  t41.is_show_external_offer_link AS is_show_external_offer_link_102,
  t41.is_included_in_beauty AS is_included_in_beauty_103,
  t41.qr_codes AS qr_codes_104,
  t41.recurrent_disabled AS recurrent_disabled_105,
  t41.available_on_food AS available_on_food_106,
  t41.online_auto_opened AS online_auto_opened_107,
  t41.foodcourt_logo_enabled AS foodcourt_logo_enabled_108,
  t41.rating AS rating_109,
  t41.foodcourt_info_teaser AS foodcourt_info_teaser_110,
  t41.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_111,
  t41.online_order_gift_enabled AS online_order_gift_enabled_112,
  t41.buy_code_in_app_only AS buy_code_in_app_only_113,
  t41.show_products_in_offer_description AS show_products_in_offer_description_114,
  t41.check_address_in_offer_menu AS check_address_in_offer_menu_115,
  t41.show_map_icon_in_app AS show_map_icon_in_app_116,
  t41.viber AS viber_117,
  t41.telegram AS telegram_118,
  t41.messenger_callback AS messenger_callback_119,
  t41.allowed_online_order_types AS allowed_online_order_types_120,
  t41.title_font_color AS title_font_color_121,
  t41.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_122,
  t41.map_price AS map_price_123,
  t41.map_rating AS map_rating_124,
  t41.review AS review_125,
  t41.on_review AS on_review_126,
  t41.id AS id_127,
  t41.bank_currency_id AS bank_currency_id_128,
  t41.manager_id AS manager_id_129,
  t41.creator_id AS creator_id_130,
  t41.default_city_id AS default_city_id_131,
  t0.user_id AS user_id_132,
  t0.operator_id AS operator_id_133,
  t0.type,
  t0.parameter_varchar_0 AS parameter_varchar_0_134,
  t0.parameter_int_0 AS parameter_int_0_135,
  t0.delivery_status AS delivery_status_136,
  t0.parameter_int_0 AS parameter_int_0_137,
  t0.parameter_int_0 AS parameter_int_0_138,
  t0.parameter_int_0 AS parameter_int_0_139
FROM
  offer_order t0
  LEFT JOIN offer t41 ON t0.offer_id = t41.id
WHERE
  t0.user_id = ?
  AND t0.type IN ('0', '3', '4', '5', '6', '7')
ORDER BY
  t0.created_on DESC

SELECT t0.user_id AS user_id_1, t0.operator_id AS operator_id_2, t0.created_on AS created_on_3, t0.paid_at AS paid_at_4, t0.status AS status_5, t0.amount AS amount_6, t0.codes_count AS codes_count_7, t0.code_cost AS code_cost_8, t0.number AS number_9, t0.seen_by_user AS seen_by_user_10, t0.sent_to_supplier AS sent_to_supplier_11, t0.utm_source AS utm_source_12, t0.transition_id AS transition_id_13, t0.device_type AS device_type_14, t0.cookie_period AS cookie_period_15, t0.payment_method_id AS payment_method_id_16, t0.utm_data AS utm_data_17, t0.comment AS comment_18, t0.delivery_time AS delivery_time_19, t0.delivery_cost AS delivery_cost_20, t0.expired_on AS expired_on_21, t0.offer_id AS offer_id_22, t0.city_id AS city_id_23, t0.subscription_plan_user_relation_id AS subscription_plan_user_relation_id_24, t0.external_id AS external_id_25, t0.is_food_court AS is_food_court_26, t0.additional_info AS additional_info_27, t0.username AS username_28, t0.user_phone AS user_phone_29, t0.subscription_period_start_at AS subscription_period_start_at_30, t0.delivery_zone_location_id AS delivery_zone_location_id_31, t0.is_online_gift AS is_online_gift_32, t0.use_partner_cashback_balance AS use_partner_cashback_balance_33, t0.used_partner_cashback_sum AS used_partner_cashback_sum_34, t0.use_fast_delivery AS use_fast_delivery_35, t0.id AS id_36, t0.booking_id AS booking_id_37, t0.delivery_address_id AS delivery_address_id_38, t0.offer_id AS offer_id_39, t41.title AS title_40, t41.me_on_map_name AS me_on_map_name_42, t41.explanation_text AS explanation_text_43, t41.price AS price_44, t41.old_price AS old_price_45, t41.regular_price AS regular_price_46, t41.offer_price AS offer_price_47, t41.discount AS discount_48, t41.active_since AS active_since_49, t41.active_till AS active_till_50, t41.code_active_till AS code_active_till_51, t41.active AS active_52, t41.hidden AS hidden_53, t41.free AS free_54, t41.without_codes AS without_codes_55, t41.online_order_allowed AS online_order_allowed_56, t41.buy_code_disable AS buy_code_disable_57, t41.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_58, t41.online_order_allowed_removed_at AS online_order_allowed_removed_at_59, t41.show_price_in_conditions AS show_price_in_conditions_60, t41.show_alt_offers AS show_alt_offers_61, t41.show_currencies AS show_currencies_62, t41.additional_percents AS additional_percents_63, t41.address AS address_64, t41.caption_name AS caption_name_65, t41.caption_color AS caption_color_66, t41.regional_caption_name AS regional_caption_name_67, t41.regional_caption_color AS regional_caption_color_68, t41.search_position AS search_position_69, t41.active_search_position AS active_search_position_70, t41.hint AS hint_71, t41.bank_currency_id AS bank_currency_id_72, t41.active_currency_calculator AS active_currency_calculator_73, t41.last_modified AS last_modified_74, t41.teaser_logo_width AS teaser_logo_width_75, t41.teaser_logo_height AS teaser_logo_height_76, t41.lucene_reindex AS lucene_reindex_77, t41.code_cost AS code_cost_78, t41.code_cost_by_count AS code_cost_by_count_79, t41.default_category_id AS default_category_id_80, t41.company_name AS company_name_81, t41.renewed_on AS renewed_on_82, t41.hide_novelty_label AS hide_novelty_label_83, t41.hide_banners_in_comments AS hide_banners_in_comments_84, t41.sum_for_free_delivery AS sum_for_free_delivery_85, t41.delivery_price AS delivery_price_86, t41.created_on AS created_on_87, t41.allowed_buy_only_code AS allowed_buy_only_code_88, t41.buy_code_button_text AS buy_code_button_text_89, t41.buy_items_button_text AS buy_items_button_text_90, t41.purchase_koeff AS purchase_koeff_91, t41.telegram_bot_show AS telegram_bot_show_92, t41.telegram_bot_position AS telegram_bot_position_93, t41.version AS version_94, t41.hide_in_app AS hide_in_app_95, t41.brandbox_enabled AS brandbox_enabled_96, t41.hide_features AS hide_features_97, t41.discount_delivery_popup AS discount_delivery_popup_98, t41.discount_pickup_popup AS discount_pickup_popup_99, t41.delivery_time_teaser AS delivery_time_teaser_100, t41.external_offer_link AS external_offer_link_101, t41.is_show_external_offer_link AS is_show_external_offer_link_102, t41.is_included_in_beauty AS is_included_in_beauty_103, t41.qr_codes AS qr_codes_104, t41.recurrent_disabled AS recurrent_disabled_105, t41.available_on_food AS available_on_food_106, t41.online_auto_opened AS online_auto_opened_107, t41.foodcourt_logo_enabled AS foodcourt_logo_enabled_108, t41.rating AS rating_109, t41.foodcourt_info_teaser AS foodcourt_info_teaser_110, t41.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_111, t41.online_order_gift_enabled AS online_order_gift_enabled_112, t41.buy_code_in_app_only AS buy_code_in_app_only_113, t41.show_products_in_offer_description AS show_products_in_offer_description_114, t41.check_address_in_offer_menu AS check_address_in_offer_menu_115, t41.show_map_icon_in_app AS show_map_icon_in_app_116, t41.viber AS viber_117, t41.telegram AS telegram_118, t41.messenger_callback AS messenger_callback_119, t41.allowed_online_order_types AS allowed_online_order_types_120, t41.title_font_color AS title_font_color_121, t41.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_122, t41.map_price AS map_price_123, t41.map_rating AS map_rating_124, t41.review AS review_125, t41.on_review AS on_review_126, t41.id AS id_127, t41.bank_currency_id AS bank_currency_id_128, t41.manager_id AS manager_id_129, t41.creator_id AS creator_id_130, t41.default_city_id AS default_city_id_131, t0.user_id AS user_id_132, t0.operator_id AS operator_id_133, t0.type, t0.parameter_varchar_0 AS parameter_varchar_0_134, t0.parameter_int_0 AS parameter_int_0_135, t0.delivery_status AS delivery_status_136, t0.parameter_int_0 AS parameter_int_0_137, t0.parameter_int_0 AS parameter_int_0_138, t0.parameter_int_0 AS parameter_int_0_139 FROM offer_order t0 LEFT JOIN offer t41 ON t0.offer_id = t41.id WHERE t0.user_id = 1281565 AND t0.type IN ('0', '3', '4', '5', '6', '7') ORDER BY t0.created_on DESC;

select
  offer_order_details.created_on
from
  offer_order_details
  inner join offer_order on offer_order_details.offer_order_id = offer_order.id
where
  offer_order.offer_id = 288083
  and status > 0
  and offer_order_details.created_on > now() + '-12 hours'
order by
  offer_order_details.id desc
limit
  1

select offer_order_details.created_on from offer_order_details inner join offer_order on offer_order_details.offer_order_id = offer_order.id
          where offer_order.offer_id = 288083 and status > 0 and offer_order_details.created_on > now() + '-12 hours' order by offer_order_details.id desc limit 1;

SELECT
  count(c0_.id) AS sclr_0
FROM
  comment c0_
WHERE
  c0_.entity_id = ?
  AND c0_.type_id = ?
  AND c0_.user_id = ?
  AND c0_.confirmed_phone = true
  AND c0_.hidden <> true
LIMIT
  1

SELECT count(c0_.id) AS sclr_0 FROM comment c0_ WHERE c0_.entity_id = 288083 AND c0_.type_id = 1 AND c0_.user_id = 1281565 AND c0_.confirmed_phone = true AND c0_.hidden <> true LIMIT 1;

SELECT
  count(v0_.id) AS sclr_0
FROM
  visit v0_
WHERE
  v0_.entity_id = ?
  AND v0_.entity_type_id = ?
  AND v0_.created_on > ?
  AND v0_.created_on > ?

SELECT count(v0_.id) AS sclr_0 FROM visit v0_ WHERE v0_.entity_id = 288083 AND v0_.entity_type_id = 1 AND v0_.created_on > '2025-07-09 08:10:50' AND v0_.created_on > '2022-06-22 00:00:00';

SELECT
  COUNT(*)
FROM
  comment t0
WHERE
  t0.parent_id = ?

SELECT COUNT(*) FROM comment t0 WHERE t0.parent_id = 697930;

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 ('18079')
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.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.entity_id = 697930 AND t0.type IN ('18079') ORDER BY t0.sort_order ASC;

SELECT
  t0.media_id AS media_id_1,
  t0.width AS width_2,
  t0.height AS height_3,
  t0.id AS id_4,
  t0.media_id AS media_id_5
FROM
  media_size t0
WHERE
  t0.media_id = ?

SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = 779459;

SELECT
  t0.type_id AS type_id_1,
  t0.entity_id AS entity_id_2,
  t0.parent_id AS parent_id_3,
  t0.user_id AS user_id_4,
  t0.created_on AS created_on_5,
  t0.user_ip AS user_ip_6,
  t0.hidden AS hidden_7,
  t0.checked AS checked_8,
  t0.deleted AS deleted_9,
  t0.confirmed_phone AS confirmed_phone_10,
  t0.seen_by_supplier AS seen_by_supplier_11,
  t0.comment AS comment_12,
  t0.admin_comment AS admin_comment_13,
  t0.rating AS rating_14,
  t0.taken_by_operator_on AS taken_by_operator_on_15,
  t0.processed_by_operator_on AS processed_by_operator_on_16,
  t0.telegram_notify_sent AS telegram_notify_sent_17,
  t0.allow_to_contact AS allow_to_contact_18,
  t0.mobile_version AS mobile_version_19,
  t0.hidden_entity AS hidden_entity_20,
  t0.id AS id_21,
  t0.parent_id AS parent_id_22,
  t0.user_id AS user_id_23,
  t0.operator_id AS operator_id_24
FROM
  comment t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.id ASC

SELECT t0.type_id AS type_id_1, t0.entity_id AS entity_id_2, t0.parent_id AS parent_id_3, t0.user_id AS user_id_4, t0.created_on AS created_on_5, t0.user_ip AS user_ip_6, t0.hidden AS hidden_7, t0.checked AS checked_8, t0.deleted AS deleted_9, t0.confirmed_phone AS confirmed_phone_10, t0.seen_by_supplier AS seen_by_supplier_11, t0.comment AS comment_12, t0.admin_comment AS admin_comment_13, t0.rating AS rating_14, t0.taken_by_operator_on AS taken_by_operator_on_15, t0.processed_by_operator_on AS processed_by_operator_on_16, t0.telegram_notify_sent AS telegram_notify_sent_17, t0.allow_to_contact AS allow_to_contact_18, t0.mobile_version AS mobile_version_19, t0.hidden_entity AS hidden_entity_20, t0.id AS id_21, t0.parent_id AS parent_id_22, t0.user_id AS user_id_23, t0.operator_id AS operator_id_24 FROM comment t0 WHERE t0.parent_id = 697930 ORDER BY t0.id ASC;