Symfony Profiler

SELECT
  t0.image_url AS image_url_1,
  t0.sort_order AS sort_order_2,
  t0.id AS id_3,
  t0.entity_description_id AS entity_description_id_4
FROM
  entity_description_slider_image t0
WHERE
  t0.entity_description_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.image_url AS image_url_1, t0.sort_order AS sort_order_2, t0.id AS id_3, t0.entity_description_id AS entity_description_id_4 FROM entity_description_slider_image t0 WHERE t0.entity_description_id = 276091 ORDER BY t0.sort_order ASC;

SELECT
  t0.name AS name_1,
  t0.path AS path_2,
  t0.description AS description_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.size AS size_6,
  t0.sort_order AS sort_order_7,
  t0.checked AS checked_8,
  t0.youtube AS youtube_9,
  t0.id AS id_10,
  t0.type_id AS type_id_11,
  t0.entity_id AS entity_id_12,
  t0.type_id AS type_id_13,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order ASC

SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.id AS id_10, t0.type_id AS type_id_11, t0.entity_id AS entity_id_12, t0.type_id AS type_id_13, t0.type FROM media t0 WHERE t0.entity_id = 286299 AND t0.type_id = 18228 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;

select
  *
from
  hot_feed
where
  type = 1
  and city_id = 1
order by
  created_on desc
limit
  20 offset 0

select * from hot_feed where type = 1  and city_id = 1 order by created_on desc limit 20 offset 0;

SELECT
  t0.type_id AS type_id_1,
  t0.entity_id AS entity_id_2,
  t0.description AS description_3,
  t0.sort_order AS sort_order_4,
  t0.id AS id_5,
  t0.entity_id AS entity_id_6,
  t0.entity_id AS entity_id_7,
  t0.entity_type_id
FROM
  entity_description t0
WHERE
  t0.entity_id = ?
  AND t0.entity_type_id IN ('2')
ORDER BY
  t0.sort_order ASC

SELECT t0.type_id AS type_id_1, t0.entity_id AS entity_id_2, t0.description AS description_3, t0.sort_order AS sort_order_4, t0.id AS id_5, t0.entity_id AS entity_id_6, t0.entity_id AS entity_id_7, t0.entity_type_id FROM entity_description t0 WHERE t0.entity_id = 16836 AND t0.entity_type_id IN ('2') ORDER BY t0.sort_order ASC;

SELECT
  COUNT(*)
FROM
  sale_version t0
WHERE
  t0.sale_id = ?

SELECT COUNT(*) FROM sale_version t0 WHERE t0.sale_id = 2454;

SELECT
  t0.created_on AS created_on_1,
  t0.title AS title_2,
  t0.alternative_title AS alternative_title_3,
  t0.body AS body_4,
  t0.active AS active_5,
  t0.sort_order AS sort_order_6,
  t0.since AS since_7,
  t0.till AS till_8,
  t0.top_position AS top_position_9,
  t0.last_modified AS last_modified_10,
  t0.teaser_title AS teaser_title_11,
  t0.flier_title AS flier_title_12,
  t0.flier_text AS flier_text_13,
  t0.gallery_url AS gallery_url_14,
  t0.caption_name AS caption_name_15,
  t0.caption_color AS caption_color_16,
  t0.video_guide_youtube_id AS video_guide_youtube_id_17,
  t0.address AS address_18,
  t0.video_duration_seconds AS video_duration_seconds_19,
  t0.renewed_on AS renewed_on_20,
  t0.offer_link_url AS offer_link_url_21,
  t0.offer_link_name AS offer_link_name_22,
  t0.show_map AS show_map_23,
  t0.supercheck_shop_id AS supercheck_shop_id_24,
  t0.lucene_reindex AS lucene_reindex_25,
  t0.show_on_main_page AS show_on_main_page_26,
  t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_27,
  t0.default_category_id AS default_category_id_28,
  t0.alternative_url AS alternative_url_29,
  t0.review AS review_30,
  t0.on_review AS on_review_31,
  t0.id AS id_32,
  t0.creator_id AS creator_id_33
FROM
  sale t0
WHERE
  t0.id = ?

SELECT t0.created_on AS created_on_1, t0.title AS title_2, t0.alternative_title AS alternative_title_3, t0.body AS body_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.since AS since_7, t0.till AS till_8, t0.top_position AS top_position_9, t0.last_modified AS last_modified_10, t0.teaser_title AS teaser_title_11, t0.flier_title AS flier_title_12, t0.flier_text AS flier_text_13, t0.gallery_url AS gallery_url_14, t0.caption_name AS caption_name_15, t0.caption_color AS caption_color_16, t0.video_guide_youtube_id AS video_guide_youtube_id_17, t0.address AS address_18, t0.video_duration_seconds AS video_duration_seconds_19, t0.renewed_on AS renewed_on_20, t0.offer_link_url AS offer_link_url_21, t0.offer_link_name AS offer_link_name_22, t0.show_map AS show_map_23, t0.supercheck_shop_id AS supercheck_shop_id_24, t0.lucene_reindex AS lucene_reindex_25, t0.show_on_main_page AS show_on_main_page_26, t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_27, t0.default_category_id AS default_category_id_28, t0.alternative_url AS alternative_url_29, t0.review AS review_30, t0.on_review AS on_review_31, t0.id AS id_32, t0.creator_id AS creator_id_33 FROM sale t0 WHERE t0.id = 286299;

