P6Spy - มา debug SQL command จาก JPA

package ga.tumit.p6spyspbdemo.member;

import lombok.Getter;
import lombok.Setter;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Getter
@Setter
@Entity(name = "MEMBER")
public class MemberEntity {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long memberId;

    private String memberName;
}

public interface MemberRepository extends JpaRepository<MemberEntity, Long> { }

package ga.tumit.p6spyspbdemo.member;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.Optional;

import static org.assertj.core.api.Assertions.assertThat;

@SpringBootTest
public class MemberRepositoryTest {

    @Autowired
    private MemberRepository memberRepository;

    @Test
    void findById() {
        long id = 999L;
        Optional<MemberEntity> member = memberRepository.findById(id);
        assertThat(member.isPresent()).isFalse();
    }
}

# enable show-sql
spring.jpa.show-sql=true

Hibernate: select memberenti0_.member_id as member_i1_0_0_, memberenti0_.member_name as member_n2_0_0_ from member memberenti0_ where memberenti0_.member_id=?

where memberenti0_.member_id=?

implementation 'com.github.gavlyukovskiy:p6spy-spring-boot-starter:1.8.0'

# p6spy config
decorator.datasource.p6spy.log-format=%(category): %(sql)

Hibernate: select memberenti0_.member_id as member_i1_0_0_, memberenti0_.member_name as member_n2_0_0_ from member memberenti0_ where memberenti0_.member_id=?
2022-02-04 09:10:56  INFO  p6spy.logSQL:60 - statement: select memberenti0_.member_id as member_i1_0_0_, memberenti0_.member_name as member_n2_0_0_ from member memberenti0_ where memberenti0_.member_id=999
2022-02-04 09:10:56  INFO  p6spy.logSQL:60 - commit: 

where memberenti0_.member_id=999