검색 쿼리 개선하기

[jminkkk]

검색 쿼리 개선하기

[jminkkk]

기존 검색 구현 사항

• 멤버 ID
• 검색 키워드 (템플릿명, 템플릿 설명, 파일명, 소스 코드)
• 카테고리 ID
• 태그 ID들

[jminkkk]

조건별 속도

API 속도는 저혼자 궁금해서 찍어본거임

단일 검색

멤버 ID

Total request count: 1000
Total elapsed time: 177783ms
Average elapsed time: 177ms

검색 키워드 (템플릿명, 템플릿 설명, 파일명, 소스 코드)

Total request count: 1000
Total elapsed time: 1200642ms
Average elapsed time: 1200ms

1. 해당 키워드가 포함된 템플릿이 17853건일 때, (키워드는 Time)
   

2. 해당 키워드가 포함된 템플릿이 17753건일 때, (키워드는 17753)

3. 해당 키워드가 포함된 템플릿이

카테고리 ID

Total request count: 1000
Total elapsed time: 142164ms
Average elapsed time: 142ms

태그 ID들

Total request count: 1000
Total elapsed time: 204150ms
Average elapsed time: 204ms

1. 해당 태그가 포함된 템플릿이 156건일 때

복합 검색

키워드 & 카테고리

Total request count: 1000
Total elapsed time: 63441ms
Average elapsed time: 63ms

멤버 & 키워드

Total request count: 1000
Total elapsed time: 310193ms
Average elapsed time: 310ms

멤버 & 카테고리

Total request count: 1000
Total elapsed time: 141267ms
Average elapsed time: 141ms

멤버�& 태그

Total request count: 1000
Total elapsed time: 79246ms
Average elapsed time: 79ms

키워드 & 태그

Total request count: 1000
Total elapsed time: 560551ms
Average elapsed time: 560ms

카테고리 & 태그

3Total request count: 1000
Total elapsed time: 40035ms
Average elapsed time: 40ms

모든 조건

Total request count: 1000
Total elapsed time: 30331ms
Average elapsed time: 30ms

[jminkkk]

모든 검색에서 실행되는 JPA method

• TemplateJpaRepository.findAll()
• TemplateTagJpaRepository.findAllByTemplate
• ThumbnailJpaRepository.fetchByTemplate
• MemberJpaRepository.fetchByTemplateId

메서드별 쿼리 목록

1. TemplateJpaRepository.findAll() -> 1번 발생

• 1.1 템플릿 검색 (1번 발생)
• 1.2 카테고리 조회 (카테고리 갯수만큼 발생)
• 1.3 템플릿 갯수 조회 (1번 발생)

2. TemplateTagJpaRepository.findAllByTemplate() -> 템플릿 갯수만큼 발생

• 2.1 템플릿 태그 조회 (1번 발생)
• 2.2 각 템플릿의 태그 조회(태그 갯수만큼 조회)

3. ThumbnailJpaRepository.fetchByTemplate() -> 템플릿 갯수만큼 발생

• 3.1 썸네일 조회(1번 발생)
• 3.2 소스코드 조회(소스코드 갯수만큼 발생)

4. MemberJpaRepository.fetchByTemplateId() -> 템플릿 갯수만큼 발생

• 템플릿 작성 회원 조회(1번 발생)

