Query Metrics
56
Database Queries
27
Different statements
2123.82 ms
Query time
0
Invalid entities
45
Cache hits
4
Cache misses
4
Cache puts
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 184.91 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" => 72625 ] |
| 2 | 0.77 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 (NULL)
Parameters:
[] |
| 3 | 2.16 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 | 22.30 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:
[ 351456 319606 345163 292679 292656 291408 291378 291243 291173 291025 291021 290357 286301 266409 237753 236946 152673 100497 100225 99954 ] |
| 5 | 216.26 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:
[ 99954 100225 100497 152673 236946 237753 266409 286301 290357 291021 291025 291173 291243 291378 291408 292656 292679 319606 345163 351456 ] |
| 6 | 76.16 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:
[ 100377 99982 102353 100314 101706 237617 243447 237886 266575 268135 290377 290421 291225 291233 291424 291257 291592 291395 319640 345192 351582 351665 ] |
| 7 | 249.21 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:
[ 100379 266598 266605 267739 268201 290723 291313 305409 319649 322715 ] |
| 8 | 307.07 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:
[ 100484 100397 266604 266824 268400 291287 320276 319714 323209 ] |
| 9 | 124.84 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:
[ 102112 268159 266698 267533 277371 320215 319820 319830 322087 323228 323309 ] |
| 10 | 76.48 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:
[ 102143 319858 320449 320514 320403 319857 321846 320089 320397 320295 322250 323394 ] |
| 11 | 42.69 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:
[ 320423 319901 320425 320447 320416 320577 322781 323870 ] |
| 12 | 24.36 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:
[ 319970 320828 320486 324536 323185 325162 ] |
| 13 | 2.91 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:
[ 320094 320131 320706 320837 324544 325397 ] |
| 14 | 1.04 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:
[ 321060 320302 325516 ] |
| 15 | 75.50 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:
[ 320364 320391 325527 ] |
| 16 | 1.27 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:
[ 320519 320481 325537 ] |
| 17 | 87.29 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:
[ 320500 322346 325735 ] |
| 18 | 0.71 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:
[ 320605 322704 326252 ] |
| 19 | 5.91 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:
[
320934
]
|
| 20 | 0.56 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:
[
320975
]
|
| 21 | 9.96 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:
[
321031
]
|
| 22 | 0.60 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:
[
321995
]
|
| 23 | 1.09 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:
[
322732
]
|
| 24 | 76.64 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:
[
322780
]
|
| 25 | 45.21 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:
[
323131
]
|
| 26 | 124.20 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:
[
324018
]
|
| 27 | 142.11 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:
[
324155
]
|
| 28 | 14.96 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:
[
324270
]
|
| 29 | 10.13 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:
[
324369
]
|
| 30 | 27.17 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:
[
325057
]
|
| 31 | 0.83 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:
[
325781
]
|
| 32 | 0.56 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:
[] |
| 33 | 0.88 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:
[
33882
]
|
| 34 | 0.82 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:
[
31425
]
|
| 35 | 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:
[
33384
]
|
| 36 | 3.70 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:
[
27901
]
|
| 37 | 0.73 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:
[
27784
]
|
| 38 | 0.48 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:
[
27558
]
|
| 39 | 1.11 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:
[
25875
]
|
| 40 | 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:
[
23394
]
|
| 41 | 3.47 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:
[
15533
]
|
| 42 | 0.80 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:
[
10896
]
|
| 43 | 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.user_id = ?
Parameters:
[
72625
]
|
| 44 | 0.70 ms |
SELECT COUNT(*) FROM entry_comment t0 WHERE t0.user_id = ?
Parameters:
[
72625
]
|
| 45 | 0.50 ms |
SELECT COUNT(*) FROM post t0 WHERE t0.user_id = ?
Parameters:
[
72625
]
|
| 46 | 0.36 ms |
SELECT COUNT(*) FROM post_comment t0 WHERE t0.user_id = ?
Parameters:
[
72625
]
|
| 47 | 2.07 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" => 72625 ] |
| 48 | 0.65 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:
[
72625
]
|
| 49 | 0.31 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:
[
72625
]
|
| 50 | 2.05 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" => 72625 ] |
| 51 | 114.70 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" => 72625 ] |
| 52 | 17.36 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:
[
51524
]
|
| 53 | 2.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:
[
51188
]
|
| 54 | 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:
[
46528
]
|
| 55 | 2.86 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:
[
44691
]
|
| 56 | 5.60 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:
[
72625
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
45
Hits
4
Misses
4
Puts
Number of cache hits
| Region | Hits |
|---|---|
| app_entity_user | 11 |
| app_entity_settings | 16 |
| app_entity_image | 5 |
| app_entity_magazine | 6 |
| app_entity_domain | 7 |
Number of cache misses
| Region | Misses |
|---|---|
| app_entity_image | 4 |
Number of cache puts
| Region | Puts |
|---|---|
| app_entity_image | 4 |