1
3.82 ms
SELECT m0_ . name AS name_0 , m0_ . title AS title_1 , m0_ . description AS description_2 , m0_ . rules AS rules_3 , m0_ . subscriptions_count AS subscriptions_count_4 , m0_ . entry_count AS entry_count_5 , m0_ . entry_comment_count AS entry_comment_count_6 , m0_ . post_count AS post_count_7 , m0_ . post_comment_count AS post_comment_count_8 , m0_ . is_adult AS is_adult_9 , m0_ . custom_css AS custom_css_10 , m0_ . last_active AS last_active_11 , m0_ . marked_for_deletion_at AS marked_for_deletion_at_12 , m0_ . tags AS tags_13 , m0_ . id AS id_14 , m0_ . ap_id AS ap_id_15 , m0_ . ap_profile_id AS ap_profile_id_16 , m0_ . ap_public_url AS ap_public_url_17 , m0_ . ap_followers_url AS ap_followers_url_18 , m0_ . ap_inbox_url AS ap_inbox_url_19 , m0_ . ap_domain AS ap_domain_20 , m0_ . ap_preferred_username AS ap_preferred_username_21 , m0_ . ap_discoverable AS ap_discoverable_22 , m0_ . ap_manually_approves_followers AS ap_manually_approves_followers_23 , m0_ . private_key AS private_key_24 , m0_ . public_key AS public_key_25 , m0_ . ap_fetched_at AS ap_fetched_at_26 , m0_ . ap_deleted_at AS ap_deleted_at_27 , m0_ . ap_timeout_at AS ap_timeout_at_28 , m0_ . visibility AS visibility_29 , m0_ . created_at AS created_at_30 , m0_ . icon_id AS icon_id_31 FROM magazine m0_ WHERE LOWER (m0_ . name ) = LOWER (? )
Parameters :
[
"datahoarder@lemmy.ml "
]
SELECT m0_ . name AS name_0 , m0_ . title AS title_1 , m0_ . description AS description_2 , m0_ . rules AS rules_3 , m0_ . subscriptions_count AS subscriptions_count_4 , m0_ . entry_count AS entry_count_5 , m0_ . entry_comment_count AS entry_comment_count_6 , m0_ . post_count AS post_count_7 , m0_ . post_comment_count AS post_comment_count_8 , m0_ . is_adult AS is_adult_9 , m0_ . custom_css AS custom_css_10 , m0_ . last_active AS last_active_11 , m0_ . marked_for_deletion_at AS marked_for_deletion_at_12 , m0_ . tags AS tags_13 , m0_ . id AS id_14 , m0_ . ap_id AS ap_id_15 , m0_ . ap_profile_id AS ap_profile_id_16 , m0_ . ap_public_url AS ap_public_url_17 , m0_ . ap_followers_url AS ap_followers_url_18 , m0_ . ap_inbox_url AS ap_inbox_url_19 , m0_ . ap_domain AS ap_domain_20 , m0_ . ap_preferred_username AS ap_preferred_username_21 , m0_ . ap_discoverable AS ap_discoverable_22 , m0_ . ap_manually_approves_followers AS ap_manually_approves_followers_23 , m0_ . private_key AS private_key_24 , m0_ . public_key AS public_key_25 , m0_ . ap_fetched_at AS ap_fetched_at_26 , m0_ . ap_deleted_at AS ap_deleted_at_27 , m0_ . ap_timeout_at AS ap_timeout_at_28 , m0_ . visibility AS visibility_29 , m0_ . created_at AS created_at_30 , m0_ . icon_id AS icon_id_31 FROM magazine m0_ WHERE LOWER (m0_ . name ) = LOWER ('datahoarder@lemmy.ml' );
Copy
2
70.97 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_ . magazine_id = ? AND e0_ . type = ? AND m1_ . is_adult = ? AND e0_ . is_adult = ? ORDER BY e0_ . sticky DESC , e0_ . score DESC , e0_ . created_at DESC , e0_ . id DESC LIMIT 25
Parameters :
[
"visible "
"visible "
32
"article "
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_ . magazine_id = 32 AND e0_ . type = 'article' AND m1_ . is_adult = 0 AND e0_ . is_adult = 0 ORDER BY e0_ . sticky DESC , e0_ . score DESC , e0_ . created_at DESC , e0_ . id DESC LIMIT 25 ;
Copy
3
3.90 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 = ?
Copy
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 = 90672 ;
Copy
4
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 = ?
Copy
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 = 49409 ;
Copy
5
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 = ?
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 = ?
Copy
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 = 88299 ;
Copy
6
0.93 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 = ?
Copy
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 = 57117 ;
Copy
7
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 = ?
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 = ?
Copy
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 = 75725 ;
Copy
8
2.69 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 = ?
Copy
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 = 85630 ;
Copy
9
1.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 = ?
Copy
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 = 1357 ;
Copy
10
1.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 = ?
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 = ?
Copy
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 = 48444 ;
Copy
11
0.99 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 = ?
Copy
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 = 61232 ;
Copy
12
0.93 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 = ?
Copy
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 = 75260 ;
Copy
13
5.68 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 = ?
Copy
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 = 58045 ;
Copy
14
7.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 = ?
Copy
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 = 67001 ;
Copy
15
5.43 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 = ?
Copy
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 = 47882 ;
Copy
16
0.85 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 = ?
Copy
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 = 47667 ;
Copy
17
2.68 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 = ?
Copy
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 = 47097 ;
Copy
18
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 = ?
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 = ?
Copy
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 = 24050 ;
Copy
19
0.93 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 = ?
Copy
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 = 47137 ;
Copy
20
1.88 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_ . magazine_id = ? AND e0_ . type = ? AND m1_ . is_adult = ? AND e0_ . is_adult = ? ORDER BY sclr_0 ASC
Parameters :
[
"visible "
"visible "
32
"article "
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_ . magazine_id = 32 AND e0_ . type = 'article' AND m1_ . is_adult = 0 AND e0_ . is_adult = 0 ORDER BY sclr_0 ASC ;
Copy
21
0.92 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 = ? )
SELECT t0 . is_owner AS is_owner_1 , t0 . is_confirmed AS is_confirmed_2 , t0 . id AS id_3 , t0 . created_at AS created_at_4 , t0 . user_id AS user_id_5 , t0 . magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0 . is_owner = 1 AND t0 . magazine_id = 32 );
Copy
22
0.59 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 = ?
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 = 32 ;
Copy
23
4.72 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' )
SELECT COUNT (* ) FROM magazine_log t0 WHERE t0 . magazine_id = 32 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' );
Copy
24
5.47 ms
SELECT m0_ . name AS name_0 , m0_ . title AS title_1 , m0_ . description AS description_2 , m0_ . rules AS rules_3 , m0_ . subscriptions_count AS subscriptions_count_4 , m0_ . entry_count AS entry_count_5 , m0_ . entry_comment_count AS entry_comment_count_6 , m0_ . post_count AS post_count_7 , m0_ . post_comment_count AS post_comment_count_8 , m0_ . is_adult AS is_adult_9 , m0_ . custom_css AS custom_css_10 , m0_ . last_active AS last_active_11 , m0_ . marked_for_deletion_at AS marked_for_deletion_at_12 , m0_ . tags AS tags_13 , m0_ . id AS id_14 , m0_ . ap_id AS ap_id_15 , m0_ . ap_profile_id AS ap_profile_id_16 , m0_ . ap_public_url AS ap_public_url_17 , m0_ . ap_followers_url AS ap_followers_url_18 , m0_ . ap_inbox_url AS ap_inbox_url_19 , m0_ . ap_domain AS ap_domain_20 , m0_ . ap_preferred_username AS ap_preferred_username_21 , m0_ . ap_discoverable AS ap_discoverable_22 , m0_ . ap_manually_approves_followers AS ap_manually_approves_followers_23 , m0_ . private_key AS private_key_24 , m0_ . public_key AS public_key_25 , m0_ . ap_fetched_at AS ap_fetched_at_26 , m0_ . ap_deleted_at AS ap_deleted_at_27 , m0_ . ap_timeout_at AS ap_timeout_at_28 , m0_ . visibility AS visibility_29 , m0_ . created_at AS created_at_30 , m0_ . icon_id AS icon_id_31 FROM magazine m0_ WHERE (m0_ . entry_count > 0 OR m0_ . post_count > 0 ) AND (LOWER (m0_ . title ) LIKE ? OR LOWER (m0_ . description ) LIKE ? OR LOWER (m0_ . name ) LIKE ? ) AND m0_ . is_adult = false AND m0_ . visibility = ? LIMIT 5
Parameters :
[
"%datahoarderlemmy.ml% "
"%datahoarderlemmy.ml% "
"%datahoarderlemmy.ml% "
"visible "
]
SELECT m0_ . name AS name_0 , m0_ . title AS title_1 , m0_ . description AS description_2 , m0_ . rules AS rules_3 , m0_ . subscriptions_count AS subscriptions_count_4 , m0_ . entry_count AS entry_count_5 , m0_ . entry_comment_count AS entry_comment_count_6 , m0_ . post_count AS post_count_7 , m0_ . post_comment_count AS post_comment_count_8 , m0_ . is_adult AS is_adult_9 , m0_ . custom_css AS custom_css_10 , m0_ . last_active AS last_active_11 , m0_ . marked_for_deletion_at AS marked_for_deletion_at_12 , m0_ . tags AS tags_13 , m0_ . id AS id_14 , m0_ . ap_id AS ap_id_15 , m0_ . ap_profile_id AS ap_profile_id_16 , m0_ . ap_public_url AS ap_public_url_17 , m0_ . ap_followers_url AS ap_followers_url_18 , m0_ . ap_inbox_url AS ap_inbox_url_19 , m0_ . ap_domain AS ap_domain_20 , m0_ . ap_preferred_username AS ap_preferred_username_21 , m0_ . ap_discoverable AS ap_discoverable_22 , m0_ . ap_manually_approves_followers AS ap_manually_approves_followers_23 , m0_ . private_key AS private_key_24 , m0_ . public_key AS public_key_25 , m0_ . ap_fetched_at AS ap_fetched_at_26 , m0_ . ap_deleted_at AS ap_deleted_at_27 , m0_ . ap_timeout_at AS ap_timeout_at_28 , m0_ . visibility AS visibility_29 , m0_ . created_at AS created_at_30 , m0_ . icon_id AS icon_id_31 FROM magazine m0_ WHERE (m0_ . entry_count > 0 OR m0_ . post_count > 0 ) AND (LOWER (m0_ . title ) LIKE '%datahoarderlemmy.ml%' OR LOWER (m0_ . description ) LIKE '%datahoarderlemmy.ml%' OR LOWER (m0_ . name ) LIKE '%datahoarderlemmy.ml%' ) AND m0_ . is_adult = false AND m0_ . visibility = 'visible' LIMIT 5 ;
Copy
25
10.25 ms
(SELECT count (id ), user_id FROM entry WHERE magazine_id = :magazineId GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM entry_comment WHERE magazine_id = :magazineId GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM post WHERE magazine_id = :magazineId GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM post_comment WHERE magazine_id = :magazineId GROUP BY user_id ORDER BY count DESC LIMIT 50 )
ORDER BY count DESC
Parameters :
[
"magazineId " => 32
]
(SELECT count (id ), user_id FROM entry WHERE magazine_id = 32 GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM entry_comment WHERE magazine_id = 32 GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM post WHERE magazine_id = 32 GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM post_comment WHERE magazine_id = 32 GROUP BY user_id ORDER BY count DESC LIMIT 50 )
ORDER BY count DESC ;
Copy
26
14.38 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_ WHERE u0_ . id IN (61232 , 48097 , 72741 , 46223 , 48444 , 58045 , 20899 , 9226 , 7496 , 1357 , 55873 , 64869 , 20980 , 45166 , 85630 , 67001 , 47105 , 76 , 39334 , 445 , 22052 , 41464 , 47168 , 47247 , 43500 , 68363 , 90672 , 43677 , 5357 , 49409 , 54507 , 48943 , 47142 , 50734 , 33933 , 7057 , 58777 , 72179 , 3170 , 9624 , 47231 , 41785 , 18739 , 22675 , 11167 , 21343 , 9753 , 379 , 12654 , 24600 , 48036 , 9652 , 49666 , 25106 , 48013 , 88299 , 53761 , 76044 , 83326 , 83179 , 7049 , 47604 , 49407 , 47137 , 9935 , 57766 , 57117 , 49420 , 47736 , 47930 , 47902 , 47667 , 20646 , 37623 , 47097 , 43194 , 36105 , 49413 , 40288 , 75725 , 33539 , 47882 , 8224 , 76184 , 6065 , 47183 , 53129 , 55589 , 64691 , 47569 , 4933 , 51870 , 24050 , 75260 ) AND u0_ . is_banned = false AND u0_ . ap_deleted_at IS NULL AND u0_ . about IS NOT NULL AND u0_ . avatar_id IS NOT NULL 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_
WHERE
u0_ . id IN (
61232 , 48097 , 72741 , 46223 , 48444 , 58045 ,
20899 , 9226 , 7496 , 1357 , 55873 , 64869 ,
20980 , 45166 , 85630 , 67001 , 47105 ,
76 , 39334 , 445 , 22052 , 41464 , 47168 ,
47247 , 43500 , 68363 , 90672 , 43677 ,
5357 , 49409 , 54507 , 48943 , 47142 , 50734 ,
33933 , 7057 , 58777 , 72179 , 3170 , 9624 ,
47231 , 41785 , 18739 , 22675 , 11167 ,
21343 , 9753 , 379 , 12654 , 24600 , 48036 ,
9652 , 49666 , 25106 , 48013 , 88299 , 53761 ,
76044 , 83326 , 83179 , 7049 , 47604 , 49407 ,
47137 , 9935 , 57766 , 57117 , 49420 , 47736 ,
47930 , 47902 , 47667 , 20646 , 37623 ,
47097 , 43194 , 36105 , 49413 , 40288 ,
75725 , 33539 , 47882 , 8224 , 76184 , 6065 ,
47183 , 53129 , 55589 , 64691 , 47569 ,
4933 , 51870 , 24050 , 75260
)
AND u0_ . is_banned = false
AND u0_ . ap_deleted_at IS NULL
AND u0_ . about IS NOT NULL
AND u0_ . avatar_id IS NOT NULL
LIMIT
35
Copy
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_ WHERE u0_ . id IN (61232 , 48097 , 72741 , 46223 , 48444 , 58045 , 20899 , 9226 , 7496 , 1357 , 55873 , 64869 , 20980 , 45166 , 85630 , 67001 , 47105 , 76 , 39334 , 445 , 22052 , 41464 , 47168 , 47247 , 43500 , 68363 , 90672 , 43677 , 5357 , 49409 , 54507 , 48943 , 47142 , 50734 , 33933 , 7057 , 58777 , 72179 , 3170 , 9624 , 47231 , 41785 , 18739 , 22675 , 11167 , 21343 , 9753 , 379 , 12654 , 24600 , 48036 , 9652 , 49666 , 25106 , 48013 , 88299 , 53761 , 76044 , 83326 , 83179 , 7049 , 47604 , 49407 , 47137 , 9935 , 57766 , 57117 , 49420 , 47736 , 47930 , 47902 , 47667 , 20646 , 37623 , 47097 , 43194 , 36105 , 49413 , 40288 , 75725 , 33539 , 47882 , 8224 , 76184 , 6065 , 47183 , 53129 , 55589 , 64691 , 47569 , 4933 , 51870 , 24050 , 75260 ) AND u0_ . is_banned = false AND u0_ . ap_deleted_at IS NULL AND u0_ . about IS NOT NULL AND u0_ . avatar_id IS NOT NULL LIMIT 35 ;
Copy
27
1.36 ms
SELECT c0_ . name AS name_0 , c0_ . slug AS slug_1 , c0_ . description AS description_2 , c0_ . is_private AS is_private_3 , c0_ . is_official AS is_official_4 , c0_ . magazines_count AS magazines_count_5 , c0_ . subscriptions_count AS subscriptions_count_6 , c0_ . id AS id_7 , c0_ . created_at AS created_at_8 , c0_ . user_id AS user_id_9 FROM category c0_ WHERE (LOWER (c0_ . name ) LIKE ? OR LOWER (c0_ . description ) LIKE ? ) AND c0_ . is_private = false LIMIT 5
Parameters :
[
"%datahoarderlemmy.ml% "
"%datahoarderlemmy.ml% "
]
SELECT c0_ . name AS name_0 , c0_ . slug AS slug_1 , c0_ . description AS description_2 , c0_ . is_private AS is_private_3 , c0_ . is_official AS is_official_4 , c0_ . magazines_count AS magazines_count_5 , c0_ . subscriptions_count AS subscriptions_count_6 , c0_ . id AS id_7 , c0_ . created_at AS created_at_8 , c0_ . user_id AS user_id_9 FROM category c0_ WHERE (LOWER (c0_ . name ) LIKE '%datahoarderlemmy.ml%' OR LOWER (c0_ . description ) LIKE '%datahoarderlemmy.ml%' ) AND c0_ . is_private = false LIMIT 5 ;
Copy
28
2.79 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 WHERE p0_ . tags @ > '"datahoarder"' = true AND p0_ . visibility = ? AND m1_ . name < > ? AND p0_ . is_adult = false AND m1_ . is_adult = false ORDER BY p0_ . created_at DESC LIMIT 24
Parameters :
[
"visible "
"datahoarder "
]
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 WHERE p0_ . tags @ > '"datahoarder"' = true AND p0_ . visibility = 'visible' AND m1_ . name < > 'datahoarder' AND p0_ . is_adult = false AND m1_ . is_adult = false ORDER BY p0_ . created_at DESC LIMIT 24 ;
Copy
29
21.52 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 WHERE e0_ . tags @ > '"datahoarder"' = true AND e0_ . visibility = ? AND m1_ . is_adult = false AND e0_ . is_adult = false ORDER BY e0_ . created_at DESC LIMIT 24
Parameters :
[
"visible "
]
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 WHERE e0_ . tags @ > '"datahoarder"' = true AND e0_ . visibility = 'visible' AND m1_ . is_adult = false AND e0_ . is_adult = false ORDER BY e0_ . created_at DESC LIMIT 24 ;
Copy