SHOW FULL COLUMNS FROM `sxzc_article_cate` [ RunTime:0.002505s ]
SELECT * FROM `sxzc_article_cate` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000648s ]
SELECT * FROM `sxzc_article_cate` WHERE `delete_time` = 0 [ RunTime:0.000600s ]
SHOW FULL COLUMNS FROM `sxzc_article` [ RunTime:0.002459s ]
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` = '40' LIMIT 1 [ RunTime:0.000655s ]
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` = '40' ORDER BY `a`.`id` DESC LIMIT 0,12 [ RunTime:0.001149s ]