SHOW FULL COLUMNS FROM `syzjjt_article_cate` [ RunTime:0.001334s ]
SELECT * FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 0 ORDER BY `sort` ASC [ RunTime:0.000621s ]
SELECT `id` FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 3 [ RunTime:0.000361s ]
SELECT * FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 3 ORDER BY `sort` ASC [ RunTime:0.000341s ]
SELECT `id` FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 10 [ RunTime:0.000274s ]
SELECT * FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 10 ORDER BY `sort` ASC [ RunTime:0.000324s ]
SELECT `id` FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 4 [ RunTime:0.000260s ]
SELECT * FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 4 ORDER BY `sort` ASC [ RunTime:0.000403s ]
SELECT `id` FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 8 [ RunTime:0.000404s ]
SELECT * FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 8 ORDER BY `sort` ASC [ RunTime:0.000357s ]
SELECT `id` FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 7 [ RunTime:0.000316s ]
SELECT * FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 7 ORDER BY `sort` ASC [ RunTime:0.000330s ]
SELECT `id` FROM `syzjjt_article_cate` WHERE `delete_time` = 0 AND `pid` = 10 [ RunTime:0.000434s ]
SELECT `title` FROM `syzjjt_article_cate` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000373s ]
SHOW FULL COLUMNS FROM `syzjjt_article` [ RunTime:0.000840s ]
SELECT COUNT(*) AS think_count FROM `syzjjt_article` `a` LEFT JOIN `syzjjt_article_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`cate_id` = '10' AND `a`.`delete_time` = '0' AND `a`.`status` = '1' LIMIT 1 [ RunTime:0.000486s ]
SELECT `a`.*,c.id as cate_id,c.title as cate_title FROM `syzjjt_article` `a` LEFT JOIN `syzjjt_article_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`cate_id` = '10' AND `a`.`delete_time` = '0' AND `a`.`status` = '1' ORDER BY `a`.`id` DESC,`a`.`create_time` DESC LIMIT 0,30 [ RunTime:0.000496s ]
SELECT `id`,`title`,`pid` FROM `syzjjt_article_cate` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000301s ]
SELECT `title`,`keywords`,`desc` FROM `syzjjt_article_cate` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000275s ]
