Query Metrics
3
Database Queries
3
Different statements
58.65 ms
Query time
0
Invalid entities
18
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
32.56 ms (55.52%) |
1 |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (NULL)
Parameters:
[] |
|
15.65 ms (26.68%) |
1 |
SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL)
Parameters:
[] |
|
10.44 ms (17.80%) |
1 |
(
SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type
FROM entry
INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id
INNER JOIN "user" u_entry ON entry.user_id = u_entry.id
WHERE entry.visibility = :visibility
AND m_entry.visibility = :visibility
AND entry.is_adult = false
AND m_entry.is_adult = false
AND (entry.created_at BETWEEN :timeFrom AND :timeTo)
)
UNION
(
SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type
FROM post
INNER JOIN magazine m_post ON post.magazine_id = m_post.id
INNER JOIN "user" u_post ON post.user_id = u_post.id
WHERE post.visibility = :visibility
AND m_post.visibility = :visibility
AND post.is_adult = false
AND m_post.is_adult = false
AND (post.created_at BETWEEN :timeFrom AND :timeTo)
)
ORDER BY comment_count DESC, created_at DESC LIMIT 25000
Parameters:
[ "visibility" => "visible" "timeFrom" => "2025-08-20 19:11:56" "timeTo" => "2025-09-20 19:11:56" ] |
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_settings | 16 |
| app_entity_magazine | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Entry | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Magazine | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Domain | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Settings | No errors. |
| App\Entity\Moderator | No errors. |
| App\Entity\MagazineOwnershipRequest | No errors. |
| App\Entity\ModeratorRequest | 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. |