Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.published AS published_3,
  t0_.meta_name AS meta_name_4,
  t0_.meta_description AS meta_description_5,
  t0_.created_at AS created_at_6,
  t0_.updated_at AS updated_at_7,
  t0_.image AS image_8,
  t0_.main AS main_9
FROM
  tag t0_
  INNER JOIN news_tag n2_ ON t0_.id = n2_.tag_id
  INNER JOIN news n1_ ON n1_.id = n2_.news_id
WHERE
  n1_.id = ?

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.published AS published_3, t0_.meta_name AS meta_name_4, t0_.meta_description AS meta_description_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7, t0_.image AS image_8, t0_.main AS main_9 FROM tag t0_ INNER JOIN news_tag n2_ ON t0_.id = n2_.tag_id INNER JOIN news n1_ ON n1_.id = n2_.news_id WHERE n1_.id = 132585;

UPDATE
  news
SET
  hits = hits + 1
WHERE
  id = ?

UPDATE news SET hits = hits + 1 WHERE id = 132585;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.published AS published_3,
  t0_.meta_name AS meta_name_4,
  t0_.meta_description AS meta_description_5,
  t0_.created_at AS created_at_6,
  t0_.updated_at AS updated_at_7,
  t0_.image AS image_8,
  t0_.main AS main_9
FROM
  tag t0_
WHERE
  t0_.main = ?
  AND t0_.published = ?
ORDER BY
  t0_.updated_at DESC
LIMIT
  4

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.published AS published_3, t0_.meta_name AS meta_name_4, t0_.meta_description AS meta_description_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7, t0_.image AS image_8, t0_.main AS main_9 FROM tag t0_ WHERE t0_.main = 1 AND t0_.published = 1 ORDER BY t0_.updated_at DESC LIMIT 4;

SELECT
  n0_.id AS id_0,
  n0_.region_id AS region_id_1,
  n0_.status AS status_2,
  n0_.title AS title_3,
  n0_.alias AS alias_4,
  n0_.featured AS featured_5,
  n0_.campaign_material AS campaign_material_6,
  n0_.hits AS hits_7,
  n0_.published AS published_8,
  n0_.is_hidden AS is_hidden_9,
  n0_.is_main AS is_main_10,
  n0_.is_day_news AS is_day_news_11,
  n0_.extract AS extract_12,
  n0_.text AS text_13,
  n0_.social AS social_14,
  n0_.image AS image_15,
  n0_.image_caption AS image_caption_16,
  n0_.image_size AS image_size_17,
  n0_.video AS video_18,
  n0_.created_at AS created_at_19,
  n0_.updated_at AS updated_at_20,
  n0_.publish_at AS publish_at_21,
  n0_.reaction AS reaction_22,
  n0_.is_highlight AS is_highlight_23,
  n0_.has_video AS has_video_24,
  n0_.locked_at AS locked_at_25,
  n0_.category_id AS category_id_26,
  n0_.user_id AS user_id_27,
  n0_.id_author AS id_author_28,
  n0_.locked_user_id AS locked_user_id_29
FROM
  news n0_
  INNER JOIN categories c1_ ON n0_.category_id = c1_.id
WHERE
  n0_.id > ?
  AND n0_.category_id = ?
  AND c1_.published = 1
  AND n0_.published = 1
GROUP BY
  n0_.id
