Symfony Profiler

SELECT
  (
    SELECT
      count(f.id)
    FROM
      favourite f
      LEFT JOIN entry fj ON f.entry_id = fj.id
    WHERE
      fj.user_id = :user
      AND f.user_id != :user
  ) + (
    SELECT
      count(f.id)
    FROM
      favourite f
      LEFT JOIN entry_comment fj ON f.entry_comment_id = fj.id
    WHERE
      fj.user_id = :user
      AND f.user_id != :user
  ) + (
    SELECT
      count(f.id)
    FROM
      favourite f
      LEFT JOIN post fj ON f.post_id = fj.id
    WHERE
      fj.user_id = :user
      AND f.user_id != :user
  ) + (
    SELECT
      count(f.id)
    FROM
      favourite f
      LEFT JOIN post_comment fj ON f.post_comment_id = fj.id
    WHERE
      fj.user_id = :user
      AND f.user_id != :user
  ) as total

SELECT
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN entry fj ON f.entry_id = fj.id
                WHERE fj.user_id = 5863 AND f.user_id != 5863) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN entry_comment fj ON f.entry_comment_id = fj.id
                WHERE fj.user_id = 5863 AND f.user_id != 5863) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN post fj ON f.post_id = fj.id
                WHERE fj.user_id = 5863 AND f.user_id != 5863) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN post_comment fj ON f.post_comment_id = fj.id
                WHERE fj.user_id = 5863 AND f.user_id != 5863) as total;

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.is_adult AS is_adult_3,
  t0.favourite_count AS favourite_count_4,
  t0.score AS score_5,
  t0.last_active AS last_active_6,
  t0.ip AS ip_7,
  t0.tags AS tags_8,
  t0.mentions AS mentions_9,
  t0.id AS id_10,
  t0.body_ts AS body_ts_11,
  t0.up_votes AS up_votes_12,
  t0.down_votes AS down_votes_13,
  t0.visibility AS visibility_14,
  t0.ap_id AS ap_id_15,
  t0.edited_at AS edited_at_16,
  t0.created_at AS created_at_17,
  t0.user_id AS user_id_18,
  t0.entry_id AS entry_id_19,
  t0.magazine_id AS magazine_id_20,
  t0.image_id AS image_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23
FROM
  entry_comment t0
WHERE
  t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (92980, 64232, 224566, 217780, 221219, 77360, 92999, 64292, 163929, 136990, 142897, 171175, 40514, 101595, 93276);

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.is_adult AS is_adult_3,
  t0.favourite_count AS favourite_count_4,
  t0.score AS score_5,
  t0.last_active AS last_active_6,
  t0.ip AS ip_7,
  t0.tags AS tags_8,
  t0.mentions AS mentions_9,
  t0.id AS id_10,
  t0.body_ts AS body_ts_11,
  t0.up_votes AS up_votes_12,
  t0.down_votes AS down_votes_13,
  t0.visibility AS visibility_14,
  t0.ap_id AS ap_id_15,
  t0.edited_at AS edited_at_16,
  t0.created_at AS created_at_17,
  t0.user_id AS user_id_18,
  t0.entry_id AS entry_id_19,
  t0.magazine_id AS magazine_id_20,
  t0.image_id AS image_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23
FROM
  entry_comment t0
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (64246, 66128, 64452, 64442, 64340, 64690, 77574, 77878, 77516, 77871, 93097, 93186, 93267, 93740, 93856, 95695, 96514, 93904, 102314, 139725, 137037, 138830, 138156, 137069, 137458, 137509, 139119, 137112, 142315, 137076, 143064, 143120, 165136, 164443, 171542, 217785, 217861, 219653, 219156, 217885, 221345);

SELECT
  t0.slug AS slug_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.type AS type_5,
  t0.lang AS lang_6,
  t0.is_oc AS is_oc_7,
  t0.has_embed AS has_embed_8,
  t0.comment_count AS comment_count_9,
  t0.favourite_count AS favourite_count_10,
  t0.score AS score_11,
  t0.is_adult AS is_adult_12,
  t0.sticky AS sticky_13,
  t0.last_active AS last_active_14,
  t0.ip AS ip_15,
  t0.ada_amount AS ada_amount_16,
  t0.tags AS tags_17,
  t0.mentions AS mentions_18,
  t0.id AS id_19,
  t0.title_ts AS title_ts_20,
  t0.body_ts AS body_ts_21,
  t0.up_votes AS up_votes_22,
  t0.down_votes AS down_votes_23,
  t0.ranking AS ranking_24,
  t0.visibility AS visibility_25,
  t0.ap_id AS ap_id_26,
  t0.edited_at AS edited_at_27,
  t0.created_at AS created_at_28,
  t0.user_id AS user_id_29,
  t0.magazine_id AS magazine_id_30,
  t0.image_id AS image_id_31,
  t0.domain_id AS domain_id_32
