SHOW FULL COLUMNS FROM `xl_article` [ RunTime:0.001061s ]
SELECT COUNT(*) AS think_count FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` IN (4,5,23,24,25,26,27,28) AND `status` = 99 [ RunTime:0.000944s ]
SELECT * FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` IN (4,5,23,24,25,26,27,28) AND `status` = 99 ORDER BY `topfeed` DESC,`listorder` DESC,`publishtime` DESC,`xl_article`.`id` DESC LIMIT 0,20 [ RunTime:0.001621s ]