ORDER BY
  n0_.id DESC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.region_id AS region_id_1, n0_.status AS status_2, n0_.title AS title_3, n0_.alias AS alias_4, n0_.featured AS featured_5, n0_.campaign_material AS campaign_material_6, n0_.hits AS hits_7, n0_.published AS published_8, n0_.is_hidden AS is_hidden_9, n0_.is_main AS is_main_10, n0_.is_day_news AS is_day_news_11, n0_.extract AS extract_12, n0_.text AS text_13, n0_.social AS social_14, n0_.image AS image_15, n0_.image_caption AS image_caption_16, n0_.image_size AS image_size_17, n0_.video AS video_18, n0_.created_at AS created_at_19, n0_.updated_at AS updated_at_20, n0_.publish_at AS publish_at_21, n0_.reaction AS reaction_22, n0_.is_highlight AS is_highlight_23, n0_.has_video AS has_video_24, n0_.locked_at AS locked_at_25, n0_.category_id AS category_id_26, n0_.user_id AS user_id_27, n0_.id_author AS id_author_28, n0_.locked_user_id AS locked_user_id_29 FROM news n0_ INNER JOIN categories c1_ ON n0_.category_id = c1_.id WHERE n0_.id > 132585 AND n0_.category_id = '37' AND c1_.published = 1 AND n0_.published = 1 GROUP BY n0_.id ORDER BY n0_.id DESC LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.region_id AS region_id_1,
  n0_.status AS status_2,
  n0_.title AS title_3,
  n0_.alias AS alias_4,
  n0_.featured AS featured_5,
  n0_.campaign_material AS campaign_material_6,
  n0_.hits AS hits_7,
  n0_.published AS published_8,
  n0_.is_hidden AS is_hidden_9,
  n0_.is_main AS is_main_10,
  n0_.is_day_news AS is_day_news_11,
  n0_.extract AS extract_12,
  n0_.text AS text_13,
  n0_.social AS social_14,
  n0_.image AS image_15,
  n0_.image_caption AS image_caption_16,
  n0_.image_size AS image_size_17,
  n0_.video AS video_18,
  n0_.created_at AS created_at_19,
  n0_.updated_at AS updated_at_20,
  n0_.publish_at AS publish_at_21,
  n0_.reaction AS reaction_22,
  n0_.is_highlight AS is_highlight_23,
  n0_.has_video AS has_video_24,
  n0_.locked_at AS locked_at_25,
  n0_.category_id AS category_id_26,
  n0_.user_id AS user_id_27,
  n0_.id_author AS id_author_28,
  n0_.locked_user_id AS locked_user_id_29
FROM
  news n0_
  INNER JOIN categories c1_ ON n0_.category_id = c1_.id
WHERE
  n0_.id < ?
  AND n0_.category_id = ?
  AND c1_.published = 1
  AND n0_.published = 1
GROUP BY
  n0_.id
ORDER BY
  n0_.id DESC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.region_id AS region_id_1, n0_.status AS status_2, n0_.title AS title_3, n0_.alias AS alias_4, n0_.featured AS featured_5, n0_.campaign_material AS campaign_material_6, n0_.hits AS hits_7, n0_.published AS published_8, n0_.is_hidden AS is_hidden_9, n0_.is_main AS is_main_10, n0_.is_day_news AS is_day_news_11, n0_.extract AS extract_12, n0_.text AS text_13, n0_.social AS social_14, n0_.image AS image_15, n0_.image_caption AS image_caption_16, n0_.image_size AS image_size_17, n0_.video AS video_18, n0_.created_at AS created_at_19, n0_.updated_at AS updated_at_20, n0_.publish_at AS publish_at_21, n0_.reaction AS reaction_22, n0_.is_highlight AS is_highlight_23, n0_.has_video AS has_video_24, n0_.locked_at AS locked_at_25, n0_.category_id AS category_id_26, n0_.user_id AS user_id_27, n0_.id_author AS id_author_28, n0_.locked_user_id AS locked_user_id_29 FROM news n0_ INNER JOIN categories c1_ ON n0_.category_id = c1_.id WHERE n0_.id < 132585 AND n0_.category_id = '37' AND c1_.published = 1 AND n0_.published = 1 GROUP BY n0_.id ORDER BY n0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.name AS name_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.alias AS alias_6,
  t0.ordering AS ordering_7,
  t0.published AS published_8,
  t0.description AS description_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.on_duty AS on_duty_12
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.name AS name_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.alias AS alias_6, t0.ordering AS ordering_7, t0.published AS published_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.on_duty AS on_duty_12 FROM categories t0 WHERE t0.id = '37';

