[BE] comment list 쿼리가 너무 많이 나가요

Tags

Back

Person

Status

In Progress

문제가 발생한 기능

댓글 리스트

생성 일시

2024/12/02 04:29

2024-11-09T06:22:54.830Z  INFO 213934 --- [nio-8080-exec-7] c.d.u.user.infra.BlockUserManagerImpl    : 유저 [user2nick]와 차단 관계에 있는 모든 유저를 조회합니다.
Hibernate:
    select
        bu1_0.id,
        bu1_0.target_id,
        bu1_0.user_id,
        bu1_0.created_at,
        bu1_0.updated_at
    from
        block_users bu1_0
    where
        bu1_0.user_id=?
2024-11-09T06:22:54.831Z  INFO 213934 --- [nio-8080-exec-5] c.d.u.user.infra.BlockUserManagerImpl    : 유저 [user2nick]와 차단 관계에 있는 유저는 총 [0]명입니다.
2024-11-09T06:22:54.832Z  INFO 213934 --- [nio-8080-exec-5] c.d.u.c.d.service.CommentServiceImpl     : [ Comments Retrieval Completed! ]
Hibernate:
    select
        count(r1_0.id)
    from
        reactions r1_0
    where
        r1_0.type=?
        and r1_0.target_id=?
Hibernate:
    select
        bu1_0.id,
        bu1_0.target_id,
        bu1_0.user_id,
        bu1_0.created_at,
        bu1_0.updated_at
    from
        block_users bu1_0
    where
        bu1_0.target_id=?
2024-11-09T06:22:54.835Z  INFO 213934 --- [nio-8080-exec-7] c.d.u.user.infra.BlockUserManagerImpl    : 유저 [user2nick]와 차단 관계에 있는 유저는 총 [0]명입니다.
Hibernate:
    select
        r1_0.id
    from
        reactions r1_0
    where
        r1_0.user_id=?
        and r1_0.type=?
        and r1_0.target_id=?
    limit
        ?
Hibernate:
    select
        u1_0.id,
        u1_0.created_at,
        u1_0.deleted,
        u1_0.description,
        u1_0.email,
        u1_0.nickname,
        u1_0.profile_image,
        u1_0.provider,
        u1_0.token,
        u1_0.univ_name,
        u1_0.updated_at
    from
        users u1_0
    where
        u1_0.id=?
Hibernate:
    select
        count(r1_0.id)
    from
        reactions r1_0
    where
        r1_0.type=?
        and r1_0.target_id=?
Hibernate:
    select
        r1_0.id
    from
        reactions r1_0
    where
        r1_0.user_id=?
        and r1_0.type=?
        and r1_0.target_id=?
    limit
        ?
Hibernate:
    select
        count(r1_0.id)
    from
        reactions r1_0
    where
        r1_0.type=?
        and r1_0.target_id=?
Hibernate:
    select
        u1_0.id,
        u1_0.created_at,
        u1_0.deleted,
        u1_0.description,
        u1_0.email,
        u1_0.nickname,
        u1_0.profile_image,
        u1_0.provider,
        u1_0.token,
        u1_0.univ_name,
        u1_0.updated_at
    from
        users u1_0
    where
        u1_0.id=?
Hibernate:
    select
        r1_0.id
    from
        reactions r1_0
    where
        r1_0.user_id=?
        and r1_0.type=?
        and r1_0.target_id=?
    limit
        ?
Hibernate:
    select
        u1_0.id,
        u1_0.created_at,
        u1_0.deleted,
        u1_0.description,
        u1_0.email,
        u1_0.nickname,
        u1_0.profile_image,
        u1_0.provider,
        u1_0.token,
        u1_0.univ_name,
        u1_0.updated_at
    from
        users u1_0
    where
        u1_0.id=?
Hibernate:
    select
        count(r1_0.id)
    from
        reactions r1_0
    where
        r1_0.type=?
        and r1_0.target_id=?
Hibernate:
    select
        r1_0.id
    from
        reactions r1_0
    where
        r1_0.user_id=?
        and r1_0.type=?
        and r1_0.target_id=?
    limit
        ?
Hibernate:
    select
        u1_0.id,
        u1_0.created_at,
        u1_0.deleted,
        u1_0.description,
        u1_0.email,
        u1_0.nickname,
        u1_0.profile_image,
        u1_0.provider,
        u1_0.token,
        u1_0.univ_name,
        u1_0.updated_at
    from
        users u1_0
    where
        u1_0.id=?
Hibernate:
    select
        count(r1_0.id)
    from
        reactions r1_0
    where
        r1_0.type=?
        and r1_0.target_id=?
Hibernate:
    select
        r1_0.id
    from
        reactions r1_0
    where
        r1_0.user_id=?
        and r1_0.type=?
        and r1_0.target_id=?
    limit
        ?
Hibernate:
    select
        count(r1_0.id)
    from
        reactions r1_0
    where
        r1_0.type=?
        and r1_0.target_id=?
Hibernate:
    select
        r1_0.id
    from
        reactions r1_0
    where
        r1_0.user_id=?
        and r1_0.type=?
        and r1_0.target_id=?
    limit
        ?
JSON
복사

정신이 아찔해요