Symfony Profiler

SELECT
  COUNT(*)
FROM
  (
    SELECT
      c.id,
      c.text,
      c.created_at,
      (
        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.created_at, (
                    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 = 19) AND (c.approved = 1) AND (c.reply_to IS NULL)) tmp;

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.product_id AS product_id_2,
  t0.title AS title_3,
  t0.cover AS cover_4,
  t0.text_ai AS text_ai_5,
  t0.text AS text_6,
  t0.url AS url_7,
  t0.published AS published_8,
  t0.moderated AS moderated_9,
  t0.priority AS priority_10,
  t0.themed_images AS themed_images_11,
  t0.photos_dir_num AS photos_dir_num_12,
  t0.parsed_url AS parsed_url_13,
  t0.add_later AS add_later_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.author_id AS author_id_17,
  t0.editor_id AS editor_id_18,
  t0.category_id AS category_id_19
FROM
  blog_posts t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.title AS title_3, t0.cover AS cover_4, t0.text_ai AS text_ai_5, t0.text AS text_6, t0.url AS url_7, t0.published AS published_8, t0.moderated AS moderated_9, t0.priority AS priority_10, t0.themed_images AS themed_images_11, t0.photos_dir_num AS photos_dir_num_12, t0.parsed_url AS parsed_url_13, t0.add_later AS add_later_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.author_id AS author_id_17, t0.editor_id AS editor_id_18, t0.category_id AS category_id_19 FROM blog_posts t0 WHERE t0.url = 'merceder-s-class' LIMIT 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 = 1;

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

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

SELECT
  c.id,
  c.text,
  c.created_at,
  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 (NULL)
  )
  AND (c.approved = 1)

SELECT c.id, c.text, c.created_at, 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 (NULL)) AND (c.approved = 1);

SELECT
  COUNT(id)
FROM
  blog_post_likes
WHERE
  post_id = ?

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

SELECT
  COUNT(id)
FROM
  blog_post_dislikes
WHERE
  post_id = ?

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

SELECT
  COUNT(id)
FROM
  blog_post_favorites
WHERE
  post_id = ?

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