총 템플릿 갯수가 N, 총 카테고리 갯수가 C, 템플릿 당 평균 태그 T, 템플릿 당 평균 소스코드 SC일 때 다음처럼 발생
(1 + C + 1) + N * { (1 + T) + (1 + SC + 1}

-> O(N * (C + T + SC))

조건에 상관없이 무조건 발생되는 쿼리 목록

    # 1.1 템플릿 검색 (1번 발생)
    # 🍀 조건에 따라 다르게 발생 -> 하단 참고

    # 1.2 카테고리 조회 (카테고리 갯수만큼 발생)
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?

    # 1.3 템플릿 갯수 조회 (1번 발생)
    # 🍀 조건에 따라 다르게 발생 -> 하단 참고

    # 🔥 여기서부터 4개 쿼리는 아래 템플릿 갯수만큼 조회 🔥 -> 각 발생되는 쿼리 * 템플릿 갯수
    # 2.1 템플릿 태그 조회 (1번 발생)
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?

    # 2.2 각 템플릿의 태그 조회(태그 갯수만큼 조회)
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?

    # 3.1 썸네일 조회(1번 발생)
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?

    # 3.2 소스코드 조회(소스코드 갯수만큼 발생)
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?

    # 4.1 템플릿 작성 회원 조회(템플릿 갯수만큼 발생)
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?

[jminkkk]

조건별 발생되는 쿼리

아래 두 쿼리는 where 절이 조회 조건에 따라 변경됩니다.

1.1 템플릿 검색

    select
        t1_0.id,
        t1_0.category_id,
        t1_0.created_at,
        t1_0.description,
        t1_0.member_id,
        t1_0.modified_at,
        t1_0.title 
    from
        template t1_0 
    where
        # 조건별로 다른 쿼리 
    limit
        ?, ?

1.3 템플릿 갯수 조회 (1번 발생)

    select
        count(t1_0.id) 
    from
        template t1_0 
    where
        # 조건별로 다른 쿼리 

필터링 조건 별 추가되는 where 절 조건

멤버 ID

    where
        t1_0.member_id=? 

검색 키워드 (템플릿명, 템플릿 설명, 파일명, 소스 코드)

    where
        (
            t1_0.title like ? escape '' 
            or t1_0.description like ? escape '' 
            or t1_0.id in ((select
                sc1_0.template_id 
            from
                source_code sc1_0 
            where
                sc1_0.content like ? escape '' 
                or sc1_0.filename like ? escape ''))
        ) 

카테고리 ID

    where
        t1_0.category_id=? 

태그 ID들

    where
        t1_0.id in ((select
            tt1_0.template_id 
        from
            template_tag tt1_0 
        where
            tt1_0.tag_id in (?) 
        group by
            1 
        having
            count(distinct tt1_0.tag_id)=?)) 

---

따라서 모든 조건이 적용된다면
where절은 다음과 같습니다.

    select
        t1_0.id,
        t1_0.category_id,
        t1_0.created_at,
        t1_0.description,
        t1_0.member_id,
        t1_0.modified_at,
        t1_0.title 
    from
        template t1_0 
    where
        t1_0.member_id=? 
        and t1_0.category_id=? 
        and t1_0.id in ((select
            tt1_0.template_id 
        from
            template_tag tt1_0 
        where
            tt1_0.tag_id in (?) 
        group by
            1 
        having
            count(distinct tt1_0.tag_id)=?)) 
        and (
            t1_0.title like ? escape '' 
            or t1_0.description like ? escape '' 
            or t1_0.id in ((select
                sc1_0.template_id 
            from
                source_code sc1_0 
            where
                sc1_0.content like ? escape '' 
                or sc1_0.filename like ? escape ''))
        ) 
    limit
        ?, ?

[jminkkk]

개선하기

1. 서브쿼리 -> Join으로 변경

검색 키워드와 태그 ID들이 조건에 포함될 경우 서브 쿼리로 조건절이 나간다.

각 서브 쿼리를 Join 절로 바꾸어 개선하면 다음과 같다.

태그들

AS-IS

where t1_0.id in ((select tt1_0.template_id
                   from template_tag tt1_0
                   where tt1_0.tag_id in (1)
                   group by 1
                   having count(distinct tt1_0.tag_id) = 1))

모든 레코드 가져오는데 걸린 시간: 3.09

TO-BE

FROM template t
         JOIN template_tag tt ON t.id = tt.template_id

모든 레코드 가져오는데 걸린 시간: 1.3

약 2.37배 개선

[jminkkk]

N + 1 먼저 해결하기

http://localhost:8080/templates를 조회했을 때 날라가는 쿼리

총 템플릿 갯수가 N, 총 카테고리 갯수가 C, 템플릿 당 평균 태그 T, 템플릿 당 평균 소스코드 SC일 때 다음처럼 발생
(1 + C + 1) + N * { (1 + T) + (1 + SC + 1}

-> O(N * (C + T + SC))

Hibernate:
    select
        t1_0.id,
        t1_0.category_id,
        t1_0.created_at,
        t1_0.description,
        t1_0.member_id,
        t1_0.modified_at,
        t1_0.title 
    from
        template t1_0 
    where
        1=1 
    limit
        ?, ?
⚡️ binding parameter (1:INTEGER) <- [0] 
⚡️ binding parameter (2:INTEGER) <- [20] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [1] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [10] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [7] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [3] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [5] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [8] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [2] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [6] 
Hibernate: 
    select
        c1_0.id,
        c1_0.created_at,
        c1_0.is_default,
        c1_0.member_id,
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt,
        c1_0.modified_at,
        c1_0.name 
    from
        category c1_0 
    join
        member m1_0 
            on m1_0.id=c1_0.member_id 
    where
        c1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [9] 
Hibernate: 
    select
        count(t1_0.id) 
    from
        template t1_0 
    where
        1=1
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateJpaRepository.findAll 실행 84ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateService.findAll 실행 84ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [1] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [53] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [81] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [95] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [123] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 7ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 7ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [1] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [1] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 4ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [2] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [185] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [2] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [5] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 3ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [3] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [159] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [199] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [3] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [8] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 3ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [4] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [37] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [72] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [165] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [169] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 4ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 4ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [4] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [13] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [5] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [149] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [5] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [16] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [6] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [82] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [98] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [142] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [154] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 4ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 4ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [6] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [18] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 3ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [7] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [23] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [58] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 2ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [7] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [23] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [8] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [47] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [52] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [68] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [102] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [198] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 5ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 5ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [8] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [25] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [9] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [33] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [78] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [89] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 4ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 4ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [9] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [26] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [10] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [9] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [32] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [115] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [188] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 4ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [10] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [29] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 1ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 1ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [11] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [97] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [11] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [31] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 1ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [12] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [111] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [129] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [136] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [140] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [12] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [34] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [13] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [22] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [196] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [13] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [37] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 1ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 1ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [14] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [65] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [74] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [179] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [14] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [42] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [15] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 1ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 1ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [15] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [44] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [16] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [61] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [70] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [170] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [16] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [49] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [17] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [50] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [88] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 5ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 5ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [17] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [53] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [18] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [83] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 2ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [18] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [56] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [19] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [18] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 2ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [19] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [60] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at 
    from
        template_tag tt1_0 
    where
        tt1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [20] 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        tag t1_0 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [128] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplate 실행 3ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateTagService.getByTemplate 실행 3ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    where
        t1_0.template_id=?
⚡️ binding parameter (1:BIGINT) <- [20] 
Hibernate: 
    select
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id 
    from
        source_code sc1_0 
    where
        sc1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [64] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.fetchByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getByTemplate 실행 2ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateApplicationService.findAllBy 실행 195ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [1] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 2ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [2] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [3] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [4] 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:22][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [5] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [6] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [7] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [8] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 0ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 0ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [9] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [10] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [11] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [12] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 0ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 0ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [13] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [14] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [15] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [16] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [17] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 0ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 0ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [18] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [19] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 1ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 1ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        template t1_0 
    join
        member m1_0 
            on m1_0.id=t1_0.member_id 
    where
        t1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [20] 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberJpaRepository.fetchByTemplateId 실행 0ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberService.getByTemplateId 실행 0ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] MemberTemplateApplicationService.getAllTemplatesBy 실행 213ms 
[INFO][09-25 19:59:23][f87afa5d][c.g.l.MethodExecutionTimeAspect] TemplateController.getTemplates 실행 214ms 

[jminkkk]

1. N + 1 개선하기

태그 조회 개선하기

TemplateTagJpaRepository.findAllByTemplate() -> TemplateTag(1) + Tag(N)

개선 전

fetch join 적용 후

@Query("""
        SELECT tt, t
        FROM TemplateTag tt
        JOIN FETCH tt.tag t
        WHERE tt.id.templateId = :templateId
        """)
List<TemplateTag> findAllByTemplate(Template template);

---

썸네일 조회 개선하기

개선 전

fetch join 적용 후

@Query("""
        SELECT t, sc
        FROM Thumbnail t
        join fetch t.sourceCode sc
        WHERE t.template = :template
        """)

개선 시간

개선 전

(멤버만 조건으로 검색)

Total request count: 1000
Total elapsed time: 177783ms
Average elapsed time: 177ms

개선 후

(멤버만 조건으로 검색)

Total request count: 1000
Total elapsed time: 12344ms
Average elapsed time: 123ms

1.43 배 개선

[jminkkk]

2. 서비스단 로직 개선

개선 전 로직

검색하여 템플릿 목록을 조회(templateService.findAll)

-> 응답 Response를 만드면서 makeTemplatesResponse 호출

-> 조회한 template 하나하나를 순회하면서 템플릿 태그와 썸네일을 다시 조회

-> 템플릿 태그와 썸네일은 template 수만큼 호출됨

개선 후 로직

검색하여 템플릿 목록을 조회(templateService.findAll)

-> 응답 Response를 만드면서 makeTemplatesResponse 호출

-> 조회한 template 목록 전체를 넘겨 템플릿 태그와 썸네일 목록 조회

-> 템플릿 태그와 썸네일 목록은 한번만 조회

개선 전

(멤버만 조건으로 검색)

Total request count: 1000
Total elapsed time: 177783ms
Average elapsed time: 177ms

개선 후

Total request count: 1000
Total elapsed time: 64133ms
Average elapsed time: 64ms

2.7배 개선 (처음 시간과 비교)

[jminkkk]

멤버만 조건으로 검색

• 개선 전 시간

  • Total elapsed time: 177783ms
  • Average elapsed time: 177ms

• 개선 후

  • Total elapsed time: 64133ms
  • Average elapsed time: 64ms

카테고리만 조회 (2.9배 개선)

• 개선 전 시간

  • Total elapsed time: 142164ms
  • Average elapsed time: 142ms

• 개선 후

  • Total elapsed time: 49060ms
  • Average elapsed time: 49ms

태그들만 조회 (1.6배 개선)

• 개선 전 시간

  • Total elapsed time: 204150ms
  • Average elapsed time: 204ms

• 개선 후

  • Total elapsed time: 129075ms
  • Average elapsed time: 129ms

월등히 개선된 것을 확인할 수 있다.

🔥 여전히 문제 🔥

키워드만 조회 (그대로)

• 개선 전 시간

  • Total elapsed time: 1200642ms
  • Average elapsed time: 1200ms

• 개선 후

  • Total elapsed time: 1262576ms
  • Average elapsed time: 1262ms

키워드를 포함한 조회 시 이전 개선 사항들이 유의미하지 않다....ㅠ

이유 분석

키워드가 검색 조건으로 들어갈 경우
템플릿의 제목, 설명, 소스코드 목록 중 내용, 파일명에서 Like 연산을 통해 일치하는 템플릿을 조회해온다

    select
        t1_0.id,
// ... 생략
    where
        (
            t1_0.title like ? escape '' 
            or t1_0.description like ? escape '' 
            or t1_0.id in ((select
                sc1_0.template_id 
            from
                source_code sc1_0 
            where
                sc1_0.content like ? escape '' 
                or sc1_0.filename like ? escape ''))
        ) 
    limit
        ?, ?

[jminkkk]

MySQL Full Text Index 적용

기존 검색
6배 개선!!!!!!!!!!!!~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

---

public class TemplateSpecification implements Specification<Template> {
    private final Long memberId;
    private final String keyword;
    private final Long categoryId;
    private final List<Long> tagIds;

    public TemplateSpecification(
            Long memberId,
            String keyword,
            Long categoryId,
            List<Long> tagIds
    ) {
        this.memberId = memberId;
        this.keyword = keyword;
        this.categoryId = categoryId;
        this.tagIds = tagIds;
    }

    @Override
    public Predicate toPredicate(Root<Template> root, CriteriaQuery<?> query, CriteriaBuilder criteriaBuilder) {
        // 생략
        if (query.getResultType().equals(Template.class)) {
            root.fetch("category", JoinType.LEFT);
            root.fetch("member", JoinType.LEFT);
        }

        return criteriaBuilder.and(predicates.toArray(new Predicate[0]));
    }

    private void addKeywordPredicate(List<Predicate> predicates, CriteriaBuilder criteriaBuilder, Root<Template> root,
            CriteriaQuery<?> query
    ) {
        if (keyword != null && !keyword.trim().isEmpty()) {
            String searchKeyword = keyword.trim();

            // Full-Text Search를 위한 Predicate 추가
            Predicate titleDescriptionPredicate = criteriaBuilder.isTrue(
                    criteriaBuilder.function("MATCH", Boolean.class,
                            root.get("title"), root.get("description"),
                            criteriaBuilder.literal(searchKeyword)));

            // SourceCode에 대한 Full-Text Search 추가
            Subquery<Long> sourceCodeSubquery = query.subquery(Long.class);
            Root<SourceCode> sourceCodeRoot = sourceCodeSubquery.from(SourceCode.class);
            sourceCodeSubquery.select(sourceCodeRoot.get("template").get("id"));
            sourceCodeSubquery.where(criteriaBuilder.isTrue(
                    criteriaBuilder.function("MATCH", Boolean.class,
                            sourceCodeRoot.get("content"), sourceCodeRoot.get("filename"),
                            criteriaBuilder.literal(searchKeyword))));

            predicates.add(criteriaBuilder.or(titleDescriptionPredicate, root.get("id").in(sourceCodeSubquery)));
        }
    }
            // 생략
}

사용자 정의 함수(match against) dialect 사용하기

[jminkkk]

[jminkkk]

Hibernate: 
    select
        t1_0.id,
        t1_0.category_id,
        t1_0.created_at,
        t1_0.description,
        (select
            count(*) 
        from
            likes 
        where
            likes.template_id = t1_0.id),
        t1_0.member_id,
        t1_0.modified_at,
        t1_0.title 
    from
        template t1_0 
    where
        t1_0.member_id=? 
        and t1_0.category_id=? 
        and (
            t1_0.title like ? escape '' 
            or t1_0.description like ? escape '' 
            or t1_0.id in ((select
                sc1_0.template_id 
            from
                source_code sc1_0 
            where
                sc1_0.content like ? escape '' 
                or sc1_0.filename like ? escape ''))
        ) 
    limit
        ?, ?
⚡️ binding parameter (1:BIGINT) <- [1] 
⚡️ binding parameter (2:BIGINT) <- [1] 
⚡️ binding parameter (3:VARCHAR) <- [%join%] 
⚡️ binding parameter (4:VARCHAR) <- [%join%] 
⚡️ binding parameter (5:VARCHAR) <- [%join%] 
⚡️ binding parameter (6:VARCHAR) <- [%join%] 
⚡️ binding parameter (7:INTEGER) <- [0] 
⚡️ binding parameter (8:INTEGER) <- [20] 
Hibernate: 
    select
        count(t1_0.id) 
    from
        template t1_0 
    where
        t1_0.member_id=? 
        and t1_0.category_id=? 
        and (
            t1_0.title like ? escape '' 
            or t1_0.description like ? escape '' 
            or t1_0.id in ((select
                sc1_0.template_id 
            from
                source_code sc1_0 
            where
                sc1_0.content like ? escape '' 
                or sc1_0.filename like ? escape ''))
        )
⚡️ binding parameter (1:BIGINT) <- [1] 
⚡️ binding parameter (2:BIGINT) <- [1] 
⚡️ binding parameter (3:VARCHAR) <- [%join%] 
⚡️ binding parameter (4:VARCHAR) <- [%join%] 
⚡️ binding parameter (5:VARCHAR) <- [%join%] 
⚡️ binding parameter (6:VARCHAR) <- [%join%] 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.MethodExecutionTimeAspect] TemplateJpaRepository.findAll 실행 50ms 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.MethodExecutionTimeAspect] TemplateService.findAllBy 실행 51ms 
Hibernate: 
    select
        tt1_0.tag_id,
        tt1_0.template_id,
        tt1_0.created_at,
        tt1_0.modified_at,
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.name 
    from
        template_tag tt1_0 
    join
        tag t1_0 
            on t1_0.id=tt1_0.tag_id 
    where
        tt1_0.template_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
