SHOW FULL COLUMNS FROM `menu` [ RunTime:0.001847s ]
SELECT * FROM `menu` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000969s ]
SELECT * FROM `menu` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000864s ]
SHOW FULL COLUMNS FROM `news_category` [ RunTime:0.001574s ]
SELECT * FROM `news_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000706s ]
SELECT `c`.*,COUNT(n.id) as news_count FROM `news_category` `c` LEFT JOIN `news` `n` ON `c`.`id`=n.category_id AND n.status = 1 WHERE `c`.`status` = '1' GROUP BY `c`.`id` ORDER BY `c`.`sort` ASC [ RunTime:0.001287s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.001670s ]
SELECT COUNT(*) AS think_count FROM `news` `n` INNER JOIN `news_category` `c` ON `n`.`category_id`=`c`.`id` WHERE `n`.`status` = '1' AND `n`.`category_id` = '2' LIMIT 1 [ RunTime:0.000955s ]
SELECT `n`.*,c.name as category_name FROM `news` `n` INNER JOIN `news_category` `c` ON `n`.`category_id`=`c`.`id` WHERE `n`.`status` = '1' AND `n`.`category_id` = '2' ORDER BY `n`.`is_top` DESC,`n`.`create_time` DESC LIMIT 0,10 [ RunTime:0.001171s ]
SELECT * FROM `news` WHERE `status` = 1 ORDER BY `views` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.000927s ]
