GET https://kbin.spritesserver.nl/u/@Tavarin@lemmy.world

Response
200 OK
IP
3.16.78.138
Profiled on
Token
e97e46

Query Metrics

20 Database Queries
19 Different statements
378.92 ms Query time
0 Invalid entities
21 Cache hits
3 Cache misses
4 Cache puts

Queries

Group similar statements

#▲ Time Info
1 15.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.username = ? LIMIT 1
Parameters: 
[
  "@Tavarin@lemmy.world"
]
View formatted query    View runnable query    Explain query
2 29.40 ms 
(
        SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type 
        FROM entry 
        INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id 
        INNER JOIN "user" u_entry ON entry.user_id = u_entry.id
        
            WHERE entry.visibility = :visibility
            AND m_entry.visibility = :visibility
            
            AND entry.user_id = :criteria_user
            
            AND entry.is_adult = false
            AND m_entry.is_adult = false
            
        )
        UNION
        (
        SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type 
        FROM post 
        INNER JOIN magazine m_post ON post.magazine_id = m_post.id 
        INNER JOIN "user" u_post ON post.user_id = u_post.id
        
            WHERE post.visibility = :visibility
            AND m_post.visibility = :visibility
            
            AND post.user_id = :criteria_user
            
            AND post.is_adult = false
            AND m_post.is_adult = false
            
        )
        
        UNION
        (
        SELECT entry_comment.id, entry_comment.created_at, entry_comment.score, entry_comment.score + entry_comment.favourite_count AS ranking, entry_comment.last_active, 0 as comment_count, 'entry_comment' AS type 
        FROM entry_comment 
        INNER JOIN magazine m_entry_comment ON entry_comment.magazine_id = m_entry_comment.id 
        INNER JOIN "user" u_entry_comment ON entry_comment.user_id = u_entry_comment.id
        
            WHERE entry_comment.visibility = :visibility
            AND m_entry_comment.visibility = :visibility
            
            AND entry_comment.user_id = :criteria_user
            
            AND entry_comment.is_adult = false
            AND m_entry_comment.is_adult = false
            
        )
        UNION
        (
        SELECT post_comment.id, post_comment.created_at, post_comment.score, post_comment.score + post_comment.favourite_count AS ranking, post_comment.last_active, 0 as comment_count, 'post_comment' AS type 
        FROM post_comment 
        INNER JOIN magazine m_post_comment ON post_comment.magazine_id = m_post_comment.id 
        INNER JOIN "user" u_post_comment ON post_comment.user_id = u_post_comment.id
        
            WHERE post_comment.visibility = :visibility
            AND m_post_comment.visibility = :visibility
            
            AND post_comment.user_id = :criteria_user
            
            AND post_comment.is_adult = false
            AND m_post_comment.is_adult = false
            
        )
        ORDER BY created_at DESC, created_at DESC LIMIT 25000
Parameters: 
[
  "visibility" => "visible"
  "criteria_user" => 33827
]
View formatted query    View runnable query    Explain query
3 19.11 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 IN (NULL)
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 17.81 ms 
SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL)
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 23.11 ms 
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.id IN (?)
Parameters: 
[
  23246
]
View formatted query    View runnable query    Explain query
6 85.73 ms 
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?)
Parameters: 
[
  23246
]
View formatted query    View runnable query    Explain query
7 15.65 ms 
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.id IN (NULL)
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 17.54 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 = ?
Parameters: 
[
  1539
]
View formatted query    View runnable query    Explain query
9 5.13 ms 
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  22543
]
View formatted query    View runnable query    Explain query
10 11.82 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.user_id = ?
Parameters: 
[
  33827
]
View formatted query    View runnable query    Explain query
11 23.52 ms 
SELECT COUNT(*) FROM entry_comment t0 WHERE t0.user_id = ?
Parameters: 
[
  33827
]
View formatted query    View runnable query    Explain query
12 14.64 ms 
SELECT COUNT(*) FROM post t0 WHERE t0.user_id = ?
Parameters: 
[
  33827
]
View formatted query    View runnable query    Explain query
13 8.63 ms 
SELECT COUNT(*) FROM post_comment t0 WHERE t0.user_id = ?
Parameters: 
[
  33827
]
View formatted query    View runnable query    Explain query
14 11.80 ms 
(SELECT entry_id as id, created_at, 'entry' AS type FROM entry_vote WHERE user_id = :userId AND choice = 1)
        UNION
        (SELECT comment_id as id, created_at, 'entry_comment' AS type FROM entry_comment_vote WHERE user_id = :userId AND choice = 1)
        UNION
        (SELECT post_id as id, created_at, 'post' AS type FROM post_vote WHERE user_id = :userId AND choice = 1)
        UNION
        (SELECT comment_id as id, created_at, 'post_comment' AS type FROM post_comment_vote WHERE user_id = :userId AND choice = 1)
        ORDER BY created_at DESC
