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.000505
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.000156
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.000123
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000143
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: 44095
Run Time: 0.000404
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.000381
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: 44095
Run Time: 0.001505
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: 44095
Run Time: 0.000109
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d1864b4ed6d2ebb1a6179a2d8e678571, , 1716349516
Run Time: 0.000686
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=44095, 1716345916,
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, 43450, a:7:{i:0;s:69:"“仅限江浙沪包邮”,这句让无数淘宝族郁闷的话,";i:1;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:129:"近日被网友调侃为“阻碍全国人民团结友爱”两大因素之一,与“北方供暖”一起成为网上热词。";}}i:2;s:133:"为什么网购包邮能在江浙沪实现?是地域因素还是购物习惯结果?重庆距离包邮还有到底有多远呢?
";i:3;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:68:"为啥江浙沪能包邮?地方小 买多卖多 运输成本极低";}}i:4;s:1830:"
“江浙沪包邮”打开淘宝检索链接,615192件商品正以这样的方式促销。而若按其余地区划分(如西南包邮)检索,所得商品信息甚至不会超过20条。
“身在江浙沪洋洋得意,离开之后‘恨之入骨’。”曾在浙江大学读书的重庆网友“莫莫”抱怨,大学毕业回家后,上网购物少则十元、多则数十元的快递费,时常让她觉得不习惯。
“凭什么江浙沪就能包邮?”“莫莫”提出了这样的疑问。网上,网友们更把“北方供暖”与“江浙沪包邮”调侃为“阻碍全国人民团结友爱的两大因素”。
那么,为什么江浙沪地区能包邮,其他地方却不可以呢?
“虽然叫江浙沪,总面积并不大。”快递业内人士吴先生介绍,江苏、浙江两省面积均不到11万平方公里,上海市面积在6300平方公里左右,三地 总面积不到30万平方公里。而与之相比,包含“西南五省”的西南地区,总面积达250万平方公里,仅四川省总面积就超过了48万平方公里。因此,总面积较 小是实现包邮的重要因素之一。
此外,据阿里巴巴数据显示,江浙沪一带,包含了全国密度最大的淘宝买家、卖家,每日货物进出量是其他地区的数十倍甚至上百倍。“以空运算,每趟 航班的收包、送包量极大,因此分摊到每件货品上的价格也迅速降低。”重庆圆通有关负责人介绍,相较于重庆方面的快递运输成本,江浙沪快递成本极低。据南京 一淘宝卖家透露,江浙沪运输成本可以控制在首重每公斤1.7元左右(通常发包首重价格在7—10元)。
因此,卖家用这样的运输成本来包邮,可谓轻松愉快。
";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:85:"重庆距离包邮区还有多远? 取决于电商发展与地方运输网络建设";}}i:6;s:1652:"
“做西南地区包邮,跟做全国包邮区别不大。”重庆淘宝电商许涛介绍,以他的网店“凌悦服饰”为例,如在重庆做西南地区包邮,快递费与全国包邮几乎无异。
另外,许涛提到,事实上,以购买力与促销力度而言,因江浙沪一带顾客量大,在当地开店的店主做“江浙沪包邮”,势必能吸引可观客源,而对于专门 对重庆、西南或其他地区的包邮促销而言,并没有这样的作用。因此,许涛认为,这也是江浙沪地区常有包邮,而全国其余地区并没形成“包邮圈”的重要原因。
重庆距离包邮区还有多远?快递业内人士吴先生认为,一方面,重庆的电商环境较沿海地区落后。在重庆网商协会副秘书长张达巍看来,起码有十年以上 的距离。因此,让配套与电商服务的快递业,在落后十年以上的大环境下,搭建超前的运输网络显然不现实,故需要将希望寄托在电子商务行业的繁荣之上。
另一方面,记者注意到,除淘宝外,如腾讯电商旗下的易迅,已将大仓设在重庆,并计划在2013年内实现“一日三送”服务。而结合常设在成都的各 大平台大仓,吴先生认为,在西南地区,起码川渝范围内建立内部循环的高效、低价物流循环网络还是很有可能的。结合附近省市优势,其他地区形成自身的“包邮 圈”,可能是配合电子商务建设物流网络的一个短期发展方向。
(原标题:网购为啥总是江浙沪包邮 重庆距“包邮圈”还有多远?)";}, 1621686945, 1716345916
Run Time: 0.000807