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.000319
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.000074
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.000064
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: 48908
Run Time: 0.000386
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: 12
Run Time: 0.000226
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: 48908
Run Time: 0.000968
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 | 7 | 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 attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (241609, 241758)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000283
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 2 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | partisan_xfdata.attachment.data_id | 1 | |
SELECT post_id
FROM xf_change_limit
WHERE post_id = 241609
AND user_id = 0
AND end_date > 1407293110
Run Time: 0.000147
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 = 241622
AND user_id = 0
AND end_date > 1407333284
Run Time: 0.000121
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 = 241653
AND user_id = 0
AND end_date > 1407378597
Run Time: 0.000122
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 = 241661
AND user_id = 0
AND end_date > 1407426058
Run Time: 0.000197
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 = 241758
AND user_id = 0
AND end_date > 1407785150
Run Time: 0.000115
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 = 241800
AND user_id = 0
AND end_date > 1407930002
Run Time: 0.000118
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 = 241807
AND user_id = 0
AND end_date > 1408027160
Run Time: 0.000119
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: 48908
Run Time: 0.000077
SELECT thread.*
,
0 AS thread_reply_banned
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 48908
Run Time: 0.000215
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: 12
Run Time: 0.000330
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, 48908
Run Time: 0.000141
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: d0729e92ae302d9bcdf645a5157091cc, , 1714075790
Run Time: 0.000144
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=48908, 1714072190,
Run Time: 0.000196
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.000210
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.000067
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.000064
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.000120
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:1714072190;}}
Run Time: 0.007584
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000117
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.000066
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.000153
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.000195
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="77122" 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="96570" 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="287202" 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="547961" 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:1714072190;}}
Run Time: 0.000320
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:1714072190;}}
Run Time: 0.000205