Query Metrics
141
Database Queries
18
Different statements
333.78 ms
Query time
0
Invalid entities
34
Cache hits
61
Cache misses
61
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 9.39 ms |
SELECT p0_.slug AS slug_0, p0_.body AS body_1, p0_.lang AS lang_2, p0_.comment_count AS comment_count_3, p0_.favourite_count AS favourite_count_4, p0_.score AS score_5, p0_.is_adult AS is_adult_6, p0_.sticky AS sticky_7, p0_.last_active AS last_active_8, p0_.ip AS ip_9, p0_.tags AS tags_10, p0_.mentions AS mentions_11, p0_.id AS id_12, p0_.body_ts AS body_ts_13, p0_.up_votes AS up_votes_14, p0_.down_votes AS down_votes_15, p0_.ranking AS ranking_16, p0_.visibility AS visibility_17, p0_.ap_id AS ap_id_18, p0_.edited_at AS edited_at_19, p0_.created_at AS created_at_20, p0_.user_id AS user_id_21, p0_.magazine_id AS magazine_id_22, p0_.image_id AS image_id_23 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON p0_.user_id = u2_.id WHERE p0_.visibility = ? AND m1_.visibility = ? AND p0_.magazine_id = ? AND m1_.is_adult = ? AND p0_.is_adult = ? ORDER BY p0_.sticky DESC, p0_.score DESC, p0_.created_at DESC, p0_.id DESC LIMIT 15
Parameters:
[ "visible" "visible" 19 0 0 ] |
2 | 1.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:
[
14577
]
|
3 | 0.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.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 107 ] |
4 | 4.75 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:
[
5471
]
|
5 | 0.78 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:
[
2667
]
|
6 | 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:
[
11157
]
|
7 | 2.03 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
107
]
|
8 | 0.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:
[ 240 227 196 241 208 242 226 228 ] |
9 | 0.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.post_id = ? ORDER BY t0.created_at ASC
Parameters:
[
107
]
|
10 | 1.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 226 ] |
11 | 0.42 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 228 ] |
12 | 0.77 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:
[
11130
]
|
13 | 4.03 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 114 ] |
14 | 1.23 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:
[
5443
]
|
15 | 1.23 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:
[
16551
]
|
16 | 1.01 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
114
]
|
17 | 0.62 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:
[
219
]
|
18 | 0.65 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.post_id = ? ORDER BY t0.created_at ASC
Parameters:
[
114
]
|
19 | 0.98 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:
[
7223
]
|
20 | 1.00 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:
[
2369
]
|
21 | 5.59 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 219 ] |
22 | 0.63 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 109 ] |
23 | 7.41 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:
[
18087
]
|
24 | 0.77 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
109
]
|
25 | 0.55 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:
[ 197 198 201 ] |
26 | 0.81 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:
[
6810
]
|
27 | 0.91 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 197 ] |
28 | 0.74 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:
[
6091
]
|
29 | 1.06 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 198 ] |
30 | 0.59 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 102 ] |
31 | 0.83 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:
[
11779
]
|
32 | 0.85 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
102
]
|
33 | 0.82 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:
[ 186 204 205 206 ] |
34 | 1.23 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:
[
14421
]
|
35 | 0.51 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 186 ] |
36 | 2.57 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:
[
12217
]
|
37 | 0.79 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:
[
11940
]
|
38 | 0.67 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:
[
21693
]
|
39 | 0.58 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 204 ] |
40 | 0.80 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:
[
6480
]
|
41 | 2.65 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 135 ] |
42 | 0.67 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
135
]
|
43 | 0.46 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:
[ 272 273 286 ] |
44 | 0.50 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.post_id = ? ORDER BY t0.created_at ASC
Parameters:
[
135
]
|
45 | 2.95 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 273 ] |
46 | 1.27 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:
[
6352
]
|
47 | 0.65 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 286 ] |
48 | 1.26 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:
[
6222
]
|
49 | 2.22 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:
[
1908
]
|
50 | 9.17 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 122 ] |
51 | 13.29 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:
[
9750
]
|
52 | 0.76 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
122
]
|
53 | 0.44 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:
[ 236 237 238 ] |
54 | 1.79 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.post_id = ? ORDER BY t0.created_at ASC
Parameters:
[
122
]
|
55 | 0.69 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 237 ] |
56 | 0.91 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:
[
867
]
|
57 | 0.74 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:
[
2911
]
|
58 | 2.95 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 238 ] |
59 | 1.00 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:
[
11161
]
|
60 | 0.71 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:
[
3883
]
|
61 | 1.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 119 ] |
62 | 1.39 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:
[
15202
]
|
63 | 0.98 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:
[
13854
]
|
64 | 0.75 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
119
]
|
65 | 0.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:
[ 229 230 231 ] |
66 | 0.75 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:
[
436
]
|
67 | 0.85 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:
[
909
]
|
68 | 1.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 230 ] |
69 | 2.89 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:
[
233
]
|
70 | 0.50 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 229 ] |
71 | 26.87 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:
[
15874
]
|
72 | 3.18 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:
[
12019
]
|
73 | 2.92 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 75 ] |
74 | 3.19 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:
[
12211
]
|
75 | 0.73 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
75
]
|
76 | 0.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:
[ 154 152 153 ] |
77 | 0.89 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:
[
8705
]
|
78 | 0.51 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 152 ] |
79 | 0.87 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:
[
12241
]
|
80 | 0.69 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 154 ] |
81 | 1.28 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:
[
11628
]
|
82 | 7.10 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:
[
4100
]
|
83 | 7.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.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 80 ] |
84 | 0.87 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
80
]
|
85 | 4.65 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:
[ 162 158 159 174 ] |
86 | 6.42 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 158 ] |
87 | 0.88 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:
[
11995
]
|
88 | 12.22 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:
[
4628
]
|
89 | 7.80 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 162 ] |
90 | 1.61 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:
[
11619
]
|
91 | 0.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.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 138 ] |
92 | 0.72 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:
[
4932
]
|
93 | 0.71 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
138
]
|
94 | 0.53 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:
[
297
]
|
95 | 0.49 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.post_id = ? ORDER BY t0.created_at ASC
Parameters:
[
138
]
|
96 | 0.82 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:
[
23283
]
|
97 | 0.61 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 297 ] |
98 | 0.86 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 136 ] |
99 | 1.18 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
136
]
|
100 | 0.92 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:
[ 274 284 285 275 276 277 278 280 279 281 282 283 355 ] |
101 | 0.70 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 274 ] |
102 | 0.78 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:
[
25336
]
|
103 | 0.98 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:
[
20153
]
|
104 | 3.46 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:
[
49225
]
|
105 | 8.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 284 ] |
106 | 2.00 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:
[
5847
]
|
107 | 0.86 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 133 ] |
108 | 5.30 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
133
]
|
109 | 0.99 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:
[ 266 267 268 ] |
110 | 0.79 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.post_id = ? ORDER BY t0.created_at ASC
Parameters:
[
133
]
|
111 | 0.72 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 267 ] |
112 | 1.10 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:
[
8845
]
|
113 | 0.60 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:
[
10667
]
|
114 | 2.58 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 268 ] |
115 | 5.57 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:
[
19719
]
|
116 | 1.00 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:
[
15599
]
|
117 | 0.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.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 131 ] |
118 | 1.44 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
131
]
|
119 | 0.97 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:
[ 258 261 288 262 263 256 257 259 264 265 269 270 287 364 ] |
120 | 1.02 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:
[
19914
]
|
121 | 0.65 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 258 ] |
122 | 1.00 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:
[
10790
]
|
123 | 6.30 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:
[
21619
]
|
124 | 6.34 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 261 ] |
125 | 2.13 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:
[
12881
]
|
126 | 2.25 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:
[
5319
]
|
127 | 0.69 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 100 ] |
128 | 3.56 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:
[
7307
]
|
129 | 1.96 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:
[
2404
]
|
130 | 2.44 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 97 ] |
131 | 2.79 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.post_id = ? ORDER BY t0.up_votes DESC, t0.created_at ASC
Parameters:
[
97
]
|
132 | 2.76 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:
[ 207 181 ] |
133 | 3.21 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:
[
6548
]
|
134 | 8.43 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:
[
2068
]
|
135 | 0.70 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 181 ] |
136 | 3.72 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:
[
16591
]
|
137 | 4.99 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 207 ] |
138 | 2.96 ms |
SELECT count(p0_.id) AS sclr_0 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON p0_.user_id = u2_.id WHERE p0_.visibility = ? AND m1_.visibility = ? AND p0_.magazine_id = ? AND m1_.is_adult = ? AND p0_.is_adult = ? ORDER BY sclr_0 ASC
Parameters:
[ "visible" "visible" 19 0 0 ] |
139 | 1.65 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 19 ] |
140 | 8.22 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:
[
19
]
|
141 | 6.45 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:
[
19
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
34
Hits
61
Misses
61
Puts
Number of cache hits
Region | Hits |
---|---|
app_entity_magazine | 4 |
app_entity_settings | 16 |
app_entity_image | 6 |
app_entity_user | 8 |
Number of cache misses
Region | Misses |
---|---|
app_entity_user | 45 |
app_entity_image | 16 |
Number of cache puts
Region | Puts |
---|---|
app_entity_user | 45 |
app_entity_image | 16 |