Query Metrics
20
Database Queries
4
Different statements
171.94 ms
Query time
0
Invalid entities
35
Cache hits
18
Cache misses
18
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 32.64 ms |
SELECT count(e0_.id) AS sclr_0 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY sclr_0 ASC
Parameters:
[ "visible" "visible" "startrek.website" 0 0 ] |
2 | 20.15 ms |
SELECT e0_.slug AS slug_0, e0_.title AS title_1, e0_.url AS url_2, e0_.body AS body_3, e0_.type AS type_4, e0_.lang AS lang_5, e0_.is_oc AS is_oc_6, e0_.has_embed AS has_embed_7, e0_.comment_count AS comment_count_8, e0_.favourite_count AS favourite_count_9, e0_.score AS score_10, e0_.is_adult AS is_adult_11, e0_.sticky AS sticky_12, e0_.last_active AS last_active_13, e0_.ip AS ip_14, e0_.ada_amount AS ada_amount_15, e0_.tags AS tags_16, e0_.mentions AS mentions_17, e0_.id AS id_18, e0_.title_ts AS title_ts_19, e0_.body_ts AS body_ts_20, e0_.up_votes AS up_votes_21, e0_.down_votes AS down_votes_22, e0_.ranking AS ranking_23, e0_.visibility AS visibility_24, e0_.ap_id AS ap_id_25, e0_.edited_at AS edited_at_26, e0_.created_at AS created_at_27, e0_.user_id AS user_id_28, e0_.magazine_id AS magazine_id_29, e0_.image_id AS image_id_30, e0_.domain_id AS domain_id_31 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY e0_.last_active DESC, e0_.created_at DESC, e0_.id DESC LIMIT 25 OFFSET 75
Parameters:
[ "visible" "visible" "startrek.website" 0 0 ] |
3 | 4.64 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.id = ?
Parameters:
[
78
]
|
4 | 1.32 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
49302
]
|
5 | 33.17 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
49480
]
|
6 | 8.02 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
49373
]
|
7 | 0.76 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
36407
]
|
8 | 8.60 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
30644
]
|
9 | 0.81 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
49327
]
|
10 | 0.72 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
49063
]
|
11 | 2.98 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
48792
]
|
12 | 5.27 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
48977
]
|
13 | 3.08 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
49049
]
|
14 | 12.43 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
49098
]
|
15 | 1.98 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
49048
]
|
16 | 0.83 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
27205
]
|
17 | 0.71 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
27399
]
|
18 | 0.71 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
37752
]
|
19 | 13.59 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
27380
]
|
20 | 19.52 ms |
SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?
Parameters:
[
48802
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
35
Hits
18
Misses
18
Puts
Number of cache hits
Region | Hits |
---|---|
app_entity_domain | 2 |
app_entity_settings | 16 |
app_entity_user | 4 |
app_entity_magazine | 6 |
app_entity_image | 7 |
Number of cache misses
Region | Misses |
---|---|
app_entity_magazine | 1 |
app_entity_image | 17 |
Number of cache puts
Region | Puts |
---|---|
app_entity_magazine | 1 |
app_entity_image | 17 |