SHOW FULL COLUMNS FROM `web_content` [ RunTime:0.001312s ]
SHOW FULL COLUMNS FROM `web_content_tag` [ RunTime:0.001034s ]
SELECT * FROM `web_content_tag` WHERE ( `name`='tp5' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000288s ]
SELECT * FROM `web_content` WHERE ( 1=1 ) ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000245s ]
SELECT * FROM `web_content_tag` WHERE ( 1=1 ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:0.000209s ]
SHOW COLUMNS FROM web_content [ RunTime:0.001036s ]
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`=18 ) [ RunTime:0.000219s ]
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`=18 ) [ RunTime:0.000183s ]
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`=18 ) ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000233s ]