SHOW FULL COLUMNS FROM `xl_article` [ RunTime:0.001294s ]
SELECT COUNT(*) AS think_count FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` IN (6,7,13,14,29,30,31,32,33,34,35,36,37,38,39) AND `status` = 99 [ RunTime:0.001003s ]
SELECT * FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` IN (6,7,13,14,29,30,31,32,33,34,35,36,37,38,39) AND `status` = 99 ORDER BY `topfeed` DESC,`listorder` DESC,`publishtime` DESC,`xl_article`.`id` DESC LIMIT 0,20 [ RunTime:0.003795s ]