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.000714
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.000149
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.000140
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.000112
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000656
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: 231409
Run Time: 0.001854
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.000501
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: 231409
Run Time: 0.003617
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: 231409
Run Time: 0.000089
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: c92a3f593dc498e44d0871aaa79cd1d2, , 1714977127
Run Time: 0.000877
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=231409, 1714973527,
Run Time: 0.000106
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, 237019, a:11:{i:0;s:95:"日报标题:说个朴素的问题,你们别笑,真的无法想象中国有多么缺水
";i:1;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:38:"http://pic4.zhimg.com/3dbd096a3_is.jpg";}}i:2;s:1871:" 哲部豪跋,虽千万人,我不同意
我个人想说一个比较朴素观点,纯市场机制运作的产物,你浪费与否或者说节约与否,其实没什么大不了,因为最终都是在促进市场的发展,你浪费的东西,你要多交很多钱,最后甚至可以说这促进行业发展。
但是中国的自来水供给的体系不是一个纯市场机制,应该说根本不是市场机制,甚至可以说就是福利机构,真的不怎么挣钱,跟瓶装水确实成本有差距,但是体现在价格上根本不可能差到几百倍,瓶装水,你花钱了,你怎么浪费,我觉得最后都给这个行业有促进的作用,哪怕你买矿泉水冲厕所,那是你的自由。
但是中国的自来水,真的爱惜点用,你不知道中国面临的水资源匮乏有多么严重,中国的自来水管网有多么的年久失修,每年光是管网漏损就有 16%,真没那么多钱去全部修一遍,而且每年供水的缺口非常大,400 亿立方,而且地下水污染严重,开采过度,严重制约中国的社会经济发展
很多人没有这样一个概念,中国每产生一万美金的 GDP 所需要的耗水量是 1197m³,是世界平均的 1.7 倍,美国的 3 倍,日本的 7.3 倍、德国的 12.3 倍(2009 年)
十二五期间,水耗下降单位 GDP 28% 换算下来现在大概每一万美金耗水量是 864m³,仍旧是一个非常高的数字,对比一下美国 400 ,日本 163,德国 97
此外,中国用水的大头是农业用水,但是中国农业灌溉用水有效使用率是 50%,对比发达国家农业用水效率能达到 70% 以上,甚至以色列、德国、日本这种地方能到 80%,2030 年中国农业用水灌溉效率的目标是提升至 60%,能达到这个水平,中国的水资源缺口基本算是堵上了。
";i:3;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:231:"
[*]污染严重
[*]管网漏损
[*]产业结构,农业、重工业占比大,技术陈旧,耗水量大
[*]污水回用技术不成熟,量小、效率低
[*]供水价格相对自由市场的价格偏低,几乎算是福利
";}}i:4;s:495:"
这基本就是中国公共供水、用水的现状,所以自来水之类的公共供水,能节约还是尽量节约吧
最后推荐一本书,本文的大部分内容来自于这本书《中国城市水效管理》,写的非常好,把中国水资源的问题,说的非常透彻,解决之道也分析清楚,是本难得的好书,可以当做公民读本来看,就算不是从业者,最好也看看,能了解很多中国水资源的现状以及未来发展的趋势。
";i:5;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:63:"http://pic1.zhimg.com/70/28ecb844b7c34862f8a6e1f83f1712b8_b.jpg";}}i:6;s:40:"
更多讨论,查看 知乎圆桌 ·";i:7;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:1:" ";}}i:8;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"https://www.zhihu.com/roundtable/environeco";s:8:"original";a:2:{i:0;s:51:"[URL='https://www.zhihu.com/roundtable/environeco']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:9;s:2:"
";i:10;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"http://www.zhihu.com/question/29522582";s:8:"original";a:2:{i:0;s:46:"[URL='http://www.zhihu.com/question/29522582']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1714973527
Run Time: 0.000750