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 = '/lazernaya-epilyatsiya-minsk-skidka-megasunbeauty' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

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

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.created_on between :dateFrom
    and :dateTo
  )
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 = 282591) AND (offer_code.created_on between '2025-04-30 17:04:33' and '2025-05-01 17:04:33') GROUP BY offer_id;

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 = 282591
  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 = 282591 and status > 0 and offer_order_details.created_on > now() + '-12 hours' order by offer_order_details.id desc limit 1;

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.id = ?
  AND t0.type IN ('26')

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.id = 1389252 AND t0.type IN ('26');

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

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 = 'Slivki:Default:details' AND t0.entity_id = 282591 AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

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

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

SELECT
  b0_.type_id AS type_id_0,
  b0_.title AS title_1,
  b0_.url AS url_2,
  b0_.file_path AS file_path_3,
  b0_.active AS active_4,
  b0_.file_path_mobile AS file_path_mobile_5,
  b0_.substitute_path AS substitute_path_6,
  b0_.javascript AS javascript_7,
  b0_.json AS json_8,
  b0_.code AS code_9,
  b0_.code_file_path AS code_file_path_10,
  b0_.position AS position_11,
  b0_.pixel_code AS pixel_code_12,
  b0_.pixel_code_mobile AS pixel_code_mobile_13,
  b0_.id AS id_14,
  b0_.position_row AS position_row_15,
  b0_.position_column AS position_column_16,
  b0_.utm_campaign AS utm_campaign_17,
  b0_.type AS type_18
FROM
  banner b0_
  INNER JOIN banner_city b2_ ON b0_.id = b2_.banner_id
  INNER JOIN city c1_ ON c1_.id = b2_.city_id
WHERE
  (
    b0_.type_id = ?
    AND b0_.active = ?
    AND c1_.id IN (?)
  )
  AND b0_.type IN ('0')
ORDER BY
  b0_.code DESC

SELECT b0_.type_id AS type_id_0, b0_.title AS title_1, b0_.url AS url_2, b0_.file_path AS file_path_3, b0_.active AS active_4, b0_.file_path_mobile AS file_path_mobile_5, b0_.substitute_path AS substitute_path_6, b0_.javascript AS javascript_7, b0_.json AS json_8, b0_.code AS code_9, b0_.code_file_path AS code_file_path_10, b0_.position AS position_11, b0_.pixel_code AS pixel_code_12, b0_.pixel_code_mobile AS pixel_code_mobile_13, b0_.id AS id_14, b0_.position_row AS position_row_15, b0_.position_column AS position_column_16, b0_.utm_campaign AS utm_campaign_17, b0_.type AS type_18 FROM banner b0_ INNER JOIN banner_city b2_ ON b0_.id = b2_.banner_id INNER JOIN city c1_ ON c1_.id = b2_.city_id WHERE (b0_.type_id = 7 AND b0_.active = 1 AND c1_.id IN (1)) AND b0_.type IN ('0') ORDER BY b0_.code DESC;

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 = 282591 AND c0_.type_id = 1 AND c0_.confirmed_phone = true AND c0_.hidden <> true AND (c0_.deleted <> true OR c0_.deleted IS NULL);

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_.id AS id_22,
  m1_.name AS name_23,
  m1_.path AS path_24,
  m1_.description AS description_25,
  m1_.width AS width_26,
  m1_.height AS height_27,
  m1_.size AS size_28,
  m1_.sort_order AS sort_order_29,
  m1_.checked AS checked_30,
  m1_.youtube AS youtube_31,
  m1_.tags AS tags_32,
  m1_.id AS id_33,
  c0_.parent_id AS parent_id_34,
  c0_.user_id AS user_id_35,
  c0_.operator_id AS operator_id_36,
  m1_.type AS type_37,
  m1_.entity_id AS entity_id_38
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_.id AS id_22, m1_.name AS name_23, m1_.path AS path_24, m1_.description AS description_25, m1_.width AS width_26, m1_.height AS height_27, m1_.size AS size_28, m1_.sort_order AS sort_order_29, m1_.checked AS checked_30, m1_.youtube AS youtube_31, m1_.tags AS tags_32, m1_.id AS id_33, c0_.parent_id AS parent_id_34, c0_.user_id AS user_id_35, c0_.operator_id AS operator_id_36, m1_.type AS type_37, m1_.entity_id AS entity_id_38 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 = 282591 ORDER BY c0_.id DESC, m1_.sort_order ASC LIMIT 10;

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

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.id AS id_30,
  t31.created_on AS created_on_32,
  t31.email AS email_33,
  t31.status AS status_34,
  t31.id AS id_35,
  t31.referral_id AS referral_id_36,
  t31.user_balance_activity_id AS user_balance_activity_id_37,
  t31.referer_id AS referer_id_38,
  t0.city_id AS city_id_39
