SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000289
| 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_is_watched
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 215336
Run Time: 0.001097
| 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: 32
Run Time: 0.000603
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | permission | const | PRIMARY | PRIMARY | 85 | const,const,const | 1 | |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
INNER JOIN xf_thread AS thread ON
(thread.node_id = forum.node_id)
WHERE (thread.thread_id = 215336)
LIMIT 1
Run Time: 0.000847
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY,node_id_last_post_date,node_id_sticky_last_post_date | PRIMARY | 4 | const | 1 | |
| SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM EWRporta_options
WHERE option_id = ?
Params: recentnews_forum
Run Time: 0.000326
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_options | const | PRIMARY | PRIMARY | 152 | const | 1 | |
SELECT post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
0 AS like_date, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 1) as dark_postrating_1_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 14) as dark_postrating_14_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 2) as dark_postrating_2_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 3) as dark_postrating_3_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 4) as dark_postrating_4_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 6) as dark_postrating_6_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 8) as dark_postrating_8_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 12) as dark_postrating_12_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 13) as dark_postrating_13_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,2,4,6,8)) as positive_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (14,12,13)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (3)) as neutral_rating_count
,
pr2.rating
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_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 dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 0)
WHERE post.thread_id = ?
AND (((post.message_state IN ('visible'))
AND (post.position >= 0 AND post.position < 40) )
OR post.post_id = thread.first_post_id)
ORDER BY post.position ASC, post.post_date ASCParams: 215336
Run Time: 0.016115
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| PRIMARY | post | index_merge | PRIMARY,thread_id_post_date,thread_id_position | thread_id_position,PRIMARY | 8,4 | | 39 | Using sort_union(thread_id_position,PRIMARY); Using where |
| PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.post.user_id | 1 | |
| PRIMARY | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.post.user_id | 1 | |
| PRIMARY | pr2 | eq_ref | post_id_user_id,post_id_rating,user_id_rating | post_id_user_id | 8 | valvetime_forums.post.post_id,const | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | eq_ref | user_id_rating | user_id_rating | 8 | valvetime_forums.post.user_id,const | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | valvetime_forums.post.user_id | 1 | Using index condition |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | valvetime_forums.post.user_id | 1 | Using index condition |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | valvetime_forums.post.post_id,const | 1 | Using index |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (3364302)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.001161
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 81 | const,const | 3 | Using index condition; Using where |
| SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.attachment.data_id | 1 | |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 215336
Run Time: 0.000295
SELECT *
FROM xf_node
WHERE lft < ? AND rgt > ?
ORDER BY lft ASC
Params: 34, 35
Run Time: 0.000367
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ALL | lft | | | | 56 | Using where; Using filesort |
SELECT *
FROM EWRporta_options
WHERE option_id = ?
Params: recentnews_forum
Run Time: 0.000335
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_options | const | PRIMARY | PRIMARY | 152 | const | 1 | |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_name ASC
Params: 215336
Run Time: 0.001245
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 69 | Using filesort |
| SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | valvetime_forums.EWRporta_categories.category_id,const | 1 | Using index |
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date)
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)
Params: 0, 839997653, 839997653, XenForo_ControllerPublic_Thread, Index, valid, thread_id=215336, 1371531284
Run Time: 0.000245
SELECT *
FROM kingk_bbcm
ORDER BY tag
Run Time: 0.000541
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | kingk_bbcm | ALL | | | | | 11 | Using filesort |
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: article-215336
Run Time: 0.000410
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: article
Run Time: 0.000209
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_layouts | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *, 'disabled' AS position
FROM EWRporta_blocks
WHERE active = 1
ORDER BY block_id ASC
Run Time: 0.000356
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_blocks | index | | PRIMARY | 77 | | 14 | Using where |
SELECT * FROM EWRporta_caches
Run Time: 0.000335
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_caches | ALL | | | | | 9 | |
SELECT * FROM EWRporta_options
Run Time: 0.000348
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_options | ALL | | | | | 37 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bdtagme_tag', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'EWRblock_Twitter', 'EWRblock_FaceBook', 'EWRblock_BoardTotals', 'EWRblock_YorickRSS', 'EWRblock_AdSidebar')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000287
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 12 | Using where |
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000181
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRcarta_pages | const | page_slug | page_slug | 302 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('EWRporta_ArticleView', 'nat_childlinks')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000727
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 2 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('home')Params: 1
Run Time: 0.000210
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 231 | const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('EWRporta_Navtabs', 'steam_navtabs', 'EWRcarta_Navtabs', 'steam_login_bar_item', 'steam_navigation_visitor_tab_link', 'steam_account_wrapper_sidebar_settings', 'steam_message_user_info', 'steam_js', 'steamstats_js', 'steam_member_view_info', 'steam_message_content', 'steam_helper_criteria_privs', 'steam_member_card_info', 'steam_footer', 'steam_public_index', 'steam_public_owned', 'steam_public_played', 'steam_public_recent', 'wf_hook_moderator_bar', 'wf_revealer', 'forumwatch_navigation_tabs_forums', 'attachmentviewer_navigation_tabs_forums', 'attachmentviewer_navigation_visitor_tab', 'bdtagme_PAGE_CONTAINER', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000365
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 25 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('dark_postrating')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000144
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('EWRporta_Custom_Top')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000185
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('quick_reply_preview')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000194
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('EWRporta_Custom_Btm')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000174
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbcm_js')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000158
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('MobileIcons_Links')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000133
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BrowserUpdate')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000155
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('social_connect_status_editor')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000155
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |