setFirstResult 와 setMaxResults 적용 안되는 문제

[질문 템플릿]
1. 강의 내용과 관련된 질문인가요? (예/아니오)
2. 인프런의 질문 게시판과 자주 하는 질문에 없는 내용인가요? (예/아니오)
3. 질문 잘하기 메뉴얼을 읽어보셨나요? (예/아니오)

[질문 내용]
orderRepository 파일의 findAllWithItem 함수를 통해 데이터를 불러 올때 setFirstResult 과 setMaxResults 를 통해 페이징을 하기로 코드에 설정하였습니다.

하지만 실제로 api(/api/v3.1/orders?offset=1&limit=10)를 호출해보면 jpa를 통해 만들어지는 쿼리에 offset 및 limit 이 적용되지 않고 날라갑니다. 어떤 문제가 있는지 찾아보았으나 찾지 못하여 질문 올립니다.

OrderRepository.java

package jpabook.jpashop.repository;

import jpabook.jpashop.api.OrderSimpleApiController;
import jpabook.jpashop.domain.Order;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Repository;

import javax.persistence.EntityManager;
import java.util.List;

@Repository
@RequiredArgsConstructor
public class OrderRepository {

    private final EntityManager em;

    public void save(Order order) {
        em.persist(order);

    }

    public Order findOne(Long id) {
        return em.find(Order.class, id);
    }

    public List<Order> findAll(OrderSearch orderSearch) {
        return em.createQuery("select o from Order o join o.member m"
                        + " where o.status = :status" +
                        " and m.name like :name", Order.class)
                .setParameter("status", orderSearch.getOrderStatus())
                .setParameter("name", orderSearch.getMemberName())
                .setFirstResult(0)
                .setMaxResults(1000)
                .getResultList();

    }

    public List<Order> findAllWithMemberDelivery() {
        return em.createQuery(
                "select o from Order o" +
                        " join fetch o.member m" +
                        " join fetch o.delivery d", Order.class
        ).getResultList();



    }


    public List<Order> findAllWithItem() {
        return em.createQuery(
                "select distinct o from Order o" +
                        " join fetch o.member m" +
                        " join fetch o.delivery d" +
                        " join fetch o.orderItems oi" +
                        " join fetch oi.item i", Order.class
        ).getResultList();
    }

    public List<Order> findAllWithItem(int offset, int limit) {
        return em.createQuery(
                "select o from Order o" +
                        " join fetch o.member m" +
                        " join fetch o.delivery d", Order.class)
                .setFirstResult(offset)
                .setMaxResults(limit)
                .getResultList();


    }
}

OrderApiController.java

package jpabook.jpashop.api;

import ch.qos.logback.classic.sift.AppenderFactoryUsingJoran;
import jpabook.jpashop.domain.Address;
import jpabook.jpashop.domain.Order;
import jpabook.jpashop.domain.OrderItem;
import jpabook.jpashop.domain.OrderStatus;
import jpabook.jpashop.repository.OrderRepository;
import jpabook.jpashop.repository.OrderSearch;
import lombok.Data;
import lombok.RequiredArgsConstructor;
import org.hibernate.cache.spi.support.AbstractCachedDomainDataAccess;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.time.LocalDateTime;
import java.util.List;
import java.util.stream.Collectors;

@RestController
@RequiredArgsConstructor
public class OrderApiController {
    private final OrderRepository orderRepository;

    @GetMapping("/api/v1/orders")
    public List<Order>  ordersv1() {
        List<Order> all = orderRepository.findAll(new OrderSearch());
        for (Order order : all) {
            order.getMember().getName();
            order.getDelivery().getAddress();
            List<OrderItem> orderItems = order.getOrderItems();
            orderItems.stream().forEach(o-> o.getItem().getName());

        }
        return all;
    }

    @GetMapping("/api/v2/orders")
    public List<OrderDto>  ordersv2() {
        List<Order> orders = orderRepository.findAll(new OrderSearch());
        List<OrderDto> result = orders.stream()
                .map(o -> new OrderDto(o))
                .collect(Collectors.toList());

        return result;
    }

    @GetMapping("/api/v3/orders")
    public List<OrderDto> ordersV3(
            @RequestParam(value = "offset", defaultValue = "0") int offset,
            @RequestParam(value = "limit", defaultValue = "100") int limit
                                   ) {
        List<Order> orders=orderRepository.findAllWithItem(offset, limit );
        List<OrderDto> result = orders.stream()
                .map(o -> new OrderDto(o))
                .collect(Collectors.toList());

        return result;
    }

