Symfony Profiler

SELECT
  t0.geo_location_id AS geo_location_id_1,
  t0.schedule_date AS schedule_date_2,
  t0.schedule_time AS schedule_time_3,
  t0.phone AS phone_4,
  t0.name AS name_5,
  t0.id AS id_6,
  t0.order_details_id AS order_details_id_7
FROM
  tire_schedule t0
WHERE
  t0.order_details_id = ?

SELECT t0.geo_location_id AS geo_location_id_1, t0.schedule_date AS schedule_date_2, t0.schedule_time AS schedule_time_3, t0.phone AS phone_4, t0.name AS name_5, t0.id AS id_6, t0.order_details_id AS order_details_id_7 FROM tire_schedule t0 WHERE t0.order_details_id = 23523609;

SELECT
  t0.canvas_data AS canvas_data_1,
  t0.description AS description_2,
  t0.title AS title_3,
  t0.image AS image_4,
  t0.preview_image_path AS preview_image_path_5,
  t0.preview_image_saved AS preview_image_saved_6,
  t0.description_font_color AS description_font_color_7,
  t0.description_font_family AS description_font_family_8,
  t0.title_font_color AS title_font_color_9,
  t0.title_font_family AS title_font_family_10,
  t0.certificate_code AS certificate_code_11,
  t0.id AS id_12,
  t0.order_details_id AS order_details_id_13
FROM
  gift_certificate_data t0
WHERE
  t0.order_details_id = ?

SELECT t0.canvas_data AS canvas_data_1, t0.description AS description_2, t0.title AS title_3, t0.image AS image_4, t0.preview_image_path AS preview_image_path_5, t0.preview_image_saved AS preview_image_saved_6, t0.description_font_color AS description_font_color_7, t0.description_font_family AS description_font_family_8, t0.title_font_color AS title_font_color_9, t0.title_font_family AS title_font_family_10, t0.certificate_code AS certificate_code_11, t0.id AS id_12, t0.order_details_id AS order_details_id_13 FROM gift_certificate_data t0 WHERE t0.order_details_id = 23523609;

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

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

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.transition_id AS transition_id_3,
  t0.hidden AS hidden_4,
  t0.id AS id_5
FROM
  user_group t0
  INNER JOIN user2group ON t0.id = user2group.group_id
WHERE
  user2group.user_id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.transition_id AS transition_id_3, t0.hidden AS hidden_4, t0.id AS id_5 FROM user_group t0 INNER JOIN user2group ON t0.id = user2group.group_id WHERE user2group.user_id = 2274921;

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

SELECT t0.domain_object_id AS domain_object_id_1, t0.name AS name_2, t0.email AS email_3, t0.legal_email AS legal_email_4, t0.legal_entity AS legal_entity_5, t0.tax_id AS tax_id_6, t0.receive_letters AS receive_letters_7, t0.transition_id AS transition_id_8, t0.teaser_logo_width AS teaser_logo_width_9, t0.teaser_logo_height AS teaser_logo_height_10, t0.status AS status_11, t0.punished AS punished_12, t0.last_code_number AS last_code_number_13, t0.about AS about_14, t0.created_on AS created_on_15, t0.modified_on AS modified_on_16, t0.extra_emails AS extra_emails_17, t0.phone_number AS phone_number_18, t0.site AS site_19, t0.legal_address AS legal_address_20, t0.account_number AS account_number_21, t0.tax_registration_date AS tax_registration_date_22, t0.trade_registration_date AS trade_registration_date_23, t0.registration_authority AS registration_authority_24, t0.working_hours AS working_hours_25, t0.footer_info AS footer_info_26, t0.company_link AS company_link_27, t0.id AS id_28, t0.page_offer_id AS page_offer_id_29, t0.manager_id AS manager_id_30 FROM director t0 INNER JOIN offer2director ON t0.id = offer2director.director_id WHERE offer2director.offer_id = 243440 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.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 = 243440 AND t0.type IN ('10') ORDER BY t0.id DESC;

