SHOW FULL COLUMNS FROM `idc_kefu_category` [ RunTime:0.003478s ]
SELECT `C`.`id`,`C`.`name`,`C`.`description`,`C`.`icon` FROM `idc_kefu_category` `C` WHERE ( `status` = '1' ) AND `C`.`delete_time` IS NULL ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001094s ]
SHOW FULL COLUMNS FROM `idc_news_category` [ RunTime:0.003336s ]
SELECT * FROM `idc_news_category` WHERE `link_name` = 'industry' AND `status` = 1 LIMIT 1 [ RunTime:0.001243s ]
SHOW FULL COLUMNS FROM `idc_news` [ RunTime:0.003513s ]
SELECT COUNT(*) AS think_count FROM `idc_news` `n` LEFT JOIN `idc_news_category` `c` ON `n`.`category_id`=`c`.`id` WHERE `n`.`status` = '1' AND `n`.`category_id` = '2' [ RunTime:0.001199s ]
SELECT `N`.*,N.id as id,C.name as category_name,C.link_name as category_link FROM `idc_news` `N` LEFT JOIN `idc_news_category` `C` ON `N`.`category_id`=`C`.`id` WHERE ( `N`.`category_id` = '2' AND `N`.`status` = '1' ) ORDER BY `N`.`id` DESC LIMIT 8 [ RunTime:0.001206s ]
SELECT `N`.*,N.id as id,C.name as category_name FROM `idc_news` `N` LEFT JOIN `idc_news_category` `C` ON `N`.`category_id`=`C`.`id` ORDER BY `N`.`views` DESC LIMIT 8 [ RunTime:0.001107s ]
SELECT * FROM `idc_news_category` WHERE `status` = 1 [ RunTime:0.001123s ]
SELECT COUNT(*) AS think_count FROM `idc_news` WHERE `category_id` = 2 AND `status` = 1 [ RunTime:0.001098s ]
