Symfony Profiler

SELECT
  offer_order.offer_id as offer_id,
  count(*) as codes_count
FROM
  offer_code
  INNER JOIN offer_order offer_order ON offer_order.id = offer_code.offer_order_id
WHERE
  (
    offer_order.subscription_period_start_at IS NULL
  )
  AND (offer_order.offer_id = :offerId)
  AND (
    offer_code.offer_code_pool_id = :codePoolId
  )
GROUP BY
  offer_id

SELECT offer_order.offer_id as offer_id, count(*) as codes_count FROM offer_code INNER JOIN offer_order offer_order ON offer_order.id = offer_code.offer_order_id WHERE (offer_order.subscription_period_start_at IS NULL) AND (offer_order.offer_id = 139615) AND (offer_code.offer_code_pool_id = 154841) GROUP BY offer_id;

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_.voice_path AS voice_path_20,
  c0_.phone AS phone_21,
  c0_.transcription AS transcription_22,
  c0_.id AS id_23,
  m1_.name AS name_24,
  m1_.path AS path_25,
  m1_.description AS description_26,
  m1_.width AS width_27,
  m1_.height AS height_28,
  m1_.size AS size_29,
  m1_.sort_order AS sort_order_30,
  m1_.checked AS checked_31,
  m1_.youtube AS youtube_32,
  m1_.tags AS tags_33,
  m1_.id AS id_34,
  c0_.parent_id AS parent_id_35,
  c0_.user_id AS user_id_36,
  c0_.operator_id AS operator_id_37,
  m1_.type AS type_38,
  m1_.entity_id AS entity_id_39
FROM
  comment c0_
  INNER JOIN media m1_ ON c0_.id = m1_.entity_id
  AND m1_.type IN ('18079')
  INNER JOIN offer o2_ ON (o2_.id = c0_.entity_id)
WHERE
  c0_.type_id = ?
  AND c0_.hidden = false
  AND c0_.confirmed_phone = true
  AND (
    c0_.deleted = false
    OR c0_.deleted IS NULL
  )
  AND o2_.active = true
  AND o2_.id = ?
ORDER BY
  c0_.id DESC,
  m1_.sort_order ASC
