SHOW FULL COLUMNS FROM `category_college` [ RunTime:0.002224s ]
SELECT `code`,`name`,`slug` FROM `category_college` WHERE `status` = 1 ORDER BY `rank` DESC [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `college` [ RunTime:0.002183s ]
SELECT * FROM `college` WHERE ( `id` = 20 AND `status` = 1 ) LIMIT 1 [ RunTime:0.000667s ]
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.000948s ]
SELECT `id`,`title`,`pic1`,`create_time` FROM `college` WHERE ( `category` = '51' AND `status` = 1 ) ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000782s ]
UPDATE `college` SET `views` = 34 WHERE `id` = 20 [ RunTime:0.006676s ]