SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000320
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: moods
Run Time: 0.000121
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000099
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_reply_banned,
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: 51627
Run Time: 0.000604
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: 14
Run Time: 0.000417
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | 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.*,
user_privacy.*,
session_activity.view_date AS last_view_date,
0 AS like_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_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id)
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 20)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 51627
Run Time: 0.001399
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 | 4 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | partisan_xfdata.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | partisan_xfdata.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | partisan_xfdata.post.user_id | 1 | |
SIMPLE | session_activity | ref | PRIMARY | PRIMARY | 4 | partisan_xfdata.post.user_id | 11 | Using where |
SELECT post_id
FROM xf_change_limit
WHERE post_id = 276042
AND user_id = 0
AND end_date > 1594310506
Run Time: 0.000188
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_change_limit | ref | post_id | post_id | 4 | const | 1 | Using where |
SELECT post_id
FROM xf_change_limit
WHERE post_id = 276045
AND user_id = 0
AND end_date > 1594312683
Run Time: 0.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_change_limit | ref | post_id | post_id | 4 | const | 1 | Using where |
SELECT post_id
FROM xf_change_limit
WHERE post_id = 276086
AND user_id = 0
AND end_date > 1594573055
Run Time: 0.000601
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_change_limit | ref | post_id | post_id | 4 | const | 1 | Using where |
SELECT post_id
FROM xf_change_limit
WHERE post_id = 276087
AND user_id = 0
AND end_date > 1594576276
Run Time: 0.000154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_change_limit | ref | post_id | post_id | 4 | const | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 51627
Run Time: 0.000112
SELECT thread.*
,
0 AS thread_reply_banned
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 51627
Run Time: 0.000335
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache
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: 14
Run Time: 0.000332
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT *
FROM xf_ignore_thread
WHERE user_id = ?
AND thread_id = ?
Params: 0, 51627
Run Time: 0.000345
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_ignore_thread | ref | user_thread | user_thread | 8 | const,const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: a4238987581501e505baf71d69439741, , 1714078037
Run Time: 0.000173
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_Thread, Index, valid, thread_id=51627, 1714074437,
Run Time: 0.000117
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', '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_threads', 'ignore_thread_tool', 'thread_view', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 1
Run Time: 0.000606
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 14 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('mood_display')
AND style_id = ?
AND language_id = ?
Params: 3, 1
Run Time: 0.000108
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_all')
Run Time: 0.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_all_lock')
Run Time: 0.000432
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_all_lock, a:1:{s:11:"all_lock_11";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1714074437;}}
Run Time: 0.001420
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000153
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 15 | 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.000100
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 15 | Using where |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE (thread.node_id IN (15, 18, 17, 16, 11, 14, 12, 13)) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.post_date DESC
LIMIT 36
Run Time: 0.000221
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | index | node_id_last_post_date,node_id_sticky_state_last_post | post_date | 4 | | 76 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | partisan_xfdata.thread.user_id | 1 | |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id IN (14, 14, 14, 14, 14, 14, 14, 14, 14, 12, 14, 14, 14, 13, 16, 14, 14, 14, 16, 13, 14, 14, 14, 14, 14, 13, 14, 16, 16, 14, 14, 14, 14, 14, 13, 16)
Run Time: 0.000281
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 4 | Using where |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | partisan_xfdata.node.node_id | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_all, a:1:{s:6:"all_11";a:2:{s:4:"html";s:7666:"<div class="avatarList">
<ul>
<li class="thread-54204 thread-node-14">
<a href="members/toughcoins.22846/" class="avatar Av22846s" data-avatarhtml="true"><img src="styles/flexile/xenforo/avatars/avatar_s.png" width="48" height="48" alt="toughcoins" /></a>
<a
href="threads/democrat-party-money-grab.54204/">
Democrat Party money-grab
</a>
<div class="userTitle">
<a href="members/toughcoins.22846/">toughcoins</a> posted <abbr class="DateTime" data-time="1713995068" data-diff="79369" data-datestring="Apr 24, 2024" data-timestring="5:44 PM">Apr 24, 2024 at 5:44 PM</abbr>
</div>
</li>
<li class="thread-54203 thread-node-14">
<a href="members/what-u-ignore.33514/" class="avatar Av33514s" data-avatarhtml="true"><img src="data/avatars/s/33/33514.jpg?1665005328" width="48" height="48" alt="What U ignore" /></a>
<a title="HEADS UP if you care for secure American elections." class="Tooltip"
href="threads/heads-up-if-you-care-for-secure-american-elections.54203/">
HEADS UP if you care for secure...
</a>
<div class="userTitle">
<a href="members/what-u-ignore.33514/">What U ignore</a> posted <abbr class="DateTime" data-time="1713975620" data-diff="98817" data-datestring="Apr 24, 2024" data-timestring="12:20 PM">Apr 24, 2024 at 12:20 PM</abbr>
</div>
</li>
<li class="thread-54202 thread-node-14">
<a href="members/charley.32216/" class="avatar Av32216s" data-avatarhtml="true"><img src="styles/flexile/xenforo/avatars/avatar_s.png" width="48" height="48" alt="charley" /></a>
<a
href="threads/the-first-witness-in.54202/">
The first witness in....
</a>
<div class="userTitle">
<a href="members/charley.32216/">charley</a> posted <abbr class="DateTime" data-time="1713784988" data-diff="289449" data-datestring="Apr 22, 2024" data-timestring="7:23 AM">Apr 22, 2024 at 7:23 AM</abbr>
</div>
</li>
<li class="thread-54201 thread-node-14">
<a href="members/justafarmer.18561/" class="avatar Av18561s" data-avatarhtml="true"><img src="styles/flexile/xenforo/avatars/avatar_s.png" width="48" height="48" alt="justafarmer" /></a>
<a title="President Biden just canceled plans to refill America's emergency oil reserve" class="Tooltip"
href="threads/president-biden-just-canceled-plans-to-refill-americas-emergency-oil-reserve.54201/">
President Biden just canceled...
</a>
<div class="userTitle">
<a href="members/justafarmer.18561/">justafarmer</a> posted <abbr class="DateTime" data-time="1713524229" data-diff="550208" data-datestring="Apr 19, 2024" data-timestring="6:57 AM">Apr 19, 2024 at 6:57 AM</abbr>
</div>
</li>
<li class="thread-54200 thread-node-14">
<a href="members/charley.32216/" class="avatar Av32216s" data-avatarhtml="true"><img src="styles/flexile/xenforo/avatars/avatar_s.png" width="48" height="48" alt="charley" /></a>
<a
href="threads/the-cannibals.54200/">
The Cannibals....
</a>
<div class="userTitle">
<a href="members/charley.32216/">charley</a> posted <span class="DateTime" title="Apr 18, 2024 at 1:14 PM">Apr 18, 2024</span>
</div>
</li>
<li class="thread-54199 thread-node-14">
<a href="members/charley.32216/" class="avatar Av32216s" data-avatarhtml="true"><img src="styles/flexile/xenforo/avatars/avatar_s.png" width="48" height="48" alt="charley" /></a>
<a
href="threads/alxovivichka-magorkavka.54199/">
Alxovivichka Magorkavka....
</a>
<div class="userTitle">
<a href="members/charley.32216/">charley</a> posted <span class="DateTime" title="Apr 17, 2024 at 2:08 PM">Apr 17, 2024</span>
</div>
</li>
<li class="thread-54198 thread-node-14">
<a href="members/justafarmer.18561/" class="avatar Av18561s" data-avatarhtml="true"><img src="styles/flexile/xenforo/avatars/avatar_s.png" width="48" height="48" alt="justafarmer" /></a>
<a title="Bragg files motion to hold Trump in contempt for alleged gag order violations, threatens 30 days of" class="Tooltip"
href="threads/bragg-files-motion-to-hold-trump-in-contempt-for-alleged-gag-order-violations-threatens-30-days-of.54198/">
Bragg files motion to hold Trump...
</a>
<div class="userTitle">
<a href="members/justafarmer.18561/">justafarmer</a> posted <span class="DateTime" title="Apr 16, 2024 at 2:27 PM">Apr 16, 2024</span>
</div>
</li>
<li class="thread-54197 thread-node-14">
<a href="members/justafarmer.18561/" class="avatar Av18561s" data-avatarhtml="true"><img src="styles/flexile/xenforo/avatars/avatar_s.png" width="48" height="48" alt="justafarmer" /></a>
<a title="National Popular Vote Interstate Compact" class="Tooltip"
href="threads/national-popular-vote-interstate-compact.54197/">
National Popular Vote Interstate...
</a>
<div class="userTitle">
<a href="members/justafarmer.18561/">justafarmer</a> posted <span class="DateTime" title="Apr 16, 2024 at 11:18 AM">Apr 16, 2024</span>
</div>
</li>
<li class="thread-54196 thread-node-14">
<a href="members/what-u-ignore.33514/" class="avatar Av33514s" data-avatarhtml="true"><img src="data/avatars/s/33/33514.jpg?1665005328" width="48" height="48" alt="What U ignore" /></a>
<a title="Biden Admin informed by Iran when they would attack Israel!" class="Tooltip"
href="threads/biden-admin-informed-by-iran-when-they-would-attack-israel.54196/">
Biden Admin informed by Iran when...
</a>
<div class="userTitle">
<a href="members/what-u-ignore.33514/">What U ignore</a> posted <span class="DateTime" title="Apr 15, 2024 at 6:55 PM">Apr 15, 2024</span>
</div>
</li>
<li class="thread-54195 thread-node-12">
<a href="members/mopar-dude.28633/" class="avatar Av28633s" data-avatarhtml="true"><img src="data/avatars/s/28/28633.jpg?1612044012" width="48" height="48" alt="Mopar Dude" /></a>
<a
href="threads/wake-up-call.54195/">
Wake Up Call
</a>
<div class="userTitle">
<a href="members/mopar-dude.28633/">Mopar Dude</a> posted <span class="DateTime" title="Apr 15, 2024 at 6:31 PM">Apr 15, 2024</span>
</div>
</li>
<li class="thread-54194 thread-node-14">
<a href="members/profiler.30153/" class="avatar Av30153s" data-avatarhtml="true"><img src="styles/flexile/xenforo/avatars/avatar_s.png" width="48" height="48" alt="Profiler" /></a>
<a
href="threads/sjl-and-the-rest-of-the-world.54194/">
SJL and the rest of the world
</a>
<div class="userTitle">
<a href="members/profiler.30153/">Profiler</a> posted <span class="DateTime" title="Apr 14, 2024 at 8:38 PM">Apr 14, 2024</span>
</div>
</li>
<li class="thread-54193 thread-node-14">
<a href="members/coinokc.100/" class="avatar Av100s" data-avatarhtml="true"><img src="data/avatars/s/0/100.jpg?1692927432" width="48" height="48" alt="CoinOKC" /></a>
<a title="Why Do Liberals Despise The American Flag So Much?" class="Tooltip"
href="threads/why-do-liberals-despise-the-american-flag-so-much.54193/">
Why Do Liberals Despise The...
</a>
<div class="userTitle">
<a href="members/coinokc.100/">CoinOKC</a> posted <span class="DateTime" title="Apr 10, 2024 at 10:48 PM">Apr 10, 2024</span>
</div>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Loading...</span>
</div>
</div>
</div>";s:4:"time";i:1714074437;}}
Run Time: 0.000347
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_all_lock, a:1:{s:11:"all_lock_11";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714074437;}}
Run Time: 0.000171