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 = '/' 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
  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.gszurl AS gszurl_25,
  t0.lucene_reindex AS lucene_reindex_26,
  t0.show_on_main_page AS show_on_main_page_27,
  t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28,
  t0.default_category_id AS default_category_id_29,
  t0.alternative_url AS alternative_url_30,
  t0.review AS review_31,
  t0.on_review AS on_review_32,
  t0.id AS id_33,
  t0.creator_id AS creator_id_34
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.gszurl AS gszurl_25, t0.lucene_reindex AS lucene_reindex_26, t0.show_on_main_page AS show_on_main_page_27, t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28, t0.default_category_id AS default_category_id_29, t0.alternative_url AS alternative_url_30, t0.review AS review_31, t0.on_review AS on_review_32, t0.id AS id_33, t0.creator_id AS creator_id_34 FROM sale t0 WHERE t0.id = 286299;

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.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.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.entity_id = 286299 AND t0.type_id = 18228 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;

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.gszurl AS gszurl_25,
  t0.lucene_reindex AS lucene_reindex_26,
  t0.show_on_main_page AS show_on_main_page_27,
  t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28,
  t0.default_category_id AS default_category_id_29,
  t0.alternative_url AS alternative_url_30,
  t0.review AS review_31,
  t0.on_review AS on_review_32,
  t0.id AS id_33,
  t0.creator_id AS creator_id_34
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.gszurl AS gszurl_25, t0.lucene_reindex AS lucene_reindex_26, t0.show_on_main_page AS show_on_main_page_27, t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28, t0.default_category_id AS default_category_id_29, t0.alternative_url AS alternative_url_30, t0.review AS review_31, t0.on_review AS on_review_32, t0.id AS id_33, t0.creator_id AS creator_id_34 FROM sale t0 WHERE t0.id = 1356;

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.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.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.entity_id = 1356 AND t0.type_id = 18228 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;

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.gszurl AS gszurl_25,
  t0.lucene_reindex AS lucene_reindex_26,
  t0.show_on_main_page AS show_on_main_page_27,
  t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28,
  t0.default_category_id AS default_category_id_29,
  t0.alternative_url AS alternative_url_30,
  t0.review AS review_31,
  t0.on_review AS on_review_32,
  t0.id AS id_33,
  t0.creator_id AS creator_id_34
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.gszurl AS gszurl_25, t0.lucene_reindex AS lucene_reindex_26, t0.show_on_main_page AS show_on_main_page_27, t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28, t0.default_category_id AS default_category_id_29, t0.alternative_url AS alternative_url_30, t0.review AS review_31, t0.on_review AS on_review_32, t0.id AS id_33, t0.creator_id AS creator_id_34 FROM sale t0 WHERE t0.id = 286334;

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.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.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.entity_id = 286334 AND t0.type_id = 18228 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;

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-11-02 08:25:18', 0, 0, '114.119.132.88', 1, 'https://www.test1.dev.slivki.by/giper-shop/2potsene1?city=%D0%91%D0%B5%D1%88%D0%B5%D0%BD%D0%BA%D0%BE%D0%B2%D0%B8%D1%87%D0%B8', 845784762, NULL);

"COMMIT"

"COMMIT";

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.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:category' AND t0.entity_id = 3894 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
  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 = 1144789;

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

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

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