FROM
  customer t0
  LEFT JOIN referral t31 ON t31.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.id AS id_30, t31.created_on AS created_on_32, t31.email AS email_33, t31.status AS status_34, t31.id AS id_35, t31.referral_id AS referral_id_36, t31.user_balance_activity_id AS user_balance_activity_id_37, t31.referer_id AS referer_id_38, t0.city_id AS city_id_39 FROM customer t0 LEFT JOIN referral t31 ON t31.referral_id = t0.id WHERE t0.id = 1365362;

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

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 = 282591 AND c0_.type_id = 1 AND c0_.confirmed_phone = true AND c0_.hidden <> true AND (c0_.deleted <> true OR c0_.deleted IS NULL);

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

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

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 = 'Slivki:Default:category' AND t0.entity_id = 212 AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

SELECT
  NEXTVAL('visit_id_seq')

SELECT NEXTVAL('visit_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO visit (
  created_on, entity_id, entity_type_id,
  ip_address, device_type, referrer,
  id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO visit (created_on, entity_id, entity_type_id, ip_address, device_type, referrer, id, user_id) VALUES ('2025-05-01 17:04:33', 282591, 1, '3.138.109.3', 0, '', 794102168, NULL);

"COMMIT"

"COMMIT";

SELECT
  max(offer_code_pool.id)
FROM
  offer_code_pool
WHERE
  offer_code_pool.offer_id = :offerId

SELECT max(offer_code_pool.id) FROM offer_code_pool WHERE offer_code_pool.offer_id = 282591;

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 = 282591) AND (offer_code.offer_code_pool_id = 167463) GROUP BY offer_id;

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 = 282591
  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=282591 and rating > 0 and confirmed_phone and not hidden ;

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

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

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 = 282591 AND v0_.entity_type_id = 1 AND v0_.created_on > '2025-04-30 17:04:33' AND v0_.created_on > '2020-10-30 00:00:00';

select
  get_visit_count(1, 282591, 30)

select get_visit_count(1, 282591, 30);

select
  category_id
from
  category2entity
  left join category_child_relation on category2entity.category_id = category_child_relation.child_id
where
  child_id is null
  and entity_id = 282591

select category_id from category2entity left join category_child_relation on category2entity.category_id = category_child_relation.child_id where child_id is null and entity_id = 282591;

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 = 282591);

SELECT
  g0_.active AS active_0,
  g0_.name AS name_1,
  g0_.price_regular AS price_regular_2,
  g0_.price_offer AS price_offer_3,
  g0_.discount_percent AS discount_percent_4,
  g0_.description AS description_5,
  g0_.position AS position_6,
  g0_.codes_per_item AS codes_per_item_7,
  g0_.hidden AS hidden_8,
  g0_.buy_only_code AS buy_only_code_9,
  g0_.special123 AS special123_10,
  g0_.active_days AS active_days_11,
  g0_.purchase_count AS purchase_count_12,
  g0_.position_beauty AS position_beauty_13,
  g0_.price_partner_purchase AS price_partner_purchase_14,
  g0_.code_suffix AS code_suffix_15,
  g0_.bundle_promo_count AS bundle_promo_count_16,
  g0_.multi_use_code_period AS multi_use_code_period_17,
  g0_.multi_use_code_per_period AS multi_use_code_per_period_18,
  g0_.is_subscription AS is_subscription_19,
  g0_.id AS id_20,
  g0_.offer_id AS offer_id_21
FROM
  gift_certificate g0_
WHERE
  g0_.offer_id = ?

SELECT g0_.active AS active_0, g0_.name AS name_1, g0_.price_regular AS price_regular_2, g0_.price_offer AS price_offer_3, g0_.discount_percent AS discount_percent_4, g0_.description AS description_5, g0_.position AS position_6, g0_.codes_per_item AS codes_per_item_7, g0_.hidden AS hidden_8, g0_.buy_only_code AS buy_only_code_9, g0_.special123 AS special123_10, g0_.active_days AS active_days_11, g0_.purchase_count AS purchase_count_12, g0_.position_beauty AS position_beauty_13, g0_.price_partner_purchase AS price_partner_purchase_14, g0_.code_suffix AS code_suffix_15, g0_.bundle_promo_count AS bundle_promo_count_16, g0_.multi_use_code_period AS multi_use_code_period_17, g0_.multi_use_code_per_period AS multi_use_code_per_period_18, g0_.is_subscription AS is_subscription_19, g0_.id AS id_20, g0_.offer_id AS offer_id_21 FROM gift_certificate g0_ WHERE g0_.offer_id = 282591;

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

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.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.id = ?
  AND t0.type IN ('0')

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.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.id = 1116693 AND t0.type IN ('0');

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