SHOW FULL COLUMNS FROM `mu_room` [ RunTime:0.002001s ]
SELECT * FROM `mu_room` WHERE `status` = '1' AND `hidden` <> '1' AND `id` = 5825 LIMIT 1 [ RunTime:0.000733s ]
SHOW FULL COLUMNS FROM `mu_view` [ RunTime:0.001151s ]
SELECT * FROM `mu_view` WHERE `mu_id` = 5825 LIMIT 1 [ RunTime:0.001111s ]
SHOW FULL COLUMNS FROM `mu_room_jp` [ RunTime:0.001214s ]
SELECT COUNT(*) AS think_count FROM `mu_room_jp` WHERE `mu_id` = 5825 LIMIT 1 [ RunTime:0.020690s ]
SHOW FULL COLUMNS FROM `mu_comment` [ RunTime:0.001467s ]
SELECT COUNT(*) AS think_count FROM `mu_comment` WHERE `mu_id` = 5825 AND `shenhe` = '1' AND `status` = '1' AND `hidden` = 0 LIMIT 1 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `mu_story` [ RunTime:0.001295s ]
SELECT COUNT(*) AS think_count FROM `mu_story` `s` INNER JOIN `mu_room` `r` ON `s`.`mu_id`=`r`.`id` WHERE `s`.`status` = '1' AND `s`.`hidden` = '0' AND `s`.`shenhe` = '1' AND `r`.`status` = '1' AND `r`.`hidden` <> '1' AND `s`.`mu_id` = '5825' LIMIT 1 [ RunTime:0.000618s ]
SELECT `s`.`id`,`s`.`mu_id`,`s`.`uid`,`s`.`title`,`s`.`content`,`s`.`story_date`,`s`.`images`,`s`.`create_time`,r.name as room_name,r.photo as room_photo FROM `mu_story` `s` INNER JOIN `mu_room` `r` ON `s`.`mu_id`=`r`.`id` WHERE `s`.`status` = '1' AND `s`.`hidden` = '0' AND `s`.`shenhe` = '1' AND `r`.`status` = '1' AND `r`.`hidden` <> '1' AND `s`.`mu_id` = '5825' ORDER BY `s`.`story_date` DESC,`s`.`id` DESC LIMIT 0,8 [ RunTime:0.000421s ]
SELECT COUNT(*) AS think_count FROM `mu_comment` `c` INNER JOIN `mu_room` `r` ON `c`.`mu_id`=`r`.`id` WHERE `c`.`status` = '1' AND `c`.`hidden` = '0' AND `c`.`shenhe` = '1' AND `r`.`status` = '1' AND `r`.`hidden` <> '1' AND `c`.`mu_id` = '5825' LIMIT 1 [ RunTime:0.000495s ]
SELECT `c`.`id`,`c`.`mu_id`,`c`.`uid`,`c`.`content`,`c`.`images`,`c`.`create_time`,r.name as room_name,r.photo as room_photo FROM `mu_comment` `c` INNER JOIN `mu_room` `r` ON `c`.`mu_id`=`r`.`id` WHERE `c`.`status` = '1' AND `c`.`hidden` = '0' AND `c`.`shenhe` = '1' AND `r`.`status` = '1' AND `r`.`hidden` <> '1' AND `c`.`mu_id` = '5825' ORDER BY `c`.`id` DESC LIMIT 0,8 [ RunTime:0.000505s ]
SHOW FULL COLUMNS FROM `user_info` [ RunTime:0.001355s ]
SELECT `nickname`,`avatar` FROM `user_info` WHERE `user_id` = 7322 LIMIT 1 [ RunTime:0.000472s ]
SELECT `nickname`,`avatar` FROM `user_info` WHERE `user_id` = 7322 LIMIT 1 [ RunTime:0.000324s ]
SELECT `nickname`,`avatar` FROM `user_info` WHERE `user_id` = 7322 LIMIT 1 [ RunTime:0.000324s ]
SELECT `nickname`,`avatar` FROM `user_info` WHERE `user_id` = 7322 LIMIT 1 [ RunTime:0.000313s ]
SELECT `nickname`,`avatar` FROM `user_info` WHERE `user_id` = 7322 LIMIT 1 [ RunTime:0.000319s ]
SELECT `nickname`,`avatar` FROM `user_info` WHERE `user_id` = 7322 LIMIT 1 [ RunTime:0.000294s ]
SELECT `nickname`,`avatar` FROM `user_info` WHERE `user_id` = 7322 LIMIT 1 [ RunTime:0.000332s ]
SELECT `nickname`,`avatar` FROM `user_info` WHERE `user_id` = 7322 LIMIT 1 [ RunTime:0.000314s ]
SELECT * FROM `mu_room` WHERE `id` = 5825 AND `status` = '1' LIMIT 1 [ RunTime:0.000579s ]
SELECT COUNT(1) AS c FROM (
SELECT 'create_room' AS event_type, id AS source_id, id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, '' AS content, '' AS images, NULL AS end_time
FROM mu_room
WHERE id = '5825' AND status = 1
UNION ALL
SELECT 'visit' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, '' AS content, '' AS images, NULL AS end_time
FROM mu_my_view
WHERE mu_id = '5825'
UNION ALL
SELECT 'offer' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, jp_id AS jp_id, msg AS content, '' AS images, end_time AS end_time
FROM mu_room_jp_v2
WHERE mu_id = '5825' AND status = 1 AND is_pos = 0
UNION ALL
SELECT 'comment' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, content AS content, images AS images, NULL AS end_time
FROM mu_comment
WHERE mu_id = '5825' AND status = 1 AND shenhe = 1 AND hidden = 0
UNION ALL
SELECT 'photo' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, name AS content, src AS images, NULL AS end_time
FROM mu_gallery
WHERE mu_id = '5825' AND status = 1
UNION ALL
SELECT 'story' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, title AS content, images AS images, NULL AS end_time
FROM mu_story
WHERE mu_id = '5825' AND status = 1 AND shenhe = 1 AND hidden = 0
) t WHERE 1 = 1 [ RunTime:0.002613s ]
SELECT * FROM (
SELECT 'create_room' AS event_type, id AS source_id, id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, '' AS content, '' AS images, NULL AS end_time
FROM mu_room
WHERE id = '5825' AND status = 1
UNION ALL
SELECT 'visit' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, '' AS content, '' AS images, NULL AS end_time
FROM mu_my_view
WHERE mu_id = '5825'
UNION ALL
SELECT 'offer' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, jp_id AS jp_id, msg AS content, '' AS images, end_time AS end_time
FROM mu_room_jp_v2
WHERE mu_id = '5825' AND status = 1 AND is_pos = 0
UNION ALL
SELECT 'comment' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, content AS content, images AS images, NULL AS end_time
FROM mu_comment
WHERE mu_id = '5825' AND status = 1 AND shenhe = 1 AND hidden = 0
UNION ALL
SELECT 'photo' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, name AS content, src AS images, NULL AS end_time
FROM mu_gallery
WHERE mu_id = '5825' AND status = 1
UNION ALL
SELECT 'story' AS event_type, id AS source_id, mu_id AS mu_id, uid AS uid, create_time AS sort_time, 0 AS jp_id, title AS content, images AS images, NULL AS end_time
FROM mu_story
WHERE mu_id = '5825' AND status = 1 AND shenhe = 1 AND hidden = 0
) t
WHERE 1 = 1
ORDER BY t.sort_time DESC, t.source_id DESC
LIMIT 0,11 [ RunTime:0.002022s ]
SELECT `user_id`,`nickname`,`avatar` FROM `user_info` WHERE `user_id` IN (7322,7710,3662,8638) [ RunTime:0.000634s ]
SHOW FULL COLUMNS FROM `user` [ RunTime:0.001735s ]
SELECT `id`,`name`,`photo` FROM `user` WHERE `id` IN (7322,7710,3662,8638) [ RunTime:0.000604s ]
SHOW FULL COLUMNS FROM `mu_fans` [ RunTime:0.001204s ]
SELECT `uid`,`type` FROM `mu_fans` WHERE `mu_id` = 5825 AND `uid` IN (7322,7710,3662,8638) [ RunTime:0.000605s ]
SHOW FULL COLUMNS FROM `mu_gallery` [ RunTime:0.001176s ]
SELECT * FROM `mu_gallery` WHERE `mu_id` = 5825 AND `status` = '1' ORDER BY `id` DESC LIMIT 12 [ RunTime:0.001550s ]
SELECT * FROM `mu_room` WHERE `status` = '1' AND `hidden` <> '1' AND `id` <> 5825 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.000847s ]
SELECT * FROM `mu_view` WHERE `mu_id` = 7792 LIMIT 1 [ RunTime:0.001272s ]
SELECT COUNT(*) AS think_count FROM `mu_room_jp` WHERE `mu_id` = 7792 LIMIT 1 [ RunTime:0.020271s ]
SELECT COUNT(*) AS think_count FROM `mu_comment` WHERE `mu_id` = 7792 AND `shenhe` = '1' AND `status` = '1' AND `hidden` = 0 LIMIT 1 [ RunTime:0.000586s ]
SELECT * FROM `mu_view` WHERE `mu_id` = 7771 LIMIT 1 [ RunTime:0.001190s ]
SELECT COUNT(*) AS think_count FROM `mu_room_jp` WHERE `mu_id` = 7771 LIMIT 1 [ RunTime:0.020621s ]
SELECT COUNT(*) AS think_count FROM `mu_comment` WHERE `mu_id` = 7771 AND `shenhe` = '1' AND `status` = '1' AND `hidden` = 0 LIMIT 1 [ RunTime:0.000466s ]
SELECT * FROM `mu_view` WHERE `mu_id` = 7728 LIMIT 1 [ RunTime:0.001186s ]
SELECT COUNT(*) AS think_count FROM `mu_room_jp` WHERE `mu_id` = 7728 LIMIT 1 [ RunTime:0.020113s ]
SELECT COUNT(*) AS think_count FROM `mu_comment` WHERE `mu_id` = 7728 AND `shenhe` = '1' AND `status` = '1' AND `hidden` = 0 LIMIT 1 [ RunTime:0.000502s ]
SELECT * FROM `mu_view` WHERE `mu_id` = 7725 LIMIT 1 [ RunTime:0.001177s ]
SELECT COUNT(*) AS think_count FROM `mu_room_jp` WHERE `mu_id` = 7725 LIMIT 1 [ RunTime:0.021010s ]
SELECT COUNT(*) AS think_count FROM `mu_comment` WHERE `mu_id` = 7725 AND `shenhe` = '1' AND `status` = '1' AND `hidden` = 0 LIMIT 1 [ RunTime:0.000556s ]
总觉得陪伴你的时间太少了,真的很想你。
寒衣节到了,防寒保
爸,中元节快乐
又是一年清明
河南的十月一了,儿子远在新疆愿父亲别忘了天凉了加衣服
爸,三儿在北京丰台,在这里不敢去十字路口给您送钱,只有这样了,请你愿谅三
您在那边还好吗,端午节快乐
一年一度的清朋节来临之季,祝您们在那边好好的生活