SHOW FULL COLUMNS FROM `sxzc_article_cate` [ RunTime:0.002588s ]
SELECT * FROM `sxzc_article_cate` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000539s ]
SELECT * FROM `sxzc_article_cate` WHERE `delete_time` = 0 [ RunTime:0.000426s ]
SHOW FULL COLUMNS FROM `sxzc_article` [ RunTime:0.002282s ]
SELECT COUNT(*) AS think_count FROM `sxzc_article` `a` LEFT JOIN `sxzc_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' AND `a`.`cate_id` = '30' LIMIT 1 [ RunTime:0.000785s ]
SELECT `a`.*,`f`.`filepath` FROM `sxzc_article` `a` LEFT JOIN `sxzc_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' AND `a`.`cate_id` = '30' ORDER BY `a`.`id` DESC LIMIT 0,12 [ RunTime:0.001065s ]