SELECT
  t0.created_on AS created_on_1,
  t0.name AS name_2,
  t0.description_background_url AS description_background_url_3,
  t0.description_title_background_url AS description_title_background_url_4,
  t0.since AS since_5,
  t0.till AS till_6,
  t0.id AS id_7,
  t0.sale_id AS sale_id_8
FROM
  sale_version t0
WHERE
  t0.sale_id = ?
ORDER BY
  t0.id DESC

SELECT t0.created_on AS created_on_1, t0.name AS name_2, t0.description_background_url AS description_background_url_3, t0.description_title_background_url AS description_title_background_url_4, t0.since AS since_5, t0.till AS till_6, t0.id AS id_7, t0.sale_id AS sale_id_8 FROM sale_version t0 WHERE t0.sale_id = 2454 ORDER BY t0.id DESC;

SELECT
  t0.type_id AS type_id_1,
  t0.entity_id AS entity_id_2,
  t0.description AS description_3,
  t0.sort_order AS sort_order_4,
  t0.id AS id_5,
  t0.entity_id AS entity_id_6,
  t0.entity_id AS entity_id_7,
  t0.entity_type_id
FROM
  entity_description t0
WHERE
  t0.entity_id = ?
  AND t0.entity_type_id IN ('3')

SELECT t0.type_id AS type_id_1, t0.entity_id AS entity_id_2, t0.description AS description_3, t0.sort_order AS sort_order_4, t0.id AS id_5, t0.entity_id AS entity_id_6, t0.entity_id AS entity_id_7, t0.entity_type_id FROM entity_description t0 WHERE t0.entity_id = 16836 AND t0.entity_type_id IN ('3');

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

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_.id AS id_20,
  c0_.parent_id AS parent_id_21,
  c0_.user_id AS user_id_22,
  c0_.operator_id AS operator_id_23
FROM
  comment c0_
  INNER JOIN offer o1_ ON (o1_.id = c0_.entity_id)
WHERE
  c0_.hidden = ?
  AND c0_.confirmed_phone = ?
  AND o1_.default_city_id <> ?
ORDER BY
  c0_.created_on DESC
LIMIT
  3

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_.id AS id_20, c0_.parent_id AS parent_id_21, c0_.user_id AS user_id_22, c0_.operator_id AS operator_id_23 FROM comment c0_ INNER JOIN offer o1_ ON (o1_.id = c0_.entity_id) WHERE c0_.hidden = 0 AND c0_.confirmed_phone = 1 AND o1_.default_city_id <> 184 ORDER BY c0_.created_on DESC LIMIT 3;

"COMMIT"

"COMMIT";

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.city_area_id AS city_area_id_20,
  t0.type
FROM
  geo_location t0
  INNER JOIN geo_location_relation ON t0.id = geo_location_relation.location_id
WHERE
  geo_location_relation.entity_id = ?
  AND t0.type IN ('1')

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.city_area_id AS city_area_id_20, t0.type FROM geo_location t0 INNER JOIN geo_location_relation ON t0.id = geo_location_relation.location_id WHERE geo_location_relation.entity_id = 2454 AND t0.type IN ('1');

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 sale2director ON t0.id = sale2director.director_id
WHERE
  sale2director.sale_id = ?

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 sale2director ON t0.id = sale2director.director_id WHERE sale2director.sale_id = 2454;

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

SELECT
  t0.sort_order AS sort_order_1,
  t0.id AS id_2,
  t0.sale_id AS sale_id_3,
  t0.city_id AS city_id_4
FROM
  top_sale t0
WHERE
  t0.city_id = ?
ORDER BY
  t0.sort_order ASC
LIMIT
  3

SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = 1 ORDER BY t0.sort_order ASC LIMIT 3;

select
  avg(rating) as rating
from
  comment
where
  type_id = 2
  and entity_id = 2454
  and rating > 0
  and checked
  and confirmed_phone
  and not hidden

select avg(rating) as rating from comment where type_id=2 and entity_id=2454 and rating > 0 and checked and confirmed_phone and not hidden ;

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-08-01 03:48:52', 0, 0, '220.250.11.146', 0, '', 814922887, NULL);

SELECT
  NEXTVAL('visit_id_seq')

SELECT NEXTVAL('visit_id_seq');

"START TRANSACTION"

"START TRANSACTION";