SHOW FULL COLUMNS FROM `lnk_sns_user` [ RunTime:0.000567s ]
SELECT id,name,avatar,gender,age,career,integral_all,integral_usable,integral_used,mobile,city,province,status FROM `lnk_sns_user` WHERE `id` = 1047 LIMIT 1 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `lnk_sns_dynamic` [ RunTime:0.000504s ]
SELECT COUNT(*) AS think_count FROM `lnk_sns_dynamic` WHERE `user_id` = 1047 AND `status` = 1 AND `show` = 1 LIMIT 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `lnk_sns_user_like_dynamic` [ RunTime:0.000366s ]
SELECT COUNT(*) AS think_count FROM `lnk_sns_user_like_dynamic` WHERE `status` = 1 AND `user_id` = 1047 LIMIT 1 [ RunTime:0.000228s ]
SHOW FULL COLUMNS FROM `lnk_sns_user_follow` [ RunTime:0.000446s ]
SELECT `follow_user_id` FROM `lnk_sns_user_follow` WHERE `user_id` = 1047 AND `user_id` = 1047 [ RunTime:0.000249s ]
SELECT * FROM `lnk_sns_user` WHERE 0 = 1 LIMIT 20 [ RunTime:0.000219s ]
SELECT `user_id` FROM `lnk_sns_user_follow` WHERE `follow_user_id` = 1047 AND `follow_user_id` = 1047 [ RunTime:0.005693s ]
SELECT * FROM `lnk_sns_user` WHERE 0 = 1 LIMIT 20 [ RunTime:0.000217s ]
SELECT COUNT(*) AS think_count FROM `lnk_sns_dynamic` WHERE `status` = 1 AND `show` = 1 AND `user_id` = 1047 LIMIT 1 [ RunTime:0.000286s ]
SELECT id,user_id,content,circle_id,circle_name,province,adds,lat,lng,create_time,view,type,status,mold FROM `lnk_sns_dynamic` WHERE `status` = 1 AND `show` = 1 AND `user_id` = 1047 ORDER BY `top` DESC,`create_time` DESC,`weigh` DESC,`view` DESC LIMIT 0,6 [ RunTime:0.000378s ]
SELECT `name`,`avatar`,`career` FROM `lnk_sns_user` WHERE `id` = 1047 LIMIT 1 [ RunTime:0.000221s ]
SHOW FULL COLUMNS FROM `lnk_sns_dynamic_video` [ RunTime:0.000465s ]
SELECT `url`,`img`,`wide`,`high` FROM `lnk_sns_dynamic_video` WHERE `dynamic_id` = 136 LIMIT 1 [ RunTime:0.000212s ]
SHOW FULL COLUMNS FROM `lnk_sns_dynamic_comment` [ RunTime:0.000401s ]
SELECT COUNT(*) AS think_count FROM `lnk_sns_dynamic_comment` WHERE `status` <> 0 AND `dynamic_id` = 136 LIMIT 1 [ RunTime:0.000238s ]
SELECT COUNT(*) AS think_count FROM `lnk_sns_user_like_dynamic` WHERE `dynamic_id` = 136 LIMIT 1 [ RunTime:0.000773s ]
SELECT `user_id`,`content`,`status` FROM `lnk_sns_dynamic_comment` WHERE `dynamic_id` = 136 AND `status` <> 0 LIMIT 1 [ RunTime:0.000206s ]
SELECT `name` FROM `lnk_sns_user` WHERE `id` = 1048 LIMIT 1 [ RunTime:0.000199s ]
SELECT COUNT(*) AS think_count FROM `lnk_sns_user_like_dynamic` WHERE `dynamic_id` = 136 AND `user_id` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000201s ]