like 조회(쿼리수 7번)
좋아요한 회원이 많을수록 for문이 돌아 쿼리가 점점 늘어남
Hibernate:
select
member0_.`member_id` as member_i1_5_,
member0_.`created_at` as created_2_5_,
member0_.`modified_at` as modified3_5_,
member0_.`member_email` as member_e4_5_,
member0_.`member_kakao_id` as member_k5_5_,
member0_.`member_status` as member_s6_5_,
member0_.`member_nickname` as member_n7_5_,
member0_.`member_password` as member_p8_5_,
member0_.`member_profile_img_url` as member_p9_5_
from
`member` member0_
where
member0_.`member_email`=?
Hibernate:
select
todolist0_.`todo_list_id` as todo_lis1_9_0_,
todolist0_.`todo_list_due_date` as todo_lis2_9_0_,
todolist0_.`member_id` as member_i7_9_0_,
todolist0_.`todo_list_planet_color` as todo_lis3_9_0_,
todolist0_.`todo_list_planet_level` as todo_lis4_9_0_,
todolist0_.`todo_list_planet_size` as todo_lis5_9_0_,
todolist0_.`todo_list_planet_type` as todo_lis6_9_0_
from
`todo_list` todolist0_
where
todolist0_.`todo_list_id`=?
Hibernate:
select
likes0_.`likes_id` as likes_id1_4_,
likes0_.`member_id` as member_i2_4_,
likes0_.`todo_list_id` as todo_lis3_4_
from
`likes` likes0_
where
likes0_.`todo_list_id`=?
Hibernate:
select
member0_.`member_id` as member_i1_5_0_,
member0_.`created_at` as created_2_5_0_,
member0_.`modified_at` as modified3_5_0_,
member0_.`member_email` as member_e4_5_0_,
member0_.`member_kakao_id` as member_k5_5_0_,
member0_.`member_status` as member_s6_5_0_,
member0_.`member_nickname` as member_n7_5_0_,
member0_.`member_password` as member_p8_5_0_,
member0_.`member_profile_img_url` as member_p9_5_0_
from
`member` member0_
where
member0_.`member_id`=?
Hibernate:
select
member0_.`member_id` as member_i1_5_0_,
member0_.`created_at` as created_2_5_0_,
member0_.`modified_at` as modified3_5_0_,
member0_.`member_email` as member_e4_5_0_,
member0_.`member_kakao_id` as member_k5_5_0_,
member0_.`member_status` as member_s6_5_0_,
member0_.`member_nickname` as member_n7_5_0_,
member0_.`member_password` as member_p8_5_0_,
member0_.`member_profile_img_url` as member_p9_5_0_
from
`member` member0_
where
member0_.`member_id`=?
Hibernate:
select
member0_.`member_id` as member_i1_5_0_,
member0_.`created_at` as created_2_5_0_,
member0_.`modified_at` as modified3_5_0_,
member0_.`member_email` as member_e4_5_0_,
member0_.`member_kakao_id` as member_k5_5_0_,
member0_.`member_status` as member_s6_5_0_,
member0_.`member_nickname` as member_n7_5_0_,
member0_.`member_password` as member_p8_5_0_,
member0_.`member_profile_img_url` as member_p9_5_0_
from
`member` member0_
where
member0_.`member_id`=?
Hibernate:
select
member0_.`member_id` as member_i1_5_0_,
member0_.`created_at` as created_2_5_0_,
member0_.`modified_at` as modified3_5_0_,
member0_.`member_email` as member_e4_5_0_,
member0_.`member_kakao_id` as member_k5_5_0_,
member0_.`member_status` as member_s6_5_0_,
member0_.`member_nickname` as member_n7_5_0_,
member0_.`member_password` as member_p8_5_0_,
member0_.`member_profile_img_url` as member_p9_5_0_
from
`member` member0_
where
member0_.`member_id`=?
like 조회(쿼리수 3번)