🔸쿼리
```sql
#authUtil.getLoginMember()
select
member0_.member_id as member_i1_13_0_,
member0_.member_email as member_e2_13_0_,
member0_.member_gender as member_g3_13_0_,
member0_.member_image_name as member_i4_13_0_,
member0_.member_image_type as member_i5_13_0_,
member0_.member_image_uuid as member_i6_13_0_,
member0_.member_image_url as member_i7_13_0_,
member0_.member_introduce as member_i8_13_0_,
member0_.member_name as member_n9_13_0_,
member0_.member_password as member_10_13_0_,
member0_.member_phone as member_11_13_0_,
member0_.member_role as member_12_13_0_,
member0_.member_username as member_13_13_0_,
member0_.member_website as member_14_13_0_
from
members member0_
where
member0_.member_id=?
#hashtagRepository.findByName()
select
hashtag0_.hashtag_id as hashtag_1_8_,
hashtag0_.hashtag_count as hashtag_2_8_,
hashtag0_.hashtag_name as hashtag_3_8_
from
hashtags hashtag0_
where
hashtag0_.hashtag_name=?
#hashtagPostRepository.findHashtagProfileByLoginMemberIdAndHashtagId()
select
hashtag1_.hashtag_name as col_0_0_,
count(hashtagpos0_.hashtag_post_id) as col_1_0_,
exists (select
1
from
hashtag_follows hashtagfol3_
where
hashtagfol3_.hashtag_id=?
and hashtagfol3_.member_id=?) as col_2_0_
from
hashtag_posts hashtagpos0_
inner join
hashtags hashtag1_
on hashtagpos0_.hashtag_id=hashtag1_.hashtag_id
where
hashtagpos0_.hashtag_id=?
#hashtagPostRepository.findAllWithPostByHashtagId()
select
hashtagpos0_.hashtag_post_id as hashtag_1_7_0_,
post1_.post_id as post_id1_24_1_,
hashtagpos0_.hashtag_id as hashtag_2_7_0_,
hashtagpos0_.post_id as post_id3_7_0_,
post1_.post_comment_flag as post_com2_24_1_,
post1_.post_content as post_con3_24_1_,
post1_.post_like_flag as post_lik4_24_1_,
post1_.member_id as member_i6_24_1_,
post1_.post_upload_date as post_upl5_24_1_
from
hashtag_posts hashtagpos0_
inner join
posts post1_
on hashtagpos0_.post_id=post1_.post_id
where
hashtagpos0_.hashtag_id=?
order by
hashtagpos0_.post_id desc limit ?
#getPostImages()
select
postimages0_.post_id as post_id7_21_1_,
postimages0_.post_image_id as post_ima1_21_1_,
postimages0_.post_image_id as post_ima1_21_0_,
postimages0_.post_image_alt_text as post_ima2_21_0_,
postimages0_.post_image_name as post_ima3_21_0_,
postimages0_.post_image_type as post_ima4_21_0_,
postimages0_.post_image_uuid as post_ima5_21_0_,
postimages0_.post_image_url as post_ima6_21_0_,
postimages0_.post_id as post_id7_21_0_
from
post_images postimages0_
where
postimages0_.post_id=?
```
💬Comment
-
📑References
✅Check List
[x] 추가한 기능에 대한 테스트는 모두 완료하셨나요?
[x] 코드 정렬(Ctrl + Alt + L), 불필요한 코드나 오타는 없는지 확인하셨나요?
📌Linked Issues
✏Change Details
🔸쿼리
```sql #authUtil.getLoginMember() select member0_.member_id as member_i1_13_0_, member0_.member_email as member_e2_13_0_, member0_.member_gender as member_g3_13_0_, member0_.member_image_name as member_i4_13_0_, member0_.member_image_type as member_i5_13_0_, member0_.member_image_uuid as member_i6_13_0_, member0_.member_image_url as member_i7_13_0_, member0_.member_introduce as member_i8_13_0_, member0_.member_name as member_n9_13_0_, member0_.member_password as member_10_13_0_, member0_.member_phone as member_11_13_0_, member0_.member_role as member_12_13_0_, member0_.member_username as member_13_13_0_, member0_.member_website as member_14_13_0_ from members member0_ where member0_.member_id=? #hashtagRepository.findByName() select hashtag0_.hashtag_id as hashtag_1_8_, hashtag0_.hashtag_count as hashtag_2_8_, hashtag0_.hashtag_name as hashtag_3_8_ from hashtags hashtag0_ where hashtag0_.hashtag_name=? #hashtagPostRepository.findHashtagProfileByLoginMemberIdAndHashtagId() select hashtag1_.hashtag_name as col_0_0_, count(hashtagpos0_.hashtag_post_id) as col_1_0_, exists (select 1 from hashtag_follows hashtagfol3_ where hashtagfol3_.hashtag_id=? and hashtagfol3_.member_id=?) as col_2_0_ from hashtag_posts hashtagpos0_ inner join hashtags hashtag1_ on hashtagpos0_.hashtag_id=hashtag1_.hashtag_id where hashtagpos0_.hashtag_id=? #hashtagPostRepository.findAllWithPostByHashtagId() select hashtagpos0_.hashtag_post_id as hashtag_1_7_0_, post1_.post_id as post_id1_24_1_, hashtagpos0_.hashtag_id as hashtag_2_7_0_, hashtagpos0_.post_id as post_id3_7_0_, post1_.post_comment_flag as post_com2_24_1_, post1_.post_content as post_con3_24_1_, post1_.post_like_flag as post_lik4_24_1_, post1_.member_id as member_i6_24_1_, post1_.post_upload_date as post_upl5_24_1_ from hashtag_posts hashtagpos0_ inner join posts post1_ on hashtagpos0_.post_id=post1_.post_id where hashtagpos0_.hashtag_id=? order by hashtagpos0_.post_id desc limit ? #getPostImages() select postimages0_.post_id as post_id7_21_1_, postimages0_.post_image_id as post_ima1_21_1_, postimages0_.post_image_id as post_ima1_21_0_, postimages0_.post_image_alt_text as post_ima2_21_0_, postimages0_.post_image_name as post_ima3_21_0_, postimages0_.post_image_type as post_ima4_21_0_, postimages0_.post_image_uuid as post_ima5_21_0_, postimages0_.post_image_url as post_ima6_21_0_, postimages0_.post_id as post_id7_21_0_ from post_images postimages0_ where postimages0_.post_id=? ```💬Comment
-
📑References
✅Check List