SHOW FULL COLUMNS FROM `xl_article` [ RunTime:0.003172s ]
SELECT COUNT(*) AS think_count FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` = 9 AND `status` = 99 [ RunTime:0.002588s ]
SELECT * FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` = 9 AND `status` = 99 ORDER BY `topfeed` DESC,`listorder` DESC,`publishtime` DESC,`xl_article`.`id` DESC LIMIT 0,20 [ RunTime:0.002924s ]
SELECT * FROM `xl_article` WHERE ( catid in (10,11,27) and status=99 and status = 99 ) ORDER BY `listorder` DESC,`publishtime` DESC,`id` DESC LIMIT 2 [ RunTime:0.002491s ]