SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000317
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*,
IF (session_activity.view_date IS NULL, user.last_activity, session_activity.view_date) AS effective_last_activity,
session_activity.view_date, session_activity.controller_name, session_activity.controller_action, session_activity.params, session_activity.ip,
0 AS following_0
,(select sum(count_received) from dark_postrating_count where user_id = user.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 = user.user_id and rating in (14,12,13)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (3)) as neutral_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
FROM xf_user AS user
INNER JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
INNER JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
INNER JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(session_activity.user_id = user.user_id AND session_activity.unique_key = user.user_id)
WHERE user.user_id = ?
Params: 73877
Run Time: 0.004300
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| PRIMARY | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| PRIMARY | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| PRIMARY | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| PRIMARY | session_activity | const | PRIMARY | PRIMARY | 8 | const,const | 0 | unique row not found |
| SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 5 | |
| SUBQUERY | | | | | | | | Impossible WHERE noticed after reading const tables |
| SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 3 | Using index condition |
| SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 5 | Using index condition |
SELECT COUNT(*)
FROM xf_profile_post AS profile_post
WHERE (profile_post.profile_user_id = 73877) AND (profile_post.message_state IN ('visible'))Run Time: 0.006829
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | profile_post | ref | profile_user_id_post_date | profile_user_id_post_date | 4 | const | 225 | Using where |
SELECT profile_post.*
,
posting_user.*,
IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username,
0 AS like_date
FROM xf_profile_post AS profile_post
LEFT JOIN xf_user AS posting_user ON
(posting_user.user_id = profile_post.user_id)
WHERE (profile_post.profile_user_id = 73877) AND (profile_post.message_state IN ('visible'))
ORDER BY profile_post.post_date DESC
LIMIT 40 OFFSET 200Run Time: 0.007442
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | profile_post | ref | profile_user_id_post_date | profile_user_id_post_date | 4 | const | 225 | Using where |
| SIMPLE | posting_user | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.profile_post.user_id | 1 | |
SELECT user_field.*
,
field_value.field_value
FROM xf_user_field AS user_field
LEFT JOIN xf_user_field_value AS field_value ON
(field_value.field_id = user_field.field_id AND field_value.user_id = 73877)
WHERE (user_field.display_group <> 'preferences' AND user_field.viewable_profile = 1)
ORDER BY user_field.display_group, user_field.display_order
Run Time: 0.174447
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | user_field | ALL | display_group_order | | | | 11 | Using where; Using filesort |
| SIMPLE | field_value | eq_ref | PRIMARY,field_id | PRIMARY | 81 | const,valvetime_forums.user_field.field_id | 1 | |
SELECT
user.*,
user_profile.*,
user_option.*
,(select sum(count_received) from dark_postrating_count where user_id = user.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 = user.user_id and rating in (14,12,13)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (3)) as neutral_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
FROM xf_user_follow AS user_follow
INNER JOIN xf_user AS user ON
(user.user_id = user_follow.follow_user_id)
INNER JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
INNER JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
WHERE user_follow.user_id = ?
ORDER BY RAND()
LIMIT 6
Params: 73877
Run Time: 0.011800
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | user_follow | ref | PRIMARY,follow_user_id | PRIMARY | 4 | const | 21 | Using index; Using temporary; Using filesort |
| PRIMARY | user_option | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.user_follow.follow_user_id | 1 | |
| PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.user_follow.follow_user_id | 1 | |
| PRIMARY | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.user_follow.follow_user_id | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | valvetime_forums.user.user_id | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | eq_ref | user_id_rating | user_id_rating | 8 | valvetime_forums.user.user_id,const | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | valvetime_forums.user.user_id | 1 | Using index condition |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | valvetime_forums.user.user_id | 1 | Using index condition |
SELECT COUNT(*)
FROM xf_user_follow
WHERE follow_user_id = ?
Params: 73877
Run Time: 0.000828
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_user_follow | ref | follow_user_id | follow_user_id | 4 | const | 7 | Using index |
SELECT user.*,
user_profile.*,
user_option.*
,(select sum(count_received) from dark_postrating_count where user_id = user.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 = user.user_id and rating in (14,12,13)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (3)) as neutral_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
FROM xf_user_follow AS user_follow
INNER JOIN xf_user AS user ON
(user.user_id = user_follow.user_id)
INNER JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
INNER JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
WHERE user_follow.follow_user_id = ?
ORDER BY RAND()
LIMIT 6
Params: 73877
Run Time: 0.005801
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | user_follow | ref | PRIMARY,follow_user_id | follow_user_id | 4 | const | 7 | Using index; Using temporary; Using filesort |
| PRIMARY | user_option | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.user_follow.user_id | 1 | |
| PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.user_follow.user_id | 1 | |
| PRIMARY | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | valvetime_forums.user_follow.user_id | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | valvetime_forums.user.user_id | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | eq_ref | user_id_rating | user_id_rating | 8 | valvetime_forums.user.user_id,const | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | valvetime_forums.user.user_id | 1 | Using index condition |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | valvetime_forums.user.user_id | 1 | Using index condition |
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, 1796610423, 1796610423, XenForo_ControllerPublic_Member, Member, valid, user_id=73877, 1371618527
Run Time: 0.000264
SELECT *
FROM kingk_bbcm
ORDER BY tag
Run Time: 0.000539
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | kingk_bbcm | ALL | | | | | 11 | Using filesort |
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000177
| 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 ('page_nav', 'bdtagme_tag', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'social_connect_status_editor', 'member_view', 'nat_childlinks')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000386
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 10 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('user_field_Twitter_desc', 'user_field_Facebook_desc', 'user_field_aim_desc', 'user_field_msn_desc', 'user_field_icq_desc', 'user_field_yahoo_desc', 'user_field_skype_desc', 'user_field_gtalk_desc', 'home')Params: 1
Run Time: 0.000236
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 231 | | 9 | Using where |
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.000391
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 25 | Using where |
SELECT count_given as rating_count, rating, 1 as given
FROM dark_postrating_count
WHERE user_id = ?
UNION
SELECT count_received as rating_count, rating, 0 as given
FROM dark_postrating_count
WHERE user_id = ?
ORDER BY rating_count desc, rating asc
Params: 73877, 73877
Run Time: 0.000832
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 5 | |
| UNION | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 5 | |
| UNION RESULT | <union1,2> | ALL | | | | | | Using filesort |
SELECT COUNT(*)
FROM xf_liked_content
WHERE like_user_id = ?
Params: 73877
Run Time: 0.009095
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_liked_content | index | | content_type_id_like_user_id | 85 | | 8071 | Using where; Using index |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('likes_received')Params: 1
Run Time: 0.000258
| 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 ('dark_postrating_member_totals')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000321
| 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 count_given as rating_count, rating, 1 as given
FROM dark_postrating_count
WHERE user_id = ?
UNION
SELECT count_received as rating_count, rating, 0 as given
FROM dark_postrating_count
WHERE user_id = ?
ORDER BY rating_count desc, rating asc
Params: 73877, 73877
Run Time: 0.000286
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 5 | |
| UNION | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 5 | |
| UNION RESULT | <union1,2> | ALL | | | | | | Using filesort |
SELECT COUNT(*)
FROM xf_liked_content
WHERE like_user_id = ?
Params: 73877
Run Time: 0.000237
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_liked_content | index | | content_type_id_like_user_id | 85 | | 8071 | Using where; Using index |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('dark_postrating_member')
AND style_id = ?
AND language_id = ?Params: 9, 1
Run Time: 0.000268
| 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.000176
| 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.000160
| 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.000162
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |