GET https://kbin.spritesserver.nl/support-us

Query Metrics

9 Database Queries
7 Different statements
19.39 ms Query time
0 Invalid entities
18 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

Time Count Info
10.11 ms
(52.13%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.user_id AS user_id_6 FROM donor t0 WHERE t0.email IS NULL LIMIT 1
Parameters:
[]
3.26 ms
(16.79%)
1
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"
]
1.98 ms
(10.20%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.body AS body_4, t0.lang AS lang_5, t0.is_active AS is_active_6 FROM page t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "supportUs"
]
1.95 ms
(10.08%)
1
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
]
0.95 ms
(4.90%)
1
SELECT c.id FROM category c
            WHERE c.is_private = false
            ORDER BY random()
            LIMIT 5
Parameters:
[]
0.80 ms
(4.14%)
1
SELECT d0_.id AS id_0, d0_.username AS username_1, d0_.email AS email_2, d0_.url AS url_3, d0_.is_active AS is_active_4, d0_.user_id AS user_id_5 FROM donor d0_ WHERE d0_.is_active = true
Parameters:
[]
0.34 ms
(1.77%)
1
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:
[]

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