FROM
  entry t0
WHERE
  t0.id = ?

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = 10218;

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.is_adult AS is_adult_3,
  t0.favourite_count AS favourite_count_4,
  t0.score AS score_5,
  t0.last_active AS last_active_6,
  t0.ip AS ip_7,
  t0.tags AS tags_8,
  t0.mentions AS mentions_9,
  t0.id AS id_10,
  t0.body_ts AS body_ts_11,
  t0.up_votes AS up_votes_12,
  t0.down_votes AS down_votes_13,
  t0.visibility AS visibility_14,
  t0.ap_id AS ap_id_15,
  t0.edited_at AS edited_at_16,
  t0.created_at AS created_at_17,
  t0.user_id AS user_id_18,
  t0.entry_id AS entry_id_19,
  t0.magazine_id AS magazine_id_20,
  t0.image_id AS image_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23
FROM
  entry_comment t0
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (64239, 64370, 64602, 64315, 77364, 77498, 77483, 92984, 93197, 93807, 102180, 102299, 137014, 138100, 137033, 143023, 164061, 164192, 171389, 217872, 217782, 221321, 226970);

SELECT
  e0_.body AS body_0,
  e0_.lang AS lang_1,
  e0_.is_adult AS is_adult_2,
  e0_.favourite_count AS favourite_count_3,
  e0_.score AS score_4,
  e0_.last_active AS last_active_5,
  e0_.ip AS ip_6,
  e0_.tags AS tags_7,
  e0_.mentions AS mentions_8,
  e0_.id AS id_9,
  e0_.body_ts AS body_ts_10,
  e0_.up_votes AS up_votes_11,
  e0_.down_votes AS down_votes_12,
  e0_.visibility AS visibility_13,
  e0_.ap_id AS ap_id_14,
  e0_.edited_at AS edited_at_15,
  e0_.created_at AS created_at_16,
  u1_.email AS email_17,
  u1_.username AS username_18,
  u1_.roles AS roles_19,
  u1_.followers_count AS followers_count_20,
  u1_.homepage AS homepage_21,
  u1_.about AS about_22,
  u1_.last_active AS last_active_23,
  u1_.marked_for_deletion_at AS marked_for_deletion_at_24,
  u1_.fields AS fields_25,
  u1_.oauth_github_id AS oauth_github_id_26,
  u1_.oauth_google_id AS oauth_google_id_27,
  u1_.oauth_facebook_id AS oauth_facebook_id_28,
  u1_.oauth_keycloak_id AS oauth_keycloak_id_29,
  u1_.hide_adult AS hide_adult_30,
  u1_.show_subscribed_users AS show_subscribed_users_31,
  u1_.show_subscribed_magazines AS show_subscribed_magazines_32,
  u1_.show_subscribed_domains AS show_subscribed_domains_33,
  u1_.preferred_languages AS preferred_languages_34,
  u1_.featured_magazines AS featured_magazines_35,
  u1_.show_profile_subscriptions AS show_profile_subscriptions_36,
  u1_.show_profile_followings AS show_profile_followings_37,
  u1_.mark_new_comments AS mark_new_comments_38,
  u1_.notify_on_new_entry AS notify_on_new_entry_39,
  u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_40,
  u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_41,
  u1_.notify_on_new_post AS notify_on_new_post_42,
  u1_.notify_on_new_post_reply AS notify_on_new_post_reply_43,
  u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_44,
  u1_.add_mentions_entries AS add_mentions_entries_45,
  u1_.add_mentions_posts AS add_mentions_posts_46,
  u1_.is_banned AS is_banned_47,
  u1_.is_verified AS is_verified_48,
  u1_.is_deleted AS is_deleted_49,
  u1_.is_bot AS is_bot_50,
  u1_.spam_protection AS spam_protection_51,
  u1_.custom_css AS custom_css_52,
  u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_53,
  u1_.id AS id_54,
  u1_.password AS password_55,
  u1_.totp_secret AS totp_secret_56,
  u1_.totp_backup_codes AS totp_backup_codes_57,
  u1_.ap_id AS ap_id_58,
  u1_.ap_profile_id AS ap_profile_id_59,
  u1_.ap_public_url AS ap_public_url_60,
  u1_.ap_followers_url AS ap_followers_url_61,
  u1_.ap_inbox_url AS ap_inbox_url_62,
  u1_.ap_domain AS ap_domain_63,
  u1_.ap_preferred_username AS ap_preferred_username_64,
  u1_.ap_discoverable AS ap_discoverable_65,
  u1_.ap_manually_approves_followers AS ap_manually_approves_followers_66,
  u1_.private_key AS private_key_67,
  u1_.public_key AS public_key_68,
  u1_.ap_fetched_at AS ap_fetched_at_69,
  u1_.ap_deleted_at AS ap_deleted_at_70,
  u1_.ap_timeout_at AS ap_timeout_at_71,
  u1_.visibility AS visibility_72,
  u1_.created_at AS created_at_73,
  e0_.user_id AS user_id_74,
  e0_.entry_id AS entry_id_75,
  e0_.magazine_id AS magazine_id_76,
  e0_.image_id AS image_id_77,
  e0_.parent_id AS parent_id_78,
  e0_.root_id AS root_id_79,
  u1_.avatar_id AS avatar_id_80,
  u1_.cover_id AS cover_id_81
