SHOW FULL COLUMNS FROM `category_college` [ RunTime:0.002177s ]
SELECT `code`,`name`,`slug` FROM `category_college` WHERE `status` = 1 ORDER BY `rank` DESC [ RunTime:0.000560s ]
SHOW FULL COLUMNS FROM `college` [ RunTime:0.002043s ]
SELECT COUNT(*) AS think_count FROM `college` WHERE ( `status` = 1 AND `category` = '51' ) [ RunTime:0.000715s ]
SELECT * FROM `college` WHERE ( `status` = 1 AND `category` = '51' ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000712s ]
SELECT `id`,`title`,`pic1`,`create_time` FROM `college` WHERE ( `category` = '53' AND `status` = 1 AND `pic1` <> '' ) ORDER BY `create_time` DESC LIMIT 4 [ RunTime:0.000745s ]
SELECT `id`,`title`,`pic1`,`create_time` FROM `college` WHERE ( `category` = '51' AND `status` = 1 ) ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000600s ]