Query Metrics
28
Database Queries
4
Different statements
159.69 ms
Query time
0
Invalid entities
26
Cache hits
22
Cache misses
22
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 29.89 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" "mander.xyz" 0 0 ] |
2 | 13.82 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_.ranking DESC, e0_.created_at DESC, e0_.id DESC LIMIT 25 OFFSET 200
Parameters:
[ "visible" "visible" "mander.xyz" 0 0 ] |
3 | 2.23 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:
[
30132
]
|
4 | 3.25 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:
[
30123
]
|
5 | 21.67 ms |
SELECT t0.url AS url_1, t0.has_embed AS has_embed_2, t0.id AS id_3, t0.created_at AS created_at_4 FROM embed t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC8903786/"
]
|
6 | 11.84 ms |
SELECT t0.url AS url_1, t0.has_embed AS has_embed_2, t0.id AS id_3, t0.created_at AS created_at_4 FROM embed t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"https://www.vox.com/down-to-earth/2022/11/30/23473062/plant-mimicry-boquila-trifoliolata"
]
|
7 | 2.86 ms |
SELECT t0.url AS url_1, t0.has_embed AS has_embed_2, t0.id AS id_3, t0.created_at AS created_at_4 FROM embed t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"https://en.wikipedia.org/wiki/Mimicry_in_plants?wprov=sfla1"
]
|
8 | 0.50 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:
[
30111
]
|
9 | 0.84 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:
[
29996
]
|
10 | 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:
[
29962
]
|
11 | 7.75 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:
[
29934
]
|
12 | 5.07 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:
[
29932
]
|
13 | 11.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:
[
29931
]
|
14 | 3.95 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:
[
29897
]
|
15 | 4.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:
[
29867
]
|
16 | 0.96 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:
[
29645
]
|
17 | 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:
[
29531
]
|
18 | 0.67 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:
[
29523
]
|
19 | 0.82 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:
[
29488
]
|
20 | 1.51 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:
[
29487
]
|
21 | 1.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:
[
29485
]
|
22 | 7.42 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:
[
29398
]
|
23 | 4.48 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:
[
29393
]
|
24 | 0.77 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:
[
29388
]
|
25 | 5.77 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:
[
29387
]
|
26 | 8.45 ms |
SELECT t0.url AS url_1, t0.has_embed AS has_embed_2, t0.id AS id_3, t0.created_at AS created_at_4 FROM embed t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"https://www.nasa.gov/image-article/why-sun-wont-become-black-hole/"
]
|
27 | 4.84 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:
[
29383
]
|
28 | 0.79 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:
[
29375
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
26
Hits
22
Misses
22
Puts
Number of cache hits
Region | Hits |
---|---|
app_entity_domain | 2 |
app_entity_settings | 16 |
app_entity_magazine | 3 |
app_entity_user | 2 |
app_entity_image | 3 |
Number of cache misses
Region | Misses |
---|---|
app_entity_image | 22 |
Number of cache puts
Region | Puts |
---|---|
app_entity_image | 22 |