SHOW FULL COLUMNS FROM `tao_system` [ RunTime:0.000870s ]
SELECT `template` FROM `tao_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `tao_cate` [ RunTime:0.000825s ]
SELECT * FROM `tao_cate` WHERE `status` = '1' AND `delete_time` = 0 ORDER BY `sort` ASC [ RunTime:0.000475s ]
SHOW FULL COLUMNS FROM `tao_article` [ RunTime:0.000750s ]
SELECT `id` FROM `tao_article` WHERE `status` = '1' AND `delete_time` = 0 AND `id` = 70 LIMIT 1 [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `tao_comment` [ RunTime:0.000599s ]
SHOW FULL COLUMNS FROM `tao_collection` [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `tao_user_see_article_log` [ RunTime:0.000606s ]
SELECT `id`,`title`,`content`,`status`,`cate_id`,`user_id`,`is_top`,`is_hot`,`is_reply`,`pv`,`jie`,`upzip`,`downloads`,`tags`,`description`,`title_color`,`create_time`,(SELECT COUNT(*) AS think_count FROM `tao_comment` `count_table` WHERE ( ( `count_table`.`article_id` =tao_article.id ) ) AND `count_table`.`delete_time` = '0') AS `comments_count`,(SELECT COUNT(*) AS think_count FROM `tao_collection` `count_table` WHERE ( ( `count_table`.`article_id` =tao_article.id ) ) AND `count_table`.`delete_time` = '0') AS `collection_count`,(SELECT COUNT(*) AS think_count FROM `tao_user_see_article_log` `count_table` WHERE ( `count_table`.`article_id` =tao_article.id )) AS `userseearticlelog_count` FROM `tao_article` WHERE ( `status` = '1' AND `id` = 70 ) AND `tao_article`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`catename`,`ename` FROM `tao_cate` WHERE ( `delete_time` = 0 AND `id` = 1 ) AND `tao_cate`.`delete_time` = '0' [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `tao_user` [ RunTime:0.000944s ]
SELECT `id`,`name`,`nickname`,`user_img`,`area_id`,`vip` FROM `tao_user` WHERE ( `id` = 11 ) AND `tao_user`.`delete_time` = '0' [ RunTime:0.000453s ]
SELECT `detpl` FROM `tao_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tao_article` SET `pv` = `pv` + 1 WHERE `id` = 70 [ RunTime:0.004727s ]
SELECT `pv` FROM `tao_article` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000377s ]
SELECT COUNT(*) AS think_count FROM `tao_comment` WHERE ( `article_id` = 70 AND `status` = '1' AND `parent_id` = 0 ) AND `tao_comment`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`title`,`pv`,`cate_id`,(SELECT COUNT(*) AS think_count FROM `tao_comment` `count_table` WHERE ( ( `count_table`.`article_id` =tao_article.id ) ) AND `count_table`.`delete_time` = '0') AS `comments_count` FROM `tao_article` WHERE ( `status` = '1' AND `delete_time` = 0 AND `create_time` BETWEEN 1735660800 AND 1767196799 ) AND `tao_article`.`delete_time` = '0' ORDER BY `pv` DESC LIMIT 5 [ RunTime:0.000532s ]
SELECT `id` FROM `tao_article` WHERE `user_id` = 11 [ RunTime:0.000252s ]
SELECT COUNT(`id`) AS think_count FROM `tao_collection` WHERE `article_id` IN (69,70,83,84) LIMIT 1 [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `tao_article_zan` [ RunTime:0.000597s ]
SELECT COUNT(`id`) AS think_count FROM `tao_article_zan` WHERE `article_id` IN (69,70,83,84) LIMIT 1 [ RunTime:0.000315s ]
SHOW FULL COLUMNS FROM `tao_news_cate` [ RunTime:0.000767s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000382s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000311s ]
2023-03-06 11:12:06
3675
1
2
0
