SHOW FULL COLUMNS FROM `wf_notes` [ RunTime:0.000399s ]
SELECT `n`.*,`u`.`nickname`,`u`.`avatar`,`u`.`credit_score`,`u`.`bio` FROM `wf_notes` `n` INNER JOIN `wf_note_media` `nm` ON `n`.`id`=`nm`.`note_id` INNER JOIN `wf_users` `u` ON `n`.`user_id`=`u`.`id` WHERE `n`.`note_type` = '2' AND `n`.`status` = '1' AND `nm`.`media_type` = '2' ORDER BY `n`.`published_at` DESC LIMIT 1 [ RunTime:0.000390s ]
UPDATE `wf_notes` SET `view_count` = `view_count` + 1 WHERE `id` = 14 [ RunTime:0.020652s ]
SELECT `view_count` FROM `wf_notes` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000153s ]
SHOW FULL COLUMNS FROM `wf_note_media` [ RunTime:0.000289s ]
SELECT * FROM `wf_note_media` WHERE `note_id` = 14 AND `media_type` = 2 ORDER BY `sort_order` ASC LIMIT 1 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `wf_note_tags` [ RunTime:0.000260s ]
SELECT `t`.`id`,`t`.`name` FROM `wf_note_tags` `nt` INNER JOIN `wf_tags` `t` ON `nt`.`tag_id`=`t`.`id` WHERE `nt`.`note_id` = '14' [ RunTime:0.000186s ]
SELECT * FROM `wf_notes` WHERE `user_id` = 3 AND `note_type` = 2 AND `status` = 1 AND `id` <> 14 ORDER BY `published_at` DESC LIMIT 10 [ RunTime:0.000278s ]
SELECT * FROM `wf_note_media` WHERE `note_id` = 13 AND `media_type` = 2 LIMIT 1 [ RunTime:0.000186s ]
SELECT * FROM `wf_note_media` WHERE `note_id` = 4 AND `media_type` = 2 LIMIT 1 [ RunTime:0.000176s ]
SELECT * FROM `wf_notes` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000186s ]
SHOW FULL COLUMNS FROM `wf_comments` [ RunTime:0.000283s ]
SELECT `c`.`id`,`c`.`user_id`,`c`.`content`,`c`.`location`,`c`.`like_count`,`c`.`created_at`,`u`.`nickname`,`u`.`avatar` FROM `wf_comments` `c` INNER JOIN `wf_users` `u` ON `c`.`user_id`=`u`.`id` WHERE `c`.`note_id` = '14' AND `c`.`status` = '1' AND `c`.`parent_id` = '0' ORDER BY CASE WHEN c.like_count >= 10 THEN c.like_count ELSE 0 END DESC, c.created_at DESC LIMIT 0,10 [ RunTime:0.000249s ]
SELECT `c`.`id`,`c`.`user_id`,`c`.`parent_id`,`c`.`content`,`c`.`location`,`c`.`like_count`,`c`.`created_at`,u.nickname as reply_nickname,u.avatar as reply_avatar,pu.nickname as parent_nickname,pu.id as parent_user_id FROM `wf_comments` `c` INNER JOIN `wf_users` `u` ON `c`.`user_id`=`u`.`id` LEFT JOIN `wf_comments` `pc` ON `c`.`parent_id`=`pc`.`id` LEFT JOIN `wf_users` `pu` ON `pc`.`user_id`=`pu`.`id` WHERE `c`.`note_id` = '14' AND `c`.`parent_id` <> '0' AND `c`.`status` = '1' ORDER BY `c`.`created_at` ASC [ RunTime:0.000252s ]
SELECT COUNT(*) AS think_count FROM `wf_comments` WHERE `note_id` = 14 AND `status` = 1 LIMIT 1 [ RunTime:0.000167s ]
SELECT COUNT(*) AS think_count FROM `wf_comments` WHERE `note_id` = 14 AND `status` = 1 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000168s ]
评论 0