GET https://kbin.spritesserver.nl/d/chia.owly.net/newest/3h/links

Query Metrics

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

Group similar statements

# Time Info
1 2.85 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:
0 of 0
[ "chia.owly.net" ]
2 8.16 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_.created_at DESC, e0_.id DESC LIMIT 25
Parameters:
0 of 0
[ "visible" "visible" "2025-02-22 11:51:05+0000" "2025-02-22 14:51:05+0000" "link" "chia.owly.net" 0 0 ]
3 2.19 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:
0 of 0
[ "visible" "visible" "2025-02-22 11:51:05+0000" "2025-02-22 14:51:05+0000" "link" "chia.owly.net" 0 0 ]