Symfony Profiler

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

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/gift-certificate/select/286127' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

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

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

SELECT
  count(*)
FROM
  gift_certificate
WHERE
  (
    gift_certificate.active = :active
  )
  AND (
    gift_certificate.offer_id = :offerId
  )

SELECT count(*) FROM gift_certificate WHERE (gift_certificate.active = 1) AND (gift_certificate.offer_id = 286127);

select
  avg(rating) as rating,
  count(*) as amount
from
  comment
where
  created_on > date_trunc('day', now() + '-90 days'): :timestamp without time zone
  and type_id = 1
  and entity_id = 286127
  and rating > 0
  and confirmed_phone
  and not hidden

select avg(rating) as rating, count(*) as amount from comment where created_on > date_trunc('day', now() + '-90 days')::timestamp without time zone and type_id=1 and entity_id=286127 and rating > 0 and confirmed_phone and not hidden ;

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

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

select
  gift_certificate.id,
  sum(
    offer_order_details.items_count
  ) as cnt
from
  offer_order_details
  inner join offer_order on offer_order.id = offer_order_details.offer_order_id
  inner join gift_certificate on gift_certificate.id = offer_order_details.gift_certificate_id
where
  offer_order.status > 0
  and offer_order.type = 6
  and offer_order.offer_id = 286127
group by
  1
order by
  2 desc;

select gift_certificate.id, sum(offer_order_details.items_count) as cnt from offer_order_details
            inner join offer_order on offer_order.id = offer_order_details.offer_order_id
            inner join gift_certificate on gift_certificate.id = offer_order_details.gift_certificate_id
            where offer_order.status > 0 and offer_order.type = 6 and offer_order.offer_id = 286127 group by 1 order by 2 desc;;

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

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

SELECT
  t0.active AS active_1,
  t0.name AS name_2,
  t0.price_regular AS price_regular_3,
  t0.price_offer AS price_offer_4,
  t0.discount_percent AS discount_percent_5,
  t0.description AS description_6,
  t0.position AS position_7,
  t0.codes_per_item AS codes_per_item_8,
  t0.hidden AS hidden_9,
  t0.buy_only_code AS buy_only_code_10,
  t0.special123 AS special123_11,
  t0.active_days AS active_days_12,
  t0.purchase_count AS purchase_count_13,
  t0.position_beauty AS position_beauty_14,
  t0.price_partner_purchase AS price_partner_purchase_15,
  t0.code_suffix AS code_suffix_16,
  t0.bundle_promo_count AS bundle_promo_count_17,
  t0.multi_use_code_period AS multi_use_code_period_18,
  t0.multi_use_code_per_period AS multi_use_code_per_period_19,
  t0.is_subscription AS is_subscription_20,
  t0.id AS id_21,
  t0.offer_id AS offer_id_22
FROM
  gift_certificate t0
WHERE
  (
    (
      t0.active = ?
      AND t0.hidden = ?
    )
    AND t0.offer_id = ?
  )
ORDER BY
  t0.position ASC

