SHOW FULL COLUMNS FROM `cms_site_module` [ RunTime:0.001081s ]
SELECT `a`.`id`,`a`.`name`,`a`.`description`,`a`.`module_img`,`a`.`module_emoji`,`a`.`module_key`,`a`.`tag_id`,`a`.`cat_id`,`a`.`pc_num`,`a`.`mobile_num` FROM `cms_site_module` `a` LEFT JOIN `cms_site_page` `b` ON `a`.`page_id`=`b`.`id` WHERE `a`.`site_id` = '1972' AND `a`.`status` = '1' AND `b`.`page_uid` = 'category' ORDER BY `a`.`sort` DESC [ RunTime:0.000317s ]
SHOW FULL COLUMNS FROM `cms_site_news` [ RunTime:0.000730s ]
SELECT `sa`.`id`,`sa`.`news_id`,`sa`.`top_flag`,`sa`.`hot_flag`,`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`,`a`.`publish_time`,`a`.`create_time`,`a`.`update_time` FROM `cms_site_news` `sa` INNER JOIN `cms_news` `a` ON `sa`.`news_id`=`a`.`id` INNER JOIN `cms_categories` `c` ON `a`.`cat_id`=`c`.`id` WHERE `sa`.`site_id` = '1972' AND `sa`.`cat_module_id` = '51462' AND `a`.`status` = '1' AND `sa`.`status` = '1' ORDER BY `a`.`update_time` DESC LIMIT 9 [ RunTime:0.000476s ]
SHOW FULL COLUMNS FROM `cms_site_category` [ RunTime:0.000776s ]
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.000217s ]
SELECT `seo_title`,`seo_keywords`,`seo_description`,`page_hero`,`page_hero_bg` FROM `cms_site_category` WHERE `cat_id` = '2909' AND `site_id` = '1972' LIMIT 1 [ RunTime:0.000195s ]
SHOW FULL COLUMNS FROM `cms_categories` [ RunTime:0.000741s ]
SELECT `id` FROM `cms_categories` WHERE `pid` = '2909' [ RunTime:0.000195s ]
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` = '2909' [ RunTime:0.000352s ]
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` = '2909' GROUP BY `a`.`id` ORDER BY `sa`.`create_time` DESC LIMIT 0,20 [ RunTime:0.000440s ]
