쿼리수 개선

개발 공부 중·2022년 9월 26일
0

Spring

목록 보기
2/8

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번)

profile
개발 공부 중

0개의 댓글