LIMIT
  10

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_.voice_path AS voice_path_20, c0_.phone AS phone_21, c0_.transcription AS transcription_22, c0_.id AS id_23, m1_.name AS name_24, m1_.path AS path_25, m1_.description AS description_26, m1_.width AS width_27, m1_.height AS height_28, m1_.size AS size_29, m1_.sort_order AS sort_order_30, m1_.checked AS checked_31, m1_.youtube AS youtube_32, m1_.tags AS tags_33, m1_.id AS id_34, c0_.parent_id AS parent_id_35, c0_.user_id AS user_id_36, c0_.operator_id AS operator_id_37, m1_.type AS type_38, m1_.entity_id AS entity_id_39 FROM comment c0_ INNER JOIN media m1_ ON c0_.id = m1_.entity_id AND m1_.type IN ('18079') INNER JOIN offer o2_ ON (o2_.id = c0_.entity_id) WHERE c0_.type_id = 1 AND c0_.hidden = false AND c0_.confirmed_phone = true AND (c0_.deleted = false OR c0_.deleted IS NULL) AND o2_.active = true AND o2_.id = 139615 ORDER BY c0_.id DESC, m1_.sort_order ASC LIMIT 10;

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 = 139615 AND c0_.type_id = 1 AND c0_.user_id = 1580641 AND c0_.confirmed_phone = true AND c0_.hidden <> true LIMIT 1;

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_.voice_path AS voice_path_20,
  c0_.phone AS phone_21,
  c0_.transcription AS transcription_22,
  c0_.id AS id_23,
  c1_.external_id AS external_id_24,
  c1_.created_on AS created_on_25,
  c1_.city_id AS city_id_26,
  c1_.email AS email_27,
  c1_.password AS password_28,
  c1_.accept_newsletter AS accept_newsletter_29,
  c1_.transition_id AS transition_id_30,
  c1_.first_name AS first_name_31,
  c1_.last_name AS last_name_32,
  c1_.phone AS phone_33,
  c1_.status AS status_34,
  c1_.balance AS balance_35,
  c1_.registered_from_utm_source AS registered_from_utm_source_36,
  c1_.token AS token_37,
  c1_.totally_unsubscribed AS totally_unsubscribed_38,
  c1_.seen_microphone_tooltip AS seen_microphone_tooltip_39,
  c1_.not_show_rate_popup_till AS not_show_rate_popup_till_40,
  c1_.geo_location_accepted AS geo_location_accepted_41,
  c1_.geo_location AS geo_location_42,
  c1_.telegram_id AS telegram_id_43,
  c1_.site_id AS site_id_44,
  c1_.manager_name AS manager_name_45,
  c1_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_46,
  c1_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_47,
  c1_.dob AS dob_48,
  c1_.batch_codes_count AS batch_codes_count_49,
  c1_.virtual_wallet_amount AS virtual_wallet_amount_50,
  c1_.virtual_wallet_cashback AS virtual_wallet_cashback_51,
  c1_.money_balance AS money_balance_52,
  c1_.security_code AS security_code_53,
  c1_.id AS id_54,
  c0_.parent_id AS parent_id_55,
  c0_.user_id AS user_id_56,
  c0_.operator_id AS operator_id_57,
  c1_.city_id AS city_id_58
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 680

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_.voice_path AS voice_path_20, c0_.phone AS phone_21, c0_.transcription AS transcription_22, c0_.id AS id_23, c1_.external_id AS external_id_24, c1_.created_on AS created_on_25, c1_.city_id AS city_id_26, c1_.email AS email_27, c1_.password AS password_28, c1_.accept_newsletter AS accept_newsletter_29, c1_.transition_id AS transition_id_30, c1_.first_name AS first_name_31, c1_.last_name AS last_name_32, c1_.phone AS phone_33, c1_.status AS status_34, c1_.balance AS balance_35, c1_.registered_from_utm_source AS registered_from_utm_source_36, c1_.token AS token_37, c1_.totally_unsubscribed AS totally_unsubscribed_38, c1_.seen_microphone_tooltip AS seen_microphone_tooltip_39, c1_.not_show_rate_popup_till AS not_show_rate_popup_till_40, c1_.geo_location_accepted AS geo_location_accepted_41, c1_.geo_location AS geo_location_42, c1_.telegram_id AS telegram_id_43, c1_.site_id AS site_id_44, c1_.manager_name AS manager_name_45, c1_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_46, c1_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_47, c1_.dob AS dob_48, c1_.batch_codes_count AS batch_codes_count_49, c1_.virtual_wallet_amount AS virtual_wallet_amount_50, c1_.virtual_wallet_cashback AS virtual_wallet_cashback_51, c1_.money_balance AS money_balance_52, c1_.security_code AS security_code_53, c1_.id AS id_54, c0_.parent_id AS parent_id_55, c0_.user_id AS user_id_56, c0_.operator_id AS operator_id_57, c1_.city_id AS city_id_58 FROM comment c0_ INNER JOIN customer c1_ ON c0_.user_id = c1_.id WHERE c0_.entity_id = 139615 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 680;

SELECT
  count(c0_.id) AS sclr_0
FROM
  comment c0_
WHERE
  c0_.entity_id = ?
  AND c0_.type_id = ?
  AND c0_.confirmed_phone = true
  AND c0_.hidden <> true
  AND (
    c0_.deleted <> true
    OR c0_.deleted IS NULL
  )

SELECT count(c0_.id) AS sclr_0 FROM comment c0_ WHERE c0_.entity_id = 139615 AND c0_.type_id = 1 AND c0_.confirmed_phone = true AND c0_.hidden <> true AND (c0_.deleted <> true OR c0_.deleted IS NULL);

select
  count(*) as amount
from
  comment
where
  type_id = 1
  and entity_id = 139615
  and confirmed_phone
  and not hidden

select count(*) as amount from comment where type_id=1 and entity_id=139615 and confirmed_phone and not hidden;