    @GetMapping("/api/v3.1/orders")
    public List<OrderDto> ordersV3_page() {
        List<Order> orders=orderRepository.findAllWithMemberDelivery();

        List<OrderDto> result = orders.stream()
                .map(o -> new OrderDto(o))
                .collect(Collectors.toList());

        return result;

    }


        @Data
    static class OrderDto {
        private Long orderId;
        private String name;
        private LocalDateTime orderDate;
        private OrderStatus orderStatus;
        private Address address;
        private List<OrderItemDto> orderItems;


        public OrderDto(Order order) {
            orderId =order.getId();
            name= order.getMember().getName();
            orderDate = order.getOrderDate();
            orderStatus = order.getStatus();
            address=order.getDelivery().getAddress();
            orderItems=order.getOrderItems().stream().map(orderItem -> new OrderItemDto(orderItem)).collect(Collectors.toList());

        }

    }

    @Data
    static class OrderItemDto {
        private String itemName;
        private int orderPrice;
        private int count;
        public OrderItemDto(OrderItem orderItem) {
            itemName = orderItem.getItem().getName();
            orderPrice=orderItem.getOrderPrice();
            count=orderItem.getCount();

        }
    }




    }

api 호출시 터미널에 뜨는 메시지

 select
        order0_.order_id as order_id1_6_0_,
        member1_.member_id as member_i1_4_1_,
        delivery2_.delivery_id as delivery1_2_2_,
        order0_.delivery_id as delivery4_6_0_,
        order0_.member_id as member_i5_6_0_,
        order0_.order_date as order_da2_6_0_,
        order0_.status as status3_6_0_,
        member1_.city as city2_4_1_,
        member1_.street as street3_4_1_,
        member1_.zipcode as zipcode4_4_1_,
        member1_.name as name5_4_1_,
        delivery2_.city as city2_2_2_,
        delivery2_.street as street3_2_2_,
        delivery2_.zipcode as zipcode4_2_2_,
        delivery2_.status as status5_2_2_ 
    from
        orders order0_ 
    inner join
        member member1_ 
            on order0_.member_id=member1_.member_id 
    inner join
        delivery delivery2_ 
            on order0_.delivery_id=delivery2_.delivery_id
Hibernate: 
    select
        order0_.order_id as order_id1_6_0_,
        member1_.member_id as member_i1_4_1_,
        delivery2_.delivery_id as delivery1_2_2_,
        order0_.delivery_id as delivery4_6_0_,
        order0_.member_id as member_i5_6_0_,
        order0_.order_date as order_da2_6_0_,
        order0_.status as status3_6_0_,
        member1_.city as city2_4_1_,
        member1_.street as street3_4_1_,
        member1_.zipcode as zipcode4_4_1_,
        member1_.name as name5_4_1_,
        delivery2_.city as city2_2_2_,
        delivery2_.street as street3_2_2_,
        delivery2_.zipcode as zipcode4_2_2_,
        delivery2_.status as status5_2_2_ 
    from
        orders order0_ 
    inner join
        member member1_ 
            on order0_.member_id=member1_.member_id 
    inner join
        delivery delivery2_ 
            on order0_.delivery_id=delivery2_.delivery_id
