Query Metrics
3
Database Queries
3
Different statements
17.01 ms
Query time
0
Invalid entities
16
Cache hits
1
Cache misses
1
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.59 ms |
SELECT c.id FROM category c WHERE c.is_private = false ORDER BY random() LIMIT 5
Parameters:
[] |
2 | 0.76 ms |
SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.description AS description_2, c0_.is_private AS is_private_3, c0_.is_official AS is_official_4, c0_.magazines_count AS magazines_count_5, c0_.subscriptions_count AS subscriptions_count_6, c0_.id AS id_7, c0_.created_at AS created_at_8, c0_.user_id AS user_id_9 FROM category c0_ WHERE c0_.id IN (NULL)
Parameters:
[] |
3 | 13.66 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\Category | No errors. |
App\Entity\User | No errors. |
App\Entity\Magazine | No errors. |
App\Entity\Image | No errors. |
App\Entity\Moderator | No errors. |
App\Entity\MagazineOwnershipRequest | No errors. |
App\Entity\ModeratorRequest | No errors. |
App\Entity\Entry | No errors. |
App\Entity\Post | 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. |