Query Metrics
1
Database Queries
1
Different statements
9.47 ms
Query time
0
Invalid entities
18
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 9.47 ms |
SELECT count(e0_.id) AS sclr_0 FROM entry_comment e0_ INNER JOIN "user" u1_ ON e0_.user_id = u1_.id INNER JOIN entry e2_ ON e0_.entry_id = e2_.id INNER JOIN entry e3_ ON e0_.entry_id = e3_.id INNER JOIN magazine m4_ ON e2_.magazine_id = m4_.id WHERE e0_.visibility IN (?, ?, ?) AND (e0_.created_at BETWEEN ? AND ?) AND e2_.visibility = ? AND e0_.user_id = ? AND m4_.is_adult = ? AND e2_.is_adult = ? ORDER BY sclr_0 ASC
Parameters:
[ "soft_deleted" "visible" "trashed" "2025-02-10 10:38:17+0000" "2025-02-11 10:38:17+0000" "visible" 48226 0 0 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
18
Hits
0
Misses
0
Puts
Number of cache hits
Region | Hits |
---|---|
app_entity_user | 2 |
app_entity_settings | 16 |