2022-11-02 16:18:50.294  INFO 31332 --- [nio-8080-exec-1] p6spy                                    : #1667373530294 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop
select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id
select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id;
2022-11-02 16:18:50.296 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id1_6_0_] : [BIGINT]) - [4]
2022-11-02 16:18:50.296 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([member_i1_4_1_] : [BIGINT]) - [1]
2022-11-02 16:18:50.297 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([delivery1_2_2_] : [BIGINT]) - [5]
2022-11-02 16:18:50.298 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([delivery4_6_0_] : [BIGINT]) - [5]
2022-11-02 16:18:50.298 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([member_i5_6_0_] : [BIGINT]) - [1]
2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_da2_6_0_] : [TIMESTAMP]) - [2022-11-02T16:18:45.107619]
2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([status3_6_0_] : [VARCHAR]) - [ORDER]
2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([city2_4_1_] : [VARCHAR]) - [seoul]
2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([street3_4_1_] : [VARCHAR]) - [1]
2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([zipcode4_4_1_] : [VARCHAR]) - [111]
2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([name5_4_1_] : [VARCHAR]) - [userA]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([city2_2_2_] : [VARCHAR]) - [seoul]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([street3_2_2_] : [VARCHAR]) - [1]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([zipcode4_2_2_] : [VARCHAR]) - [111]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([status5_2_2_] : [VARCHAR]) - [null]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id1_6_0_] : [BIGINT]) - [11]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([member_i1_4_1_] : [BIGINT]) - [8]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([delivery1_2_2_] : [BIGINT]) - [12]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([delivery4_6_0_] : [BIGINT]) - [12]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([member_i5_6_0_] : [BIGINT]) - [8]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_da2_6_0_] : [TIMESTAMP]) - [2022-11-02T16:18:45.142303]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([status3_6_0_] : [VARCHAR]) - [ORDER]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([city2_4_1_] : [VARCHAR]) - [tokyo]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([street3_4_1_] : [VARCHAR]) - [1]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([zipcode4_4_1_] : [VARCHAR]) - [111]
2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([name5_4_1_] : [VARCHAR]) - [userB]
2022-11-02 16:18:50.301 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([city2_2_2_] : [VARCHAR]) - [tokyo]
2022-11-02 16:18:50.301 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([street3_2_2_] : [VARCHAR]) - [1]
2022-11-02 16:18:50.301 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([zipcode4_2_2_] : [VARCHAR]) - [111]
2022-11-02 16:18:50.301 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([status5_2_2_] : [VARCHAR]) - [null]
2022-11-02 16:18:50.306 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType        : Created collection wrapper: [jpabook.jpashop.domain.Order.orderItems#4]
2022-11-02 16:18:50.307 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType        : Created collection wrapper: [jpabook.jpashop.domain.Member.orders#1]
2022-11-02 16:18:50.307 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType        : Created collection wrapper: [jpabook.jpashop.domain.Order.orderItems#11]
2022-11-02 16:18:50.307 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType        : Created collection wrapper: [jpabook.jpashop.domain.Member.orders#8]
2022-11-02 16:18:50.310 DEBUG 31332 --- [nio-8080-exec-1] org.hibernate.SQL                        : 
    select
        orderitems0_.order_id as order_id5_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.count as count2_5_1_,
        orderitems0_.item_id as item_id4_5_1_,
        orderitems0_.order_id as order_id5_5_1_,
        orderitems0_.order_price as order_pr3_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
Hibernate: 
    select
        orderitems0_.order_id as order_id5_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.count as count2_5_1_,
        orderitems0_.item_id as item_id4_5_1_,
        orderitems0_.order_id as order_id5_5_1_,
        orderitems0_.order_price as order_pr3_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
2022-11-02 16:18:50.311 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2022-11-02 16:18:50.312  INFO 31332 --- [nio-8080-exec-1] p6spy                                    : #1667373530312 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop
select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=?
select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=4;
2022-11-02 16:18:50.315 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [6]
2022-11-02 16:18:50.316 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count2_5_1_] : [INTEGER]) - [1]
2022-11-02 16:18:50.316 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id4_5_1_] : [BIGINT]) - [3]
2022-11-02 16:18:50.316 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id5_5_1_] : [BIGINT]) - [4]
2022-11-02 16:18:50.316 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr3_5_1_] : [INTEGER]) - [10000]
2022-11-02 16:18:50.317 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id5_5_0_] : [BIGINT]) - [4]
2022-11-02 16:18:50.317 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [6]
2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [7]
2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count2_5_1_] : [INTEGER]) - [2]
2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id4_5_1_] : [BIGINT]) - [3]
2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id5_5_1_] : [BIGINT]) - [4]
2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr3_5_1_] : [INTEGER]) - [10000]
2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id5_5_0_] : [BIGINT]) - [4]
2022-11-02 16:18:50.320 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [7]
2022-11-02 16:18:50.324 DEBUG 31332 --- [nio-8080-exec-1] org.hibernate.SQL                        : 
    select
        item0_.item_id as item_id2_3_0_,
        item0_.name as name3_3_0_,
        item0_.price as price4_3_0_,
        item0_.stock_quantity as stock_qu5_3_0_,
        item0_.artist as artist6_3_0_,
        item0_.etc as etc7_3_0_,
        item0_.author as author8_3_0_,
        item0_.isbn as isbn9_3_0_,
        item0_.actor as actor10_3_0_,
        item0_.director as directo11_3_0_,
        item0_.dtype as dtype1_3_0_ 
    from
        item item0_ 
    where
        item0_.item_id=?
Hibernate: 
    select
        item0_.item_id as item_id2_3_0_,
        item0_.name as name3_3_0_,
        item0_.price as price4_3_0_,
        item0_.stock_quantity as stock_qu5_3_0_,
        item0_.artist as artist6_3_0_,
        item0_.etc as etc7_3_0_,
        item0_.author as author8_3_0_,
        item0_.isbn as isbn9_3_0_,
        item0_.actor as actor10_3_0_,
        item0_.director as directo11_3_0_,
        item0_.dtype as dtype1_3_0_ 
    from
        item item0_ 
    where
        item0_.item_id=?
