불필요하게 join을 활용하는 조회 로직을 개선한다.

[hyeonic]

🤷 구현할 기능

불필요하게 join을 활용하는 조회 로직을 개선한다.

🔨 상세 작업 내용

• 불필요하게 join을 활용하는 조회 로직 탐색
• 개선

📄 참고 사항

⏰ 예상 소요 기간

3시간

[hyeonic]

Optional<OAuthToken> findByMemberId(final Long memberId);

개선 전

Hibernate: 
    select
        oauthtoken0_.id as id1_4_,
        oauthtoken0_.created_at as created_2_4_,
        oauthtoken0_.updated_at as updated_3_4_,
        oauthtoken0_.members_id as members_5_4_,
        oauthtoken0_.refresh_token as refresh_4_4_ 
    from
        oauth_tokens oauthtoken0_ 
    left outer join
        members member1_ 
            on oauthtoken0_.members_id=member1_.id 
    where
        member1_.id=?

개선 후

Hibernate: 
    select
        oauthtoken0_.id as id1_4_,
        oauthtoken0_.created_at as created_2_4_,
        oauthtoken0_.updated_at as updated_3_4_,
        oauthtoken0_.members_id as members_5_4_,
        oauthtoken0_.refresh_token as refresh_4_4_ 
    from
        oauth_tokens oauthtoken0_ 
    where
        oauthtoken0_.members_id=?