주문 이력 조회

1) OrderItemDto 생성

package com.shop.dto;

import com.shop.entity.OrderItem;
import lombok.Getter;
import lombok.Setter;

@Getter
@Setter
public class OrderItemDto {
    private String itemNm;
    private int count;
    private int orderPrice;
    private String imgUrl;

    public OrderItemDto(OrderItem orderItem, String imgUrl) {
        this.itemNm = orderItem.getItem().getItemNm();
        this.count = orderItem.getCount();
        this.orderPrice = orderItem.getOrderPrice();
        this.imgUrl = imgUrl;
    }
}

 

2) OrderHistDto 생성

package com.shop.dto;

import com.shop.constant.OrderStatus;
import com.shop.entity.Order;
import lombok.Getter;
import lombok.Setter;

import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;

@Getter
@Setter
public class OrderHistDto {
    private Long orderId;
    private String orderDate;
    private OrderStatus orderStatus;
    private List<OrderItemDto> orderItemDtoList = new ArrayList<>();

    public OrderHistDto(Order order) {
        this.orderId = order.getId();
        this.orderDate = order.getOrderDate().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm"));
        this.orderStatus = order.getOrderStatus();
    }

    public void addOrderItemDto(OrderItemDto orderItemDto){
        orderItemDtoList.add(orderItemDto);
    }
}

 

3) 인터페이스 생성

- 단순 쿼리 라서 @Query 이용

package com.shop.repository;

import com.shop.entity.Order;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface OrderRepository extends JpaRepository<Order, Long> {
    @Query("select o from Order o where o.member.email = :email order by o.orderDate desc")
    List<Order> findOrders(@Param("email") String email, Pageable pageable);

    @Query("select count(o) from Order o where o.member.email = :email")
    Long countOrder(@Param("email") String email);
}

 

- 주문이력에 이미지를 표현하기위해 인터페이스 생성

package com.shop.repository;

import com.shop.entity.ItemImg;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;

public interface ItemImgRepository extends JpaRepository<ItemImg, Long> {
    List<ItemImg> findByItemIdOrderByIdAsc(Long itemId);

    ItemImg findByItemIdAndRepimgYn(Long itemId, String repimgYn);
}

 

4) 서비스 구현

package com.shop.service;

import com.shop.dto.OrderDto;
import com.shop.dto.OrderHistDto;
import com.shop.dto.OrderItemDto;
import com.shop.entity.*;
import com.shop.repository.ItemImgRepository;
import com.shop.repository.ItemRepository;
import com.shop.repository.MemberRepository;
import com.shop.repository.OrderRepository;
import lombok.RequiredArgsConstructor;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageImpl;
import org.springframework.data.domain.Pageable;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.thymeleaf.util.StringUtils;

import javax.persistence.EntityNotFoundException;
import java.util.ArrayList;
import java.util.List;

@Service
@Transactional
@RequiredArgsConstructor
public class OrderService {
    private final ItemRepository itemRepository;
    private final MemberRepository memberRepository;
    private final OrderRepository orderRepository;
    private final ItemImgRepository itemImgRepository;

    ...
    
    @Transactional(readOnly = true)
    public Page<OrderHistDto> getOrderList(String email, Pageable pageable){
        List<Order> orders = orderRepository.findOrders(email, pageable);
        Long totalCount = orderRepository.countOrder(email);

        List<OrderHistDto> orderHistDtos = new ArrayList<>();

        for(Order order : orders){
            OrderHistDto orderHistDto = new OrderHistDto(order);
            List<OrderItem> orderItems = order.getOrderItems();
            for(OrderItem orderItem : orderItems){
                ItemImg itemImg = itemImgRepository.findByItemIdAndRepimgYn(orderItem.getItem().getId(), "Y");
                OrderItemDto orderItemDto = new OrderItemDto(orderItem, itemImg.getImgUrl());
                orderHistDto.addOrderItemDto(orderItemDto);
            }
            orderHistDtos.add(orderHistDto);
        }
        return new PageImpl<>(orderHistDtos, pageable, totalCount);
    }
}

 

5) 컨트롤러 구현

package com.shop.controller;

import com.shop.dto.OrderDto;
import com.shop.dto.OrderHistDto;
import com.shop.service.OrderService;
import lombok.RequiredArgsConstructor;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.validation.FieldError;
import org.springframework.web.bind.annotation.*;

import javax.validation.Valid;
import java.security.Principal;
import java.util.List;
import java.util.Optional;

@Controller
@RequiredArgsConstructor
public class OrderController {
    private final OrderService orderService;

    ...

    @GetMapping(value = {"/orders", "/orders/{page}"})
    public String orderHist(@PathVariable("page")Optional<Integer> page, Principal principal, Model model){
        Pageable pageable = PageRequest.of(page.isPresent() ? page.get() : 0, 4);
        Page<OrderHistDto> orderHistDtoList = orderService.getOrderList(principal.getName(), pageable);
        model.addAttribute("orders", orderHistDtoList);
        model.addAttribute("page", pageable.getPageNumber());
        model.addAttribute("maxPage",5);
        return "order/orderHist";
    }

}

 

