GET https://kbin.spritesserver.nl/*/hot/1y?p=628

Response
200 OK
IP
18.225.149.238
Profiled on
Token
dbf5a3

Query Metrics

3 Database Queries
3 Different statements
510.94 ms Query time
0 Invalid entities
21 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 479.00 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.is_adult = false
            AND m_entry.is_adult = false
            
            AND (entry.created_at BETWEEN :timeFrom AND :timeTo)
            
        )
        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.is_adult = false
            AND m_post.is_adult = false
            
            AND (post.created_at BETWEEN :timeFrom AND :timeTo)
            
        )
        ORDER BY ranking DESC, created_at DESC LIMIT 25000
Parameters: 
[
  "visibility" => "visible"
  "timeFrom" => "2023-09-30 18:22:40"
  "timeTo" => "2024-09-30 18:22:40"
]
View formatted query    View runnable query    Explain query
2 30.58 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  30016
  30013
  30012
  30011
  30009
  30008
  30007
  30006
  30004
  30002
  30003
  30001
  29996
  29998
  29999
  29994
  29992
  29991
  29988
  29990
  29987
  29986
  29984
  29985
  29982
]
View formatted query    View runnable query    Explain query
3 1.36 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

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

21 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
app_entity_settings 16
app_entity_magazine 3
app_entity_user 1
app_entity_domain 1

Entities Mapping

Class Mapping errors
App\Entity\Entry No errors.
App\Entity\User No errors.
App\Entity\Magazine No errors.
App\Entity\Image No errors.
App\Entity\Domain No errors.
App\Entity\EntryComment No errors.
App\Entity\Vote No errors.
App\Entity\EntryVote No errors.
App\Entity\Report No errors.
App\Entity\EntryReport No errors.
App\Entity\Favourite No errors.
App\Entity\EntryFavourite No errors.
App\Entity\Notification No errors.
App\Entity\EntryCreatedNotification No errors.
App\Entity\EntryBadge No errors.
App\Entity\Post No errors.
App\Entity\Settings No errors.
App\Entity\Moderator No errors.
App\Entity\MagazineOwnershipRequest No errors.
App\Entity\ModeratorRequest No errors.
App\Entity\MagazineSubscription No errors.
App\Entity\MagazineBan No errors.
App\Entity\Badge No errors.
App\Entity\MagazineLog No errors.
App\Entity\Award No errors.
App\Entity\CategoryMagazine No errors.
App\Entity\EntryCommentVote No errors.
App\Entity\PostVote No errors.
App\Entity\PostComment No errors.
App\Entity\PostCommentVote 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\CategorySubscription No errors.
App\Entity\Category No errors.
App\Entity\OAuth2UserConsent No errors.