SHOW FULL COLUMNS FROM `sxzc_article_cate` [ RunTime:0.002039s ]
SELECT * FROM `sxzc_article_cate` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000453s ]
SELECT * FROM `sxzc_article_cate` WHERE `delete_time` = 0 [ RunTime:0.000576s ]
SHOW FULL COLUMNS FROM `sxzc_article` [ RunTime:0.002268s ]
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` = '42' LIMIT 1 [ RunTime:0.000788s ]
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` = '42' ORDER BY `a`.`id` DESC LIMIT 0,12 [ RunTime:0.001085s ]