⚡️ binding parameter (1:BIGINT) <- [6] 
⚡️ binding parameter (2:BIGINT) <- [17] 
⚡️ binding parameter (3:BIGINT) <- [32] 
⚡️ binding parameter (4:BIGINT) <- [137] 
⚡️ binding parameter (5:BIGINT) <- [144] 
⚡️ binding parameter (6:BIGINT) <- [217] 
⚡️ binding parameter (7:BIGINT) <- [275] 
⚡️ binding parameter (8:BIGINT) <- [286] 
⚡️ binding parameter (9:BIGINT) <- [356] 
⚡️ binding parameter (10:BIGINT) <- [435] 
⚡️ binding parameter (11:BIGINT) <- [555] 
⚡️ binding parameter (12:BIGINT) <- [574] 
⚡️ binding parameter (13:BIGINT) <- [666] 
⚡️ binding parameter (14:BIGINT) <- [785] 
⚡️ binding parameter (15:BIGINT) <- [876] 
⚡️ binding parameter (16:BIGINT) <- [1042] 
⚡️ binding parameter (17:BIGINT) <- [1081] 
⚡️ binding parameter (18:BIGINT) <- [1097] 
⚡️ binding parameter (19:BIGINT) <- [1099] 
⚡️ binding parameter (20:BIGINT) <- [1111] 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.MethodExecutionTimeAspect] TemplateTagJpaRepository.findAllByTemplateIdsIn 실행 18ms 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.MethodExecutionTimeAspect] TagService.getAllTemplateTagsByTemplates 실행 19ms 
Hibernate: 
    select
        t1_0.id,
        t1_0.created_at,
        t1_0.modified_at,
        t1_0.source_code_id,
        sc1_0.id,
        sc1_0.content,
        sc1_0.created_at,
        sc1_0.filename,
        sc1_0.modified_at,
        sc1_0.ordinal,
        sc1_0.template_id,
        t1_0.template_id 
    from
        thumbnail t1_0 
    join
        source_code sc1_0 
            on sc1_0.id=t1_0.source_code_id 
    where
        t1_0.template_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
⚡️ binding parameter (1:BIGINT) <- [6] 
⚡️ binding parameter (2:BIGINT) <- [17] 
⚡️ binding parameter (3:BIGINT) <- [32] 
⚡️ binding parameter (4:BIGINT) <- [137] 
⚡️ binding parameter (5:BIGINT) <- [144] 
⚡️ binding parameter (6:BIGINT) <- [217] 
⚡️ binding parameter (7:BIGINT) <- [275] 
⚡️ binding parameter (8:BIGINT) <- [286] 
⚡️ binding parameter (9:BIGINT) <- [356] 
⚡️ binding parameter (10:BIGINT) <- [435] 
⚡️ binding parameter (11:BIGINT) <- [555] 
⚡️ binding parameter (12:BIGINT) <- [574] 
⚡️ binding parameter (13:BIGINT) <- [666] 
⚡️ binding parameter (14:BIGINT) <- [785] 
⚡️ binding parameter (15:BIGINT) <- [876] 
⚡️ binding parameter (16:BIGINT) <- [1042] 
⚡️ binding parameter (17:BIGINT) <- [1081] 
⚡️ binding parameter (18:BIGINT) <- [1097] 
⚡️ binding parameter (19:BIGINT) <- [1099] 
⚡️ binding parameter (20:BIGINT) <- [1111] 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.MethodExecutionTimeAspect] ThumbnailJpaRepository.findAllByTemplateIn 실행 8ms 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.MethodExecutionTimeAspect] ThumbnailService.getAllByTemplates 실행 8ms 
Hibernate: 
    select
        m1_0.id,
        m1_0.created_at,
        m1_0.modified_at,
        m1_0.name,
        m1_0.password,
        m1_0.salt 
    from
        member m1_0 
    where
        m1_0.id=?
⚡️ binding parameter (1:BIGINT) <- [1] 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.MethodExecutionTimeAspect] TemplateApplicationService.findAllBy 실행 80ms 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.MethodExecutionTimeAspect] TemplateController.findAllTemplates 실행 80ms 
[INFO][09-27 00:04:56][a8297b2e][c.g.l.RequestResponseLogger] [Request] GET /templates, 헤더 값: host : localhost:8080
connection : keep-alive
cache-control : max-age=0
sec-ch-ua : "Whale";v="3", "Not-A.Brand";v="8", "Chromium";v="126"
sec-ch-ua-mobile : ?0
sec-ch-ua-platform : "macOS"
upgrade-insecure-requests : 1
user-agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Whale/3.27.254.15 Safari/537.36
accept : text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
sec-fetch-site : none
sec-fetch-mode : navigate
sec-fetch-user : ?1
sec-fetch-dest : document
accept-encoding : gzip, deflate, br, zstd
accept-language : ko-KR,ko;q=0.9,en-US;q=0.8,en;q=0.7
cookie : ngrinder-remember-me=YWRtaW46MTcyODIxNDM3MTUwNDo1ZjRhYzlkNTg5OGU3YmJlMDAyNGE2ZThmMGYwYzJlNQ; naveruserlocale=kr; JSESSIONID=6D43BE62A67C4D5BD2791198C27748C1
 
 요청 바디:  
