SHOW FULL COLUMNS FROM `cms_site_category` [ RunTime:0.000839s ]
SELECT `seo_title`,`seo_keywords`,`seo_description`,`page_hero`,`page_hero_bg` FROM `cms_site_category` WHERE `name` = 'category' AND `site_id` = '1972' LIMIT 1 [ RunTime:0.000215s ]
SELECT `seo_title`,`seo_keywords`,`seo_description`,`page_hero`,`page_hero_bg` FROM `cms_site_category` WHERE `cat_id` = '2908' AND `site_id` = '1972' LIMIT 1 [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `cms_site_news` [ RunTime:0.000753s ]
SHOW FULL COLUMNS FROM `cms_categories` [ RunTime:0.000744s ]
SELECT `id` FROM `cms_categories` WHERE `pid` = '2908' [ RunTime:0.000175s ]
SELECT COUNT(DISTINCT `a`.`id`) AS think_count FROM `cms_site_news` `sa` INNER JOIN `cms_news` `a` ON `sa`.`news_id`=`a`.`id` WHERE `sa`.`site_id` = '1972' AND `a`.`status` = '1' AND `sa`.`status` = '1' AND `a`.`cat_id` = '2908' [ RunTime:0.000368s ]
SELECT `sa`.`id`,`sa`.`news_id`,`c`.`cat_name`,`a`.`cat_id`,`a`.`title`,`a`.`summary`,`a`.`thumb_small`,`a`.`thumb_middle`,`a`.`thumb_big`,`a`.`author`,`a`.`view_count`,`click_count`,`share_count`,`sa`.`create_time`,`sa`.`update_time` FROM `cms_site_news` `sa` INNER JOIN `cms_news` `a` ON `sa`.`news_id`=`a`.`id` LEFT JOIN `cms_categories` `c` ON `a`.`cat_id`=`c`.`id` WHERE `sa`.`site_id` = '1972' AND `a`.`status` = '1' AND `sa`.`status` = '1' AND `a`.`cat_id` = '2908' GROUP BY `a`.`id` ORDER BY `sa`.`create_time` DESC LIMIT 0,20 [ RunTime:0.000449s ]
