SHOW FULL COLUMNS FROM `xl_article` [ RunTime:0.000993s ]
SELECT COUNT(*) AS think_count FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` = 40 AND `status` = 99 [ RunTime:0.000506s ]
SELECT * FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` = 40 AND `status` = 99 ORDER BY `topfeed` DESC,`listorder` DESC,`publishtime` DESC,`xl_article`.`id` DESC LIMIT 0,20 [ RunTime:0.000533s ]
SELECT * FROM `xl_article` WHERE ( catid =40 and recommend like "%2%" and status=99 and status = 99 ) ORDER BY `listorder` DESC,`publishtime` DESC,`id` DESC LIMIT 10 [ RunTime:0.000702s ]
