SHOW FULL COLUMNS FROM `tao_system` [ RunTime:0.001412s ]
SELECT `template` FROM `tao_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `tao_cate` [ RunTime:0.000932s ]
SELECT * FROM `tao_cate` WHERE `status` = '1' AND `delete_time` = 0 ORDER BY `sort` ASC [ RunTime:0.000630s ]
SHOW FULL COLUMNS FROM `tao_article` [ RunTime:0.001047s ]
SELECT `id` FROM `tao_article` WHERE `status` = '1' AND `delete_time` = 0 AND `id` = 68 LIMIT 1 [ RunTime:0.000542s ]
SHOW FULL COLUMNS FROM `tao_comment` [ RunTime:0.001156s ]
SHOW FULL COLUMNS FROM `tao_collection` [ RunTime:0.000875s ]
SHOW FULL COLUMNS FROM `tao_user_see_article_log` [ RunTime:0.000962s ]
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.001026s ]
SELECT `id`,`catename`,`ename` FROM `tao_cate` WHERE ( `delete_time` = 0 AND `id` = 1 ) AND `tao_cate`.`delete_time` = '0' [ RunTime:0.000649s ]
SHOW FULL COLUMNS FROM `tao_user` [ RunTime:0.001479s ]
SELECT `id`,`name`,`nickname`,`user_img`,`area_id`,`vip` FROM `tao_user` WHERE ( `id` = 17 ) AND `tao_user`.`delete_time` = '0' [ RunTime:0.000577s ]
SELECT `detpl` FROM `tao_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000786s ]
UPDATE `tao_article` SET `pv` = `pv` + 1 WHERE `id` = 68 [ RunTime:0.005097s ]
SELECT `pv` FROM `tao_article` WHERE `id` = 68 LIMIT 1 [ RunTime:0.000574s ]
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.000589s ]
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.000960s ]
SELECT `id` FROM `tao_article` WHERE `user_id` = 17 [ RunTime:0.000836s ]
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.000565s ]
SHOW FULL COLUMNS FROM `tao_article_zan` [ RunTime:0.000848s ]
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.000630s ]
SHOW FULL COLUMNS FROM `tao_news_cate` [ RunTime:0.000965s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000556s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000537s ]
2023-03-05 23:41:58
5332
0
2
0
