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.000533
| 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.000146
| 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.000141
| 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.000137
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000156
| 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: 350214
Run Time: 0.000379
| 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.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: 350214
Run Time: 0.002599
| 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: 350214
Run Time: 0.000087
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 5934a5d57cefc56ea5ca2fbd97e269a7, , 1715852396
Run Time: 0.000773
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=350214, 1715848796,
Run Time: 0.000101
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, 356848, a:45:{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:80:"https://pic4.zhimg.com/v2-bf06ae7cec4924a291ccf4c32a566748_l.jpg?source=8673f162";}}i:1;s:33:" 剁椒鹿，私人号:duojiaolu ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:58:"https://www.zhihu.com/question/422686198/answer/1495779208";s:8:"original";a:2:{i:0;s:66:"[URL='https://www.zhihu.com/question/422686198/answer/1495779208']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}i:3;s:88:"
微型胡萝卜不是一个品种，而是由普通的美国胡萝卜削出来的。
";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:83:"https://pic2.zhimg.com/v2-268e3a510a3c1dea88dbb01be5555f90_720w.jpg?source=8673f162";}}i:5;s:216:"
就是这种包装好的胡萝卜，卖的时候叫什么水果胡萝卜或者吮指胡萝卜、baby carrot、手指胡萝卜啥的，其实都是普通胡萝卜切出来的（不过不是我们本地的种）。
";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:83:"https://pic2.zhimg.com/v2-0b46c1c068c40691fcef0c1b12838b65_720w.jpg?source=8673f162";}}i:7;s:49:"
大小不同的部位，对应不同的规格
";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:83:"https://pic3.zhimg.com/v2-414024a8e7624c0c2d03ca5298af5d7a_720w.jpg?source=8673f162";}}i:9;s:1:"
";i:10;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:83:"https://pic4.zhimg.com/v2-81fe6e9fd7f44830db5d459a58a574ab_720w.jpg?source=8673f162";}}i:11;s:1:"
";i:12;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:83:"https://pic2.zhimg.com/v2-8d5610b1b504ffe8f06b3238079e7c76_720w.jpg?source=8673f162";}}i:13;s:363:"
曾经我跟朋友讨论过，原来很多朋友以为水果胡萝卜长出来就是圆圆小小的样子······
看在上帝的份上，没人发现水果胡萝卜没有头上和根部的胡须吗（笑）？
这个产品是这么来的，上世纪八九十年代的美国加利福尼亚州，当时的胡萝卜种植人麦克，不愿意将仅仅因为";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:30:"有一点点腐烂和缺陷的";}}i:15;s:661:"胡萝卜扔掉，为此他开始寻求一种能高效利用资源且避免浪费的方法。
后来，他找到了工业化的青豆切削设备和土豆削皮机，将胡萝卜切成两种长度削皮打磨。于是，一个「新的」胡萝卜品种就诞生了。
所以水果胡萝卜最开始的目的是为了解决掉部分腐烂的胡萝卜（当然现在销量上去了应该不用坏的了），然后包装成孩子爱吃的健康餐后甜点为卖点，以此卖出去。
当年的倾销产品，现在竟然成了高价货，也是让人意想不到呢。
我特意去找了淘宝和京东都卖的很好的一款水果胡萝卜，标价是 ";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:15:"38 块钱一斤";}}i:17;s:86:"，还特意标明了适合小孩（是儿童食品比较好赚钱么哈哈哈）。
";i:18;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:83:"https://pic4.zhimg.com/v2-045f9f06c763c8230b4558fe18fb2499_720w.jpg?source=8673f162";}}i:19;s:1:"
";i:20;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:83:"https://pic4.zhimg.com/v2-44e482e5576dad98aa82456d3b374b72_720w.jpg?source=8673f162";}}i:21;s:64:"
商家也比较实诚，标题就写了是打磨的啊 23333
";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:144:"所以三十八一斤的胡萝卜和两块钱一斤的胡萝卜有啥区别？没啥区别，有的人喜欢便宜的，有的人喜欢贵的。";}}i:23;s:2:"
";i:24;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:83:"https://pic2.zhimg.com/v2-ed5d11b890f7df06ee597be4bb05c370_720w.jpg?source=8673f162";}}i:25;s:67:"
hhh，然后我去搜的时候发现了这条评价排在第一
";i:26;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:83:"https://pic2.zhimg.com/v2-1a62681c4f098da139dcb731cdec72f7_720w.jpg?source=8673f162";}}i:27;s:630:"
朋友们。准备买小胡萝卜的今天可以省下 40 块钱奶茶钱了 23333
哦，对了，另外一个冷知识，我跟朋友讨论的时候，她还提了一句。说这种胡萝卜可以生吃。
天地良心啊，朋友，所有胡萝卜都可以生吃，如果你乐意的话。
生菜可以生吃，莴苣可以生吃，事实上，除了少数几种块茎或者不加热有毒的豆类外，其他蔬菜都可以生吃，只要你不担心寄生虫和大肠杆菌的话。
因为欧美人就是这么吃的，所有蔬菜通通用生的做沙拉 不过因此也经常爆出大肠杆菌啥的中毒罢了。
";i:28;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:83:"https://pic1.zhimg.com/v2-f0791cac4674826edd8d6392c2c2c667_720w.jpg?source=8673f162";}}i:29;s:264:"
利益相关人员来反驳了 23333
没错，水果胡萝卜的品种确实是培育专家一代一代选出来的（并且专家并不是你们工厂培育的），他们付出了努力，可是这跟我的描述并不矛盾呀？
我说的是，把市面上";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:9:"几块钱";}}i:31;s:33:"一斤的胡萝卜切一下就卖";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:18:"几十块钱一斤";}}i:33;s:121:"这件事。
国内的胡萝卜品种不太适合生吃，所以现有的水果胡萝卜都是引进的西方的种：
";i:34;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:83:"https://pic2.zhimg.com/v2-54d98426f9aaf7458039097d19a1db93_720w.jpg?source=8673f162";}}i:35;s:1:"
";i:36;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:83:"https://pic2.zhimg.com/v2-e1fbe83f45dae63173b3fc37488ed8cd_720w.jpg?source=8673f162";}}i:37;s:306:"
但是就是在西方国家，可以生吃的胡萝卜也就比普通胡萝卜多 2~3 倍的样子，现在国内种植的微型（比正常的小，但是要做成图上那样还是得机器切）胡萝卜已经有一定规模的种植，切出来的却比普通的贵几十倍，这不太合理吧？
";i:38;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:83:"https://pic2.zhimg.com/v2-4020a49a07a1568173c38f0534160a29_720w.jpg?source=8673f162";}}i:39;s:348:"
所以啊，大家如果喜欢生吃胡萝卜，就去找找那种可以鲜食的品种吧！
只要吃得人多了，种植的会更多的~（而且即便是可以鲜食的品种，也不会太甜，所以为什么不直接吃苹果呢 23333）
下图是作者比较了国内外比较好的一些「微型」胡萝卜品种的营养元素：
";i:40;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:83:"https://pic4.zhimg.com/v2-7a30f32e5ebf7302e21d744ee17b1027_720w.jpg?source=8673f162";}}i:41;s:94:"
你看，费大力气选育半天，可溶性糖最高也才 8%，被苹果轻松秒杀：
";i:42;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:83:"https://pic2.zhimg.com/v2-d7232e59032eda7a83bc98d5b3f16df5_720w.jpg?source=8673f162";}}i:43;s:943:"
苹果平均可溶性糖都有 11%（算上那些极酸的苹果平均）
所以你如果想要从水果胡萝卜身上吃到什么难以名状的甜味，还是直接省点钱买苹果吧。
维 c 和蛋白质这些成分更是轻松被其他蔬菜秒杀，而且，胡萝卜最为重要的营养：胡萝卜素（维生素 A 前体）是脂溶性的！！
所以营养学课本上都有说，吃胡萝卜最好用油炒，炒肉是最最最好的。
那么整体来说，水果胡萝卜只有一个好处：方便，因为他帮你切好，洗好了。
可是你愿不愿意为了这么一点点方便付出几十倍的代价，就看你个人意愿了。
当然，如果未来水果胡萝卜价格降到十块钱左右一斤，那还算比较合理的，偶尔给孩子吃也还行吧~
完毕~
引用文献：
1 鲜食胡萝卜品种引进及肉质根的相关研究 王淳
2 苹果可溶性糖组分及其含量特性的研究
";i:44;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:40:"https://www.zhihu.com/question/422686198";s:8:"original";a:2:{i:0;s:48:"[URL='https://www.zhihu.com/question/422686198']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1715848796
Run Time: 0.001151