SHOW FULL COLUMNS FROM `asc_config` [ RunTime:0.019858s ]
SELECT * FROM `asc_config` WHERE `site_code` = 'asc' AND `lang` = 'zh-TW' [ RunTime:0.007155s ]
SHOW FULL COLUMNS FROM `asc_news_category` [ RunTime:0.003629s ]
SELECT * FROM `asc_news_category` WHERE `status` = 1 AND `site_code` = 'asc' AND `lang` = 'zh-TW' ORDER BY `sort_order` ASC [ RunTime:0.005735s ]
SHOW FULL COLUMNS FROM `asc_news` [ RunTime:0.001356s ]
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' ) [ RunTime:0.004948s ]
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' ) ORDER BY `is_top` DESC,`publish_time` DESC LIMIT 0,10 [ RunTime:0.000406s ]