FROM
  entry_comment e0_
  INNER JOIN "user" u1_ ON e0_.user_id = u1_.id
  INNER JOIN entry e2_ ON e0_.entry_id = e2_.id
  INNER JOIN entry e3_ ON e0_.entry_id = e3_.id
  INNER JOIN magazine m4_ ON e2_.magazine_id = m4_.id
WHERE
  e0_.visibility IN (?, ?, ?)
  AND e2_.visibility = ?
  AND e0_.user_id = ?
  AND m4_.is_adult = ?
  AND e2_.is_adult = ?
ORDER BY
  e0_.favourite_count - e0_.down_votes DESC,
  e0_.created_at DESC,
  e0_.id DESC
LIMIT
  15

SELECT e0_.body AS body_0, e0_.lang AS lang_1, e0_.is_adult AS is_adult_2, e0_.favourite_count AS favourite_count_3, e0_.score AS score_4, e0_.last_active AS last_active_5, e0_.ip AS ip_6, e0_.tags AS tags_7, e0_.mentions AS mentions_8, e0_.id AS id_9, e0_.body_ts AS body_ts_10, e0_.up_votes AS up_votes_11, e0_.down_votes AS down_votes_12, e0_.visibility AS visibility_13, e0_.ap_id AS ap_id_14, e0_.edited_at AS edited_at_15, e0_.created_at AS created_at_16, u1_.email AS email_17, u1_.username AS username_18, u1_.roles AS roles_19, u1_.followers_count AS followers_count_20, u1_.homepage AS homepage_21, u1_.about AS about_22, u1_.last_active AS last_active_23, u1_.marked_for_deletion_at AS marked_for_deletion_at_24, u1_.fields AS fields_25, u1_.oauth_github_id AS oauth_github_id_26, u1_.oauth_google_id AS oauth_google_id_27, u1_.oauth_facebook_id AS oauth_facebook_id_28, u1_.oauth_keycloak_id AS oauth_keycloak_id_29, u1_.hide_adult AS hide_adult_30, u1_.show_subscribed_users AS show_subscribed_users_31, u1_.show_subscribed_magazines AS show_subscribed_magazines_32, u1_.show_subscribed_domains AS show_subscribed_domains_33, u1_.preferred_languages AS preferred_languages_34, u1_.featured_magazines AS featured_magazines_35, u1_.show_profile_subscriptions AS show_profile_subscriptions_36, u1_.show_profile_followings AS show_profile_followings_37, u1_.mark_new_comments AS mark_new_comments_38, u1_.notify_on_new_entry AS notify_on_new_entry_39, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_40, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_41, u1_.notify_on_new_post AS notify_on_new_post_42, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_43, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_44, u1_.add_mentions_entries AS add_mentions_entries_45, u1_.add_mentions_posts AS add_mentions_posts_46, u1_.is_banned AS is_banned_47, u1_.is_verified AS is_verified_48, u1_.is_deleted AS is_deleted_49, u1_.is_bot AS is_bot_50, u1_.spam_protection AS spam_protection_51, u1_.custom_css AS custom_css_52, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_53, u1_.id AS id_54, u1_.password AS password_55, u1_.totp_secret AS totp_secret_56, u1_.totp_backup_codes AS totp_backup_codes_57, u1_.ap_id AS ap_id_58, u1_.ap_profile_id AS ap_profile_id_59, u1_.ap_public_url AS ap_public_url_60, u1_.ap_followers_url AS ap_followers_url_61, u1_.ap_inbox_url AS ap_inbox_url_62, u1_.ap_domain AS ap_domain_63, u1_.ap_preferred_username AS ap_preferred_username_64, u1_.ap_discoverable AS ap_discoverable_65, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_66, u1_.private_key AS private_key_67, u1_.public_key AS public_key_68, u1_.ap_fetched_at AS ap_fetched_at_69, u1_.ap_deleted_at AS ap_deleted_at_70, u1_.ap_timeout_at AS ap_timeout_at_71, u1_.visibility AS visibility_72, u1_.created_at AS created_at_73, e0_.user_id AS user_id_74, e0_.entry_id AS entry_id_75, e0_.magazine_id AS magazine_id_76, e0_.image_id AS image_id_77, e0_.parent_id AS parent_id_78, e0_.root_id AS root_id_79, u1_.avatar_id AS avatar_id_80, u1_.cover_id AS cover_id_81 FROM entry_comment e0_ INNER JOIN "user" u1_ ON e0_.user_id = u1_.id INNER JOIN entry e2_ ON e0_.entry_id = e2_.id INNER JOIN entry e3_ ON e0_.entry_id = e3_.id INNER JOIN magazine m4_ ON e2_.magazine_id = m4_.id WHERE e0_.visibility IN ('soft_deleted', 'visible', 'trashed') AND e2_.visibility = 'visible' AND e0_.user_id = 5863 AND m4_.is_adult = 0 AND e2_.is_adult = 0 ORDER BY e0_.favourite_count - e0_.down_votes DESC, e0_.created_at DESC, e0_.id DESC LIMIT 15;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.follower_id AS follower_id_3,
  t0.following_id AS following_id_4
