GET https://kbin.spritesserver.nl/m/lemmy_support@lemmy.ml/modlog

Query Metrics

5 Database Queries
4 Different statements
6.12 ms Query time
0 Invalid entities
21 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 2.57 ms
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:
[
  40
]
2 1.20 ms
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.log_type, t0.entry_id AS entry_id_5, t0.entry_id AS entry_id_6, t0.entry_comment_id AS entry_comment_id_7, t0.entry_comment_id AS entry_comment_id_8, t0.post_id AS post_id_9, t0.post_id AS post_id_10, t0.post_comment_id AS post_comment_id_11, t0.post_comment_id AS post_comment_id_12, t0.meta AS meta_13, t0.ban_id AS ban_id_14 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') ORDER BY t0.created_at DESC LIMIT 48
Parameters:
[
  40
]
3 1.16 ms
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
  40
]
4 0.70 ms
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:
[
  40
]
5 0.48 ms
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:
[
  40
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

21 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
app_entity_magazine 4
app_entity_settings 16
app_entity_user 1

Entities Mapping

Class Mapping errors
App\Entity\Magazine No errors.
App\Entity\Image No errors.
App\Entity\Moderator No errors.
App\Entity\MagazineOwnershipRequest No errors.
App\Entity\ModeratorRequest No errors.
App\Entity\Entry 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.
App\Entity\Settings No errors.
App\Entity\User No errors.
App\Entity\MagazineLogEntryDeleted No errors.
App\Entity\MagazineLogEntryRestored No errors.
App\Entity\MagazineLogEntryCommentDeleted No errors.
App\Entity\EntryComment No errors.
App\Entity\MagazineLogEntryCommentRestored No errors.
App\Entity\MagazineLogPostDeleted No errors.
App\Entity\MagazineLogPostRestored No errors.
App\Entity\MagazineLogPostCommentDeleted No errors.
App\Entity\PostComment No errors.
App\Entity\MagazineLogPostCommentRestored No errors.
App\Entity\MagazineLogBan No errors.
App\Entity\Vote No errors.
App\Entity\EntryVote No errors.
App\Entity\EntryCommentVote No errors.
App\Entity\PostVote 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\Favourite No errors.
App\Entity\Notification No errors.
App\Entity\CategorySubscription No errors.
App\Entity\Category No errors.
App\Entity\OAuth2UserConsent No errors.