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.000541
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.000147
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.000142
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.000147
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000144
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: 114546
Run Time: 0.000384
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.000348
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: 114546
Run Time: 0.001532
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: 114546
Run Time: 0.000091
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 1d2cac4662b0d7b06ce217a5d3d206dd, , 1715871668
Run Time: 0.000690
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=114546, 1715868068,
Run Time: 0.000103
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, 117970, a:13:{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:12:"热门评论";}}i:1;s:408:"
匿名人士 | 2014-07-28 07:52:35
是写的云里雾里还是翻译的不知所云?
支持:0 | 反对:0
最近,亚马逊推出了Kindle Unlimited服务,用户每个月只需花费9.99美元(约合人民币62元),就能无限制阅读60万册电子书。其实亚马逊的这项服务提供了新的机会,为解决现在的电子书窘境。是买还是租,由用户自己决定。
";i:2;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:62:"http://static.cnbetacdn.com/newsimg/2014/0728/25_1jRoZqq4l.jpg";}}i:3;s:2:"
";i:4;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:27:"买了就是你的了吗?";}}i:5;s:1237:"
很多电影、书籍和音乐网站卖给你的都有严格的数码版权管理,这些限制使得你买就和租一样,对你买的这些,你有部分权利,但并不是真正拥有。以视频为例。在苹果、亚马逊、谷歌和其他正当的电影资源上,能下载的电影都是有数码版权管理,而且只能在经授权的设备和特定的视频应用里播放。
你买错了吗?你买的产品,是没有所谓的数字化财产的,你既不能外借,也不能再卖给别人。因此,关于视频的话,我坚持租赁,而不是买。但如果你准备买的话,你就应该给予亚马逊尤其是电子书以肯定。随着Kindle应用的增多,(其中包括网页版的云阅读,能在任一浏览器上使用),这已经是比较仁慈的数码产权“统治方式”了,而你也不用买苹果的iBook应用。
Kindle的灵活度比不上亚马逊的MP3,也比不上苹果iTunes商店AAC格式的歌曲。这些都是没有数码版权管理的,甚至等亚马逊或者苹果公司不存在了,你也能继续使用这些数码文件。因此亚马逊在数码供应方面还是不错的。当然这项服务能够维护消费者权益,是迟早的事。
";i:6;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:6:"选择";}}i:7;s:907:"
Kindle Owner借阅图书馆计划,尽管是免费的,但要求用户注册Amazon Prime的账号,还需要Kindle电子书阅读器。新出的Kindle Unlimited和Kindle Owner借阅图书馆计划一样,选择有限。
有些老年人可能会享受在周五的晚上逛逛视频商店,找点东西来观看。这就和浏览Kindle Unlimited一样。我来给这项服务做个小测试。看看纽约时报上排名前十的10本畅销小说和10本纪实作品,这些作品包括去年以及更早时期的,我觉得这会给亚马逊带来一些启发。
在这20本书里,只有一本书,也就是Laurelin Paige自行出版的爱情小说《哈得孙河》能在Kindle Unlimited上阅读。结果证明前五的出版商都不想和Kindle Unlimited合作。我在自己的书架里随机挑出了10本书,Netflix公司的选择质量不一,但是Kindle Unilimited差得更远。
";i:8;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:9;s:884:"
我有幸挨着较好的电子书借阅资源:华盛顿公共图书馆。该图书馆外借的电子书目上,有6本纽约时报上排名前十的畅销小说,还有7本畅销纪实书,另外有一本也是我自己收藏过的书。让人遗憾的是,这14本书里只有William Gibson的科幻小说《神经漫游者》能够外借,而不是搁置在那里。我得等到其他书目的电子版核查入馆之后,才能够借。这是图书馆存在很久的问题了:在华盛顿邮报两年半前记录这一问题以来,电子书需求暴涨,出版商制定的外借配额限制很严格,很多读者只能等待。
就算你注册了Amazon Prime,Kindle Unlimited每个月还需9.99美元,而当地图书馆的资源却是不收你费用的。关于书籍的话,如果我想租或者借,我会考虑花费,坚持利用图书馆的资源。
";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:12:"可重读性";}}i:11;s:1226:"
如果要买书,我会考虑我会不会重读这本书,我会搜寻没有数码版权管理的版本。一些相对较小的出版社,如O’Reilly Media和Tor Books在这方面做得不错。毕竟,我避免在Kindle上购买不值得重读的书。如果我在考虑一本书有没有长存的价值,我更有可能会买免数码版权的、不用其他设备以及高清晰度的版本,也就是纸质书。
我觉得音乐也是如此。如果我想永久地拥有一张专辑,能够反复播放,我会去买CD,然后刻录到电脑上。音乐公司意识到这样就不用数码版权管理了,因此现在购买网上下载对我来说是一件容易的事。
很多作家和独立出版商也意识到了这一点,于是利用亚马逊的方法来卖免数码版权管理的书籍。这些书生存地很艰难,但是Author Earnings的分析者分析了亚马逊的销售数据,在上周报道指出,免数码版权管理的书平均每本的销量是有数码版权管理的两倍。
一个是租借较便宜的数码版权管理的书,一个是购买没有数码版权管理的书,二选一,这是个有意思的选择,但并不是现下亚马逊准备做的事。
来源:";i:12;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:111:"http://%EF%BC%9Ahttps://www.yahoo.com/tech/the-kindle-conundrum-should-you-rent-or-buy-digital-92475429404.html";s:8:"original";a:2:{i:0;s:119:"[URL='http://%EF%BC%9Ahttps://www.yahoo.com/tech/the-kindle-conundrum-should-you-rent-or-buy-digital-92475429404.html']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:5:"yahoo";}}}, 1621686945, 1715868068
Run Time: 0.000795