SHOW FULL COLUMNS FROM `xl_article` [ RunTime:0.002601s ]
SELECT COUNT(*) AS think_count FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` IN (5,6,20,21,22,23,24,25,26) AND `status` = 99 [ RunTime:0.001958s ]
SELECT * FROM `xl_article` LEFT JOIN `xl_article_data` ON `xl_article_data`.`id`=`xl_article`.`id` WHERE `catid` IN (5,6,20,21,22,23,24,25,26) AND `status` = 99 ORDER BY `topfeed` DESC,`listorder` DESC,`publishtime` DESC,`xl_article`.`id` DESC LIMIT 0,21 [ RunTime:0.003293s ]
SELECT * FROM `xl_article` WHERE ( catid in (5,6,20,21,22,23,24,25,26) and recommend like "%1%" and status=99 and status = 99 ) ORDER BY `listorder` DESC,`publishtime` DESC,`id` DESC LIMIT 4 [ RunTime:0.002141s ]
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.002119s ]
