GET https://kbin.spritesserver.nl/index.php/m/linuxmemes@lemmy.world/moderators

Query Metrics

5 Database Queries
5 Different statements
5.75 ms Query time
0 Invalid entities
22 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
2.32 ms
(40.40%)
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 = ? ORDER BY t0.created_at ASC LIMIT 48
Parameters:
[
  83
]
1.86 ms
(32.35%)
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:
[
  83
]
0.64 ms
(11.14%)
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
  83
]
0.60 ms
(10.50%)
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 = ? ORDER BY t0.created_at ASC
Parameters:
[
  83
]
0.32 ms
(5.62%)
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:
[
  83
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

22 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
app_entity_magazine 4
app_entity_settings 16
app_entity_user 1
app_entity_image 1