SELECT
  t0.name AS name_1,
  t0.domain AS domain_2,
  t0.name_genitive AS name_genitive_3,
  t0.name_locative AS name_locative_4,
  t0.active AS active_5,
  t0.position AS position_6,
  t0.google_analytics AS google_analytics_7,
  ST_AsEWKT(t0.point : :geometry) AS point_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10
FROM
  city t0
  INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id
WHERE
  branding_banner_city.banner_id = ?

SELECT t0.name AS name_1, t0.domain AS domain_2, t0.name_genitive AS name_genitive_3, t0.name_locative AS name_locative_4, t0.active AS active_5, t0.position AS position_6, t0.google_analytics AS google_analytics_7, ST_AsEWKT(t0.point::geometry) AS point_8, t0.id AS id_9, t0.parent_id AS parent_id_10 FROM city t0 INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id WHERE branding_banner_city.banner_id = 775;

SELECT
  count(distinct fo.user_id)
FROM
  favourite_offer fo
WHERE
  fo.offer_id = :offerId

SELECT count(distinct fo.user_id) FROM favourite_offer fo WHERE fo.offer_id = 139615;

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.voice_path AS voice_path_21,
  t0.phone AS phone_22,
  t0.transcription AS transcription_23,
  t0.id AS id_24,
  t0.parent_id AS parent_id_25,
  t0.user_id AS user_id_26,
  t0.operator_id AS operator_id_27
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.voice_path AS voice_path_21, t0.phone AS phone_22, t0.transcription AS transcription_23, t0.id AS id_24, t0.parent_id AS parent_id_25, t0.user_id AS user_id_26, t0.operator_id AS operator_id_27 FROM comment t0 WHERE t0.parent_id = 661911 ORDER BY t0.id 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.tags AS tags_10,
  t0.id AS id_11,
  t0.entity_id AS entity_id_12,
  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.tags AS tags_10, t0.id AS id_11, t0.entity_id AS entity_id_12, t0.type FROM media t0 WHERE t0.entity_id = 661911 AND t0.type IN ('18079') ORDER BY t0.sort_order ASC;

SELECT
  t0.comment_id AS comment_id_1,
  t0.user_id AS user_id_2,
  t0.vote AS vote_3,
  t0.id AS id_4,
  t0.comment_id AS comment_id_5
FROM
  comment_like t0
WHERE
  t0.comment_id = ?

SELECT t0.comment_id AS comment_id_1, t0.user_id AS user_id_2, t0.vote AS vote_3, t0.id AS id_4, t0.comment_id AS comment_id_5 FROM comment_like t0 WHERE t0.comment_id = 661911;

SELECT
  t0.external_id AS external_id_1,
  t0.created_on AS created_on_2,
  t0.city_id AS city_id_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.accept_newsletter AS accept_newsletter_6,
  t0.transition_id AS transition_id_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.phone AS phone_10,
  t0.status AS status_11,
  t0.balance AS balance_12,
  t0.registered_from_utm_source AS registered_from_utm_source_13,
  t0.token AS token_14,
  t0.totally_unsubscribed AS totally_unsubscribed_15,
  t0.seen_microphone_tooltip AS seen_microphone_tooltip_16,
  t0.not_show_rate_popup_till AS not_show_rate_popup_till_17,
  t0.geo_location_accepted AS geo_location_accepted_18,
  t0.geo_location AS geo_location_19,
  t0.telegram_id AS telegram_id_20,
  t0.site_id AS site_id_21,
  t0.manager_name AS manager_name_22,
  t0.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_23,
  t0.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_24,
  t0.dob AS dob_25,
  t0.batch_codes_count AS batch_codes_count_26,
  t0.virtual_wallet_amount AS virtual_wallet_amount_27,
  t0.virtual_wallet_cashback AS virtual_wallet_cashback_28,
  t0.money_balance AS money_balance_29,
  t0.security_code AS security_code_30,
  t0.id AS id_31,
  t32.created_on AS created_on_33,
  t32.email AS email_34,
  t32.status AS status_35,
  t32.id AS id_36,
  t32.referral_id AS referral_id_37,
  t32.user_balance_activity_id AS user_balance_activity_id_38,
  t32.referer_id AS referer_id_39,
  t0.city_id AS city_id_40