SELECT
  o0_.offer_order_id AS offer_order_id_0,
  o0_.offer_code_pool_id AS offer_code_pool_id_1,
  o0_.created_on AS created_on_2,
  o0_.code AS code_3,
  o0_.used AS used_4,
  o0_.marked_used_by_supplier AS marked_used_by_supplier_5,
  o0_.marked_used_by_supplier_checktime AS marked_used_by_supplier_checktime_6,
  o0_.supplier_comment AS supplier_comment_7,
  o0_.monthly_bonus_credited AS monthly_bonus_credited_8,
  o0_.code_active_till AS code_active_till_9,
  o0_.supplier_revert_reason AS supplier_revert_reason_10,
  o0_.uniq_id AS uniq_id_11,
  o0_.items_count AS items_count_12,
  o0_.purchase_price AS purchase_price_13,
  o0_.id AS id_14,
  o1_.user_id AS user_id_15,
  o1_.operator_id AS operator_id_16,
  o1_.created_on AS created_on_17,
  o1_.paid_at AS paid_at_18,
  o1_.status AS status_19,
  o1_.amount AS amount_20,
  o1_.codes_count AS codes_count_21,
  o1_.code_cost AS code_cost_22,
  o1_.number AS number_23,
  o1_.seen_by_user AS seen_by_user_24,
  o1_.sent_to_supplier AS sent_to_supplier_25,
  o1_.utm_source AS utm_source_26,
  o1_.transition_id AS transition_id_27,
  o1_.device_type AS device_type_28,
  o1_.cookie_period AS cookie_period_29,
  o1_.payment_method_id AS payment_method_id_30,
  o1_.utm_data AS utm_data_31,
  o1_.comment AS comment_32,
  o1_.delivery_time AS delivery_time_33,
  o1_.delivery_cost AS delivery_cost_34,
  o1_.expired_on AS expired_on_35,
  o1_.offer_id AS offer_id_36,
  o1_.city_id AS city_id_37,
  o1_.subscription_plan_user_relation_id AS subscription_plan_user_relation_id_38,
  o1_.external_id AS external_id_39,
  o1_.is_food_court AS is_food_court_40,
  o1_.additional_info AS additional_info_41,
  o1_.username AS username_42,
  o1_.user_phone AS user_phone_43,
  o1_.subscription_period_start_at AS subscription_period_start_at_44,
  o1_.delivery_zone_location_id AS delivery_zone_location_id_45,
  o1_.is_online_gift AS is_online_gift_46,
  o1_.use_partner_cashback_balance AS use_partner_cashback_balance_47,
  o1_.used_partner_cashback_sum AS used_partner_cashback_sum_48,
  o1_.use_fast_delivery AS use_fast_delivery_49,
  o1_.id AS id_50,
  o1_.parameter_varchar_0 AS parameter_varchar_0_51,
  o1_.parameter_int_0 AS parameter_int_0_52,
  o1_.delivery_status AS delivery_status_53,
  o1_.parameter_int_0 AS parameter_int_0_54,
  o2_.title AS title_55,
  o2_.me_on_map_name AS me_on_map_name_56,
  o2_.explanation_text AS explanation_text_57,
  o2_.price AS price_58,
  o2_.old_price AS old_price_59,
  o2_.regular_price AS regular_price_60,
  o2_.offer_price AS offer_price_61,
  o2_.discount AS discount_62,
  o2_.active_since AS active_since_63,
  o2_.active_till AS active_till_64,
  o2_.code_active_till AS code_active_till_65,
  o2_.active AS active_66,
  o2_.hidden AS hidden_67,
  o2_.free AS free_68,
  o2_.without_codes AS without_codes_69,
  o2_.online_order_allowed AS online_order_allowed_70,
  o2_.buy_code_disable AS buy_code_disable_71,
  o2_.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_72,
  o2_.online_order_allowed_removed_at AS online_order_allowed_removed_at_73,
  o2_.show_price_in_conditions AS show_price_in_conditions_74,
  o2_.show_alt_offers AS show_alt_offers_75,
  o2_.show_currencies AS show_currencies_76,
  o2_.additional_percents AS additional_percents_77,
  o2_.address AS address_78,
  o2_.caption_name AS caption_name_79,
  o2_.caption_color AS caption_color_80,
  o2_.regional_caption_name AS regional_caption_name_81,
  o2_.regional_caption_color AS regional_caption_color_82,
  o2_.search_position AS search_position_83,
  o2_.active_search_position AS active_search_position_84,
  o2_.hint AS hint_85,
  o2_.bank_currency_id AS bank_currency_id_86,
  o2_.active_currency_calculator AS active_currency_calculator_87,
  o2_.last_modified AS last_modified_88,
  o2_.teaser_logo_width AS teaser_logo_width_89,
  o2_.teaser_logo_height AS teaser_logo_height_90,
  o2_.lucene_reindex AS lucene_reindex_91,
  o2_.code_cost AS code_cost_92,
  o2_.code_cost_by_count AS code_cost_by_count_93,
  o2_.default_category_id AS default_category_id_94,
  o2_.company_name AS company_name_95,
  o2_.renewed_on AS renewed_on_96,
  o2_.hide_novelty_label AS hide_novelty_label_97,
  o2_.hide_banners_in_comments AS hide_banners_in_comments_98,
  o2_.sum_for_free_delivery AS sum_for_free_delivery_99,
  o2_.delivery_price AS delivery_price_100,
  o2_.created_on AS created_on_101,
  o2_.allowed_buy_only_code AS allowed_buy_only_code_102,
  o2_.buy_code_button_text AS buy_code_button_text_103,
  o2_.buy_items_button_text AS buy_items_button_text_104,
  o2_.purchase_koeff AS purchase_koeff_105,
  o2_.telegram_bot_show AS telegram_bot_show_106,
  o2_.telegram_bot_position AS telegram_bot_position_107,
  o2_.version AS version_108,
  o2_.hide_in_app AS hide_in_app_109,
  o2_.brandbox_enabled AS brandbox_enabled_110,
  o2_.hide_features AS hide_features_111,
  o2_.discount_delivery_popup AS discount_delivery_popup_112,
  o2_.discount_pickup_popup AS discount_pickup_popup_113,
  o2_.delivery_time_teaser AS delivery_time_teaser_114,
  o2_.external_offer_link AS external_offer_link_115,
  o2_.is_show_external_offer_link AS is_show_external_offer_link_116,
  o2_.is_included_in_beauty AS is_included_in_beauty_117,
  o2_.qr_codes AS qr_codes_118,
  o2_.recurrent_disabled AS recurrent_disabled_119,
  o2_.available_on_food AS available_on_food_120,
  o2_.online_auto_opened AS online_auto_opened_121,
  o2_.foodcourt_logo_enabled AS foodcourt_logo_enabled_122,
  o2_.rating AS rating_123,
  o2_.foodcourt_info_teaser AS foodcourt_info_teaser_124,
  o2_.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_125,
  o2_.online_order_gift_enabled AS online_order_gift_enabled_126,
  o2_.buy_code_in_app_only AS buy_code_in_app_only_127,
  o2_.show_products_in_offer_description AS show_products_in_offer_description_128,
  o2_.check_address_in_offer_menu AS check_address_in_offer_menu_129,
  o2_.show_map_icon_in_app AS show_map_icon_in_app_130,
  o2_.viber AS viber_131,
  o2_.telegram AS telegram_132,
  o2_.messenger_callback AS messenger_callback_133,
  o2_.allowed_online_order_types AS allowed_online_order_types_134,
  o2_.title_font_color AS title_font_color_135,
  o2_.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_136,
  o2_.map_price AS map_price_137,
  o2_.map_rating AS map_rating_138,
  o2_.review AS review_139,
  o2_.on_review AS on_review_140,
  o2_.id AS id_141,
  o0_.offer_extension_id AS offer_extension_id_142,
  o0_.offer_extension_variant_id AS offer_extension_variant_id_143,
  o0_.gift_certificate_id AS gift_certificate_id_144,
  o0_.offer_order_id AS offer_order_id_145,
  o0_.offer_code_pool_id AS offer_code_pool_id_146,
  o0_.operator_id AS operator_id_147,
  o0_.supplier_id AS supplier_id_148,
  o1_.type AS type_149,
  o1_.booking_id AS booking_id_150,
  o1_.delivery_address_id AS delivery_address_id_151,
  o1_.offer_id AS offer_id_152,
  o1_.user_id AS user_id_153,
  o1_.operator_id AS operator_id_154,
  o1_.parameter_int_0 AS parameter_int_0_155,
  o1_.parameter_int_0 AS parameter_int_0_156,
  o2_.bank_currency_id AS bank_currency_id_157,
  o2_.manager_id AS manager_id_158,
  o2_.creator_id AS creator_id_159,
  o2_.default_city_id AS default_city_id_160
