SHOW FULL COLUMNS FROM `cms_site_page` [ RunTime:0.001040s ]
SELECT `sp`.*,`st`.`tp_uid`,`st`.`hot_flag`,`st`.`new_flag`,`st`.`popular_flag` FROM `cms_site_page` `sp` LEFT JOIN `cms_site_tp` `st` ON `sp`.`tp_id`=`st`.`id` WHERE `sp`.`site_id` = '1972' AND `sp`.`page_uid` = 'category' LIMIT 1 [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `cms_site_module` [ RunTime:0.000813s ]
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.000297s ]
SHOW FULL COLUMNS FROM `cms_site_category` [ RunTime:0.000806s ]
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.000227s ]
SHOW FULL COLUMNS FROM `cms_categories` [ RunTime:0.000724s ]
SELECT `id`,`cat_name` FROM `cms_categories` WHERE `id` = '2907' LIMIT 1 [ RunTime:0.000163s ]
SELECT `seo_title`,`seo_keywords`,`seo_description`,`page_hero`,`page_hero_bg` FROM `cms_site_category` WHERE `cat_id` = '2907' AND `site_id` = '1972' LIMIT 1 [ RunTime:0.000187s ]
SHOW FULL COLUMNS FROM `cms_site_menu` [ RunTime:0.000755s ]
SELECT * FROM `cms_site_menu` WHERE `site_id` = 1972 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `cms_site_news` [ RunTime:0.000711s ]
SELECT `id` FROM `cms_categories` WHERE `pid` = '2907' [ RunTime:0.000213s ]
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` = '2907' [ RunTime:0.000622s ]
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` = '2907' GROUP BY `a`.`id` ORDER BY `sa`.`create_time` DESC LIMIT 0,20 [ RunTime:0.000832s ]
