README.md · max/seed_boot

[TOC]

# case题目

## [简单]表迁移&分页查询`case-transfer`

### 全局响应参数

### 题目要求 No.1

1. 提供表迁移接口`/user/transfer`，请求方式`POST`

2. 用代码实现功能：完成`user_info_bak`数据全部迁移到`user_info`表中

### 题目要求 No.2

1. 提供分页查询接口`/user/page`，请求方式`POST`

2. 参数格式如下：

| 请求参数名称 | 参数类型 |   描述   |
| :----------- | :------: | :------: |
| page         |   int    |  第几页  |
| pageSize     |   int    | 每页几条 |

| 响应参数名称 | 参数类型  |   描述   |
| :----------- | :-------: | :------: |
| list         | User list | User列表 |
| totalNum     |    int    |  总条数  |
| totalPage    |    int    |  总页数  |
| pageNum      |    int    |  当前页  |
| pageSize     |    int    | 每页数量 |

| User参数名称 | 参数类型 |      描述       |
| :----------- | :------: | :-------------: |
| id           |   Long   |      主键       |
| name         |  String  |      姓名       |
| sex          | Integer  | 性别：1-男 2-女 |
| phone        |  String  |     手机号      |
| createTime   |   date   |    创建时间     |

### SQL语句

```sql
DROP TABLE IF EXISTS `user_info_bak`;
CREATE TABLE `user_info_bak` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '名字',
  `sex` int(1) DEFAULT NULL COMMENT '性别：1男 2女',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user_info_bak
-- ----------------------------
INSERT INTO `user_info_bak` VALUES ('1', '机器人1号', '2', '18698291131', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('2', '机器人2号', '1', '18698291132', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('3', '机器人3号', '2', '18698291133', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('4', '机器人4号', '1', '18698291134', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('5', '机器人5号', '2', '18698291135', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('6', '机器人6号', '1', '18698291136', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('7', '机器人7号', '2', '18698291137', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('8', '机器人8号', '1', '18698291138', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('9', '机器人9号', '2', '18698291139', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('10', '机器人10号', '1', '18698291140', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('11', '机器人11号', '2', '18698291141', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('12', '机器人12号', '1', '18698291142', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('13', '机器人13号', '2', '18698291143', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('14', '机器人14号', '1', '18698291144', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('15', '机器人15号', '2', '18698291145', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('16', '机器人16号', '1', '18698291146', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('17', '机器人17号', '2', '18698291147', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('18', '机器人18号', '1', '18698291148', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('19', '机器人19号', '2', '18698291149', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('20', '机器人20号', '1', '18698291150', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('21', '机器人21号', '2', '18698291151', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('22', '机器人22号', '1', '18698291152', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('23', '机器人23号', '2', '18698291153', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('24', '机器人24号', '1', '18698291154', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('25', '机器人25号', '2', '18698291155', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('26', '机器人26号', '1', '18698291156', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('27', '机器人27号', '2', '18698291157', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('28', '机器人28号', '1', '18698291158', '2020-12-21 00:00:00');
INSERT INTO `user_info_bak` VALUES ('29', '机器人29号', '2', '18698291159', '2020-12-21 00:00:00');

DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `sex` int(1) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```

## [中等]并发注册&分环境打包部署`case-regist`

### 全局响应参数

### 题目要求 No.1

1. 提供注册接口`/user/regist`，请求方式`POST`

2. 代码要求：利用悲观锁和唯一索引，保证注册手机号不重复

3. 能够支持并发，保证数据的正确性

4. 参数格式要求：

| 请求参数名称 | 参数类型 |  描述  |
   | :----------- | :------: | :----: |
   | phone        |  String  | 手机号 |
   | password     |  String  |  密码  |

### 题目要求 No.2

支持分环境打包部署，预设三个环境：`dev`（默认），`test`，`pro`

### SQL要求

```sql
DROP TABLE IF EXISTS `user_regist_info`;
CREATE TABLE `user_regist_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `phone` varchar(20) NOT NULL,
  `password` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `INX_PHONE` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

```
## [中等]权限验证`case-security`
### 题目要求：

- 前端编写几个简单页面，比如首页、用户页面、部门1页面、部门2页面、管理员页面和登录页面
- 完成用户名密码登录，登出；
- 用户登录后，可根据数据库中的权限设置（roles），进行不同页面的权限验证

### 方案建议

- Springboot + Spring Security
- 前端使用js/jsp/thymeleaf都可以

### SQL

```sql
DROP TABLE IF EXISTS `security_user`;
CREATE TABLE `security_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL COMMENT '姓名',
  `address` varchar(64) DEFAULT NULL COMMENT '联系地址',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
  `roles` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
--  Records of `security_user`
-- ----------------------------
BEGIN;
INSERT INTO `security_user` VALUES ('1', 'Adam', 'beijing', 'adam','$2a$10$9SIFu8l8asZUKxtwqrJM5ujhWarz/PMnTX44wXNsBHfpJMakWw3M6', 'ROLE_USER');
INSERT INTO `security_user` VALUES ('2', 'SuperMan', 'shanghang', 'super','$2a$10$9SIFu8l8asZUKxtwqrJM5ujhWarz/PMnTX44wXNsBHfpJMakWw3M6', 'ROLE_USER,ROLE_ADMIN');
INSERT INTO `security_user` VALUES ('3', 'Manager', 'beijing', 'manager','$2a$10$9SIFu8l8asZUKxtwqrJM5ujhWarz/PMnTX44wXNsBHfpJMakWw3M6', 'ROLE_USER,ROLE_MANAGER');
INSERT INTO `security_user` VALUES ('4', 'User1', 'shanghang', 'user1','$2a$10$9SIFu8l8asZUKxtwqrJM5ujhWarz/PMnTX44wXNsBHfpJMakWw3M6', 'ROLE_USER,ROLE_DEPART1');
INSERT INTO `security_user` VALUES ('5', 'User2', 'shanghang', 'user2','$2a$10$9SIFu8l8asZUKxtwqrJM5ujhWarz/PMnTX44wXNsBHfpJMakWw3M6', 'ROLE_USER,ROLE_DEPART2');
COMMIT;

-- ----------------------------
--  Table structure for `security_resource`
-- ----------------------------
DROP TABLE IF EXISTS `security_resource`;
CREATE TABLE `security_resource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL COMMENT '资源',
  `roles` varchar(255) DEFAULT NULL COMMENT '所需角色',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