FROM
  offer_order_details o0_
  INNER JOIN offer_order o1_ ON o0_.offer_order_id = o1_.id
  AND o1_.type IN ('0', '3', '4', '5', '6', '7')
  INNER JOIN offer o2_ ON o1_.offer_id = o2_.id
WHERE
  o1_.user_id = ?
  AND o1_.type IN ('3', '4', '5', '6', '7', '0')
  AND NOT o1_.type IN ('4')
  AND NOT o1_.type IN ('6')
  AND NOT o1_.type IN ('5')
  AND NOT o1_.type IN ('3')
ORDER BY
  o0_.id DESC
LIMIT
  11 OFFSET 20

SELECT o0_.offer_order_id AS offer_order_id_0, o0_.offer_code_pool_id AS offer_code_pool_id_1, o0_.created_on AS created_on_2, o0_.code AS code_3, o0_.used AS used_4, o0_.marked_used_by_supplier AS marked_used_by_supplier_5, o0_.marked_used_by_supplier_checktime AS marked_used_by_supplier_checktime_6, o0_.supplier_comment AS supplier_comment_7, o0_.monthly_bonus_credited AS monthly_bonus_credited_8, o0_.code_active_till AS code_active_till_9, o0_.supplier_revert_reason AS supplier_revert_reason_10, o0_.uniq_id AS uniq_id_11, o0_.items_count AS items_count_12, o0_.purchase_price AS purchase_price_13, o0_.id AS id_14, o1_.user_id AS user_id_15, o1_.operator_id AS operator_id_16, o1_.created_on AS created_on_17, o1_.paid_at AS paid_at_18, o1_.status AS status_19, o1_.amount AS amount_20, o1_.codes_count AS codes_count_21, o1_.code_cost AS code_cost_22, o1_.number AS number_23, o1_.seen_by_user AS seen_by_user_24, o1_.sent_to_supplier AS sent_to_supplier_25, o1_.utm_source AS utm_source_26, o1_.transition_id AS transition_id_27, o1_.device_type AS device_type_28, o1_.cookie_period AS cookie_period_29, o1_.payment_method_id AS payment_method_id_30, o1_.utm_data AS utm_data_31, o1_.comment AS comment_32, o1_.delivery_time AS delivery_time_33, o1_.delivery_cost AS delivery_cost_34, o1_.expired_on AS expired_on_35, o1_.offer_id AS offer_id_36, o1_.city_id AS city_id_37, o1_.subscription_plan_user_relation_id AS subscription_plan_user_relation_id_38, o1_.external_id AS external_id_39, o1_.is_food_court AS is_food_court_40, o1_.additional_info AS additional_info_41, o1_.username AS username_42, o1_.user_phone AS user_phone_43, o1_.subscription_period_start_at AS subscription_period_start_at_44, o1_.delivery_zone_location_id AS delivery_zone_location_id_45, o1_.is_online_gift AS is_online_gift_46, o1_.use_partner_cashback_balance AS use_partner_cashback_balance_47, o1_.used_partner_cashback_sum AS used_partner_cashback_sum_48, o1_.use_fast_delivery AS use_fast_delivery_49, o1_.id AS id_50, o1_.parameter_varchar_0 AS parameter_varchar_0_51, o1_.parameter_int_0 AS parameter_int_0_52, o1_.delivery_status AS delivery_status_53, o1_.parameter_int_0 AS parameter_int_0_54, o2_.title AS title_55, o2_.me_on_map_name AS me_on_map_name_56, o2_.explanation_text AS explanation_text_57, o2_.price AS price_58, o2_.old_price AS old_price_59, o2_.regular_price AS regular_price_60, o2_.offer_price AS offer_price_61, o2_.discount AS discount_62, o2_.active_since AS active_since_63, o2_.active_till AS active_till_64, o2_.code_active_till AS code_active_till_65, o2_.active AS active_66, o2_.hidden AS hidden_67, o2_.free AS free_68, o2_.without_codes AS without_codes_69, o2_.online_order_allowed AS online_order_allowed_70, o2_.buy_code_disable AS buy_code_disable_71, o2_.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_72, o2_.online_order_allowed_removed_at AS online_order_allowed_removed_at_73, o2_.show_price_in_conditions AS show_price_in_conditions_74, o2_.show_alt_offers AS show_alt_offers_75, o2_.show_currencies AS show_currencies_76, o2_.additional_percents AS additional_percents_77, o2_.address AS address_78, o2_.caption_name AS caption_name_79, o2_.caption_color AS caption_color_80, o2_.regional_caption_name AS regional_caption_name_81, o2_.regional_caption_color AS regional_caption_color_82, o2_.search_position AS search_position_83, o2_.active_search_position AS active_search_position_84, o2_.hint AS hint_85, o2_.bank_currency_id AS bank_currency_id_86, o2_.active_currency_calculator AS active_currency_calculator_87, o2_.last_modified AS last_modified_88, o2_.teaser_logo_width AS teaser_logo_width_89, o2_.teaser_logo_height AS teaser_logo_height_90, o2_.lucene_reindex AS lucene_reindex_91, o2_.code_cost AS code_cost_92, o2_.code_cost_by_count AS code_cost_by_count_93, o2_.default_category_id AS default_category_id_94, o2_.company_name AS company_name_95, o2_.renewed_on AS renewed_on_96, o2_.hide_novelty_label AS hide_novelty_label_97, o2_.hide_banners_in_comments AS hide_banners_in_comments_98, o2_.sum_for_free_delivery AS sum_for_free_delivery_99, o2_.delivery_price AS delivery_price_100, o2_.created_on AS created_on_101, o2_.allowed_buy_only_code AS allowed_buy_only_code_102, o2_.buy_code_button_text AS buy_code_button_text_103, o2_.buy_items_button_text AS buy_items_button_text_104, o2_.purchase_koeff AS purchase_koeff_105, o2_.telegram_bot_show AS telegram_bot_show_106, o2_.telegram_bot_position AS telegram_bot_position_107, o2_.version AS version_108, o2_.hide_in_app AS hide_in_app_109, o2_.brandbox_enabled AS brandbox_enabled_110, o2_.hide_features AS hide_features_111, o2_.discount_delivery_popup AS discount_delivery_popup_112, o2_.discount_pickup_popup AS discount_pickup_popup_113, o2_.delivery_time_teaser AS delivery_time_teaser_114, o2_.external_offer_link AS external_offer_link_115, o2_.is_show_external_offer_link AS is_show_external_offer_link_116, o2_.is_included_in_beauty AS is_included_in_beauty_117, o2_.qr_codes AS qr_codes_118, o2_.recurrent_disabled AS recurrent_disabled_119, o2_.available_on_food AS available_on_food_120, o2_.online_auto_opened AS online_auto_opened_121, o2_.foodcourt_logo_enabled AS foodcourt_logo_enabled_122, o2_.rating AS rating_123, o2_.foodcourt_info_teaser AS foodcourt_info_teaser_124, o2_.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_125, o2_.online_order_gift_enabled AS online_order_gift_enabled_126, o2_.buy_code_in_app_only AS buy_code_in_app_only_127, o2_.show_products_in_offer_description AS show_products_in_offer_description_128, o2_.check_address_in_offer_menu AS check_address_in_offer_menu_129, o2_.show_map_icon_in_app AS show_map_icon_in_app_130, o2_.viber AS viber_131, o2_.telegram AS telegram_132, o2_.messenger_callback AS messenger_callback_133, o2_.allowed_online_order_types AS allowed_online_order_types_134, o2_.title_font_color AS title_font_color_135, o2_.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_136, o2_.map_price AS map_price_137, o2_.map_rating AS map_rating_138, o2_.review AS review_139, o2_.on_review AS on_review_140, o2_.id AS id_141, o0_.offer_extension_id AS offer_extension_id_142, o0_.offer_extension_variant_id AS offer_extension_variant_id_143, o0_.gift_certificate_id AS gift_certificate_id_144, o0_.offer_order_id AS offer_order_id_145, o0_.offer_code_pool_id AS offer_code_pool_id_146, o0_.operator_id AS operator_id_147, o0_.supplier_id AS supplier_id_148, o1_.type AS type_149, o1_.booking_id AS booking_id_150, o1_.delivery_address_id AS delivery_address_id_151, o1_.offer_id AS offer_id_152, o1_.user_id AS user_id_153, o1_.operator_id AS operator_id_154, o1_.parameter_int_0 AS parameter_int_0_155, o1_.parameter_int_0 AS parameter_int_0_156, o2_.bank_currency_id AS bank_currency_id_157, o2_.manager_id AS manager_id_158, o2_.creator_id AS creator_id_159, o2_.default_city_id AS default_city_id_160 FROM offer_order_details o0_ INNER JOIN offer_order o1_ ON o0_.offer_order_id = o1_.id AND o1_.type IN ('0', '3', '4', '5', '6', '7') INNER JOIN offer o2_ ON o1_.offer_id = o2_.id WHERE o1_.user_id = 2274921 AND o1_.type IN ('3', '4', '5', '6', '7', '0') AND NOT o1_.type IN ('4') AND NOT o1_.type IN ('6') AND NOT o1_.type IN ('5') AND NOT o1_.type IN ('3') ORDER BY o0_.id DESC LIMIT 11 OFFSET 20;

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 = 243440 AND t0.type IN ('0', '1', '2', '3');

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 = 602040;

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 = 2274921;

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.city_id AS city_id_34,
  t0.type_id AS type_id_35,
  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.hide_work_examples AS hide_work_examples_33, t0.city_id AS city_id_34, t0.type_id AS type_id_35, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = 297223 AND t0.type IN ('0');

