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.000555
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.000144
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.000143
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.000127
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000146
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: 326292
Run Time: 0.000675
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: 25
Run Time: 0.000360
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: 326292
Run Time: 0.001980
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: 326292
Run Time: 0.000088
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 8ed655af7a3218f85efbb809ad2384a2, a:8:{s:12:"sessionStart";i:1711677100;s:2:"ip";s:4:"Qޘ";s:11:"sessionCsrf";s:16:"pB0PYBcoo6WbpW0I";s:9:"userAgent";s:9:"claudebot";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1621687349;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1484570488;}}, 1711680700
Run Time: 0.000918
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, Qޘ, Qޘ, XenForo_ControllerPublic_Thread, Index, valid, thread_id=326292, 1711677100,
Run Time: 0.000112
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, 332921, a:13:{i:0;s:48:"联合国毒品和犯罪问题办公室发布的";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:100:"https://www.unodc.org/documents/data-and-analysis/wildlife/2020/World_Wildlife_Report_2020_9July.pdf";s:8:"original";a:2:{i:0;s:108:"[URL='https://www.unodc.org/documents/data-and-analysis/wildlife/2020/World_Wildlife_Report_2020_9July.pdf']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:43:"《2020年全球野生物种犯罪报告》";}}i:2;s:869:"同时指出,对欧洲鳗鱼幼苗等物种的管制加强,催生了新的非法贸易市场、象牙和穿山甲鳞片等完全不同的野生物种制品开始出现在同一批次的缴获物品中,此外,既非来源国也非目的地国的中间商国家犯罪组织开始集中控制多个市场。
今天发布的这份报告包含了从149个国家和地区、近18万批次的缴获物品中所获取的数据和信息。报告发现,在1999-2019年间,全球共有近6000种野生物种遭到非法贩卖,涉及哺乳类、爬行类、珊瑚、鸟类和鱼类等,没有一种物种占到全球非法贸易量的5%以上,也没有一个国家所吸收的非法野生物种制品超过全球总量的9%,抓获的犯罪嫌疑人也涉及150多个不同的国家和地区,所有这些都反映出野生物种犯罪是一个全球问题。
";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:72:"https://static.cnbetacdn.com/thumb/article/2020/0605/32ed8a709a5df2e.jpg";s:8:"original";a:2:{i:0;s:80:"[URL='https://static.cnbetacdn.com/thumb/article/2020/0605/32ed8a709a5df2e.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:96:"https://rdimg.com/proxy/https://static.cnbetacdn.com/thumb/article/2020/0605/32ed8a709a5df2e.jpg";}}}}i:4;s:729:"
毒品和犯罪问题办公室执行主任瓦利表示,“跨国有组织犯罪网络正从野生物种犯罪中获取丰厚利润,但付出代价的却是贫困群体。为了按照可持续发展目标保护人类和地球,为了在新冠疫情危机后以更好的方式实现复苏,我们不能忽视野生物种犯罪。报告能帮助国际社会提高对这一威胁的警觉,增加政府支持、通过必要的立法、建立跨机构协作、加强应对该项犯罪的能力。”
报告列出了全球野生物种犯罪领域的重要趋势,并详细分析了花梨木、象牙、犀牛角、穿山甲鳞片、活体爬行动物、大型猫科动物以及欧洲鳗鱼等物种的非法贸易现状。
";i:5;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:6;s:474:"
报告显示,对非洲象牙和犀牛角的需求正在下降,非法市场的规模较此前有所减小。2016到2018年间,象牙和犀牛角贩运所产生的非法收入分别在每年4亿和2.3亿美元左右。
毒品和犯罪问题办公室的数据显示,2005到2017年间所缴获的1262批非洲象牙中,有90%的目的地都是中国和东南亚,中国在过去是最大的市场,但近来越南已成为非法象牙贸易的主要目的地。
";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:48:"穿山甲贩运从活体和食用肉转向鳞片";}}i:8;s:641:"
报告显示,虽然亚洲各国仍会缴获穿山甲食用肉,但近年来更多截获的是主要从尼日利亚和刚果民主共和国等非洲国家出口到越南等亚洲国家的鳞片。从长期来看,中国是穿山甲非法贩运的主要目的地,广西防城港、广东广州和云南昆明是贩运路线上的重要节点,而越南则是主要的中转国。
穿山甲鳞片主要用于入药,目前,包括中国在内的19个国家向《濒危野生动植物种国际贸易公约》申报了国内的穿山甲鳞片库存,据报告,中国定期将该库存提供给指定的医院和中药生产商。
";i:9;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:42:"虎豹等大型猫科动物贩运量上升";}}i:10;s:1065:"
报告显示,虽然非法贸易的老虎及虎制品的缴获量仍然较小,但缴获的次数在2007到2018年间呈上升趋势,泰国和印度是主要的来源国,此外还有尼泊尔、孟加拉国和不丹。
据估计,全球笼养的老虎数量约在1万2574头,可能是野生数量的三倍。现有数据显示,笼养虎中有91%分布在中国、美国、泰国、老挝、印度、越南和南非这7个国家,部分笼养设施主要供应国内市场,另有部分似乎是非法跨国贸易的货源地。
报告显示,老虎的非法贸易主要涉及中国、越南、印度和印尼商人,相关制品主要销往中国的制药产业,以及越南和泰国的厂商和消费者。
报告指出,中国在1993年正式禁止国内的虎制品买卖,但豹骨被允许作为虎骨的替代品。2006年,中国全面禁止从野外猎捕豹类和收购豹骨,仅允许药品企业用完现有的豹骨库存,2018年,非处方药“鸿茅药酒”中包含豹骨一事,也曾在国内引发广泛关注。
";i:11;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:12;s:562:"
报告指出,犯罪分子正利用各种渠道开展非法野生物种贸易,热带硬木木材的非法贩运在过去二十年间大幅增加,部分非法砍伐的非洲花梨木甚至混入合法供应链,出现在国际木材家具展上。
此外,活体爬行动物以及虎骨等野生动物制品的交易已转向网络平台和加密聊天软件,进一步增加了执法难度。报告呼吁各国巩固司法体系,加强国际合作和跨境调查,采取更多措施,将野生物种犯罪作为一项严重罪行来加以惩治。";}, 1621686945, 1711677100
Run Time: 0.000632