spring boot学习第十五篇:分库分表实战

先了解分库分表的一些概念，参考：【MySQL】MySQL分库分表详解[通俗易懂]-腾讯云开发者社区-腾讯云

然后觉得哔哩哔哩里讲的挺好的，要试一下：1、海量数据冲击下的MySQL优化方案_哔哩哔哩_bilibili

官网资料：Apache ShardingSphere

还有博客：https://blog.51cto.com/u_14904176/5959319

接下来，我贴下代码，和验证结果。

先贴下表结构例子：

CREATE TABLE `t_order_0` (
  `order_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=983058321449680897 DEFAULT CHARSET=utf8;

1、pom.xml文件内容如下：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>
    <parent>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-parent</artifactId>
      <version>2.3.1.RELEASE</version>
      <relativePath/>
    </parent>

    <groupId>com.hmblogs.example</groupId>
    <artifactId>sharding-jdbc-demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>sharding-jdbc-demo</name>

    <properties>
      <java.version>1.8</java.version>
    </properties>
    <dependencies>

        <dependency>
          <groupId>org.apache.shardingsphere</groupId>
          <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
          <version>4.1.1</version>
        </dependency>

        <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <scope>runtime</scope>
        </dependency>
        <dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>druid</artifactId>
          <version>1.1.22</version>
        </dependency>

        <dependency>
          <groupId>org.projectlombok</groupId>
          <artifactId>lombok</artifactId>
          <optional>true</optional>
        </dependency>
        <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-test</artifactId>
          <scope>test</scope>
          <exclusions>
              <exclusion>
              <groupId>org.junit.vintage</groupId>
              <artifactId>junit-vintage-engine</artifactId>
              </exclusion>
          </exclusions>
        </dependency>
    </dependencies>

    <build>
     <plugins>
      <plugin>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-maven-plugin</artifactId>
      </plugin>
      </plugins>
    </build>
</project>

2、application.properties内容如下：

server.port=8080
server.servlet.context-path=/order

# 配置真实数据源
spring.shardingsphere.datasource.names=ds0,ds1

# 配置第1个数据源
spring.shardingsphere.datasource.ds0.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.ds0.driver-class-name=com.mysql.jdbc.Driver
spring.shardingsphere.datasource.ds0.url=jdbc:mysql://localhost:3306/ds0?serverTimezone=UTC
spring.shardingsphere.datasource.ds0.username=root
spring.shardingsphere.datasource.ds0.password=123456

# 配置第2个数据源
spring.shardingsphere.datasource.ds1.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.ds1.driver-class-name=com.mysql.jdbc.Driver
spring.shardingsphere.datasource.ds1.url=jdbc:mysql://localhost:3306/ds1?serverTimezone=UTC
spring.shardingsphere.datasource.ds1.username=root
spring.shardingsphere.datasource.ds1.password=123456

# 配置t_order表规则
spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds$->{0..1}.t_order_$->{0..1}

spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id

spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order_$->{order_id % 2}

spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE
spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
spring.shardingsphere.sharding.tables.t_order.database-strategy.inline.sharding-column=user_id

spring.shardingsphere.sharding.tables.t_order.database-strategy.inline.algorithm-expression=ds$->{user_id % 2}


spring.shardingsphere.props.sql.show=true

3、启动类内容如下：

package com.hmblogs;

import org.springframework.boot.CommandLineRunner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.transaction.jta.JtaAutoConfiguration;
import javax.annotation.Resource;
import javax.sql.DataSource;
/** *
 /** *
 http://shardingsphere.apache.org/index.html
 最最重要的是 application.properties
 /** *
 /** *
 https://shardingsphere.apache.org/document/legacy/4.x/document/en/manual/shardingjdbc/
 http://shardingsphere.apache.org/index_zh.html
 */
@SpringBootApplication(exclude = JtaAutoConfiguration.class)
public class ShardingJdbcDemoApplication implements CommandLineRunner {

        public static void main(String[] args) {
            SpringApplication.run(ShardingJdbcDemoApplication.class, args);
        }
        @Resource
        private DataSource dataSource;

        @Override
        public void run(String... args) throws Exception {
            System.out.println(dataSource);
        }
}

4、服务实现类代码如下：

package com.hmblogs.service;

import com.hmblogs.dao.OrderRepository;
import com.hmblogs.entity.OrderEntity;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;

@Service
public class OrderService {

    @Resource
    private OrderRepository orderRepository;

    public void save(OrderEntity entity) {
        orderRepository.save(entity);
    }

    public List<OrderEntity> findAll() {
        return orderRepository.findAll();
    }

    public OrderEntity findById(Long id) {
        return orderRepository.findById(id).get();
    }
}

5、实体类代码如下：

package com.hmblogs.entity;

import lombok.Data;
import javax.persistence.*;
import java.io.Serializable;

@Entity
@Table(name = "t_order")
@Data
public class OrderEntity implements Serializable {


    @Id
    @Column(name = "order_id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long orderId;

    private Integer userId;

    private Integer status = 1;
}

6、dao类代码如下：

package com.hmblogs.dao;


import com.hmblogs.entity.OrderEntity;
import org.springframework.data.jpa.repository.JpaRepository;

public interface OrderRepository extends JpaRepository<OrderEntity, Long> {
}

7、接口类代码如下：

package com.hmblogs.controller;

import com.hmblogs.entity.OrderEntity;
import com.hmblogs.service.OrderService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RequestMapping("/order")
@RestController
public class OrderController {

    @Autowired
    private OrderService orderService;

    @GetMapping("/save")
    public String save(@RequestParam("userId") Integer userId) {
        OrderEntity entity = new OrderEntity();
        entity.setOrderId(userId.longValue());
        entity.setUserId(userId);
        orderService.save(entity);
        return "ok";
    }

    @GetMapping("/findAll")
    public List<OrderEntity> findAll() {
        return orderService.findAll();
    }

    @GetMapping("/findById")
    public OrderEntity findById(@RequestParam("id") Long id) {
        return orderService.findById(id);
    }
}

8、验证

8.1在已经有数据的情况下，先调用http://localhost:8080/order/order/findById?id=982331633019387905

这个接口，发现只从ds0/ds1的t_order_1表找

查看控制台，内容如下：

2024-04-05 16:45:01.992  INFO 24508 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/order]  : Initializing Spring DispatcherServlet 'dispatcherServlet'
2024-04-05 16:45:01.992  INFO 24508 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2024-04-05 16:45:02.001  INFO 24508 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 8 ms
2024-04-05 16:45:02.711  INFO 24508 --- [nio-8080-exec-1] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 16:45:02.711  INFO 24508 --- [nio-8080-exec-1] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@38b4133f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@443b7175), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@443b7175, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@1b7d32a0, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@62c214ab, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@7a77ce27, containsSubquery=false)
2024-04-05 16:45:02.711  INFO 24508 --- [nio-8080-exec-1] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [982331633019387905]
2024-04-05 16:45:02.711  INFO 24508 --- [nio-8080-exec-1] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [982331633019387905]

8.2查询所有订单时，会从ds0/ds1的t_order_0、t_order_1表找

执行http://localhost:8080/order/order/findAll

接口，查出的数据如下：

查看控制台，输出内容如下：

2024-04-05 16:51:59.924  INFO 24508 --- [nio-8080-exec-4] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_, orderentit0_.status as status2_0_, orderentit0_.user_id as user_id3_0_ from t_order orderentit0_
2024-04-05 16:51:59.924  INFO 24508 --- [nio-8080-exec-4] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@74b9f792, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@5e13977b), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@5e13977b, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=115, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@1bfaffb8, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@4deffb15, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@76d1905d, containsSubquery=false)
2024-04-05 16:51:59.925  INFO 24508 --- [nio-8080-exec-4] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_, orderentit0_.status as status2_0_, orderentit0_.user_id as user_id3_0_ from t_order_0 orderentit0_
2024-04-05 16:51:59.925  INFO 24508 --- [nio-8080-exec-4] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_, orderentit0_.status as status2_0_, orderentit0_.user_id as user_id3_0_ from t_order_1 orderentit0_
2024-04-05 16:51:59.925  INFO 24508 --- [nio-8080-exec-4] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_, orderentit0_.status as status2_0_, orderentit0_.user_id as user_id3_0_ from t_order_0 orderentit0_
2024-04-05 16:51:59.925  INFO 24508 --- [nio-8080-exec-4] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_, orderentit0_.status as status2_0_, orderentit0_.user_id as user_id3_0_ from t_order_1 orderentit0_

8.3添加订单信息

执行接口http://localhost:8080/order/order/save?userId=9

查看控制台打印日志，如下：

2024-04-05 16:59:33.410  INFO 24508 --- [nio-8080-exec-7] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 16:59:33.410  INFO 24508 --- [nio-8080-exec-7] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@38b4133f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1f542437), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1f542437, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@7ac57efe, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@4317defd, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@3af100d2, containsSubquery=false)
2024-04-05 16:59:33.411  INFO 24508 --- [nio-8080-exec-7] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [9]
2024-04-05 16:59:33.411  INFO 24508 --- [nio-8080-exec-7] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [9]
2024-04-05 16:59:33.561  INFO 24508 --- [nio-8080-exec-7] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 16:59:33.561  INFO 24508 --- [nio-8080-exec-7] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2f647545, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1ee72c5e), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1ee72c5e, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 9])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983052471892967424])])
2024-04-05 16:59:33.562  INFO 24508 --- [nio-8080-exec-7] ShardingSphere-SQL                       : Actual SQL: ds1 ::: insert into t_order_0 (status, user_id, order_id) values (?, ?, ?) ::: [1, 9, 983052471892967424]

然后尝试着把userId改成10,11,12,13,14,15,16,17

控制台打印的内容如下：

2024-04-05 17:16:46.884  INFO 27436 --- [nio-8080-exec-1] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 17:16:46.884  INFO 27436 --- [nio-8080-exec-1] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@1c3adb3f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@742406c7), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@742406c7, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@1fb4049b, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@69915000, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@23389d2e, containsSubquery=false)
2024-04-05 17:16:46.885  INFO 27436 --- [nio-8080-exec-1] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_0 orderentit0_ where orderentit0_.order_id=? ::: [10]
2024-04-05 17:16:46.885  INFO 27436 --- [nio-8080-exec-1] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_0 orderentit0_ where orderentit0_.order_id=? ::: [10]
2024-04-05 17:16:47.032  INFO 27436 --- [nio-8080-exec-1] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 17:16:47.033  INFO 27436 --- [nio-8080-exec-1] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@503432d8, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3ed135f1), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3ed135f1, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 10])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983056806643236864])])
2024-04-05 17:16:47.033  INFO 27436 --- [nio-8080-exec-1] ShardingSphere-SQL                       : Actual SQL: ds0 ::: insert into t_order_0 (status, user_id, order_id) values (?, ?, ?) ::: [1, 10, 983056806643236864]
2024-04-05 17:17:04.662  INFO 27436 --- [nio-8080-exec-2] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 17:17:04.662  INFO 27436 --- [nio-8080-exec-2] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@1c3adb3f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7345a190), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7345a190, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@3647319c, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@213a077e, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@7bba7fd, containsSubquery=false)
2024-04-05 17:17:04.662  INFO 27436 --- [nio-8080-exec-2] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [11]
2024-04-05 17:17:04.662  INFO 27436 --- [nio-8080-exec-2] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [11]
2024-04-05 17:17:04.684  INFO 27436 --- [nio-8080-exec-2] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 17:17:04.685  INFO 27436 --- [nio-8080-exec-2] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@503432d8, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7eae8b59), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7eae8b59, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 11])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983056880744005633])])
2024-04-05 17:17:04.685  INFO 27436 --- [nio-8080-exec-2] ShardingSphere-SQL                       : Actual SQL: ds1 ::: insert into t_order_1 (status, user_id, order_id) values (?, ?, ?) ::: [1, 11, 983056880744005633]
2024-04-05 17:17:18.941  INFO 27436 --- [nio-8080-exec-3] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 17:17:18.942  INFO 27436 --- [nio-8080-exec-3] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@1c3adb3f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7fb0347d), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7fb0347d, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@3ab2b5ef, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@db53583, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@bc24afe, containsSubquery=false)
2024-04-05 17:17:18.942  INFO 27436 --- [nio-8080-exec-3] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_0 orderentit0_ where orderentit0_.order_id=? ::: [12]
2024-04-05 17:17:18.942  INFO 27436 --- [nio-8080-exec-3] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_0 orderentit0_ where orderentit0_.order_id=? ::: [12]
2024-04-05 17:17:18.962  INFO 27436 --- [nio-8080-exec-3] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 17:17:18.962  INFO 27436 --- [nio-8080-exec-3] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@503432d8, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@26a3d312), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@26a3d312, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 12])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983056940630278144])])
2024-04-05 17:17:18.962  INFO 27436 --- [nio-8080-exec-3] ShardingSphere-SQL                       : Actual SQL: ds0 ::: insert into t_order_0 (status, user_id, order_id) values (?, ?, ?) ::: [1, 12, 983056940630278144]
2024-04-05 17:17:34.548  INFO 27436 --- [nio-8080-exec-8] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 17:17:34.548  INFO 27436 --- [nio-8080-exec-8] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@1c3adb3f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1c59c47a), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1c59c47a, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@595b5995, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@4299644b, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@68c8a495, containsSubquery=false)
2024-04-05 17:17:34.549  INFO 27436 --- [nio-8080-exec-8] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [13]
2024-04-05 17:17:34.549  INFO 27436 --- [nio-8080-exec-8] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [13]
2024-04-05 17:17:34.573  INFO 27436 --- [nio-8080-exec-8] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 17:17:34.573  INFO 27436 --- [nio-8080-exec-8] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@503432d8, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1751bc23), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1751bc23, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 13])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983057006107557889])])
2024-04-05 17:17:34.573  INFO 27436 --- [nio-8080-exec-8] ShardingSphere-SQL                       : Actual SQL: ds1 ::: insert into t_order_1 (status, user_id, order_id) values (?, ?, ?) ::: [1, 13, 983057006107557889]
2024-04-05 17:17:50.256  INFO 27436 --- [nio-8080-exec-6] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 17:17:50.256  INFO 27436 --- [nio-8080-exec-6] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@1c3adb3f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4e1f6700), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4e1f6700, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@b1df0a7, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@77e5e938, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@3adc1942, containsSubquery=false)
2024-04-05 17:17:50.257  INFO 27436 --- [nio-8080-exec-6] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_0 orderentit0_ where orderentit0_.order_id=? ::: [14]
2024-04-05 17:17:50.257  INFO 27436 --- [nio-8080-exec-6] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_0 orderentit0_ where orderentit0_.order_id=? ::: [14]
2024-04-05 17:17:50.279  INFO 27436 --- [nio-8080-exec-6] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 17:17:50.279  INFO 27436 --- [nio-8080-exec-6] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@503432d8, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@554394ae), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@554394ae, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 14])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983057071983296512])])
2024-04-05 17:17:50.279  INFO 27436 --- [nio-8080-exec-6] ShardingSphere-SQL                       : Actual SQL: ds0 ::: insert into t_order_0 (status, user_id, order_id) values (?, ?, ?) ::: [1, 14, 983057071983296512]
2024-04-05 17:18:05.942  INFO 27436 --- [nio-8080-exec-5] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 17:18:05.942  INFO 27436 --- [nio-8080-exec-5] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@1c3adb3f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@115ff7bd), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@115ff7bd, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@6dc1ded0, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@15e572cc, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@64d7de45, containsSubquery=false)
2024-04-05 17:18:05.943  INFO 27436 --- [nio-8080-exec-5] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [15]
2024-04-05 17:18:05.943  INFO 27436 --- [nio-8080-exec-5] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [15]
2024-04-05 17:18:05.965  INFO 27436 --- [nio-8080-exec-5] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 17:18:05.965  INFO 27436 --- [nio-8080-exec-5] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@503432d8, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@69fe86e6), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@69fe86e6, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 15])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983057137779343361])])
2024-04-05 17:18:05.965  INFO 27436 --- [nio-8080-exec-5] ShardingSphere-SQL                       : Actual SQL: ds1 ::: insert into t_order_1 (status, user_id, order_id) values (?, ?, ?) ::: [1, 15, 983057137779343361]
2024-04-05 17:18:35.736  INFO 27436 --- [nio-8080-exec-9] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 17:18:35.736  INFO 27436 --- [nio-8080-exec-9] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@1c3adb3f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7666bf47), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7666bf47, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@33642fef, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@39d16ad8, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@29d9fb3, containsSubquery=false)
2024-04-05 17:18:35.737  INFO 27436 --- [nio-8080-exec-9] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_0 orderentit0_ where orderentit0_.order_id=? ::: [16]
2024-04-05 17:18:35.737  INFO 27436 --- [nio-8080-exec-9] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_0 orderentit0_ where orderentit0_.order_id=? ::: [16]
2024-04-05 17:18:35.757  INFO 27436 --- [nio-8080-exec-9] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 17:18:35.757  INFO 27436 --- [nio-8080-exec-9] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@503432d8, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4aca1cb0), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4aca1cb0, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 16])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983057262736048128])])
2024-04-05 17:18:35.757  INFO 27436 --- [nio-8080-exec-9] ShardingSphere-SQL                       : Actual SQL: ds0 ::: insert into t_order_0 (status, user_id, order_id) values (?, ?, ?) ::: [1, 16, 983057262736048128]
2024-04-05 17:18:49.216  INFO 27436 --- [io-8080-exec-10] ShardingSphere-SQL                       : Logic SQL: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order orderentit0_ where orderentit0_.order_id=?
2024-04-05 17:18:49.217  INFO 27436 --- [io-8080-exec-10] ShardingSphere-SQL                       : SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@1c3adb3f, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@428cde24), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@428cde24, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=121, distinctRow=false, projections=[ColumnProjection(owner=orderentit0_, name=order_id, alias=Optional[order_id1_0_0_]), ColumnProjection(owner=orderentit0_, name=status, alias=Optional[status2_0_0_]), ColumnProjection(owner=orderentit0_, name=user_id, alias=Optional[user_id3_0_0_])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@74ebade2, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@f900c41, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@7d519bae, containsSubquery=false)
2024-04-05 17:18:49.217  INFO 27436 --- [io-8080-exec-10] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [17]
2024-04-05 17:18:49.217  INFO 27436 --- [io-8080-exec-10] ShardingSphere-SQL                       : Actual SQL: ds1 ::: select orderentit0_.order_id as order_id1_0_0_, orderentit0_.status as status2_0_0_, orderentit0_.user_id as user_id3_0_0_ from t_order_1 orderentit0_ where orderentit0_.order_id=? ::: [17]
2024-04-05 17:18:49.240  INFO 27436 --- [io-8080-exec-10] ShardingSphere-SQL                       : Logic SQL: insert into t_order (status, user_id) values (?, ?)
2024-04-05 17:18:49.240  INFO 27436 --- [io-8080-exec-10] ShardingSphere-SQL                       : SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@503432d8, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1ac2190a), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1ac2190a, columnNames=[status, user_id], insertValueContexts=[InsertValueContext(parametersCount=2, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=46, stopIndex=46, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=49, stopIndex=49, parameterMarkerIndex=1), DerivedParameterMarkerExpressionSegment(super=ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0, parameterMarkerIndex=2))], parameters=[1, 17])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=order_id, generated=true, generatedValues=[983057319283654657])])
2024-04-05 17:18:49.240  INFO 27436 --- [io-8080-exec-10] ShardingSphere-SQL                       : Actual SQL: ds1 ::: insert into t_order_1 (status, user_id, order_id) values (?, ?, ?) ::: [1, 17, 983057319283654657]

数据截图如下：