SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000232
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 438
Run Time: 0.000617
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 34
Run Time: 0.000310
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
session_activity.view_date AS last_view_date,
0 AS like_date
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,2,5,6,7,8,10)) as positive_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (11,12,13)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (14,3,4,9)) as neutral_rating_count
,
pr2.rating,
pr.*, post.post_id
FROM xf_post AS post
LEFT JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id AND thread.post_sticky = 1)
LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
LEFT JOIN dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 0)
LEFT JOIN (
select
pivot_pr.post_id
, sum(case when pivot_pr.rating = 1 then 1 else 0 end) dark_postrating_1_count
, sum(case when pivot_pr.rating = 14 then 1 else 0 end) dark_postrating_14_count
, sum(case when pivot_pr.rating = 2 then 1 else 0 end) dark_postrating_2_count
, sum(case when pivot_pr.rating = 3 then 1 else 0 end) dark_postrating_3_count
, sum(case when pivot_pr.rating = 4 then 1 else 0 end) dark_postrating_4_count
, sum(case when pivot_pr.rating = 5 then 1 else 0 end) dark_postrating_5_count
, sum(case when pivot_pr.rating = 6 then 1 else 0 end) dark_postrating_6_count
, sum(case when pivot_pr.rating = 7 then 1 else 0 end) dark_postrating_7_count
, sum(case when pivot_pr.rating = 8 then 1 else 0 end) dark_postrating_8_count
, sum(case when pivot_pr.rating = 9 then 1 else 0 end) dark_postrating_9_count
, sum(case when pivot_pr.rating = 10 then 1 else 0 end) dark_postrating_10_count
, sum(case when pivot_pr.rating = 11 then 1 else 0 end) dark_postrating_11_count
, sum(case when pivot_pr.rating = 12 then 1 else 0 end) dark_postrating_12_count
, sum(case when pivot_pr.rating = 13 then 1 else 0 end) dark_postrating_13_count
from dark_postrating pivot_pr
use index (`post_id_rating`)
left join xf_post pivot_post on (pivot_pr.post_id = pivot_post.post_id)
where pivot_post.thread_id = 438
group by pivot_pr.post_id
) pr on (pr.post_id = post.post_id)
WHERE post.thread_id = ?
AND (((post.message_state IN ('visible'))
AND (post.position >= 0 AND post.position < 20) ) OR (post.post_id = thread.first_post_id AND thread.post_sticky))
ORDER BY post.position ASC, post.post_date ASC
Params: 438
Run Time: 0.010014
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | post | ref | PRIMARY,thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 519 | Using where; Using filesort |
PRIMARY | thread | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.post.thread_id | 1 | Using where |
PRIMARY | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,viregfum_db.post.post_id | 1 | Using where |
PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.post.user_id | 1 | |
PRIMARY | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.post.user_id | 1 | |
PRIMARY | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.post.user_id | 1 | |
PRIMARY | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,viregfum_db.post.user_id | 1 | Using where |
PRIMARY | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | viregfum_db.post.user_id,func | 1 | Using where |
PRIMARY | pr2 | eq_ref | post_id_user_id,post_id_rating,user_id_rating | post_id_user_id | 8 | viregfum_db.post.post_id,const | 1 | |
PRIMARY | <derived5> | ref | key0 | key0 | 5 | viregfum_db.post.post_id | 2 | |
LATERAL DERIVED | pivot_pr | ref | post_id_rating | post_id_rating | 4 | viregfum_db.post.post_id | 1 | Using index |
LATERAL DERIVED | pivot_post | eq_ref | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | viregfum_db.pivot_pr.post_id | 1 | Using where |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | viregfum_db.post.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | viregfum_db.post.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | viregfum_db.post.user_id | 1 | Using index condition |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 438
Run Time: 0.000413
SELECT thread.*
,
0 AS thread_reply_banned
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 438
Run Time: 0.000491
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 34
Run Time: 0.000353
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=438, 1713556453,
Run Time: 0.001699
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000191
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT *
FROM uix_node_layout
Run Time: 0.000195
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | uix_node_layout | ALL | | | | | 2 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000137
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT node.*,
node_field.uix_node_icons,
node_field.uix_styling,
node_field.collapsed,
node_field.inheritClass,
node_field.inheritStyling
FROM xf_node AS node
LEFT JOIN uix_node_fields AS node_field ON (node.node_id = node_field.node_id)
Run Time: 0.000351
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | ALL | | | | | 102 | |
SIMPLE | node_field | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.node.node_id | 1 | |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1713554053)
ORDER BY session_activity.view_date DESC
Run Time: 0.011705
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 367 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.session_activity.user_id | 1 | |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1713554053)
ORDER BY session_activity.view_date DESC
Run Time: 0.000826
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 367 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.session_activity.user_id | 1 | |
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000333
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 102 | Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000299
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 110 | Using where |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE (thread.node_id IN (1, 10, 44, 45, 42, 50, 98, 63, 77, 89, 105, 125, 49, 126, 120, 90, 124, 48, 53, 102, 108, 15, 127, 64, 47, 54, 55, 11, 56, 22, 13, 14, 104, 38, 12, 43, 30, 60, 33, 70, 34, 83, 94, 116, 118, 121, 84, 85, 86, 87, 115, 97, 69, 91, 80, 88, 92, 46, 58, 59, 41, 40, 32, 61, 112, 36, 37, 62, 72, 35, 71, 95, 52, 106, 73, 103, 81, 107, 82, 101, 114, 113, 117, 119, 123, 111, 110, 100, 75, 74, 76, 16, 19, 17, 18, 31, 65, 66, 67, 68, 3, 4, 93, 6, 5, 23, 24, 99, 79)) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.post_date DESC
LIMIT 15
Run Time: 0.000227
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | index | node_id_last_post_date,node_id_sticky_state_last_post | post_date | 4 | | 17 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.thread.user_id | 1 | |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id IN (53, 80, 10, 14, 4, 48, 22, 4, 53, 48, 126, 22, 53, 48, 125)
Run Time: 0.000245
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 9 | Using where |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | viregfum_db.node.node_id | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_thread_view, a:1:{s:14:"thread_view_12";a:2:{s:4:"html";s:3297:"<div class="avatarList">
<ul>
<li class="thread-2786 thread-node-53">
<a href="members/frayz.25875/" class="avatar Av25875s" data-avatarhtml="true"><img src="styles/class/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Frayz" /></a>
<a title="Сбрасываются настройки Neoline Shadow." class="Tooltip"
href="threads/sbrasyvajutsja-nastrojki-neoline-shadow.2786/">
Сбрасываются настройки Neoline...
</a>
<div class="userTitle">
<a href="members/frayz.25875/" class="username">Frayz</a> posted <span class="DateTime" title="17 мар 2024 в 02:05">17 мар 2024</span>
</div>
</li>
<li class="thread-2785 thread-node-80">
<a href="members/igorpv.25869/" class="avatar Av25869s" data-avatarhtml="true"><img src="styles/class/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="IgorPV" /></a>
<a title="BlackSys сайт производителя в 2024 году." class="Tooltip"
href="threads/blacksys-sajt-proizvoditelja-v-2024-godu.2785/">
BlackSys сайт производителя в...
</a>
<div class="userTitle">
<a href="members/igorpv.25869/" class="username">IgorPV</a> posted <span class="DateTime" title="14 мар 2024 в 17:24">14 мар 2024</span>
</div>
</li>
<li class="thread-2784 thread-node-10">
<a href="members/ustas52.25829/" class="avatar Av25829s" data-avatarhtml="true"><img src="styles/class/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Ustas52" /></a>
<a
href="threads/korejskij-registrator-mando-z7.2784/">
Корейский регистратор Mando Z7
</a>
<div class="userTitle">
<a href="members/ustas52.25829/" class="username">Ustas52</a> posted <span class="DateTime" title="20 фев 2024 в 16:51">20 фев 2024</span>
</div>
</li>
<li class="thread-2782 thread-node-14">
<a href="members/sviatoi1988.25804/" class="avatar Av25804s" data-avatarhtml="true"><img src="styles/class/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Sviatoi1988" /></a>
<a
href="threads/finevu-gx3.2782/">
FineVu GX3
</a>
<div class="userTitle">
<a href="members/sviatoi1988.25804/" class="username">Sviatoi1988</a> posted <span class="DateTime" title="10 фев 2024 в 20:25">10 фев 2024</span>
</div>
</li>
<li class="thread-2780 thread-node-4">
<a href="members/karagandinez.24193/" class="avatar Av24193s" data-avatarhtml="true"><img src="data/avatars/s/24/24193.jpg?1617208412" width="48" height="48" alt="Karagandinez" /></a>
<a
href="threads/s-nastupajuschim-novym-2024-godom.2780/">
С Наступающим Новым 2024 годом!!!
</a>
<div class="userTitle">
<a href="members/karagandinez.24193/" class="username">Karagandinez</a> posted <span class="DateTime" title="30 дек 2023 в 22:59">30 дек 2023</span>
</div>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Загрузка...</span>
</div>
</div>
</div>";s:4:"time";i:1713556453;}}
Run Time: 0.000338
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('members_online_now', 'forum_statistics', 'wf_widget_threads_type_new')
Params: 2
Run Time: 0.000094
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 3 | Using where |