SHOW FULL COLUMNS FROM `asc_config` [ RunTime:0.012034s ]
SELECT * FROM `asc_config` WHERE `site_code` = 'asc' AND `lang` = 'zh-TW' [ RunTime:0.003206s ]
SHOW FULL COLUMNS FROM `asc_news_category` [ RunTime:0.002458s ]
SELECT * FROM `asc_news_category` WHERE `status` = 1 AND `site_code` = 'asc' AND `lang` = 'zh-TW' ORDER BY `sort_order` ASC [ RunTime:0.005178s ]
SHOW FULL COLUMNS FROM `asc_news` [ RunTime:0.002050s ]
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.002647s ]
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.000363s ]
