Symfony Profiler

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.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.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
  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 = 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.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 = 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.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 = 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.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 = 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-05-07 13:25:46', 0, 0, '114.119.139.167', 1, 'https://www.test.dev.slivki.by/produktysoskidkoy?city=%D0%9F%D0%B5%D1%80%D0%B2%D0%BE%D0%BC%D0%B0%D0%B9%D1%81%D0%BA%D0%B0%D1%8F', 795297772, 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;