SELECT
  c0_.external_id AS external_id_0,
  c0_.created_on AS created_on_1,
  c0_.city_id AS city_id_2,
  c0_.email AS email_3,
  c0_.password AS password_4,
  c0_.accept_newsletter AS accept_newsletter_5,
  c0_.transition_id AS transition_id_6,
  c0_.first_name AS first_name_7,
  c0_.last_name AS last_name_8,
  c0_.phone AS phone_9,
  c0_.status AS status_10,
  c0_.balance AS balance_11,
  c0_.registered_from_utm_source AS registered_from_utm_source_12,
  c0_.token AS token_13,
  c0_.totally_unsubscribed AS totally_unsubscribed_14,
  c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15,
  c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16,
  c0_.geo_location_accepted AS geo_location_accepted_17,
  c0_.geo_location AS geo_location_18,
  c0_.telegram_id AS telegram_id_19,
  c0_.site_id AS site_id_20,
  c0_.manager_name AS manager_name_21,
  c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22,
  c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23,
  c0_.batch_codes_count AS batch_codes_count_24,
  c0_.money_balance AS money_balance_25,
  c0_.id AS id_26,
  c0_.city_id AS city_id_27
FROM
  customer c0_
  INNER JOIN mobile_user_token m1_ ON (c0_.id = m1_.user_id)