6) orderHist.html 구현

코드 길어서 아래 링크 참고

https://github.com/gusrl6394/SpringbootShop/blob/master/src/main/resources/templates/order/orderHist.html

 

결과)

 

---

주문 이력많을수록 쿼리조회 부담감이 생기는것을 아래를 통해 볼수있다. (55번째줄)

2022-02-09 16:15:27.288 DEBUG 5304 --- [p-nio-80-exec-3] org.hibernate.SQL                        : 
    select
        orderitems0_.order_id as order_id9_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.reg_time as reg_time2_5_1_,
        orderitems0_.update_time as update_t3_5_1_,
        orderitems0_.create_by as create_b4_5_1_,
        orderitems0_.modified_by as modified5_5_1_,
        orderitems0_.count as count6_5_1_,
        orderitems0_.item_id as item_id8_5_1_,
        orderitems0_.order_id as order_id9_5_1_,
        orderitems0_.order_price as order_pr7_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
Hibernate: 
    select
        orderitems0_.order_id as order_id9_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.reg_time as reg_time2_5_1_,
        orderitems0_.update_time as update_t3_5_1_,
        orderitems0_.create_by as create_b4_5_1_,
        orderitems0_.modified_by as modified5_5_1_,
        orderitems0_.count as count6_5_1_,
        orderitems0_.item_id as item_id8_5_1_,
        orderitems0_.order_id as order_id9_5_1_,
        orderitems0_.order_price as order_pr7_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [20]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [21]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([reg_time2_5_1_] : [TIMESTAMP]) - [2022-02-09T16:07:30.357329]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([update_t3_5_1_] : [TIMESTAMP]) - [2022-02-09T16:07:30.357329]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([create_b4_5_1_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([modified5_5_1_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count6_5_1_] : [INTEGER]) - [1]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id8_5_1_] : [BIGINT]) - [2]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_1_] : [BIGINT]) - [20]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr7_5_1_] : [INTEGER]) - [50000]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_0_] : [BIGINT]) - [20]
2022-02-09 16:15:27.289 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [21]

 

2022-02-09 16:15:49.964 DEBUG 5304 --- [p-nio-80-exec-3] org.hibernate.SQL                        : 
    select
        orderitems0_.order_id as order_id9_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.reg_time as reg_time2_5_1_,
        orderitems0_.update_time as update_t3_5_1_,
        orderitems0_.create_by as create_b4_5_1_,
        orderitems0_.modified_by as modified5_5_1_,
        orderitems0_.count as count6_5_1_,
        orderitems0_.item_id as item_id8_5_1_,
        orderitems0_.order_id as order_id9_5_1_,
        orderitems0_.order_price as order_pr7_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
Hibernate: 
    select
        orderitems0_.order_id as order_id9_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.reg_time as reg_time2_5_1_,
        orderitems0_.update_time as update_t3_5_1_,
        orderitems0_.create_by as create_b4_5_1_,
        orderitems0_.modified_by as modified5_5_1_,
        orderitems0_.count as count6_5_1_,
        orderitems0_.item_id as item_id8_5_1_,
        orderitems0_.order_id as order_id9_5_1_,
        orderitems0_.order_price as order_pr7_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [18]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [19]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([reg_time2_5_1_] : [TIMESTAMP]) - [2022-02-09T16:07:27.831215]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([update_t3_5_1_] : [TIMESTAMP]) - [2022-02-09T16:07:27.831215]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([create_b4_5_1_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([modified5_5_1_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count6_5_1_] : [INTEGER]) - [2]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id8_5_1_] : [BIGINT]) - [8]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_1_] : [BIGINT]) - [18]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr7_5_1_] : [INTEGER]) - [20000]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_0_] : [BIGINT]) - [18]
2022-02-09 16:15:49.965 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [19]

 

2022-02-09 16:16:04.098 DEBUG 5304 --- [p-nio-80-exec-3] org.hibernate.SQL                        : 
    select
        orderitems0_.order_id as order_id9_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.reg_time as reg_time2_5_1_,
        orderitems0_.update_time as update_t3_5_1_,
        orderitems0_.create_by as create_b4_5_1_,
        orderitems0_.modified_by as modified5_5_1_,
        orderitems0_.count as count6_5_1_,
        orderitems0_.item_id as item_id8_5_1_,
        orderitems0_.order_id as order_id9_5_1_,
        orderitems0_.order_price as order_pr7_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
Hibernate: 
    select
        orderitems0_.order_id as order_id9_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.reg_time as reg_time2_5_1_,
        orderitems0_.update_time as update_t3_5_1_,
        orderitems0_.create_by as create_b4_5_1_,
        orderitems0_.modified_by as modified5_5_1_,
        orderitems0_.count as count6_5_1_,
        orderitems0_.item_id as item_id8_5_1_,
        orderitems0_.order_id as order_id9_5_1_,
        orderitems0_.order_price as order_pr7_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
