SHOW FULL COLUMNS FROM `puku` [ RunTime:0.001637s ]
SELECT `p`.`sitekeywords`,`p`.`seocontent`,`p`.`webid`,`p`.`bpm`,`p`.`beat`,`p`.`m3u8`,`p`.`catid`,`p`.`hexian`,`p`.`capo`,`p`.`yuandiao`,`p`.`linkfile`,`p`.`tips`,`p`.`preview`,`p`.`num`,`p`.`type`,`p`.`id`,`p`.`pics`,`p`.`readpoint`,`p`.`userid`,`p`.`title`,`p`.`status`,`p`.`thumb`,`p`.`keywords`,`p`.`description`,`p`.`content`,`p`.`vurl`,`p`.`hits`,`p`.`createtime`,`p`.`sname`,`p`.`singer`,`p`.`jiezouxing`,`p`.`xuandiao`,`p`.`author`,`p`.`hdpic`,`p`.`version`,`p`.`sales`,`p`.`set`,p.id as id,`c`.`catname`,c.id as cid FROM `puku` `p` INNER JOIN `category` `c` ON `c`.`id`=`p`.`catid` WHERE `p`.`id` = '89214' LIMIT 1 [ RunTime:0.000482s ]
SHOW FULL COLUMNS FROM `shoucang` [ RunTime:0.000999s ]
SELECT COUNT(*) AS think_count FROM `shoucang` WHERE `uid` = 223459 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `user_zhuanlan` [ RunTime:0.000926s ]
SELECT * FROM `user_zhuanlan` WHERE `uid` = 223459 [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `category` [ RunTime:0.001270s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `user_subscribe` [ RunTime:0.000900s ]
SELECT * FROM `user_subscribe` WHERE `authorid` = 223459 [ RunTime:0.000280s ]
UPDATE `puku` SET `hits` = `hits` + 1 WHERE `id` = 89214 [ RunTime:0.005325s ]
SELECT * FROM `puku` WHERE `userid` = 223459 AND `status` = 1 AND `open` = 0 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001031s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000279s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000300s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000255s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000324s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000294s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000273s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000259s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000259s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000289s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000272s ]
SHOW FULL COLUMNS FROM `comments` [ RunTime:0.001035s ]
SELECT COUNT(*) AS think_count FROM `comments` WHERE `aid` = 89214 [ RunTime:0.000283s ]
SELECT `p`.*,`u`.`id`,`u`.`teacher`,`u`.`avatar`,`u`.`username`,`u`.`level_id`,u.id as userid,p.title_style as listlink,p.id as id FROM `puku` `p` INNER JOIN `users` `u` ON `p`.`userid`=`u`.`id` WHERE `p`.`catid` = '5' AND `p`.`id` <> '89214' AND `p`.`status` = '1' AND (`p`.`singer` LIKE 'Green Day') ORDER BY `p`.`id` DESC LIMIT 15 [ RunTime:0.001103s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000298s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000263s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000277s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000275s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000250s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `users` [ RunTime:0.001655s ]
SELECT * FROM `users` WHERE `id` = 209133 LIMIT 1 [ RunTime:0.000480s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000283s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000253s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000237s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000238s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000252s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000245s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000255s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000266s ]
SELECT `catname` FROM `category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000276s ]
