SHOW FULL COLUMNS FROM `category_college` [ RunTime:0.002161s ]
SELECT `code`,`name`,`slug` FROM `category_college` WHERE `status` = 1 ORDER BY `rank` DESC [ RunTime:0.000702s ]
SHOW FULL COLUMNS FROM `college` [ RunTime:0.002089s ]
SELECT COUNT(*) AS think_count FROM `college` WHERE ( `status` = 1 AND `category` = '52' ) [ RunTime:0.000929s ]
SELECT * FROM `college` WHERE ( `status` = 1 AND `category` = '52' ) ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000841s ]
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.000787s ]
SELECT `id`,`title`,`pic1`,`create_time` FROM `college` WHERE ( `category` = '51' AND `status` = 1 ) ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000646s ]
