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
#▲ | 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 |