GET https://kbin.spritesserver.nl/m/memes@lemmy.ml/t/25999/Pleae-someone-What-s-the-safe-word/favourites

Query Metrics

7 Database Queries
7 Different statements
44.38 ms Query time
0 Invalid entities
27 Cache hits
1 Cache misses
1 Cache puts

Grouped Statements

Show all queries

Time Count Info
19.92 ms
(44.89%)
1
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:
[
  44794
]
10.75 ms
(24.21%)
1
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:
[
  "25999"
]
9.19 ms
(20.71%)
1
SELECT COUNT(*) FROM favourite t0 WHERE t0.entry_id = ? AND t0.favourite_type IN ('entry')
Parameters:
[
  25999
]
1.45 ms
(3.26%)
1
SELECT COUNT(*) FROM magazine_log t0 WHERE t0.magazine_id = ? AND t0.log_type IN ('entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban')
Parameters:
[
  38
]
1.36 ms
(3.06%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.magazine_id AS magazine_id_3, t0.user_id AS user_id_4, t0.entry_id AS entry_id_5, t0.favourite_type FROM favourite t0 WHERE t0.entry_id = ? AND t0.favourite_type IN ('entry') ORDER BY t0.created_at DESC
Parameters:
[
  25999
]
1.27 ms
(2.87%)
1
SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0.is_owner = ? AND t0.magazine_id = ?)
Parameters:
[
  1
  38
]
0.44 ms
(0.99%)
1
SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = ?
Parameters:
[
  38
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

27 Hits
1 Misses
1 Puts

Number of cache hits

Region Hits
app_entity_magazine 4
app_entity_settings 16
app_entity_user 3
app_entity_domain 1
app_entity_image 3

Number of cache misses

Region Misses
app_entity_image 1

Number of cache puts

Region Puts
app_entity_image 1