Query Metrics
44
Database Queries
27
Different statements
252.24 ms
Query time
0
Invalid entities
60
Cache hits
4
Cache misses
4
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 22.29 ms |
( SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type FROM entry INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id INNER JOIN "user" u_entry ON entry.user_id = u_entry.id WHERE entry.visibility = :visibility AND m_entry.visibility = :visibility AND entry.user_id = :criteria_user AND entry.is_adult = false AND m_entry.is_adult = false ) UNION ( SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type FROM post INNER JOIN magazine m_post ON post.magazine_id = m_post.id INNER JOIN "user" u_post ON post.user_id = u_post.id WHERE post.visibility = :visibility AND m_post.visibility = :visibility AND post.user_id = :criteria_user AND post.is_adult = false AND m_post.is_adult = false ) UNION ( SELECT entry_comment.id, entry_comment.created_at, entry_comment.score, entry_comment.score + entry_comment.favourite_count AS ranking, entry_comment.last_active, 0 as comment_count, 'entry_comment' AS type FROM entry_comment INNER JOIN magazine m_entry_comment ON entry_comment.magazine_id = m_entry_comment.id INNER JOIN "user" u_entry_comment ON entry_comment.user_id = u_entry_comment.id WHERE entry_comment.visibility = :visibility AND m_entry_comment.visibility = :visibility AND entry_comment.user_id = :criteria_user AND entry_comment.is_adult = false AND m_entry_comment.is_adult = false ) UNION ( SELECT post_comment.id, post_comment.created_at, post_comment.score, post_comment.score + post_comment.favourite_count AS ranking, post_comment.last_active, 0 as comment_count, 'post_comment' AS type FROM post_comment INNER JOIN magazine m_post_comment ON post_comment.magazine_id = m_post_comment.id INNER JOIN "user" u_post_comment ON post_comment.user_id = u_post_comment.id WHERE post_comment.visibility = :visibility AND m_post_comment.visibility = :visibility AND post_comment.user_id = :criteria_user AND post_comment.is_adult = false AND m_post_comment.is_adult = false ) ORDER BY last_active DESC, created_at DESC LIMIT 25000
Parameters:
[ "visibility" => "visible" "criteria_user" => 28212 ] |
2 | 1.71 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 33182 31625 32720 32612 32216 32051 31528 29094 ] |
3 | 0.62 ms |
SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL)
Parameters:
[] |
4 | 4.73 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 340967 328216 333910 321095 306547 306587 299564 290215 289106 239177 254968 254787 270621 268780 256763 265977 253935 ] |
5 | 15.02 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 239177 253935 254787 254968 256763 265977 268780 270621 289106 290215 299564 306547 306587 321095 328216 333910 340967 ] |
6 | 40.12 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 239667 240066 239510 239480 239269 254009 254834 254854 254921 255144 254883 254882 254809 255670 256263 271612 255103 255459 267933 266052 266133 269307 269108 269391 269585 270644 271336 289188 289682 290228 290239 300224 306553 306984 307526 322852 328242 328512 328998 329203 340802 334122 335204 341246 ] |
7 | 35.42 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 241051 239462 239618 239530 240255 240230 254965 255382 271637 266704 269767 270376 269765 289529 290241 290772 309001 308754 323686 328271 328335 328732 328474 328528 328771 328866 328895 334444 341556 341256 341259 ] |
8 | 14.55 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 239545 240552 239549 240007 240428 240505 240805 239538 240356 240806 240492 240419 240496 246425 242503 241259 242064 257021 255460 266721 290892 310171 324865 328719 328896 329876 329319 335306 335937 336220 341300 341558 342126 ] |
9 | 9.73 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 240431 246423 249910 240482 240440 240581 240513 240633 241131 240570 249918 242798 257112 337880 341587 ] |
10 | 46.79 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 242414 241515 247570 242440 241744 249941 246455 243060 269930 337896 341666 341680 ] |
11 | 1.12 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 242794 242459 250178 271967 337944 342157 ] |
12 | 4.45 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?)
Parameters:
[ 242517 250507 343231 ] |
13 | 0.48 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.id IN (NULL)
Parameters:
[] |
14 | 0.61 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
30249
]
|
15 | 0.79 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
24826
]
|
16 | 0.55 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
25947
]
|
17 | 0.50 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
24821
]
|
18 | 0.51 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
25855
]
|
19 | 0.54 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
26423
]
|
20 | 0.49 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
25061
]
|
21 | 0.51 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
25087
]
|
22 | 0.51 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
23703
]
|
23 | 1.22 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
27826
]
|
24 | 0.45 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
27963
]
|
25 | 0.49 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
28444
]
|
26 | 0.42 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
30247
]
|
27 | 0.43 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
31529
]
|
28 | 0.43 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
32553
]
|
29 | 0.43 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
32071
]
|
30 | 0.46 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
32952
]
|
31 | 1.08 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.user_id = ?
Parameters:
[
28212
]
|
32 | 1.12 ms |
SELECT COUNT(*) FROM entry_comment t0 WHERE t0.user_id = ?
Parameters:
[
28212
]
|
33 | 3.69 ms |
SELECT COUNT(*) FROM post t0 WHERE t0.user_id = ?
Parameters:
[
28212
]
|
34 | 1.03 ms |
SELECT COUNT(*) FROM post_comment t0 WHERE t0.user_id = ?
Parameters:
[
28212
]
|
35 | 1.83 ms |
(SELECT entry_id as id, created_at, 'entry' AS type FROM entry_vote WHERE user_id = :userId AND choice = 1) UNION (SELECT comment_id as id, created_at, 'entry_comment' AS type FROM entry_comment_vote WHERE user_id = :userId AND choice = 1) UNION (SELECT post_id as id, created_at, 'post' AS type FROM post_vote WHERE user_id = :userId AND choice = 1) UNION (SELECT comment_id as id, created_at, 'post_comment' AS type FROM post_comment_vote WHERE user_id = :userId AND choice = 1) ORDER BY created_at DESC
Parameters:
[ "userId" => 28212 ] |
36 | 0.60 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.follower_id AS follower_id_3, t0.following_id AS following_id_4 FROM user_follow t0 WHERE t0.follower_id = ? ORDER BY t0.created_at DESC
Parameters:
[
28212
]
|
37 | 0.33 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.follower_id AS follower_id_3, t0.following_id AS following_id_4 FROM user_follow t0 WHERE t0.following_id = ? ORDER BY t0.created_at DESC
Parameters:
[
28212
]
|
38 | 1.52 ms |
SELECT (SELECT SUM( (SELECT COUNT(id) FROM entry_vote WHERE author_id = :user AND user_id != :user AND choice = 1) * 2 - (SELECT COUNT(id) FROM entry_vote WHERE author_id = :user AND user_id != :user AND choice = -1) )) + (SELECT SUM( (SELECT COUNT(id) FROM entry_comment_vote WHERE author_id = :user AND user_id != :user AND choice = 1) * 2 - (SELECT COUNT(id) FROM entry_comment_vote WHERE author_id = :user AND user_id != :user AND choice = -1) )) + (SELECT SUM( (SELECT COUNT(id) FROM post_vote WHERE author_id = :user AND user_id != :user AND choice = 1) * 2 - (SELECT COUNT(id) FROM post_vote WHERE author_id = :user AND user_id != :user AND choice = -1) )) + (SELECT SUM( (SELECT COUNT(id) FROM post_comment_vote WHERE author_id = :user AND user_id != :user AND choice = 1) * 2 - (SELECT COUNT(id) FROM post_comment_vote WHERE author_id = :user AND user_id != :user AND choice = -1) )) as total
Parameters:
[ "user" => 28212 ] |
39 | 16.53 ms |
SELECT (SELECT count(f.id) FROM favourite f LEFT JOIN entry fj ON f.entry_id = fj.id WHERE fj.user_id = :user AND f.user_id != :user) + (SELECT count(f.id) FROM favourite f LEFT JOIN entry_comment fj ON f.entry_comment_id = fj.id WHERE fj.user_id = :user AND f.user_id != :user) + (SELECT count(f.id) FROM favourite f LEFT JOIN post fj ON f.post_id = fj.id WHERE fj.user_id = :user AND f.user_id != :user) + (SELECT count(f.id) FROM favourite f LEFT JOIN post_comment fj ON f.post_comment_id = fj.id WHERE fj.user_id = :user AND f.user_id != :user) as total
Parameters:
[ "user" => 28212 ] |
40 | 1.94 ms |
SELECT t0.email AS email_1, t0.username AS username_2, t0.roles AS roles_3, t0.followers_count AS followers_count_4, t0.homepage AS homepage_5, t0.about AS about_6, t0.last_active AS last_active_7, t0.marked_for_deletion_at AS marked_for_deletion_at_8, t0.fields AS fields_9, t0.oauth_github_id AS oauth_github_id_10, t0.oauth_google_id AS oauth_google_id_11, t0.oauth_facebook_id AS oauth_facebook_id_12, t0.oauth_keycloak_id AS oauth_keycloak_id_13, t0.hide_adult AS hide_adult_14, t0.show_subscribed_users AS show_subscribed_users_15, t0.show_subscribed_magazines AS show_subscribed_magazines_16, t0.show_subscribed_domains AS show_subscribed_domains_17, t0.preferred_languages AS preferred_languages_18, t0.featured_magazines AS featured_magazines_19, t0.show_profile_subscriptions AS show_profile_subscriptions_20, t0.show_profile_followings AS show_profile_followings_21, t0.mark_new_comments AS mark_new_comments_22, t0.notify_on_new_entry AS notify_on_new_entry_23, t0.notify_on_new_entry_reply AS notify_on_new_entry_reply_24, t0.notify_on_new_entry_comment_reply AS notify_on_new_entry_comment_reply_25, t0.notify_on_new_post AS notify_on_new_post_26, t0.notify_on_new_post_reply AS notify_on_new_post_reply_27, t0.notify_on_new_post_comment_reply AS notify_on_new_post_comment_reply_28, t0.add_mentions_entries AS add_mentions_entries_29, t0.add_mentions_posts AS add_mentions_posts_30, t0.is_banned AS is_banned_31, t0.is_verified AS is_verified_32, t0.is_deleted AS is_deleted_33, t0.is_bot AS is_bot_34, t0.spam_protection AS spam_protection_35, t0.custom_css AS custom_css_36, t0.ignore_magazines_custom_css AS ignore_magazines_custom_css_37, t0.id AS id_38, t0.password AS password_39, t0.totp_secret AS totp_secret_40, t0.totp_backup_codes AS totp_backup_codes_41, t0.ap_id AS ap_id_42, t0.ap_profile_id AS ap_profile_id_43, t0.ap_public_url AS ap_public_url_44, t0.ap_followers_url AS ap_followers_url_45, t0.ap_inbox_url AS ap_inbox_url_46, t0.ap_domain AS ap_domain_47, t0.ap_preferred_username AS ap_preferred_username_48, t0.ap_discoverable AS ap_discoverable_49, t0.ap_manually_approves_followers AS ap_manually_approves_followers_50, t0.private_key AS private_key_51, t0.public_key AS public_key_52, t0.ap_fetched_at AS ap_fetched_at_53, t0.ap_deleted_at AS ap_deleted_at_54, t0.ap_timeout_at AS ap_timeout_at_55, t0.visibility AS visibility_56, t0.created_at AS created_at_57, t0.avatar_id AS avatar_id_58, t0.cover_id AS cover_id_59 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
80887
]
|
41 | 0.94 ms |
SELECT t0.name AS name_1, t0.entry_count AS entry_count_2, t0.subscriptions_count AS subscriptions_count_3, t0.id AS id_4 FROM domain t0 WHERE t0.id = ?
Parameters:
[
41
]
|
42 | 12.57 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:
[
50574
]
|
43 | 0.91 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:
[
50216
]
|
44 | 1.78 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 (SELECT m1_.magazine_id AS sclr_32 FROM moderator m1_ WHERE m1_.user_id = ?) ORDER BY m0_.ap_id DESC, m0_.last_active DESC
Parameters:
[
28212
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
60
Hits
4
Misses
4
Puts
Number of cache hits
Region | Hits |
---|---|
app_entity_user | 16 |
app_entity_settings | 16 |
app_entity_magazine | 11 |
app_entity_domain | 8 |
app_entity_image | 9 |
Number of cache misses
Region | Misses |
---|---|
app_entity_user | 1 |
app_entity_domain | 1 |
app_entity_image | 2 |
Number of cache puts
Region | Puts |
---|---|
app_entity_user | 1 |
app_entity_domain | 1 |
app_entity_image | 2 |