Symfony Profiler

Query Metrics

45 Database Queries

15 Different statements

177.81 ms Query time

0 Invalid entities

28 Cache hits

3 Cache misses

3 Cache puts

Queries

Group similar statements


SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id = ?
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.post_id AS post_id_6 FROM post_vote t0 WHERE (t0.choice = ? AND t0.post_id = ?) ORDER BY t0.created_at DESC
SELECT p0_.body AS body_0, p0_.lang AS lang_1, p0_.favourite_count AS favourite_count_2, p0_.score AS score_3, p0_.last_active AS last_active_4, p0_.ip AS ip_5, p0_.tags AS tags_6, p0_.mentions AS mentions_7, p0_.is_adult AS is_adult_8, p0_.update_mark AS update_mark_9, p0_.id AS id_10, p0_.body_ts AS body_ts_11, p0_.up_votes AS up_votes_12, p0_.down_votes AS down_votes_13, p0_.visibility AS visibility_14, p0_.ap_id AS ap_id_15, p0_.edited_at AS edited_at_16, p0_.created_at AS created_at_17, u1_.email AS email_18, u1_.username AS username_19, u1_.roles AS roles_20, u1_.followers_count AS followers_count_21, u1_.homepage AS homepage_22, u1_.about AS about_23, u1_.last_active AS last_active_24, u1_.marked_for_deletion_at AS marked_for_deletion_at_25, u1_.fields AS fields_26, u1_.oauth_github_id AS oauth_github_id_27, u1_.oauth_google_id AS oauth_google_id_28, u1_.oauth_facebook_id AS oauth_facebook_id_29, u1_.oauth_keycloak_id AS oauth_keycloak_id_30, u1_.hide_adult AS hide_adult_31, u1_.show_subscribed_users AS show_subscribed_users_32, u1_.show_subscribed_magazines AS show_subscribed_magazines_33, u1_.show_subscribed_domains AS show_subscribed_domains_34, u1_.preferred_languages AS preferred_languages_35, u1_.featured_magazines AS featured_magazines_36, u1_.show_profile_subscriptions AS show_profile_subscriptions_37, u1_.show_profile_followings AS show_profile_followings_38, u1_.mark_new_comments AS mark_new_comments_39, u1_.notify_on_new_entry AS notify_on_new_entry_40, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_41, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_42, u1_.notify_on_new_post AS notify_on_new_post_43, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_44, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_45, u1_.add_mentions_entries AS add_mentions_entries_46, u1_.add_mentions_posts AS add_mentions_posts_47, u1_.is_banned AS is_banned_48, u1_.is_verified AS is_verified_49, u1_.is_deleted AS is_deleted_50, u1_.is_bot AS is_bot_51, u1_.spam_protection AS spam_protection_52, u1_.custom_css AS custom_css_53, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_54, u1_.id AS id_55, u1_.password AS password_56, u1_.totp_secret AS totp_secret_57, u1_.totp_backup_codes AS totp_backup_codes_58, u1_.ap_id AS ap_id_59, u1_.ap_profile_id AS ap_profile_id_60, u1_.ap_public_url AS ap_public_url_61, u1_.ap_followers_url AS ap_followers_url_62, u1_.ap_inbox_url AS ap_inbox_url_63, u1_.ap_domain AS ap_domain_64, u1_.ap_preferred_username AS ap_preferred_username_65, u1_.ap_discoverable AS ap_discoverable_66, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_67, u1_.private_key AS private_key_68, u1_.public_key AS public_key_69, u1_.ap_fetched_at AS ap_fetched_at_70, u1_.ap_deleted_at AS ap_deleted_at_71, u1_.ap_timeout_at AS ap_timeout_at_72, u1_.visibility AS visibility_73, u1_.created_at AS created_at_74, p0_.user_id AS user_id_75, p0_.post_id AS post_id_76, p0_.magazine_id AS magazine_id_77, p0_.parent_id AS parent_id_78, p0_.root_id AS root_id_79, p0_.image_id AS image_id_80, u1_.avatar_id AS avatar_id_81, u1_.cover_id AS cover_id_82 FROM post_comment p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility IN (?, ?, ?) AND p0_.post_id = ? AND p0_.parent_id IS NULL ORDER BY p0_.up_votes DESC, p0_.created_at DESC, p0_.id DESC LIMIT 25
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?)
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?)
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?)
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?)
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?)
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?)
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = ?
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = ?
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT p0_.body AS body_0, p0_.lang AS lang_1, p0_.favourite_count AS favourite_count_2, p0_.score AS score_3, p0_.last_active AS last_active_4, p0_.ip AS ip_5, p0_.tags AS tags_6, p0_.mentions AS mentions_7, p0_.is_adult AS is_adult_8, p0_.update_mark AS update_mark_9, p0_.id AS id_10, p0_.body_ts AS body_ts_11, p0_.up_votes AS up_votes_12, p0_.down_votes AS down_votes_13, p0_.visibility AS visibility_14, p0_.ap_id AS ap_id_15, p0_.edited_at AS edited_at_16, p0_.created_at AS created_at_17, u1_.email AS email_18, u1_.username AS username_19, u1_.roles AS roles_20, u1_.followers_count AS followers_count_21, u1_.homepage AS homepage_22, u1_.about AS about_23, u1_.last_active AS last_active_24, u1_.marked_for_deletion_at AS marked_for_deletion_at_25, u1_.fields AS fields_26, u1_.oauth_github_id AS oauth_github_id_27, u1_.oauth_google_id AS oauth_google_id_28, u1_.oauth_facebook_id AS oauth_facebook_id_29, u1_.oauth_keycloak_id AS oauth_keycloak_id_30, u1_.hide_adult AS hide_adult_31, u1_.show_subscribed_users AS show_subscribed_users_32, u1_.show_subscribed_magazines AS show_subscribed_magazines_33, u1_.show_subscribed_domains AS show_subscribed_domains_34, u1_.preferred_languages AS preferred_languages_35, u1_.featured_magazines AS featured_magazines_36, u1_.show_profile_subscriptions AS show_profile_subscriptions_37, u1_.show_profile_followings AS show_profile_followings_38, u1_.mark_new_comments AS mark_new_comments_39, u1_.notify_on_new_entry AS notify_on_new_entry_40, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_41, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_42, u1_.notify_on_new_post AS notify_on_new_post_43, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_44, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_45, u1_.add_mentions_entries AS add_mentions_entries_46, u1_.add_mentions_posts AS add_mentions_posts_47, u1_.is_banned AS is_banned_48, u1_.is_verified AS is_verified_49, u1_.is_deleted AS is_deleted_50, u1_.is_bot AS is_bot_51, u1_.spam_protection AS spam_protection_52, u1_.custom_css AS custom_css_53, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_54, u1_.id AS id_55, u1_.password AS password_56, u1_.totp_secret AS totp_secret_57, u1_.totp_backup_codes AS totp_backup_codes_58, u1_.ap_id AS ap_id_59, u1_.ap_profile_id AS ap_profile_id_60, u1_.ap_public_url AS ap_public_url_61, u1_.ap_followers_url AS ap_followers_url_62, u1_.ap_inbox_url AS ap_inbox_url_63, u1_.ap_domain AS ap_domain_64, u1_.ap_preferred_username AS ap_preferred_username_65, u1_.ap_discoverable AS ap_discoverable_66, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_67, u1_.private_key AS private_key_68, u1_.public_key AS public_key_69, u1_.ap_fetched_at AS ap_fetched_at_70, u1_.ap_deleted_at AS ap_deleted_at_71, u1_.ap_timeout_at AS ap_timeout_at_72, u1_.visibility AS visibility_73, u1_.created_at AS created_at_74 FROM post_comment p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility IN (?, ?, ?) AND p0_.post_id = ? AND p0_.parent_id IS NULL ORDER BY p0_.up_votes DESC, p0_.created_at DESC, p0_.id DESC) dctrn_result) dctrn_table
SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0.is_owner = ? AND t0.magazine_id = ?)
SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = ?
SELECT COUNT(*) FROM magazine_log t0 WHERE t0.magazine_id = ? AND t0.log_type IN ('entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban')