FROM
  customer t0
  LEFT JOIN referral t32 ON t32.referral_id = t0.id
WHERE
  t0.id = ?

SELECT t0.external_id AS external_id_1, t0.created_on AS created_on_2, t0.city_id AS city_id_3, t0.email AS email_4, t0.password AS password_5, t0.accept_newsletter AS accept_newsletter_6, t0.transition_id AS transition_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.status AS status_11, t0.balance AS balance_12, t0.registered_from_utm_source AS registered_from_utm_source_13, t0.token AS token_14, t0.totally_unsubscribed AS totally_unsubscribed_15, t0.seen_microphone_tooltip AS seen_microphone_tooltip_16, t0.not_show_rate_popup_till AS not_show_rate_popup_till_17, t0.geo_location_accepted AS geo_location_accepted_18, t0.geo_location AS geo_location_19, t0.telegram_id AS telegram_id_20, t0.site_id AS site_id_21, t0.manager_name AS manager_name_22, t0.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_23, t0.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_24, t0.dob AS dob_25, t0.batch_codes_count AS batch_codes_count_26, t0.virtual_wallet_amount AS virtual_wallet_amount_27, t0.virtual_wallet_cashback AS virtual_wallet_cashback_28, t0.money_balance AS money_balance_29, t0.security_code AS security_code_30, t0.id AS id_31, t32.created_on AS created_on_33, t32.email AS email_34, t32.status AS status_35, t32.id AS id_36, t32.referral_id AS referral_id_37, t32.user_balance_activity_id AS user_balance_activity_id_38, t32.referer_id AS referer_id_39, t0.city_id AS city_id_40 FROM customer t0 LEFT JOIN referral t32 ON t32.referral_id = t0.id WHERE t0.id = 265552;

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 = 139615 AND v0_.entity_type_id = 1 AND v0_.created_on > '2025-07-08 09:01:39' AND v0_.created_on > '2016-02-09 00:00:00';

select
  get_visit_count(1, 139615, 30)

select get_visit_count(1, 139615, 30);

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

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

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.tags AS tags_10,
  t0.id AS id_11,
  t0.entity_id AS entity_id_12,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type IN ('18083')

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.tags AS tags_10, t0.id AS id_11, t0.entity_id AS entity_id_12, t0.type FROM media t0 WHERE t0.entity_id = 1580641 AND t0.type IN ('18083');

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
WHERE
  t0.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 WHERE t0.id = 476 AND t0.type IN ('0');

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.partner_online_registration_link AS partner_online_registration_link_119,
  t41.partner_online_registration_allowed AS partner_online_registration_allowed_120,
  t41.allowed_payment_methods_for_certificate AS allowed_payment_methods_for_certificate_121,
  t41.messenger_callback AS messenger_callback_122,
  t41.allowed_online_order_types AS allowed_online_order_types_123,
  t41.title_font_color AS title_font_color_124,
  t41.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_125,
  t41.map_price AS map_price_126,
  t41.map_rating AS map_rating_127,
  t41.yclient_app_key AS yclient_app_key_128,
  t41.yclient_company_id AS yclient_company_id_129,
  t41.fest_offer AS fest_offer_130,
  t41.review AS review_131,
  t41.on_review AS on_review_132,
  t41.id AS id_133,
  t41.bank_currency_id AS bank_currency_id_134,
  t41.manager_id AS manager_id_135,
  t41.creator_id AS creator_id_136,
  t41.default_city_id AS default_city_id_137,
  t0.user_id AS user_id_138,
  t0.operator_id AS operator_id_139,
  t0.type,
  t0.parameter_varchar_0 AS parameter_varchar_0_140,
  t0.parameter_int_0 AS parameter_int_0_141,
  t0.delivery_status AS delivery_status_142,
  t0.parameter_int_0 AS parameter_int_0_143,
  t0.parameter_int_0 AS parameter_int_0_144,
  t0.parameter_int_0 AS parameter_int_0_145
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', '8')
ORDER BY
  t0.created_on DESC