SHOW FULL COLUMNS FROM `web_content` [ RunTime:0.001295s ]
SHOW FULL COLUMNS FROM `web_content_tag` [ RunTime:0.001085s ]
SELECT * FROM `web_content_tag` WHERE ( `name`='centos' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000262s ]
SHOW COLUMNS FROM web_content [ RunTime:0.001070s ]
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`=22 ) [ RunTime:0.000228s ]
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`=22 ) [ RunTime:0.000196s ]
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`=22 ) ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000270s ]
