SHOW FULL COLUMNS FROM `asc_config` [ RunTime:0.043656s ]
SELECT * FROM `asc_config` WHERE `site_code` = 'asc' AND `lang` = 'zh-TW' [ RunTime:0.006118s ]
SHOW FULL COLUMNS FROM `asc_news_category` [ RunTime:0.006854s ]
SELECT * FROM `asc_news_category` WHERE `status` = 1 AND `site_code` = 'asc' AND `lang` = 'zh-TW' ORDER BY `sort_order` ASC [ RunTime:0.005474s ]
SELECT * FROM `asc_news_category` WHERE `id` = 2 AND `status` = 1 AND `site_code` = 'asc' AND `lang` = 'zh-TW' LIMIT 1 [ RunTime:0.000847s ]
SHOW FULL COLUMNS FROM `asc_news` [ RunTime:0.003967s ]
SELECT COUNT(*) AS think_count FROM `asc_news` `n` INNER JOIN `asc_news_category` `nc` ON `n`.`category_id`=`nc`.`id` WHERE ( `n`.`delete_time` IS NULL AND `n`.`status` = '1' AND `n`.`site_code` = 'asc' AND `n`.`lang` = 'zh-TW' AND `n`.`category_id` = '2' ) [ RunTime:0.005355s ]
SELECT `n`.*,nc.name as cat_name FROM `asc_news` `n` INNER JOIN `asc_news_category` `nc` ON `n`.`category_id`=`nc`.`id` WHERE ( `n`.`delete_time` IS NULL AND `n`.`status` = '1' AND `n`.`site_code` = 'asc' AND `n`.`lang` = 'zh-TW' AND `n`.`category_id` = '2' ) ORDER BY `is_top` DESC,`publish_time` DESC LIMIT 0,10 [ RunTime:0.001946s ]