SELECT
  n0_.id AS id_0,
  n0_.region_id AS region_id_1,
  n0_.status AS status_2,
  n0_.title AS title_3,
  n0_.alias AS alias_4,
  n0_.featured AS featured_5,
  n0_.campaign_material AS campaign_material_6,
  n0_.hits AS hits_7,
  n0_.published AS published_8,
  n0_.is_hidden AS is_hidden_9,
  n0_.is_main AS is_main_10,
  n0_.is_day_news AS is_day_news_11,
  n0_.extract AS extract_12,
  n0_.text AS text_13,
  n0_.social AS social_14,
  n0_.image AS image_15,
  n0_.image_caption AS image_caption_16,
  n0_.image_size AS image_size_17,
  n0_.video AS video_18,
  n0_.created_at AS created_at_19,
  n0_.updated_at AS updated_at_20,
  n0_.publish_at AS publish_at_21,
  n0_.reaction AS reaction_22,
  n0_.is_highlight AS is_highlight_23,
  n0_.has_video AS has_video_24,
  n0_.locked_at AS locked_at_25,
  c1_.id AS id_26,
  c1_.category_id AS category_id_27,
  c1_.name AS name_28,
  c1_.meta_title AS meta_title_29,
  c1_.meta_description AS meta_description_30,
  c1_.alias AS alias_31,
  c1_.ordering AS ordering_32,
  c1_.published AS published_33,
  c1_.description AS description_34,
  c1_.created_at AS created_at_35,
  c1_.updated_at AS updated_at_36,
  c1_.on_duty AS on_duty_37,
  n0_.category_id AS category_id_38,
  n0_.user_id AS user_id_39,
  n0_.id_author AS id_author_40,
  n0_.locked_user_id AS locked_user_id_41
FROM
  news n0_
  LEFT JOIN categories c1_ ON n0_.category_id = c1_.id
WHERE
  n0_.published = ?
  AND c1_.published = ?
  AND n0_.id NOT IN (?)
  AND n0_.publish_at >= ?
  AND n0_.publish_at <= ?
ORDER BY
  n0_.hits DESC
LIMIT
  5

SELECT n0_.id AS id_0, n0_.region_id AS region_id_1, n0_.status AS status_2, n0_.title AS title_3, n0_.alias AS alias_4, n0_.featured AS featured_5, n0_.campaign_material AS campaign_material_6, n0_.hits AS hits_7, n0_.published AS published_8, n0_.is_hidden AS is_hidden_9, n0_.is_main AS is_main_10, n0_.is_day_news AS is_day_news_11, n0_.extract AS extract_12, n0_.text AS text_13, n0_.social AS social_14, n0_.image AS image_15, n0_.image_caption AS image_caption_16, n0_.image_size AS image_size_17, n0_.video AS video_18, n0_.created_at AS created_at_19, n0_.updated_at AS updated_at_20, n0_.publish_at AS publish_at_21, n0_.reaction AS reaction_22, n0_.is_highlight AS is_highlight_23, n0_.has_video AS has_video_24, n0_.locked_at AS locked_at_25, c1_.id AS id_26, c1_.category_id AS category_id_27, c1_.name AS name_28, c1_.meta_title AS meta_title_29, c1_.meta_description AS meta_description_30, c1_.alias AS alias_31, c1_.ordering AS ordering_32, c1_.published AS published_33, c1_.description AS description_34, c1_.created_at AS created_at_35, c1_.updated_at AS updated_at_36, c1_.on_duty AS on_duty_37, n0_.category_id AS category_id_38, n0_.user_id AS user_id_39, n0_.id_author AS id_author_40, n0_.locked_user_id AS locked_user_id_41 FROM news n0_ LEFT JOIN categories c1_ ON n0_.category_id = c1_.id WHERE n0_.published = 1 AND c1_.published = 1 AND n0_.id NOT IN (132585) AND n0_.publish_at >= '2025-10-04 00:00:00' AND n0_.publish_at <= '2025-10-04 21:40:13' ORDER BY n0_.hits DESC LIMIT 5;