Query Metrics
5
Database Queries
5
Different statements
18.19 ms
Query time
0
Invalid entities
16
Cache hits
1
Cache misses
1
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.87 ms |
SELECT m.id FROM magazine m WHERE m.ap_id IS NULL AND m.visibility = :visible AND m.is_adult = false ORDER BY random() LIMIT 5
Parameters:
[ "visible" => "visible" ] |
2 | 5.58 ms |
SELECT m0_.name AS name_0, m0_.title AS title_1, m0_.description AS description_2, m0_.rules AS rules_3, m0_.subscriptions_count AS subscriptions_count_4, m0_.entry_count AS entry_count_5, m0_.entry_comment_count AS entry_comment_count_6, m0_.post_count AS post_count_7, m0_.post_comment_count AS post_comment_count_8, m0_.is_adult AS is_adult_9, m0_.custom_css AS custom_css_10, m0_.last_active AS last_active_11, m0_.marked_for_deletion_at AS marked_for_deletion_at_12, m0_.tags AS tags_13, m0_.id AS id_14, m0_.ap_id AS ap_id_15, m0_.ap_profile_id AS ap_profile_id_16, m0_.ap_public_url AS ap_public_url_17, m0_.ap_followers_url AS ap_followers_url_18, m0_.ap_inbox_url AS ap_inbox_url_19, m0_.ap_domain AS ap_domain_20, m0_.ap_preferred_username AS ap_preferred_username_21, m0_.ap_discoverable AS ap_discoverable_22, m0_.ap_manually_approves_followers AS ap_manually_approves_followers_23, m0_.private_key AS private_key_24, m0_.public_key AS public_key_25, m0_.ap_fetched_at AS ap_fetched_at_26, m0_.ap_deleted_at AS ap_deleted_at_27, m0_.ap_timeout_at AS ap_timeout_at_28, m0_.visibility AS visibility_29, m0_.created_at AS created_at_30, m0_.icon_id AS icon_id_31 FROM magazine m0_ WHERE m0_.id IN (?)
Parameters:
[
1
]
|
3 | 1.51 ms |
SELECT c.id FROM category c WHERE c.is_private = false ORDER BY random() LIMIT 5
Parameters:
[] |
4 | 4.70 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:
[] |
5 | 1.53 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\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. |
App\Entity\Category | No errors. |
App\Entity\User | No errors. |