FROM
  user_follow t0
WHERE
  t0.follower_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.follower_id AS follower_id_3, t0.following_id AS following_id_4 FROM user_follow t0 WHERE t0.follower_id = 5863 ORDER BY t0.created_at DESC;

SELECT
  COUNT(*)
FROM
  post t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM post t0 WHERE t0.user_id = 5863;

SELECT
  t0.slug AS slug_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.type AS type_5,
  t0.lang AS lang_6,
  t0.is_oc AS is_oc_7,
  t0.has_embed AS has_embed_8,
  t0.comment_count AS comment_count_9,
  t0.favourite_count AS favourite_count_10,
  t0.score AS score_11,
  t0.is_adult AS is_adult_12,
  t0.sticky AS sticky_13,
  t0.last_active AS last_active_14,
  t0.ip AS ip_15,
  t0.ada_amount AS ada_amount_16,
  t0.tags AS tags_17,
  t0.mentions AS mentions_18,
  t0.id AS id_19,
  t0.title_ts AS title_ts_20,
  t0.body_ts AS body_ts_21,
  t0.up_votes AS up_votes_22,
  t0.down_votes AS down_votes_23,
  t0.ranking AS ranking_24,
  t0.visibility AS visibility_25,
  t0.ap_id AS ap_id_26,
  t0.edited_at AS edited_at_27,
  t0.created_at AS created_at_28,
  t0.user_id AS user_id_29,
  t0.magazine_id AS magazine_id_30,
  t0.image_id AS image_id_31,
  t0.domain_id AS domain_id_32
FROM
  entry t0
WHERE
  t0.user_id = ?

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.user_id = 5863;

SELECT
  COUNT(*)
FROM
  entry_comment t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM entry_comment t0 WHERE t0.user_id = 5863;

SELECT
  count(e0_.id) AS sclr_0
FROM
  entry_comment e0_
  INNER JOIN "user" u1_ ON e0_.user_id = u1_.id
  INNER JOIN entry e2_ ON e0_.entry_id = e2_.id
  INNER JOIN entry e3_ ON e0_.entry_id = e3_.id
  INNER JOIN magazine m4_ ON e2_.magazine_id = m4_.id
WHERE
  e0_.visibility IN (?, ?, ?)
  AND e2_.visibility = ?
  AND e0_.user_id = ?
  AND m4_.is_adult = ?
  AND e2_.is_adult = ?
ORDER BY
  sclr_0 ASC

SELECT count(e0_.id) AS sclr_0 FROM entry_comment e0_ INNER JOIN "user" u1_ ON e0_.user_id = u1_.id INNER JOIN entry e2_ ON e0_.entry_id = e2_.id INNER JOIN entry e3_ ON e0_.entry_id = e3_.id INNER JOIN magazine m4_ ON e2_.magazine_id = m4_.id WHERE e0_.visibility IN ('soft_deleted', 'visible', 'trashed') AND e2_.visibility = 'visible' AND e0_.user_id = 5863 AND m4_.is_adult = 0 AND e2_.is_adult = 0 ORDER BY sclr_0 ASC;

