GET https://kbin.spritesserver.nl/d/hexbear.net/top/1m/videos?p=1

Response
200 OK
IP
3.133.156.208
Profiled on
Token
60fe62

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 3.41 ms 
SELECT t0.name AS name_1, t0.entry_count AS entry_count_2, t0.subscriptions_count AS subscriptions_count_3, t0.id AS id_4 FROM domain t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "hexbear.net"
]
View formatted query    View runnable query    Explain query
2 20.33 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 d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY e0_.score DESC, e0_.created_at DESC, e0_.id DESC LIMIT 25
Parameters: 
[
  "visible"
  "visible"
  "2024-08-19 19:26:06+0000"
  "2024-09-19 19:26:06+0000"
  "video"
  "hexbear.net"
  0
  0
]
View formatted query    View runnable query    Explain query
3 22.83 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 d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY sclr_0 ASC
Parameters: 
[
  "visible"
  "visible"
  "2024-08-19 19:26:06+0000"
  "2024-09-19 19:26:06+0000"
  "video"
  "hexbear.net"
  0
  0
]
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

18 Hits
1 Misses
1 Puts

Number of cache hits

Region Hits
app_entity_settings 16
app_entity_magazine 2

Number of cache misses

Region Misses
app_entity_domain 1

Number of cache puts

Region Puts
app_entity_domain 1

Entities Mapping

Class Mapping errors
App\Entity\Domain No errors.
App\Entity\Entry No errors.
App\Entity\DomainSubscription No errors.
App\Entity\Settings No errors.
App\Entity\Magazine No 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\Post No errors.
App\Entity\MagazineSubscription No errors.
App\Entity\MagazineBan No errors.
App\Entity\Report No errors.
App\Entity\Badge No errors.
App\Entity\MagazineLog No errors.
App\Entity\Award No errors.
App\Entity\CategoryMagazine No errors.