#▲	Time	Info
1	3.07 ms	SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id = ? Parameters: [`"286"`] View formatted query View runnable query Explain query SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id = ? SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id = '286';
2	3.60 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.post_id AS post_id_6 FROM post_vote t0 WHERE (t0.choice = ? AND t0.post_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 286`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.post_id AS post_id_6 FROM post_vote t0 WHERE ( t0.choice = ? AND t0.post_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.post_id AS post_id_6 FROM post_vote t0 WHERE (t0.choice = 1 AND t0.post_id = 286) ORDER BY t0.created_at DESC;
3	10.34 ms	SELECT p0_.body AS body_0, p0_.lang AS lang_1, p0_.favourite_count AS favourite_count_2, p0_.score AS score_3, p0_.last_active AS last_active_4, p0_.ip AS ip_5, p0_.tags AS tags_6, p0_.mentions AS mentions_7, p0_.is_adult AS is_adult_8, p0_.update_mark AS update_mark_9, p0_.id AS id_10, p0_.body_ts AS body_ts_11, p0_.up_votes AS up_votes_12, p0_.down_votes AS down_votes_13, p0_.visibility AS visibility_14, p0_.ap_id AS ap_id_15, p0_.edited_at AS edited_at_16, p0_.created_at AS created_at_17, u1_.email AS email_18, u1_.username AS username_19, u1_.roles AS roles_20, u1_.followers_count AS followers_count_21, u1_.homepage AS homepage_22, u1_.about AS about_23, u1_.last_active AS last_active_24, u1_.marked_for_deletion_at AS marked_for_deletion_at_25, u1_.fields AS fields_26, u1_.oauth_github_id AS oauth_github_id_27, u1_.oauth_google_id AS oauth_google_id_28, u1_.oauth_facebook_id AS oauth_facebook_id_29, u1_.oauth_keycloak_id AS oauth_keycloak_id_30, u1_.hide_adult AS hide_adult_31, u1_.show_subscribed_users AS show_subscribed_users_32, u1_.show_subscribed_magazines AS show_subscribed_magazines_33, u1_.show_subscribed_domains AS show_subscribed_domains_34, u1_.preferred_languages AS preferred_languages_35, u1_.featured_magazines AS featured_magazines_36, u1_.show_profile_subscriptions AS show_profile_subscriptions_37, u1_.show_profile_followings AS show_profile_followings_38, u1_.mark_new_comments AS mark_new_comments_39, u1_.notify_on_new_entry AS notify_on_new_entry_40, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_41, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_42, u1_.notify_on_new_post AS notify_on_new_post_43, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_44, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_45, u1_.add_mentions_entries AS add_mentions_entries_46, u1_.add_mentions_posts AS add_mentions_posts_47, u1_.is_banned AS is_banned_48, u1_.is_verified AS is_verified_49, u1_.is_deleted AS is_deleted_50, u1_.is_bot AS is_bot_51, u1_.spam_protection AS spam_protection_52, u1_.custom_css AS custom_css_53, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_54, u1_.id AS id_55, u1_.password AS password_56, u1_.totp_secret AS totp_secret_57, u1_.totp_backup_codes AS totp_backup_codes_58, u1_.ap_id AS ap_id_59, u1_.ap_profile_id AS ap_profile_id_60, u1_.ap_public_url AS ap_public_url_61, u1_.ap_followers_url AS ap_followers_url_62, u1_.ap_inbox_url AS ap_inbox_url_63, u1_.ap_domain AS ap_domain_64, u1_.ap_preferred_username AS ap_preferred_username_65, u1_.ap_discoverable AS ap_discoverable_66, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_67, u1_.private_key AS private_key_68, u1_.public_key AS public_key_69, u1_.ap_fetched_at AS ap_fetched_at_70, u1_.ap_deleted_at AS ap_deleted_at_71, u1_.ap_timeout_at AS ap_timeout_at_72, u1_.visibility AS visibility_73, u1_.created_at AS created_at_74, p0_.user_id AS user_id_75, p0_.post_id AS post_id_76, p0_.magazine_id AS magazine_id_77, p0_.parent_id AS parent_id_78, p0_.root_id AS root_id_79, p0_.image_id AS image_id_80, u1_.avatar_id AS avatar_id_81, u1_.cover_id AS cover_id_82 FROM post_comment p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility IN (?, ?, ?) AND p0_.post_id = ? AND p0_.parent_id IS NULL ORDER BY p0_.up_votes DESC, p0_.created_at DESC, p0_.id DESC LIMIT 25 Parameters: [`"soft_deleted" "visible" "trashed" 286`] View formatted query View runnable query Explain query SELECT p0_.body AS body_0, p0_.lang AS lang_1, p0_.favourite_count AS favourite_count_2, p0_.score AS score_3, p0_.last_active AS last_active_4, p0_.ip AS ip_5, p0_.tags AS tags_6, p0_.mentions AS mentions_7, p0_.is_adult AS is_adult_8, p0_.update_mark AS update_mark_9, p0_.id AS id_10, p0_.body_ts AS body_ts_11, p0_.up_votes AS up_votes_12, p0_.down_votes AS down_votes_13, p0_.visibility AS visibility_14, p0_.ap_id AS ap_id_15, p0_.edited_at AS edited_at_16, p0_.created_at AS created_at_17, u1_.email AS email_18, u1_.username AS username_19, u1_.roles AS roles_20, u1_.followers_count AS followers_count_21, u1_.homepage AS homepage_22, u1_.about AS about_23, u1_.last_active AS last_active_24, u1_.marked_for_deletion_at AS marked_for_deletion_at_25, u1_.fields AS fields_26, u1_.oauth_github_id AS oauth_github_id_27, u1_.oauth_google_id AS oauth_google_id_28, u1_.oauth_facebook_id AS oauth_facebook_id_29, u1_.oauth_keycloak_id AS oauth_keycloak_id_30, u1_.hide_adult AS hide_adult_31, u1_.show_subscribed_users AS show_subscribed_users_32, u1_.show_subscribed_magazines AS show_subscribed_magazines_33, u1_.show_subscribed_domains AS show_subscribed_domains_34, u1_.preferred_languages AS preferred_languages_35, u1_.featured_magazines AS featured_magazines_36, u1_.show_profile_subscriptions AS show_profile_subscriptions_37, u1_.show_profile_followings AS show_profile_followings_38, u1_.mark_new_comments AS mark_new_comments_39, u1_.notify_on_new_entry AS notify_on_new_entry_40, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_41, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_42, u1_.notify_on_new_post AS notify_on_new_post_43, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_44, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_45, u1_.add_mentions_entries AS add_mentions_entries_46, u1_.add_mentions_posts AS add_mentions_posts_47, u1_.is_banned AS is_banned_48, u1_.is_verified AS is_verified_49, u1_.is_deleted AS is_deleted_50, u1_.is_bot AS is_bot_51, u1_.spam_protection AS spam_protection_52, u1_.custom_css AS custom_css_53, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_54, u1_.id AS id_55, u1_.password AS password_56, u1_.totp_secret AS totp_secret_57, u1_.totp_backup_codes AS totp_backup_codes_58, u1_.ap_id AS ap_id_59, u1_.ap_profile_id AS ap_profile_id_60, u1_.ap_public_url AS ap_public_url_61, u1_.ap_followers_url AS ap_followers_url_62, u1_.ap_inbox_url AS ap_inbox_url_63, u1_.ap_domain AS ap_domain_64, u1_.ap_preferred_username AS ap_preferred_username_65, u1_.ap_discoverable AS ap_discoverable_66, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_67, u1_.private_key AS private_key_68, u1_.public_key AS public_key_69, u1_.ap_fetched_at AS ap_fetched_at_70, u1_.ap_deleted_at AS ap_deleted_at_71, u1_.ap_timeout_at AS ap_timeout_at_72, u1_.visibility AS visibility_73, u1_.created_at AS created_at_74, p0_.user_id AS user_id_75, p0_.post_id AS post_id_76, p0_.magazine_id AS magazine_id_77, p0_.parent_id AS parent_id_78, p0_.root_id AS root_id_79, p0_.image_id AS image_id_80, u1_.avatar_id AS avatar_id_81, u1_.cover_id AS cover_id_82 FROM post_comment p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility IN (?, ?, ?) AND p0_.post_id = ? AND p0_.parent_id IS NULL ORDER BY p0_.up_votes DESC, p0_.created_at DESC, p0_.id DESC LIMIT 25 SELECT p0_.body AS body_0, p0_.lang AS lang_1, p0_.favourite_count AS favourite_count_2, p0_.score AS score_3, p0_.last_active AS last_active_4, p0_.ip AS ip_5, p0_.tags AS tags_6, p0_.mentions AS mentions_7, p0_.is_adult AS is_adult_8, p0_.update_mark AS update_mark_9, p0_.id AS id_10, p0_.body_ts AS body_ts_11, p0_.up_votes AS up_votes_12, p0_.down_votes AS down_votes_13, p0_.visibility AS visibility_14, p0_.ap_id AS ap_id_15, p0_.edited_at AS edited_at_16, p0_.created_at AS created_at_17, u1_.email AS email_18, u1_.username AS username_19, u1_.roles AS roles_20, u1_.followers_count AS followers_count_21, u1_.homepage AS homepage_22, u1_.about AS about_23, u1_.last_active AS last_active_24, u1_.marked_for_deletion_at AS marked_for_deletion_at_25, u1_.fields AS fields_26, u1_.oauth_github_id AS oauth_github_id_27, u1_.oauth_google_id AS oauth_google_id_28, u1_.oauth_facebook_id AS oauth_facebook_id_29, u1_.oauth_keycloak_id AS oauth_keycloak_id_30, u1_.hide_adult AS hide_adult_31, u1_.show_subscribed_users AS show_subscribed_users_32, u1_.show_subscribed_magazines AS show_subscribed_magazines_33, u1_.show_subscribed_domains AS show_subscribed_domains_34, u1_.preferred_languages AS preferred_languages_35, u1_.featured_magazines AS featured_magazines_36, u1_.show_profile_subscriptions AS show_profile_subscriptions_37, u1_.show_profile_followings AS show_profile_followings_38, u1_.mark_new_comments AS mark_new_comments_39, u1_.notify_on_new_entry AS notify_on_new_entry_40, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_41, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_42, u1_.notify_on_new_post AS notify_on_new_post_43, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_44, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_45, u1_.add_mentions_entries AS add_mentions_entries_46, u1_.add_mentions_posts AS add_mentions_posts_47, u1_.is_banned AS is_banned_48, u1_.is_verified AS is_verified_49, u1_.is_deleted AS is_deleted_50, u1_.is_bot AS is_bot_51, u1_.spam_protection AS spam_protection_52, u1_.custom_css AS custom_css_53, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_54, u1_.id AS id_55, u1_.password AS password_56, u1_.totp_secret AS totp_secret_57, u1_.totp_backup_codes AS totp_backup_codes_58, u1_.ap_id AS ap_id_59, u1_.ap_profile_id AS ap_profile_id_60, u1_.ap_public_url AS ap_public_url_61, u1_.ap_followers_url AS ap_followers_url_62, u1_.ap_inbox_url AS ap_inbox_url_63, u1_.ap_domain AS ap_domain_64, u1_.ap_preferred_username AS ap_preferred_username_65, u1_.ap_discoverable AS ap_discoverable_66, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_67, u1_.private_key AS private_key_68, u1_.public_key AS public_key_69, u1_.ap_fetched_at AS ap_fetched_at_70, u1_.ap_deleted_at AS ap_deleted_at_71, u1_.ap_timeout_at AS ap_timeout_at_72, u1_.visibility AS visibility_73, u1_.created_at AS created_at_74, p0_.user_id AS user_id_75, p0_.post_id AS post_id_76, p0_.magazine_id AS magazine_id_77, p0_.parent_id AS parent_id_78, p0_.root_id AS root_id_79, p0_.image_id AS image_id_80, u1_.avatar_id AS avatar_id_81, u1_.cover_id AS cover_id_82 FROM post_comment p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility IN ('soft_deleted', 'visible', 'trashed') AND p0_.post_id = 286 AND p0_.parent_id IS NULL ORDER BY p0_.up_votes DESC, p0_.created_at DESC, p0_.id DESC LIMIT 25;
4	5.24 ms	SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?) Parameters: [`628 625 622 615 610 608 607`] View formatted query View runnable query Explain query SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?) SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (628, 625, 622, 615, 610, 608, 607);
5	10.83 ms	SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?) Parameters: [`623 611 609 616 629`] View formatted query View runnable query Explain query SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?) SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (623, 611, 609, 616, 629);
6	3.61 ms	SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?) Parameters: [`618 612 617 632 631 630`] View formatted query View runnable query Explain query SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?) SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (618, 612, 617, 632, 631, 630);
7	1.19 ms	SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?) Parameters: [`614 613 624 619 633 635`] View formatted query View runnable query Explain query SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?) SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (614, 613, 624, 619, 633, 635);
8	2.45 ms	SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?) Parameters: [`620 627 634 636`] View formatted query View runnable query Explain query SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?) SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (620, 627, 634, 636);
9	8.58 ms	SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?) Parameters: [`626 621`] View formatted query View runnable query Explain query SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?, ?) SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (626, 621);
10	13.66 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 628`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 628) ORDER BY t0.created_at DESC;
11	1.26 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 625`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 625) ORDER BY t0.created_at DESC;
12	1.94 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 629`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 629) ORDER BY t0.created_at DESC;
13	1.00 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 630`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 630) ORDER BY t0.created_at DESC;
14	2.31 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 633`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 633) ORDER BY t0.created_at DESC;
15	7.20 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 622`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 622) ORDER BY t0.created_at DESC;
16	5.43 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 615`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 615) ORDER BY t0.created_at DESC;
17	5.35 ms	SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ? Parameters: [`16916`] View formatted query View runnable query Explain query SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ? SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = 16916;
18	1.28 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 610`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 610) ORDER BY t0.created_at DESC;
19	5.21 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 616`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 616) ORDER BY t0.created_at DESC;
20	1.39 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 617`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 617) ORDER BY t0.created_at DESC;
21	0.97 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 624`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 624) ORDER BY t0.created_at DESC;
22	5.67 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 627`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 627) ORDER BY t0.created_at DESC;
23	3.37 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 632`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 632) ORDER BY t0.created_at DESC;
24	9.89 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 608`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 608) ORDER BY t0.created_at DESC;
25	2.46 ms	SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = ? Parameters: [`34817`] View formatted query View runnable query Explain query SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = ? SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = 34817;
26	1.55 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 611`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 611) ORDER BY t0.created_at DESC;
27	8.04 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 612`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 612) ORDER BY t0.created_at DESC;
28	1.78 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 614`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 614) ORDER BY t0.created_at DESC;
29	4.15 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 620`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 620) ORDER BY t0.created_at DESC;
30	4.39 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 626`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 626) ORDER BY t0.created_at DESC;
31	7.68 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 621`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 621) ORDER BY t0.created_at DESC;
32	3.21 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 613`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 613) ORDER BY t0.created_at DESC;
33	1.07 ms	SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = ? Parameters: [`49449`] View formatted query View runnable query Explain query SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = ? SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = 49449;
34	3.04 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 609`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 609) ORDER BY t0.created_at DESC;
35	0.57 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 618`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 618) ORDER BY t0.created_at DESC;
36	0.52 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 619`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 619) ORDER BY t0.created_at DESC;
37	17.33 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 607`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 607) ORDER BY t0.created_at DESC;
38	0.66 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 623`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 623) ORDER BY t0.created_at DESC;
39	0.60 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 631`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 631) ORDER BY t0.created_at DESC;
40	0.57 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 635`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 635) ORDER BY t0.created_at DESC;
41	0.62 ms	SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = ? AND t0.comment_id = ?) ORDER BY t0.created_at DESC Parameters: [`1 636`] View formatted query View runnable query Explain query SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE ( t0.choice = ? AND t0.comment_id = ? ) ORDER BY t0.created_at DESC SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 636) ORDER BY t0.created_at DESC;
42	2.06 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT p0_.body AS body_0, p0_.lang AS lang_1, p0_.favourite_count AS favourite_count_2, p0_.score AS score_3, p0_.last_active AS last_active_4, p0_.ip AS ip_5, p0_.tags AS tags_6, p0_.mentions AS mentions_7, p0_.is_adult AS is_adult_8, p0_.update_mark AS update_mark_9, p0_.id AS id_10, p0_.body_ts AS body_ts_11, p0_.up_votes AS up_votes_12, p0_.down_votes AS down_votes_13, p0_.visibility AS visibility_14, p0_.ap_id AS ap_id_15, p0_.edited_at AS edited_at_16, p0_.created_at AS created_at_17, u1_.email AS email_18, u1_.username AS username_19, u1_.roles AS roles_20, u1_.followers_count AS followers_count_21, u1_.homepage AS homepage_22, u1_.about AS about_23, u1_.last_active AS last_active_24, u1_.marked_for_deletion_at AS marked_for_deletion_at_25, u1_.fields AS fields_26, u1_.oauth_github_id AS oauth_github_id_27, u1_.oauth_google_id AS oauth_google_id_28, u1_.oauth_facebook_id AS oauth_facebook_id_29, u1_.oauth_keycloak_id AS oauth_keycloak_id_30, u1_.hide_adult AS hide_adult_31, u1_.show_subscribed_users AS show_subscribed_users_32, u1_.show_subscribed_magazines AS show_subscribed_magazines_33, u1_.show_subscribed_domains AS show_subscribed_domains_34, u1_.preferred_languages AS preferred_languages_35, u1_.featured_magazines AS featured_magazines_36, u1_.show_profile_subscriptions AS show_profile_subscriptions_37, u1_.show_profile_followings AS show_profile_followings_38, u1_.mark_new_comments AS mark_new_comments_39, u1_.notify_on_new_entry AS notify_on_new_entry_40, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_41, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_42, u1_.notify_on_new_post AS notify_on_new_post_43, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_44, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_45, u1_.add_mentions_entries AS add_mentions_entries_46, u1_.add_mentions_posts AS add_mentions_posts_47, u1_.is_banned AS is_banned_48, u1_.is_verified AS is_verified_49, u1_.is_deleted AS is_deleted_50, u1_.is_bot AS is_bot_51, u1_.spam_protection AS spam_protection_52, u1_.custom_css AS custom_css_53, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_54, u1_.id AS id_55, u1_.password AS password_56, u1_.totp_secret AS totp_secret_57, u1_.totp_backup_codes AS totp_backup_codes_58, u1_.ap_id AS ap_id_59, u1_.ap_profile_id AS ap_profile_id_60, u1_.ap_public_url AS ap_public_url_61, u1_.ap_followers_url AS ap_followers_url_62, u1_.ap_inbox_url AS ap_inbox_url_63, u1_.ap_domain AS ap_domain_64, u1_.ap_preferred_username AS ap_preferred_username_65, u1_.ap_discoverable AS ap_discoverable_66, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_67, u1_.private_key AS private_key_68, u1_.public_key AS public_key_69, u1_.ap_fetched_at AS ap_fetched_at_70, u1_.ap_deleted_at AS ap_deleted_at_71, u1_.ap_timeout_at AS ap_timeout_at_72, u1_.visibility AS visibility_73, u1_.created_at AS created_at_74 FROM post_comment p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility IN (?, ?, ?) AND p0_.post_id = ? AND p0_.parent_id IS NULL ORDER BY p0_.up_votes DESC, p0_.created_at DESC, p0_.id DESC) dctrn_result) dctrn_table Parameters: [`"soft_deleted" "visible" "trashed" 286`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_10 FROM ( SELECT p0_.body AS body_0, p0_.lang AS lang_1, p0_.favourite_count AS favourite_count_2, p0_.score AS score_3, p0_.last_active AS last_active_4, p0_.ip AS ip_5, p0_.tags AS tags_6, p0_.mentions AS mentions_7, p0_.is_adult AS is_adult_8, p0_.update_mark AS update_mark_9, p0_.id AS id_10, p0_.body_ts AS body_ts_11, p0_.up_votes AS up_votes_12, p0_.down_votes AS down_votes_13, p0_.visibility AS visibility_14, p0_.ap_id AS ap_id_15, p0_.edited_at AS edited_at_16, p0_.created_at AS created_at_17, u1_.email AS email_18, u1_.username AS username_19, u1_.roles AS roles_20, u1_.followers_count AS followers_count_21, u1_.homepage AS homepage_22, u1_.about AS about_23, u1_.last_active AS last_active_24, u1_.marked_for_deletion_at AS marked_for_deletion_at_25, u1_.fields AS fields_26, u1_.oauth_github_id AS oauth_github_id_27, u1_.oauth_google_id AS oauth_google_id_28, u1_.oauth_facebook_id AS oauth_facebook_id_29, u1_.oauth_keycloak_id AS oauth_keycloak_id_30, u1_.hide_adult AS hide_adult_31, u1_.show_subscribed_users AS show_subscribed_users_32, u1_.show_subscribed_magazines AS show_subscribed_magazines_33, u1_.show_subscribed_domains AS show_subscribed_domains_34, u1_.preferred_languages AS preferred_languages_35, u1_.featured_magazines AS featured_magazines_36, u1_.show_profile_subscriptions AS show_profile_subscriptions_37, u1_.show_profile_followings AS show_profile_followings_38, u1_.mark_new_comments AS mark_new_comments_39, u1_.notify_on_new_entry AS notify_on_new_entry_40, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_41, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_42, u1_.notify_on_new_post AS notify_on_new_post_43, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_44, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_45, u1_.add_mentions_entries AS add_mentions_entries_46, u1_.add_mentions_posts AS add_mentions_posts_47, u1_.is_banned AS is_banned_48, u1_.is_verified AS is_verified_49, u1_.is_deleted AS is_deleted_50, u1_.is_bot AS is_bot_51, u1_.spam_protection AS spam_protection_52, u1_.custom_css AS custom_css_53, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_54, u1_.id AS id_55, u1_.password AS password_56, u1_.totp_secret AS totp_secret_57, u1_.totp_backup_codes AS totp_backup_codes_58, u1_.ap_id AS ap_id_59, u1_.ap_profile_id AS ap_profile_id_60, u1_.ap_public_url AS ap_public_url_61, u1_.ap_followers_url AS ap_followers_url_62, u1_.ap_inbox_url AS ap_inbox_url_63, u1_.ap_domain AS ap_domain_64, u1_.ap_preferred_username AS ap_preferred_username_65, u1_.ap_discoverable AS ap_discoverable_66, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_67, u1_.private_key AS private_key_68, u1_.public_key AS public_key_69, u1_.ap_fetched_at AS ap_fetched_at_70, u1_.ap_deleted_at AS ap_deleted_at_71, u1_.ap_timeout_at AS ap_timeout_at_72, u1_.visibility AS visibility_73, u1_.created_at AS created_at_74 FROM post_comment p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility IN (?, ?, ?) AND p0_.post_id = ? AND p0_.parent_id IS NULL ORDER BY p0_.up_votes DESC, p0_.created_at DESC, p0_.id DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT p0_.body AS body_0, p0_.lang AS lang_1, p0_.favourite_count AS favourite_count_2, p0_.score AS score_3, p0_.last_active AS last_active_4, p0_.ip AS ip_5, p0_.tags AS tags_6, p0_.mentions AS mentions_7, p0_.is_adult AS is_adult_8, p0_.update_mark AS update_mark_9, p0_.id AS id_10, p0_.body_ts AS body_ts_11, p0_.up_votes AS up_votes_12, p0_.down_votes AS down_votes_13, p0_.visibility AS visibility_14, p0_.ap_id AS ap_id_15, p0_.edited_at AS edited_at_16, p0_.created_at AS created_at_17, u1_.email AS email_18, u1_.username AS username_19, u1_.roles AS roles_20, u1_.followers_count AS followers_count_21, u1_.homepage AS homepage_22, u1_.about AS about_23, u1_.last_active AS last_active_24, u1_.marked_for_deletion_at AS marked_for_deletion_at_25, u1_.fields AS fields_26, u1_.oauth_github_id AS oauth_github_id_27, u1_.oauth_google_id AS oauth_google_id_28, u1_.oauth_facebook_id AS oauth_facebook_id_29, u1_.oauth_keycloak_id AS oauth_keycloak_id_30, u1_.hide_adult AS hide_adult_31, u1_.show_subscribed_users AS show_subscribed_users_32, u1_.show_subscribed_magazines AS show_subscribed_magazines_33, u1_.show_subscribed_domains AS show_subscribed_domains_34, u1_.preferred_languages AS preferred_languages_35, u1_.featured_magazines AS featured_magazines_36, u1_.show_profile_subscriptions AS show_profile_subscriptions_37, u1_.show_profile_followings AS show_profile_followings_38, u1_.mark_new_comments AS mark_new_comments_39, u1_.notify_on_new_entry AS notify_on_new_entry_40, u1_.notify_on_new_entry_reply AS notify_on_new_entry_reply_41, u1_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_42, u1_.notify_on_new_post AS notify_on_new_post_43, u1_.notify_on_new_post_reply AS notify_on_new_post_reply_44, u1_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_45, u1_.add_mentions_entries AS add_mentions_entries_46, u1_.add_mentions_posts AS add_mentions_posts_47, u1_.is_banned AS is_banned_48, u1_.is_verified AS is_verified_49, u1_.is_deleted AS is_deleted_50, u1_.is_bot AS is_bot_51, u1_.spam_protection AS spam_protection_52, u1_.custom_css AS custom_css_53, u1_.ignore_magazines_custom_css AS ignore_magazines_custom_css_54, u1_.id AS id_55, u1_.password AS password_56, u1_.totp_secret AS totp_secret_57, u1_.totp_backup_codes AS totp_backup_codes_58, u1_.ap_id AS ap_id_59, u1_.ap_profile_id AS ap_profile_id_60, u1_.ap_public_url AS ap_public_url_61, u1_.ap_followers_url AS ap_followers_url_62, u1_.ap_inbox_url AS ap_inbox_url_63, u1_.ap_domain AS ap_domain_64, u1_.ap_preferred_username AS ap_preferred_username_65, u1_.ap_discoverable AS ap_discoverable_66, u1_.ap_manually_approves_followers AS ap_manually_approves_followers_67, u1_.private_key AS private_key_68, u1_.public_key AS public_key_69, u1_.ap_fetched_at AS ap_fetched_at_70, u1_.ap_deleted_at AS ap_deleted_at_71, u1_.ap_timeout_at AS ap_timeout_at_72, u1_.visibility AS visibility_73, u1_.created_at AS created_at_74 FROM post_comment p0_ INNER JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.visibility IN ('soft_deleted', 'visible', 'trashed') AND p0_.post_id = 286 AND p0_.parent_id IS NULL ORDER BY p0_.up_votes DESC, p0_.created_at DESC, p0_.id DESC) dctrn_result) dctrn_table;
43	0.97 ms	SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0.is_owner = ? AND t0.magazine_id = ?) Parameters: [`1 73`] View formatted query View runnable query Explain query SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE ( t0.is_owner = ? AND t0.magazine_id = ? ) SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0.is_owner = 1 AND t0.magazine_id = 73);
44	0.50 ms	SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = ? Parameters: [`73`] View formatted query View runnable query Explain query SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = ? SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = 73;
45	1.20 ms	SELECT COUNT() FROM magazine_log t0 WHERE t0.magazine_id = ? AND t0.log_type IN ('entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban') Parameters: [`73`] View formatted query View runnable query Explain query SELECT COUNT() FROM magazine_log t0 WHERE t0.magazine_id = ? AND t0.log_type IN ( 'entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban' ) SELECT COUNT(*) FROM magazine_log t0 WHERE t0.magazine_id = 73 AND t0.log_type IN ('entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

28 Hits

3 Misses

3 Puts

Number of cache hits

Region	Hits
app_entity_settings	16
app_entity_magazine	4
app_entity_user	4
app_entity_image	4

Number of cache misses

Region	Misses
app_entity_image	1
app_entity_user	2

Number of cache puts

Region	Puts
app_entity_image	1
app_entity_user	2

Entities Mapping

Class	Mapping errors
App\Entity\Settings	No errors.
App\Entity\Magazine	No errors.
App\Entity\Image	No errors.
App\Entity\Moderator	No errors.
App\Entity\MagazineOwnershipRequest	No errors.
App\Entity\ModeratorRequest	No errors.
App\Entity\Entry	No errors.
App\Entity\Post	No errors.
App\Entity\MagazineSubscription	No errors.
App\Entity\MagazineBan	No errors.
App\Entity\Report	No errors.
App\Entity\Badge	No errors.
App\Entity\MagazineLog	No errors.
App\Entity\Award	No errors.
App\Entity\CategoryMagazine	No errors.
App\Entity\User	No errors.
App\Entity\PostComment	No errors.
App\Entity\Vote	No errors.
App\Entity\PostVote	No errors.
App\Entity\PostReport	No errors.
App\Entity\Favourite	No errors.
App\Entity\PostFavourite	No errors.
App\Entity\Notification	No errors.
App\Entity\PostCreatedNotification	No errors.
App\Entity\EntryVote	No errors.
App\Entity\EntryComment	No errors.
App\Entity\EntryCommentVote	No errors.
App\Entity\PostCommentVote	No errors.
App\Entity\DomainSubscription	No errors.
App\Entity\UserFollow	No errors.
App\Entity\UserBlock	No errors.
App\Entity\MagazineBlock	No errors.
App\Entity\DomainBlock	No errors.
App\Entity\CategorySubscription	No errors.
App\Entity\Category	No errors.
App\Entity\OAuth2UserConsent	No errors.
App\Entity\PostCommentReport	No errors.
App\Entity\PostCommentFavourite	No errors.
App\Entity\PostCommentCreatedNotification	No errors.

Symfony Profiler

GET https://kbin.spritesserver.nl/m/linux@lemmy.ml/p/286/Run-command-as-not-root-Hi-everyone-At-work-I-have

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Number of cache misses

Number of cache puts

Entities Mapping