SHOW FULL COLUMNS FROM `sxzc_article_cate` [ RunTime:0.002129s ]
SELECT * FROM `sxzc_article_cate` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000469s ]
SHOW FULL COLUMNS FROM `sxzc_article` [ RunTime:0.001822s ]
SELECT * FROM `sxzc_article_cate` WHERE `delete_time` = 0 AND `pid` = 27 [ RunTime:0.000458s ]
SELECT * FROM `sxzc_article_cate` WHERE `delete_time` = 0 [ RunTime:0.000347s ]
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` IN ('37','38','80') LIMIT 1 [ RunTime:0.000611s ]
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` IN ('37','38','80') ORDER BY `a`.`id` DESC LIMIT 0,10 [ RunTime:0.000570s ]