SHOW FULL COLUMNS FROM `category_college` [ RunTime:0.002318s ]
SELECT `code`,`name`,`slug` FROM `category_college` WHERE `status` = 1 ORDER BY `rank` DESC [ RunTime:0.000591s ]
SHOW FULL COLUMNS FROM `college` [ RunTime:0.002108s ]
SELECT COUNT(*) AS think_count FROM `college` WHERE ( `status` = 1 AND `category` = '53' ) [ RunTime:0.000881s ]
SELECT * FROM `college` WHERE ( `status` = 1 AND `category` = '53' ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000832s ]
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.000833s ]
SELECT `id`,`title`,`pic1`,`create_time` FROM `college` WHERE ( `category` = '51' AND `status` = 1 ) ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000680s ]