Query Metrics
1
Database Queries
1
Different statements
55.97 ms
Query time
0
Invalid entities
18
Cache hits
0
Cache misses
0
Cache puts
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 55.97 ms |
SELECT u0_.email AS email_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.followers_count AS followers_count_3, u0_.homepage AS homepage_4, u0_.about AS about_5, u0_.last_active AS last_active_6, u0_.marked_for_deletion_at AS marked_for_deletion_at_7, u0_.fields AS fields_8, u0_.oauth_github_id AS oauth_github_id_9, u0_.oauth_google_id AS oauth_google_id_10, u0_.oauth_facebook_id AS oauth_facebook_id_11, u0_.oauth_keycloak_id AS oauth_keycloak_id_12, u0_.hide_adult AS hide_adult_13, u0_.show_subscribed_users AS show_subscribed_users_14, u0_.show_subscribed_magazines AS show_subscribed_magazines_15, u0_.show_subscribed_domains AS show_subscribed_domains_16, u0_.preferred_languages AS preferred_languages_17, u0_.featured_magazines AS featured_magazines_18, u0_.show_profile_subscriptions AS show_profile_subscriptions_19, u0_.show_profile_followings AS show_profile_followings_20, u0_.mark_new_comments AS mark_new_comments_21, u0_.notify_on_new_entry AS notify_on_new_entry_22, u0_.notify_on_new_entry_reply AS notify_on_new_entry_reply_23, u0_.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_24, u0_.notify_on_new_post AS notify_on_new_post_25, u0_.notify_on_new_post_reply AS notify_on_new_post_reply_26, u0_.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_27, u0_.add_mentions_entries AS add_mentions_entries_28, u0_.add_mentions_posts AS add_mentions_posts_29, u0_.is_banned AS is_banned_30, u0_.is_verified AS is_verified_31, u0_.is_deleted AS is_deleted_32, u0_.is_bot AS is_bot_33, u0_.spam_protection AS spam_protection_34, u0_.custom_css AS custom_css_35, u0_.ignore_magazines_custom_css AS ignore_magazines_custom_css_36, u0_.id AS id_37, u0_.password AS password_38, u0_.totp_secret AS totp_secret_39, u0_.totp_backup_codes AS totp_backup_codes_40, u0_.ap_id AS ap_id_41, u0_.ap_profile_id AS ap_profile_id_42, u0_.ap_public_url AS ap_public_url_43, u0_.ap_followers_url AS ap_followers_url_44, u0_.ap_inbox_url AS ap_inbox_url_45, u0_.ap_domain AS ap_domain_46, u0_.ap_preferred_username AS ap_preferred_username_47, u0_.ap_discoverable AS ap_discoverable_48, u0_.ap_manually_approves_followers AS ap_manually_approves_followers_49, u0_.private_key AS private_key_50, u0_.public_key AS public_key_51, u0_.ap_fetched_at AS ap_fetched_at_52, u0_.ap_deleted_at AS ap_deleted_at_53, u0_.ap_timeout_at AS ap_timeout_at_54, u0_.visibility AS visibility_55, u0_.created_at AS created_at_56, u0_.avatar_id AS avatar_id_57, u0_.cover_id AS cover_id_58 FROM "user" u0_ INNER JOIN image i1_ ON u0_.avatar_id = i1_.id WHERE u0_.last_active >= ? AND u0_.is_banned = false AND u0_.ap_deleted_at IS NULL AND u0_.avatar_id IS NOT NULL ORDER BY u0_.last_active DESC LIMIT 35
Parameters:
[
"2025-03-05 16:40:54"
]
|
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\Settings | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Magazine | 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. |