--  Records of `security_resource`
-- ----------------------------
BEGIN;
INSERT INTO `security_resource` VALUES ('1', '/depart1/**', 'ROLE_ADMIN,ROLE_MANAGER,ROLE_DEPART1');
INSERT INTO `security_resource` VALUES ('2', '/depart2/**', 'ROLE_ADMIN,ROLE_MANAGER,ROLE_DEPART2');
INSERT INTO `security_resource` VALUES ('3', '/user/**', 'ROLE_ADMIN,ROLE_USER');
INSERT INTO `security_resource` VALUES ('4', '/admin/**', 'ROLE_ADMIN');
COMMIT;

```

## [简单]排行榜 ①`case-ranklist-easy`

### 题目描述

现有订单表`r_order`和用户表`r_user`，请仅用SQL语句来完成 ———

根据用户下单总金额展示前十名的信息，包括排名、用户手机号以及用户订单总金额。

排行榜样式如下：

| 排名 | 用户手机号  | 订单总金额 |
| :--: | :---------: | :--------: |
|  1   | 186****3530 |  91125.73  |
|  2   | 186****4530 |  84706.45  |
|  3   | 186****3930 |  80842.01  |
|  4   | 186****0030 |  78002.46  |
|  5   | 186****4830 |  73964.09  |
|  6   | 186****8430 |  73232.76  |
|  7   | 186****6530 |  72909.16  |
|  8   | 186****7730 |  71406.96  |
|  9   | 186****1730 |  71336.24  |
|  10  | 186****8730 |  70396.33  |

### SQL

```sql
-- ----------------------------
-- Table structure for r_order
-- ----------------------------
DROP TABLE IF EXISTS `r_order`;
CREATE TABLE `r_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `order_amount` decimal(12,2) DEFAULT NULL COMMENT '订单金额',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_deleted` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=601 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of r_order
-- ----------------------------
INSERT INTO `r_order` VALUES ('1', '87', '3601.80', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('2', '76', '12867.18', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('3', '64', '3160.13', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('4', '27', '8337.95', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('5', '37', '12079.76', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('6', '52', '10573.99', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('7', '49', '287.93', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('8', '62', '404.68', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('9', '28', '4197.61', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('10', '75', '10212.51', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('11', '66', '12359.27', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('12', '75', '12013.56', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('13', '34', '12124.10', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('14', '63', '4335.85', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('15', '77', '11364.28', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('16', '3', '6998.68', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('17', '58', '3796.32', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('18', '70', '8242.07', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('19', '5', '4532.49', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('20', '58', '11038.57', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('21', '49', '12040.47', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('22', '13', '11521.74', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('23', '2', '5648.84', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('24', '10', '2732.34', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('25', '73', '174.92', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('26', '87', '3832.40', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('27', '86', '5341.35', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('28', '46', '1094.04', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('29', '2', '10814.68', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('30', '9', '12732.59', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('31', '60', '687.05', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('32', '45', '1560.72', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('33', '22', '9570.27', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('34', '1', '10888.69', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('35', '15', '2852.58', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('36', '64', '7300.90', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('37', '86', '8143.77', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('38', '53', '10123.61', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('39', '28', '1154.61', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('40', '57', '7925.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('41', '31', '9287.31', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('42', '63', '232.15', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('43', '18', '10925.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('44', '65', '9585.59', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('45', '72', '4901.26', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('46', '72', '5953.55', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('47', '12', '3106.08', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('48', '81', '4533.57', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('49', '29', '5283.11', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('50', '15', '6676.94', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('51', '11', '413.90', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('52', '80', '11871.62', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('53', '15', '12935.64', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('54', '52', '8032.67', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('55', '51', '9300.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('56', '2', '12505.87', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('57', '73', '10011.56', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('58', '64', '11766.73', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('59', '58', '2563.91', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('60', '22', '6913.78', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('61', '97', '3386.65', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('62', '37', '1222.33', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('63', '33', '4844.34', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('64', '86', '2141.44', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('65', '24', '9188.37', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('66', '80', '11406.12', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('67', '97', '3121.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('68', '26', '7743.88', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('69', '17', '1144.68', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('70', '90', '3154.10', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('71', '49', '9725.70', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('72', '24', '12501.50', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('73', '7', '6097.14', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('74', '12', '2432.10', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('75', '56', '3435.71', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('76', '61', '3489.56', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('77', '49', '8480.22', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('78', '77', '11818.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('79', '21', '4323.85', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('80', '1', '889.34', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('81', '29', '3082.83', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('82', '31', '10669.67', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('83', '17', '5078.27', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('84', '43', '12560.10', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('85', '53', '10037.53', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('86', '24', '11772.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('87', '78', '2434.09', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('88', '58', '4397.96', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('89', '94', '8754.40', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('90', '54', '8851.99', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('91', '77', '10498.27', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('92', '71', '1899.18', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('93', '57', '5700.08', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('94', '45', '12308.88', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('95', '36', '12667.97', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('96', '77', '12011.58', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('97', '30', '9308.36', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('98', '67', '2854.56', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('99', '6', '8561.37', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('100', '9', '6075.01', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('101', '6', '11472.89', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('102', '23', '6409.76', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('103', '77', '4629.47', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('104', '46', '3372.07', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('105', '89', '8504.07', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('106', '60', '328.66', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('107', '32', '6808.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('108', '64', '8494.01', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('109', '32', '8214.25', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('110', '19', '724.59', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('111', '69', '3938.95', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('112', '42', '2418.85', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('113', '66', '9607.61', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('114', '70', '3874.86', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('115', '37', '12253.92', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('116', '60', '2050.80', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('117', '98', '5779.86', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('118', '26', '12460.13', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('119', '100', '1823.80', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('120', '68', '12610.96', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('121', '80', '1294.07', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('122', '8', '1188.70', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('123', '21', '10038.76', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('124', '22', '10138.05', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('125', '23', '10374.08', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('126', '29', '965.19', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('127', '48', '2071.87', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('128', '35', '3778.77', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('129', '38', '249.77', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('130', '95', '8836.64', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('131', '54', '8748.32', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('132', '72', '7788.32', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('133', '81', '3343.14', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('134', '84', '5524.72', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('135', '59', '8981.46', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('136', '66', '3025.35', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('137', '17', '1748.42', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('138', '16', '5091.92', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('139', '47', '2110.60', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('140', '39', '6374.09', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('141', '25', '10212.38', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('142', '16', '5768.45', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('143', '72', '3789.17', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('144', '27', '6178.12', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('145', '55', '4381.82', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('146', '1', '751.42', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('147', '23', '12940.66', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('148', '26', '4209.71', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('149', '82', '1618.55', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('150', '15', '4965.13', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('151', '44', '870.53', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('152', '99', '9953.94', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('153', '83', '11390.02', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('154', '86', '8924.90', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('155', '83', '1162.91', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('156', '94', '5871.27', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('157', '41', '9188.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('158', '28', '3830.56', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('159', '61', '2188.61', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('160', '100', '6208.52', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('161', '38', '6364.50', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('162', '28', '12148.77', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('163', '82', '3646.13', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('164', '94', '11037.55', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('165', '42', '6998.21', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('166', '43', '6728.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('167', '29', '11948.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('168', '70', '9563.87', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('169', '57', '8279.72', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('170', '46', '5339.91', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('171', '65', '13040.72', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('172', '6', '3814.44', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('173', '27', '6207.99', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('174', '56', '4721.74', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('175', '12', '6941.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('176', '28', '10487.17', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('177', '17', '5885.36', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('178', '72', '3537.26', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('179', '17', '339.81', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('180', '61', '12721.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('181', '4', '3740.75', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('182', '29', '7685.17', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('183', '7', '7451.51', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('184', '64', '6512.12', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('185', '56', '3766.66', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('186', '76', '12057.55', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('187', '34', '12293.56', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('188', '68', '7159.68', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('189', '71', '11491.85', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('190', '28', '10008.08', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('191', '98', '7826.85', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('192', '5', '5737.40', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('193', '4', '11669.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('194', '34', '174.36', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('195', '3', '1391.85', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('196', '43', '10975.96', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('197', '91', '116.53', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('198', '30', '6530.38', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('199', '58', '5128.42', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('200', '22', '11766.60', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('201', '86', '7509.60', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('202', '30', '9883.04', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('203', '89', '2291.32', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('204', '19', '5687.72', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('205', '59', '8544.83', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('206', '49', '6262.36', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('207', '92', '2181.40', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('208', '6', '10185.26', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('209', '73', '3987.39', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('210', '32', '9192.99', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('211', '54', '7880.37', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('212', '38', '1090.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('213', '26', '890.46', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('214', '54', '6206.91', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('215', '76', '5017.16', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('216', '62', '12563.81', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('217', '94', '10657.94', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('218', '25', '10526.68', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('219', '27', '12185.35', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('220', '85', '5881.61', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('221', '69', '1182.36', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('222', '37', '7630.42', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('223', '80', '3436.75', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('224', '89', '8724.42', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('225', '66', '3933.32', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('226', '51', '8313.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('227', '65', '4651.00', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('228', '81', '12650.17', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('229', '42', '2594.15', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('230', '71', '12537.35', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('231', '67', '5962.24', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('232', '27', '12546.42', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('233', '1', '1821.87', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('234', '66', '11797.68', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('235', '53', '11859.17', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('236', '97', '1245.08', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('237', '56', '7023.99', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('238', '99', '4350.04', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('239', '68', '5534.90', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('240', '6', '112.82', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('241', '86', '3429.38', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('242', '73', '11242.90', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('243', '12', '12850.69', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('244', '58', '12076.92', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('245', '89', '8905.40', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('246', '73', '7610.26', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('247', '73', '11546.41', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('248', '24', '6989.47', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('249', '95', '1982.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('250', '89', '12856.58', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('251', '26', '4535.21', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('252', '94', '8559.71', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('253', '45', '3917.66', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('254', '13', '9498.14', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('255', '26', '1305.74', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('256', '71', '3425.76', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('257', '16', '437.74', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('258', '66', '2585.31', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('259', '100', '5281.20', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('260', '1', '11175.04', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('261', '24', '7894.92', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('262', '31', '9528.12', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('263', '72', '5080.07', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('264', '79', '9868.27', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('265', '42', '10876.49', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('266', '90', '12938.94', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('267', '26', '4051.42', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('268', '76', '11626.51', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('269', '16', '1540.94', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('270', '10', '1739.32', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('271', '36', '5278.58', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('272', '93', '5739.13', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('273', '40', '8636.23', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('274', '11', '7536.13', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('275', '54', '12560.44', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('276', '19', '923.28', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('277', '76', '7598.33', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('278', '63', '5158.71', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('279', '8', '2730.49', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('280', '79', '4551.03', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('281', '35', '8995.16', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('282', '40', '12048.83', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('283', '42', '4071.35', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('284', '29', '7016.15', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('285', '80', '4764.70', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('286', '43', '483.87', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('287', '89', '4411.25', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('288', '1', '559.01', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('289', '16', '9019.85', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('290', '96', '9446.04', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('291', '73', '6396.23', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('292', '24', '9613.98', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('293', '95', '7199.63', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('294', '89', '10367.18', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('295', '30', '1279.67', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('296', '58', '8109.18', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('297', '35', '11657.28', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('298', '41', '4605.83', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('299', '53', '7695.28', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('300', '35', '12857.79', '2020-08-26 18:01:52', '0');
INSERT INTO `r_order` VALUES ('301', '87', '5140.47', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('302', '34', '7048.88', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('303', '66', '8764.54', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('304', '38', '11186.40', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('305', '16', '2760.77', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('306', '57', '2876.98', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('307', '38', '2915.70', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('308', '97', '2605.44', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('309', '6', '9362.10', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('310', '39', '10530.85', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('311', '85', '10927.35', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('312', '63', '7942.02', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('313', '16', '12652.14', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('314', '37', '12012.49', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('315', '50', '9468.06', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('316', '13', '5880.81', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('317', '86', '12622.74', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('318', '24', '4004.82', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('319', '79', '587.01', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('320', '83', '209.78', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('321', '57', '10802.70', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('322', '41', '7463.22', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('323', '62', '4676.95', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('324', '93', '7792.98', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('325', '18', '1074.07', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('326', '87', '1370.61', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('327', '90', '2474.91', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('328', '23', '7787.72', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('329', '28', '7792.53', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('330', '14', '12068.62', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('331', '19', '2270.99', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('332', '28', '11631.26', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('333', '61', '4655.04', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('334', '95', '8864.36', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('335', '54', '8627.60', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('336', '68', '5245.08', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('337', '97', '8108.15', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('338', '20', '1949.04', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('339', '12', '2158.54', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('340', '45', '9570.90', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('341', '33', '5520.21', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('342', '13', '4845.84', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('343', '46', '2489.04', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('344', '56', '2779.24', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('345', '38', '3504.11', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('346', '19', '1665.00', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('347', '6', '12198.01', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('348', '48', '7877.19', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('349', '56', '12984.56', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('350', '29', '5911.92', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('351', '39', '7565.51', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('352', '73', '11637.43', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('353', '28', '9121.65', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('354', '66', '2674.44', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('355', '3', '6819.49', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('356', '52', '600.45', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('357', '64', '1133.02', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('358', '49', '2223.31', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('359', '38', '5145.81', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('360', '82', '11860.63', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('361', '9', '9139.73', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('362', '24', '1009.09', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('363', '66', '1015.10', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('364', '39', '9305.09', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('365', '39', '10760.89', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('366', '94', '2811.15', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('367', '25', '7663.73', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('368', '19', '2410.60', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('369', '34', '1927.91', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('370', '70', '1034.78', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('371', '27', '1409.60', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('372', '72', '3569.39', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('373', '20', '2231.98', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('374', '25', '9383.22', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('375', '85', '1293.30', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('376', '92', '4223.80', '2020-08-26 18:10:07', '0');
INSERT INTO `r_order` VALUES ('377', '84', '2712.45', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('378', '52', '12622.36', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('379', '28', '6512.88', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('380', '64', '9243.41', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('381', '61', '12108.89', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('382', '80', '2978.21', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('383', '72', '11706.06', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('384', '33', '12711.16', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('385', '87', '5257.52', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('386', '40', '10592.44', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('387', '84', '10038.63', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('388', '32', '3502.12', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('389', '38', '1292.62', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('390', '34', '5140.76', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('391', '95', '7140.78', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('392', '89', '10507.96', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('393', '35', '4484.18', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('394', '65', '2727.72', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('395', '9', '10569.19', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('396', '78', '6365.19', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('397', '8', '11915.78', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('398', '34', '12213.07', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('399', '67', '6906.28', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('400', '63', '7401.74', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('401', '93', '12576.55', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('402', '2', '2438.77', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('403', '87', '10247.66', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('404', '32', '2856.56', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('405', '13', '145.83', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('406', '64', '2161.62', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('407', '90', '12858.42', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('408', '24', '2955.31', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('409', '40', '4525.06', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('410', '51', '6478.44', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('411', '95', '3464.86', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('412', '46', '6626.32', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('413', '15', '2816.39', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('414', '62', '5974.50', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('415', '42', '9268.05', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('416', '29', '4422.35', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('417', '80', '12712.24', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('418', '48', '5831.36', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('419', '80', '8485.72', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('420', '85', '3846.41', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('421', '91', '8810.37', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('422', '63', '1879.25', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('423', '80', '7512.49', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('424', '47', '7924.01', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('425', '63', '4043.79', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('426', '66', '4615.86', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('427', '79', '11407.23', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('428', '1', '5294.62', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('429', '100', '10032.71', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('430', '85', '12070.00', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('431', '8', '8135.59', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('432', '87', '6046.12', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('433', '70', '1756.05', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('434', '54', '4049.91', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('435', '91', '8243.78', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('436', '41', '2282.62', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('437', '62', '7275.85', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('438', '93', '12797.48', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('439', '11', '7769.56', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('440', '64', '5544.22', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('441', '19', '8514.20', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('442', '70', '6971.73', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('443', '57', '2935.06', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('444', '41', '5120.51', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('445', '71', '4974.25', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('446', '76', '8526.10', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('447', '98', '12327.59', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('448', '78', '589.38', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('449', '88', '3349.97', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('450', '64', '5444.93', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('451', '16', '7404.04', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('452', '34', '12772.39', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('453', '88', '6139.04', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('454', '69', '790.17', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('455', '20', '10861.86', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('456', '55', '3363.75', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('457', '62', '4254.59', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('458', '76', '10663.41', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('459', '81', '7413.55', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('460', '42', '4986.81', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('461', '65', '1127.37', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('462', '48', '1638.80', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('463', '18', '7090.88', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('464', '16', '2077.45', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('465', '31', '753.60', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('466', '35', '7721.38', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('467', '89', '9023.76', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('468', '77', '10059.13', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('469', '54', '5009.55', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('470', '29', '3749.35', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('471', '56', '12251.74', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('472', '1', '3138.86', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('473', '15', '472.78', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('474', '71', '5833.13', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('475', '9', '1674.40', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('476', '34', '4415.51', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('477', '65', '2925.02', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('478', '16', '1935.85', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('479', '24', '9556.03', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('480', '95', '7241.93', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('481', '91', '11692.44', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('482', '74', '13078.90', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('483', '79', '12367.11', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('484', '36', '12365.06', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('485', '66', '5732.05', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('486', '21', '9723.47', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('487', '8', '2257.39', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('488', '60', '6479.29', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('489', '67', '10889.96', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('490', '17', '4695.56', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('491', '27', '3306.01', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('492', '45', '6654.22', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('493', '18', '4776.04', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('494', '28', '3956.89', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('495', '66', '5296.43', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('496', '3', '12120.28', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('497', '55', '12717.45', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('498', '21', '1649.09', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('499', '98', '6975.59', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('500', '72', '12794.50', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('501', '75', '10415.11', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('502', '74', '3836.60', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('503', '24', '4259.39', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('504', '90', '6499.09', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('505', '79', '6248.23', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('506', '100', '7324.49', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('507', '80', '4031.23', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('508', '14', '9773.02', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('509', '33', '5506.33', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('510', '10', '2763.00', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('511', '76', '2040.09', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('512', '49', '12994.67', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('513', '50', '6637.92', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('514', '3', '8268.45', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('515', '6', '5459.29', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('516', '89', '2410.52', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('517', '24', '8766.19', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('518', '62', '962.93', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('519', '50', '3499.93', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('520', '84', '4932.24', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('521', '37', '9313.32', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('522', '45', '1662.95', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('523', '26', '11876.18', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('524', '77', '1780.80', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('525', '34', '4049.69', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('526', '51', '8016.91', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('527', '54', '10974.07', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('528', '59', '5455.10', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('529', '31', '3980.27', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('530', '58', '12629.30', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('531', '11', '8234.29', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('532', '82', '2887.80', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('533', '62', '5859.65', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('534', '37', '6443.21', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('535', '35', '3784.08', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('536', '37', '13008.64', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('537', '86', '4207.45', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('538', '1', '963.79', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('539', '33', '5544.91', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('540', '13', '4779.15', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('541', '43', '999.72', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('542', '6', '1082.39', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('543', '21', '10667.95', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('544', '45', '10049.49', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('545', '51', '3028.71', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('546', '62', '5200.17', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('547', '13', '5644.74', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('548', '78', '7548.54', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('549', '56', '719.68', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('550', '58', '9837.08', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('551', '1', '10527.33', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('552', '99', '6585.55', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('553', '56', '3479.50', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('554', '65', '5940.57', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('555', '31', '2655.41', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('556', '6', '9087.67', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('557', '29', '4866.93', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('558', '97', '9782.67', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('559', '82', '11168.35', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('560', '81', '6254.66', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('561', '96', '4423.38', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('562', '82', '852.24', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('563', '86', '1482.14', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('564', '97', '6590.57', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('565', '61', '6981.63', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('566', '84', '7435.84', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('567', '34', '12546.22', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('568', '80', '1555.60', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('569', '17', '6740.46', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('570', '5', '9168.27', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('571', '35', '8633.10', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('572', '24', '2614.46', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('573', '27', '10076.76', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('574', '3', '11028.41', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('575', '12', '948.96', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('576', '98', '8874.53', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('577', '46', '3175.49', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('578', '83', '5563.49', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('579', '63', '11226.86', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('580', '41', '6339.01', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('581', '18', '5499.46', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('582', '57', '7538.59', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('583', '18', '1838.09', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('584', '16', '5176.37', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('585', '48', '2908.30', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('586', '65', '7770.35', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('587', '1', '3561.97', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('588', '31', '9844.19', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('589', '82', '11081.84', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('590', '77', '4057.23', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('591', '22', '2450.93', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('592', '25', '9152.55', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('593', '74', '7940.11', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('594', '81', '2589.19', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('595', '56', '2833.66', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('596', '39', '3636.88', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('597', '22', '3697.77', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('598', '73', '10625.66', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('599', '87', '11707.55', '2020-08-26 18:10:08', '0');
INSERT INTO `r_order` VALUES ('600', '88', '8912.61', '2020-08-26 18:10:08', '0');

```

```sql
-- ----------------------------
-- Table structure for r_user
-- ----------------------------
DROP TABLE IF EXISTS `r_user`;
CREATE TABLE `r_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) DEFAULT NULL COMMENT '用户姓名',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_deleted` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of r_user
-- ----------------------------
INSERT INTO `r_user` VALUES ('1', '机器人1号', '18698291230', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('2', '机器人2号', '18698291330', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('3', '机器人3号', '18698291430', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('4', '机器人4号', '18698291530', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('5', '机器人5号', '18698291630', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('6', '机器人6号', '18698291730', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('7', '机器人7号', '18698291830', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('8', '机器人8号', '18698291930', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('9', '机器人9号', '18698292030', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('10', '机器人10号', '18698292130', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('11', '机器人11号', '18698292230', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('12', '机器人12号', '18698292330', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('13', '机器人13号', '18698292430', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('14', '机器人14号', '18698292530', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('15', '机器人15号', '18698292630', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('16', '机器人16号', '18698292730', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('17', '机器人17号', '18698292830', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('18', '机器人18号', '18698292930', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('19', '机器人19号', '18698293030', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('20', '机器人20号', '18698293130', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('21', '机器人21号', '18698293230', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('22', '机器人22号', '18698293330', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('23', '机器人23号', '18698293430', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('24', '机器人24号', '18698293530', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('25', '机器人25号', '18698293630', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('26', '机器人26号', '18698293730', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('27', '机器人27号', '18698293830', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('28', '机器人28号', '18698293930', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('29', '机器人29号', '18698294030', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('30', '机器人30号', '18698294130', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('31', '机器人31号', '18698294230', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('32', '机器人32号', '18698294330', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('33', '机器人33号', '18698294430', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('34', '机器人34号', '18698294530', '2020-08-26 17:45:21', '0');
INSERT INTO `r_user` VALUES ('35', '机器人35号', '18698294630', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('36', '机器人36号', '18698294730', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('37', '机器人37号', '18698294830', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('38', '机器人38号', '18698294930', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('39', '机器人39号', '18698295030', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('40', '机器人40号', '18698295130', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('41', '机器人41号', '18698295230', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('42', '机器人42号', '18698295330', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('43', '机器人43号', '18698295430', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('44', '机器人44号', '18698295530', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('45', '机器人45号', '18698295630', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('46', '机器人46号', '18698295730', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('47', '机器人47号', '18698295830', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('48', '机器人48号', '18698295930', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('49', '机器人49号', '18698296030', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('50', '机器人50号', '18698296130', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('51', '机器人51号', '18698296230', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('52', '机器人52号', '18698296330', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('53', '机器人53号', '18698296430', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('54', '机器人54号', '18698296530', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('55', '机器人55号', '18698296630', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('56', '机器人56号', '18698296730', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('57', '机器人57号', '18698296830', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('58', '机器人58号', '18698296930', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('59', '机器人59号', '18698297030', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('60', '机器人60号', '18698297130', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('61', '机器人61号', '18698297230', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('62', '机器人62号', '18698297330', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('63', '机器人63号', '18698297430', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('64', '机器人64号', '18698297530', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('65', '机器人65号', '18698297630', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('66', '机器人66号', '18698297730', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('67', '机器人67号', '18698297830', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('68', '机器人68号', '18698297930', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('69', '机器人69号', '18698298030', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('70', '机器人70号', '18698298130', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('71', '机器人71号', '18698298230', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('72', '机器人72号', '18698298330', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('73', '机器人73号', '18698298430', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('74', '机器人74号', '18698298530', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('75', '机器人75号', '18698298630', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('76', '机器人76号', '18698298730', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('77', '机器人77号', '18698298830', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('78', '机器人78号', '18698298930', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('79', '机器人79号', '18698299030', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('80', '机器人80号', '18698299130', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('81', '机器人81号', '18698299230', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('82', '机器人82号', '18698299330', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('83', '机器人83号', '18698299430', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('84', '机器人84号', '18698299530', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('85', '机器人85号', '18698299630', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('86', '机器人86号', '18698299730', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('87', '机器人87号', '18698299830', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('88', '机器人88号', '18698299930', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('89', '机器人89号', '18698300030', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('90', '机器人90号', '18698300130', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('91', '机器人91号', '18698300230', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('92', '机器人92号', '18698300330', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('93', '机器人93号', '18698300430', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('94', '机器人94号', '18698300530', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('95', '机器人95号', '18698300630', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('96', '机器人96号', '18698300730', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('97', '机器人97号', '18698300830', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('98', '机器人98号', '18698300930', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('99', '机器人99号', '18698301030', '2020-08-26 17:45:22', '0');
INSERT INTO `r_user` VALUES ('100', '机器人100号', '18698301130', '2020-08-26 17:45:22', '0');

```

## [中等]排行榜 ②`case-ranklist-medium`

### 题目描述

在`排行榜①`中，我们已经完成对静态数据的排行逻辑；但是在实际的业务场景中，排行榜需求往往都是要求对动态变化的数据完成统计的，并且我们还需要考虑接口的性能以及效率问题；

在这个case中，我们增加几个设定：

1. 表的数据随时在更新
2. 假定该表数据量是千万级别
3. 允许排行榜的结果是非实时的

### 思路提示

- 定时任务
- 缓存

### 题目交付要求

- 提供一个定时任务：随机新增订单表数据（新增逻辑随意，只要能定时新增订单表数据即可）
- 实现一个非实时结果的排行榜接口，（单机QPS在`1500/s`左右，峰值`5000/s`）
- 输入内容格式与`排行榜①`相同

## [中等]排行榜③ `case-ranklist-hard`

### 题目描述

- 实时获取排行榜数据（单机QPS在`1500/s`左右，峰值`5000/s`）
- 内容返回格式与`排行榜①`一致

### 思路提示

- redis

## [中等]并发抢购① `case-seckill-base`

### 场景介绍

秒杀系统主要应用在商品抢购的场景，比如：

- 电商抢购限量商品
- 卖周董演唱会的门票
- 抢火车票
- ...

秒杀系统抽象来说就是以下几个步骤：

- 用户选定商品下单
- **校验库存**
- **扣库存**
- **创建用户订单**
- （后续不在本次考察范围）...

### 题目描述

了解一下抢购系统需要满足的最基本要求：

- **防止超卖**：假如库存总共100件，你却卖出去120件，就叫做超卖
- **防止一人多卖**：一般对与特别优惠的商品，我们会限制每个用户下单次数，否则容易出现被一人包圆的风险。

### 题目要求

- 要求分别用悲观锁和乐观锁两种方式设计方案；
- 要求防止超卖：商品表已售库存数和订单数应保持一致；
- 要求防止一人多卖：订单表中一个用户只能有一条记录
- 无需考虑超高并发的性能问题
- 测试场景：Jmeter模拟1000线程并发访问，目标可达。

请设计出满足以上条件的方案并coding。

### SQL

```sql
-- ----------------------------
-- Table structure for seckill_user
-- ----------------------------
DROP TABLE IF EXISTS `seckill_user`;
CREATE TABLE `seckill_user` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '用户名称',
  `phone` varchar(30) DEFAULT NULL COMMENT '用户手机号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_deleted` int(11) DEFAULT '0' COMMENT '是否删除：0否 1是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of seckill_user
-- ----------------------------
INSERT INTO `seckill_user` VALUES ('1', '测试用户1', '18602832211', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('2', '测试用户2', '18602832212', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('3', '测试用户3', '18602832213', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('4', '测试用户4', '18602832214', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('5', '测试用户5', '18602832215', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('6', '测试用户6', '18602832216', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('7', '测试用户7', '18602832217', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('8', '测试用户8', '18602832218', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('9', '测试用户9', '18602832219', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('10', '测试用户10', '18602832220', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('11', '测试用户11', '18602832221', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('12', '测试用户12', '18602832222', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('13', '测试用户13', '18602832223', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('14', '测试用户14', '18602832224', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('15', '测试用户15', '18602832225', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('16', '测试用户16', '18602832226', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('17', '测试用户17', '18602832227', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('18', '测试用户18', '18602832228', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('19', '测试用户19', '18602832229', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('20', '测试用户20', '18602832230', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('21', '测试用户21', '18602832231', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('22', '测试用户22', '18602832232', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('23', '测试用户23', '18602832233', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('24', '测试用户24', '18602832234', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('25', '测试用户25', '18602832235', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('26', '测试用户26', '18602832236', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('27', '测试用户27', '18602832237', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('28', '测试用户28', '18602832238', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('29', '测试用户29', '18602832239', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('30', '测试用户30', '18602832240', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('31', '测试用户31', '18602832241', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('32', '测试用户32', '18602832242', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('33', '测试用户33', '18602832243', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('34', '测试用户34', '18602832244', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('35', '测试用户35', '18602832245', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('36', '测试用户36', '18602832246', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('37', '测试用户37', '18602832247', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('38', '测试用户38', '18602832248', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('39', '测试用户39', '18602832249', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('40', '测试用户40', '18602832250', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('41', '测试用户41', '18602832251', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('42', '测试用户42', '18602832252', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('43', '测试用户43', '18602832253', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('44', '测试用户44', '18602832254', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('45', '测试用户45', '18602832255', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('46', '测试用户46', '18602832256', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('47', '测试用户47', '18602832257', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('48', '测试用户48', '18602832258', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('49', '测试用户49', '18602832259', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('50', '测试用户50', '18602832260', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('51', '测试用户51', '18602832261', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('52', '测试用户52', '18602832262', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('53', '测试用户53', '18602832263', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('54', '测试用户54', '18602832264', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('55', '测试用户55', '18602832265', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('56', '测试用户56', '18602832266', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('57', '测试用户57', '18602832267', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('58', '测试用户58', '18602832268', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('59', '测试用户59', '18602832269', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('60', '测试用户60', '18602832270', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('61', '测试用户61', '18602832271', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('62', '测试用户62', '18602832272', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('63', '测试用户63', '18602832273', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('64', '测试用户64', '18602832274', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('65', '测试用户65', '18602832275', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('66', '测试用户66', '18602832276', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('67', '测试用户67', '18602832277', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('68', '测试用户68', '18602832278', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('69', '测试用户69', '18602832279', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('70', '测试用户70', '18602832280', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('71', '测试用户71', '18602832281', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('72', '测试用户72', '18602832282', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('73', '测试用户73', '18602832283', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('74', '测试用户74', '18602832284', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('75', '测试用户75', '18602832285', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('76', '测试用户76', '18602832286', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('77', '测试用户77', '18602832287', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('78', '测试用户78', '18602832288', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('79', '测试用户79', '18602832289', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('80', '测试用户80', '18602832290', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('81', '测试用户81', '18602832291', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('82', '测试用户82', '18602832292', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('83', '测试用户83', '18602832293', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('84', '测试用户84', '18602832294', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('85', '测试用户85', '18602832295', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('86', '测试用户86', '18602832296', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('87', '测试用户87', '18602832297', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('88', '测试用户88', '18602832298', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('89', '测试用户89', '18602832299', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('90', '测试用户90', '18602832300', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('91', '测试用户91', '18602832301', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('92', '测试用户92', '18602832302', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('93', '测试用户93', '18602832303', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('94', '测试用户94', '18602832304', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('95', '测试用户95', '18602832305', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('96', '测试用户96', '18602832306', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('97', '测试用户97', '18602832307', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('98', '测试用户98', '18602832308', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('99', '测试用户99', '18602832309', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('100', '测试用户100', '18602832310', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('101', '测试用户101', '18602832311', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('102', '测试用户102', '18602832312', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('103', '测试用户103', '18602832313', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('104', '测试用户104', '18602832314', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('105', '测试用户105', '18602832315', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('106', '测试用户106', '18602832316', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('107', '测试用户107', '18602832317', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('108', '测试用户108', '18602832318', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('109', '测试用户109', '18602832319', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('110', '测试用户110', '18602832320', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('111', '测试用户111', '18602832321', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('112', '测试用户112', '18602832322', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('113', '测试用户113', '18602832323', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('114', '测试用户114', '18602832324', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('115', '测试用户115', '18602832325', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('116', '测试用户116', '18602832326', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('117', '测试用户117', '18602832327', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('118', '测试用户118', '18602832328', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('119', '测试用户119', '18602832329', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('120', '测试用户120', '18602832330', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('121', '测试用户121', '18602832331', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('122', '测试用户122', '18602832332', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('123', '测试用户123', '18602832333', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('124', '测试用户124', '18602832334', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('125', '测试用户125', '18602832335', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('126', '测试用户126', '18602832336', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('127', '测试用户127', '18602832337', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('128', '测试用户128', '18602832338', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('129', '测试用户129', '18602832339', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('130', '测试用户130', '18602832340', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('131', '测试用户131', '18602832341', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('132', '测试用户132', '18602832342', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('133', '测试用户133', '18602832343', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('134', '测试用户134', '18602832344', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('135', '测试用户135', '18602832345', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('136', '测试用户136', '18602832346', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('137', '测试用户137', '18602832347', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('138', '测试用户138', '18602832348', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('139', '测试用户139', '18602832349', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('140', '测试用户140', '18602832350', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('141', '测试用户141', '18602832351', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('142', '测试用户142', '18602832352', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('143', '测试用户143', '18602832353', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('144', '测试用户144', '18602832354', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('145', '测试用户145', '18602832355', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('146', '测试用户146', '18602832356', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('147', '测试用户147', '18602832357', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('148', '测试用户148', '18602832358', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('149', '测试用户149', '18602832359', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('150', '测试用户150', '18602832360', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('151', '测试用户151', '18602832361', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('152', '测试用户152', '18602832362', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('153', '测试用户153', '18602832363', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('154', '测试用户154', '18602832364', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('155', '测试用户155', '18602832365', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('156', '测试用户156', '18602832366', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('157', '测试用户157', '18602832367', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('158', '测试用户158', '18602832368', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('159', '测试用户159', '18602832369', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('160', '测试用户160', '18602832370', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('161', '测试用户161', '18602832371', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('162', '测试用户162', '18602832372', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('163', '测试用户163', '18602832373', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('164', '测试用户164', '18602832374', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('165', '测试用户165', '18602832375', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('166', '测试用户166', '18602832376', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('167', '测试用户167', '18602832377', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('168', '测试用户168', '18602832378', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('169', '测试用户169', '18602832379', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('170', '测试用户170', '18602832380', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('171', '测试用户171', '18602832381', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('172', '测试用户172', '18602832382', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('173', '测试用户173', '18602832383', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('174', '测试用户174', '18602832384', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('175', '测试用户175', '18602832385', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('176', '测试用户176', '18602832386', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('177', '测试用户177', '18602832387', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('178', '测试用户178', '18602832388', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('179', '测试用户179', '18602832389', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('180', '测试用户180', '18602832390', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('181', '测试用户181', '18602832391', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('182', '测试用户182', '18602832392', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('183', '测试用户183', '18602832393', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('184', '测试用户184', '18602832394', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('185', '测试用户185', '18602832395', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('186', '测试用户186', '18602832396', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('187', '测试用户187', '18602832397', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('188', '测试用户188', '18602832398', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('189', '测试用户189', '18602832399', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('190', '测试用户190', '18602832400', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('191', '测试用户191', '18602832401', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('192', '测试用户192', '18602832402', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('193', '测试用户193', '18602832403', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('194', '测试用户194', '18602832404', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('195', '测试用户195', '18602832405', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('196', '测试用户196', '18602832406', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('197', '测试用户197', '18602832407', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('198', '测试用户198', '18602832408', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('199', '测试用户199', '18602832409', '2020-08-27 11:40:52', '0');
INSERT INTO `seckill_user` VALUES ('200', '测试用户200', '18602832410', '2020-08-27 11:40:52', '0');

```

```sql
-- ----------------------------
-- Table structure for seckill_order
-- ----------------------------
DROP TABLE IF EXISTS `seckill_order`;
CREATE TABLE `seckill_order` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `product_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `product_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';
```

```sql
-- ----------------------------
-- Table structure for seckill_products
-- ----------------------------
DROP TABLE IF EXISTS `seckill_products`;
CREATE TABLE `seckill_products` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '商品名称',
  `count` int(11) DEFAULT NULL COMMENT '商品总库存数量',
  `saled` int(11) DEFAULT NULL COMMENT '已售数量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_deleted` int(1) DEFAULT NULL COMMENT '是否删除：0否 1是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='商品表';

-- ----------------------------
-- Records of seckill_products
-- ----------------------------
INSERT INTO `seckill_products` VALUES ('1', '10000-1000优惠券', '100', '0', '2020-08-27 11:32:59', '0');
```

## [复杂]并发抢购②`case-seckill-advance`

### 题目描述

`并发抢购①`我们已经完成了基本的并发抢购逻辑；

接下来我们需要对其进行优化：

优化思路的核心是限流和削峰，参考优化后的秒杀接口流程图：

### 题目要求

- 实现秒杀url隐藏模块逻辑
- 实现单用户访问频次限制模块逻辑
- 实现验证码校验
- 实现令牌桶限流 
- 针对分布式高并发场景下的扣减库存方案，请选择其中一种优化方案实现（分布式锁、消息中间件以及redis）

max/seed_boot

简介

发行版

贡献者

近期动态

max/seed_boot .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

max/seed_boot