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.000582
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.000188
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.000179
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.000135
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 36613d14ecbb57fc647d2b0498431f79, 1716155768
Run Time: 0.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
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: 326308
Run Time: 0.000443
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.000408
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: 326308
Run Time: 0.001918
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: 326308
Run Time: 0.000089
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = '36613d14ecbb57fc647d2b0498431f79')
Params: 1716159368
Run Time: 0.000945
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=326308, 1716155768,
Run Time: 0.000124
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, 332937, a:6:{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:222:"近年来崛起的美团点评和拼多多势不可挡,最近股价都出现了飙升。两家公司都体现了中国市场数字经济的光明前景,投资者对这两家蓬勃发展的互联网公司爱不释手。";}}i:1;s:182:"中国市场蓬勃发展的数字经济催生了数以千计的初创企业。但长期以来最知名的莫过于BAT:阿里巴巴、腾讯和百度。
而诸如电子商务公司";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:109:"https://c.duomai.com/track.php?k=nJ9QWa1VmJxYTPklWYmYDO5IDNy0DZp9VZ0l2cmYiJt92YuQmauc3d3ZkMlYkMlE0MlMHc0RHa9Q";s:8:"original";a:2:{i:0;s:117:"[URL='https://c.duomai.com/track.php?k=nJ9QWa1VmJxYTPklWYmYDO5IDNy0DZp9VZ0l2cmYiJt92YuQmauc3d3ZkMlYkMlE0MlMHc0RHa9Q']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:6:"京东";}}i:3;s:506:"、叫车服务公司滴滴出行以及字节跳动等新进入者也在重塑市场。最近让投资者心跳加速的莫过于美团点评和拼多多。这两家公司有很多共同点:其都是为消费者提供打折服务(美团点评是提供打折的电影票等线下服务,拼多多是提供打折的各类产品)。两家公司也都在2018年上市。自年初以来,两家公司的股价都出现了飙升,现在市值都超过了1000亿美元,但发展道路却各不相同。
";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:72:"https://static.cnbetacdn.com/thumb/article/2019/1026/351986139532667.png";s:8:"original";a:2:{i:0;s:80:"[URL='https://static.cnbetacdn.com/thumb/article/2019/1026/351986139532667.png']";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/2019/1026/351986139532667.png";}}}}i:5;s:4235:"
美团网于2010年由清华大学毕业生王兴创立,最初主要销售优惠券。与腾讯和阿里巴巴一样,美团也在向其他领域扩张。2013年,公司推出送餐业务,并推出了预订酒店和机票的旅游业务,两年后其与大众点评网合并。2018年,合并后的美团点评斥资27亿美元收购了共享单车服务公司摩拜单车,并打入叫车服务领域。去年,该公司将叫车业务扩展到了中国几十个城市。里昂证券分析师梁向奕表示,如今美团点评可以被视为“服务搜索引擎”。
其中诸如外卖送餐和共享单车等业务量大但利润低。2019年,公司每次送餐的利润不到3美分,主要来自向餐馆收取的佣金,但总量极大。美团点评的平台拥有70万到80万名外卖员。美团点评外卖营收占到整个中国外卖市场营收的三分之二。
和摩拜单车一样,外卖送餐业务帮助美团点评吸引了更多用户,然后可以将他们引到旅游等公司利润更高的业务上来。美团在酒店预订方面的营业利润率一直在20%到35%之间;今年5月底美团点评的酒店预订量已恢复到此前的70%。
拼多多则采取了与美团点评完全相反的策略。它没有分散投资,而是在电子商务上加倍投入。拼多多战略副总裁九鼎说,在线零售在中国的发展速度是如此之快,足以证明自己不能做“万事通”。
根据市场研究公司eMarketer的数据,中国今年的电子商务销售额可能会增长16%,达到14.4万亿元人民币(合2万亿美元)。阿里巴巴可能会获得其中一半的增长。拼多多将与京东争夺剩下的增长份额。
拼多多崛起的核心是“社交购物”概念,公司将其描述为好市多和迪士尼乐园的融合体。如果用户和其他喜欢砍价的人一起大量购买,产品价格会更便宜。用户还可以通过微信加入现有群组或邀请好友。商家也愿意让出一定的利润来换取更高的销量。
拼多多创始人、曾在美国谷歌任工程师的黄峥并没有发明团购,但他确实发展了这个想法,例如引入游戏,奖励玩家可用于未来消费的积分。
中国消费者喜欢拼多多。截至3月底,其中6.28亿人在过去12个月里至少在拼多多上购买过一件商品,比去年增加42%;只有阿里巴巴拥有比拼多多更多的活跃用户(7.26亿)。拼多多用户的平均年消费额也从1250元人民币增加到1800元人民币,公司在中国电子商务市场的份额也从2017年的2%上升到去年的10%。市场研究公司伯恩斯坦预计,到2024年拼多多在中国电子商务市场中的占比将达到18%,与京东持平。
购物狂潮使得拼多多今年第一季度的营收同比增长44%,达到65亿元人民币。这些钱来自交易费用和商家为促销而花钱购买的应用内广告。拼多多并没有商品库存,也没有自建物流网络,完全依靠商家将产品运送给买家。相反,拼多多在销售和营销上烧掉了大量现金,其第一季度相关开支达到营收的112%,而且还在不断增长。
九鼎坚称,这些成本可以轻松收回,但其他市场的经验表明情况并非如此。全球叫车服务巨头Uber也是将卖家(司机)和买家(乘客)联系起来,但一直在亏损。像Uber一样,拼多多享受着“网络效应”带来的好处:更多买家使用应用,吸引更多的卖家,这些卖家反过来又吸引新的买家。但和叫车服务一样,买家和卖家在转向提供更优惠价格的另一款应用时几乎没有什么成本。京东和阿里巴巴已经向其庞大的用户群推出了类似于拼多多的服务。
当然,美团点评的盈利之路更加清晰。去年该公司首次实现盈利,其盈利的食品和旅游业务在与饿了么等对手的竞争中获得市场份额,在财务上也给了亏损部门喘息的空间。
无论如何,美团点评和拼多多都体现了中国市场数字经济的光明前景。但只有当两家公司都能和腾讯和阿里巴巴一样获得持续丰厚的利润,才会像曾经的BAT一样成长为新的明星企业。";}, 1621686945, 1716155768
Run Time: 0.000855