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.000514
| 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_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')Run Time: 0.000148
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000149
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_brivium_addon | index | | PRIMARY | 77 | | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: brBriviumAddOns, a:0:{}
Run Time: 0.000126
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000141
| 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: 1456
Run Time: 0.000396
| 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: 9
Run Time: 0.000579
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
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_bb_code_parse_cache AS signature_parse_cache ON
(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_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 AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE (
(post.thread_id = ? AND (post.position >= 0 AND post.position < 10) )
)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASCParams: 1456
Run Time: 0.003042
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 2 | Using index condition; Using where |
| SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,xenforo.cc.post.post_id | 1 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.cc.post.user_id | 1 | |
| SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.cc.post.user_id | 1 | |
| SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.cc.post.user_id | 1 | |
| SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,xenforo.cc.post.user_id | 1 | Using where |
| SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | xenforo.cc.post.user_id,func | 1 | Using where |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 1456
Run Time: 0.000096
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: e50d7ce3570d33237f79dc34946eb856, , 1714670989
Run Time: 0.000894
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=1456, 1714667389,
Run Time: 0.000116
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 1502, a:1:{i:0;s:2294:"快速安装win8的方式。众所周知，win8的引导方式从以前的文字引导（NT60 ）改成了图形界面并支持鼠标操作。这点让那个我兴奋了好半天。但是看到网上有好多人装win8都是用的硬盘安装方式，首先要腾出一个盘来，再者如果要重装将是很麻烦的一件事情。而win7时代就原生支持vhd启动方式，这个可以看论坛上各位高手们的文章。书归简短。文章伺候（以下内容操作均在win7系统上操作，请选择好系统版本 如果是家庭版用户请飘过，谢谢！本文安装不涉及其他第三方软件）不好意思 各位没有做截图。图这两天补上。
win7下右键计算机-管理-磁盘管理-右键左侧的磁盘管理 创建一个VHD（请记好你保存的VHD文件路径） 这里说明一下 win8的系统32位最少创建一个固定大小为40-50G的vhd，如果是X64位的请确保系统最少固定大小60G的vhd 最好是100G。创建完毕后。用准备好的X64和X86的安装盘（U盘更好）启动win8安装，此处省略几百字，到选择安装盘那里，需要点击磁盘。按下shift+F10键 调出命令行 输入Diskpart进入磁盘管理命令行模式，输入select vdisk file=vhd文件位置，然后回车 提示已载入。（比如我原来是将vhd文件存在E盘的win8文件夹下，在进入磁盘管理的时候 你的VHD也会占用你一个盘符这个是别人告诉我的，不知道对不对，所以在往后一个盘符就应该没问题）
载入成功后，输入命令attach vdisk 装载。这时候关闭命令行 刷新磁盘就会发现你刚刚创建的VHD硬盘，格式化 安装后面步骤不用说了吧！大家都懂得！
关于卸载win8 用vhd方式 在window8的右键计算机 属性 高级 启动和故障修复 设置中将window7设为系统默认启动系统，这样就把系统引导交给了nt60方式，此步骤和开机选择系统选择菜单 选择window7，然后系统重启一样。不知道说的对不对，哪位如果知道可以帮忙普及一下这方面的知识。 经过上面步骤选择后 重启之后按下F8是win7的系统菜单，进入系统将挂载的硬盘删除，用BCD或者其他优化软件将win8的启动删除即可（不删除也没啥关系）";}, 1621686945, 1714667389
Run Time: 0.001139
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 1503, a:2:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:15:"相关知识：";}}i:1;s:1734:"
把系统装进VHD格式虚拟磁盘
原理非常简单
把系统装进源虚拟磁盘（就是一个文件）
然后，创建差异磁盘来顶替源虚拟磁盘
以后的所有更改都作用在差异磁盘上
没更改的内容是直接转到源磁盘读取
更改的内容写到差异磁盘上
简单的说，就是把“系统”这张纸上再铺一张“差异磁盘”的描图纸
描图纸划坏了
抽掉换一张即可
装系统前按SHIFT+F10调出命令行
可以先格式化C盘，自己决定
Format c: /fs:ntfs /q
diskpart回车（下同，都要回车）
等Diskpart >提示符出现后
create vdisk file="C:\win7.vhd" maximum="16384" type=expandabe
意思是，在C盘创建一个名为win7.vhd，最大容量为16384字节（16.0GB）的动态扩容虚拟磁盘
你也可以改为D:\win7.vhd改到D盘创建
然后
按上箭头
会复制上一条命令
把它第一个单词改为select
变成
select vdisk file="C:\win7.vhd" maximum="16384" type=expandabe
然后
attach vdisk
虚拟磁盘就加载上了
然后，把系统装到磁盘1即可
装完第一次重启
然后第二次重启时再进安装盘
同样，SHIFT+F10调命令行
notepad
记事本就出来了
按打开，然后把文件类型改成所有文件
把那个win7.vhd改个名
比如win7s.vhd
然后DISKPART
create vdisk file="c:\win7.vhd" parent="c:\win7s.vhd"
↑如果你装在D盘C:可以换成D:↑
创建一个差异虚拟磁盘
然后EXIT
notepad进记事本
同理，把文本文档换成所有文件
然后，把win7.vhd拷贝一份
然后，重启，照常使用
出了毛病，用安装盘启动或者进双系统XP
把win7.vhd改个名，然后，再把那个拷贝的win7.vhd再拷贝一份，改名为win7.vhd
就相当于重装了";}, 1621686945, 1714667389
Run Time: 0.000799
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 12859, a:1:{i:0;s:31:"这个可以学习一下的了.";}, 1621686945, 1714667389
Run Time: 0.000445