(
  SELECT
    entry_id as id,
    created_at,
    'entry' AS type
  FROM
    entry_vote
  WHERE
    user_id = :userId
    AND choice = 1
)
UNION
  (
    SELECT
      comment_id as id,
      created_at,
      'entry_comment' AS type
    FROM
      entry_comment_vote
    WHERE
      user_id = :userId
      AND choice = 1
  )
UNION
  (
    SELECT
      post_id as id,
      created_at,
      'post' AS type
    FROM
      post_vote
    WHERE
      user_id = :userId
      AND choice = 1
  )
UNION
  (
    SELECT
      comment_id as id,
      created_at,
      'post_comment' AS type
    FROM
      post_comment_vote
    WHERE
      user_id = :userId
      AND choice = 1
  )
ORDER BY
  created_at DESC

(SELECT entry_id as id, created_at, 'entry' AS type FROM entry_vote WHERE user_id = 5863 AND choice = 1)
        UNION
        (SELECT comment_id as id, created_at, 'entry_comment' AS type FROM entry_comment_vote WHERE user_id = 5863 AND choice = 1)
        UNION
        (SELECT post_id as id, created_at, 'post' AS type FROM post_vote WHERE user_id = 5863 AND choice = 1)
        UNION
        (SELECT comment_id as id, created_at, 'post_comment' AS type FROM post_comment_vote WHERE user_id = 5863 AND choice = 1)
        ORDER BY created_at DESC;

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.is_adult AS is_adult_3,
  t0.favourite_count AS favourite_count_4,
  t0.score AS score_5,
  t0.last_active AS last_active_6,
  t0.ip AS ip_7,
  t0.tags AS tags_8,
  t0.mentions AS mentions_9,
  t0.id AS id_10,
  t0.body_ts AS body_ts_11,
  t0.up_votes AS up_votes_12,
  t0.down_votes AS down_votes_13,
  t0.visibility AS visibility_14,
  t0.ap_id AS ap_id_15,
  t0.edited_at AS edited_at_16,
  t0.created_at AS created_at_17,
  t0.user_id AS user_id_18,
  t0.entry_id AS entry_id_19,
  t0.magazine_id AS magazine_id_20,
  t0.image_id AS image_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23
FROM
  entry_comment t0
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (64781, 66072, 69072, 72839, 93133, 93135, 93333, 93532, 93636, 138458, 138453, 138767, 139629, 142767, 147989, 218314, 218062);

SELECT
  (
    SELECT
      SUM(
        (
          SELECT
            COUNT(id)
          FROM
            entry_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = 1
        ) * 2 - (
          SELECT
            COUNT(id)
          FROM
            entry_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = -1
        )
      )
  ) + (
    SELECT
      SUM(
        (
          SELECT
            COUNT(id)
          FROM
            entry_comment_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = 1
        ) * 2 - (
          SELECT
            COUNT(id)
          FROM
            entry_comment_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = -1
        )
      )
  ) + (
    SELECT
      SUM(
        (
          SELECT
            COUNT(id)
          FROM
            post_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = 1
        ) * 2 - (
          SELECT
            COUNT(id)
          FROM
            post_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = -1
        )
      )
  ) + (
    SELECT
      SUM(
        (
          SELECT
            COUNT(id)
          FROM
            post_comment_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = 1
        ) * 2 - (
          SELECT
            COUNT(id)
          FROM
            post_comment_vote
          WHERE
            author_id = :user
            AND user_id != :user
            AND choice = -1
        )
      )
  ) as total

SELECT
                    (SELECT SUM(
            (SELECT COUNT(id) FROM entry_vote WHERE author_id = 5863 AND user_id != 5863 AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM entry_vote WHERE author_id = 5863 AND user_id != 5863 AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM entry_comment_vote WHERE author_id = 5863 AND user_id != 5863 AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM entry_comment_vote WHERE author_id = 5863 AND user_id != 5863 AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM post_vote WHERE author_id = 5863 AND user_id != 5863 AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM post_vote WHERE author_id = 5863 AND user_id != 5863 AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM post_comment_vote WHERE author_id = 5863 AND user_id != 5863 AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM post_comment_vote WHERE author_id = 5863 AND user_id != 5863 AND choice = -1)
        )) as total;

SELECT
  COUNT(*)
FROM
  post_comment t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM post_comment t0 WHERE t0.user_id = 5863;