SHOW FULL COLUMNS FROM `tao_system` [ RunTime:0.000823s ]
SELECT `template` FROM `tao_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000469s ]
SHOW FULL COLUMNS FROM `tao_cate` [ RunTime:0.000810s ]
SELECT * FROM `tao_cate` WHERE `status` = '1' AND `delete_time` = 0 ORDER BY `sort` ASC [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `tao_article` [ RunTime:0.000640s ]
SELECT `id` FROM `tao_article` WHERE `status` = '1' AND `delete_time` = 0 AND `id` = 70 LIMIT 1 [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `tao_comment` [ RunTime:0.000699s ]
SHOW FULL COLUMNS FROM `tao_collection` [ RunTime:0.000616s ]
SHOW FULL COLUMNS FROM `tao_user_see_article_log` [ RunTime:0.000552s ]
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.000721s ]
SELECT `id`,`catename`,`ename` FROM `tao_cate` WHERE ( `delete_time` = 0 AND `id` = 1 ) AND `tao_cate`.`delete_time` = '0' [ RunTime:0.000505s ]
SHOW FULL COLUMNS FROM `tao_user` [ RunTime:0.000980s ]
SELECT `id`,`name`,`nickname`,`user_img`,`area_id`,`vip` FROM `tao_user` WHERE ( `id` = 11 ) AND `tao_user`.`delete_time` = '0' [ RunTime:0.000429s ]
SELECT `detpl` FROM `tao_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tao_article` SET `pv` = `pv` + 1 WHERE `id` = 70 [ RunTime:0.004934s ]
SELECT `pv` FROM `tao_article` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000415s ]
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.000392s ]
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.000511s ]
SELECT `id` FROM `tao_article` WHERE `user_id` = 11 [ RunTime:0.000276s ]
SELECT COUNT(`id`) AS think_count FROM `tao_collection` WHERE `article_id` IN (69,70,83,84) LIMIT 1 [ RunTime:0.000299s ]
SHOW FULL COLUMNS FROM `tao_article_zan` [ RunTime:0.000548s ]
SELECT COUNT(`id`) AS think_count FROM `tao_article_zan` WHERE `article_id` IN (69,70,83,84) LIMIT 1 [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `tao_news_cate` [ RunTime:0.000831s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000395s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000407s ]
2023-03-06 11:12:06
3581
1
2
0
