SHOW FULL COLUMNS FROM `web_content` [ RunTime:0.001450s ]
SHOW FULL COLUMNS FROM `web_content_tag` [ RunTime:0.001195s ]
SELECT * FROM `web_content_tag` WHERE ( `name`='linux' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000723s ]
SELECT * FROM `web_content` WHERE ( 1=1 ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000544s ]
SELECT * FROM `web_content_tag` WHERE ( 1=1 ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:0.000727s ]
SHOW COLUMNS FROM web_content [ RunTime:0.001412s ]
SELECT COUNT(*) AS think_count FROM `web_content` `content` LEFT JOIN `web_content_id` `content_id` ON `content_id`.`contentid`=`content`.`id` WHERE ( `content_id`.`tagid`=2 ) [ RunTime:0.000746s ]
SELECT COUNT(*) AS think_count FROM `web_content` `content` LEFT JOIN `web_content_id` `content_id` ON `content_id`.`contentid`=`content`.`id` WHERE ( `content_id`.`tagid`=2 ) [ RunTime:0.000713s ]
SELECT `content`.`id`,`content`.`catid`,`content`.`title`,`content`.`keyword`,`content`.`desc`,`content`.`thumb`,`content`.`hits`,`content`.`state`,`content`.`update_time`,`content`.`create_time`,`content`.`sort`,`content_id`.`contentid` FROM `web_content` `content` LEFT JOIN `web_content_id` `content_id` ON `content_id`.`contentid`=`content`.`id` WHERE ( `content_id`.`tagid`=2 ) ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000730s ]