1
12.41 ms
SELECT t0 . slug AS slug_1 , t0 . title AS title_2 , t0 . url AS url_3 , t0 . body AS body_4 , t0 . type AS type_5 , t0 . lang AS lang_6 , t0 . is_oc AS is_oc_7 , t0 . has_embed AS has_embed_8 , t0 . comment_count AS comment_count_9 , t0 . favourite_count AS favourite_count_10 , t0 . score AS score_11 , t0 . is_adult AS is_adult_12 , t0 . sticky AS sticky_13 , t0 . last_active AS last_active_14 , t0 . ip AS ip_15 , t0 . ada_amount AS ada_amount_16 , t0 . tags AS tags_17 , t0 . mentions AS mentions_18 , t0 . id AS id_19 , t0 . title_ts AS title_ts_20 , t0 . body_ts AS body_ts_21 , t0 . up_votes AS up_votes_22 , t0 . down_votes AS down_votes_23 , t0 . ranking AS ranking_24 , t0 . visibility AS visibility_25 , t0 . ap_id AS ap_id_26 , t0 . edited_at AS edited_at_27 , t0 . created_at AS created_at_28 , t0 . user_id AS user_id_29 , t0 . magazine_id AS magazine_id_30 , t0 . image_id AS image_id_31 , t0 . domain_id AS domain_id_32 FROM entry t0 WHERE t0 . id = ?
SELECT t0 . slug AS slug_1 , t0 . title AS title_2 , t0 . url AS url_3 , t0 . body AS body_4 , t0 . type AS type_5 , t0 . lang AS lang_6 , t0 . is_oc AS is_oc_7 , t0 . has_embed AS has_embed_8 , t0 . comment_count AS comment_count_9 , t0 . favourite_count AS favourite_count_10 , t0 . score AS score_11 , t0 . is_adult AS is_adult_12 , t0 . sticky AS sticky_13 , t0 . last_active AS last_active_14 , t0 . ip AS ip_15 , t0 . ada_amount AS ada_amount_16 , t0 . tags AS tags_17 , t0 . mentions AS mentions_18 , t0 . id AS id_19 , t0 . title_ts AS title_ts_20 , t0 . body_ts AS body_ts_21 , t0 . up_votes AS up_votes_22 , t0 . down_votes AS down_votes_23 , t0 . ranking AS ranking_24 , t0 . visibility AS visibility_25 , t0 . ap_id AS ap_id_26 , t0 . edited_at AS edited_at_27 , t0 . created_at AS created_at_28 , t0 . user_id AS user_id_29 , t0 . magazine_id AS magazine_id_30 , t0 . image_id AS image_id_31 , t0 . domain_id AS domain_id_32 FROM entry t0 WHERE t0 . id = '15022' ;
Copy
2
10.93 ms
SELECT COUNT (* ) FROM favourite t0 WHERE t0 . entry_id = ? AND t0 . favourite_type IN ('entry' )
SELECT COUNT (* ) FROM favourite t0 WHERE t0 . entry_id = 15022 AND t0 . favourite_type IN ('entry' );
Copy
3
4.00 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . magazine_id AS magazine_id_3 , t0 . user_id AS user_id_4 , t0 . entry_id AS entry_id_5 , t0 . favourite_type FROM favourite t0 WHERE t0 . entry_id = ? AND t0 . favourite_type IN ('entry' ) ORDER BY t0 . created_at DESC
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . magazine_id AS magazine_id_3 , t0 . user_id AS user_id_4 , t0 . entry_id AS entry_id_5 , t0 . favourite_type FROM favourite t0 WHERE t0 . entry_id = 15022 AND t0 . favourite_type IN ('entry' ) ORDER BY t0 . created_at DESC ;
Copy
4
2.17 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 = 75210 ;
Copy
5
1.05 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 = 6225 ;
Copy
6
1.10 ms
SELECT t0 . email AS email_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . followers_count AS followers_count_4 , t0 . homepage AS homepage_5 , t0 . about AS about_6 , t0 . last_active AS last_active_7 , t0 . marked_for_deletion_at AS marked_for_deletion_at_8 , t0 . fields AS fields_9 , t0 . oauth_github_id AS oauth_github_id_10 , t0 . oauth_google_id AS oauth_google_id_11 , t0 . oauth_facebook_id AS oauth_facebook_id_12 , t0 . oauth_keycloak_id AS oauth_keycloak_id_13 , t0 . hide_adult AS hide_adult_14 , t0 . show_subscribed_users AS show_subscribed_users_15 , t0 . show_subscribed_magazines AS show_subscribed_magazines_16 , t0 . show_subscribed_domains AS show_subscribed_domains_17 , t0 . preferred_languages AS preferred_languages_18 , t0 . featured_magazines AS featured_magazines_19 , t0 . show_profile_subscriptions AS show_profile_subscriptions_20 , t0 . show_profile_followings AS show_profile_followings_21 , t0 . mark_new_comments AS mark_new_comments_22 , t0 . notify_on_new_entry AS notify_on_new_entry_23 , t0 . notify_on_new_entry_reply AS notify_on_new_entry_reply_24 , t0 . notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25 , t0 . notify_on_new_post AS notify_on_new_post_26 , t0 . notify_on_new_post_reply AS notify_on_new_post_reply_27 , t0 . notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28 , t0 . add_mentions_entries AS add_mentions_entries_29 , t0 . add_mentions_posts AS add_mentions_posts_30 , t0 . is_banned AS is_banned_31 , t0 . is_verified AS is_verified_32 , t0 . is_deleted AS is_deleted_33 , t0 . is_bot AS is_bot_34 , t0 . spam_protection AS spam_protection_35 , t0 . custom_css AS custom_css_36 , t0 . ignore_magazines_custom_css AS ignore_magazines_custom_css_37 , t0 . id AS id_38 , t0 . password AS password_39 , t0 . totp_secret AS totp_secret_40 , t0 . totp_backup_codes AS totp_backup_codes_41 , t0 . ap_id AS ap_id_42 , t0 . ap_profile_id AS ap_profile_id_43 , t0 . ap_public_url AS ap_public_url_44 , t0 . ap_followers_url AS ap_followers_url_45 , t0 . ap_inbox_url AS ap_inbox_url_46 , t0 . ap_domain AS ap_domain_47 , t0 . ap_preferred_username AS ap_preferred_username_48 , t0 . ap_discoverable AS ap_discoverable_49 , t0 . ap_manually_approves_followers AS ap_manually_approves_followers_50 , t0 . private_key AS private_key_51 , t0 . public_key AS public_key_52 , t0 . ap_fetched_at AS ap_fetched_at_53 , t0 . ap_deleted_at AS ap_deleted_at_54 , t0 . ap_timeout_at AS ap_timeout_at_55 , t0 . visibility AS visibility_56 , t0 . created_at AS created_at_57 , t0 . avatar_id AS avatar_id_58 , t0 . cover_id AS cover_id_59 FROM "user" t0 WHERE t0 . id = ?
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 = 42110 ;
Copy
7
0.77 ms
SELECT t0 . email AS email_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . followers_count AS followers_count_4 , t0 . homepage AS homepage_5 , t0 . about AS about_6 , t0 . last_active AS last_active_7 , t0 . marked_for_deletion_at AS marked_for_deletion_at_8 , t0 . fields AS fields_9 , t0 . oauth_github_id AS oauth_github_id_10 , t0 . oauth_google_id AS oauth_google_id_11 , t0 . oauth_facebook_id AS oauth_facebook_id_12 , t0 . oauth_keycloak_id AS oauth_keycloak_id_13 , t0 . hide_adult AS hide_adult_14 , t0 . show_subscribed_users AS show_subscribed_users_15 , t0 . show_subscribed_magazines AS show_subscribed_magazines_16 , t0 . show_subscribed_domains AS show_subscribed_domains_17 , t0 . preferred_languages AS preferred_languages_18 , t0 . featured_magazines AS featured_magazines_19 , t0 . show_profile_subscriptions AS show_profile_subscriptions_20 , t0 . show_profile_followings AS show_profile_followings_21 , t0 . mark_new_comments AS mark_new_comments_22 , t0 . notify_on_new_entry AS notify_on_new_entry_23 , t0 . notify_on_new_entry_reply AS notify_on_new_entry_reply_24 , t0 . notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25 , t0 . notify_on_new_post AS notify_on_new_post_26 , t0 . notify_on_new_post_reply AS notify_on_new_post_reply_27 , t0 . notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28 , t0 . add_mentions_entries AS add_mentions_entries_29 , t0 . add_mentions_posts AS add_mentions_posts_30 , t0 . is_banned AS is_banned_31 , t0 . is_verified AS is_verified_32 , t0 . is_deleted AS is_deleted_33 , t0 . is_bot AS is_bot_34 , t0 . spam_protection AS spam_protection_35 , t0 . custom_css AS custom_css_36 , t0 . ignore_magazines_custom_css AS ignore_magazines_custom_css_37 , t0 . id AS id_38 , t0 . password AS password_39 , t0 . totp_secret AS totp_secret_40 , t0 . totp_backup_codes AS totp_backup_codes_41 , t0 . ap_id AS ap_id_42 , t0 . ap_profile_id AS ap_profile_id_43 , t0 . ap_public_url AS ap_public_url_44 , t0 . ap_followers_url AS ap_followers_url_45 , t0 . ap_inbox_url AS ap_inbox_url_46 , t0 . ap_domain AS ap_domain_47 , t0 . ap_preferred_username AS ap_preferred_username_48 , t0 . ap_discoverable AS ap_discoverable_49 , t0 . ap_manually_approves_followers AS ap_manually_approves_followers_50 , t0 . private_key AS private_key_51 , t0 . public_key AS public_key_52 , t0 . ap_fetched_at AS ap_fetched_at_53 , t0 . ap_deleted_at AS ap_deleted_at_54 , t0 . ap_timeout_at AS ap_timeout_at_55 , t0 . visibility AS visibility_56 , t0 . created_at AS created_at_57 , t0 . avatar_id AS avatar_id_58 , t0 . cover_id AS cover_id_59 FROM "user" t0 WHERE t0 . id = ?
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 = 2382 ;
Copy
8
0.75 ms
SELECT t0 . email AS email_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . followers_count AS followers_count_4 , t0 . homepage AS homepage_5 , t0 . about AS about_6 , t0 . last_active AS last_active_7 , t0 . marked_for_deletion_at AS marked_for_deletion_at_8 , t0 . fields AS fields_9 , t0 . oauth_github_id AS oauth_github_id_10 , t0 . oauth_google_id AS oauth_google_id_11 , t0 . oauth_facebook_id AS oauth_facebook_id_12 , t0 . oauth_keycloak_id AS oauth_keycloak_id_13 , t0 . hide_adult AS hide_adult_14 , t0 . show_subscribed_users AS show_subscribed_users_15 , t0 . show_subscribed_magazines AS show_subscribed_magazines_16 , t0 . show_subscribed_domains AS show_subscribed_domains_17 , t0 . preferred_languages AS preferred_languages_18 , t0 . featured_magazines AS featured_magazines_19 , t0 . show_profile_subscriptions AS show_profile_subscriptions_20 , t0 . show_profile_followings AS show_profile_followings_21 , t0 . mark_new_comments AS mark_new_comments_22 , t0 . notify_on_new_entry AS notify_on_new_entry_23 , t0 . notify_on_new_entry_reply AS notify_on_new_entry_reply_24 , t0 . notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25 , t0 . notify_on_new_post AS notify_on_new_post_26 , t0 . notify_on_new_post_reply AS notify_on_new_post_reply_27 , t0 . notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28 , t0 . add_mentions_entries AS add_mentions_entries_29 , t0 . add_mentions_posts AS add_mentions_posts_30 , t0 . is_banned AS is_banned_31 , t0 . is_verified AS is_verified_32 , t0 . is_deleted AS is_deleted_33 , t0 . is_bot AS is_bot_34 , t0 . spam_protection AS spam_protection_35 , t0 . custom_css AS custom_css_36 , t0 . ignore_magazines_custom_css AS ignore_magazines_custom_css_37 , t0 . id AS id_38 , t0 . password AS password_39 , t0 . totp_secret AS totp_secret_40 , t0 . totp_backup_codes AS totp_backup_codes_41 , t0 . ap_id AS ap_id_42 , t0 . ap_profile_id AS ap_profile_id_43 , t0 . ap_public_url AS ap_public_url_44 , t0 . ap_followers_url AS ap_followers_url_45 , t0 . ap_inbox_url AS ap_inbox_url_46 , t0 . ap_domain AS ap_domain_47 , t0 . ap_preferred_username AS ap_preferred_username_48 , t0 . ap_discoverable AS ap_discoverable_49 , t0 . ap_manually_approves_followers AS ap_manually_approves_followers_50 , t0 . private_key AS private_key_51 , t0 . public_key AS public_key_52 , t0 . ap_fetched_at AS ap_fetched_at_53 , t0 . ap_deleted_at AS ap_deleted_at_54 , t0 . ap_timeout_at AS ap_timeout_at_55 , t0 . visibility AS visibility_56 , t0 . created_at AS created_at_57 , t0 . avatar_id AS avatar_id_58 , t0 . cover_id AS cover_id_59 FROM "user" t0 WHERE t0 . id = ?
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 = 35357 ;
Copy
9
3.17 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 = 38701 ;
Copy
10
2.81 ms
SELECT t0 . email AS email_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . followers_count AS followers_count_4 , t0 . homepage AS homepage_5 , t0 . about AS about_6 , t0 . last_active AS last_active_7 , t0 . marked_for_deletion_at AS marked_for_deletion_at_8 , t0 . fields AS fields_9 , t0 . oauth_github_id AS oauth_github_id_10 , t0 . oauth_google_id AS oauth_google_id_11 , t0 . oauth_facebook_id AS oauth_facebook_id_12 , t0 . oauth_keycloak_id AS oauth_keycloak_id_13 , t0 . hide_adult AS hide_adult_14 , t0 . show_subscribed_users AS show_subscribed_users_15 , t0 . show_subscribed_magazines AS show_subscribed_magazines_16 , t0 . show_subscribed_domains AS show_subscribed_domains_17 , t0 . preferred_languages AS preferred_languages_18 , t0 . featured_magazines AS featured_magazines_19 , t0 . show_profile_subscriptions AS show_profile_subscriptions_20 , t0 . show_profile_followings AS show_profile_followings_21 , t0 . mark_new_comments AS mark_new_comments_22 , t0 . notify_on_new_entry AS notify_on_new_entry_23 , t0 . notify_on_new_entry_reply AS notify_on_new_entry_reply_24 , t0 . notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25 , t0 . notify_on_new_post AS notify_on_new_post_26 , t0 . notify_on_new_post_reply AS notify_on_new_post_reply_27 , t0 . notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28 , t0 . add_mentions_entries AS add_mentions_entries_29 , t0 . add_mentions_posts AS add_mentions_posts_30 , t0 . is_banned AS is_banned_31 , t0 . is_verified AS is_verified_32 , t0 . is_deleted AS is_deleted_33 , t0 . is_bot AS is_bot_34 , t0 . spam_protection AS spam_protection_35 , t0 . custom_css AS custom_css_36 , t0 . ignore_magazines_custom_css AS ignore_magazines_custom_css_37 , t0 . id AS id_38 , t0 . password AS password_39 , t0 . totp_secret AS totp_secret_40 , t0 . totp_backup_codes AS totp_backup_codes_41 , t0 . ap_id AS ap_id_42 , t0 . ap_profile_id AS ap_profile_id_43 , t0 . ap_public_url AS ap_public_url_44 , t0 . ap_followers_url AS ap_followers_url_45 , t0 . ap_inbox_url AS ap_inbox_url_46 , t0 . ap_domain AS ap_domain_47 , t0 . ap_preferred_username AS ap_preferred_username_48 , t0 . ap_discoverable AS ap_discoverable_49 , t0 . ap_manually_approves_followers AS ap_manually_approves_followers_50 , t0 . private_key AS private_key_51 , t0 . public_key AS public_key_52 , t0 . ap_fetched_at AS ap_fetched_at_53 , t0 . ap_deleted_at AS ap_deleted_at_54 , t0 . ap_timeout_at AS ap_timeout_at_55 , t0 . visibility AS visibility_56 , t0 . created_at AS created_at_57 , t0 . avatar_id AS avatar_id_58 , t0 . cover_id AS cover_id_59 FROM "user" t0 WHERE t0 . id = ?
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 = 31700 ;
Copy
11
0.73 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 = 29191 ;
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 = 4427 ;
Copy
13
0.80 ms
SELECT t0 . email AS email_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . followers_count AS followers_count_4 , t0 . homepage AS homepage_5 , t0 . about AS about_6 , t0 . last_active AS last_active_7 , t0 . marked_for_deletion_at AS marked_for_deletion_at_8 , t0 . fields AS fields_9 , t0 . oauth_github_id AS oauth_github_id_10 , t0 . oauth_google_id AS oauth_google_id_11 , t0 . oauth_facebook_id AS oauth_facebook_id_12 , t0 . oauth_keycloak_id AS oauth_keycloak_id_13 , t0 . hide_adult AS hide_adult_14 , t0 . show_subscribed_users AS show_subscribed_users_15 , t0 . show_subscribed_magazines AS show_subscribed_magazines_16 , t0 . show_subscribed_domains AS show_subscribed_domains_17 , t0 . preferred_languages AS preferred_languages_18 , t0 . featured_magazines AS featured_magazines_19 , t0 . show_profile_subscriptions AS show_profile_subscriptions_20 , t0 . show_profile_followings AS show_profile_followings_21 , t0 . mark_new_comments AS mark_new_comments_22 , t0 . notify_on_new_entry AS notify_on_new_entry_23 , t0 . notify_on_new_entry_reply AS notify_on_new_entry_reply_24 , t0 . notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25 , t0 . notify_on_new_post AS notify_on_new_post_26 , t0 . notify_on_new_post_reply AS notify_on_new_post_reply_27 , t0 . notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28 , t0 . add_mentions_entries AS add_mentions_entries_29 , t0 . add_mentions_posts AS add_mentions_posts_30 , t0 . is_banned AS is_banned_31 , t0 . is_verified AS is_verified_32 , t0 . is_deleted AS is_deleted_33 , t0 . is_bot AS is_bot_34 , t0 . spam_protection AS spam_protection_35 , t0 . custom_css AS custom_css_36 , t0 . ignore_magazines_custom_css AS ignore_magazines_custom_css_37 , t0 . id AS id_38 , t0 . password AS password_39 , t0 . totp_secret AS totp_secret_40 , t0 . totp_backup_codes AS totp_backup_codes_41 , t0 . ap_id AS ap_id_42 , t0 . ap_profile_id AS ap_profile_id_43 , t0 . ap_public_url AS ap_public_url_44 , t0 . ap_followers_url AS ap_followers_url_45 , t0 . ap_inbox_url AS ap_inbox_url_46 , t0 . ap_domain AS ap_domain_47 , t0 . ap_preferred_username AS ap_preferred_username_48 , t0 . ap_discoverable AS ap_discoverable_49 , t0 . ap_manually_approves_followers AS ap_manually_approves_followers_50 , t0 . private_key AS private_key_51 , t0 . public_key AS public_key_52 , t0 . ap_fetched_at AS ap_fetched_at_53 , t0 . ap_deleted_at AS ap_deleted_at_54 , t0 . ap_timeout_at AS ap_timeout_at_55 , t0 . visibility AS visibility_56 , t0 . created_at AS created_at_57 , t0 . avatar_id AS avatar_id_58 , t0 . cover_id AS cover_id_59 FROM "user" t0 WHERE t0 . id = ?
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 = 25962 ;
Copy
14
0.79 ms
SELECT t0 . email AS email_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . followers_count AS followers_count_4 , t0 . homepage AS homepage_5 , t0 . about AS about_6 , t0 . last_active AS last_active_7 , t0 . marked_for_deletion_at AS marked_for_deletion_at_8 , t0 . fields AS fields_9 , t0 . oauth_github_id AS oauth_github_id_10 , t0 . oauth_google_id AS oauth_google_id_11 , t0 . oauth_facebook_id AS oauth_facebook_id_12 , t0 . oauth_keycloak_id AS oauth_keycloak_id_13 , t0 . hide_adult AS hide_adult_14 , t0 . show_subscribed_users AS show_subscribed_users_15 , t0 . show_subscribed_magazines AS show_subscribed_magazines_16 , t0 . show_subscribed_domains AS show_subscribed_domains_17 , t0 . preferred_languages AS preferred_languages_18 , t0 . featured_magazines AS featured_magazines_19 , t0 . show_profile_subscriptions AS show_profile_subscriptions_20 , t0 . show_profile_followings AS show_profile_followings_21 , t0 . mark_new_comments AS mark_new_comments_22 , t0 . notify_on_new_entry AS notify_on_new_entry_23 , t0 . notify_on_new_entry_reply AS notify_on_new_entry_reply_24 , t0 . notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25 , t0 . notify_on_new_post AS notify_on_new_post_26 , t0 . notify_on_new_post_reply AS notify_on_new_post_reply_27 , t0 . notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28 , t0 . add_mentions_entries AS add_mentions_entries_29 , t0 . add_mentions_posts AS add_mentions_posts_30 , t0 . is_banned AS is_banned_31 , t0 . is_verified AS is_verified_32 , t0 . is_deleted AS is_deleted_33 , t0 . is_bot AS is_bot_34 , t0 . spam_protection AS spam_protection_35 , t0 . custom_css AS custom_css_36 , t0 . ignore_magazines_custom_css AS ignore_magazines_custom_css_37 , t0 . id AS id_38 , t0 . password AS password_39 , t0 . totp_secret AS totp_secret_40 , t0 . totp_backup_codes AS totp_backup_codes_41 , t0 . ap_id AS ap_id_42 , t0 . ap_profile_id AS ap_profile_id_43 , t0 . ap_public_url AS ap_public_url_44 , t0 . ap_followers_url AS ap_followers_url_45 , t0 . ap_inbox_url AS ap_inbox_url_46 , t0 . ap_domain AS ap_domain_47 , t0 . ap_preferred_username AS ap_preferred_username_48 , t0 . ap_discoverable AS ap_discoverable_49 , t0 . ap_manually_approves_followers AS ap_manually_approves_followers_50 , t0 . private_key AS private_key_51 , t0 . public_key AS public_key_52 , t0 . ap_fetched_at AS ap_fetched_at_53 , t0 . ap_deleted_at AS ap_deleted_at_54 , t0 . ap_timeout_at AS ap_timeout_at_55 , t0 . visibility AS visibility_56 , t0 . created_at AS created_at_57 , t0 . avatar_id AS avatar_id_58 , t0 . cover_id AS cover_id_59 FROM "user" t0 WHERE t0 . id = ?
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 = 16297 ;
Copy
15
0.88 ms
SELECT t0 . email AS email_1 , t0 . username AS username_2 , t0 . roles AS roles_3 , t0 . followers_count AS followers_count_4 , t0 . homepage AS homepage_5 , t0 . about AS about_6 , t0 . last_active AS last_active_7 , t0 . marked_for_deletion_at AS marked_for_deletion_at_8 , t0 . fields AS fields_9 , t0 . oauth_github_id AS oauth_github_id_10 , t0 . oauth_google_id AS oauth_google_id_11 , t0 . oauth_facebook_id AS oauth_facebook_id_12 , t0 . oauth_keycloak_id AS oauth_keycloak_id_13 , t0 . hide_adult AS hide_adult_14 , t0 . show_subscribed_users AS show_subscribed_users_15 , t0 . show_subscribed_magazines AS show_subscribed_magazines_16 , t0 . show_subscribed_domains AS show_subscribed_domains_17 , t0 . preferred_languages AS preferred_languages_18 , t0 . featured_magazines AS featured_magazines_19 , t0 . show_profile_subscriptions AS show_profile_subscriptions_20 , t0 . show_profile_followings AS show_profile_followings_21 , t0 . mark_new_comments AS mark_new_comments_22 , t0 . notify_on_new_entry AS notify_on_new_entry_23 , t0 . notify_on_new_entry_reply AS notify_on_new_entry_reply_24 , t0 . notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25 , t0 . notify_on_new_post AS notify_on_new_post_26 , t0 . notify_on_new_post_reply AS notify_on_new_post_reply_27 , t0 . notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28 , t0 . add_mentions_entries AS add_mentions_entries_29 , t0 . add_mentions_posts AS add_mentions_posts_30 , t0 . is_banned AS is_banned_31 , t0 . is_verified AS is_verified_32 , t0 . is_deleted AS is_deleted_33 , t0 . is_bot AS is_bot_34 , t0 . spam_protection AS spam_protection_35 , t0 . custom_css AS custom_css_36 , t0 . ignore_magazines_custom_css AS ignore_magazines_custom_css_37 , t0 . id AS id_38 , t0 . password AS password_39 , t0 . totp_secret AS totp_secret_40 , t0 . totp_backup_codes AS totp_backup_codes_41 , t0 . ap_id AS ap_id_42 , t0 . ap_profile_id AS ap_profile_id_43 , t0 . ap_public_url AS ap_public_url_44 , t0 . ap_followers_url AS ap_followers_url_45 , t0 . ap_inbox_url AS ap_inbox_url_46 , t0 . ap_domain AS ap_domain_47 , t0 . ap_preferred_username AS ap_preferred_username_48 , t0 . ap_discoverable AS ap_discoverable_49 , t0 . ap_manually_approves_followers AS ap_manually_approves_followers_50 , t0 . private_key AS private_key_51 , t0 . public_key AS public_key_52 , t0 . ap_fetched_at AS ap_fetched_at_53 , t0 . ap_deleted_at AS ap_deleted_at_54 , t0 . ap_timeout_at AS ap_timeout_at_55 , t0 . visibility AS visibility_56 , t0 . created_at AS created_at_57 , t0 . avatar_id AS avatar_id_58 , t0 . cover_id AS cover_id_59 FROM "user" t0 WHERE t0 . id = ?
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 = 28908 ;
Copy
16
0.67 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 = 52649 ;
Copy
17
4.57 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 = 93 );
Copy
18
0.48 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 = 93 ;
Copy
19
0.99 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 = 93 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
20
6.35 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 :
[
"%baldurs_gate_3lemmy.world% "
"%baldurs_gate_3lemmy.world% "
"%baldurs_gate_3lemmy.world% "
"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 '%baldurs_gate_3lemmy.world%' OR LOWER (m0_ . description ) LIKE '%baldurs_gate_3lemmy.world%' OR LOWER (m0_ . name ) LIKE '%baldurs_gate_3lemmy.world%' ) AND m0_ . is_adult = false AND m0_ . visibility = 'visible' LIMIT 5 ;
Copy
21
14.34 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 " => 93
]
(SELECT count (id ), user_id FROM entry WHERE magazine_id = 93 GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM entry_comment WHERE magazine_id = 93 GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM post WHERE magazine_id = 93 GROUP BY user_id ORDER BY count DESC LIMIT 50 )
UNION
(SELECT count (id ), user_id FROM post_comment WHERE magazine_id = 93 GROUP BY user_id ORDER BY count DESC LIMIT 50 )
ORDER BY count DESC ;
Copy
22
6.99 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 (40365 , 12254 , 6053 , 48310 , 37132 , 21219 , 52649 , 21016 , 7776 , 65957 , 55677 , 47358 , 43686 , 25107 , 2946 , 43442 , 25250 , 28432 , 19404 , 50686 , 76883 , 44700 , 19286 , 48678 , 12241 , 1997 , 28043 , 46007 , 86248 , 2615 , 68837 , 30465 , 78956 , 650 , 54459 , 64998 , 42029 , 29294 , 58869 , 58763 , 39611 , 13958 , 78988 , 27377 , 55575 , 20009 , 46823 , 1374 , 27445 , 56202 , 14942 , 24933 , 38972 , 64736 , 42222 , 80575 , 43495 , 18819 , 93170 , 80099 , 58348 , 86090 , 80752 , 53785 , 46498 , 58813 , 35109 , 25226 , 82746 , 30376 , 30672 , 8175 , 67375 , 21455 , 53425 , 43091 , 68672 , 32961 , 24524 , 64061 , 83505 , 57875 , 24387 , 64444 , 32575 , 22942 , 85264 , 49828 , 59214 ) 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 (
40365 , 12254 , 6053 , 48310 , 37132 , 21219 ,
52649 , 21016 , 7776 , 65957 , 55677 , 47358 ,
43686 , 25107 , 2946 , 43442 , 25250 , 28432 ,
19404 , 50686 , 76883 , 44700 , 19286 ,
48678 , 12241 , 1997 , 28043 , 46007 , 86248 ,
2615 , 68837 , 30465 , 78956 , 650 , 54459 ,
64998 , 42029 , 29294 , 58869 , 58763 ,
39611 , 13958 , 78988 , 27377 , 55575 ,
20009 , 46823 , 1374 , 27445 , 56202 , 14942 ,
24933 , 38972 , 64736 , 42222 , 80575 ,
43495 , 18819 , 93170 , 80099 , 58348 ,
86090 , 80752 , 53785 , 46498 , 58813 ,
35109 , 25226 , 82746 , 30376 , 30672 ,
8175 , 67375 , 21455 , 53425 , 43091 , 68672 ,
32961 , 24524 , 64061 , 83505 , 57875 ,
24387 , 64444 , 32575 , 22942 , 85264 ,
49828 , 59214
)
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 (40365 , 12254 , 6053 , 48310 , 37132 , 21219 , 52649 , 21016 , 7776 , 65957 , 55677 , 47358 , 43686 , 25107 , 2946 , 43442 , 25250 , 28432 , 19404 , 50686 , 76883 , 44700 , 19286 , 48678 , 12241 , 1997 , 28043 , 46007 , 86248 , 2615 , 68837 , 30465 , 78956 , 650 , 54459 , 64998 , 42029 , 29294 , 58869 , 58763 , 39611 , 13958 , 78988 , 27377 , 55575 , 20009 , 46823 , 1374 , 27445 , 56202 , 14942 , 24933 , 38972 , 64736 , 42222 , 80575 , 43495 , 18819 , 93170 , 80099 , 58348 , 86090 , 80752 , 53785 , 46498 , 58813 , 35109 , 25226 , 82746 , 30376 , 30672 , 8175 , 67375 , 21455 , 53425 , 43091 , 68672 , 32961 , 24524 , 64061 , 83505 , 57875 , 24387 , 64444 , 32575 , 22942 , 85264 , 49828 , 59214 ) 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
23
1.40 ms
SELECT t0 . file_path AS file_path_1 , t0 . file_name AS file_name_2 , t0 . sha256 AS sha256_3 , t0 . width AS width_4 , t0 . height AS height_5 , t0 . blurhash AS blurhash_6 , t0 . alt_text AS alt_text_7 , t0 . source_url AS source_url_8 , t0 . id AS id_9 FROM image t0 WHERE t0 . id = ?
SELECT t0 . file_path AS file_path_1 , t0 . file_name AS file_name_2 , t0 . sha256 AS sha256_3 , t0 . width AS width_4 , t0 . height AS height_5 , t0 . blurhash AS blurhash_6 , t0 . alt_text AS alt_text_7 , t0 . source_url AS source_url_8 , t0 . id AS id_9 FROM image t0 WHERE t0 . id = 46924 ;
Copy
24
0.78 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 :
[
"%baldurs_gate_3lemmy.world% "
"%baldurs_gate_3lemmy.world% "
]
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 '%baldurs_gate_3lemmy.world%' OR LOWER (c0_ . description ) LIKE '%baldurs_gate_3lemmy.world%' ) AND c0_ . is_private = false LIMIT 5 ;
Copy