[ DB ] CONNECT:[ UseTime:0.010510s ] mysql:host=rm-uf65b664in66523x4780.mysql.rds.aliyuncs.com;port=3306;dbname=site_itheat;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `system_node` [ RunTime:0.003021s ]
[ SQL ] SELECT `is_auth`,`is_login` FROM `system_node` WHERE `node` = 'article/tag/index' LIMIT 1 [ RunTime:0.002779s ]
[ SQL ] SELECT `is_auth`,`is_login` FROM `system_node` WHERE `node` = 'article/tag/index' LIMIT 1 [ RunTime:0.002669s ]
[ SQL ] SHOW COLUMNS FROM `article_tag` [ RunTime:0.002963s ]
[ SQL ] SELECT * FROM `article_tag` WHERE `name` = '2020chinajoy' AND `is_deleted` = 0 LIMIT 1 [ RunTime:0.002947s ]
[ SQL ] SHOW COLUMNS FROM `article_tag_topic` [ RunTime:0.002874s ]
[ SQL ] SELECT * FROM `article_tag_topic` WHERE `article_tag_id` = 22 AND `is_deleted` = 0 LIMIT 1 [ RunTime:0.002702s ]
[ SQL ] SHOW COLUMNS FROM `article_tag_topic_link` [ RunTime:0.002767s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `article_tag_topic_link` WHERE `article_tag_id` = 22 AND `type` = 'link' AND `is_deleted` = 0 [ RunTime:0.002678s ]
[ SQL ] SELECT * FROM `article_tag_topic_link` WHERE `article_tag_id` = 22 AND `type` IN ('slide','main','sub','code') AND `is_deleted` = 0 ORDER BY `sort` DESC,`updated_at` DESC [ RunTime:0.002777s ]
[ SQL ] SELECT * FROM `article_tag` WHERE `relate_article_tag_id` = 22 [ RunTime:0.002740s ]
[ SQL ] SELECT * FROM `article_tag` WHERE `name` = '2020chinajoy' [ RunTime:0.002713s ]
[ SQL ] SHOW COLUMNS FROM `article_post` [ RunTime:0.003001s ]
[ SQL ] SHOW COLUMNS FROM `article_post_tag` [ RunTime:0.002824s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `article_post` WHERE `article_post_id` IN (SELECT `article_post_id` FROM `article_post_tag` WHERE `article_tag_id` = 22 GROUP BY `article_post_id`) AND `status` = 99 [ RunTime:0.007836s ]
[ SQL ] SELECT * FROM `article_post` WHERE `article_post_id` IN (SELECT `article_post_id` FROM `article_post_tag` WHERE `article_tag_id` = 22 GROUP BY `article_post_id`) AND `status` = 99 ORDER BY `published_at` DESC LIMIT 30,10 [ RunTime:0.005985s ]
[ SQL ] SHOW COLUMNS FROM `article_category` [ RunTime:0.003045s ]
[ SQL ] SELECT * FROM `article_category` [ RunTime:0.002773s ]
[ SQL ] SELECT * FROM `article_post` WHERE `article_post_id` IN (SELECT `article_post_id` FROM `article_post_tag` WHERE `article_tag_id` = 22 GROUP BY `article_post_id`) AND `status` = 99 GROUP BY `article_category_id` [ RunTime:0.005292s ]
[ SQL ] SELECT * FROM `article_category` WHERE `article_category_id` IN (5,9,13) AND `hide` = 0 [ RunTime:0.002817s ]
[ SQL ] SHOW COLUMNS FROM `article_view` [ RunTime:0.003006s ]
[ SQL ] SELECT article_post_id, COUNT(article_post_id) as `_view_count` FROM `article_view` WHERE `article_post_id` IN (SELECT `article_post_id` FROM `article_post` WHERE `status` = 99 AND `published_at` BETWEEN '2025-01-17 17:26:56' AND '2025-07-16 17:26:56' AND `article_post_id` IN (SELECT `article_post_id` FROM `article_post_tag` WHERE `article_tag_id` = 22)) AND `time` BETWEEN '2025-01-17 17:26:56' AND '2025-07-16 17:26:56' GROUP BY `article_post_id` ORDER BY `_view_count` DESC,`article_post_id` DESC LIMIT 0,10 [ RunTime:0.003435s ]
[ SQL ] SELECT * FROM `article_post` WHERE `article_category_type` = 9 AND `status` = 99 AND `published_at` <= '2025-07-16 17:26:56' ORDER BY `published_at` DESC LIMIT 0,2 [ RunTime:0.006452s ]
ChinaJoy 2020丨雷柏携旗下新女性时尚品牌ralemo外设惊艳ChinaJoy雷柏给人的最大印象便是极具性价比的产品以及足够优秀的外设，让消费者花费平民的价格就可以享受土豪般的性能，而在于7月31日开幕的ChinaJoy期间，雷柏也将它的产品在ITheat热点科技展台进行展示，为消费者重新定义了性价比，成为全场的焦点。
小小的世界 | 2020-07-314.5万655快讯
ChinaJoy 2020丨热点科技携拯救者电竞手机，展现次世代手游体验7月31日，ChinaJoy 2020如约而至，刚刚发布的联想拯救者电竞手机Pro也来到展会现场，现身热点科技展台（E6馆03-1），为现场观众带来与众不同的手游体验。
ChinaJoy 2020丨realme首次参展CJ 潮流舞台引众人围观 7月31日，第18届ChinaJoy正式开幕，作为全球数码互动娱乐领域具有影响力的盛会，今年仍然是人山人海。众多手机品牌也都参与本场盛会，其中就包括刚刚海归一年多的realme品牌。
荡荡 | 2020-07-313.9万624快讯
ChinaJoy 2020丨OPPO Ace 2定制版亮相，超级闪充大放异彩随着手游市场的进一步发展，越来越多的手机厂商也参与到ChinaJoy当中。今年，OPPO以高通合作伙伴的身份亮相ChinaJoy，演示了新一代的Super Vooc闪充技术，并展示了OPPO Ace 2 EVA定制版、50W 超闪饼干充电器等产品。
二楠 | 2020-07-31
沪公网安备 31010702005758号
