SHOW FULL COLUMNS FROM `ais_web_news` [ RunTime:0.000408s ]
SELECT *, DATE_FORMAT(create_time, "%Y-%m-%d") as create_time FROM `ais_web_news` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000244s ]
SELECT COUNT(*) AS think_count FROM `ais_web_news` LIMIT 1 [ RunTime:0.000177s ]
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.000276s ]
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.000298s ]
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.000230s ]
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.000209s ]
SELECT `id`,`title` FROM `ais_web_news` WHERE ( id > 29 ) LIMIT 1 [ RunTime:0.000193s ]
SELECT `id`,`title` FROM `ais_web_news` WHERE ( id < 29 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000191s ]
UPDATE `ais_web_news` SET `views` = `views` + 1 WHERE `id` = 29 [ RunTime:0.003234s ]