Query Metrics
2
Database Queries
2
Different statements
13.54 ms
Query time
0
Invalid entities
0
Cache hits
1
Cache misses
1
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
9.42 ms (69.55%) |
1 |
SELECT count(e0_.id) AS sclr_0 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND (e0_.created_at BETWEEN ? AND ?) AND e0_.type = ? AND d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY sclr_0 ASC
Parameters:
[ "visible" "visible" "2025-04-15 05:02:59+0000" "2025-04-15 08:02:59+0000" "link" "lemmy.world" 0 0 ] |
4.12 ms (30.45%) |
1 |
SELECT t0.name AS name_1, t0.entry_count AS entry_count_2, t0.subscriptions_count AS subscriptions_count_3, t0.id AS id_4 FROM domain t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"lemmy.world"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
1
Misses
1
Puts
Number of cache misses
Region | Misses |
---|---|
app_entity_domain | 1 |
Number of cache puts
Region | Puts |
---|---|
app_entity_domain | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Domain | No errors. |
App\Entity\Entry | No errors. |
App\Entity\DomainSubscription | No errors. |
App\Entity\Magazine | No errors. |
App\Entity\User | No errors. |