GET https://kbin.spritesserver.nl/top/1y/videos?p=4

Response
200 OK
IP
3.147.76.250
Profiled on
Token
17b6c6

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 14.80 ms 
SELECT count(e0_.id) AS sclr_0 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND (e0_.created_at BETWEEN ? AND ?) AND e0_.type = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY sclr_0 ASC
Parameters: 
[
  "visible"
  "visible"
  "2024-01-18 10:18:46+0000"
  "2025-01-18 10:18:46+0000"
  "video"
  0
  0
]
View formatted query    View runnable query    Explain query
2 5.06 ms 
SELECT e0_.slug AS slug_0, e0_.title AS title_1, e0_.url AS url_2, e0_.body AS body_3, e0_.type AS type_4, e0_.lang AS lang_5, e0_.is_oc AS is_oc_6, e0_.has_embed AS has_embed_7, e0_.comment_count AS comment_count_8, e0_.favourite_count AS favourite_count_9, e0_.score AS score_10, e0_.is_adult AS is_adult_11, e0_.sticky AS sticky_12, e0_.last_active AS last_active_13, e0_.ip AS ip_14, e0_.ada_amount AS ada_amount_15, e0_.tags AS tags_16, e0_.mentions AS mentions_17, e0_.id AS id_18, e0_.title_ts AS title_ts_19, e0_.body_ts AS body_ts_20, e0_.up_votes AS up_votes_21, e0_.down_votes AS down_votes_22, e0_.ranking AS ranking_23, e0_.visibility AS visibility_24, e0_.ap_id AS ap_id_25, e0_.edited_at AS edited_at_26, e0_.created_at AS created_at_27, e0_.user_id AS user_id_28, e0_.magazine_id AS magazine_id_29, e0_.image_id AS image_id_30, e0_.domain_id AS domain_id_31 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND (e0_.created_at BETWEEN ? AND ?) AND e0_.type = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY e0_.score DESC, e0_.created_at DESC, e0_.id DESC LIMIT 25 OFFSET 75
Parameters: 
[
  "visible"
  "visible"
  "2024-01-18 10:18:46+0000"
  "2025-01-18 10:18:46+0000"
  "video"
  0
  0
]
View formatted query    View runnable query    Explain query
3 13.18 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: 
[
  49538
]
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
1 Misses
1 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_image 1

Number of cache puts

Region Puts
app_entity_image 1

Entities Mapping

Class Mapping errors
App\Entity\Entry No errors.
App\Entity\Magazine No errors.
App\Entity\User No errors.
App\Entity\Domain No errors.
App\Entity\Image 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\Settings No errors.
App\Entity\Moderator No errors.
App\Entity\MagazineOwnershipRequest No errors.
App\Entity\ModeratorRequest No errors.
App\Entity\Post 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.