| 1 |
22.86 ms |
SELECT count(e0_.id) AS sclr_0 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND e0_.type = ? AND d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY sclr_0 ASC
Parameters: [
"visible"
"visible"
"image"
"i.imgur.com"
0
0
]
SELECT count(e0_.id) AS sclr_0 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = 'visible' AND m1_.visibility = 'visible' AND e0_.type = 'image' AND d3_.name = 'i.imgur.com' AND m1_.is_adult = 0 AND e0_.is_adult = 0 ORDER BY sclr_0 ASC;
|
| 2 |
11.25 ms |
SELECT e0_.slug AS slug_0, e0_.title AS title_1, e0_.url AS url_2, e0_.body AS body_3, e0_.type AS type_4, e0_.lang AS lang_5, e0_.is_oc AS is_oc_6, e0_.has_embed AS has_embed_7, e0_.comment_count AS comment_count_8, e0_.favourite_count AS favourite_count_9, e0_.score AS score_10, e0_.is_adult AS is_adult_11, e0_.sticky AS sticky_12, e0_.last_active AS last_active_13, e0_.ip AS ip_14, e0_.ada_amount AS ada_amount_15, e0_.tags AS tags_16, e0_.mentions AS mentions_17, e0_.id AS id_18, e0_.title_ts AS title_ts_19, e0_.body_ts AS body_ts_20, e0_.up_votes AS up_votes_21, e0_.down_votes AS down_votes_22, e0_.ranking AS ranking_23, e0_.visibility AS visibility_24, e0_.ap_id AS ap_id_25, e0_.edited_at AS edited_at_26, e0_.created_at AS created_at_27, e0_.user_id AS user_id_28, e0_.magazine_id AS magazine_id_29, e0_.image_id AS image_id_30, e0_.domain_id AS domain_id_31 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND e0_.type = ? AND d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY e0_.ranking DESC, e0_.created_at DESC, e0_.id DESC LIMIT 25 OFFSET 300
Parameters: [
"visible"
"visible"
"image"
"i.imgur.com"
0
0
]
SELECT e0_.slug AS slug_0, e0_.title AS title_1, e0_.url AS url_2, e0_.body AS body_3, e0_.type AS type_4, e0_.lang AS lang_5, e0_.is_oc AS is_oc_6, e0_.has_embed AS has_embed_7, e0_.comment_count AS comment_count_8, e0_.favourite_count AS favourite_count_9, e0_.score AS score_10, e0_.is_adult AS is_adult_11, e0_.sticky AS sticky_12, e0_.last_active AS last_active_13, e0_.ip AS ip_14, e0_.ada_amount AS ada_amount_15, e0_.tags AS tags_16, e0_.mentions AS mentions_17, e0_.id AS id_18, e0_.title_ts AS title_ts_19, e0_.body_ts AS body_ts_20, e0_.up_votes AS up_votes_21, e0_.down_votes AS down_votes_22, e0_.ranking AS ranking_23, e0_.visibility AS visibility_24, e0_.ap_id AS ap_id_25, e0_.edited_at AS edited_at_26, e0_.created_at AS created_at_27, e0_.user_id AS user_id_28, e0_.magazine_id AS magazine_id_29, e0_.image_id AS image_id_30, e0_.domain_id AS domain_id_31 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = 'visible' AND m1_.visibility = 'visible' AND e0_.type = 'image' AND d3_.name = 'i.imgur.com' AND m1_.is_adult = 0 AND e0_.is_adult = 0 ORDER BY e0_.ranking DESC, e0_.created_at DESC, e0_.id DESC LIMIT 25 OFFSET 300;
|
| 3 |
1.36 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 = ?
SELECT
t0.email AS email_1,
t0.username AS username_2,
t0.roles AS roles_3,
t0.followers_count AS followers_count_4,
t0.homepage AS homepage_5,
t0.about AS about_6,
t0.last_active AS last_active_7,
t0.marked_for_deletion_at AS marked_for_deletion_at_8,
t0.fields AS fields_9,
t0.oauth_github_id AS oauth_github_id_10,
t0.oauth_google_id AS oauth_google_id_11,
t0.oauth_facebook_id AS oauth_facebook_id_12,
t0.oauth_keycloak_id AS oauth_keycloak_id_13,
t0.hide_adult AS hide_adult_14,
t0.show_subscribed_users AS show_subscribed_users_15,
t0.show_subscribed_magazines AS show_subscribed_magazines_16,
t0.show_subscribed_domains AS show_subscribed_domains_17,
t0.preferred_languages AS preferred_languages_18,
t0.featured_magazines AS featured_magazines_19,
t0.show_profile_subscriptions AS show_profile_subscriptions_20,
t0.show_profile_followings AS show_profile_followings_21,
t0.mark_new_comments AS mark_new_comments_22,
t0.notify_on_new_entry AS notify_on_new_entry_23,
t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24,
t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25,
t0.notify_on_new_post AS notify_on_new_post_26,
t0.notify_on_new_post_reply AS notify_on_new_post_reply_27,
t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28,
t0.add_mentions_entries AS add_mentions_entries_29,
t0.add_mentions_posts AS add_mentions_posts_30,
t0.is_banned AS is_banned_31,
t0.is_verified AS is_verified_32,
t0.is_deleted AS is_deleted_33,
t0.is_bot AS is_bot_34,
t0.spam_protection AS spam_protection_35,
t0.custom_css AS custom_css_36,
t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37,
t0.id AS id_38,
t0.password AS password_39,
t0.totp_secret AS totp_secret_40,
t0.totp_backup_codes AS totp_backup_codes_41,
t0.ap_id AS ap_id_42,
t0.ap_profile_id AS ap_profile_id_43,
t0.ap_public_url AS ap_public_url_44,
t0.ap_followers_url AS ap_followers_url_45,
t0.ap_inbox_url AS ap_inbox_url_46,
t0.ap_domain AS ap_domain_47,
t0.ap_preferred_username AS ap_preferred_username_48,
t0.ap_discoverable AS ap_discoverable_49,
t0.ap_manually_approves_followers AS ap_manually_approves_followers_50,
t0.private_key AS private_key_51,
t0.public_key AS public_key_52,
t0.ap_fetched_at AS ap_fetched_at_53,
t0.ap_deleted_at AS ap_deleted_at_54,
t0.ap_timeout_at AS ap_timeout_at_55,
t0.visibility AS visibility_56,
t0.created_at AS created_at_57,
t0.avatar_id AS avatar_id_58,
t0.cover_id AS cover_id_59
FROM
"user" t0
WHERE
t0.id = ?
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = 48984;
|
| 4 |
1.08 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 = ?
SELECT
t0.email AS email_1,
t0.username AS username_2,
t0.roles AS roles_3,
t0.followers_count AS followers_count_4,
t0.homepage AS homepage_5,
t0.about AS about_6,
t0.last_active AS last_active_7,
t0.marked_for_deletion_at AS marked_for_deletion_at_8,
t0.fields AS fields_9,
t0.oauth_github_id AS oauth_github_id_10,
t0.oauth_google_id AS oauth_google_id_11,
t0.oauth_facebook_id AS oauth_facebook_id_12,
t0.oauth_keycloak_id AS oauth_keycloak_id_13,
t0.hide_adult AS hide_adult_14,
t0.show_subscribed_users AS show_subscribed_users_15,
t0.show_subscribed_magazines AS show_subscribed_magazines_16,
t0.show_subscribed_domains AS show_subscribed_domains_17,
t0.preferred_languages AS preferred_languages_18,
t0.featured_magazines AS featured_magazines_19,
t0.show_profile_subscriptions AS show_profile_subscriptions_20,
t0.show_profile_followings AS show_profile_followings_21,
t0.mark_new_comments AS mark_new_comments_22,
t0.notify_on_new_entry AS notify_on_new_entry_23,
t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24,
t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25,
t0.notify_on_new_post AS notify_on_new_post_26,
t0.notify_on_new_post_reply AS notify_on_new_post_reply_27,
t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28,
t0.add_mentions_entries AS add_mentions_entries_29,
t0.add_mentions_posts AS add_mentions_posts_30,
t0.is_banned AS is_banned_31,
t0.is_verified AS is_verified_32,
t0.is_deleted AS is_deleted_33,
t0.is_bot AS is_bot_34,
t0.spam_protection AS spam_protection_35,
t0.custom_css AS custom_css_36,
t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37,
t0.id AS id_38,
t0.password AS password_39,
t0.totp_secret AS totp_secret_40,
t0.totp_backup_codes AS totp_backup_codes_41,
t0.ap_id AS ap_id_42,
t0.ap_profile_id AS ap_profile_id_43,
t0.ap_public_url AS ap_public_url_44,
t0.ap_followers_url AS ap_followers_url_45,
t0.ap_inbox_url AS ap_inbox_url_46,
t0.ap_domain AS ap_domain_47,
t0.ap_preferred_username AS ap_preferred_username_48,
t0.ap_discoverable AS ap_discoverable_49,
t0.ap_manually_approves_followers AS ap_manually_approves_followers_50,
t0.private_key AS private_key_51,
t0.public_key AS public_key_52,
t0.ap_fetched_at AS ap_fetched_at_53,
t0.ap_deleted_at AS ap_deleted_at_54,
t0.ap_timeout_at AS ap_timeout_at_55,
t0.visibility AS visibility_56,
t0.created_at AS created_at_57,
t0.avatar_id AS avatar_id_58,
t0.cover_id AS cover_id_59
FROM
"user" t0
WHERE
t0.id = ?
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = 494;
|
| 5 |
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 = ?
SELECT
t0.email AS email_1,
t0.username AS username_2,
t0.roles AS roles_3,
t0.followers_count AS followers_count_4,
t0.homepage AS homepage_5,
t0.about AS about_6,
t0.last_active AS last_active_7,
t0.marked_for_deletion_at AS marked_for_deletion_at_8,
t0.fields AS fields_9,
t0.oauth_github_id AS oauth_github_id_10,
t0.oauth_google_id AS oauth_google_id_11,
t0.oauth_facebook_id AS oauth_facebook_id_12,
t0.oauth_keycloak_id AS oauth_keycloak_id_13,
t0.hide_adult AS hide_adult_14,
t0.show_subscribed_users AS show_subscribed_users_15,
t0.show_subscribed_magazines AS show_subscribed_magazines_16,
t0.show_subscribed_domains AS show_subscribed_domains_17,
t0.preferred_languages AS preferred_languages_18,
t0.featured_magazines AS featured_magazines_19,
t0.show_profile_subscriptions AS show_profile_subscriptions_20,
t0.show_profile_followings AS show_profile_followings_21,
t0.mark_new_comments AS mark_new_comments_22,
t0.notify_on_new_entry AS notify_on_new_entry_23,
t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24,
t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25,
t0.notify_on_new_post AS notify_on_new_post_26,
t0.notify_on_new_post_reply AS notify_on_new_post_reply_27,
t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28,
t0.add_mentions_entries AS add_mentions_entries_29,
t0.add_mentions_posts AS add_mentions_posts_30,
t0.is_banned AS is_banned_31,
t0.is_verified AS is_verified_32,
t0.is_deleted AS is_deleted_33,
t0.is_bot AS is_bot_34,
t0.spam_protection AS spam_protection_35,
t0.custom_css AS custom_css_36,
t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37,
t0.id AS id_38,
t0.password AS password_39,
t0.totp_secret AS totp_secret_40,
t0.totp_backup_codes AS totp_backup_codes_41,
t0.ap_id AS ap_id_42,
t0.ap_profile_id AS ap_profile_id_43,
t0.ap_public_url AS ap_public_url_44,
t0.ap_followers_url AS ap_followers_url_45,
t0.ap_inbox_url AS ap_inbox_url_46,
t0.ap_domain AS ap_domain_47,
t0.ap_preferred_username AS ap_preferred_username_48,
t0.ap_discoverable AS ap_discoverable_49,
t0.ap_manually_approves_followers AS ap_manually_approves_followers_50,
t0.private_key AS private_key_51,
t0.public_key AS public_key_52,
t0.ap_fetched_at AS ap_fetched_at_53,
t0.ap_deleted_at AS ap_deleted_at_54,
t0.ap_timeout_at AS ap_timeout_at_55,
t0.visibility AS visibility_56,
t0.created_at AS created_at_57,
t0.avatar_id AS avatar_id_58,
t0.cover_id AS cover_id_59
FROM
"user" t0
WHERE
t0.id = ?
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = 51333;
|
| 6 |
2.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 = ?
SELECT
t0.email AS email_1,
t0.username AS username_2,
t0.roles AS roles_3,
t0.followers_count AS followers_count_4,
t0.homepage AS homepage_5,
t0.about AS about_6,
t0.last_active AS last_active_7,
t0.marked_for_deletion_at AS marked_for_deletion_at_8,
t0.fields AS fields_9,
t0.oauth_github_id AS oauth_github_id_10,
t0.oauth_google_id AS oauth_google_id_11,
t0.oauth_facebook_id AS oauth_facebook_id_12,
t0.oauth_keycloak_id AS oauth_keycloak_id_13,
t0.hide_adult AS hide_adult_14,
t0.show_subscribed_users AS show_subscribed_users_15,
t0.show_subscribed_magazines AS show_subscribed_magazines_16,
t0.show_subscribed_domains AS show_subscribed_domains_17,
t0.preferred_languages AS preferred_languages_18,
t0.featured_magazines AS featured_magazines_19,
t0.show_profile_subscriptions AS show_profile_subscriptions_20,
t0.show_profile_followings AS show_profile_followings_21,
t0.mark_new_comments AS mark_new_comments_22,
t0.notify_on_new_entry AS notify_on_new_entry_23,
t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24,
t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25,
t0.notify_on_new_post AS notify_on_new_post_26,
t0.notify_on_new_post_reply AS notify_on_new_post_reply_27,
t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28,
t0.add_mentions_entries AS add_mentions_entries_29,
t0.add_mentions_posts AS add_mentions_posts_30,
t0.is_banned AS is_banned_31,
t0.is_verified AS is_verified_32,
t0.is_deleted AS is_deleted_33,
t0.is_bot AS is_bot_34,
t0.spam_protection AS spam_protection_35,
t0.custom_css AS custom_css_36,
t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37,
t0.id AS id_38,
t0.password AS password_39,
t0.totp_secret AS totp_secret_40,
t0.totp_backup_codes AS totp_backup_codes_41,
t0.ap_id AS ap_id_42,
t0.ap_profile_id AS ap_profile_id_43,
t0.ap_public_url AS ap_public_url_44,
t0.ap_followers_url AS ap_followers_url_45,
t0.ap_inbox_url AS ap_inbox_url_46,
t0.ap_domain AS ap_domain_47,
t0.ap_preferred_username AS ap_preferred_username_48,
t0.ap_discoverable AS ap_discoverable_49,
t0.ap_manually_approves_followers AS ap_manually_approves_followers_50,
t0.private_key AS private_key_51,
t0.public_key AS public_key_52,
t0.ap_fetched_at AS ap_fetched_at_53,
t0.ap_deleted_at AS ap_deleted_at_54,
t0.ap_timeout_at AS ap_timeout_at_55,
t0.visibility AS visibility_56,
t0.created_at AS created_at_57,
t0.avatar_id AS avatar_id_58,
t0.cover_id AS cover_id_59
FROM
"user" t0
WHERE
t0.id = ?
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = 44286;
|
| 7 |
12.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 = ?
SELECT
t0.email AS email_1,
t0.username AS username_2,
t0.roles AS roles_3,
t0.followers_count AS followers_count_4,
t0.homepage AS homepage_5,
t0.about AS about_6,
t0.last_active AS last_active_7,
t0.marked_for_deletion_at AS marked_for_deletion_at_8,
t0.fields AS fields_9,
t0.oauth_github_id AS oauth_github_id_10,
t0.oauth_google_id AS oauth_google_id_11,
t0.oauth_facebook_id AS oauth_facebook_id_12,
t0.oauth_keycloak_id AS oauth_keycloak_id_13,
t0.hide_adult AS hide_adult_14,
t0.show_subscribed_users AS show_subscribed_users_15,
t0.show_subscribed_magazines AS show_subscribed_magazines_16,
t0.show_subscribed_domains AS show_subscribed_domains_17,
t0.preferred_languages AS preferred_languages_18,
t0.featured_magazines AS featured_magazines_19,
t0.show_profile_subscriptions AS show_profile_subscriptions_20,
t0.show_profile_followings AS show_profile_followings_21,
t0.mark_new_comments AS mark_new_comments_22,
t0.notify_on_new_entry AS notify_on_new_entry_23,
t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24,
t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25,
t0.notify_on_new_post AS notify_on_new_post_26,
t0.notify_on_new_post_reply AS notify_on_new_post_reply_27,
t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28,
t0.add_mentions_entries AS add_mentions_entries_29,
t0.add_mentions_posts AS add_mentions_posts_30,
t0.is_banned AS is_banned_31,
t0.is_verified AS is_verified_32,
t0.is_deleted AS is_deleted_33,
t0.is_bot AS is_bot_34,
t0.spam_protection AS spam_protection_35,
t0.custom_css AS custom_css_36,
t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37,
t0.id AS id_38,
t0.password AS password_39,
t0.totp_secret AS totp_secret_40,
t0.totp_backup_codes AS totp_backup_codes_41,
t0.ap_id AS ap_id_42,
t0.ap_profile_id AS ap_profile_id_43,
t0.ap_public_url AS ap_public_url_44,
t0.ap_followers_url AS ap_followers_url_45,
t0.ap_inbox_url AS ap_inbox_url_46,
t0.ap_domain AS ap_domain_47,
t0.ap_preferred_username AS ap_preferred_username_48,
t0.ap_discoverable AS ap_discoverable_49,
t0.ap_manually_approves_followers AS ap_manually_approves_followers_50,
t0.private_key AS private_key_51,
t0.public_key AS public_key_52,
t0.ap_fetched_at AS ap_fetched_at_53,
t0.ap_deleted_at AS ap_deleted_at_54,
t0.ap_timeout_at AS ap_timeout_at_55,
t0.visibility AS visibility_56,
t0.created_at AS created_at_57,
t0.avatar_id AS avatar_id_58,
t0.cover_id AS cover_id_59
FROM
"user" t0
WHERE
t0.id = ?
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = 41265;
|
| 8 |
8.01 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 = ?
SELECT
t0.email AS email_1,
t0.username AS username_2,
t0.roles AS roles_3,
t0.followers_count AS followers_count_4,
t0.homepage AS homepage_5,
t0.about AS about_6,
t0.last_active AS last_active_7,
t0.marked_for_deletion_at AS marked_for_deletion_at_8,
t0.fields AS fields_9,
t0.oauth_github_id AS oauth_github_id_10,
t0.oauth_google_id AS oauth_google_id_11,
t0.oauth_facebook_id AS oauth_facebook_id_12,
t0.oauth_keycloak_id AS oauth_keycloak_id_13,
t0.hide_adult AS hide_adult_14,
t0.show_subscribed_users AS show_subscribed_users_15,
t0.show_subscribed_magazines AS show_subscribed_magazines_16,
t0.show_subscribed_domains AS show_subscribed_domains_17,
t0.preferred_languages AS preferred_languages_18,
t0.featured_magazines AS featured_magazines_19,
t0.show_profile_subscriptions AS show_profile_subscriptions_20,
t0.show_profile_followings AS show_profile_followings_21,
t0.mark_new_comments AS mark_new_comments_22,
t0.notify_on_new_entry AS notify_on_new_entry_23,
t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24,
t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25,
t0.notify_on_new_post AS notify_on_new_post_26,
t0.notify_on_new_post_reply AS notify_on_new_post_reply_27,
t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28,
t0.add_mentions_entries AS add_mentions_entries_29,
t0.add_mentions_posts AS add_mentions_posts_30,
t0.is_banned AS is_banned_31,
t0.is_verified AS is_verified_32,
t0.is_deleted AS is_deleted_33,
t0.is_bot AS is_bot_34,
t0.spam_protection AS spam_protection_35,
t0.custom_css AS custom_css_36,
t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37,
t0.id AS id_38,
t0.password AS password_39,
t0.totp_secret AS totp_secret_40,
t0.totp_backup_codes AS totp_backup_codes_41,
t0.ap_id AS ap_id_42,
t0.ap_profile_id AS ap_profile_id_43,
t0.ap_public_url AS ap_public_url_44,
t0.ap_followers_url AS ap_followers_url_45,
t0.ap_inbox_url AS ap_inbox_url_46,
t0.ap_domain AS ap_domain_47,
t0.ap_preferred_username AS ap_preferred_username_48,
t0.ap_discoverable AS ap_discoverable_49,
t0.ap_manually_approves_followers AS ap_manually_approves_followers_50,
t0.private_key AS private_key_51,
t0.public_key AS public_key_52,
t0.ap_fetched_at AS ap_fetched_at_53,
t0.ap_deleted_at AS ap_deleted_at_54,
t0.ap_timeout_at AS ap_timeout_at_55,
t0.visibility AS visibility_56,
t0.created_at AS created_at_57,
t0.avatar_id AS avatar_id_58,
t0.cover_id AS cover_id_59
FROM
"user" t0
WHERE
t0.id = ?
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = 37459;
|
| 9 |
64.54 ms |
SELECT u0_.email AS email_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.followers_count AS followers_count_3, u0_.homepage AS homepage_4, u0_.about AS about_5, u0_.last_active AS last_active_6, u0_.marked_for_deletion_at AS marked_for_deletion_at_7, u0_.fields AS fields_8, u0_.oauth_github_id AS oauth_github_id_9, u0_.oauth_google_id AS oauth_google_id_10, u0_.oauth_facebook_id AS oauth_facebook_id_11, u0_.oauth_keycloak_id AS oauth_keycloak_id_12, u0_.hide_adult AS hide_adult_13, u0_.show_subscribed_users AS show_subscribed_users_14, u0_.show_subscribed_magazines AS show_subscribed_magazines_15, u0_.show_subscribed_domains AS show_subscribed_domains_16, u0_.preferred_languages AS preferred_languages_17, u0_.featured_magazines AS featured_magazines_18, u0_.show_profile_subscriptions AS show_profile_subscriptions_19, u0_.show_profile_followings AS show_profile_followings_20, u0_.mark_new_comments AS mark_new_comments_21, u0_.notify_on_new_entry AS notify_on_new_entry_22, u0_.notify_on_new_entry_reply AS notify_on_new_entry_reply_23, u0_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_24, u0_.notify_on_new_post AS notify_on_new_post_25, u0_.notify_on_new_post_reply AS notify_on_new_post_reply_26, u0_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_27, u0_.add_mentions_entries AS add_mentions_entries_28, u0_.add_mentions_posts AS add_mentions_posts_29, u0_.is_banned AS is_banned_30, u0_.is_verified AS is_verified_31, u0_.is_deleted AS is_deleted_32, u0_.is_bot AS is_bot_33, u0_.spam_protection AS spam_protection_34, u0_.custom_css AS custom_css_35, u0_.ignore_magazines_custom_css AS ignore_magazines_custom_css_36, u0_.id AS id_37, u0_.password AS password_38, u0_.totp_secret AS totp_secret_39, u0_.totp_backup_codes AS totp_backup_codes_40, u0_.ap_id AS ap_id_41, u0_.ap_profile_id AS ap_profile_id_42, u0_.ap_public_url AS ap_public_url_43, u0_.ap_followers_url AS ap_followers_url_44, u0_.ap_inbox_url AS ap_inbox_url_45, u0_.ap_domain AS ap_domain_46, u0_.ap_preferred_username AS ap_preferred_username_47, u0_.ap_discoverable AS ap_discoverable_48, u0_.ap_manually_approves_followers AS ap_manually_approves_followers_49, u0_.private_key AS private_key_50, u0_.public_key AS public_key_51, u0_.ap_fetched_at AS ap_fetched_at_52, u0_.ap_deleted_at AS ap_deleted_at_53, u0_.ap_timeout_at AS ap_timeout_at_54, u0_.visibility AS visibility_55, u0_.created_at AS created_at_56, u0_.avatar_id AS avatar_id_57, u0_.cover_id AS cover_id_58 FROM "user" u0_ INNER JOIN image i1_ ON u0_.avatar_id = i1_.id WHERE u0_.last_active >= ? AND u0_.is_banned = false AND u0_.ap_deleted_at IS NULL AND u0_.avatar_id IS NOT NULL ORDER BY u0_.last_active DESC LIMIT 35
Parameters: [
"2025-02-16 14:20:04"
]
SELECT
u0_.email AS email_0,
u0_.username AS username_1,
u0_.roles AS roles_2,
u0_.followers_count AS followers_count_3,
u0_.homepage AS homepage_4,
u0_.about AS about_5,
u0_.last_active AS last_active_6,
u0_.marked_for_deletion_at AS marked_for_deletion_at_7,
u0_.fields AS fields_8,
u0_.oauth_github_id AS oauth_github_id_9,
u0_.oauth_google_id AS oauth_google_id_10,
u0_.oauth_facebook_id AS oauth_facebook_id_11,
u0_.oauth_keycloak_id AS oauth_keycloak_id_12,
u0_.hide_adult AS hide_adult_13,
u0_.show_subscribed_users AS show_subscribed_users_14,
u0_.show_subscribed_magazines AS show_subscribed_magazines_15,
u0_.show_subscribed_domains AS show_subscribed_domains_16,
u0_.preferred_languages AS preferred_languages_17,
u0_.featured_magazines AS featured_magazines_18,
u0_.show_profile_subscriptions AS show_profile_subscriptions_19,
u0_.show_profile_followings AS show_profile_followings_20,
u0_.mark_new_comments AS mark_new_comments_21,
u0_.notify_on_new_entry AS notify_on_new_entry_22,
u0_.notify_on_new_entry_reply AS notify_on_new_entry_reply_23,
u0_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_24,
u0_.notify_on_new_post AS notify_on_new_post_25,
u0_.notify_on_new_post_reply AS notify_on_new_post_reply_26,
u0_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_27,
u0_.add_mentions_entries AS add_mentions_entries_28,
u0_.add_mentions_posts AS add_mentions_posts_29,
u0_.is_banned AS is_banned_30,
u0_.is_verified AS is_verified_31,
u0_.is_deleted AS is_deleted_32,
u0_.is_bot AS is_bot_33,
u0_.spam_protection AS spam_protection_34,
u0_.custom_css AS custom_css_35,
u0_.ignore_magazines_custom_css AS ignore_magazines_custom_css_36,
u0_.id AS id_37,
u0_.password AS password_38,
u0_.totp_secret AS totp_secret_39,
u0_.totp_backup_codes AS totp_backup_codes_40,
u0_.ap_id AS ap_id_41,
u0_.ap_profile_id AS ap_profile_id_42,
u0_.ap_public_url AS ap_public_url_43,
u0_.ap_followers_url AS ap_followers_url_44,
u0_.ap_inbox_url AS ap_inbox_url_45,
u0_.ap_domain AS ap_domain_46,
u0_.ap_preferred_username AS ap_preferred_username_47,
u0_.ap_discoverable AS ap_discoverable_48,
u0_.ap_manually_approves_followers AS ap_manually_approves_followers_49,
u0_.private_key AS private_key_50,
u0_.public_key AS public_key_51,
u0_.ap_fetched_at AS ap_fetched_at_52,
u0_.ap_deleted_at AS ap_deleted_at_53,
u0_.ap_timeout_at AS ap_timeout_at_54,
u0_.visibility AS visibility_55,
u0_.created_at AS created_at_56,
u0_.avatar_id AS avatar_id_57,
u0_.cover_id AS cover_id_58
FROM
"user" u0_
INNER JOIN image i1_ ON u0_.avatar_id = i1_.id
WHERE
u0_.last_active >= ?
AND u0_.is_banned = false
AND u0_.ap_deleted_at IS NULL
AND u0_.avatar_id IS NOT NULL
ORDER BY
u0_.last_active DESC
LIMIT
35
SELECT u0_.email AS email_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.followers_count AS followers_count_3, u0_.homepage AS homepage_4, u0_.about AS about_5, u0_.last_active AS last_active_6, u0_.marked_for_deletion_at AS marked_for_deletion_at_7, u0_.fields AS fields_8, u0_.oauth_github_id AS oauth_github_id_9, u0_.oauth_google_id AS oauth_google_id_10, u0_.oauth_facebook_id AS oauth_facebook_id_11, u0_.oauth_keycloak_id AS oauth_keycloak_id_12, u0_.hide_adult AS hide_adult_13, u0_.show_subscribed_users AS show_subscribed_users_14, u0_.show_subscribed_magazines AS show_subscribed_magazines_15, u0_.show_subscribed_domains AS show_subscribed_domains_16, u0_.preferred_languages AS preferred_languages_17, u0_.featured_magazines AS featured_magazines_18, u0_.show_profile_subscriptions AS show_profile_subscriptions_19, u0_.show_profile_followings AS show_profile_followings_20, u0_.mark_new_comments AS mark_new_comments_21, u0_.notify_on_new_entry AS notify_on_new_entry_22, u0_.notify_on_new_entry_reply AS notify_on_new_entry_reply_23, u0_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_24, u0_.notify_on_new_post AS notify_on_new_post_25, u0_.notify_on_new_post_reply AS notify_on_new_post_reply_26, u0_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_27, u0_.add_mentions_entries AS add_mentions_entries_28, u0_.add_mentions_posts AS add_mentions_posts_29, u0_.is_banned AS is_banned_30, u0_.is_verified AS is_verified_31, u0_.is_deleted AS is_deleted_32, u0_.is_bot AS is_bot_33, u0_.spam_protection AS spam_protection_34, u0_.custom_css AS custom_css_35, u0_.ignore_magazines_custom_css AS ignore_magazines_custom_css_36, u0_.id AS id_37, u0_.password AS password_38, u0_.totp_secret AS totp_secret_39, u0_.totp_backup_codes AS totp_backup_codes_40, u0_.ap_id AS ap_id_41, u0_.ap_profile_id AS ap_profile_id_42, u0_.ap_public_url AS ap_public_url_43, u0_.ap_followers_url AS ap_followers_url_44, u0_.ap_inbox_url AS ap_inbox_url_45, u0_.ap_domain AS ap_domain_46, u0_.ap_preferred_username AS ap_preferred_username_47, u0_.ap_discoverable AS ap_discoverable_48, u0_.ap_manually_approves_followers AS ap_manually_approves_followers_49, u0_.private_key AS private_key_50, u0_.public_key AS public_key_51, u0_.ap_fetched_at AS ap_fetched_at_52, u0_.ap_deleted_at AS ap_deleted_at_53, u0_.ap_timeout_at AS ap_timeout_at_54, u0_.visibility AS visibility_55, u0_.created_at AS created_at_56, u0_.avatar_id AS avatar_id_57, u0_.cover_id AS cover_id_58 FROM "user" u0_ INNER JOIN image i1_ ON u0_.avatar_id = i1_.id WHERE u0_.last_active >= '2025-02-16 14:20:04' AND u0_.is_banned = false AND u0_.ap_deleted_at IS NULL AND u0_.avatar_id IS NOT NULL ORDER BY u0_.last_active DESC LIMIT 35;
|