SELECT t0.active AS active_1, t0.name AS name_2, t0.price_regular AS price_regular_3, t0.price_offer AS price_offer_4, t0.discount_percent AS discount_percent_5, t0.description AS description_6, t0.position AS position_7, t0.codes_per_item AS codes_per_item_8, t0.hidden AS hidden_9, t0.buy_only_code AS buy_only_code_10, t0.special123 AS special123_11, t0.active_days AS active_days_12, t0.purchase_count AS purchase_count_13, t0.position_beauty AS position_beauty_14, t0.price_partner_purchase AS price_partner_purchase_15, t0.code_suffix AS code_suffix_16, t0.bundle_promo_count AS bundle_promo_count_17, t0.multi_use_code_period AS multi_use_code_period_18, t0.multi_use_code_per_period AS multi_use_code_per_period_19, t0.is_subscription AS is_subscription_20, t0.id AS id_21, t0.offer_id AS offer_id_22 FROM gift_certificate t0 WHERE ((t0.active = 1 AND t0.hidden = 0) AND t0.offer_id = 286127) ORDER BY t0.position 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 ('3')

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 = 4438 AND t0.type IN ('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 = 731663;

SELECT
  t0.offer_id AS offer_id_1,
  t0.active AS active_2,
  t0.auto_addition_step AS auto_addition_step_3,
  t0.auto_addition_remainder AS auto_addition_remainder_4,
  t0.codes_reserved AS codes_reserved_5,
  t0.codes_free AS codes_free_6,
  t0.codes_used AS codes_used_7,
  t0.transition_id AS transition_id_8,
  t0.used_codes_count_fake AS used_codes_count_fake_9,
  t0.random_codes AS random_codes_10,
  t0.id AS id_11,
  t0.offer_id AS offer_id_12,
  t0.type
FROM
  offer_code_pool t0
WHERE
  t0.offer_id = ?
  AND t0.type IN ('2')

SELECT t0.offer_id AS offer_id_1, t0.active AS active_2, t0.auto_addition_step AS auto_addition_step_3, t0.auto_addition_remainder AS auto_addition_remainder_4, t0.codes_reserved AS codes_reserved_5, t0.codes_free AS codes_free_6, t0.codes_used AS codes_used_7, t0.transition_id AS transition_id_8, t0.used_codes_count_fake AS used_codes_count_fake_9, t0.random_codes AS random_codes_10, t0.id AS id_11, t0.offer_id AS offer_id_12, t0.type FROM offer_code_pool t0 WHERE t0.offer_id = 4438 AND t0.type IN ('2');

SELECT
  t0.description AS description_1,
  t0.city AS city_2,
  t0.street AS street_3,
  t0.house AS house_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  ST_AsEWKT(t0.point : :geometry) AS point_7,
  t0.label AS label_8,
  t0.working_hours AS working_hours_9,
  t0.big_map_marker AS big_map_marker_10,
  t0.schedule AS schedule_11,
  t0.schedule_modified_at AS schedule_modified_at_12,
  t0.id AS id_13,
  t0.sort_order AS sort_order_14,
  t0.pickup_point_partner_id AS pickup_point_partner_id_15,
  t0.pickup_point_bel_trans_sat_depot_id AS pickup_point_bel_trans_sat_depot_id_16,
  t0.pickup_point_schedule AS pickup_point_schedule_17,
  t0.active AS active_18,
  t0.bepaid_credentials AS bepaid_credentials_19,
  t0.callback_chat_id AS callback_chat_id_20,
  t0.city_area_id AS city_area_id_21,
  t0.type
FROM
  geo_location t0
  INNER JOIN gift_certificate_location_relation ON t0.id = gift_certificate_location_relation.location_id
WHERE
  gift_certificate_location_relation.entity_id = ?
  AND t0.type IN ('1')
ORDER BY
  t0.sort_order ASC

SELECT t0.description AS description_1, t0.city AS city_2, t0.street AS street_3, t0.house AS house_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, ST_AsEWKT(t0.point::geometry) AS point_7, t0.label AS label_8, t0.working_hours AS working_hours_9, t0.big_map_marker AS big_map_marker_10, t0.schedule AS schedule_11, t0.schedule_modified_at AS schedule_modified_at_12, t0.id AS id_13, t0.sort_order AS sort_order_14, t0.pickup_point_partner_id AS pickup_point_partner_id_15, t0.pickup_point_bel_trans_sat_depot_id AS pickup_point_bel_trans_sat_depot_id_16, t0.pickup_point_schedule AS pickup_point_schedule_17, t0.active AS active_18, t0.bepaid_credentials AS bepaid_credentials_19, t0.callback_chat_id AS callback_chat_id_20, t0.city_area_id AS city_area_id_21, t0.type FROM geo_location t0 INNER JOIN gift_certificate_location_relation ON t0.id = gift_certificate_location_relation.location_id WHERE gift_certificate_location_relation.entity_id = 4438 AND t0.type IN ('1') ORDER BY t0.sort_order ASC;

SELECT
  t0.tag AS tag_1,
  t0.id AS id_2
FROM
  gift_certificate_tag t0
  INNER JOIN giftCertificate2tag ON t0.id = giftCertificate2tag.tag_id
WHERE
  giftCertificate2tag.certificate_id = ?

SELECT t0.tag AS tag_1, t0.id AS id_2 FROM gift_certificate_tag t0 INNER JOIN giftCertificate2tag ON t0.id = giftCertificate2tag.tag_id WHERE giftCertificate2tag.certificate_id = 4438;

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 ('3')

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 = 4437 AND t0.type IN ('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 = 731672;

SELECT
  t0.offer_id AS offer_id_1,
  t0.active AS active_2,
  t0.auto_addition_step AS auto_addition_step_3,
  t0.auto_addition_remainder AS auto_addition_remainder_4,
  t0.codes_reserved AS codes_reserved_5,
  t0.codes_free AS codes_free_6,
  t0.codes_used AS codes_used_7,
  t0.transition_id AS transition_id_8,
  t0.used_codes_count_fake AS used_codes_count_fake_9,
  t0.random_codes AS random_codes_10,
  t0.id AS id_11,
  t0.offer_id AS offer_id_12,
  t0.type
FROM
  offer_code_pool t0
WHERE
  t0.offer_id = ?
  AND t0.type IN ('2')

SELECT t0.offer_id AS offer_id_1, t0.active AS active_2, t0.auto_addition_step AS auto_addition_step_3, t0.auto_addition_remainder AS auto_addition_remainder_4, t0.codes_reserved AS codes_reserved_5, t0.codes_free AS codes_free_6, t0.codes_used AS codes_used_7, t0.transition_id AS transition_id_8, t0.used_codes_count_fake AS used_codes_count_fake_9, t0.random_codes AS random_codes_10, t0.id AS id_11, t0.offer_id AS offer_id_12, t0.type FROM offer_code_pool t0 WHERE t0.offer_id = 4437 AND t0.type IN ('2');

SELECT
  t0.description AS description_1,
  t0.city AS city_2,
  t0.street AS street_3,
  t0.house AS house_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  ST_AsEWKT(t0.point : :geometry) AS point_7,
  t0.label AS label_8,
  t0.working_hours AS working_hours_9,
  t0.big_map_marker AS big_map_marker_10,
  t0.schedule AS schedule_11,
  t0.schedule_modified_at AS schedule_modified_at_12,
  t0.id AS id_13,
  t0.sort_order AS sort_order_14,
  t0.pickup_point_partner_id AS pickup_point_partner_id_15,
  t0.pickup_point_bel_trans_sat_depot_id AS pickup_point_bel_trans_sat_depot_id_16,
  t0.pickup_point_schedule AS pickup_point_schedule_17,
  t0.active AS active_18,
  t0.bepaid_credentials AS bepaid_credentials_19,
  t0.callback_chat_id AS callback_chat_id_20,
  t0.city_area_id AS city_area_id_21,
  t0.type
FROM
  geo_location t0
  INNER JOIN gift_certificate_location_relation ON t0.id = gift_certificate_location_relation.location_id
WHERE
  gift_certificate_location_relation.entity_id = ?
  AND t0.type IN ('1')
ORDER BY
  t0.sort_order ASC

SELECT t0.description AS description_1, t0.city AS city_2, t0.street AS street_3, t0.house AS house_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, ST_AsEWKT(t0.point::geometry) AS point_7, t0.label AS label_8, t0.working_hours AS working_hours_9, t0.big_map_marker AS big_map_marker_10, t0.schedule AS schedule_11, t0.schedule_modified_at AS schedule_modified_at_12, t0.id AS id_13, t0.sort_order AS sort_order_14, t0.pickup_point_partner_id AS pickup_point_partner_id_15, t0.pickup_point_bel_trans_sat_depot_id AS pickup_point_bel_trans_sat_depot_id_16, t0.pickup_point_schedule AS pickup_point_schedule_17, t0.active AS active_18, t0.bepaid_credentials AS bepaid_credentials_19, t0.callback_chat_id AS callback_chat_id_20, t0.city_area_id AS city_area_id_21, t0.type FROM geo_location t0 INNER JOIN gift_certificate_location_relation ON t0.id = gift_certificate_location_relation.location_id WHERE gift_certificate_location_relation.entity_id = 4437 AND t0.type IN ('1') ORDER BY t0.sort_order ASC;

SELECT
  t0.tag AS tag_1,
  t0.id AS id_2
FROM
  gift_certificate_tag t0
  INNER JOIN giftCertificate2tag ON t0.id = giftCertificate2tag.tag_id
WHERE
  giftCertificate2tag.certificate_id = ?

SELECT t0.tag AS tag_1, t0.id AS id_2 FROM gift_certificate_tag t0 INNER JOIN giftCertificate2tag ON t0.id = giftCertificate2tag.tag_id WHERE giftCertificate2tag.certificate_id = 4437;

SELECT
  p0_.last_modified AS last_modified_0,
  p0_.entity_id AS entity_id_1,
  p0_.purchase_count AS purchase_count_2,
  p0_.purchase_count_recent AS purchase_count_recent_3,
  p0_.purchase_count_last_month AS purchase_count_last_month_4,
  p0_.purchase_count_last_day AS purchase_count_last_day_5,
  p0_.purchase_count_last_month_with_correction AS purchase_count_last_month_with_correction_6,
  p0_.purchase_count_last_week_with_correction AS purchase_count_last_week_with_correction_7,
  p0_.purchase_count_last_day_with_correction AS purchase_count_last_day_with_correction_8,
  p0_.purchase_count_with_correction AS purchase_count_with_correction_9,
  p0_.id AS id_10
FROM
  purchase_count p0_
WHERE
  p0_.entity_id = ?

SELECT p0_.last_modified AS last_modified_0, p0_.entity_id AS entity_id_1, p0_.purchase_count AS purchase_count_2, p0_.purchase_count_recent AS purchase_count_recent_3, p0_.purchase_count_last_month AS purchase_count_last_month_4, p0_.purchase_count_last_day AS purchase_count_last_day_5, p0_.purchase_count_last_month_with_correction AS purchase_count_last_month_with_correction_6, p0_.purchase_count_last_week_with_correction AS purchase_count_last_week_with_correction_7, p0_.purchase_count_last_day_with_correction AS purchase_count_last_day_with_correction_8, p0_.purchase_count_with_correction AS purchase_count_with_correction_9, p0_.id AS id_10 FROM purchase_count p0_ WHERE p0_.entity_id = 286127;

select
  get_visit_count(1, 286127, 30)

select get_visit_count(1, 286127, 30);

SELECT
  t0.entity_id AS entity_id_1,
  t0.open AS open_2,
  t0.recommended AS recommended_3,
  t0.popular AS popular_4,
  t0.speed AS speed_5,
  t0.asc_price AS asc_price_6,
  t0.desc_price AS desc_price_7,
  t0.price_by_kg AS price_by_kg_8,
  t0.popular_day AS popular_day_9,
  t0.price_by_kg_desc AS price_by_kg_desc_10,
  t0.id AS id_11
FROM
  food_filter_counter t0
WHERE
  t0.entity_id = ?
LIMIT
  1

SELECT t0.entity_id AS entity_id_1, t0.open AS open_2, t0.recommended AS recommended_3, t0.popular AS popular_4, t0.speed AS speed_5, t0.asc_price AS asc_price_6, t0.desc_price AS desc_price_7, t0.price_by_kg AS price_by_kg_8, t0.popular_day AS popular_day_9, t0.price_by_kg_desc AS price_by_kg_desc_10, t0.id AS id_11 FROM food_filter_counter t0 WHERE t0.entity_id = '286127' LIMIT 1;

SELECT
  d0_.domain_object_id AS domain_object_id_0,
  d0_.name AS name_1,
  d0_.email AS email_2,
  d0_.legal_email AS legal_email_3,
  d0_.legal_entity AS legal_entity_4,
  d0_.tax_id AS tax_id_5,
  d0_.receive_letters AS receive_letters_6,
  d0_.transition_id AS transition_id_7,
  d0_.teaser_logo_width AS teaser_logo_width_8,
  d0_.teaser_logo_height AS teaser_logo_height_9,
  d0_.status AS status_10,
  d0_.punished AS punished_11,
  d0_.last_code_number AS last_code_number_12,
  d0_.about AS about_13,
  d0_.created_on AS created_on_14,
  d0_.modified_on AS modified_on_15,
  d0_.extra_emails AS extra_emails_16,
  d0_.phone_number AS phone_number_17,
  d0_.site AS site_18,
  d0_.legal_address AS legal_address_19,
  d0_.account_number AS account_number_20,
  d0_.tax_registration_date AS tax_registration_date_21,
  d0_.trade_registration_date AS trade_registration_date_22,
  d0_.registration_authority AS registration_authority_23,
  d0_.working_hours AS working_hours_24,
  d0_.footer_info AS footer_info_25,
  d0_.company_link AS company_link_26,
  d0_.id AS id_27,
  d0_.page_offer_id AS page_offer_id_28,
  d0_.manager_id AS manager_id_29
FROM
  director d0_
  INNER JOIN offer2director o2_ ON d0_.id = o2_.director_id
  INNER JOIN offer o1_ ON o1_.id = o2_.offer_id
WHERE
  o1_.id = ?

SELECT d0_.domain_object_id AS domain_object_id_0, d0_.name AS name_1, d0_.email AS email_2, d0_.legal_email AS legal_email_3, d0_.legal_entity AS legal_entity_4, d0_.tax_id AS tax_id_5, d0_.receive_letters AS receive_letters_6, d0_.transition_id AS transition_id_7, d0_.teaser_logo_width AS teaser_logo_width_8, d0_.teaser_logo_height AS teaser_logo_height_9, d0_.status AS status_10, d0_.punished AS punished_11, d0_.last_code_number AS last_code_number_12, d0_.about AS about_13, d0_.created_on AS created_on_14, d0_.modified_on AS modified_on_15, d0_.extra_emails AS extra_emails_16, d0_.phone_number AS phone_number_17, d0_.site AS site_18, d0_.legal_address AS legal_address_19, d0_.account_number AS account_number_20, d0_.tax_registration_date AS tax_registration_date_21, d0_.trade_registration_date AS trade_registration_date_22, d0_.registration_authority AS registration_authority_23, d0_.working_hours AS working_hours_24, d0_.footer_info AS footer_info_25, d0_.company_link AS company_link_26, d0_.id AS id_27, d0_.page_offer_id AS page_offer_id_28, d0_.manager_id AS manager_id_29 FROM director d0_ INNER JOIN offer2director o2_ ON d0_.id = o2_.director_id INNER JOIN offer o1_ ON o1_.id = o2_.offer_id WHERE o1_.id = '286127';

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 ('21')

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 = 16144 AND t0.type IN ('21');

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.resource_url = ?
  AND t0.entity_id = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC
LIMIT
  1