인프런 커뮤니티 질문&답변

안녕하세요,,

김영한님 강의를 열혈 수강하고 있는 김주영이라고합니다..

다름아니라, 제가 개인 프로젝트 중 아래 쿼리문을 작성을 했는데

DB조회 개수가 7개 일때, 아래의 쿼리를 실행시키면 select User문에서 쿼리가 7번 나가더라구요,,

도통 이유를 모르겠어서 질문 드립니다..

@Query("select distinct new ..패키지명...user.UserScrapUserQueryDto(us, coalesce(scrap.status, false), us.selectedFirstAt) " +
        "from User us " +
        "left join fetch Work work on work.user.id = us.id " +
        "left join fetch UserScrap scrap on scrap.targetId = us.id and scrap.user.id = :userId " +
        "where us.userStatus = 'PERMITTED' and " +
        "      us.id not in (select block.targetId from Block block where block.user.id = :userId and block.status = true) " +
        "and us.id != :userId and us.role = 'USER' " +
        "order by us.selectedFirstAt desc")

• 내 userid에 해당하는 user는 제외,

• block한 유저는 제외,

• UserScarp과 Work는 fetch join으로 갖고오는 쿼리인데,

   

   

• 혹시 왜 select절이 DB 반환 개수만큼 나오는지 알려주실 수 있을까요? ㅠㅠ

아래처럼 쿼리가 한번 나간 후에

Hibernate: 

    select

        distinct user0_.user_id as col_0_0_,

        coalesce(userscrap2_.status,

        false) as col_1_0_,

        user0_.selected_first_at as col_2_0_ 

    from

        "user" user0_ 

    left outer join

        "work" work1_ 

            on (

                work1_.user_id=user0_.user_id

            ) 

    left outer join

        "user_scrap" userscrap2_ 

            on (

                userscrap2_.target_id=user0_.user_id 

                and userscrap2_.user_id=?

            ) 

    where

        user0_.user_status='PERMITTED' 

        and (

            user0_.user_id not in  (

                select

                    block3_.target_id 

                from

                    "block" block3_ 

                where

                    block3_.user_id=? 

                    and block3_.status=true

            )

        ) 

        and user0_.user_id<>? 

        and user0_.role='USER' 

    order by

        user0_.selected_first_at desc

select 쿼리로 db에서 갖고온 개수만큼 반환합니다..

Hibernate: 
    select
        user0_.user_id as user_id1_7_0_,
        user0_.created_at as created_2_7_0_,
        user0_.modified_at as modified3_7_0_,
        user0_.behance as behance4_7_0_,
        user0_.detail as detail5_7_0_,
        user0_.device_token as device_t6_7_0_,
        user0_.email as email7_7_0_,
        user0_.first_work_id as first_wo8_7_0_,
        user0_.info as info9_7_0_,
        user0_.instagram as instagr10_7_0_,
        user0_.magazine_view_count as magazin11_7_0_,
        user0_.notion as notion12_7_0_,
        user0_.role as role13_7_0_,
        user0_.scrap_count as scrap_c14_7_0_,
        user0_.selected_first_at as selecte15_7_0_,
        user0_.tag as tag16_7_0_,
        user0_.user_name as user_na17_7_0_,
        user0_.user_status as user_st18_7_0_,
        user0_.view_count as view_co19_7_0_,
        user0_.work_thumb_nail as work_th20_7_0_ 
    from
        "user" user0_ 
    where
        user0_.user_id=?

답변 주시면 정말 감사하겠습니다..