Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.cover AS cover_3,
  t0.text_ai AS text_ai_4,
  t0.text AS text_5,
  t0.url AS url_6,
  t0.published AS published_7,
  t0.moderated AS moderated_8,
  t0.priority AS priority_9,
  t0.thematic_images AS thematic_images_10,
  t0.short_info_for_table AS short_info_for_table_11,
  t0.add_later AS add_later_12,
  t0.date AS date_13,
  t0.update_date AS update_date_14,
  t0.author_id AS author_id_15,
  t0.editor_id AS editor_id_16,
  t0.category_id AS category_id_17
FROM
  blog_posts t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.cover AS cover_3, t0.text_ai AS text_ai_4, t0.text AS text_5, t0.url AS url_6, t0.published AS published_7, t0.moderated AS moderated_8, t0.priority AS priority_9, t0.thematic_images AS thematic_images_10, t0.short_info_for_table AS short_info_for_table_11, t0.add_later AS add_later_12, t0.date AS date_13, t0.update_date AS update_date_14, t0.author_id AS author_id_15, t0.editor_id AS editor_id_16, t0.category_id AS category_id_17 FROM blog_posts t0 WHERE t0.url = 'energy-efficiency-types-of-renewable-energy-their-comparison-and-main-advantages' LIMIT 1;

SELECT
  COUNT(id)
FROM
  blog_post_likes
WHERE
  post_id = ?

SELECT COUNT(id) FROM blog_post_likes WHERE post_id = 1;

SELECT
  COUNT(id)
FROM
  blog_post_dislikes
WHERE
  post_id = ?

SELECT COUNT(id) FROM blog_post_dislikes WHERE post_id = 1;

SELECT
  COUNT(id)
FROM
  blog_post_favorites
WHERE
  post_id = ?

SELECT COUNT(id) FROM blog_post_favorites WHERE post_id = 1;

SELECT
  COUNT(*)
FROM
  (
    SELECT
      c.id,
      c.text,
      c.date,
      (
        SELECT
          COUNT(cl.id)
        FROM
          blog_post_comments_likes cl
        WHERE
          cl.user_id = c.author_id
          AND cl.comment_id = c.id
      ) AS likes_cnt,
      (
        SELECT
          COUNT(cd.id)
        FROM
          blog_post_comments_dislikes cd
        WHERE
          cd.user_id = c.author_id
          AND cd.comment_id = c.id
      ) AS dislikes_cnt,
      (
        SELECT
          COUNT(cl.id)
        FROM
          blog_post_comments_likes cl
        WHERE
          cl.user_id = ?
          AND cl.comment_id = c.id
      ) AS is_current_user_liked,
      (
        SELECT
          COUNT(cd.id)
        FROM
          blog_post_comments_dislikes cd
        WHERE
          cd.user_id = ?
          AND cd.comment_id = c.id
      ) AS is_current_user_disliked,
      TRIM(
        CONCAT(u.name_first, ' ', u.name_last)
      ) AS name,
      u.nickname,
      u.avatar,
      u.photos_dir_num,
      u.fake
    FROM
      blog_post_comments c
      INNER JOIN user_users u ON c.author_id = u.id
    WHERE
      (c.post_id = ?)
      AND (c.approved = 1)
      AND (c.reply_to IS NULL)
  ) tmp

SELECT COUNT(*) FROM (SELECT c.id, c.text, c.date, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                 ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = 0 AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = 0 AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.post_id = 1) AND (c.approved = 1) AND (c.reply_to IS NULL)) tmp;

SELECT
  c.id,
  c.text,
  c.date,
  (
    SELECT
      COUNT(cl.id)
    FROM
      blog_post_comments_likes cl
    WHERE
      cl.user_id = c.author_id
      AND cl.comment_id = c.id
  ) AS likes_cnt,
  (
    SELECT
      COUNT(cd.id)
    FROM
      blog_post_comments_dislikes cd
    WHERE
      cd.user_id = c.author_id
      AND cd.comment_id = c.id
  ) AS dislikes_cnt,
  (
    SELECT
      COUNT(cl.id)
    FROM
      blog_post_comments_likes cl
    WHERE
      cl.user_id = ?
      AND cl.comment_id = c.id
  ) AS is_current_user_liked,
  (
    SELECT
      COUNT(cd.id)
    FROM
      blog_post_comments_dislikes cd
    WHERE
      cd.user_id = ?
      AND cd.comment_id = c.id
  ) AS is_current_user_disliked,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  u.nickname,
  u.avatar,
  u.photos_dir_num,
  u.fake
FROM
  blog_post_comments c
  INNER JOIN user_users u ON c.author_id = u.id
WHERE
  (c.post_id = ?)
  AND (c.approved = 1)
  AND (c.reply_to IS NULL)
ORDER BY
  id desc
LIMIT
  5
OFFSET
  15

SELECT c.id, c.text, c.date, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                 ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = 0 AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = 0 AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.post_id = 1) AND (c.approved = 1) AND (c.reply_to IS NULL) ORDER BY id desc LIMIT 5 OFFSET 15;