2022-02-09 16:16:04.098 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [16]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [17]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([reg_time2_5_1_] : [TIMESTAMP]) - [2022-02-09T16:07:19.367288]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([update_t3_5_1_] : [TIMESTAMP]) - [2022-02-09T16:07:19.367288]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([create_b4_5_1_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([modified5_5_1_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count6_5_1_] : [INTEGER]) - [3]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id8_5_1_] : [BIGINT]) - [2]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_1_] : [BIGINT]) - [16]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr7_5_1_] : [INTEGER]) - [50000]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_0_] : [BIGINT]) - [16]
2022-02-09 16:16:04.099 TRACE 5304 --- [p-nio-80-exec-3] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [17]

---

- in 쿼리를 이용해 한번에 조회할수 있도록 설정한다

* JPA를 사용하다보면 N+1 문제를 많이 만나게 되는데 성능상 이슈가 생길 수 있기 때문에 조심해서 사용해야 한다

spring.jpa.properties.hibernate.default_batch_fetch_size=1000

2022-02-09 16:19:47.929 DEBUG 11332 --- [p-nio-80-exec-1] org.hibernate.SQL                        : 
    select
        orderitems0_.order_id as order_id9_5_1_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.reg_time as reg_time2_5_0_,
        orderitems0_.update_time as update_t3_5_0_,
        orderitems0_.create_by as create_b4_5_0_,
        orderitems0_.modified_by as modified5_5_0_,
        orderitems0_.count as count6_5_0_,
        orderitems0_.item_id as item_id8_5_0_,
        orderitems0_.order_id as order_id9_5_0_,
        orderitems0_.order_price as order_pr7_5_0_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id in (
            ?, ?, ?
        )
Hibernate: 
    select
        orderitems0_.order_id as order_id9_5_1_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.reg_time as reg_time2_5_0_,
        orderitems0_.update_time as update_t3_5_0_,
        orderitems0_.create_by as create_b4_5_0_,
        orderitems0_.modified_by as modified5_5_0_,
        orderitems0_.count as count6_5_0_,
        orderitems0_.item_id as item_id8_5_0_,
        orderitems0_.order_id as order_id9_5_0_,
        orderitems0_.order_price as order_pr7_5_0_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id in (
            ?, ?, ?
        )
2022-02-09 16:19:47.930 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [20]
2022-02-09 16:19:47.930 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [18]
2022-02-09 16:19:47.930 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicBinder      : binding parameter [3] as [BIGINT] - [16]
2022-02-09 16:19:47.932 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [17]
2022-02-09 16:19:47.932 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([reg_time2_5_0_] : [TIMESTAMP]) - [2022-02-09T16:07:19.367288]
2022-02-09 16:19:47.932 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([update_t3_5_0_] : [TIMESTAMP]) - [2022-02-09T16:07:19.367288]
2022-02-09 16:19:47.932 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([create_b4_5_0_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:19:47.932 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([modified5_5_0_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:19:47.933 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count6_5_0_] : [INTEGER]) - [3]
2022-02-09 16:19:47.933 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id8_5_0_] : [BIGINT]) - [2]
2022-02-09 16:19:47.933 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_0_] : [BIGINT]) - [16]
2022-02-09 16:19:47.933 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr7_5_0_] : [INTEGER]) - [50000]
2022-02-09 16:19:47.933 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_1_] : [BIGINT]) - [16]
2022-02-09 16:19:47.933 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [17]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [19]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([reg_time2_5_0_] : [TIMESTAMP]) - [2022-02-09T16:07:27.831215]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([update_t3_5_0_] : [TIMESTAMP]) - [2022-02-09T16:07:27.831215]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([create_b4_5_0_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([modified5_5_0_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count6_5_0_] : [INTEGER]) - [2]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id8_5_0_] : [BIGINT]) - [8]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_0_] : [BIGINT]) - [18]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr7_5_0_] : [INTEGER]) - [20000]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_1_] : [BIGINT]) - [18]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [19]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [21]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([reg_time2_5_0_] : [TIMESTAMP]) - [2022-02-09T16:07:30.357329]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([update_t3_5_0_] : [TIMESTAMP]) - [2022-02-09T16:07:30.357329]
2022-02-09 16:19:47.934 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([create_b4_5_0_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:19:47.935 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([modified5_5_0_] : [VARCHAR]) - [test@gmail.com]
2022-02-09 16:19:47.935 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count6_5_0_] : [INTEGER]) - [1]
2022-02-09 16:19:47.935 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id8_5_0_] : [BIGINT]) - [2]
2022-02-09 16:19:47.935 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_0_] : [BIGINT]) - [20]
2022-02-09 16:19:47.935 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr7_5_0_] : [INTEGER]) - [50000]
2022-02-09 16:19:47.935 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id9_5_1_] : [BIGINT]) - [20]
2022-02-09 16:19:47.935 TRACE 11332 --- [p-nio-80-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [21]