[ DB ] CONNECT:[ UseTime:0.008875s ] mysql:host=rm-uf65b664in66523x4780.mysql.rds.aliyuncs.com;port=3306;dbname=site_itheat;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `system_node` [ RunTime:0.004126s ]
[ SQL ] SELECT `is_auth`,`is_login` FROM `system_node` WHERE `node` = 'article/tag/index' LIMIT 1 [ RunTime:0.003812s ]
[ SQL ] SELECT `is_auth`,`is_login` FROM `system_node` WHERE `node` = 'article/tag/index' LIMIT 1 [ RunTime:0.003826s ]
[ SQL ] SHOW COLUMNS FROM `article_tag` [ RunTime:0.004861s ]
[ SQL ] SELECT * FROM `article_tag` WHERE `name` = 'AWE2024' AND `is_deleted` = 0 LIMIT 1 [ RunTime:0.003819s ]
[ SQL ] SHOW COLUMNS FROM `article_tag_topic` [ RunTime:0.003981s ]
[ SQL ] SELECT * FROM `article_tag_topic` WHERE `article_tag_id` = 109 AND `is_deleted` = 0 LIMIT 1 [ RunTime:0.003796s ]
[ SQL ] SHOW COLUMNS FROM `article_tag_topic_link` [ RunTime:0.003916s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `article_tag_topic_link` WHERE `article_tag_id` = 109 AND `type` = 'link' AND `is_deleted` = 0 [ RunTime:0.004322s ]
[ SQL ] SELECT * FROM `article_tag_topic_link` WHERE `article_tag_id` = 109 AND `type` = 'link' AND `is_deleted` = 0 ORDER BY `sort` DESC,`updated_at` DESC LIMIT 0,6 [ RunTime:0.003903s ]
[ SQL ] SELECT * FROM `article_tag_topic_link` WHERE `article_tag_id` = 109 AND `type` IN ('slide','main','sub','code') AND `is_deleted` = 0 ORDER BY `sort` DESC,`updated_at` DESC [ RunTime:0.003956s ]
[ SQL ] SELECT * FROM `article_tag` WHERE `relate_article_tag_id` = 109 [ RunTime:0.003799s ]
[ SQL ] SELECT * FROM `article_tag` WHERE `name` = 'AWE2024' [ RunTime:0.003729s ]
[ SQL ] SHOW COLUMNS FROM `article_post` [ RunTime:0.004187s ]
[ SQL ] SHOW COLUMNS FROM `article_post_tag` [ RunTime:0.003935s ]
[ 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` = 109 GROUP BY `article_post_id`) AND `status` = 99 AND `article_category_id` = 13 [ RunTime:0.012677s ]
[ SQL ] SELECT * FROM `article_post` WHERE `article_post_id` IN (SELECT `article_post_id` FROM `article_post_tag` WHERE `article_tag_id` = 109 GROUP BY `article_post_id`) AND `status` = 99 AND `article_category_id` = 13 ORDER BY `published_at` DESC LIMIT 0,10 [ RunTime:0.020502s ]
[ SQL ] SHOW COLUMNS FROM `article_category` [ RunTime:0.004024s ]
[ SQL ] SELECT * FROM `article_category` [ RunTime:0.003873s ]
[ SQL ] SELECT * FROM `article_post` WHERE `article_post_id` IN (SELECT `article_post_id` FROM `article_post_tag` WHERE `article_tag_id` = 109 GROUP BY `article_post_id`) AND `status` = 99 GROUP BY `article_category_id` [ RunTime:0.005393s ]
[ SQL ] SELECT * FROM `article_category` WHERE `article_category_id` IN (5,9,13) AND `hide` = 0 [ RunTime:0.003878s ]
[ SQL ] SHOW COLUMNS FROM `article_view` [ RunTime:0.004007s ]
[ 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 '2024-03-14 00:00:00' AND '2024-03-31 00:00:00' AND `article_post_id` IN (SELECT `article_post_id` FROM `article_post_tag` WHERE `article_tag_id` = 109)) AND `time` BETWEEN '2024-03-14 00:00:00' AND '2024-03-31 00:00:00' GROUP BY `article_post_id` ORDER BY `_view_count` DESC,`article_post_id` DESC LIMIT 0,10 [ RunTime:0.006192s ]
[ SQL ] SELECT * FROM `article_category` WHERE `cname` = 'zhuanfang' AND `hide` = 0 ORDER BY `sort` ASC [ RunTime:0.003855s ]
[ SQL ] SELECT * FROM `article_post` WHERE `article_category_type` = 9 AND `status` = 99 AND `published_at` <= '2025-07-17 01:01:59' ORDER BY `published_at` DESC LIMIT 0,2 [ RunTime:0.006534s ]