SELECT
  c.id,
  c.text,
  c.date,
  c.reply_to,
  (
    SELECT
      COUNT(cl.id)
    FROM
      blog_post_comments_likes cl
    WHERE
      cl.user_id = c.author_id
      AND cl.comment_id = c.id
  ) AS likes_cnt,
  (
    SELECT
      COUNT(cd.id)
    FROM
      blog_post_comments_dislikes cd
    WHERE
      cd.user_id = c.author_id
      AND cd.comment_id = c.id
  ) AS dislikes_cnt,
  (
    SELECT
      COUNT(cl.id)
    FROM
      blog_post_comments_likes cl
    WHERE
      cl.user_id = ?
      AND cl.comment_id = c.id
  ) AS is_current_user_liked,
  (
    SELECT
      COUNT(cd.id)
    FROM
      blog_post_comments_dislikes cd
    WHERE
      cd.user_id = ?
      AND cd.comment_id = c.id
  ) AS is_current_user_disliked,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  u.nickname,
  u.avatar,
  u.photos_dir_num,
  u.fake
FROM
  blog_post_comments c
  INNER JOIN user_users u ON c.author_id = u.id
WHERE
  (
    c.reply_to IN (?, ?, ?, ?, ?)
  )
  AND (c.approved = 1)

SELECT c.id, c.text, c.date, c.reply_to, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = 0 AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = 0 AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.reply_to IN (7, 6, 5, 4, 3)) AND (c.approved = 1);

SELECT
  COUNT(id)
FROM
  blog_post_comments
WHERE
  (post_id = ?)
  AND (approved = 1)

SELECT COUNT(id) FROM blog_post_comments WHERE (post_id = 1) AND (approved = 1);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.avatar AS avatar_4,
  t0.bio AS bio_5,
  t0.facebook AS facebook_6,
  t0.twitter AS twitter_7,
  t0.linkedin AS linkedin_8,
  t0.instagram AS instagram_9,
  t0.pinterest AS pinterest_10
FROM
  blog_authors t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.avatar AS avatar_4, t0.bio AS bio_5, t0.facebook AS facebook_6, t0.twitter AS twitter_7, t0.linkedin AS linkedin_8, t0.instagram AS instagram_9, t0.pinterest AS pinterest_10 FROM blog_authors t0 WHERE t0.id = 4;

SELECT
  a.id,
  a.name,
  a.url
FROM
  blog_authors a

SELECT a.id, a.name, a.url FROM blog_authors a;

SELECT
  a.id,
  a.name,
  a.url
FROM
  blog_authors a

SELECT a.id, a.name, a.url FROM blog_authors a;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  blog_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_categories t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  blog_tag_names t0
  INNER JOIN blog_tags ON t0.id = blog_tags.tag_id
WHERE
  blog_tags.post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_tag_names t0 INNER JOIN blog_tags ON t0.id = blog_tags.tag_id WHERE blog_tags.post_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.avatar AS avatar_4,
  t0.bio AS bio_5,
  t0.facebook AS facebook_6,
  t0.twitter AS twitter_7,
  t0.linkedin AS linkedin_8,
  t0.instagram AS instagram_9,
  t0.pinterest AS pinterest_10
FROM
  blog_authors t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.avatar AS avatar_4, t0.bio AS bio_5, t0.facebook AS facebook_6, t0.twitter AS twitter_7, t0.linkedin AS linkedin_8, t0.instagram AS instagram_9, t0.pinterest AS pinterest_10 FROM blog_authors t0 WHERE t0.id = 5;

SELECT
  COUNT(`id`)
FROM
  `blog_posts_published_ids`

SELECT COUNT(`id`) FROM `blog_posts_published_ids`;

SELECT
  p.url,
  p.title,
  p.cover,
  p.date,
  c.id AS category_id,
  c.name AS category_name,
  a.name AS author_name,
  a.url AS author_url,
  (
    SELECT
      COUNT(m.id)
    FROM
      blog_post_comments m
    WHERE
      m.post_id = p.id
      AND m.approved = 1
  ) AS comments_count
FROM
  blog_posts p
  INNER JOIN blog_authors a ON p.author_id = a.id
  INNER JOIN blog_categories c ON p.category_id = c.id
WHERE
  p.id IN(NULL)

SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(NULL);

SELECT
  id,
  name
FROM
  blog_categories

SELECT id, name FROM blog_categories;

SELECT
  COUNT(`id`)
FROM
  `blog_posts_published_ids`

SELECT COUNT(`id`) FROM `blog_posts_published_ids`;

SELECT
  p.url,
  p.title,
  p.cover,
  p.date,
  c.id AS category_id,
  c.name AS category_name,
  a.name AS author_name,
  a.url AS author_url,
  (
    SELECT
      COUNT(m.id)
    FROM
      blog_post_comments m
    WHERE
      m.post_id = p.id
      AND m.approved = 1
  ) AS comments_count
FROM
  blog_posts p
  INNER JOIN blog_authors a ON p.author_id = a.id
  INNER JOIN blog_categories c ON p.category_id = c.id
WHERE
  p.id IN(NULL)

SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(NULL);

SELECT
  id,
  name
FROM
  blog_tag_names
ORDER BY
  RAND() ASC
LIMIT
  20

SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 20;

SELECT
  COUNT(`id`)
FROM
  `blog_posts_published_ids`

SELECT COUNT(`id`) FROM `blog_posts_published_ids`;

SELECT
  p.url,
  p.title,
  p.cover,
  p.date,
  c.id AS category_id,
  c.name AS category_name,
  a.name AS author_name,
  a.url AS author_url,
  (
    SELECT
      COUNT(m.id)
    FROM
      blog_post_comments m
    WHERE
      m.post_id = p.id
      AND m.approved = 1
  ) AS comments_count
FROM
  blog_posts p
  INNER JOIN blog_authors a ON p.author_id = a.id
  INNER JOIN blog_categories c ON p.category_id = c.id
WHERE
  p.id IN(NULL)

SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(NULL);