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.000484
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.000135
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.000107
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_help_page
ORDER BY display_order
Run Time: 0.000105
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_help_page | ALL | | | | | 1 | Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 77d6194cca8a516a7d446f35fea07e0c, , 1614255244
Run Time: 0.000236
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_Help, Terms, valid, page_name=terms, 1614251644,
Run Time: 0.000146
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'help_wrapper', 'wf_widget_wrapper', 'wf_widget_threads', 'help_terms', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 1
Run Time: 0.000920
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 8 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_all')
Run Time: 0.000290
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.000160
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:1614251644;}}
Run Time: 0.011721
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000219
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.000101
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.000934
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 | | 69 | 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, 14, 14, 14, 14, 14, 16, 14, 14, 16, 14, 14, 12, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14)
Run Time: 0.000388
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 3 | 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:9371:"<div class="avatarList">
<ul>
<li class="thread-52329 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="Biden moving quickly to fire Postmaster General as DeJoy tells Dems to 'get used to me'" class="Tooltip"
href="threads/biden-moving-quickly-to-fire-postmaster-general-as-dejoy-tells-dems-to-get-used-to-me.52329/">
Biden moving quickly to fire...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1614208944" data-diff="42700" data-datestring="Feb 24, 2021" data-timestring="6:22 PM">Feb 24, 2021 at 6:22 PM</abbr>
</div>
</li>
<li class="thread-52328 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="Ted Cruz uncorks profane rant on neighbors who leaked chats about Cancun vacation plans" class="Tooltip"
href="threads/ted-cruz-uncorks-profane-rant-on-neighbors-who-leaked-chats-about-cancun-vacation-plans.52328/">
Ted Cruz uncorks profane rant on...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1614120268" data-diff="131376" data-datestring="Feb 23, 2021" data-timestring="5:44 PM">Feb 23, 2021 at 5:44 PM</abbr>
</div>
</li>
<li class="thread-52327 thread-node-14">
<a href="members/joenation.18850/" class="avatar Av18850s" data-avatarhtml="true"><img src="data/avatars/s/18/18850.jpg?1604804327" width="48" height="48" alt="JoeNation" /></a>
<a title="Biden's Revolution Is Doing What Obama and Clinton Did Not" class="Tooltip"
href="threads/bidens-revolution-is-doing-what-obama-and-clinton-did-not.52327/">
Biden's Revolution Is Doing What...
</a>
<div class="userTitle">
<a href="members/joenation.18850/">JoeNation</a> posted <abbr class="DateTime" data-time="1614052418" data-diff="199226" data-datestring="Feb 22, 2021" data-timestring="10:53 PM">Feb 22, 2021 at 10:53 PM</abbr>
</div>
</li>
<li class="thread-52326 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="The Republican solution to losing an election is to make it harder to vote" class="Tooltip"
href="threads/the-republican-solution-to-losing-an-election-is-to-make-it-harder-to-vote.52326/">
The Republican solution to losing...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1613947125" data-diff="304519" data-datestring="Feb 21, 2021" data-timestring="5:38 PM">Feb 21, 2021 at 5:38 PM</abbr>
</div>
</li>
<li class="thread-52325 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="Applause as Biden Plans to Rescind Medicaid Work Requirements, Targeting One of Most 'Cruel' Policie" class="Tooltip"
href="threads/applause-as-biden-plans-to-rescind-medicaid-work-requirements-targeting-one-of-most-cruel-policie.52325/">
Applause as Biden Plans to Rescind...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1613917301" data-diff="334343" data-datestring="Feb 21, 2021" data-timestring="9:21 AM">Feb 21, 2021 at 9:21 AM</abbr>
</div>
</li>
<li class="thread-52324 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="Man Yells “Get A F—ing Job” At Families Waiting In Food Drive Lines" class="Tooltip"
href="threads/man-yells-%E2%80%9Cget-a-f%E2%80%94ing-job%E2%80%9D-at-families-waiting-in-food-drive-lines.52324/">
Man Yells “Get A F—ing Job” At...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1613917207" data-diff="334437" data-datestring="Feb 21, 2021" data-timestring="9:20 AM">Feb 21, 2021 at 9:20 AM</abbr>
</div>
</li>
<li class="thread-52323 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="Trump 'doesn't have to play nice with these people anymore' as he launches war on GOP: report" class="Tooltip"
href="threads/trump-doesnt-have-to-play-nice-with-these-people-anymore-as-he-launches-war-on-gop-report.52323/">
Trump 'doesn't have to play nice...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1613860878" data-diff="390766" data-datestring="Feb 20, 2021" data-timestring="5:41 PM">Feb 20, 2021 at 5:41 PM</abbr>
</div>
</li>
<li class="thread-52322 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="BUSTED: Second Texas Republican fled killer storm by hopping on his private jet and flying to Florid" class="Tooltip"
href="threads/busted-second-texas-republican-fled-killer-storm-by-hopping-on-his-private-jet-and-flying-to-florid.52322/">
BUSTED: Second Texas Republican...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1613859592" data-diff="392052" data-datestring="Feb 20, 2021" data-timestring="5:19 PM">Feb 20, 2021 at 5:19 PM</abbr>
</div>
</li>
<li class="thread-52321 thread-node-14">
<a href="members/coinblazer.28341/" class="avatar Av28341s" data-avatarhtml="true"><img src="data/avatars/s/28/28341.jpg?1576446661" width="48" height="48" alt="CoinBlazer" /></a>
<a
href="threads/death-penalty.52321/">
Death Penalty.
</a>
<div class="userTitle">
<a href="members/coinblazer.28341/">CoinBlazer</a> posted <abbr class="DateTime" data-time="1613833920" data-diff="417724" data-datestring="Feb 20, 2021" data-timestring="10:12 AM">Feb 20, 2021 at 10:12 AM</abbr>
</div>
</li>
<li class="thread-52320 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="Steve Bannon believed Trump had early stage dementia" class="Tooltip"
href="threads/steve-bannon-believed-trump-had-early-stage-dementia.52320/">
Steve Bannon believed Trump had...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1613792396" data-diff="459248" data-datestring="Feb 19, 2021" data-timestring="10:39 PM">Feb 19, 2021 at 10:39 PM</abbr>
</div>
</li>
<li class="thread-52319 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="Squash The Vote: The GOP Plan to Thwart Democracy" class="Tooltip"
href="threads/squash-the-vote-the-gop-plan-to-thwart-democracy.52319/">
Squash The Vote: The GOP Plan to...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1613777113" data-diff="474531" data-datestring="Feb 19, 2021" data-timestring="6:25 PM">Feb 19, 2021 at 6:25 PM</abbr>
</div>
</li>
<li class="thread-52318 thread-node-14">
<a href="members/frydaddyjr.28975/" class="avatar Av28975s" data-avatarhtml="true"><img src="data/avatars/s/28/28975.jpg?1584674095" width="48" height="48" alt="FryDaddyJr" /></a>
<a title="While Ted Cruz was rushing back to America, AOC raised $1 million for the people of Texas" class="Tooltip"
href="threads/while-ted-cruz-was-rushing-back-to-america-aoc-raised-1-million-for-the-people-of-texas.52318/">
While Ted Cruz was rushing back to...
</a>
<div class="userTitle">
<a href="members/frydaddyjr.28975/">FryDaddyJr</a> posted <abbr class="DateTime" data-time="1613776327" data-diff="475317" data-datestring="Feb 19, 2021" data-timestring="6:12 PM">Feb 19, 2021 at 6:12 PM</abbr>
</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:1614251644;}}
Run Time: 0.000780
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:1614251644;}}
Run Time: 0.000190