[INFO][09-27 00:04:56][a8297b2e][c.g.l.RequestResponseLogger] [Response] Status: 200, Duration: 86ms, 헤더 값: Vary : Origin
Vary : Origin
Vary : Origin 
 응답 바디: {"totalPages":5,"totalElements":91,"templates":[{"id":6,"member":{"id":1,"name":"melissaporter"},"title":"Walk sell behavior partner campaign beat recent.","description":"Available writer tree evening senior. Product source tell executive. Interest movement range development.","tags":[{"id":48,"name":"by"},{"id":59,"name":"while"},{"id":199,"name":"front"}],"thumbnail":{"filename":"glass.odt","content":"Behind hard receive hair.\nLevel close behavior young. Remember expect feeling race into yeah base.\nWant base generation society cultural."},"likesCount":0,"isLiked":false,"createdAt":"2024-05-16 19:42:57","modifiedAt":"2024-09-10 19:40:27"},{"id":17,"member":{"id":1,"name":"melissaporter"},"title":"Good agency because.","description":"With throughout life high. Professional success often factor standard maintain very.","tags":[{"id":26,"name":"talk"},{"id":40,"name":"nothing"},{"id":91,"name":"item"},{"id":113,"name":"already"},{"id":168,"name":"be"}],"thumbnail":{"filename":"anything.jpeg","content":"Issue save key real mouth serious address sister. Support car young hair bit must. Performance indicate fish enter. Make right father wait staff.\nEverybody I might camera Congress dinner top."},"likesCount":0,"isLiked":false,"createdAt":"2024-07-13 06:21:17","modifiedAt":"2024-09-22 22:36:35"},{"id":32,"member":{"id":1,"name":"melissaporter"},"title":"Senior write woman knowledge line century tax.","description":"Population year body wish state. Catch tonight loss few must. Various win rich old source camera worker list.","tags":[{"id":13,"name":"work"},{"id":49,"name":"whole"},{"id":55,"name":"long"}],"thumbnail":{"filename":"check.webm","content":"Charge probably would important last.\nSoon join such who key term. Discussion school reach song young price arm ten."},"likesCount":0,"isLiked":false,"createdAt":"2024-03-11 00:50:55","modifiedAt":"2024-09-04 20:33:43"},{"id":137,"member":{"id":1,"name":"melissaporter"},"title":"Improve thought line similar different.","description":"Member thought nothing. Yet specific reflect join affect room. Five over itself range tonight long study.","tags":[{"id":32,"name":"movement"},{"id":35,"name":"goal"},{"id":49,"name":"whole"},{"id":100,"name":"past"},{"id":187,"name":"hundred"}],"thumbnail":{"filename":"must.webm","content":"Before off support event great person onto. Person discover great life. Might minute lose list situation nearly receive."},"likesCount":0,"isLiked":false,"createdAt":"2024-02-19 01:13:02","modifiedAt":"2024-09-24 16:09:01"},{"id":144,"member":{"id":1,"name":"melissaporter"},"title":"Cover glass dark.","description":"Bad fill small reach good. Respond season line. Left husband against development.\nJoin site produce recent nation store left. Fire watch mention part leave such.","tags":[{"id":21,"name":"recent"},{"id":64,"name":"listen"},{"id":72,"name":"hope"}],"thumbnail":{"filename":"keep.wav","content":"Message different cover career federal. Skill hear hour.\nMorning popular property quickly alone them. Age write middle name."},"likesCount":0,"isLiked":false,"createdAt":"2024-01-23 11:31:35","modifiedAt":"2024-09-24 11:30:39"},{"id":217,"member":{"id":1,"name":"melissaporter"},"title":"Myself raise remain turn enjoy bring indicate.","description":"Institution will hand spring where. Check garden me worry return.","tags":[{"id":82,"name":"day"},{"id":166,"name":"foot"}],"thumbnail":{"filename":"alone.odt","content":"Positive gas call television possible rule energy. Treat north week century entire present. Generation window sing."},"likesCount":0,"isLiked":false,"createdAt":"2024-07-12 15:08:17","modifiedAt":"2024-09-14 23:07:57"},{"id":275,"member":{"id":1,"name":"melissaporter"},"title":"Magazine feeling guess character bad carry husband.","description":"Performance onto leg reflect into cause bring. Whom leg property above. Piece identify behavior relate civil at item resource. Effort clearly dream player off star.","tags":[{"id":56,"name":"not"},{"id":62,"name":"thing"},{"id":83,"name":"onto"},{"id":140,"name":"movement"},{"id":171,"name":"suffer"}],"thumbnail":{"filename":"section.png","content":"Part around join add often heavy job important. Article certainly finish. Sister image defense so sign guy.\nInteresting stand court yes president red hot. Trouble say yard suggest member paper west."},"likesCount":0,"isLiked":false,"createdAt":"2024-01-07 13:27:26","modifiedAt":"2024-09-24 22:27:07"},{"id":286,"member":{"id":1,"name":"melissaporter"},"title":"Wrong prove than feeling how lose idea.","description":"Better child low more there employee. Dream day list affect.","tags":[{"id":26,"name":"talk"},{"id":51,"name":"argue"},{"id":158,"name":"service"}],"thumbnail":{"filename":"actually.png","content":"History rate rise mission fear outside coach. Staff loss rich join. Develop someone democratic total let land."},"likesCount":0,"isLiked":false,"createdAt":"2024-01-17 22:04:19","modifiedAt":"2024-09-22 05:43:31"},{"id":356,"member":{"id":1,"name":"melissaporter"},"title":"Follow throughout order throughout.","description":"This make student day. Dream long task allow really tend thing. Attention service television never want.\nLater national one.","tags":[{"id":35,"name":"goal"},{"id":70,"name":"police"},{"id":86,"name":"middle"}],"thumbnail":{"filename":"realize.html","content":"Society face either continue wear meeting them. Ball much join.\nFish forget I majority so hour mean. Nor another live use wonder seven federal kitchen."},"likesCount":0,"isLiked":false,"createdAt":"2024-03-20 11:05:00","modifiedAt":"2024-09-10 14:37:52"},{"id":435,"member":{"id":1,"name":"melissaporter"},"title":"Reason mission parent.","description":"Case become power still avoid nice. Why surface model away meet person able. Effect few whom these off.","tags":[{"id":37,"name":"body"},{"id":49,"name":"whole"}],"thumbnail":{"filename":"star.mp4","content":"Air scene property so wish according. Chair foot identify get suffer allow. Establish sit land interview carry.\nProtect actually commercial anyone off. Miss pass either book really serious."},"likesCount":0,"isLiked":false,"createdAt":"2024-07-17 23:29:51","modifiedAt":"2024-09-06 02:49:15"},{"id":555,"member":{"id":1,"name":"melissaporter"},"title":"Tough top important nature push lay.","description":"Town want join better cold. Buy brother strong truth mind PM and. Trouble quickly field event character baby.","tags":[{"id":108,"name":"argue"},{"id":143,"name":"building"},{"id":164,"name":"edge"},{"id":180,"name":"increase"}],"thumbnail":{"filename":"professional.json","content":"Security picture talk. Shake leader ahead sure language money fast.\nResponse price goal figure room war difficult."},"likesCount":0,"isLiked":false,"createdAt":"2024-09-07 07:30:09","modifiedAt":"2024-09-11 01:09:53"},{"id":574,"member":{"id":1,"name":"melissaporter"},"title":"Figure evening painting analysis contain protect.","description":"Parent do likely risk. Wear onto this detail.\nGas drop tell present out.\nUse close throw it.","tags":[{"id":73,"name":"short"},{"id":81,"name":"trip"},{"id":99,"name":"director"},{"id":163,"name":"event"},{"id":183,"name":"every"}],"thumbnail":{"filename":"through.csv","content":"Myself my difficult doctor reduce standard. Impact front professional test open single catch. Join civil pattern chance teacher resource down find."},"likesCount":0,"isLiked":false,"createdAt":"2024-02-20 12:05:56","modifiedAt":"2024-09-11 08:45:42"},{"id":666,"member":{"id":1,"name":"melissaporter"},"title":"Event up partner event.","description":"Wrong yet only money believe thank particular. Economic agreement education strategy.\nParent such computer live camera. Bank my left heavy daughter according remain. Pay then economic consider.","tags":[{"id":16,"name":"three"},{"id":70,"name":"police"},{"id":120,"name":"two"},{"id":154,"name":"part"},{"id":182,"name":"amount"}],"thumbnail":{"filename":"impact.mp4","content":"Build exactly have discover class though doctor. Join might candidate really. Again brother rate if anyone way whole. Never describe thus performance."},"likesCount":0,"isLiked":false,"createdAt":"2024-06-15 12:54:42","modifiedAt":"2024-09-11 17:02:44"},{"id":785,"member":{"id":1,"name":"melissaporter"},"title":"Size easy choose view claim officer.","description":"Miss off involve stock whether study. Under writer sister sport protect mind agree kid. For tonight officer over.\nFace water act road bill.","tags":[{"id":95,"name":"decade"},{"id":133,"name":"writer"},{"id":150,"name":"room"}],"thumbnail":{"filename":"agency.mp4","content":"Million whom herself. Out out two. Program seven front through.\nOff tend attention population all."},"likesCount":0,"isLiked":false,"createdAt":"2024-09-17 17:20:43","modifiedAt":"2024-09-15 09:06:00"},{"id":876,"member":{"id":1,"name":"melissaporter"},"title":"Current north with over.","description":"Voice deep join throw really organization. Without response bit artist. Special spend team.\nAccording word school drop whose blood mind. Executive some some think phone. Ball all imagine.","tags":[{"id":106,"name":"instead"},{"id":114,"name":"ask"}],"thumbnail":{"filename":"garden.xlsx","content":"Easy huge culture threat. They high enter fast threat such ball. Draw agree true better home your. Go get floor benefit enjoy behind."},"likesCount":0,"isLiked":false,"createdAt":"2024-09-02 14:47:34","modifiedAt":"2024-09-11 06:35:44"},{"id":1042,"member":{"id":1,"name":"melissaporter"},"title":"Still course care pass quality identify.","description":"Analysis least know resource none already employee. Me high recently these after.\nBeyond firm contain maybe accept. Occur end join war resource wide newspaper. Lay yes two Mrs.","tags":[{"id":32,"name":"movement"}],"thumbnail":{"filename":"international.mp4","content":"Budget call administration individual. Value prove strategy stay attack long above. Contain traditional still big guy.\nResult house child there consumer. Among about eight whatever as answer."},"likesCount":0,"isLiked":false,"createdAt":"2024-03-22 11:30:08","modifiedAt":"2024-09-01 16:49:53"},{"id":1081,"member":{"id":1,"name":"melissaporter"},"title":"Those full trip scientist garden control.","description":"Available popular likely accept behind sport. Over field social situation again score time the. Per building view back total six.\nMinute spring theory. Water while cost them break. Wear someone fact.","tags":[{"id":98,"name":"particularly"}],"thumbnail":{"filename":"production.js","content":"Not green personal join two thousand player. Sea story two together join high ok. If our administration through lose."},"likesCount":0,"isLiked":false,"createdAt":"2024-02-04 03:34:11","modifiedAt":"2024-09-21 04:45:13"},{"id":1097,"member":{"id":1,"name":"melissaporter"},"title":"Product everything government minute offer.","description":"Performance wonder property. All type throughout thought.\nBill manager kind yeah name. Cut available even interest woman heavy hospital. Return understand deal one within consumer Mrs.","tags":[{"id":14,"name":"series"},{"id":122,"name":"sort"},{"id":148,"name":"which"}],"thumbnail":{"filename":"most.html","content":"Figure popular much fact central. Hour whether someone send degree special explain.\nSchool themselves grow chair second be. Treatment hair growth teacher number. Across understand natural leg."},"likesCount":0,"isLiked":false,"createdAt":"2024-01-12 04:44:11","modifiedAt":"2024-09-20 21:03:35"},{"id":1099,"member":{"id":1,"name":"melissaporter"},"title":"Anything cover skill area.","description":"Water water whole brother smile. Executive travel report how what region. Scientist tax government write woman million would. Place feel if.","tags":[{"id":13,"name":"work"},{"id":34,"name":"gas"},{"id":105,"name":"college"},{"id":110,"name":"fly"}],"thumbnail":{"filename":"attorney.jpeg","content":"Future true degree raise week sure door. Thing director argue.\nPopulation fire age share miss power agency. Performance cold ever decision give rest middle choice."},"likesCount":0,"isLiked":false,"createdAt":"2024-05-15 07:47:40","modifiedAt":"2024-09-10 07:55:15"},{"id":1111,"member":{"id":1,"name":"melissaporter"},"title":"Project western fact cover moment newspaper lose.","description":"Foreign realize would back ready just group report. Do expect help hot chance. Price wait television before.","tags":[{"id":38,"name":"education"},{"id":90,"name":"southern"},{"id":126,"name":"exist"},{"id":158,"name":"service"},{"id":183,"name":"every"}],"thumbnail":{"filename":"these.xls","content":"Catch maybe focus use. Will student dog what indeed involve system network. Action statement set claim understand."},"likesCount":0,"isLiked":false,"createdAt":"2024-04-19 04:01:13","modifiedAt":"2024-09-14 03:35:47"}]}