SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routesPublic', 'routeFiltersIn', 'routeFiltersOut', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'trophyUserTitles', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.003168
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: modLogCounts
Run Time: 0.000160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT active FROM xf_addon WHERE addon_id = 'NodesAsTabs'
Run Time: 0.000137
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000152
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.000338
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 30 | Using where; 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.000174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 30 | Using where |
SELECT forum.*
,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE forum.node_id IN (2, 4, 5, 13, 9, 40, 39, 41, 7, 12, 15, 16, 17, 18, 19)
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 19 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.forum.node_id | 1 | Using index |
SELECT session_activity.*
,
user.*,
user_profile.*,
user_option.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
WHERE (session_activity.view_date > 1679988285)
ORDER BY session_activity.view_date DESC
Run Time: 0.000868
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 3 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.session_activity.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.user.user_id | 1 | |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.user.user_id | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000111
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT image_url, link
FROM xf_banner
ORDER BY RAND()
LIMIT 1
Run Time: 0.000113
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_banner | ALL | | | | | 1 | Using temporary; Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: fa65ed84aab615d8a52c2891d2f7b3e1, , 1679992785
Run Time: 0.000145
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_Forum, Index, valid, node_name=, 1679989185,
Run Time: 0.000068
SELECT *
FROM xf_addon
WHERE addon_id = ?
Params: xfBirthdayGreetings
Run Time: 0.000279
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT goal.*
FROM merc_goal AS goal
WHERE (goal.feature = 1) AND (goal.archived = 0) AND (goal.start_date < 1679989185)
GROUP BY (goal.goal_id)
ORDER BY display_order ASC
Run Time: 0.000222
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | goal | ALL | PRIMARY | | | | 1 | Using where; Using filesort |
SELECT goal.*
FROM merc_goal AS goal
WHERE (goal.feature = 1) AND (goal.archived = 0) AND (goal.start_date < 1679989185)
GROUP BY (goal.goal_id)
ORDER BY display_order ASC
Run Time: 0.000159
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | goal | ALL | PRIMARY | | | | 1 | Using where; Using filesort |
SELECT COUNT(*) AS total
FROM EWRrio_streams
LEFT JOIN EWRrio_games ON (EWRrio_games.game_id = EWRrio_streams.game_id)
Run Time: 0.000130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRrio_streams | ALL | | | | | 1 | |
SIMPLE | EWRrio_games | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.EWRrio_streams.game_id | 1 | Using index |
SELECT options.*, node.*,
permission.cache_value AS node_permission_cache
FROM nat_options AS options
INNER JOIN xf_node AS node
ON (node.node_id = options.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = options.node_id)
WHERE nat_display_tab = 1
ORDER BY options.nat_display_order
ASC
Params: 1
Run Time: 0.000372
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | options | ALL | node_id | | | | 29 | Using where; Using filesort |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.options.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,gamingau_main.options.node_id | 1 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bdmedal_message_medals', 'el_portal_navbar', 'node_forum_level_2', 'node_category_level_1', 'forum_list_who_visited_wrapper', 'wf_widget_wrapper', 'wf_widget_online_users', 'wf_widget_online_staff', 'who_visited_block', 'wf_widget_recent_status', 'wf_widget_stats', 'robbo_donationsidebar_goal', 'wf_widget_threads', 'gameservers_widget_servers', 'herodev_minecraftstatus_widget_status', 'teamspeak_widget_viewer', 'wf_widget_visitor_panel', 'dark_taigachat', 'merc_donation_sidebar', 'forum_list', 'EWRrio_Navtabs', 'steam_helper_criteria_privs', 'steam_navtabs', 'steam_public_index', 'dark_taigachat_list', 'wf_hook_moderator_bar', 'wf_revealer', 'waindigo_navigation_visitor_tab_subaccounts', 'skinod_linkPreview', 'bdmedal_navigation_tabs_help', 'waindigo_navigation_visitor_tab_joinusergroup', 'teamspeak_account_wrapper_sidebar_settings', 'teamspeak_navigation_visitor_tab_link', 'VietXfAdvStats_wrapper', 'tinhte_xentag_bb_code_tag_tag', 'tinhte_xentag_hook_message_below', 'tinhte_xentag_hook_message_content', 'tinhte_xentag_hook_message_notices', 'tinhte_xentag_hook_navigation_tabs_forums', 'tinhte_xentag_hook_post_private_controls', 'tinhte_xentag_hook_post_public_controls', 'modess_moderator_bar_mod_log_counts', 'banlist_position', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 34, 1
Run Time: 0.000698
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 45 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('streams')
Params: 1
Run Time: 0.000110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_forum_list')
Run Time: 0.000111
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT * from `gameservers_servers` WHERE `active` = 1 ORDER BY `order` ASC
Run Time: 0.000158
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | gameservers_servers | ALL | | | | | 1 | Using where; Using filesort |
SELECT *
FROM xf_herodev_minecraft_server
WHERE active = 1
ORDER BY display_order
Run Time: 0.000137
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_herodev_minecraft_server | ALL | | | | | 1 | Using where; Using filesort |
SELECT xf_user_profile.user_id, dob_year, dob_month, dob_day,
xf_user.username AS username, xf_user.user_id AS userId, xf_user.*,
xf_user.avatar_date, xf_user.gravatar AS gravatar, xf_user.email,
xf_user_option.receive_admin_email AS recibirEmail
FROM xf_user_profile
LEFT JOIN xf_user ON
(xf_user.user_id = xf_user_profile.user_id)
LEFT JOIN xf_user_option ON
(xf_user_option.user_id = xf_user_profile.user_id)
WHERE dob_month = 03 AND dob_day = 28
AND xf_user.last_activity > DATE_SUB( CURDATE( ) , INTERVAL 60 DAY )
AND xf_user_option.receive_admin_email = 1
AND xf_user.user_state = 'valid'
ORDER BY dob_year, dob_month, dob_day ASC
Run Time: 0.000563
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 1 | Using where; Using index |
SIMPLE | xf_user | eq_ref | PRIMARY,user_state,last_activity | PRIMARY | 4 | gamingau_main.xf_user_profile.user_id | 1 | Using where |
SIMPLE | xf_user_option | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.xf_user_profile.user_id | 1 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('advanced_rules')
Params: 1
Run Time: 0.000126
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('nat_bodyjs')
AND style_id = ?
AND language_id = ?
Params: 34, 1
Run Time: 0.000119
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT user.*
FROM xf_user AS user
WHERE user.user_state = 'valid' AND user.is_banned = 0
ORDER BY user.register_date DESC
LIMIT 10
Run Time: 0.000474
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | index | user_state | register_date | 4 | | 10 | Using where |
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000304
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 30 | 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.000187
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 30 | Using where |
SELECT thread.*
,
NULL AS thread_read_date,
article.node_id AS library_id,
node.node_id AS forum_id, node.title AS forum_title,
user.*
FROM xf_thread AS thread
LEFT JOIN xf_article AS article ON
(article.article_id = thread.article_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
INNER JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = thread.last_post_user_id)
WHERE ((1=1)) AND (thread.node_id IN ('1', '2', '4', '5', '6', '13', '9', '40', '39', '41', '7', '12', '14', '15', '16', '17', '18', '19')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated'))
ORDER BY thread.last_post_date DESC
LIMIT 10
Run Time: 0.002009
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post | | | | 82 | Using where; Using temporary; Using filesort |
SIMPLE | article | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (Block Nested Loop) |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.thread.node_id | 1 | Using index |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.thread.node_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.thread.last_post_user_id | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 9
Run Time: 0.000773
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 2
Run Time: 0.000168
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 4
Run Time: 0.000119
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 13
Run Time: 0.000127
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 16
Run Time: 0.000121
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 12
Run Time: 0.000121
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 40
Run Time: 0.000140
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('VietXfAdvStats_section_users_new', 'VietXfAdvStats_section_users_top_posters', 'VietXfAdvStats_section_users_top_trophy_points', 'VietXfAdvStats_section_users_top_liked', 'VietXfAdvStats_section_threads_recent', 'VietXfAdvStats_section_threads_latest', 'VietXfAdvStats_section_threads_hot')
Params: 1
Run Time: 0.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 7 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('VietxfAdvStats_users_new', 'VietXfAdvStats_users', 'VietxfAdvStats_threads_recent', 'VietXfAdvStats_threads')
AND style_id = ?
AND language_id = ?
Params: 34, 1
Run Time: 0.000183
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 4 | Using where |