WHERE
  m1_.token = ?

SELECT c0_.external_id AS external_id_0, c0_.created_on AS created_on_1, c0_.city_id AS city_id_2, c0_.email AS email_3, c0_.password AS password_4, c0_.accept_newsletter AS accept_newsletter_5, c0_.transition_id AS transition_id_6, c0_.first_name AS first_name_7, c0_.last_name AS last_name_8, c0_.phone AS phone_9, c0_.status AS status_10, c0_.balance AS balance_11, c0_.registered_from_utm_source AS registered_from_utm_source_12, c0_.token AS token_13, c0_.totally_unsubscribed AS totally_unsubscribed_14, c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15, c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16, c0_.geo_location_accepted AS geo_location_accepted_17, c0_.geo_location AS geo_location_18, c0_.telegram_id AS telegram_id_19, c0_.site_id AS site_id_20, c0_.manager_name AS manager_name_21, c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22, c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23, c0_.batch_codes_count AS batch_codes_count_24, c0_.money_balance AS money_balance_25, c0_.id AS id_26, c0_.city_id AS city_id_27 FROM customer c0_ INNER JOIN mobile_user_token m1_ ON (c0_.id = m1_.user_id) WHERE m1_.token = '7e7d5bda1e82833a17667bd8a51c207e';

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

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

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