SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000093
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_tag
WHERE tag_url = ?
Params: wahoo
Run Time: 0.000239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | const | tag_url | tag_url | 302 | const | 1 | |
SELECT *
FROM xf_tag_result_cache
WHERE tag_id = ?
AND user_id = ?
AND expiry_date > ?
Params: 2206, 0, 1713439981
Run Time: 0.000168
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_result_cache | const | tag_id_user_id,expiration_date | tag_id_user_id | 8 | const,const | 1 | |
SELECT tag_content_id, content_type, content_id
FROM xf_tag_content
WHERE tag_id = ?
AND visible = 1
ORDER BY content_date DESC
LIMIT 200
Params: 2206
Run Time: 0.000295
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_content | ref | tag_id_content_date | tag_id_content_date | 4 | const | 24 | Using where |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache,
last_post_user.avatar_date AS last_post_user_avatar_date, last_post_user.gravatar AS last_post_user_gravatar, last_post_user.gender AS last_post_user_gender, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 1) as dark_postrating_1_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 14) as dark_postrating_14_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 2) as dark_postrating_2_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 3) as dark_postrating_3_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 4) as dark_postrating_4_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 5) as dark_postrating_5_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 6) as dark_postrating_6_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 7) as dark_postrating_7_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 8) as dark_postrating_8_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 9) as dark_postrating_9_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 10) as dark_postrating_10_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 11) as dark_postrating_11_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 12) as dark_postrating_12_count, 1 as dark_postrating_has_fetched_max
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 13) as dark_postrating_13_count, 1 as dark_postrating_has_fetched_max
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
LEFT JOIN xf_user AS last_post_user ON
(last_post_user.user_id = thread.last_post_user_id)
WHERE thread.thread_id IN (1558226, 1544337, 1531555, 1531314, 1531126, 1527547, 1526889, 1513879, 1510561, 1489981, 1489979, 1482898, 1482354, 1472588, 1471929, 1466554, 1452968, 1405562, 1391242, 1387349, 1385723, 1382365, 1353795, 1321059)
Run Time: 0.003437
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | thread | range | PRIMARY | PRIMARY | 4 | | 24 | Using where |
PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.thread.user_id | 1 | |
PRIMARY | node | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.thread.node_id | 1 | |
PRIMARY | post | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.thread.first_post_id | 1 | |
PRIMARY | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,foromtb_www.thread.node_id | 1 | Using where |
PRIMARY | last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.thread.last_post_user_id | 1 | |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.thread.first_post_id,const | 1 | Using index |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 2206, 0, 1713439981, 1713443581, [["thread",1558226],["thread",1544337],["thread",1531555],["thread",1531314],["thread",1531126],["thread",1527547],["thread",1526889],["thread",1513879],["thread",1510561],["thread",1489981],["thread",1489979],["thread",1482898],["thread",1482354],["thread",1472588],["thread",1471929],["thread",1466554],["thread",1452968],["thread",1405562],["thread",1391242],["thread",1387349],["thread",1385723],["thread",1382365],["thread",1353795],["thread",1321059]]
Run Time: 0.013405
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 8aff3c2888b45d69796ecea8733e394a, , 1713443581
Run Time: 0.000147
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_Tag, Tag, valid, tag_url=wahoo, 1713439981,
Run Time: 0.000077
SELECT activity.*, user.username
FROM xc_trade_activity AS activity
LEFT JOIN xf_user AS user ON user.user_id=activity.user_id
WHERE activity.user_id=?
ORDER BY activity.dateline DESC
LIMIT 0, ?
Params: 0, 10
Run Time: 0.000260
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | activity | ref | user_id_dateline | user_id_dateline | 4 | const | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.activity.user_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'search_result_thread', 'tag_view', 'nflj_showcase_tab_links', 'xcxt_navtabs', 'waindigo_you_are_using_as_user_loginasuser', 'waindigo_moderator_bar_loginasuser', 'dark_postrating', 'dark_postrating_member', 'dark_postrating_member_totals', 'message_user_info_extra', 'user_criteria_content', 'thread_list_item_icon_key', 'dark_postrating_member_notable_tabs', 'dark_postrating_account_wrapper', 'dark_postrating_navigation_visitor_tab', 'dark_postrating_visitor_panel', 'dark_postrating_member_card', 'dark_postrating_member_info', 'dark_postrating_message_user_info', 'xcfw_copyright', 'xcxt_headinclude', 'xcxt_trading_preferences_link_list', 'xcxt_visitor_panel_addon', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000124
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 25 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xcxt_trade')
Params: 2
Run Time: 0.000046
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT *
FROM xf_notification
ORDER BY notification_id
Run Time: 0.000081
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_notification | index | | PRIMARY | 4 | | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('GritterNotifications')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000044
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |