Symfony Profiler

SELECT 
  t0_.tag_id AS tag_id_0, 
  t0_.name AS name_1, 
  t0_.avatar AS avatar_2, 
  t0_.description AS description_3, 
  t0_.slug AS slug_4, 
  t0_.post_count AS post_count_5, 
  s1_.tag_id AS tag_id_6, 
  s1_.summary AS summary_7, 
  s1_.focus_posts AS focus_posts_8 
FROM 
  tags t0_ 
  LEFT JOIN special_tags s1_ ON (t0_.tag_id = s1_.tag_id) 
WHERE 
  t0_.slug = ? 
LIMIT 
  1

SELECT t0_.tag_id AS tag_id_0, t0_.name AS name_1, t0_.avatar AS avatar_2, t0_.description AS description_3, t0_.slug AS slug_4, t0_.post_count AS post_count_5, s1_.tag_id AS tag_id_6, s1_.summary AS summary_7, s1_.focus_posts AS focus_posts_8 FROM tags t0_ LEFT JOIN special_tags s1_ ON (t0_.tag_id = s1_.tag_id) WHERE t0_.slug = 'homestay-bungalow' LIMIT 1;

SELECT 
  p0_.post_id AS post_id_0, 
  p0_.title AS title_1, 
  p0_.slug AS slug_2, 
  p0_.sapo AS sapo_3, 
  p0_.cate_id AS cate_id_4, 
  p0_.published_date AS published_date_5, 
  p0_.published_timestamp AS published_timestamp_6, 
  p0_.avatar AS avatar_7, 
  p0_.author_name AS author_name_8 
FROM 
  post_publishes p0_ 
  LEFT JOIN posts_tags p1_ ON (p0_.post_id = p1_.post_id) 
WHERE 
  p1_.tag_id = ? 
  AND p0_.published_date <= ? 
ORDER BY 
  p0_.published_date DESC, 
  p0_.post_id DESC 
LIMIT 
  13

SELECT p0_.post_id AS post_id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.sapo AS sapo_3, p0_.cate_id AS cate_id_4, p0_.published_date AS published_date_5, p0_.published_timestamp AS published_timestamp_6, p0_.avatar AS avatar_7, p0_.author_name AS author_name_8 FROM post_publishes p0_ LEFT JOIN posts_tags p1_ ON (p0_.post_id = p1_.post_id) WHERE p1_.tag_id = 2530 AND p0_.published_date <= '2024-11-01 11:34:14' ORDER BY p0_.published_date DESC, p0_.post_id DESC LIMIT 13;

SELECT 
  c0_.cate_id AS cate_id_0, 
  c0_.name AS name_1, 
  c0_.slug AS slug_2, 
  c0_.parent_id AS parent_id_3, 
  c0_.seo_title AS seo_title_4, 
  c0_.seo_description AS seo_description_5 
FROM 
  categories c0_

SELECT c0_.cate_id AS cate_id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3, c0_.seo_title AS seo_title_4, c0_.seo_description AS seo_description_5 FROM categories c0_;

SELECT 
  SUM(p0_.view_count) AS sclr_0, 
  p1_.post_id AS post_id_1, 
  p1_.avatar AS avatar_2, 
  p1_.slug AS slug_3, 
  p1_.sapo AS sapo_4, 
  p1_.title AS title_5, 
  p1_.cate_id AS cate_id_6, 
  p1_.view_count AS view_count_7, 
  p1_.published_date AS published_date_8, 
  p1_.published_timestamp AS published_timestamp_9 
FROM 
  post_publishes p1_ 
  INNER JOIN post_views p0_ ON (p1_.post_id = p0_.post_id) 
WHERE 
  p1_.published_timestamp <= ? 
  AND p0_.timestamp >= ? 
  AND p0_.timestamp <= ? 
GROUP BY 
  p0_.post_id 
ORDER BY 
  sclr_0 DESC, 
  p1_.published_date DESC 
LIMIT 
  5

SELECT SUM(p0_.view_count) AS sclr_0, p1_.post_id AS post_id_1, p1_.avatar AS avatar_2, p1_.slug AS slug_3, p1_.sapo AS sapo_4, p1_.title AS title_5, p1_.cate_id AS cate_id_6, p1_.view_count AS view_count_7, p1_.published_date AS published_date_8, p1_.published_timestamp AS published_timestamp_9 FROM post_publishes p1_ INNER JOIN post_views p0_ ON (p1_.post_id = p0_.post_id) WHERE p1_.published_timestamp <= 1730435654 AND p0_.timestamp >= 1730262854 AND p0_.timestamp <= 1730435654 GROUP BY p0_.post_id ORDER BY sclr_0 DESC, p1_.published_date DESC LIMIT 5;