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.000495
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.000152
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.000161
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.000147
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: 344121
Run Time: 0.000439
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: 38
Run Time: 0.000375
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 ASC
Params: 344121
Run Time: 0.001949
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 1 | 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: 344121
Run Time: 0.000117
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 7b7d5100b3d2c62d4556d2b715dd34e7, , 1716331597
Run Time: 0.000649
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=344121, 1716327997,
Run Time: 0.000104
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, 350753, a:53:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:77:"https://pic4.zhimg.com/ad98bed8fc98ea1431436f100e54194d_l.jpg?source=8673f162";}}i:1;s:186:" White,哲学初学者,时间线上是科普干货
今天浏览斯坦福哲学百科时,在一堆高大上的名词中间,我发现:
有一个奇怪的词条混进去了!
";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:74:"https://link.zhihu.com/?target=https%3A//plato.stanford.edu/entries/holes/";s:8:"original";a:2:{i:0;s:82:"[URL='https://link.zhihu.com/?target=https%3A//plato.stanford.edu/entries/holes/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:5:"Holes";}}i:3;s:54:"
啥玩意?洞?
哲学跟洞有啥子关系?
";i:4;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:64:"https://pic3.zhimg.com/v2-248c715fac7743c56e60609697ff76c2_b.jpg";}}i:5;s:43:"
我首先想到了不该想的地方。
";i:6;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:64:"https://pic2.zhimg.com/v2-d47909a9b653758281ccaefc96a74a78_b.jpg";}}i:7;s:96:"
但转念一想,不太可能。嗯。
那会不会是柏拉图的「洞穴比喻」呢?
";i:8;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:64:"https://pic1.zhimg.com/v2-ad8a9dd067dcb4677b81e94b156c552b_b.jpg";}}i:9;s:210:"
但我立刻意识到,「洞穴比喻」的「洞穴」是 cave,而不是 hole。
如果人们真住在 hole 里,那就成恐怖故事了。
那,这个词条到底讲的是啥呢?
谜底揭晓:";i:10;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:24:"洞的本体论地位。";}}i:11;s:410:"
日常语言中,我们往往把「洞」这个词当做实体来使用。比如「奶酪上有许多洞」。
我们也把「洞」视为因果解释中的一个角色,比如「水跑出来是因为桶上有个洞」。
可是,讲道理,洞似乎是非物质性的,它真的存在吗?如果不存在,它又怎么能成为因果链条中的一环呢?关于洞的难题真是层出不穷。
";i:12;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:24:"关于洞的更多难题";}}i:13;s:6:"
1、";i:14;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:45:"很难解释我们是如何知觉到洞的。";}}i:15;s:101:"
如果知觉建立在因果关系上,那么洞这种非物质体似乎不能成为原因。
2、";i:16;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:36:"很难找到洞的个体化标准。";}}i:17;s:342:"
对于一个物质实体,我们可以以它的组成部分作为个体化标准。可是如果洞是非物质的,它似乎就没有组成部分了。
或许可以通过洞周围的物质?比如,对于一个甜甜圈(donut),洞周围的可吃部分似乎可以成为个体化标准。这里,我们称甜甜圈这种东西为";i:18;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:12:"「洞主」";}}i:19;s:147:"(host),可以理解为洞的载体。但是,我们也可以想象,洞主发生了变化,而洞还是那个洞。
还有一种东西叫";i:20;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:12:"「洞客」";}}i:21;s:188:"(guest),就是填充一个洞的东西。比如往一个洞里倒水时,那个水就是洞客。洞客同样不能成为洞的个体化条件,因为空的洞也是洞啊。
3、";i:22;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:30:"很难说明洞的分体学。";}}i:23;s:116:"
在纸上扎一个洞,接着,紧挨着它再扎一个洞。现在,纸上有一个洞还是两个洞?
4、";i:24;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:36:"很难评估洞的解释相关性。";}}i:25;s:95:"
如果洞是非物质性的,在物理学解释中能否使用“洞”这个概念?
5、";i:26;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:18:"洞有形状么?";}}i:27;s:2:"
";i:28;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:12:"洞的理论";}}i:29;s:94:"
为了解释上述问题,揭示洞的本质,哲学家们提出了各种洞的理论。
";i:30;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:22:"A、洞根本不存在";}}i:31;s:268:"
说「X 上有个洞」,实际上是在说「X 是有洞的」或「X 有一个洞 - 周围的(hole-surrounding)部分」。
挑战:所有关于洞的说法都能被如此还原么?对比:「这颗牙上的洞,比牙医的最好的探针还小」。
";i:32;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:43:"B、洞存在,但只是一块时空区域";}}i:33;s:289:"
挑战:在甜甜圈中间的洞里,放一个婚戒。可知,婚戒中间的洞,是甜甜圈中间的洞的一部分。现在,让甜甜圈顺时针旋转,让婚戒逆时针旋转。请问,婚戒中间的洞难道同时朝两个方向旋转么?(脑洞大开啊……)
";i:34;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:43:"C、洞是时空的一种有性质的部分";}}i:35;s:375:"
从时空的角度来看,有一些时空的部分是狗,有一些时空的部分是雕像,等等。洞也没有什么特别的,有一些时空的部分是洞而已。
挑战:如果在这个世界或其他可能世界上,存在真正的没有性质的时空部分,那么是否就存在着真正的非物质实体了呢?洞会不会就是其中之一呢?
";i:36;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:40:"D、洞就是日常的物质性存在者";}}i:37;s:351:"
它们就是物质性的洞主。因为,对于每一个洞,我们都可以找到一个洞 - 周围;对于每一个洞 - 周围,我们都可以找到一个洞。这说明,洞就是洞 - 周围!
挑战:洞 - 周围上的一个点,算不算洞里的一个点?洞 - 周围的扩大,算不算洞的变大?(好像算诶……)
";i:38;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:40:"E、洞是物质性洞主的否定部分";}}i:39;s:169:"
这样,甜甜圈=肯定的饼 + 否定的一块。
挑战:这样,挖洞算作增加一个部分,填洞算作减少一个部分,这和日常用法相悖。
";i:40;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:46:"F、洞是某种「扰乱」(disturbances)";}}i:41;s:457:"
某物有洞,和绳子打结、地毯起皱是一样的,都是某种「扰乱」。
挑战(没看懂,放英文原文了):The metaphysical status of such entities, however, calls for
refinements. Simons 1987: 308 has suggested construing them as Husserlian
moments that continuously change their fundaments, but this seems to suit knots
and wrinkles better than holes.(现象学的大佬们,啥是「胡塞尔的时刻」呀?)
G、";i:42;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:103:"洞不是殊相,或许它们是性质、关系,或者或许是真实的缺位(genuine absences)";}}i:43;s:184:"
以上是一些「洞是……」的理论。另一些人认为,洞不是别的东西,洞就是洞,它自成一派。那么,洞这种特殊的东西,有哪些特性呢?
";i:44;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:31:"A、洞是本体论上寄生的";}}i:45;s:2:"
";i:46;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:19:"B、洞是可填的";}}i:47;s:2:"
";i:48;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:34:"C、洞是分体学上有结构的";}}i:49;s:2:"
";i:50;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:31:"D、洞是拓扑学上混杂的";}}i:51;s:139:"
好吧,我已经晕了。关于这个话题的讨论,真是脑洞大开呀……各位有什么看法呢?洞到底是什么呢?
";i:52;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:37:"https://zhuanlan.zhihu.com/p/30963183";s:8:"original";a:2:{i:0;s:45:"[URL='https://zhuanlan.zhihu.com/p/30963183']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1716327997
Run Time: 0.000760