set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000186s ]
show COLUMNS FROM xr_1_news_data_0 [ RunTime:0.000786s ]
SELECT count(*) as c FROM `xr_1_news` LEFT JOIN `xr_1_news_data_0` ON `xr_1_news`.`id`=`xr_1_news_data_0`.`id` WHERE `xr_1_news`.`yincang` = 0 AND `xr_1_news`.`catid` = 26 ORDER BY NULL [ RunTime:0.000599s ]
SELECT * FROM `xr_1_news` LEFT JOIN `xr_1_news_data_0` ON `xr_1_news`.`id`=`xr_1_news_data_0`.`id` WHERE `xr_1_news`.`yincang` = 0 AND `xr_1_news`.`catid` = 26 ORDER BY `xr_1_news`.`displayorder` ASC,`xr_1_news_data_0`.`id` DESC LIMIT 8,8 [ RunTime:0.000774s ]