SHOW FULL COLUMNS FROM `tao_system` [ RunTime:0.001092s ]
SELECT `template` FROM `tao_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000465s ]
SHOW FULL COLUMNS FROM `tao_cate` [ RunTime:0.000903s ]
SELECT * FROM `tao_cate` WHERE `status` = '1' AND `delete_time` = 0 ORDER BY `sort` ASC [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `tao_article` [ RunTime:0.000957s ]
SELECT `id` FROM `tao_article` WHERE `status` = '1' AND `delete_time` = 0 AND `id` = 68 LIMIT 1 [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `tao_comment` [ RunTime:0.000926s ]
SHOW FULL COLUMNS FROM `tao_collection` [ RunTime:0.000743s ]
SHOW FULL COLUMNS FROM `tao_user_see_article_log` [ RunTime:0.000703s ]
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` = 68 ) AND `tao_article`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000814s ]
SELECT `id`,`catename`,`ename` FROM `tao_cate` WHERE ( `delete_time` = 0 AND `id` = 1 ) AND `tao_cate`.`delete_time` = '0' [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `tao_user` [ RunTime:0.001353s ]
SELECT `id`,`name`,`nickname`,`user_img`,`area_id`,`vip` FROM `tao_user` WHERE ( `id` = 17 ) AND `tao_user`.`delete_time` = '0' [ RunTime:0.000445s ]
SELECT `detpl` FROM `tao_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tao_article` SET `pv` = `pv` + 1 WHERE `id` = 68 [ RunTime:0.005384s ]
SELECT `pv` FROM `tao_article` WHERE `id` = 68 LIMIT 1 [ RunTime:0.000442s ]
SELECT COUNT(*) AS think_count FROM `tao_comment` WHERE ( `article_id` = 68 AND `status` = '1' AND `parent_id` = 0 ) AND `tao_comment`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000550s ]
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 1767196800 AND 1798732799 ) AND `tao_article`.`delete_time` = '0' ORDER BY `pv` DESC LIMIT 5 [ RunTime:0.000558s ]
SELECT `id` FROM `tao_article` WHERE `user_id` = 17 [ RunTime:0.000346s ]
SELECT COUNT(`id`) AS think_count FROM `tao_collection` WHERE `article_id` IN (57,58,59,60,61,62,63,64,65,66,67,68,79) LIMIT 1 [ RunTime:0.000471s ]
SHOW FULL COLUMNS FROM `tao_article_zan` [ RunTime:0.000771s ]
SELECT COUNT(`id`) AS think_count FROM `tao_article_zan` WHERE `article_id` IN (57,58,59,60,61,62,63,64,65,66,67,68,79) LIMIT 1 [ RunTime:0.000643s ]
SHOW FULL COLUMNS FROM `tao_news_cate` [ RunTime:0.001015s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000373s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000383s ]
2023-03-05 23:41:58
5035
0
2
0
