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.001309
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.000087
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.000070
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.000116
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,
'' 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: 3970
Run Time: 0.000453
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 | 0 | unique row not found |
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: 13
Run Time: 0.000277
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 | 35 | const,const,const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
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: 3970
Run Time: 0.000153
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 | 0 | unique row not found |
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: 13
Run Time: 0.000217
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 | 35 | const,const,const | 1 | |
SELECT post.*
,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
0 AS like_date,
waindigo_avatarflags_ip.ip, session.view_date
FROM xf_post AS post
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_ip AS waindigo_avatarflags_ip ON
(waindigo_avatarflags_ip.ip_id = post.ip_id)LEFT OUTER JOIN xf_session_activity AS session ON post.user_id = session.user_id
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 1)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 3970
Run Time: 0.000901
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 1 | Using where; Using temporary; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.post.user_id | 1 | |
SIMPLE | waindigo_avatarflags_ip | eq_ref | PRIMARY | PRIMARY | 4 | gamingau_main.post.ip_id | 1 | |
SIMPLE | session | ALL | PRIMARY | | | | 22 | Using where; Using join buffer (hash join) |
SELECT post_id
FROM xf_change_limit
WHERE post_id = 4087
AND user_id = 0
AND end_date > 1406894243
Run Time: 0.000082
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_change_limit | ref | post_id,post_id_2 | post_id | 4 | const | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 3970
Run Time: 0.000038
SELECT field.*
,
ff.field_id, ff.node_id
FROM xf_thread_field AS field
INNER JOIN xf_forum_field AS ff ON
(ff.field_id = field.field_id)
WHERE (ff.node_id IN(13))
ORDER BY field.materialized_order
Run Time: 0.000267
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | ff | eq_ref | PRIMARY,field_id | PRIMARY | 198 | const,gamingau_main.field.field_id | 1 | Using index |
SELECT field.*
,
ff.field_id, ff.node_id
FROM xf_thread_field AS field
INNER JOIN xf_forum_field AS ff ON
(ff.field_id = field.field_id)
WHERE (ff.node_id IN(13))
ORDER BY field.materialized_order
Run Time: 0.000153
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | ff | eq_ref | PRIMARY,field_id | PRIMARY | 198 | const,gamingau_main.field.field_id | 1 | Using index |
SELECT field.*
,
ff.field_id, ff.node_id
FROM xf_post_field AS field
INNER JOIN xf_forum_post_field AS ff ON
(ff.field_id = field.field_id)
WHERE (ff.node_id IN(13))
ORDER BY field.materialized_order
Run Time: 0.000227
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ff | ALL | | | | | 1 | Using where; Using temporary; Using filesort |
SIMPLE | field | eq_ref | PRIMARY | PRIMARY | 194 | gamingau_main.ff.field_id | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
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: 3970
Run Time: 0.000168
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 | 0 | unique row not found |
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: 13
Run Time: 0.000223
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 | 35 | const,const,const | 1 | |
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000132
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.000094
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 params
FROM xf_session_activity
WHERE user_id = '0'
AND controller_action = 'CreateThread'
Run Time: 0.000063
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | ALL | PRIMARY | | | | 22 | Using where |
SELECT xf_thread.thread_id, xf_thread.title, xf_thread.node_id, xf_node.title AS nodetitle, xf_thread.post_date
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
WHERE xf_thread.title LIKE '%Link%'
AND xf_thread.title LIKE '%Steam%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND (xf_thread.node_id = 1 OR xf_thread.node_id = 2 OR xf_thread.node_id = 4 OR xf_thread.node_id = 5 OR xf_thread.node_id = 6 OR xf_thread.node_id = 13 OR xf_thread.node_id = 9 OR xf_thread.node_id = 40 OR xf_thread.node_id = 39 OR xf_thread.node_id = 41 OR xf_thread.node_id = 7 OR xf_thread.node_id = 12 OR xf_thread.node_id = 14 OR xf_thread.node_id = 15 OR xf_thread.node_id = 16 OR xf_thread.node_id = 17 OR xf_thread.node_id = 18 OR xf_thread.node_id = 19)
AND xf_thread.thread_id <> '3970'
AND xf_thread.node_id = '13'
ORDER BY xf_thread.thread_id DESC
LIMIT 5
Run Time: 0.000171
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
SIMPLE | xf_thread | ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | const | 6 | Using index condition; Using where |
SELECT xf_thread.thread_id, xf_thread.title, xf_thread.node_id, xf_node.title AS nodetitle, xf_thread.post_date
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
WHERE xf_thread.title LIKE '%Link%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND (xf_thread.node_id = 1 OR xf_thread.node_id = 2 OR xf_thread.node_id = 4 OR xf_thread.node_id = 5 OR xf_thread.node_id = 6 OR xf_thread.node_id = 13 OR xf_thread.node_id = 9 OR xf_thread.node_id = 40 OR xf_thread.node_id = 39 OR xf_thread.node_id = 41 OR xf_thread.node_id = 7 OR xf_thread.node_id = 12 OR xf_thread.node_id = 14 OR xf_thread.node_id = 15 OR xf_thread.node_id = 16 OR xf_thread.node_id = 17 OR xf_thread.node_id = 18 OR xf_thread.node_id = 19)
AND xf_thread.thread_id <> '3970'
AND xf_thread.node_id = '13'
ORDER BY xf_thread.thread_id DESC
LIMIT 5
Run Time: 0.000126
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
SIMPLE | xf_thread | ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | const | 6 | Using index condition; Using where |
SELECT xf_thread.thread_id, xf_thread.title, xf_thread.node_id, xf_node.title AS nodetitle, xf_thread.post_date
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
WHERE xf_thread.title LIKE '%Steam%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND (xf_thread.node_id = 1 OR xf_thread.node_id = 2 OR xf_thread.node_id = 4 OR xf_thread.node_id = 5 OR xf_thread.node_id = 6 OR xf_thread.node_id = 13 OR xf_thread.node_id = 9 OR xf_thread.node_id = 40 OR xf_thread.node_id = 39 OR xf_thread.node_id = 41 OR xf_thread.node_id = 7 OR xf_thread.node_id = 12 OR xf_thread.node_id = 14 OR xf_thread.node_id = 15 OR xf_thread.node_id = 16 OR xf_thread.node_id = 17 OR xf_thread.node_id = 18 OR xf_thread.node_id = 19)
AND xf_thread.thread_id <> '3970'
AND xf_thread.node_id = '13'
ORDER BY xf_thread.thread_id DESC
LIMIT 5
Run Time: 0.000120
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
SIMPLE | xf_thread | ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | const | 6 | Using index condition; Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: a2838e291990fcd82a3026d066b71569, a:7:{s:12:"sessionStart";i:1711636007;s:2:"ip";s:4:"Qޘ";s:11:"sessionCsrf";s:16:"p0nuCNFjXnG4G7kI";s:9:"userAgent";s:9:"claudebot";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1471086409;}}, 1711639607
Run Time: 0.000134
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, Qޘ, Qޘ, XenForo_ControllerPublic_Thread, Index, valid, thread_id=3970, 1711636007,
Run Time: 0.000050
SELECT *
FROM xf_addon
WHERE addon_id = ?
Params: xfBirthdayGreetings
Run Time: 0.000110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT COUNT(*) AS total
FROM EWRrio_streams
LEFT JOIN EWRrio_games ON (EWRrio_games.game_id = EWRrio_streams.game_id)
Run Time: 0.000153
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.000387
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', 'quattro_bbcode_xtable', 'tinhte_xentag_bb_code_tag_tag', 'tinhte_xentag_bb_code_tag_hashtag', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'wf_widget_wrapper', 'wf_widget_stats', 'wf_widget_threads', 'extendedpoll_message_content', 'extendedpoll_thread_poll_results', 'bdmedal_message_medals', '_header_node.13', '_footer_node.13', '_header_post_node.13', '_footer_post_node.13', 'waindigo_quick_reply_prepend_customfields', 'waindigo_header_node_customfields', 'el_portal_navbar', 'tinhte_xentag_thread_view', 'tinhte_xentag_hook_thread_view_pagenav_before', 'tinhte_xentag_hook_thread_view_form_before', 'tinhte_xentag_hook_thread_view_qr_before', 'tinhte_xentag_hook_thread_view_qr_after', 'modess_thread_log', 'thread_view', 'EWRrio_Navtabs', 'steam_helper_criteria_privs', 'steam_navtabs', 'steam_public_index', 'dark_taigachat', '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', '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.000431
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 53 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('streams')
Params: 1
Run Time: 0.000077
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 ('waindigo_thread_view_tabs_library')
AND style_id = ?
AND language_id = ?
Params: 34, 1
Run Time: 0.000073
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 title, template_compiled
FROM xf_template_compiled
WHERE title IN ('waindigo_thread_view_tools_links_customfields')
AND style_id = ?
AND language_id = ?
Params: 34, 1
Run Time: 0.000093
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 title, template_compiled
FROM xf_template_compiled
WHERE title IN ('RT_UserOnlineRibbon')
AND style_id = ?
AND language_id = ?
Params: 34, 1
Run Time: 0.000082
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 title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('offline')
Params: 1
Run Time: 0.000061
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 ('waindigo_local_time_post_memberlocaltime')
AND style_id = ?
AND language_id = ?
Params: 34, 1
Run Time: 0.000070
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 data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_thread_view')
Run Time: 0.000062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
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 = 29
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.000428
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 2 | 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.000069
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.000075
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |