Query Metrics
4
Database Queries
4
Different statements
51.91 ms
Query time
0
Invalid entities
16
Cache hits
1
Cache misses
1
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 31.52 ms |
SELECT p.id FROM post p JOIN magazine m ON p.magazine_id = m.id WHERE p.is_adult = false AND p.visibility = :visible AND m.is_adult = false AND p.ap_id IS NULL AND p.created_at >= :time ORDER BY random(), p.created_at DESC LIMIT :limit;
Parameters:
[ "visible" => "visible" "time" => "2024-09-18 18:50:45" "limit" => 154 ] |
2 | 6.83 ms |
SELECT p0_.slug AS slug_0, p0_.body AS body_1, p0_.lang AS lang_2, p0_.comment_count AS comment_count_3, p0_.favourite_count AS favourite_count_4, p0_.score AS score_5, p0_.is_adult AS is_adult_6, p0_.sticky AS sticky_7, p0_.last_active AS last_active_8, p0_.ip AS ip_9, p0_.tags AS tags_10, p0_.mentions AS mentions_11, p0_.id AS id_12, p0_.body_ts AS body_ts_13, p0_.up_votes AS up_votes_14, p0_.down_votes AS down_votes_15, p0_.ranking AS ranking_16, p0_.visibility AS visibility_17, p0_.ap_id AS ap_id_18, p0_.edited_at AS edited_at_19, p0_.created_at AS created_at_20, p0_.user_id AS user_id_21, p0_.magazine_id AS magazine_id_22, p0_.image_id AS image_id_23 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id LEFT JOIN image i2_ ON p0_.image_id = i2_.id WHERE p0_.id IN (NULL)
Parameters:
[] |
3 | 10.25 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.url AS url_3, p0_.image_url AS image_url_4, p0_.image_width AS image_width_5, p0_.image_height AS image_height_6, p0_.is_active AS is_active_7, p0_.last_active AS last_active_8 FROM partner_block p0_ WHERE p0_.is_active = true ORDER BY p0_.last_active ASC LIMIT 1
Parameters:
[] |
4 | 3.31 ms |
SELECT t0.name AS name_1, t0.title AS title_2, t0.description AS description_3, t0.rules AS rules_4, t0.subscriptions_count AS subscriptions_count_5, t0.entry_count AS entry_count_6, t0.entry_comment_count AS entry_comment_count_7, t0.post_count AS post_count_8, t0.post_comment_count AS post_comment_count_9, t0.is_adult AS is_adult_10, t0.custom_css AS custom_css_11, t0.last_active AS last_active_12, t0.marked_for_deletion_at AS marked_for_deletion_at_13, t0.tags AS tags_14, t0.id AS id_15, t0.ap_id AS ap_id_16, t0.ap_profile_id AS ap_profile_id_17, t0.ap_public_url AS ap_public_url_18, t0.ap_followers_url AS ap_followers_url_19, t0.ap_inbox_url AS ap_inbox_url_20, t0.ap_domain AS ap_domain_21, t0.ap_preferred_username AS ap_preferred_username_22, t0.ap_discoverable AS ap_discoverable_23, t0.ap_manually_approves_followers AS ap_manually_approves_followers_24, t0.private_key AS private_key_25, t0.public_key AS public_key_26, t0.ap_fetched_at AS ap_fetched_at_27, t0.ap_deleted_at AS ap_deleted_at_28, t0.ap_timeout_at AS ap_timeout_at_29, t0.visibility AS visibility_30, t0.created_at AS created_at_31, t0.icon_id AS icon_id_32 FROM magazine t0 WHERE t0.ap_id IS NULL AND t0.visibility = ? ORDER BY t0.last_active DESC LIMIT 28
Parameters:
[
"visible"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
16
Hits
1
Misses
1
Puts
Number of cache hits
Region | Hits |
---|---|
app_entity_settings | 16 |
Number of cache misses
Region | Misses |
---|---|
app_entity_magazine | 1 |
Number of cache puts
Region | Puts |
---|---|
app_entity_magazine | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Settings | No errors. |
App\Entity\Post | No errors. |
App\Entity\Magazine | No errors. |
App\Entity\Image | No errors. |
App\Entity\User | No errors. |
App\Entity\PartnerBlock | No errors. |
App\Entity\Moderator | No errors. |
App\Entity\MagazineOwnershipRequest | No errors. |
App\Entity\ModeratorRequest | No errors. |
App\Entity\Entry | 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. |