Parameters: 
[
  "userId" => 33827
]
View formatted query    View runnable query    Explain query
15 0.79 ms 
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.follower_id AS follower_id_3, t0.following_id AS following_id_4 FROM user_follow t0 WHERE t0.follower_id = ? ORDER BY t0.created_at DESC
Parameters: 
[
  33827
]
View formatted query    View runnable query    Explain query
16 2.69 ms 
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.follower_id AS follower_id_3, t0.following_id AS following_id_4 FROM user_follow t0 WHERE t0.following_id = ? ORDER BY t0.created_at DESC
Parameters: 
[
  33827
]
View formatted query    View runnable query    Explain query
17 5.30 ms 
SELECT
                    (SELECT SUM(
            (SELECT COUNT(id) FROM entry_vote WHERE author_id = :user AND user_id != :user AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM entry_vote WHERE author_id = :user AND user_id != :user AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM entry_comment_vote WHERE author_id = :user AND user_id != :user AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM entry_comment_vote WHERE author_id = :user AND user_id != :user AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM post_vote WHERE author_id = :user AND user_id != :user AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM post_vote WHERE author_id = :user AND user_id != :user AND choice = -1)
        )) +
                    (SELECT SUM(
            (SELECT COUNT(id) FROM post_comment_vote WHERE author_id = :user AND user_id != :user AND choice = 1) * 2 -
            (SELECT COUNT(id) FROM post_comment_vote WHERE author_id = :user AND user_id != :user AND choice = -1)
        )) as total
Parameters: 
[
  "user" => 33827
]
View formatted query    View runnable query    Explain query
18 21.80 ms 
SELECT
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN entry fj ON f.entry_id = fj.id
                WHERE fj.user_id = :user AND f.user_id != :user) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN entry_comment fj ON f.entry_comment_id = fj.id
                WHERE fj.user_id = :user AND f.user_id != :user) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN post fj ON f.post_id = fj.id
                WHERE fj.user_id = :user AND f.user_id != :user) +
                    (SELECT count(f.id)
                FROM favourite f
                LEFT JOIN post_comment fj ON f.post_comment_id = fj.id
                WHERE fj.user_id = :user AND f.user_id != :user) as total
Parameters: 
[
  "user" => 33827
]
View formatted query    View runnable query    Explain query
19 18.59 ms 
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  10729
]
View formatted query    View runnable query    Explain query
20 29.93 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_.id IN (SELECT m1_.magazine_id AS sclr_32 FROM moderator m1_ WHERE m1_.user_id = ?) ORDER BY m0_.ap_id DESC, m0_.last_active DESC
Parameters: 
[
  33827
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

21 Hits
3 Misses
4 Puts

Number of cache hits

Region Hits
app_entity_settings 16
app_entity_magazine 3
app_entity_user 1
app_entity_domain 1

Number of cache misses

Region Misses
app_entity_user 1
app_entity_image 2

Number of cache puts

Region Puts
app_entity_user 2
app_entity_image 2

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Image No errors.
App\Entity\Moderator No errors.
App\Entity\MagazineOwnershipRequest No errors.
App\Entity\ModeratorRequest No errors.
App\Entity\Entry No errors.
App\Entity\Vote No errors.
App\Entity\EntryVote No errors.
App\Entity\EntryComment No errors.
App\Entity\EntryCommentVote No errors.
App\Entity\Post No errors.
App\Entity\PostVote No errors.
App\Entity\PostComment No errors.
App\Entity\PostCommentVote No errors.
App\Entity\MagazineSubscription No errors.
App\Entity\DomainSubscription No errors.
App\Entity\UserFollow No errors.
App\Entity\UserBlock No errors.
App\Entity\MagazineBlock No errors.
App\Entity\DomainBlock No errors.
App\Entity\Report No errors.
App\Entity\Favourite No errors.
App\Entity\Notification No errors.
App\Entity\Award No errors.
App\Entity\CategorySubscription No errors.
App\Entity\Category No errors.
App\Entity\OAuth2UserConsent No errors.
App\Entity\Settings No errors.
App\Entity\Magazine No errors.
App\Entity\Domain No errors.
App\Entity\EntryCommentReport No errors.
App\Entity\EntryCommentFavourite No errors.
App\Entity\EntryCommentCreatedNotification No errors.
App\Entity\EntryReport No errors.
App\Entity\EntryFavourite No errors.
App\Entity\EntryCreatedNotification No errors.
App\Entity\EntryBadge No errors.
App\Entity\Site No errors.
App\Entity\MagazineBan No errors.
App\Entity\Badge No errors.
App\Entity\MagazineLog No errors.
App\Entity\CategoryMagazine No errors.