SHOW FULL COLUMNS FROM `ais_web_news` [ RunTime:0.000499s ]
SELECT *, DATE_FORMAT(create_time, "%Y-%m-%d") as create_time FROM `ais_web_news` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000272s ]
SELECT COUNT(*) AS think_count FROM `ais_web_news` LIMIT 1 [ RunTime:0.000190s ]
SELECT id, title, img_url, `desc`, DATE_FORMAT(create_time, "%Y-%m-%d") as create_time FROM `ais_web_news` ORDER BY `sort`,`id` DESC LIMIT 0,13 [ RunTime:0.000262s ]
SELECT id, title, img_url, views, DATE_FORMAT(create_time, "%Y-%m-%d") as create_time FROM `ais_web_news` ORDER BY `views` DESC,`create_time` DESC LIMIT 10 [ RunTime:0.000270s ]
SELECT id, title, img_url, views, DATE_FORMAT(create_time, "%Y-%m-%d") as create_time FROM `ais_web_news` ORDER BY `sort`,`create_time` DESC LIMIT 6 [ RunTime:0.000206s ]
SELECT id, title, img_url, views, DATE_FORMAT(create_time, "%Y-%m-%d") as create_time FROM `ais_web_news` ORDER BY `create_time` DESC,`id` DESC LIMIT 6 [ RunTime:0.000197s ]
SELECT `id`,`title` FROM `ais_web_news` WHERE ( id > 12 ) LIMIT 1 [ RunTime:0.000170s ]
SELECT `id`,`title` FROM `ais_web_news` WHERE ( id < 12 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000252s ]
UPDATE `ais_web_news` SET `views` = `views` + 1 WHERE `id` = 12 [ RunTime:0.002980s ]