SHOW FULL COLUMNS FROM `tao_system` [ RunTime:0.000730s ]
SELECT `template` FROM `tao_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `tao_cate` [ RunTime:0.000780s ]
SELECT * FROM `tao_cate` WHERE `status` = '1' AND `delete_time` = 0 ORDER BY `sort` ASC [ RunTime:0.000393s ]
SHOW FULL COLUMNS FROM `tao_article` [ RunTime:0.000547s ]
SELECT `id` FROM `tao_article` WHERE `status` = '1' AND `delete_time` = 0 AND `id` = 70 LIMIT 1 [ RunTime:0.000346s ]
SELECT `detpl` FROM `tao_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tao_article` SET `pv` = `pv` + 1 WHERE `id` = 70 [ RunTime:0.004887s ]
SELECT `pv` FROM `tao_article` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `tao_comment` [ RunTime:0.000703s ]
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.000431s ]
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.000480s ]
SHOW FULL COLUMNS FROM `tao_news_cate` [ RunTime:0.000803s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000436s ]
SELECT `id`,`cate_name` FROM `tao_news_cate` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000309s ]
2023-03-06 11:12:06
5309
1
2
0