2022-11-02 16:18:50.325 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [3]
2022-11-02 16:18:50.325  INFO 31332 --- [nio-8080-exec-1] p6spy                                    : #1667373530325 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop
select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=?
select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=3;
2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([dtype1_3_0_] : [VARCHAR]) - [B]
2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([name3_3_0_] : [VARCHAR]) - [jap2 book]
2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([price4_3_0_] : [INTEGER]) - [10000]
2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([stock_qu5_3_0_] : [INTEGER]) - [97]
2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([author8_3_0_] : [VARCHAR]) - [null]
2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([isbn9_3_0_] : [VARCHAR]) - [null]
2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType        : Created collection wrapper: [jpabook.jpashop.domain.item.Item.categories#3]
2022-11-02 16:18:50.327 DEBUG 31332 --- [nio-8080-exec-1] org.hibernate.SQL                        : 
    select
        orderitems0_.order_id as order_id5_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.count as count2_5_1_,
        orderitems0_.item_id as item_id4_5_1_,
        orderitems0_.order_id as order_id5_5_1_,
        orderitems0_.order_price as order_pr3_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
Hibernate: 
    select
        orderitems0_.order_id as order_id5_5_0_,
        orderitems0_.order_item_id as order_it1_5_0_,
        orderitems0_.order_item_id as order_it1_5_1_,
        orderitems0_.count as count2_5_1_,
        orderitems0_.item_id as item_id4_5_1_,
        orderitems0_.order_id as order_id5_5_1_,
        orderitems0_.order_price as order_pr3_5_1_ 
    from
        order_item orderitems0_ 
    where
        orderitems0_.order_id=?
2022-11-02 16:18:50.327 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [11]
2022-11-02 16:18:50.327  INFO 31332 --- [nio-8080-exec-1] p6spy                                    : #1667373530327 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop
select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=?
select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=11;
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [13]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count2_5_1_] : [INTEGER]) - [2]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id4_5_1_] : [BIGINT]) - [10]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id5_5_1_] : [BIGINT]) - [11]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr3_5_1_] : [INTEGER]) - [20000]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id5_5_0_] : [BIGINT]) - [11]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [13]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_1_] : [BIGINT]) - [14]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([count2_5_1_] : [INTEGER]) - [3]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([item_id4_5_1_] : [BIGINT]) - [10]
2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id5_5_1_] : [BIGINT]) - [11]
2022-11-02 16:18:50.329 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_pr3_5_1_] : [INTEGER]) - [30000]
2022-11-02 16:18:50.329 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_id5_5_0_] : [BIGINT]) - [11]
2022-11-02 16:18:50.329 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([order_it1_5_0_] : [BIGINT]) - [14]
2022-11-02 16:18:50.329 DEBUG 31332 --- [nio-8080-exec-1] org.hibernate.SQL                        : 
    select
        item0_.item_id as item_id2_3_0_,
        item0_.name as name3_3_0_,
        item0_.price as price4_3_0_,
        item0_.stock_quantity as stock_qu5_3_0_,
        item0_.artist as artist6_3_0_,
        item0_.etc as etc7_3_0_,
        item0_.author as author8_3_0_,
        item0_.isbn as isbn9_3_0_,
        item0_.actor as actor10_3_0_,
        item0_.director as directo11_3_0_,
        item0_.dtype as dtype1_3_0_ 
    from
        item item0_ 
    where
        item0_.item_id=?
Hibernate: 
    select
        item0_.item_id as item_id2_3_0_,
        item0_.name as name3_3_0_,
        item0_.price as price4_3_0_,
        item0_.stock_quantity as stock_qu5_3_0_,
        item0_.artist as artist6_3_0_,
        item0_.etc as etc7_3_0_,
        item0_.author as author8_3_0_,
        item0_.isbn as isbn9_3_0_,
        item0_.actor as actor10_3_0_,
        item0_.director as directo11_3_0_,
        item0_.dtype as dtype1_3_0_ 
    from
        item item0_ 
    where
        item0_.item_id=?
2022-11-02 16:18:50.330 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [10]
2022-11-02 16:18:50.330  INFO 31332 --- [nio-8080-exec-1] p6spy                                    : #1667373530330 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop
select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=?
select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=10;
2022-11-02 16:18:50.330 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([dtype1_3_0_] : [VARCHAR]) - [B]
2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([name3_3_0_] : [VARCHAR]) - [spring2 book]
2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([price4_3_0_] : [INTEGER]) - [10000]
2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([stock_qu5_3_0_] : [INTEGER]) - [95]
2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([author8_3_0_] : [VARCHAR]) - [null]
2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([isbn9_3_0_] : [VARCHAR]) - [null]
2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType        : Created collection wrapper: [jpabook.jpashop.domain.item.Item.categories#10]