set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000508s ]
SELECT count(*) as c FROM `yl_1_news` WHERE `yl_1_news`.`catid` = 2 ORDER BY NULL [ RunTime:0.001088s ]
SELECT * FROM `yl_1_news` WHERE `yl_1_news`.`catid` = 2 ORDER BY `yl_1_news`.`updatetime` DESC LIMIT 0,10 [ RunTime:0.001019s ]
show COLUMNS FROM yl_1_news_hits [ RunTime:0.001205s ]
SELECT `yl_1_news`.*,`yl_1_news_hits`.`hits`,`yl_1_news_hits`.`day_hits`,`yl_1_news_hits`.`week_hits`,`yl_1_news_hits`.`month_hits`,`yl_1_news_hits`.`year_hits`,`yl_1_news_hits`.`day_time`,`yl_1_news_hits`.`week_time`,`yl_1_news_hits`.`month_time`,`yl_1_news_hits`.`year_time` FROM `yl_1_news` LEFT JOIN `yl_1_news_hits` ON `yl_1_news`.`id`=`yl_1_news_hits`.`id` WHERE `yl_1_news`.`catid` = 2 ORDER BY `yl_1_news_hits`.`hits` DESC LIMIT 9 [ RunTime:0.000956s ]