SHOW FULL COLUMNS FROM `ais_web_news` [ RunTime:0.000566s ]
SELECT *, DATE_FORMAT(create_time, "%Y-%m-%d") as create_time FROM `ais_web_news` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000308s ]
SELECT COUNT(*) AS think_count FROM `ais_web_news` LIMIT 1 [ RunTime:0.000192s ]
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.000268s ]
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.000313s ]
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.000262s ]
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.000344s ]
SELECT `id`,`title` FROM `ais_web_news` WHERE ( id > 40 ) LIMIT 1 [ RunTime:0.000201s ]
SELECT `id`,`title` FROM `ais_web_news` WHERE ( id < 40 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000200s ]
UPDATE `ais_web_news` SET `views` = `views` + 1 WHERE `id` = 40 [ RunTime:0.004533s ]