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.000674
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.000141
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.000114
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
0 AS thread_reply_banned
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 51227
Run Time: 0.000538
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.000454
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, 51227
Run Time: 0.000919
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: c42bbe9ce4949bb9ad2f8afe58077458, a:8:{s:12:"sessionStart";i:1714071213;s:2:"ip";s:4:"e)";s:11:"sessionCsrf";s:16:"Hiw2CtCcLVXhpAKx";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1714061736;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1708425725;}}, 1714074813
Run Time: 0.000274
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, e), e), XenForo_ControllerPublic_Thread, IgnoreThread, valid, thread_id=51227, 1714071213,
Run Time: 0.000154
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'wf_widget_wrapper', 'wf_widget_threads', 'ignore_thread', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 1
Run Time: 0.000216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 7 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_all')
Run Time: 0.000103
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.000854
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:1714071213;}}
Run Time: 0.006728
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000231
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.000120
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.000300
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.000482
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="76145" 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="95593" 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="286225" 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="546984" 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:1714071213;}}
Run Time: 0.000494
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:1714071213;}}
Run Time: 0.000249