畅购商城项目--搭建项目（仅项目架构）（后端+前端）

最新推荐文章于 2024-04-23 18:52:22 发布

啊是可莉

最新推荐文章于 2024-04-23 18:52:22 发布

阅读量5.6k

点赞数

文章标签：商城项目4.0 前后端分离 java

本文链接：https://blog.csdn.net/weixin_45822542/article/details/122079648

版权

学习使用，包含静态页面和后端javabean，私我获取

注：本项目采用B2C模式

1.1 电商行业分析

近年来，世界经济正向数字化转型，大力发展数字经济成为全球共识。党的十九大报告明确提出要建设“数字中国”“网络强国”，我国数字经济发展进入新阶段，市场规模位居全球第二，数字经济与实体经济深度融合，有力促进了供给侧结构性改革。电子商务是数字经济的重要组成部分，是数字经济最活跃、最集中的表现形式之一。
我国电子商务交易规模继续扩大，全国电子商务交易额达保持高速增长。国家统计局数据显示，2017年29.16万亿元，2018年31.64万亿元，2019年34.81万亿元，2020年交易额达38.21万亿元。

1.2 主要电商模式

B2B
B2B （ Business to Business）是指进行电子商务交易的供需双方都是商家（或企业、公司），她（他）们使用了互联网的技术或各种商务网络平台，完成商务交易的过程。电子商务是现代 B2B marketing的一种具体主要的表现形式。
案例：阿里巴巴、慧聪网

C2C
C2C即 Customer（Consumer） to Customer（Consumer），意思就是消费者个人间的电子商务行为。比如一个消费者有一台电脑，通过网络进行交易，把它出售给另外一个消费者，此种交易类型就称为C2C电子商务。
案例：淘宝、易趣、瓜子二手车

B2C
B2C是Business-to-Customer的缩写，而其中文简称为“商对客”。“商对客”是电子商务的一种模式，也就是通常说的直接面向消费者销售产品和服务商业零售模式。这种形式的电子商务一般以网络零售业为主，主要借助于互联网开展在线销售活动。B2C即企业通过互联网为消费者提供一个新型的购物环境——网上商店，消费者通过网络在网上购物、网上支付等消费行为。
案例：唯品会、乐蜂网

C2B
C2B（Consumer to Business，即消费者到企业），是互联网经济时代新的商业模式。这一模式改变了原有生产者（企业和机构）和消费者的关系，是一种消费者贡献价值（Create Value），企业和机构消费价值（Consume Value）。

C2B模式和我们熟知的供需模式（DSM, Demand SupplyModel）恰恰相反，真正的C2B 应该先有消费者需求产生而后有企业生产，即先有消费者提出需求，后有生产企业按需求组织生产。通常情况为消费者根据自身需求定制产品和价格，或主动参与产品设计、生产和定价，产品、价格等彰显消费者的个性化需求，生产企业进行定制化生产。
案例：海尔商城、尚品宅配

O2O
O2O即Online To Offline（在线离线/线上到线下），是指将线下的商务机会与互联网结合，让互联网成为线下交易的平台，这个概念最早来源于美国。O2O的概念非常广泛，既可涉及到线上，又可涉及到线下,可以通称为O2O。主流商业管理课程均对O2O这种新型的商业模式有所介绍及关注。
案例：美团、饿了吗

B2B2C
B2B2C是一种电子商务类型的网络购物商业模式，B是BUSINESS的简称，C是CUSTOMER的简称，第一个B指的是商品或服务的供应商，第二个B指的是从事电子商务的企业，C则是表示消费者。

案例：京东商城、天猫商城

2.畅购前台-需求分析与系统设计

电商项目分为：前台和后台
前台：提供用户使用
后台：提供商家进行管理
本项目主要讲解时：前台

2.1 需求分析
在这里插入图片描述

2.2系统设计

2.2.1 技术架构
在这里插入图片描述
2.2.2 架构图

3.架构搭建

3.1 数据库环境
这里提供一份学习使用的SQL语句
(本项目的重点在前端和后端，提供的数据库，没有分库分表)

/*
SQLyog Enterprise - MySQL GUI v6.14
MySQL - 5.5.27 : Database - shop
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `changgou_db`;

USE `changgou_db`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `tb_address` */

DROP TABLE IF EXISTS `tb_address`;

CREATE TABLE `tb_address` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL COMMENT '用户ID',
  `shr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人姓名',
  `shr_mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人手机',
  `shr_province` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人省份',
  `shr_city` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人城市',
  `shr_area` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人地区',
  `shr_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人详情地址',
  `isdefault` int(11) NOT NULL DEFAULT '0' COMMENT '1:默认;0:不是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_address` */

insert  into `tb_address`(`id`,`user_id`,`shr_name`,`shr_mobile`,`shr_province`,`shr_city`,`shr_area`,`shr_address`,`isdefault`) values (1,1,'小明','13344445555','江苏省','宿迁市','沭阳县','常州路57号',0),(2,1,'三毛','13344445556','江苏省','宿迁市','泗阳县','东方明珠城',0),(3,1,'小明','13344445555','江苏省','宿迁市','沭阳县','奥韵都城',0),(4,1,'张三','111','北京','海淀区','西三旗','111',0),(5,1,'李四','2222','北京','海淀区','西三旗','2222',1);

/*Table structure for table `tb_admin` */

DROP TABLE IF EXISTS `tb_admin`;

CREATE TABLE `tb_admin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '账号',
  `password` char(60) COLLATE utf8_unicode_ci NOT NULL COMMENT '密码',
  PRIMARY KEY (`id`),
  KEY `admins_account_index` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_admin` */

insert  into `tb_admin`(`id`,`created_at`,`updated_at`,`username`,`password`) values (1,NULL,NULL,'root','123456');

/*Table structure for table `tb_brand` */

DROP TABLE IF EXISTS `tb_brand`;

CREATE TABLE `tb_brand` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '品牌id',
  `brand_name` varchar(50) NOT NULL COMMENT '品牌名称',
  `logo` varchar(200) DEFAULT '' COMMENT '品牌图片地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=325403 DEFAULT CHARSET=utf8 COMMENT='品牌表，一个品牌下有多个商品（spu），一对多关系';

/*Data for the table `tb_brand` */

insert  into `tb_brand`(`id`,`brand_name`,`logo`) values (1115,'HTC','http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg'),(1528,'LG','http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg'),(1912,'NEC','http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg'),(2032,'OPPO','http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg'),(2505,'TCL','http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg'),(3177,'爱贝多','http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg'),(3539,'安桥（ONKYO）','http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg'),(3941,'白金（PLATINUM）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(4986,'波导（BiRD）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(6522,'朵唯（DOOV）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(6742,'飞利浦（PHILIPS）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(7174,'富可视（InFocus）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(7203,'富士通（Fujitsu）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(7420,'格力（GREE）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(7817,'海尔（Haier）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(7888,'海信（Hisense）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(8214,'黑莓（BlackBerry）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(8551,'华硕（ASUS）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(8557,'华为（HUAWEI）','http://img10.360buyimg.com/popshop/jfs/t5662/36/8888655583/7806/1c629c01/598033b4Nd6055897.jpg'),(8740,'惠普（HP）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(9420,'金立（Gionee）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(9637,'京瓷（KYOCERA）','http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg'),(10317,'康佳（KONKA）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(10640,'酷派（Coolpad）','http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg'),(11516,'联想（Lenovo）','http://img11.360buyimg.com/popshop/jfs/t6799/74/1348425607/15774/bc286188/59804c98N1944175e.jpg'),(12286,'漫步者（EDIFIER）','http://img13.360buyimg.com/popshop/jfs/t3511/131/31887105/4943/48f83fa9/57fdf4b8N6e95624d.jpg'),(12669,'魅族（MEIZU）','http://img13.360buyimg.com/popshop/jfs/t3511/131/31887105/4943/48f83fa9/57fdf4b8N6e95624d.jpg'),(13066,'摩托罗拉（Motorola）','http://img13.360buyimg.com/popshop/jfs/t3511/131/31887105/4943/48f83fa9/57fdf4b8N6e95624d.jpg'),(13539,'诺基亚（NOKIA）','http://img11.360buyimg.com/popshop/jfs/t2572/102/189476501/7717/16cc5814/563b33d4N6c59780c.jpg'),(14026,'Apple','http://img12.360buyimg.com/popshop/jfs/t2989/240/151377693/3895/30ad9044/574d36dbN262ef26d.jpg'),(14478,'青橙（GreenOrange）','http://img13.360buyimg.com/popshop/jfs/t3511/131/31887105/4943/48f83fa9/57fdf4b8N6e95624d.jpg'),(15127,'三星（SAMSUNG）','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(15539,'神舟（HASEE）','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(16506,'索爱（soaiy）','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(16538,'索尼（SONY）','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(16975,'天语（K-Touch）','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(17193,'外星人（Alienware）','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(17424,'威图','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(17440,'微软（Microsoft）','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(18078,'NAMO','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(18362,'小辣椒','http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg'),(18374,'小米（MI）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(20130,'优思（Uniscope）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(20710,'长虹（CHANGHONG）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(21011,'中兴（ZTE）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(21360,'beats','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(21553,'本易（BENEVE）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(22261,'tonino lamborghini','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(22575,'布鲁雅尔（Blueair）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(23049,'广信（KINGSUN）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(23130,'夏普（SHARP）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(25376,'马歇尔（Marshall）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(25591,'vivo','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(27094,'努比亚（nubia）','http://img14.360buyimg.com/popshop/jfs/t2101/155/882410684/3730/b24b14db/5631cd12N7548352d.jpg'),(27306,'360','http://img10.360buyimg.com/popshop/jfs/t5182/149/2437584670/15334/2e1ebf3/591aa1abN602ebecf.jpg'),(32315,'其他','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(36404,'金圣达（GRSED）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(36652,'贝尔丰（BIFER）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(36654,'大显（DaXian）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(36657,'朗界（RugGear）','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(38125,'SUGAR','http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg'),(38126,'美图（meitu）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(38605,'MANN','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(43644,'21KE','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(45227,'易百年','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(45693,'威途（vertu）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(45757,'欧奇（ouki）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(49144,'SPIGEN','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(50450,'亿和源（YHYON）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(51040,'BIHEE','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(52302,'优购（UooGou）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(53317,'迪美（DIM）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(54347,'尼凯恩（neken）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(55524,'B&O PLAY','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(56411,'誉品（YEPEN）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(59110,'诺亚信（NOAIN）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(60106,'奥乐迪奥（AoleDior）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(63032,'一加','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(63833,'雷蛇（Razer）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(68927,'詹姆士（GERMY）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(89010,'纽曼（Newman）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(91515,'锤子（smartisan）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(102501,'赛博宇华（SOP）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(104490,'谷歌（Google）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(109150,'爱贝多（Babyfit）','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(110303,'万利达（Malata）',''),(113718,'优它（YOTAPHONE）',''),(114119,'TETC',''),(123856,'炫华（xuanhua）',''),(128080,'托尼洛·兰博基尼（Tonino Lamborghini）',''),(129098,'木糖醇（MuTuCu）',''),(130455,'爱玛（EMMA）',''),(131546,'硕尼姆（Sonim）',''),(133747,'CAT',''),(134922,'ZUK',''),(135967,'sungee',''),(149070,'AGM',''),(151370,'SOYES',''),(151844,'KODAK',''),(155608,'施耐德（schneider）',''),(159313,'MOQI',''),(174275,'Essentials',''),(178969,'SAMWEI',''),(179105,'小霸王（SUBOR）',''),(179528,'VETAS',''),(179624,'优学派',''),(180213,'纽曼（Newman）',''),(194213,'DEVIALET',''),(196065,'SHANGPREE',''),(197126,'IMOO',''),(203084,'FNNI',''),(204089,'小格雷',''),(205278,'COTTEE',''),(209178,'YAAO',''),(214915,'纽曼',''),(219484,'CONQUEST',''),(221149,'铂爵（BIOJUET）',''),(222294,'荣耀',''),(223023,'保千里（PROTRULY）',''),(223199,'Blu',''),(223316,'unruly',''),(225085,'Tonino Lamborghini',''),(228280,'守护宝',''),(233984,'8848',''),(234746,'Gold Elite',''),(238798,'HONOR',''),(240112,'BIXING',''),(246053,'锐族',''),(247149,'国美（GOME）',''),(247652,'中兴健康（ZTE Health）',''),(248132,'YOSTAR',''),(249404,'创星',''),(253520,'VERTU',''),(261196,'LBER',''),(261480,'滝风（ION MEDIC）',''),(262180,'梦幻门（MENG HUAN MEN）',''),(262334,'意龍（E&L）',''),(264451,'艾尼卡（Anica）',''),(265247,'DMZ DAMUZHI',''),(267981,'UNNO',''),(271696,'红鸟',''),(276102,'紐萬（Niuwan）',''),(276381,'Podor',''),(276780,'海语（HAIYU）',''),(278268,'YISON',''),(278755,'SOAP',''),(279173,'renebelle',''),(280120,'AKESR',''),(280152,'YOTA',''),(284571,'HOOLFINE',''),(285331,'金柏利',''),(286273,'BLACKPOULO',''),(287292,'SIMPLEWAY',''),(290104,'KaiDC',''),(290682,'奥缇斯（autrise）',''),(302250,'橄榄树（Olive tree）',''),(304654,'HIGE',''),(314866,'360手机',''),(316578,'克里特（kreta）',''),(316596,'HOOLFINE',''),(316618,'RONXS',''),(325396,'飞利浦（PHILIPS）',''),(325398,'比亚兹（ESK）',''),(325399,'亿色(ESR)',''),(325401,'黑马','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg'),(325402,'chuanzhi','http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg');

/*Table structure for table `tb_category` */

DROP TABLE IF EXISTS `tb_category`;

CREATE TABLE `tb_category` (
  `id` bigint(20) NOT NULL,
  `cat_name` varchar(20) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `is_parent` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tb_category` */

insert  into `tb_category`(`id`,`cat_name`,`parent_id`,`is_parent`) values (1,'图书、音像、电子书刊',0,1),(2,'电子书刊',1,1),(3,'电子书',2,0),(4,'网络原创',2,0),(5,'数字杂志',2,0),(6,'多媒体图书',2,0),(7,'音像',1,1),(8,'音乐',7,0),(9,'影视',7,0),(10,'教育音像',7,0),(11,'英文原版',1,1),(12,'少儿',11,0),(13,'商务投资',11,0),(14,'英语学习与考试',11,0),(15,'文学',11,0),(16,'传记',11,0),(17,'励志',11,0),(18,'文艺',1,1),(19,'小说',18,0),(20,'文学',18,0),(21,'青春文学',18,0),(22,'传记',18,0),(23,'艺术',18,0),(24,'少儿',1,1),(25,'少儿',24,0),(26,'0-2岁',24,0),(27,'3-6岁',24,0),(28,'7-10岁',24,0),(29,'11-14岁',24,0),(30,'人文社科',1,1),(31,'历史',30,0),(32,'哲学',30,0),(33,'国学',30,0),(34,'政治/军事',30,0),(35,'法律',30,0),(36,'人文社科',30,0),(37,'心理学',30,0),(38,'文化',30,0),(39,'社会科学',30,0),(40,'经管励志',1,1),(41,'经济',40,0),(42,'金融与投资',40,0),(43,'管理',40,0),(44,'励志与成功',40,0),(45,'生活',1,1),(46,'生活',45,0),(47,'健身与保健',45,0),(48,'家庭与育儿',45,0),(49,'旅游',45,0),(50,'烹饪美食',45,0),(51,'科技',1,1),(52,'工业技术',51,0),(53,'科普读物',51,0),(54,'建筑',51,0),(55,'医学',51,0),(56,'科学与自然',51,0),(57,'计算机与互联网',51,0),(58,'电子通信',51,0),(59,'教育',1,1),(60,'中小学教辅',59,0),(61,'教育与考试',59,0),(62,'外语学习',59,0),(63,'大中专教材',59,0),(64,'字典词典',59,0),(65,'港台图书',1,1),(66,'艺术/设计/收藏',65,0),(67,'经济管理',65,0),(68,'文化/学术',65,0),(69,'少儿',65,0),(70,'其他',1,1),(71,'工具书',70,0),(72,'杂志/期刊',70,0),(73,'套装书',70,0),(74,'手机',0,1),(75,'手机通讯',74,1),(76,'手机',75,0),(77,'对讲机',75,0),(78,'运营商',74,1),(79,'合约机',78,0),(80,'选号中心',78,0),(81,'装宽带',78,0),(82,'办套餐',78,0),(83,'手机配件',74,1),(84,'移动电源',83,0),(85,'电池/移动电源',83,0),(86,'蓝牙耳机',83,0),(87,'充电器/数据线',83,0),(88,'苹果周边',83,0),(89,'手机耳机',83,0),(90,'手机贴膜',83,0),(91,'手机存储卡',83,0),(92,'充电器',83,0),(93,'数据线',83,0),(94,'手机保护套',83,0),(95,'车载配件',83,0),(96,'iPhone 配件',83,0),(97,'手机电池',83,0),(98,'创意配件',83,0),(99,'便携/无线音响',83,0),(100,'手机饰品',83,0),(101,'拍照配件',83,0),(102,'手机支架',83,0),(103,'家用电器',0,1),(104,'大 家 电',103,1),(105,'平板电视',104,0),(106,'空调',104,0),(107,'冰箱',104,0),(108,'洗衣机',104,0),(109,'家庭影院',104,0),(110,'DVD/电视盒子',104,0),(111,'迷你音响',104,0),(112,'冷柜/冰吧',104,0),(113,'家电配件',104,0),(114,'功放',104,0),(115,'回音壁/Soundbar',104,0),(116,'Hi-Fi专区',104,0),(117,'电视盒子',104,0),(118,'酒柜',104,0),(119,'厨卫大电',103,1),(120,'燃气灶',119,0),(121,'油烟机',119,0),(122,'热水器',119,0),(123,'消毒柜',119,0),(124,'洗碗机',119,0),(125,'厨房小电',103,1),(126,'料理机',125,0),(127,'榨汁机',125,0),(128,'电饭煲',125,0),(129,'电压力锅',125,0),(130,'豆浆机',125,0),(131,'咖啡机',125,0),(132,'微波炉',125,0),(133,'电烤箱',125,0),(134,'电磁炉',125,0),(135,'面包机',125,0),(136,'煮蛋器',125,0),(137,'酸奶机',125,0),(138,'电炖锅',125,0),(139,'电水壶/热水瓶',125,0),(140,'电饼铛',125,0),(141,'多用途锅',125,0),(142,'电烧烤炉',125,0),(143,'果蔬解毒机',125,0),(144,'其它厨房电器',125,0),(145,'养生壶/煎药壶',125,0),(146,'电热饭盒',125,0),(147,'生活电器',103,1),(148,'取暖电器',147,0),(149,'净化器',147,0),(150,'加湿器',147,0),(151,'扫地机器人',147,0),(152,'吸尘器',147,0),(153,'挂烫机/熨斗',147,0),(154,'插座',147,0),(155,'电话机',147,0),(156,'清洁机',147,0),(157,'除湿机',147,0),(158,'干衣机',147,0),(159,'收录/音机',147,0),(160,'电风扇',147,0),(161,'冷风扇',147,0),(162,'其它生活电器',147,0),(163,'生活电器配件',147,0),(164,'净水器',147,0),(165,'饮水机',147,0),(166,'个护健康',103,1),(167,'剃须刀',166,0),(168,'剃/脱毛器',166,0),(169,'口腔护理',166,0),(170,'电吹风',166,0),(171,'美容器',166,0),(172,'理发器',166,0),(173,'卷/直发器',166,0),(174,'按摩椅',166,0),(175,'按摩器',166,0),(176,'足浴盆',166,0),(177,'血压计',166,0),(178,'电子秤/厨房秤',166,0),(179,'血糖仪',166,0),(180,'体温计',166,0),(181,'其它健康电器',166,0),(182,'计步器/脂肪检测仪',166,0),(183,'五金家装',103,1),(184,'电动工具',183,0),(185,'手动工具',183,0),(186,'仪器仪表',183,0),(187,'浴霸/排气扇',183,0),(188,'灯具',183,0),(189,'LED灯',183,0),(190,'洁身器',183,0),(191,'水槽',183,0),(192,'龙头',183,0),(193,'淋浴花洒',183,0),(194,'厨卫五金',183,0),(195,'家具五金',183,0),(196,'门铃',183,0),(197,'电气开关',183,0),(198,'插座',183,0),(199,'电工电料',183,0),(200,'监控安防',183,0),(201,'电线/线缆',183,0),(202,'数码',0,1),(203,'摄影摄像',202,1),(204,'数码相机',203,0),(205,'单电/微单相机',203,0),(206,'单反相机',203,0),(207,'摄像机',203,0),(208,'拍立得',203,0),(209,'运动相机',203,0),(210,'镜头',203,0),(211,'户外器材',203,0),(212,'影棚器材',203,0),(213,'冲印服务',203,0),(214,'数码相框',203,0),(215,'数码配件',202,1),(216,'存储卡',215,0),(217,'读卡器',215,0),(218,'滤镜',215,0),(219,'闪光灯/手柄',215,0),(220,'相机包',215,0),(221,'三脚架/云台',215,0),(222,'相机清洁/贴膜',215,0),(223,'机身附件',215,0),(224,'镜头附件',215,0),(225,'电池/充电器',215,0),(226,'移动电源',215,0),(227,'数码支架',215,0),(228,'智能设备',202,1),(229,'智能手环',228,0),(230,'智能手表',228,0),(231,'智能眼镜',228,0),(232,'运动跟踪器',228,0),(233,'健康监测',228,0),(234,'智能配饰',228,0),(235,'智能家居',228,0),(236,'体感车',228,0),(237,'其他配件',228,0),(238,'智能机器人',228,0),(239,'无人机',228,0),(240,'影音娱乐',202,1),(241,'MP3/MP4',240,0),(242,'智能设备',240,0),(243,'耳机/耳麦',240,0),(244,'便携/无线音箱',240,0),(245,'音箱/音响',240,0),(246,'高清播放器',240,0),(247,'收音机',240,0),(248,'MP3/MP4配件',240,0),(249,'麦克风',240,0),(250,'专业音频',240,0),(251,'苹果配件',240,0),(252,'电子教育',202,1),(253,'学生平板',252,0),(254,'点读机/笔',252,0),(255,'早教益智',252,0),(256,'录音笔',252,0),(257,'电纸书',252,0),(258,'电子词典',252,0),(259,'复读机',252,0),(260,'虚拟商品',202,1),(261,'延保服务',260,0),(262,'杀毒软件',260,0),(263,'积分商品',260,0),(264,'家居家装',0,1),(265,'家纺',264,1),(266,'桌布/罩件',265,0),(267,'地毯地垫',265,0),(268,'沙发垫套/椅垫',265,0),(269,'床品套件',265,0),(270,'被子',265,0),(271,'枕芯',265,0),(272,'床单被罩',265,0),(273,'毯子',265,0),(274,'床垫/床褥',265,0),(275,'蚊帐',265,0),(276,'抱枕靠垫',265,0),(277,'毛巾浴巾',265,0),(278,'电热毯',265,0),(279,'窗帘/窗纱',265,0),(280,'布艺软饰',265,0),(281,'凉席',265,0),(282,'灯具',264,1),(283,'台灯',282,0),(284,'节能灯',282,0),(285,'装饰灯',282,0),(286,'落地灯',282,0),(287,'应急灯/手电',282,0),(288,'LED灯',282,0),(289,'吸顶灯',282,0),(290,'五金电器',282,0),(291,'筒灯射灯',282,0),(292,'吊灯',282,0),(293,'氛围照明',282,0),(294,'生活日用',264,1),(295,'保暖防护',294,0),(296,'收纳用品',294,0),(297,'雨伞雨具',294,0),(298,'浴室用品',294,0),(299,'缝纫/针织用品',294,0),(300,'洗晒/熨烫',294,0),(301,'净化除味',294,0),(302,'家装软饰',264,1),(303,'相框/照片墙',302,0),(304,'装饰字画',302,0),(305,'节庆饰品',302,0),(306,'手工/十字绣',302,0),(307,'装饰摆件',302,0),(308,'帘艺隔断',302,0),(309,'墙贴/装饰贴',302,0),(310,'钟饰',302,0),(311,'花瓶花艺',302,0),(312,'香薰蜡烛',302,0),(313,'创意家居',302,0),(314,'宠物生活',264,1),(315,'宠物主粮',314,0),(316,'宠物零食',314,0),(317,'医疗保健',314,0),(318,'家居日用',314,0),(319,'宠物玩具',314,0),(320,'出行装备',314,0),(321,'洗护美容',314,0),(322,'电脑办公',0,1),(323,'电脑整机',322,1),(324,'笔记本',323,0),(325,'超极本',323,0),(326,'游戏本',323,0),(327,'平板电脑',323,0),(328,'平板电脑配件',323,0),(329,'台式机',323,0),(330,'服务器/工作站',323,0),(331,'笔记本配件',323,0),(332,'一体机',323,0),(333,'电脑配件',322,1),(334,'CPU',333,0),(335,'主板',333,0),(336,'显卡',333,0),(337,'硬盘',333,0),(338,'SSD固态硬盘',333,0),(339,'内存',333,0),(340,'机箱',333,0),(341,'电源',333,0),(342,'显示器',333,0),(343,'刻录机/光驱',333,0),(344,'散热器',333,0),(345,'声卡/扩展卡',333,0),(346,'装机配件',333,0),(347,'组装电脑',333,0),(348,'外设产品',322,1),(349,'移动硬盘',348,0),(350,'U盘',348,0),(351,'鼠标',348,0),(352,'键盘',348,0),(353,'鼠标垫',348,0),(354,'摄像头',348,0),(355,'手写板',348,0),(356,'硬盘盒',348,0),(357,'插座',348,0),(358,'线缆',348,0),(359,'UPS电源',348,0),(360,'电脑工具',348,0),(361,'游戏设备',348,0),(362,'电玩',348,0),(363,'电脑清洁',348,0),(364,'网络仪表仪器',348,0),(365,'游戏设备',322,1),(366,'游戏机',365,0),(367,'游戏耳机',365,0),(368,'手柄/方向盘',365,0),(369,'游戏软件',365,0),(370,'游戏周边',365,0),(371,'网络产品',322,1),(372,'路由器',371,0),(373,'网卡',371,0),(374,'交换机',371,0),(375,'网络存储',371,0),(376,'4G/3G上网',371,0),(377,'网络盒子',371,0),(378,'网络配件',371,0),(379,'办公设备',322,1),(380,'投影机',379,0),(381,'投影配件',379,0),(382,'多功能一体机',379,0),(383,'打印机',379,0),(384,'传真设备',379,0),(385,'验钞/点钞机',379,0),(386,'扫描设备',379,0),(387,'复合机',379,0),(388,'碎纸机',379,0),(389,'考勤机',379,0),(390,'收款/POS机',379,0),(391,'会议音频视频',379,0),(392,'保险柜',379,0),(393,'装订/封装机',379,0),(394,'安防监控',379,0),(395,'办公家具',379,0),(396,'白板',379,0),(397,'文具/耗材',322,1),(398,'硒鼓/墨粉',397,0),(399,'墨盒',397,0),(400,'色带',397,0),(401,'纸类',397,0),(402,'办公文具',397,0),(403,'学生文具',397,0),(404,'财会用品',397,0),(405,'文件管理',397,0),(406,'本册/便签',397,0),(407,'计算器',397,0),(408,'笔类',397,0),(409,'画具画材',397,0),(410,'刻录碟片/附件',397,0),(411,'服务产品',322,1),(412,'上门安装',411,0),(413,'延保服务',411,0),(414,'维修保养',411,0),(415,'电脑软件',411,0),(416,'京东服务',411,0),(417,'厨具',0,1),(418,'烹饪锅具',417,1),(419,'炒锅',418,0),(420,'煎锅',418,0),(421,'压力锅',418,0),(422,'蒸锅',418,0),(423,'汤锅',418,0),(424,'奶锅',418,0),(425,'锅具套装',418,0),(426,'煲类',418,0),(427,'水壶',418,0),(428,'火锅',418,0),(429,'刀剪菜板',417,1),(430,'菜刀',429,0),(431,'剪刀',429,0),(432,'刀具套装',429,0),(433,'砧板',429,0),(434,'瓜果刀/刨',429,0),(435,'多功能刀',429,0),(436,'厨房配件',417,1),(437,'保鲜盒',436,0),(438,'烘焙/烧烤',436,0),(439,'饭盒/提锅',436,0),(440,'储物/置物架',436,0),(441,'厨房DIY/小工具',436,0),(442,'水具酒具',417,1),(443,'塑料杯',442,0),(444,'运动水壶',442,0),(445,'玻璃杯',442,0),(446,'陶瓷/马克杯',442,0),(447,'保温杯',442,0),(448,'保温壶',442,0),(449,'酒杯/酒具',442,0),(450,'杯具套装',442,0),(451,'餐具',417,1),(452,'餐具套装',451,0),(453,'碗/碟/盘',451,0),(454,'筷勺/刀叉',451,0),(455,'一次性用品',451,0),(456,'果盘/果篮',451,0),(457,'酒店用品',417,1),(458,'自助餐炉',457,0),(459,'酒店餐具',457,0),(460,'酒店水具',457,0),(461,'茶具/咖啡具',417,1),(462,'整套茶具',461,0),(463,'茶杯',461,0),(464,'茶壶',461,0),(465,'茶盘茶托',461,0),(466,'茶叶罐',461,0),(467,'茶具配件',461,0),(468,'茶宠摆件',461,0),(469,'咖啡具',461,0),(470,'其他',461,0),(471,'个护化妆',0,1),(472,'清洁用品',471,1),(473,'纸品湿巾',472,0),(474,'衣物清洁',472,0),(475,'清洁工具',472,0),(476,'驱虫用品',472,0),(477,'家庭清洁',472,0),(478,'皮具护理',472,0),(479,'一次性用品',472,0),(480,'面部护肤',471,1),(481,'洁面',480,0),(482,'乳液面霜',480,0),(483,'面膜',480,0),(484,'剃须',480,0),(485,'套装',480,0),(486,'精华',480,0),(487,'眼霜',480,0),(488,'卸妆',480,0),(489,'防晒',480,0),(490,'防晒隔离',480,0),(491,'T区护理',480,0),(492,'眼部护理',480,0),(493,'精华露',480,0),(494,'爽肤水',480,0),(495,'身体护理',471,1),(496,'沐浴',495,0),(497,'润肤',495,0),(498,'颈部',495,0),(499,'手足',495,0),(500,'纤体塑形',495,0),(501,'美胸',495,0),(502,'套装',495,0),(503,'精油',495,0),(504,'洗发护发',495,0),(505,'染发/造型',495,0),(506,'香薰精油',495,0),(507,'磨砂/浴盐',495,0),(508,'手工/香皂',495,0),(509,'洗发',495,0),(510,'护发',495,0),(511,'染发',495,0),(512,'磨砂膏',495,0),(513,'香皂',495,0),(514,'口腔护理',471,1),(515,'牙膏/牙粉',514,0),(516,'牙刷/牙线',514,0),(517,'漱口水',514,0),(518,'套装',514,0),(519,'女性护理',471,1),(520,'卫生巾',519,0),(521,'卫生护垫',519,0),(522,'私密护理',519,0),(523,'脱毛膏',519,0),(524,'其他',519,0),(525,'洗发护发',471,1),(526,'洗发',525,0),(527,'护发',525,0),(528,'染发',525,0),(529,'造型',525,0),(530,'假发',525,0),(531,'套装',525,0),(532,'美发工具',525,0),(533,'脸部护理',525,0),(534,'香水彩妆',471,1),(535,'香水',534,0),(536,'底妆',534,0),(537,'腮红',534,0),(538,'眼影',534,0),(539,'唇部',534,0),(540,'美甲',534,0),(541,'眼线',534,0),(542,'美妆工具',534,0),(543,'套装',534,0),(544,'防晒隔离',534,0),(545,'卸妆',534,0),(546,'眉笔',534,0),(547,'睫毛膏',534,0),(548,'服饰内衣',0,1),(549,'女装',548,1),(550,'T恤',549,0),(551,'衬衫',549,0),(552,'针织衫',549,0),(553,'雪纺衫',549,0),(554,'卫衣',549,0),(555,'马甲',549,0),(556,'连衣裙',549,0),(557,'半身裙',549,0),(558,'牛仔裤',549,0),(559,'休闲裤',549,0),(560,'打底裤',549,0),(561,'正装裤',549,0),(562,'小西装',549,0),(563,'短外套',549,0),(564,'风衣',549,0),(565,'毛呢大衣',549,0),(566,'真皮皮衣',549,0),(567,'棉服',549,0),(568,'羽绒服',549,0),(569,'大码女装',549,0),(570,'中老年女装',549,0),(571,'婚纱',549,0),(572,'打底衫',549,0),(573,'旗袍/唐装',549,0),(574,'加绒裤',549,0),(575,'吊带/背心',549,0),(576,'羊绒衫',549,0),(577,'短裤',549,0),(578,'皮草',549,0),(579,'礼服',549,0),(580,'仿皮皮衣',549,0),(581,'羊毛衫',549,0),(582,'设计师/潮牌',549,0),(583,'男装',548,1),(584,'衬衫',583,0),(585,'T恤',583,0),(586,'POLO衫',583,0),(587,'针织衫',583,0),(588,'羊绒衫',583,0),(589,'卫衣',583,0),(590,'马甲/背心',583,0),(591,'夹克',583,0),(592,'风衣',583,0),(593,'毛呢大衣',583,0),(594,'仿皮皮衣',583,0),(595,'西服',583,0),(596,'棉服',583,0),(597,'羽绒服',583,0),(598,'牛仔裤',583,0),(599,'休闲裤',583,0),(600,'西裤',583,0),(601,'西服套装',583,0),(602,'大码男装',583,0),(603,'中老年男装',583,0),(604,'唐装/中山装',583,0),(605,'工装',583,0),(606,'真皮皮衣',583,0),(607,'加绒裤',583,0),(608,'卫裤/运动裤',583,0),(609,'短裤',583,0),(610,'设计师/潮牌',583,0),(611,'羊毛衫',583,0),(612,'内衣',548,1),(613,'文胸',612,0),(614,'女式内裤',612,0),(615,'男式内裤',612,0),(616,'睡衣/家居服',612,0),(617,'塑身美体',612,0),(618,'泳衣',612,0),(619,'吊带/背心',612,0),(620,'抹胸',612,0),(621,'连裤袜/丝袜',612,0),(622,'美腿袜',612,0),(623,'商务男袜',612,0),(624,'保暖内衣',612,0),(625,'情侣睡衣',612,0),(626,'文胸套装',612,0),(627,'少女文胸',612,0),(628,'休闲棉袜',612,0),(629,'大码内衣',612,0),(630,'内衣配件',612,0),(631,'打底裤袜',612,0),(632,'打底衫',612,0),(633,'秋衣秋裤',612,0),(634,'情趣内衣',612,0),(635,'洗衣服务',548,1),(636,'服装洗护',635,0),(637,'服饰配件',548,1),(638,'太阳镜',637,0),(639,'光学镜架/镜片',637,0),(640,'围巾/手套/帽子套装',637,0),(641,'袖扣',637,0),(642,'棒球帽',637,0),(643,'毛线帽',637,0),(644,'遮阳帽',637,0),(645,'老花镜',637,0),(646,'装饰眼镜',637,0),(647,'防辐射眼镜',637,0),(648,'游泳镜',637,0),(649,'女士丝巾/围巾/披肩',637,0),(650,'男士丝巾/围巾',637,0),(651,'鸭舌帽',637,0),(652,'贝雷帽',637,0),(653,'礼帽',637,0),(654,'真皮手套',637,0),(655,'毛线手套',637,0),(656,'防晒手套',637,0),(657,'男士腰带/礼盒',637,0),(658,'女士腰带/礼盒',637,0),(659,'钥匙扣',637,0),(660,'遮阳伞/雨伞',637,0),(661,'口罩',637,0),(662,'耳罩/耳包',637,0),(663,'假领',637,0),(664,'毛线/布面料',637,0),(665,'领带/领结/领带夹',637,0),(666,'钟表',0,1),(667,'钟表',666,1),(668,'男表',667,0),(669,'瑞表',667,0),(670,'女表',667,0),(671,'国表',667,0),(672,'日韩表',667,0),(673,'欧美表',667,0),(674,'德表',667,0),(675,'儿童手表',667,0),(676,'智能手表',667,0),(677,'闹钟',667,0),(678,'座钟挂钟',667,0),(679,'钟表配件',667,0),(680,'鞋靴',0,1),(681,'流行男鞋',680,1),(682,'商务休闲鞋',681,0),(683,'正装鞋',681,0),(684,'休闲鞋',681,0),(685,'凉鞋/沙滩鞋',681,0),(686,'男靴',681,0),(687,'功能鞋',681,0),(688,'拖鞋/人字拖',681,0),(689,'雨鞋/雨靴',681,0),(690,'传统布鞋',681,0),(691,'鞋配件',681,0),(692,'帆布鞋',681,0),(693,'增高鞋',681,0),(694,'工装鞋',681,0),(695,'定制鞋',681,0),(696,'时尚女鞋',680,1),(697,'高跟鞋',696,0),(698,'单鞋',696,0),(699,'休闲鞋',696,0),(700,'凉鞋',696,0),(701,'女靴',696,0),(702,'雪地靴',696,0),(703,'拖鞋/人字拖',696,0),(704,'踝靴',696,0),(705,'筒靴',696,0),(706,'帆布鞋',696,0),(707,'雨鞋/雨靴',696,0),(708,'妈妈鞋',696,0),(709,'鞋配件',696,0),(710,'特色鞋',696,0),(711,'鱼嘴鞋',696,0),(712,'布鞋/绣花鞋',696,0),(713,'马丁靴',696,0),(714,'坡跟鞋',696,0),(715,'松糕鞋',696,0),(716,'内增高',696,0),(717,'防水台',696,0),(718,'母婴',0,1),(719,'奶粉',718,1),(720,'婴幼奶粉',719,0),(721,'孕妈奶粉',719,0),(722,'营养辅食',718,1),(723,'益生菌/初乳',722,0),(724,'米粉/菜粉',722,0),(725,'果泥/果汁',722,0),(726,'DHA',722,0),(727,'宝宝零食',722,0),(728,'钙铁锌/维生素',722,0),(729,'清火/开胃',722,0),(730,'面条/粥',722,0),(731,'尿裤湿巾',718,1),(732,'婴儿尿裤',731,0),(733,'拉拉裤',731,0),(734,'婴儿湿巾',731,0),(735,'成人尿裤',731,0),(736,'喂养用品',718,1),(737,'奶瓶奶嘴',736,0),(738,'吸奶器',736,0),(739,'暖奶消毒',736,0),(740,'儿童餐具',736,0),(741,'水壶/水杯',736,0),(742,'牙胶安抚',736,0),(743,'围兜/防溅衣',736,0),(744,'辅食料理机',736,0),(745,'食物存储',736,0),(746,'洗护用品',718,1),(747,'宝宝护肤',746,0),(748,'洗发沐浴',746,0),(749,'奶瓶清洗',746,0),(750,'驱蚊防晒',746,0),(751,'理发器',746,0),(752,'洗澡用具',746,0),(753,'婴儿口腔清洁',746,0),(754,'洗衣液/皂',746,0),(755,'日常护理',746,0),(756,'座便器',746,0),(757,'童车童床',718,1),(758,'婴儿推车',757,0),(759,'餐椅摇椅',757,0),(760,'婴儿床',757,0),(761,'学步车',757,0),(762,'三轮车',757,0),(763,'自行车',757,0),(764,'电动车',757,0),(765,'扭扭车',757,0),(766,'滑板车',757,0),(767,'婴儿床垫',757,0),(768,'寝居服饰',718,1),(769,'婴儿外出服',768,0),(770,'婴儿内衣',768,0),(771,'婴儿礼盒',768,0),(772,'婴儿鞋帽袜',768,0),(773,'安全防护',768,0),(774,'家居床品',768,0),(775,'睡袋/抱被',768,0),(776,'爬行垫',768,0),(777,'妈妈专区',718,1),(778,'妈咪包/背婴带',777,0),(779,'产后塑身',777,0),(780,'文胸/内裤',777,0),(781,'防辐射服',777,0),(782,'孕妈装',777,0),(783,'孕期营养',777,0),(784,'孕妇护肤',777,0),(785,'待产护理',777,0),(786,'月子装',777,0),(787,'防溢乳垫',777,0),(788,'童装童鞋',718,1),(789,'套装',788,0),(790,'上衣',788,0),(791,'裤子',788,0),(792,'裙子',788,0),(793,'内衣/家居服',788,0),(794,'羽绒服/棉服',788,0),(795,'亲子装',788,0),(796,'儿童配饰',788,0),(797,'礼服/演出服',788,0),(798,'运动鞋',788,0),(799,'皮鞋/帆布鞋',788,0),(800,'靴子',788,0),(801,'凉鞋',788,0),(802,'功能鞋',788,0),(803,'户外/运动服',788,0),(804,'安全座椅',718,1),(805,'提篮式',804,0),(806,'安全座椅',804,0),(807,'增高垫',804,0),(808,'礼品箱包',0,1),(809,'潮流女包',808,1),(810,'钱包',809,0),(811,'手拿包',809,0),(812,'单肩包',809,0),(813,'双肩包',809,0),(814,'手提包',809,0),(815,'斜挎包',809,0),(816,'钥匙包',809,0),(817,'卡包/零钱包',809,0),(818,'精品男包',808,1),(819,'男士钱包',818,0),(820,'男士手包',818,0),(821,'卡包名片夹',818,0),(822,'商务公文包',818,0),(823,'双肩包',818,0),(824,'单肩/斜挎包',818,0),(825,'钥匙包',818,0),(826,'功能箱包',808,1),(827,'电脑包',826,0),(828,'拉杆箱',826,0),(829,'旅行包',826,0),(830,'旅行配件',826,0),(831,'休闲运动包',826,0),(832,'拉杆包',826,0),(833,'登山包',826,0),(834,'妈咪包',826,0),(835,'书包',826,0),(836,'相机包',826,0),(837,'腰包/胸包',826,0),(838,'礼品',808,1),(839,'火机烟具',838,0),(840,'礼品文具',838,0),(841,'军刀军具',838,0),(842,'收藏品',838,0),(843,'工艺礼品',838,0),(844,'创意礼品',838,0),(845,'礼盒礼券',838,0),(846,'鲜花绿植',838,0),(847,'婚庆节庆',838,0),(848,'京东卡',838,0),(849,'美妆礼品',838,0),(850,'礼品定制',838,0),(851,'京东福卡',838,0),(852,'古董文玩',838,0),(853,'奢侈品',808,1),(854,'箱包',853,0),(855,'钱包',853,0),(856,'服饰',853,0),(857,'腰带',853,0),(858,'太阳镜/眼镜框',853,0),(859,'配件',853,0),(860,'鞋靴',853,0),(861,'饰品',853,0),(862,'名品腕表',853,0),(863,'高档化妆品',853,0),(864,'婚庆',808,1),(865,'婚嫁首饰',864,0),(866,'婚纱摄影',864,0),(867,'婚纱礼服',864,0),(868,'婚庆服务',864,0),(869,'婚庆礼品/用品',864,0),(870,'婚宴',864,0),(871,'食品饮料、保健食品',0,1),(872,'进口食品',871,1),(873,'饼干蛋糕',872,0),(874,'糖果/巧克力',872,0),(875,'休闲零食',872,0),(876,'冲调饮品',872,0),(877,'粮油调味',872,0),(878,'牛奶',872,0),(879,'地方特产',871,1),(880,'其他特产',879,0),(881,'新疆',879,0),(882,'北京',879,0),(883,'山西',879,0),(884,'内蒙古',879,0),(885,'福建',879,0),(886,'湖南',879,0),(887,'四川',879,0),(888,'云南',879,0),(889,'东北',879,0),(890,'休闲食品',871,1),(891,'休闲零食',890,0),(892,'坚果炒货',890,0),(893,'肉干肉脯',890,0),(894,'蜜饯果干',890,0),(895,'糖果/巧克力',890,0),(896,'饼干蛋糕',890,0),(897,'无糖食品',890,0),(898,'粮油调味',871,1),(899,'米面杂粮',898,0),(900,'食用油',898,0),(901,'调味品',898,0),(902,'南北干货',898,0),(903,'方便食品',898,0),(904,'有机食品',898,0),(905,'饮料冲调',871,1),(906,'饮用水',905,0),(907,'饮料',905,0),(908,'牛奶乳品',905,0),(909,'咖啡/奶茶',905,0),(910,'冲饮谷物',905,0),(911,'蜂蜜/柚子茶',905,0),(912,'成人奶粉',905,0),(913,'食品礼券',871,1),(914,'月饼',913,0),(915,'大闸蟹',913,0),(916,'粽子',913,0),(917,'卡券',913,0),(918,'茗茶',871,1),(919,'铁观音',918,0),(920,'普洱',918,0),(921,'龙井',918,0),(922,'绿茶',918,0),(923,'红茶',918,0),(924,'乌龙茶',918,0),(925,'花草茶',918,0),(926,'花果茶',918,0),(927,'养生茶',918,0),(928,'黑茶',918,0),(929,'白茶',918,0),(930,'其它茶',918,0),(931,'珠宝',0,1),(932,'时尚饰品',931,1),(933,'项链',932,0),(934,'手链/脚链',932,0),(935,'戒指',932,0),(936,'耳饰',932,0),(937,'毛衣链',932,0),(938,'发饰/发卡',932,0),(939,'胸针',932,0),(940,'饰品配件',932,0),(941,'婚庆饰品',932,0),(942,'黄金',931,1),(943,'黄金吊坠',942,0),(944,'黄金项链',942,0),(945,'黄金转运珠',942,0),(946,'黄金手镯/手链/脚链',942,0),(947,'黄金耳饰',942,0),(948,'黄金戒指',942,0),(949,'K金饰品',931,1),(950,'K金吊坠',949,0),(951,'K金项链',949,0),(952,'K金手镯/手链/脚链',949,0),(953,'K金戒指',949,0),(954,'K金耳饰',949,0),(955,'金银投资',931,1),(956,'投资金',955,0),(957,'投资银',955,0),(958,'投资收藏',955,0),(959,'银饰',931,1),(960,'银吊坠/项链',959,0),(961,'银手镯/手链/脚链',959,0),(962,'银戒指',959,0),(963,'银耳饰',959,0),(964,'足银手镯',959,0),(965,'宝宝银饰',959,0),(966,'钻石',931,1),(967,'裸钻',966,0),(968,'钻戒',966,0),(969,'钻石项链/吊坠',966,0),(970,'钻石耳饰',966,0),(971,'钻石手镯/手链',966,0),(972,'翡翠玉石',931,1),(973,'项链/吊坠',972,0),(974,'手镯/手串',972,0),(975,'戒指',972,0),(976,'耳饰',972,0),(977,'挂件/摆件/把件',972,0),(978,'玉石孤品',972,0),(979,'水晶玛瑙',931,1),(980,'项链/吊坠',979,0),(981,'耳饰',979,0),(982,'手镯/手链/脚链',979,0),(983,'戒指',979,0),(984,'头饰/胸针',979,0),(985,'摆件/挂件',979,0),(986,'彩宝',931,1),(987,'琥珀/蜜蜡',986,0),(988,'碧玺',986,0),(989,'红宝石/蓝宝石',986,0),(990,'坦桑石',986,0),(991,'珊瑚',986,0),(992,'祖母绿',986,0),(993,'葡萄石',986,0),(994,'其他天然宝石',986,0),(995,'项链/吊坠',986,0),(996,'耳饰',986,0),(997,'手镯/手链',986,0),(998,'戒指',986,0),(999,'铂金',931,1),(1000,'铂金项链/吊坠',999,0),(1001,'铂金手镯/手链/脚链',999,0),(1002,'铂金戒指',999,0),(1003,'铂金耳饰',999,0),(1004,'木手串/把件',931,1),(1005,'小叶紫檀',1004,0),(1006,'黄花梨',1004,0),(1007,'沉香木',1004,0),(1008,'金丝楠',1004,0),(1009,'菩提',1004,0),(1010,'其他',1004,0),(1011,'橄榄核/核桃',1004,0),(1012,'檀香',1004,0),(1013,'珍珠',931,1),(1014,'珍珠项链',1013,0),(1015,'珍珠吊坠',1013,0),(1016,'珍珠耳饰',1013,0),(1017,'珍珠手链',1013,0),(1018,'珍珠戒指',1013,0),(1019,'珍珠胸针',1013,0),(1020,'汽车用品',0,1),(1021,'维修保养',1020,1),(1022,'机油',1021,0),(1023,'正时皮带',1021,0),(1024,'添加剂',1021,0),(1025,'汽车喇叭',1021,0),(1026,'防冻液',1021,0),(1027,'汽车玻璃',1021,0),(1028,'滤清器',1021,0),(1029,'火花塞',1021,0),(1030,'减震器',1021,0),(1031,'柴机油/辅助油',1021,0),(1032,'雨刷',1021,0),(1033,'车灯',1021,0),(1034,'后视镜',1021,0),(1035,'轮胎',1021,0),(1036,'轮毂',1021,0),(1037,'刹车片/盘',1021,0),(1038,'维修配件',1021,0),(1039,'蓄电池',1021,0),(1040,'底盘装甲/护板',1021,0),(1041,'贴膜',1021,0),(1042,'汽修工具',1021,0),(1043,'改装配件',1021,0),(1044,'车载电器',1020,1),(1045,'导航仪',1044,0),(1046,'安全预警仪',1044,0),(1047,'行车记录仪',1044,0),(1048,'倒车雷达',1044,0),(1049,'蓝牙设备',1044,0),(1050,'车载影音',1044,0),(1051,'净化器',1044,0),(1052,'电源',1044,0),(1053,'智能驾驶',1044,0),(1054,'车载电台',1044,0),(1055,'车载电器配件',1044,0),(1056,'吸尘器',1044,0),(1057,'智能车机',1044,0),(1058,'冰箱',1044,0),(1059,'汽车音响',1044,0),(1060,'车载生活电器',1044,0),(1061,'美容清洗',1020,1),(1062,'车蜡',1061,0),(1063,'补漆笔',1061,0),(1064,'玻璃水',1061,0),(1065,'清洁剂',1061,0),(1066,'洗车工具',1061,0),(1067,'镀晶镀膜',1061,0),(1068,'打蜡机',1061,0),(1069,'洗车配件',1061,0),(1070,'洗车机',1061,0),(1071,'洗车水枪',1061,0),(1072,'毛巾掸子',1061,0),(1073,'汽车装饰',1020,1),(1074,'脚垫',1073,0),(1075,'座垫',1073,0),(1076,'座套',1073,0),(1077,'后备箱垫',1073,0),(1078,'头枕腰靠',1073,0),(1079,'方向盘套',1073,0),(1080,'香水',1073,0),(1081,'空气净化',1073,0),(1082,'挂件摆件',1073,0),(1083,'功能小件',1073,0),(1084,'车身装饰件',1073,0),(1085,'车衣',1073,0),(1086,'安全自驾',1020,1),(1087,'安全座椅',1086,0),(1088,'胎压监测',1086,0),(1089,'防盗设备',1086,0),(1090,'应急救援',1086,0),(1091,'保温箱',1086,0),(1092,'地锁',1086,0),(1093,'摩托车',1086,0),(1094,'充气泵',1086,0),(1095,'储物箱',1086,0),(1096,'自驾野营',1086,0),(1097,'摩托车装备',1086,0),(1098,'汽车服务',1020,1),(1099,'清洗美容',1098,0),(1100,'功能升级',1098,0),(1101,'保养维修',1098,0),(1102,'油卡充值',1098,0),(1103,'车险',1098,0),(1104,'加油卡',1098,0),(1105,'ETC',1098,0),(1106,'驾驶培训',1098,0),(1107,'赛事改装',1020,1),(1108,'赛事服装',1107,0),(1109,'赛事用品',1107,0),(1110,'制动系统',1107,0),(1111,'悬挂系统',1107,0),(1112,'进气系统',1107,0),(1113,'排气系统',1107,0),(1114,'电子管理',1107,0),(1115,'车身强化',1107,0),(1116,'赛事座椅',1107,0),(1117,'运动健康',0,1),(1118,'运动鞋包',1117,1),(1119,'跑步鞋',1118,0),(1120,'休闲鞋',1118,0),(1121,'篮球鞋',1118,0),(1122,'板鞋',1118,0),(1123,'帆布鞋',1118,0),(1124,'足球鞋',1118,0),(1125,'乒羽网鞋',1118,0),(1126,'专项运动鞋',1118,0),(1127,'训练鞋',1118,0),(1128,'拖鞋',1118,0),(1129,'运动包',1118,0),(1130,'运动服饰',1117,1),(1131,'羽绒服',1130,0),(1132,'棉服',1130,0),(1133,'运动裤',1130,0),(1134,'夹克/风衣',1130,0),(1135,'卫衣/套头衫',1130,0),(1136,'T恤',1130,0),(1137,'套装',1130,0),(1138,'乒羽网服',1130,0),(1139,'健身服',1130,0),(1140,'运动背心',1130,0),(1141,'毛衫/线衫',1130,0),(1142,'运动配饰',1130,0),(1143,'骑行运动',1117,1),(1144,'折叠车',1143,0),(1145,'山地车/公路车',1143,0),(1146,'电动车',1143,0),(1147,'其他整车',1143,0),(1148,'骑行服',1143,0),(1149,'骑行装备',1143,0),(1150,'平衡车',1143,0),(1151,'垂钓用品',1117,1),(1152,'鱼竿鱼线',1151,0),(1153,'浮漂鱼饵',1151,0),(1154,'钓鱼桌椅',1151,0),(1155,'钓鱼配件',1151,0),(1156,'钓箱鱼包',1151,0),(1157,'其它',1151,0),(1158,'游泳用品',1117,1),(1159,'泳镜',1158,0),(1160,'泳帽',1158,0),(1161,'游泳包防水包',1158,0),(1162,'女士泳衣',1158,0),(1163,'男士泳衣',1158,0),(1164,'比基尼',1158,0),(1165,'其它',1158,0),(1166,'户外鞋服',1117,1),(1167,'冲锋衣裤',1166,0),(1168,'速干衣裤',1166,0),(1169,'滑雪服',1166,0),(1170,'羽绒服/棉服',1166,0),(1171,'休闲衣裤',1166,0),(1172,'抓绒衣裤',1166,0),(1173,'软壳衣裤',1166,0),(1174,'T恤',1166,0),(1175,'户外风衣',1166,0),(1176,'功能内衣',1166,0),(1177,'军迷服饰',1166,0),(1178,'登山鞋',1166,0),(1179,'雪地靴',1166,0),(1180,'徒步鞋',1166,0),(1181,'越野跑鞋',1166,0),(1182,'休闲鞋',1166,0),(1183,'工装鞋',1166,0),(1184,'溯溪鞋',1166,0),(1185,'沙滩/凉拖',1166,0),(1186,'户外袜',1166,0),(1187,'户外装备',1117,1),(1188,'帐篷/垫子',1187,0),(1189,'睡袋/吊床',1187,0),(1190,'登山攀岩',1187,0),(1191,'户外配饰',1187,0),(1192,'背包',1187,0),(1193,'户外照明',1187,0),(1194,'户外仪表',1187,0),(1195,'户外工具',1187,0),(1196,'望远镜',1187,0),(1197,'旅游用品',1187,0),(1198,'便携桌椅床',1187,0),(1199,'野餐烧烤',1187,0),(1200,'军迷用品',1187,0),(1201,'救援装备',1187,0),(1202,'滑雪装备',1187,0),(1203,'极限户外',1187,0),(1204,'冲浪潜水',1187,0),(1205,'健身训练',1117,1),(1206,'综合训练器',1205,0),(1207,'其他大型器械',1205,0),(1208,'哑铃',1205,0),(1209,'仰卧板/收腹机',1205,0),(1210,'其他中小型器材',1205,0),(1211,'瑜伽舞蹈',1205,0),(1212,'甩脂机',1205,0),(1213,'踏步机',1205,0),(1214,'武术搏击',1205,0),(1215,'健身车/动感单车',1205,0),(1216,'跑步机',1205,0),(1217,'运动护具',1205,0),(1218,'体育用品',1117,1),(1219,'羽毛球',1218,0),(1220,'乒乓球',1218,0),(1221,'篮球',1218,0),(1222,'足球',1218,0),(1223,'网球',1218,0),(1224,'排球',1218,0),(1225,'高尔夫',1218,0),(1226,'台球',1218,0),(1227,'棋牌麻将',1218,0),(1228,'轮滑滑板',1218,0),(1229,'其他',1218,0),(1230,'玩具乐器',0,1),(1231,'适用年龄',1230,1),(1232,'0-6个月',1231,0),(1233,'6-12个月',1231,0),(1234,'1-3岁',1231,0),(1235,'3-6岁',1231,0),(1236,'6-14岁',1231,0),(1237,'14岁以上',1231,0),(1238,'遥控/电动',1230,1),(1239,'遥控车',1238,0),(1240,'遥控飞机',1238,0),(1241,'遥控船',1238,0),(1242,'机器人',1238,0),(1243,'轨道/助力',1238,0),(1244,'毛绒布艺',1230,1),(1245,'毛绒/布艺',1244,0),(1246,'靠垫/抱枕',1244,0),(1247,'娃娃玩具',1230,1),(1248,'芭比娃娃',1247,0),(1249,'卡通娃娃',1247,0),(1250,'智能娃娃',1247,0),(1251,'模型玩具',1230,1),(1252,'仿真模型',1251,0),(1253,'拼插模型',1251,0),(1254,'收藏爱好',1251,0),(1255,'健身玩具',1230,1),(1256,'炫舞毯',1255,0),(1257,'爬行垫/毯',1255,0),(1258,'户外玩具',1255,0),(1259,'戏水玩具',1255,0),(1260,'动漫玩具',1230,1),(1261,'电影周边',1260,0),(1262,'卡通周边',1260,0),(1263,'网游周边',1260,0),(1264,'益智玩具',1230,1),(1265,'摇铃/床铃',1264,0),(1266,'健身架',1264,0),(1267,'早教启智',1264,0),(1268,'拖拉玩具',1264,0),(1269,'积木拼插',1230,1),(1270,'积木',1269,0),(1271,'拼图',1269,0),(1272,'磁力棒',1269,0),(1273,'立体拼插',1269,0),(1274,'DIY玩具',1230,1),(1275,'手工彩泥',1274,0),(1276,'绘画工具',1274,0),(1277,'情景玩具',1274,0),(1278,'创意减压',1230,1),(1279,'减压玩具',1278,0),(1280,'创意玩具',1278,0),(1281,'乐器',1230,1),(1282,'钢琴',1281,0),(1283,'电子琴/电钢琴',1281,0),(1284,'吉他/尤克里里',1281,0),(1285,'打击乐器',1281,0),(1286,'西洋管弦',1281,0),(1287,'民族管弦乐器',1281,0),(1288,'乐器配件',1281,0),(1289,'电脑音乐',1281,0),(1290,'工艺礼品乐器',1281,0),(1291,'口琴/口风琴/竖笛',1281,0),(1292,'手风琴',1281,0),(1293,'彩票、旅行、充值、票务',0,1),(1294,'彩票',1293,1),(1295,'双色球',1294,0),(1296,'大乐透',1294,0),(1297,'福彩3D',1294,0),(1298,'排列三',1294,0),(1299,'排列五',1294,0),(1300,'七星彩',1294,0),(1301,'七乐彩',1294,0),(1302,'竞彩足球',1294,0),(1303,'竞彩篮球',1294,0),(1304,'新时时彩',1294,0),(1305,'机票',1293,1),(1306,'国内机票',1305,0),(1307,'酒店',1293,1),(1308,'国内酒店',1307,0),(1309,'酒店团购',1307,0),(1310,'旅行',1293,1),(1311,'度假',1310,0),(1312,'景点',1310,0),(1313,'租车',1310,0),(1314,'火车票',1310,0),(1315,'旅游团购',1310,0),(1316,'充值',1293,1),(1317,'手机充值',1316,0),(1318,'游戏',1293,1),(1319,'游戏点卡',1318,0),(1320,'QQ充值',1318,0),(1321,'票务',1293,1),(1322,'电影票',1321,0),(1323,'演唱会',1321,0),(1324,'话剧歌剧',1321,0),(1325,'音乐会',1321,0),(1326,'体育赛事',1321,0),(1327,'舞蹈芭蕾',1321,0),(1328,'戏曲综艺',1321,0),(1329,'生鲜',0,1),(1330,'产地直供',1329,1),(1331,'东北',1330,0),(1332,'华北',1330,0),(1333,'西北',1330,0),(1334,'华中',1330,0),(1335,'华东',1330,0),(1336,'华南',1330,0),(1337,'西南',1330,0),(1338,'水果',1329,1),(1339,'苹果',1338,0),(1340,'橙子',1338,0),(1341,'奇异果/猕猴桃',1338,0),(1342,'车厘子/樱桃',1338,0),(1343,'芒果',1338,0),(1344,'蓝莓',1338,0),(1345,'火龙果',1338,0),(1346,'葡萄/提子',1338,0),(1347,'柚子',1338,0),(1348,'香蕉',1338,0),(1349,'牛油果',1338,0),(1350,'梨',1338,0),(1351,'菠萝/凤梨',1338,0),(1352,'桔/橘',1338,0),(1353,'柠檬',1338,0),(1354,'草莓',1338,0),(1355,'桃/李/杏',1338,0),(1356,'更多水果',1338,0),(1357,'水果礼盒/券',1338,0),(1358,'猪牛羊肉',1329,1),(1359,'牛肉',1358,0),(1360,'羊肉',1358,0),(1361,'猪肉',1358,0),(1362,'内脏类',1358,0),(1363,'海鲜水产',1329,1),(1364,'鱼类',1363,0),(1365,'虾类',1363,0),(1366,'蟹类',1363,0),(1367,'贝类',1363,0),(1368,'海参',1363,0),(1369,'海产干货',1363,0),(1370,'其他水产',1363,0),(1371,'海产礼盒',1363,0),(1372,'禽肉蛋品',1329,1),(1373,'鸡肉',1372,0),(1374,'鸭肉',1372,0),(1375,'蛋类',1372,0),(1376,'其他禽类',1372,0),(1377,'冷冻食品',1329,1),(1378,'水饺/馄饨',1377,0),(1379,'汤圆/元宵',1377,0),(1380,'面点',1377,0),(1381,'火锅丸串',1377,0),(1382,'速冻半成品',1377,0),(1383,'奶酪黄油',1377,0),(1384,'熟食腊味',1329,1),(1385,'熟食',1384,0),(1386,'腊肠/腊肉',1384,0),(1387,'火腿',1384,0),(1388,'糕点',1384,0),(1389,'礼品卡券',1384,0),(1390,'饮品甜品',1329,1),(1391,'冷藏果蔬汁',1390,0),(1392,'冰激凌',1390,0),(1393,'其他',1390,0),(1394,'蔬菜',1329,1),(1395,'叶菜类',1394,0),(1396,'茄果瓜类',1394,0),(1397,'根茎类',1394,0),(1398,'鲜菌菇',1394,0),(1399,'葱姜蒜椒',1394,0),(1400,'半加工蔬菜',1394,0),(1401,'整车',0,1),(1402,'全新整车',1401,1),(1403,'微型车',1402,0),(1404,'小型车',1402,0),(1405,'紧凑型车',1402,0),(1406,'中型车',1402,0),(1407,'中大型车',1402,0),(1408,'豪华车',1402,0),(1409,'MPV',1402,0),(1410,'SUV',1402,0),(1411,'跑车',1402,0),(1412,'二手车',1401,1),(1413,'微型车（二手）',1412,0),(1414,'小型车（二手）',1412,0),(1415,'紧凑型车（二手）',1412,0),(1416,'中型车（二手）',1412,0),(1417,'中大型车（二手）',1412,0),(1418,'豪华车（二手）',1412,0),(1419,'MPV（二手）',1412,0),(1420,'SUV（二手）',1412,0),(1421,'跑车（二手）',1412,0),(1422,'皮卡（二手）',1412,0),(1423,'面包车（二手）',1412,0);

/*Table structure for table `tb_category_brand` */

DROP TABLE IF EXISTS `tb_category_brand`;

CREATE TABLE `tb_category_brand` (
  `category_id` int(20) NOT NULL COMMENT '商品类目id',
  `brand_id` int(20) NOT NULL COMMENT '品牌id',
  PRIMARY KEY (`category_id`,`brand_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品分类和品牌的中间表，两者是多对多关系';

/*Data for the table `tb_category_brand` */

insert  into `tb_category_brand`(`category_id`,`brand_id`) values (76,1528),(76,1912),(76,2032),(76,2505),(76,3177),(76,3539),(76,3941),(76,4986),(76,6522),(76,6742),(76,7174),(76,7203),(76,7420),(76,7817),(76,7888),(76,8214),(76,8551),(76,8557),(76,8740),(76,9420),(76,9637),(76,10317),(76,10640),(76,11516),(76,12286),(76,12669),(76,13066),(76,13539),(76,14026),(76,14478),(76,15127),(76,15539),(76,16506),(76,16538),(76,16975),(76,17193),(76,17424),(76,17440),(76,18078),(76,18362),(76,18374),(76,20130),(76,20710),(76,21011),(76,21360),(76,21553),(76,22261),(76,22575),(76,23049),(76,23130),(76,25376),(76,25591),(76,27094),(76,27306),(76,32315),(76,36404),(76,36652),(76,36654),(76,36657),(76,38125),(76,38126),(76,38605),(76,43644),(76,45227),(76,45693),(76,45757),(76,49144),(76,50450),(76,51040),(76,52302),(76,53317),(76,54347),(76,55524),(76,56411),(76,59110),(76,60106),(76,63032),(76,63833),(76,68927),(76,89010),(76,91515),(76,102501),(76,104490),(76,109150),(76,110303),(76,113718),(76,114119),(76,123856),(76,128080),(76,129098),(76,130455),(76,131546),(76,133747),(76,134922),(76,135967),(76,149070),(76,151370),(76,151844),(76,155608),(76,159313),(76,174275),(76,178969),(76,179105),(76,179528),(76,179624),(76,180213),(76,194213),(76,196065),(76,197126),(76,203084),(76,204089),(76,205278),(76,209178),(76,214915),(76,219484),(76,221149),(76,222294),(76,223023),(76,223199),(76,223316),(76,225085),(76,228280),(76,233984),(76,234746),(76,238798),(76,240112),(76,246053),(76,247149),(76,247652),(76,248132),(76,249404),(76,253520),(76,261196),(76,261480),(76,262180),(76,262334),(76,264451),(76,265247),(76,267981),(76,271696),(76,276102),(76,276381),(76,276780),(76,278268),(76,278755),(76,279173),(76,280120),(76,280152),(76,284571),(76,285331),(76,286273),(76,287292),(76,290104),(76,290682),(76,302250),(76,304654),(76,314866),(76,316578),(76,316596),(76,316618),(76,325396),(76,325397),(76,325400),(76,325401),(84,18374),(86,18374),(90,325398),(90,325399),(94,18374),(105,1115),(105,6742),(105,7817),(105,7888),(105,16538),(105,18374),(105,23130),(106,7817),(107,7817),(108,7817),(117,18374),(128,18374),(167,6742),(170,6742),(324,18374),(326,18374),(327,18374);

/*Table structure for table `tb_impression` */

DROP TABLE IF EXISTS `tb_impression`;

CREATE TABLE `tb_impression` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL COMMENT '印象',
  `count` int(11) DEFAULT NULL,
  `spu_id` int(11) DEFAULT NULL,
  `sku_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

/*Data for the table `tb_impression` */

insert  into `tb_impression`(`id`,`title`,`count`,`spu_id`,`sku_id`) values (1,'口感不错',15326,2,2600242),(2,'实惠',3354,2,2600242),(3,'物流快',1443,2,2600242),(4,'质量不错',944,2,2600242),(5,'气味不错',575,2,2600242),(6,'味道一般',1589,2,2600242);

/*Table structure for table `tb_news` */

DROP TABLE IF EXISTS `tb_news`;

CREATE TABLE `tb_news` (
  `id` int(11) NOT NULL,
  `title` varchar(20) DEFAULT NULL,
  `content` text,
  `author` varchar(255) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `tb_news` */

insert  into `tb_news`(`id`,`title`,`content`,`author`,`created_at`,`updated_at`) values (1,'***金砖金句','***金砖金句','张杰','2018-07-26',NULL),(2,'5旬警察徒手接跳桥男子被砸','5旬警察徒手接跳桥男子被砸','李霞','2018-07-26',NULL),(3,'欧盟重罚4家亚欧巨头','欧盟重罚4家亚欧巨头','黎明','2018-07-26',NULL),(4,'揭秘“天下第一村”','揭秘“天下第一村”','黄东','2018-07-26',NULL),(5,'吉喆昨夜未归，细说那些不可告人的密码',NULL,'富贵','2018-12-18',NULL);

/*Table structure for table `tb_order` */

DROP TABLE IF EXISTS `tb_order`;

CREATE TABLE `tb_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `sn` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '订单序列号',
  `shr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人姓名',
  `shr_mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人手机',
  `shr_province` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人省份',
  `shr_city` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人城市',
  `shr_area` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人地区',
  `shr_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '收货人详情地址',
  `status` int(3) NOT NULL COMMENT '订单状态，0:未支付、1:已支付、等待发货、2:已发货、等待收货 3:已收货、等待评论 4:已结束 5:申请售后',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `post_time` datetime DEFAULT NULL COMMENT '发货时间',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户ID',
  `total_price` decimal(10,0) NOT NULL COMMENT '订单总价',
  PRIMARY KEY (`id`),
  KEY `orders_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_order` */

insert  into `tb_order`(`id`,`created_at`,`updated_at`,`sn`,`shr_name`,`shr_mobile`,`shr_province`,`shr_city`,`shr_area`,`shr_address`,`status`,`pay_time`,`post_time`,`user_id`,`total_price`) values (10,'2020-02-25 22:21:43',NULL,'1232309704374489088','李四','2222','北京','海淀区','西三旗','2222',0,NULL,NULL,1,'1713400');

/*Table structure for table `tb_order_good` */

DROP TABLE IF EXISTS `tb_order_good`;

CREATE TABLE `tb_order_good` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sn` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '订单ID',
  `spu_id` int(10) unsigned NOT NULL COMMENT 'SPUID',
  `sku_id` int(10) unsigned NOT NULL COMMENT 'SKUID',
  `number` int(10) unsigned NOT NULL COMMENT '购买数量',
  `spec_list` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '规格列表',
  `sku_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '商品名称',
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图片',
  `price` decimal(10,0) NOT NULL COMMENT '价格',
  PRIMARY KEY (`id`),
  KEY `order_goods_order_id_index` (`sn`),
  KEY `order_goods_spu_id_index` (`spu_id`),
  KEY `order_goods_sku_id_index` (`sku_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_order_good` */

insert  into `tb_order_good`(`id`,`sn`,`spu_id`,`sku_id`,`number`,`spec_list`,`sku_name`,`url`,`price`) values (17,'1232309704374489088',5,3355143,2,'{\"id_list\":\"1:1|2:7|6:24\",\"id_txt\":\"{\\\"机身颜色\\\":\\\"白色\\\",\\\"内存\\\":\\\"4GB\\\",\\\"机身存储\\\":\\\"64GB\\\"}\"}','华为 HUAWEI nova 4GB+64GB版 香槟金（白）移动联通电信4G手机 双卡双待',NULL,'139900'),(18,'1232309704374489088',2,2600242,7,'{\"id_list\":\"1:1|2:6|6:22\",\"id_txt\":\"{\\\"机身颜色\\\":\\\"白色\\\",\\\"内存\\\":\\\"3GB\\\",\\\"机身存储\\\":\\\"16GB\\\"}\"}','华为 G9 青春版 白色 移动联通电信4G手机 双卡双待',NULL,'84900'),(19,'1232309704374489088',3,2868435,1,'{\"id_list\":\"1:3|2:7|6:23\",\"id_txt\":\"{\\\"机身颜色\\\":\\\"粉色\\\",\\\"内存\\\":\\\"4GB\\\",\\\"机身存储\\\":\\\"32GB\\\"}\"}','三星 Galaxy C5（SM-C5000）4GB+32GB 蔷薇粉 移动联通电信4G手机 双卡双待',NULL,'119900'),(20,'1232309704374489088',3,2895158,6,'{\"id_list\":\"1:5|2:7|6:23\",\"id_txt\":\"{\\\"机身颜色\\\":\\\"银色\\\",\\\"内存\\\":\\\"4GB\\\",\\\"机身存储\\\":\\\"32GB\\\"}\"}','三星 Galaxy C5（SM-C5000）4GB+32GB 皎洁银 移动联通电信4G手机 双卡双待',NULL,'119900');

/*Table structure for table `tb_seckill` */

DROP TABLE IF EXISTS `tb_seckill`;

CREATE TABLE `tb_seckill` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) unsigned NOT NULL COMMENT '商家ID',
  `spu_id` int(10) unsigned NOT NULL COMMENT 'SPUID',
  `sku_id` int(10) unsigned DEFAULT NULL COMMENT 'SKUID',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `stock` int(10) unsigned NOT NULL COMMENT '库存量',
  `price` decimal(8,2) NOT NULL COMMENT '秒杀价格',
  `check_time` datetime DEFAULT NULL COMMENT '审核时间',
  `check_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '审核状态，0：未审核，1：已通过，2：未通过',
  PRIMARY KEY (`id`),
  KEY `seckills_seller_id_index` (`seller_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_seckill` */

/*Table structure for table `tb_sku` */

DROP TABLE IF EXISTS `tb_sku`;

CREATE TABLE `tb_sku` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'sku id',
  `stock` int(11) DEFAULT NULL,
  `spu_id` int(20) NOT NULL COMMENT 'spu id',
  `sku_name` varchar(255) NOT NULL COMMENT '商品标题',
  `images` varchar(1000) DEFAULT '' COMMENT '商品的图片，多个图片以‘,’分割',
  `price` double(15,0) NOT NULL DEFAULT '0' COMMENT '销售价格，单位为分',
  `spec_info_id_list` varchar(200) DEFAULT NULL,
  `spec_info_id_txt` varchar(1000) DEFAULT '' COMMENT 'sku的特有规格参数键值对，json格式，反序列化时请使用linkedHashMap，保证有序',
  `created_at` datetime NOT NULL COMMENT '添加时间',
  `updated_at` datetime NOT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  KEY `key_spu_id` (`spu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3355144 DEFAULT CHARSET=utf8 COMMENT='sku表,该表表示具体的商品实体,如黑色的 64g的iphone 8';

/*Data for the table `tb_sku` */

insert  into `tb_sku`(`id`,`stock`,`spu_id`,`sku_name`,`images`,`price`,`spec_info_id_list`,`spec_info_id_txt`,`created_at`,`updated_at`) values (2600242,90,2,'华为 G9 青春版 白色 移动联通电信4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',84900,'1:1|2:6|6:22','{\"机身颜色\":\"白色\",\"内存\":\"3GB\",\"机身存储\":\"16GB\"}','2018-04-21 15:55:14','2018-04-21 15:55:14'),(2600248,94,2,'华为 G9 青春版 金色 移动联通电信4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',84900,'1:2|2:6|6:22','{\"机身颜色\":\"金色\",\"内存\":\"3GB\",\"机身存储\":\"16GB\"}','2018-04-21 15:55:14','2018-04-21 15:55:14'),(2868393,98,3,'三星 Galaxy C5（SM-C5000）4GB+32GB 枫叶金 移动联通电信4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',119900,'1:2|2:7|6:23','{\"机身颜色\":\"金色\",\"内存\":\"4GB\",\"机身存储\":\"32GB\"}','2018-04-21 15:55:16','2018-04-21 15:55:16'),(2868435,99,3,'三星 Galaxy C5（SM-C5000）4GB+32GB 蔷薇粉 移动联通电信4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',119900,'1:3|2:7|6:23','{\"机身颜色\":\"粉色\",\"内存\":\"4GB\",\"机身存储\":\"32GB\"}','2018-04-21 15:55:16','2018-04-21 15:55:16'),(2895136,100,3,'三星 Galaxy C5（SM-C5000）4GB+32GB 烟雨灰 移动联通电信4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',119900,'1:4|2:7|6:23','{\"机身颜色\":\"灰色\",\"内存\":\"4GB\",\"机身存储\":\"32GB\"}','2018-04-21 15:55:17','2018-04-21 15:55:17'),(2895158,92,3,'三星 Galaxy C5（SM-C5000）4GB+32GB 皎洁银 移动联通电信4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',119900,'1:5|2:7|6:23','{\"机身颜色\":\"银色\",\"内存\":\"4GB\",\"机身存储\":\"32GB\"}','2018-04-21 15:55:18','2018-04-21 15:55:18'),(3234246,97,7,'华为 G9 Plus 32GB 月光银 移动联通4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',119900,'1:3|2:6|6:23','{\"机身颜色\":\"银色\",\"内存\":\"3GB\",\"机身存储\":\"32GB\"}','2018-04-21 15:55:23','2018-04-21 15:55:23'),(3234250,94,4,'华为 麦芒5 全网通 4GB+64GB版 香槟金 移动联通电信4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',139900,'1:2|2:7|6:23','{\"机身颜色\":\"金色\",\"内存\":\"4GB\",\"机身存储\":\"64GB\"}','2018-04-21 15:55:19','2018-04-21 15:55:19'),(3250951,94,124,'努比亚（nubia）Z11 百合金 4GB+64GB 全网通 移动联通电信4G手机双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',159900,'1:2|2:8|6:24','{\"机身颜色\":\"金色\",\"内存\":\"8GB\",\"机身存储\":\"64GB\"}','2018-04-21 15:59:23','2018-04-21 15:59:23'),(3355143,98,5,'华为 HUAWEI nova 4GB+64GB版 香槟金（白）移动联通电信4G手机 双卡双待','https://img12.360buyimg.com/n1/jfs/t17050/106/1124838205/250590/7e63050a/5abb6be2N853106d9.jpg',139900,'1:1|2:7|6:24','{\"机身颜色\":\"白色\",\"内存\":\"4GB\",\"机身存储\":\"64GB\"}','2018-04-21 15:55:20','2018-04-21 15:55:20');

/*Table structure for table `tb_sku_comment` */

DROP TABLE IF EXISTS `tb_sku_comment`;

CREATE TABLE `tb_sku_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL COMMENT '用户ID',
  `spu_id` int(10) unsigned NOT NULL COMMENT 'SPUID',
  `sku_id` int(10) unsigned NOT NULL COMMENT 'SKUID',
  `ratio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '0好评 1  中评   2 差评 ',
  `spec_list` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '规格列表',
  `content` varchar(600) COLLATE utf8_unicode_ci NOT NULL COMMENT '评论内容，最大600个字符',
  `star` int(3) unsigned NOT NULL COMMENT '打分，1~5分',
  `isshow` int(11) NOT NULL DEFAULT '0' COMMENT '0 显示 1 不显示',
  `sn` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `spu_comments_spu_id_index` (`spu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_sku_comment` */

insert  into `tb_sku_comment`(`id`,`created_at`,`updated_at`,`user_id`,`spu_id`,`sku_id`,`ratio`,`spec_list`,`content`,`star`,`isshow`,`sn`) values (1,NULL,NULL,1,2,2600242,'0','0_0_0','好',5,0,NULL),(2,NULL,NULL,1,2,2600248,'1',' 1_0_0','好好',4,1,NULL),(3,NULL,NULL,1,2,2600248,'2','0_0_0','差',1,0,NULL);

/*Table structure for table `tb_sku_photo` */

DROP TABLE IF EXISTS `tb_sku_photo`;

CREATE TABLE `tb_sku_photo` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sku_id` int(10) unsigned NOT NULL COMMENT 'SPUID',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '原图路径',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_sku_photo` */

/*Table structure for table `tb_specification` */

DROP TABLE IF EXISTS `tb_specification`;

CREATE TABLE `tb_specification` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `spec_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '规格名称',
  `category_id` int(10) unsigned NOT NULL COMMENT '分类ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_specification` */

insert  into `tb_specification`(`id`,`spec_name`,`category_id`) values (1,'机身颜色',76),(2,'内存',76),(3,'颜色',3),(4,'尺码',3),(5,'尺寸',11),(6,'机身存储',76);

/*Table structure for table `tb_specification_option` */

DROP TABLE IF EXISTS `tb_specification_option`;

CREATE TABLE `tb_specification_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `spec_id` int(10) unsigned NOT NULL COMMENT '规格ID',
  `option_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '选项名称',
  PRIMARY KEY (`id`),
  KEY `specification_options_spec_id_index` (`spec_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_specification_option` */

insert  into `tb_specification_option`(`id`,`spec_id`,`option_name`) values (1,1,'白色'),(2,1,'金色'),(3,1,'粉色'),(4,1,'灰色'),(5,1,'银色'),(6,2,'3GB'),(7,2,'4GB'),(8,2,'8GB'),(9,3,'红色'),(10,3,'黑色'),(11,3,'绿色'),(12,3,'蓝色'),(13,3,'紫色'),(14,4,'S'),(15,4,'M'),(16,4,'L'),(17,4,'XL'),(18,5,'5.5寸'),(19,5,'3.2寸'),(20,5,'6寸'),(21,5,'5.2寸'),(22,6,'16GB'),(23,6,'32GB'),(24,6,'64GB');

/*Table structure for table `tb_spu` */

DROP TABLE IF EXISTS `tb_spu`;

CREATE TABLE `tb_spu` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'spu id',
  `spu_name` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `spu_subname` varchar(255) DEFAULT '' COMMENT '子标题',
  `logo` varchar(255) DEFAULT NULL,
  `cat1_id` int(20) NOT NULL COMMENT '1级类目id',
  `cat2_id` int(20) NOT NULL COMMENT '2级类目id',
  `cat3_id` int(20) NOT NULL COMMENT '3级类目id',
  `brand_id` int(20) NOT NULL COMMENT '商品所属品牌id',
  `check_time` datetime DEFAULT NULL COMMENT '审核时间',
  `check_status` int(11) DEFAULT NULL COMMENT '审核状态，0：未审核，1：已通过，2：未通过',
  `price` double DEFAULT NULL COMMENT '商品价格，单位：元',
  `is_on_sale` int(11) DEFAULT NULL COMMENT '是否上架 0 未上架 1 上架',
  `on_sale_time` datetime DEFAULT NULL COMMENT '上架时间',
  `deleted_at` datetime DEFAULT NULL COMMENT '删除时间',
  `weight` double DEFAULT NULL COMMENT '重量',
  `description` text COMMENT '商品详情',
  `packages` text COMMENT '包装',
  `aftersale` longtext COMMENT '售后',
  `spec_list` longtext COMMENT '规格列表',
  `created_at` datetime DEFAULT NULL COMMENT '添加时间',
  `updated_at` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8 COMMENT='spu表，该表描述的是一个抽象性的商品，比如 iphone8';

/*Data for the table `tb_spu` */

insert  into `tb_spu`(`id`,`spu_name`,`spu_subname`,`logo`,`cat1_id`,`cat2_id`,`cat3_id`,`brand_id`,`check_time`,`check_status`,`price`,`is_on_sale`,`on_sale_time`,`deleted_at`,`weight`,`description`,`packages`,`aftersale`,`spec_list`,`created_at`,`updated_at`) values (2,'华为 G9 青春版 ','骁龙芯片！3GB运行内存！索尼1300万摄像头！<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:15','2018-04-21 15:55:15'),(3,'三星 Galaxy C5（SM-C5000）4GB+32GB ','5.2英寸AMOLED屏，800+1600万像素，金属机身，小巧便捷，续航能力强大！<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>三星S9震撼上市详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:18','2018-04-21 15:55:18'),(4,'华为 麦芒5 全网通 4GB+64GB版 ','光学防抖，持久续航！后置1600万像素，金属机身！<a href=\'http://item.jd.com/5148371.html?from_saf=1\' target=\'_blank\'>全面屏麦芒6低至2099元！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:20','2018-04-21 15:55:20'),(5,'华为 HUAWEI nova 4GB+64GB版 ','4K高清视频拍摄！美颜自拍！DTS音效！<a href=\'http://item.jd.com/5963064.html?from_saf=1\' target=\'_blank\'>nova2S白条3期免息！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:21','2018-04-21 15:55:21'),(6,'魅族 PRO','5.2英寸！500万+1200万像素！<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:22','2018-04-21 15:55:22'),(7,'华为 G9 Plus 32GB ','高清大屏，长续航，骁龙芯片，表里不凡！<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:23','2018-04-21 15:55:23'),(8,'华为 畅享6 ','轻薄有型，电力十足！5英寸AMOLED屏幕，4100mAh大容量电池！<a  target=\"_blank\"  href=\"https://sale.jd.com/act/DhKrOjXnFcGL.html\">华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:25','2018-04-21 15:55:25'),(9,'华为 HUAWEI nova 青春版 4GB+64GB ','双面弧面玻璃！麒麟658处理器！柔光屏！<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:27','2018-04-21 15:55:27'),(10,'魅族 魅蓝X 3GB+32GB 全网通公开版 ','MTK P20芯片，5.5英寸全高清夏普屏！<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:28','2018-04-21 15:55:28'),(11,'OPPO A57 3GB+32GB内存版 ','R15星空紫特别版今天10点开抢，货源稀缺，手慢无！此版本包含迪丽热巴微剧同款T恤、帽子，就要这样“紫”<a href=\'https://item.jd.com/7294559.html#crumb-wrap\' target=\'_blank\'>去看热巴同款</a>',NULL,74,75,76,2032,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:30','2018-04-21 15:55:30'),(12,'华为 HUAWEI nova 2 4GB+64GB ','前置2000万高清美拍，光学变焦双镜头！<a href=\'http://item.jd.com/5963064.html?from_saf=1\' target=\'_blank\'>nova2S白条3期免息！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:32','2018-04-21 15:55:32'),(13,'华为畅享7 3GB+32GB ','【限量领券立减100元】成交价899元！金属机身，骁龙芯片！<a href=\'http://item.jd.com/6001257.html?from_saf=1\' target=\'_blank\'>畅享7S成交价低至1399元！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:34','2018-04-21 15:55:34'),(14,'华为 Mate 9 Pro 4GB+64GB版 ','2K双曲面屏幕！二代徕卡双摄像头！<a href=\'http://item.jd.com/5706775.html?from_saf=1\' target=\'_blank\'>mate10 Pro购机享白条6期免息！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:35','2018-04-21 15:55:35'),(15,'华为 畅享6S ','骁龙芯片！金属机身！享看又享玩！<a  target=\"_blank\"  href=\"https://sale.jd.com/act/DhKrOjXnFcGL.html\">华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:37','2018-04-21 15:55:37'),(16,'锤子 坚果Pro 128GB ','1300万后置双摄像头/5.5英寸FHD显示屏/人脸识别/18W快充！<a href=\'https://sale.jd.com/act/T14MEWpIkheDcN.html\' target=\'_blank\'>坚果3火爆新品，点此下单</a>',NULL,74,75,76,91515,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:39','2018-04-21 15:55:39'),(17,'华为 HUAWEI P10 Plus 6GB+','【白条6期免息】wifi双天线设计！徕卡人像摄影！<a href=\'http://item.jd.com/3893493.html?from_saf=1\' target=\'_blank\'>P10徕卡双摄拍照，低至2988元！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:42','2018-04-21 15:55:42'),(18,'华为 HUAWEI P10 全网通 4GB+64GB ','【白条6期免息】wifi双天线设计！徕卡人像摄影！<a href=\'http://item.jd.com/4483120.html?from_saf=1\' target=\'_blank\'>大屏徕卡双摄P10 Plus，低至3388元！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:44','2018-04-21 15:55:44'),(19,'魅族 魅蓝5s 全网通公开版 3GB+16GB ','5.2英寸，CNC金属机身，18W快充！<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:45','2018-04-21 15:55:45'),(20,'小米 红米 4X 全网通版 ','4100mAh 超长续航/骁龙处理器<a href=\'https://item.jd.com/6703337.html#crumb-wrap\' target=\'_blank\'>新版本红米5A，大内存更优惠！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:46','2018-04-21 15:55:46'),(21,'小米5X 美颜双摄拍照手机 4GB+64GB ','光学变焦双摄，拍人更美/5.5吋大屏轻薄全金属/骁龙八核处理器/4GB大内存<a href=\'https://mi.jd.com/\' target=\'_blank\'>点击了解更多小米手机！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:48','2018-04-21 15:55:48'),(22,'小米 红米 4A 移动合约版 2GB内存 16GB ROM ','3120mAh 大电池/1300万像素相机<a href=\'https://item.jd.com/6703337.html#crumb-wrap\' target=\'_blank\'>红米4A迭代新机红米5A，大内存更优惠！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:50','2018-04-21 15:55:50'),(23,'华为畅享7 ','【限量领券立减100元】成交价1399元！4000毫安续航大电池！<a href=\'http://item.jd.com/6001257.html?from_saf=1\' target=\'_blank\'>畅享7S成交价低至1399元！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:53','2018-04-21 15:55:53'),(24,'荣耀 畅玩6 2GB+16GB ','柔光自拍，舒适握感，长续航！<a href=\'http://sale.jd.com/act/L1Y2V6ERZePab4.html\' target=\'_blank\'>荣耀10 99元定金预售，点击进入》》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:54','2018-04-21 15:55:54'),(25,'小米Note3 美颜双摄拍照手机 6GB+64GB ','1600万美颜自拍/2倍变焦双摄，四轴光学防抖/5.5吋护眼屏/超轻四曲面，7系铝金属边框<a href=\'https://mi.jd.com/\' target=\'_blank\'>点击了解更多小米手机！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:55','2018-04-21 15:55:55'),(26,'小米MIX2 全面屏游戏手机 ','全面屏2.0，5.99吋大屏/骁龙835旗舰处理器/4轴光学防抖/6模43频，全球频段<a  target=\"_blank\"  href=\"https://mi.jd.com/\">点击了解更多小米手机！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:56','2018-04-21 15:55:56'),(27,'小米Max2 大屏手机 4GB+64GB ','6.44’’大屏/5300mAh 充电宝级的大电量/大像素相机/轻薄全金属<a  target=\"_blank\"  href=\"https://mi.jd.com/\">点击了解更多小米手机！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:55:59','2018-04-21 15:55:59'),(28,'小米6 全网通 4GB+64GB 亮','骁龙835 旗舰处理器/变焦双摄，4 轴防抖/5.15吋 护眼屏/四曲面玻璃机身<a  target=\"_blank\"  href=\"https://mi.jd.com/\">点击了解更多小米手机！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:00','2018-04-21 15:56:00'),(29,'荣耀9 全网通 ','领券立减200！成交价2599！2000万变焦双摄，3D曲面极光玻璃！<a href=\'http://sale.jd.com/act/L1Y2V6ERZePab4.html\' target=\'_blank\'>荣耀10 99元定金预售，点击进入》》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:02','2018-04-21 15:56:02'),(30,'小米 红米Note5A 全网通版 2GB+16GB ','5.5吋高清大屏，高通骁龙处理器，超长续航，2+1卡槽<a  target=\"_blank\"  href=\"https://mi.jd.com/\">点击了解更多小米手机！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:03','2018-04-21 15:56:03'),(31,'华为 HUAWEI Mate 10 6GB+128GB ','爆款直降，全民疯抢！麒麟970芯片！AI智能拍照！<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为P20新品抢购，摄影大师，专门为你》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:05','2018-04-21 15:56:05'),(32,'荣耀 畅玩7X 4GB+32GB 全网通4G全面屏手机 标配版 ','限时优惠50！成交价1249！1600万高清双摄，全面屏手机~<a href=\'http://sale.jd.com/act/L1Y2V6ERZePab4.html\' target=\'_blank\'>荣耀10 99元定金预售，点击进入》》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:06','2018-04-21 15:56:06'),(33,'华为 HUAWEI Mate 10 Pro 全网通 6GB+128GB ','爆款直降，全民疯抢！6英寸OLED全面屏！四曲面机身！<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为P20新品抢购，摄影大师，专门为你》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:09','2018-04-21 15:56:09'),(34,'小米 红米5 Plus 全面屏手机 全网通版 3GB+32GB ','全面屏/4000mAh大电量/前置柔光自拍/14nm骁龙八核处理器<a  target=\"_blank\"  href=\"https://mi.jd.com/\">点击了解更多小米手机！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:10','2018-04-21 15:56:10'),(35,'小米 红米5','搭载高通骁龙处理器，后置12MP旗舰相机，前置柔光自拍，配备5.7英寸全面屏。<a  target=\"_blank\"  href=\"https://mi.jd.com/\">点击了解更多小米手机！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:12','2018-04-21 15:56:12'),(36,'荣耀 V10 高配版 6GB+64GB ','麒麟970！全面屏！2000万AI变焦双摄！<a href=\'http://sale.jd.com/act/L1Y2V6ERZePab4.html\' target=\'_blank\'>荣耀10 99元定金预售，点击进入》》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:14','2018-04-21 15:56:14'),(37,'荣耀9青春版 全网通 标配版 3GB+32GB ','限时赠耳机，赠完即止！全屏四摄，正反都美！<a href=\'http://sale.jd.com/act/L1Y2V6ERZePab4.html\' target=\'_blank\'>荣耀10 99元定金预售，点击进入》》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:18','2018-04-21 15:56:18'),(38,'荣耀畅玩7C 全面屏手机 全网通标配版 3GB+32GB ','人脸识别，双摄美拍！<a href=\'http://sale.jd.com/act/L1Y2V6ERZePab4.html\' target=\'_blank\'>荣耀爆品钜惠，选品质，购荣耀~</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:19','2018-04-21 15:56:19'),(39,'三星 Galaxy S9+（SM-G9650/DS）6GB+128GB ','【下单送无线快充！白条12期免息，Plus会员下单送14000京豆】960帧/秒凝时拍摄,Bixby智能人工助手!<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>F1.5-2.4智能可变光圈详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:21','2018-04-21 15:56:21'),(40,'小米 红米Note4X 全网通版 ','',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:23','2018-04-21 15:56:23'),(41,'小米 红米5A 全网通版 3GB+32GB ','8天长待机，金属机身，MIUI9快如闪电<a href=\'https://item.jd.com/5901119.html#crumb-wrap\' target=\'_blank\'>4G+全网通低至569</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:25','2018-04-21 15:56:25'),(42,'vivo X21 全面屏 双摄美颜拍照手机 6GB+128GB ','【3期免息，购机送好礼】大内存，大智慧，19:9新一代全面屏手机！AI智慧拍照！照亮你的美！<a href=\'https://sale.jd.com/act/YwJvQOrbPKaLE2.html\' target=\'_blank\'>更多精彩请点击>></a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:26','2018-04-21 15:56:26'),(43,'OPPO R15 全面屏双摄拍照手机 6G+128G ','R15星空紫特别版今天10点开抢，货源稀缺，手慢无！此版本包含迪丽热巴微剧同款T恤、帽子，就要这样“紫”<a href=\'https://item.jd.com/7294559.html#crumb-wrap\' target=\'_blank\'>去看热巴同款</a>',NULL,74,75,76,2032,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:27','2018-04-21 15:56:27'),(44,'华为 HUAWEI P20 AI智慧全面屏 6GB +64GB ','AI摄影大师/DxO评分过百/一秒记忆960个定格/影棚级人像自拍<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为新品季，更多优惠猛戳》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:29','2018-04-21 15:56:29'),(45,'华为畅享8 Plus 高清四摄大电池 4G+64G ','前后双摄！4000mAh大电池！三卡槽扩容无忧！人脸识别，轻松解锁！<a  target=\"_blank\"  href=\"https://sale.jd.com/act/DhKrOjXnFcGL.html\">华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:31','2018-04-21 15:56:31'),(46,'锤子（smartisan） 坚果 3 4G+64GB ','三面窄边框全面屏、金属中框、Smartisan OS智能体验系统、彩色+黑白双核！<a href=\'https://sale.jd.com/act/T14MEWpIkheDcN.html\' target=\'_blank\'>更多详情请点击</a>',NULL,74,75,76,91515,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:32','2018-04-21 15:56:32'),(47,'荣耀畅玩7A 全面屏手机 全网通标配版 2GB+32GB ','限时赠耳机，赠完即止！全屏刷脸，与声俱来，2GB+32GB，骁龙430<a href=\'http://sale.jd.com/act/L1Y2V6ERZePab4.html\' target=\'_blank\'>荣耀10 99元定金预售，点击进入》》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:33','2018-04-21 15:56:33'),(48,'小米（MI） 小米4A 红米4A 4G手机 ','<a href=\"https://item.jd.com/18787246601.html\" target=\"_blank\">【红米note5限时抢购】</a>流畅打王者，信号稳定，通话清晰，5.0英寸屏，学生机。',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:35','2018-04-21 15:56:35'),(49,'小米（MI） 小米4A 红米4A 4G手机 ','1300万像素！3120mAh大电池！<a href=\"https://item.jd.com/11789883614.html\" target=\"_blank\">红米5A新品现货发售</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:36','2018-04-21 15:56:36'),(50,'三星 Galaxy S8（SM-G9500）4GB+64GB ','【送无线充电器！白条12期免息！】Plus会员送10000京豆！骁龙835芯片！<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>三星S9震撼上市详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:41','2018-04-21 15:56:41'),(51,'魅族 魅蓝 Note6 3GB+32GB 全网通公开版 ','【下单立减80元】，高通八核CPU，4000mAh快充电池！<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:44','2018-04-21 15:56:44'),(52,'三星 Galaxy C8（SM-C7100）4GB+64GB ','5.5英寸，后置双摄像头，面部识别+指纹识别！<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>三星S9震撼上市详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:45','2018-04-21 15:56:45'),(53,'三星 Galaxy S8+（SM-G9550）4GB+64GB ','【送无线充电器！白条12期免息！】Plus会员送11000京豆！骁龙835芯片！<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>三星S9震撼上市详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:47','2018-04-21 15:56:47'),(54,'Meitu 美图T8s','爆品直降，白条6期免息！<a href=\'https://sale.jd.com/act/YBVND8idyzEl.html\' target=\'_blank\'>更多美图精彩活动，戳</a>',NULL,74,75,76,38126,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:49','2018-04-21 15:56:49'),(55,'华为 HUAWEI 麦芒 6 全网通 4GB+64GB版 ','5.9英寸全面屏！出彩四镜头！支持NFC！<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:51','2018-04-21 15:56:51'),(56,'魅族 魅蓝 6 全网通公开版 2GB+16GB ','秒杀降至599！快速解锁，忠于体验！<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:52','2018-04-21 15:56:52'),(57,'360手机 F','2G+16G内存/5英寸屏幕/2.5D弧形玻璃/前置指纹识别<a href=\'http://sale.jd.com/act/lhyRYJDSTC.html\' target=\'_blank\'>360手机春季惠场，爆品领券立减100>></a>',NULL,74,75,76,27306,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:53','2018-04-21 15:56:53'),(58,'360手机 N6 Pro 全网通 6GB+64GB ','4050mAh大电池/1600万后置双摄/全面屏/骁龙660<a href=\'http://sale.jd.com/act/lhyRYJDSTC.html\' target=\'_blank\'>360手机春季惠场，爆品领券立减100>></a>',NULL,74,75,76,27306,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:56:55','2018-04-21 15:56:55'),(59,'华为 HUAWEI 畅享7S 全面屏双摄 4GB +64GB ','【限量领券减100】成交价1599！5.65英寸全面屏，后置双摄！<a href=\'https://item.jd.com/7029523.html#crumb-wrap\' target=\'_blank\'>华为新品季，畅享8e正式开卖》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:00','2018-04-21 15:57:00'),(60,'三星 Galaxy S9+（SM-G9650/DS）6GB+64GB ','【下单送无线快充！白条12期免息，Plus会员下单送13400京豆】960帧/秒凝时拍摄,Bixby智能人工助手!<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>F1.5-2.4智能可变光圈详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:01','2018-04-21 15:57:01'),(61,'三星 Galaxy S9+（SM-G9650/DS）6GB+256GB ','【下单送无线快充！白条12期免息！Plus会员送14000京豆！】960帧/秒凝时拍摄,Bixby智能人工助手！<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>F1.5-2.4智能可变光圈详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:02','2018-04-21 15:57:02'),(62,'OPPO R15 梦镜版 全面屏双摄拍照手机 6G+128G ','R15星空紫特别版今天10点开抢，货源稀缺，手慢无！此版本包含迪丽热巴微剧同款T恤、帽子，就要这样“紫”<a href=\'https://item.jd.com/7294559.html#crumb-wrap\' target=\'_blank\'>去看热巴同款</a>',NULL,74,75,76,2032,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:03','2018-04-21 15:57:03'),(63,'vivo Y69 全网通 美颜拍照手机 3GB+32GB ','【超高性价比】前置1600万柔光自拍！照亮你的美！<a href=\'https://sale.jd.com/act/YwJvQOrbPKaLE2.html\' target=\'_blank\'>更多精彩请点击>></a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:04','2018-04-21 15:57:04'),(64,'三星 Galaxy S9（SM-G9600/DS）4GB+128GB ','【下单送无线快充！白条12期免息，Plus会员下单送12200京豆】960帧/秒凝时拍摄,Bixby智能人工助手!<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>三星S9震撼上市详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:07','2018-04-21 15:57:07'),(65,'华为畅享8 全面屏三卡槽 4GB+64GB ','购机送重低音耳机！5.99英寸全面屏！三卡槽扩容无忧！人脸识别，轻松解锁！<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:09','2018-04-21 15:57:09'),(66,'vivo Y85 全面屏 美颜拍照手机 4GB+64GB ','【3期免息，购机送好礼】19:9比例的全新全面屏，4GB运存，指纹面部双解锁，6.26英寸大屏，AI智慧美颜，AR萌拍 ！<a href=\'https://sale.jd.com/act/YwJvQOrbPKaLE2.html\' target=\'_blank\'>更多精彩请点击>></a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:11','2018-04-21 15:57:11'),(67,'【移动专享版】华为 HUAWEI P20 AI智慧全面屏 6GB+64GB ','AI摄影大师！一秒记忆960个定格！影棚级人像自拍！',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:12','2018-04-21 15:57:12'),(68,'华为畅享8e 全面屏后置双摄 3G+32G ','5.7英寸全面屏！三卡槽扩容无忧！人脸识别，轻松解锁！<a href=\'https://sale.jd.com/act/DhKrOjXnFcGL.html\' target=\'_blank\'>华为新品全面上线，更多优惠猛戳》》</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:15','2018-04-21 15:57:15'),(69,'华为（HUAWEI） 华为P20pro 手机 ','华为直供货源大量现货！【宝石蓝128G及极光色全系为预售请见详情】自带原装耳机 <a href=\"https://item.jd.com/26816294484.html\" target=\"_blank\">华为P20</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:17','2018-04-21 15:57:17'),(70,'华为（HUAWEI） 荣耀8 青春版 手机 ','【2万+评价，正品行货】双面2.5D玻璃，我的颜值小担当<a href=\"https://item.jd.com/15936538487.html\" target=\"_blank\">【全屏四摄→荣耀9青春版】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:19','2018-04-21 15:57:19'),(71,'小米（MI） 小米4A 红米4A 手机 ','5英寸大屏，3120mAh电池！<a href=\"https://item.jd.com/21759433312.html\" target=\"_blank\">全新骁龙636，AI双摄，逆光暗光更出色-红米note5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:22','2018-04-21 15:57:22'),(72,'华为（HUAWEI） 华为 畅享6S 移动联通电信 智能老人手机 双卡双待 ','内置带原装保护壳 再送保护膜【自营物流 货票同行】骁龙八核32G大内存 <a href=\"https://item.jd.com/26152373867.html\" target=\"_blank\">新品荣耀7C全面屏</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:25','2018-04-21 15:57:25'),(73,'华为（HUAWEI） 荣耀7C 畅玩7C 全面屏手机 ','【全部版本现货速发！】人脸识别，双摄美拍~<a href=\"https://item.jd.com/22071534211.html\" target=\"_blank\">荣耀7X</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:28','2018-04-21 15:57:28'),(74,'华为（HUAWEI） 荣耀 畅玩6 全网通 移动联通电信4G 智能老人手机 双卡双待 ','送双重好礼=壳+膜  京东直发【内置老人桌面 适合爸妈使用】<a href=\"https://item.jd.com/26152373868.html\" target=\"_blank\">新版荣耀7C人脸识别全面屏发售</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:29','2018-04-21 15:57:29'),(75,'华为（HUAWEI） 华为nova3e 手机 ','【现货热销】前置2400万自然美妆！<a href=\"https://item.jd.com/25390983397.html\" target=\"_blank\">【华为新品P20】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:31','2018-04-21 15:57:31'),(76,'华为（HUAWEI） 荣耀V9Play手机 ','【本商品正在参加春季大促活动】活动期间低至899！<a href=\"https://item.jd.com/25906780694.html\" target=\"_blank\">新品荣耀7C仅售899元起！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:33','2018-04-21 15:57:33'),(77,'华为（HUAWEI） nova3e 全面屏手机 ','送原装自拍杆+补光灯+壳膜扣套装！手机自带原装耳机！<a href=\"http://item.jd.com/21678745124.html\" target=\"_blank\">nova2s</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:39','2018-04-21 15:57:39'),(78,'华为（HUAWEI） 华为 nova 3E 全面屏手机 ','现货速发！前置2400万，后置1600万双摄！自带原装耳机保护套。新品<a href=\"https://item.jd.com/26881279032.html\" target=\"_blank\">P20pro</a>极光色',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:42','2018-04-21 15:57:42'),(79,'华为（HUAWEI） 荣耀7C 畅玩7C 手机 ','荣耀新品现货  送实用好礼 人脸识别，双摄美拍，5.99英寸全面屏  <a href=\"https://item.jd.com/24949343810.html\" target=\"_blank\">荣耀7X</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:44','2018-04-21 15:57:44'),(80,'华为（HUAWEI） 荣耀8青春版 手机 ','【尊享版4+64G低至1199元】双面2.5D玻璃，美品潮搭，颜值小担当~ <a href=\"https://item.jd.com/13114316683.html\" target=\"_blank\">荣耀9 戳我</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:47','2018-04-21 15:57:47'),(81,'华为（HUAWEI） nova 智能手机 4G手机 ','支持京东配送到付 送实用好礼 今日下单默认送延保一年 ，美颜自拍！<a href=\"https://item.jd.com/26509792446.html\" target=\"_blank\">华为nova3E热卖中</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:48','2018-04-21 15:57:48'),(82,'三星 Galaxy S8+（SM-G9550）6GB+128GB ','【送无线充电器！白条12期免息！】Plus会员送12600京豆！骁龙835芯片！<a href=\'https://sale.jd.com/act/T15MnRgiasWe8L.html\' target=\'_blank\'>三星S9震撼上市详情猛戳>></a>',NULL,74,75,76,15127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:53','2018-04-21 15:57:53'),(83,'Meitu 美图V6（MP1605）6GB+128GB ','白条3期免息！<a href=\'https://sale.jd.com/act/YBVND8idyzEl.html\' target=\'_blank\'>更多美图精彩活动，戳</a>',NULL,74,75,76,38126,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:56','2018-04-21 15:57:56'),(84,'锤子 坚果 Pro 2 ','全面屏/骁龙660/人脸识别/后置双摄/精致美颜/18W快充！<a href=\'https://sale.jd.com/act/T14MEWpIkheDcN.html\' target=\'_blank\'>坚果3火爆新品，点此下单</a>',NULL,74,75,76,91515,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:58','2018-04-21 15:57:58'),(85,'360手机 N6 Lite 全网通 4GB+32GB ','4020mAh大电池/1300万摄像头/5.5英寸全高清屏幕/骁龙630<a href=\'http://sale.jd.com/act/lhyRYJDSTC.html\' target=\'_blank\'>360手机春季惠场，爆品领券立减100>></a>',NULL,74,75,76,27306,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:57:59','2018-04-21 15:57:59'),(86,'360手机 N6 全网通 6GB+64GB ','5030mAh大电池/18W快充/全面屏/骁龙630<a href=\'http://sale.jd.com/act/lhyRYJDSTC.html\' target=\'_blank\'>360手机春季惠场，爆品领券立减100>></a>',NULL,74,75,76,27306,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:00','2018-04-21 15:58:00'),(87,'魅族 魅蓝 S6 全面屏手机 全网通公开版 3GB+64GB ','下单立减60！三星7872六核处理器，侧面指纹，全面屏！<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:02','2018-04-21 15:58:02'),(88,'华为（HUAWEI） nova 手机 ','【送好礼，现货速发，京东配送 】4K高清视频拍摄！美颜自拍！<a href=\"https://item.jd.com/10535883236.html\" target=\"_blank\">华为nova2S热销中</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:04','2018-04-21 15:58:04'),(89,'华为（HUAWEI） 荣耀9青春版 全面屏手机 ','高配尊享直降！人脸解锁！全屏四摄正反都美【官方正品 全国联保】拍送影视会员<a href=\"https://item.jd.com/26131514039.html\" target=\"_blank\">荣耀畅玩7c</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:07','2018-04-21 15:58:07'),(90,'华为（HUAWEI） 荣耀7X 畅玩7X 手机 ','【荣耀全面屏】麒麟八核 1600万后置双摄<a href=\"https://item.jd.com/25882037762.html\" target=\"_blank\">【荣耀新机→荣耀畅玩7C】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:09','2018-04-21 15:58:09'),(91,'华为（HUAWEI） 华为 P10 全网通4G智能手机 ','货票同行~支持七天保价，隔日达！<a href=\"https://item.jd.com/27179904421.html\" target=\"_blank\">预约抢购华为P20</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:13','2018-04-21 15:58:13'),(92,'华为（HUAWEI） 荣耀9 手机 ','【爆款 现货速发 全网通非阉割】 2000万变焦双摄，3D曲面极光玻璃！ <a href=\"https://item.jd.com/11795379839.html\" target=\"_blank\">荣耀8青春版</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:15','2018-04-21 15:58:15'),(93,'华为（HUAWEI） 华为P10 Plus 手机 ','64G版本仅需2766元，256G 黑、金、玉色现货速发！<a href=\"https://item.jd.com/26652299286.html\" target=\"_blank\">P20 Pro点这</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:19','2018-04-21 15:58:19'),(94,'华为（HUAWEI） 华为P20 手机 ','大量现货 华为直供货源！自带原装耳机 华为<a href=\"https://item.jd.com/26881279035.html\" target=\"_blank\">P20pro</a> 现货抢购！',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:22','2018-04-21 15:58:22'),(95,'华为（HUAWEI） 华为nova2S 全面屏手机 ','送乐心运动手环+品胜10000毫安电源+暴风VR眼镜+usb分线器！<a href=\"https://item.jd.com/26399946248.html\" target=\"_blank\">华为nova3e</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:24','2018-04-21 15:58:24'),(96,'华为（HUAWEI） nova 3e 手机 ','【现货，送五重好礼】送壳膜+自拍杆+华为原装耳机+红包！<a href=\"https://item.jd.com/21678990946.html\" target=\"_blank\">nova2s热销中~</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:27','2018-04-21 15:58:27'),(97,'华为（HUAWEI） 华为 畅享6s 4G手机 ','指纹识别！金属机身！3+32大内存骁龙八核长续航！<a href=\"https://item.jd.com/21870224382.html\" target=\"_blank\">【华为新品抢先购→华为畅享8】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:29','2018-04-21 15:58:29'),(98,'华为（HUAWEI） 荣耀 畅玩 6 全网通4G手机 双卡双待 ','',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:31','2018-04-21 15:58:31'),(99,'华为（HUAWEI） 荣耀9手机 ','限时优惠标配下单立减50成交价低至1949元！送耳机 壳膜 ！ <a href=\"https://item.jd.com/16006217377.html\" target=\"_blank\">荣耀V10低至2499</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:33','2018-04-21 15:58:33'),(100,'华为（HUAWEI） 【白条免息】 华为V10荣耀V10 全网通手机 ','京仓直发+三期免息+货到付款+评价惊喜参考赠品<a href=\"https://item.jd.com/26222134936.html\" target=\"_blank\">【红米note5 1088起 三期免息+赠品</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:36','2018-04-21 15:58:36'),(101,'小米（MI） 小米红米4A 双卡双待4G手机 ','',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:37','2018-04-21 15:58:37'),(102,'华为（HUAWEI） 荣耀7C 畅玩7C 全面屏 全网通4G智能手机 ','【京东仓发货 正品保证】现货速发！首批下单赠礼！全面屏！人脸识别，双摄美拍<a href=\"https://item.jd.com/26401034999.html\" target=\"_blank\">华为nova3e</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:39','2018-04-21 15:58:39'),(103,'华为（HUAWEI） 荣耀7X 畅玩7x 手机 ','送荣耀原装耳机+一万毫安电源限64/128G版本!现货速发!<a href=\"https://item.jd.com/26129180943.html\" target=\"_blank\">荣耀7C点这</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:41','2018-04-21 15:58:41'),(104,'小米（MI） 红米5 Plus 全面屏 手机 ','【江浙沪可享次日达】18:9全面屏，4000mAh大电池，骁龙八核处理器！<a href=\"https://item.jd.com/26187997701.html\" target=\"_blank\">红米note5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:43','2018-04-21 15:58:43'),(105,'小米（MI） 红米note5 手机 ','【64G版现货开售】，下单送耳机！AI美颜双摄！暗光逆光更出色！<a href=\"https://item.jd.com/21685362088.html\" target=\"_blank\">红米5plus32G限秒！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:46','2018-04-21 15:58:46'),(106,'小米（MI） 红米Note5 手机 ','游戏手机 王者荣耀 吃鸡 AI双摄，逆光暗光更出色 <a href=\"https://item.jd.com/21757928932.html\" target=\"_blank\">红米5plus全面屏</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:47','2018-04-21 15:58:47'),(107,'华为（HUAWEI） 荣耀6X畅玩6X手机 ','【开学爆到此商品正在参加开学季大促】活动期间享优惠促销价！<a href=\"https://item.jd.com/25906780694.html\" target=\"_blank\">荣耀7C双摄全面屏999起！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:49','2018-04-21 15:58:49'),(108,'小米（MI） 小米4A 红米4A 智能老年人手机 双卡双待 ','【京东配送】1300万像素，骁龙处理器！轻盈小巧长续航，隐私双系统！<a href=\"https://item.jd.com/25716220476.html\" target=\"_blank\">红米5A现货速发</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:51','2018-04-21 15:58:51'),(109,'小米（MI） 小米4A 红米4A 4G手机 ','【现货速发京东物流】流畅打王者，信号稳定，通话清晰，5.0英寸屏，学生机。<a href=\"http://item.jd.com/17806958156.html\" target=\"_blank\">点击查看红米5A</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:52','2018-04-21 15:58:52'),(110,'华为（HUAWEI） 华为P10 手机 ','现货速发！送229元原装视窗保护套+壳膜扣套装！<a href=\"https://item.jd.com/26652078862.html\" target=\"_blank\">华为P20点这</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:55','2018-04-21 15:58:55'),(111,'小米（MI） 红米5A 4G手机 ','京东配送【移动版支持全网与全网版不做混发、请放心购买】<a href=\"https://item.jd.com/25617369448.html\" target=\"_blank\">购买全面屏红米NOTE5手机</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:57','2018-04-21 15:58:57'),(112,'小米（MI） 小米mix2S 手机 ','黑色全系列现货 游戏手机 骁龙845带你吃鸡/AI双摄双核极速对焦<a href=\"https://item.jd.com/21759433312.html\" target=\"_blank\">红米note5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:58:58','2018-04-21 15:58:58'),(113,'小米（MI） 小米5X 手机 ','【店长推荐，现货速发】流畅打王者，骁龙处理器，5.5英寸屏，双摄拍照更美。<a href=\"https://item.jd.com/18787246601.html\" target=\"_blank\">红米note5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:00','2018-04-21 15:59:00'),(114,'小米（MI） 小米5A 红米5A 手机 ','现货速发！5.0屏幕，1300万摄像头，高通骁龙处理器！<a href=\"https://item.jd.com/21579919293.html\" target=\"_blank\">新品红米5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:02','2018-04-21 15:59:02'),(115,'小米（MI） 小米 红米note5A 手机 ','【64G少量到货】1600万柔光自拍，高通骁龙处理器，2+1卡槽设计！<a href=\"https://item.jd.com/18787246601.html\" target=\"_blank\">爆款红米note5！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:06','2018-04-21 15:59:06'),(116,'小米（MI） 红米Note5 全面屏 手机 ','送耳机+壳膜+指环扣   游戏手机 \"吃鸡\"利器 王者荣耀  AI美颜双摄！<a href=\"https://item.jd.com/21676582422.html\" target=\"_blank\">红米5plus</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:09','2018-04-21 15:59:09'),(117,'小米 红米5Plus 手机 ','【全网通不混发丨原装防摔壳】18:9全面屏丨骁龙8核处理器→<a href=\"https://item.jd.com/21117453994.html\" target=\"_blank\">新品红米note5，1499元</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:11','2018-04-21 15:59:11'),(118,'小米 note3 手机 ','全网通版不混发丨含原装壳丨人脸解锁丨美颜+后置1200万丨快充丨NFC→<a href=\"http://item.jd.com/21117453994.html\" target=\"_blank\">新品红米note5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:12','2018-04-21 15:59:12'),(119,'小米（MI） 红米5 Plus 手机 全面屏 ','【全网通，谢绝阉割版】全面屏，骁龙625处理器！<a href=\"https://item.jd.com/21759433312.html\" target=\"_blank\">全面屏-骁龙636-看新品-红米NOTE5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:14','2018-04-21 15:59:14'),(120,'华为（HUAWEI） 荣耀V10 手机 ','【荣耀旗舰】【下单赠壳膜】麒麟970！2000万AI变焦双摄<a href=\"https://item.jd.com/25882037762.html\" target=\"_blank\">【荣耀畅玩7C】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:16','2018-04-21 15:59:16'),(121,'魅族 魅蓝Note5 全网通公开版 3GB+32GB ','4000mAh真快充！金属指纹大运存！<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:18','2018-04-21 15:59:18'),(122,'魅族 魅蓝A5 移动定制版 2GB+16GB ','小身量，大电量，3060mAh！800万像素主摄像头！<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:19','2018-04-21 15:59:19'),(123,'魅族 PRO 7 4GB+64GB 全网通公开版 ','12期免息，买送耳机（数量有限，送完即止）<a href=\'https://sale.jd.com/act/InqRKmz0tg.html\' target=\'_blank\'>魅蓝6秒杀大促，直降至599抢购！</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:22','2018-04-21 15:59:22'),(124,'努比亚','无边框体验/7.5mm轻薄机身和3000mAh电池/无界续航告别一天一充！<a  target=\"_blank\"  href=\"https://sale.jd.com/act/D0Q7hajCRAWrBL.html\">更多好货请点击</a>',NULL,74,75,76,27094,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:24','2018-04-21 15:59:24'),(125,'vivo X20 全面屏 双摄美颜拍照手机 4GB+64GB ','【直降200元，白条3期免息】18:9高清全面屏，指纹面部双解锁，逆光也清晰，照亮你的美！<a href=\'https://sale.jd.com/act/YwJvQOrbPKaLE2.html\' target=\'_blank\'>更多精彩点击>>></a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:28','2018-04-21 15:59:28'),(126,'vivo X9s Plus 全网通 美颜拍照手机 4GB+64GB ','【3期免息，购机送好礼】旗舰产品，超高性价比！前置柔光拍摄！照亮你的美！部分地区有货，速来抢购！<a href=\'https://sale.jd.com/act/YwJvQOrbPKaLE2.html\' target=\'_blank\'>更多精彩请点击>></a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:32','2018-04-21 15:59:32'),(127,'努比亚（nubia）Z17 无边框 ','旗舰无边框！8GB＋64GB大内存！2300万＋1200万变焦双摄！极速闪充！<a  target=\"_blank\"  href=\"http://item.jd.com/6994622.html?from_saf=1\">红魔游戏手机火热预约中</a>',NULL,74,75,76,27094,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:34','2018-04-21 15:59:34'),(128,'华为（HUAWEI） Mate10 Pro 手机 ','送华为原装视窗保护套+华为原装蓝牙音箱+品胜10000毫安电源+乐心运动手环！<a href=\"http://item.jd.com/18167356217.html\" target=\"_blank\">mate10</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:36','2018-04-21 15:59:36'),(129,'小米（MI） 红米5 plus 手机 ','18:9全面屏，4000mAh大电池，骁龙八核处理器！<a href=\"https://item.jd.com/21685362089.html\" target=\"_blank\">32G金色限时8XX秒！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:38','2018-04-21 15:59:38'),(130,'小米（MI） 小米MIX2S 手机 ','新品现货发售！全面屏陶瓷手机，高通处理器845，AI双摄双核极速对焦！<a href=\"https://item.jd.com/18787246601.html\" target=\"_blank\">爆款红米note5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:39','2018-04-21 15:59:39'),(131,'华为（HUAWEI） 华为nova2手机 ','【移动版支持全网与全网版不做混发、请放心购买】<a href=\"https://item.jd.com/26397633043.html\" target=\"_blank\">【新品现货nova3e】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:42','2018-04-21 15:59:42'),(132,'华为（HUAWEI） 华为nova青春版 手机 ','【现货速发，京东配送】麒麟658！柔光护眼屏！双面弧面玻璃！<a href=\"https://item.jd.com/26510592706.html\" target=\"_blank\">华为P20震撼上市！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:44','2018-04-21 15:59:44'),(133,'小米（MI） 红米note5 全面屏手机 ','AI美颜双摄，人脸解锁，4000mAh大电量！点击<a href=\"https://sale.jd.com/m/act/hAaGFCsbdQ8xnMV.html\" target=\"_blank\">小米特惠专场</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:48','2018-04-21 15:59:48'),(134,'小米 红米Note4X 全网通版 ','<a href=\"https://item.jd.com/26438399057.html\" target=\"_blank\">【小米新品】~红米note5 AI智能双摄</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:51','2018-04-21 15:59:51'),(135,'小米（MI） mix2s全面屏游戏手机 ','京东配送好礼64G现货高通处理器845AI双摄双核极速对焦~<a href=\"https://item.jd.com/16716408877.html\" target=\"_blank\">小米mix2热卖中~！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:52','2018-04-21 15:59:52'),(136,'小米（MI） 小米note3 手机 亮','5.5英寸屏，骁龙660，人脸解锁，双摄镜头拍人更美！<a href=\"https://item.jd.com/18787246601.html\" target=\"_blank\">爆款红米note5现货！</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:53','2018-04-21 15:59:53'),(137,'小米（MI） 红米5 Plus 全网通4G 移动联通电信4G智能手机 双卡双待 ','18:9千元全面屏，前置柔光自拍，骁龙8核处理器<a href=\"https://item.jd.com/26438399057.html\" target=\"_blank\">【小米新品】~红米note5 AI智能双摄</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:55','2018-04-21 15:59:55'),(138,'小米（MI） 小米 MIX2S 全面屏 游戏手机 双卡双待 ','【推荐256G黑色现货速发 白色预订30天发货】高通处理器845，AI双摄双核极速对焦',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:56','2018-04-21 15:59:56'),(139,'华为（HUAWEI） 荣耀 V9 Play手机 ','科技美学，北欧极简设计<a href=\"https://item.jd.com/15936740403.html\" target=\"_blank\">【荣耀全面屏→荣耀7x】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:57','2018-04-21 15:59:57'),(140,'小米（MI） 小米MIX2S 全面屏手机 ','高通处理器845，AI双摄，支持无线快充 <a href=\"https://item.jd.com/26262075570.html\" target=\"_blank\">红米note5</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 15:59:58','2018-04-21 15:59:58'),(141,'小米 MI 6 手机 ','含原装壳丨变焦双摄丨骁龙处理器丨NFC丨<a href=\"https://item.jd.com/22320392453.html\" target=\"_blank\">小米note3骁龙八核处理器</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:00','2018-04-21 16:00:00'),(142,'小米（MI） 红米note5 手机 ','【赠多重好礼】 游戏手机 王者荣耀 吃鸡 AI双摄逆光暗光更出色/<a href=\"https://item.jd.com/21676464002.html\" target=\"_blank\">红米5plus推广中</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:02','2018-04-21 16:00:02'),(143,'华为（HUAWEI） 荣耀9青春版 手机 ','【下单赠钢化膜】全屏四摄正反都美<a href=\"https://item.jd.com/25882037762.html\" target=\"_blank\">【选“C”没错→荣耀畅玩7C】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:06','2018-04-21 16:00:06'),(144,'华为（HUAWEI） 华为 畅享6S 手机 ','指纹识别！金属机身！3+32大内存骁龙八核长续航！<a href=\"https://item.jd.com/16097496669.html\" target=\"_blank\">中兴A3特惠促销，下单有礼</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:08','2018-04-21 16:00:08'),(145,'锤子（smartisan） 坚果32 手机 ','【新品开售享壕礼】下单即送智能手环、蓝牙耳机、自拍杆~ <a href=\"https://item.jd.com/19566307882.html\" target=\"_blank\">点击购买坚果 Pro2 ！</a>',NULL,74,75,76,91515,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:09','2018-04-29 11:26:43'),(146,'华为（HUAWEI） Nova3e 手机 ','【京东配 三期免息】现货销售，下单即送多重好礼！！<a href=\"https://item.jd.com/25642117158.html\" target=\"_blank\">【新品畅享8 白条免息抢现货】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:11','2018-04-21 16:00:11'),(147,'华为（HUAWEI） nova青春版 手机 ','【现货速发】麒麟658！柔光护眼屏！双面弧面玻璃！点击<a href=\"https://item.jd.com/21381869254.html\" target=\"_blank\">畅享7s</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:14','2018-04-21 16:00:14'),(148,'vivo X21 新一代全面屏 双摄拍照手机 移动联通电信4G 双卡双待 ','<a href=\"https://sale.jd.com/act/vGWKogOy2nbPpQ.html\" target=\"_blank\">vivo X21新一代全面屏·6+128G大内存·AI智慧拍照·照亮你的美·现货抢购中</a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:16','2018-04-21 16:00:16'),(149,'华为（HUAWEI） 麦芒5手机（4G+64G）全网通高配版 4G手机 双卡双待 ','高配4+64G版金色现货速发 高通骁龙625芯片金属机身',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:18','2018-04-21 16:00:18'),(150,'华为（HUAWEI） nova 3e全面屏手机 ','送荣耀自拍杆+荣耀2合1数据线+荣耀手机支架+优质钢化膜！<a href=\"https://item.jd.com/21685713775.html\" target=\"_blank\">华为Nova 2S</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:21','2018-04-21 16:00:21'),(151,'魅族（MEIZU） 魅蓝note6 手机 ','1600万前置美拍，后置双摄像头，高通骁龙625处理器！<a href=\"https://item.jd.com/25644003916.html\" target=\"_blank\">【新品魅蓝E3】</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:23','2018-04-21 16:00:23'),(152,'vivo Y69 全网通手机 3GB+32GB移动联通电信4G手机双卡双待 ','',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:25','2018-04-21 16:00:25'),(153,'华为（HUAWEI） 华为 麦芒5 手机 ','【现货速发】5.5英寸大屏、八核处理器！ <a href=\"https://item.jd.com/16986927363.html\" target=\"_blank\">【新品麦芒6】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:26','2018-04-21 16:00:26'),(154,'魅族（MEIZU） 魅蓝S6 手机 ','疾速游戏芯片 侧面指纹 全面屏！<a href=\"https://item.jd.com/25644003916.html\" target=\"_blank\">新品魅蓝E3</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:28','2018-04-21 16:00:28'),(155,'魅族（MEIZU） 魅蓝S6 手机 ','支持京东配到付，三星Exynos芯片 全面屏侧边指纹识别 评价晒图返好礼',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:30','2018-04-21 16:00:30'),(156,'魅族（MEIZU） 魅族6 魅蓝6 手机 ','【送壳，膜现货即发】高颜值！800万+1300万像素！八核处理器！<a href=\"https://item.jd.com/25644003916.html\" target=\"_blank\">新品魅蓝E3</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:32','2018-04-21 16:00:32'),(157,'vivo Y67 全网通 美颜拍照手机 4GB+','【3期免息，购机送好礼】火爆！超高性价比！1600万柔光自拍！照亮你的美！仅部分地区有货，速来抢购！<a href=\'https://sale.jd.com/act/YwJvQOrbPKaLE2.html\' target=\'_blank\'>更多精彩请点击>></a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:37','2018-04-21 16:00:37'),(158,'诺基亚 7 (Nokia 7) ','【白条6期免息】6GB内存，蔡司摄像头，OZO音频技术~<a  target=\"_blank\"  href=\"https://sale.jd.com/act/4uxod5tD1mH.html\">猛戳进入主会场>></a>',NULL,74,75,76,13539,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:38','2018-04-21 16:00:38'),(159,'【送水晶项链】vivo X20 Plus 全面屏','【6期免息】18:9全面屏！超大屏幕，多送项链礼盒，更超值！游戏免打扰模式！畅快开黑！部分地区有货，速来抢购！<a href=\'https://sale.jd.com/act/YwJvQOrbPKaLE2.html\' target=\'_blank\'>更多精彩请点击>></a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:41','2018-04-21 16:00:41'),(160,'魅族（MEIZU） 魅蓝E3 全面屏手机 全网通4G手机 ','【128G金色少量到货】预售30天发货 骁龙8核处理器，6G大内存，索尼双摄，低温快充',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:44','2018-04-21 16:00:44'),(161,'魅族（MEIZU） 魅蓝E3手机 ','魅蓝E3 金色现货发售！6G大内存，索尼双摄，低温快充！<a href=\"https://item.jd.com/15610845217.html\" target=\"_blank\">魅蓝note6大促中</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:45','2018-04-21 16:00:45'),(162,'小米（MI） 小米MAX2 手机 6.44英寸 大屏幕 ','现货速发 6.44英寸屏幕，骁龙625处理器！热卖新品<a href=\"https://item.jd.com/26266519559.html\" target=\"_blank\">红米note5~</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:47','2018-04-21 16:00:47'),(163,'魅族（MEIZU） 魅蓝note6 全网通4G手机 双卡双待 ','<a href=\"https://item.jd.com/16844585370.html\" target=\"_blank\">（晒图写心得拿影视会员）@note6全网通香槟金仅需799！</a>送硅胶.钢化.耳机',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:49','2018-04-21 16:00:49'),(164,'华为（HUAWEI） 荣耀8 手机 ','【店长推荐】美得与众不同！<a href=\"https://item.jd.com/25882037762.html\" target=\"_blank\">【荣耀新款全面屏手机→荣耀畅玩7C】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:51','2018-04-21 16:00:51'),(165,'小米（MI） 小米note3 手机 ','赠壳膜全国联保京东配送/屏四曲面陶瓷机身骁龙835<a href=\"https://item.jd.com/16716408877.html\" target=\"_blank\">小米MIX2点击购买</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:54','2018-04-21 16:00:54'),(166,'华为（HUAWEI） Mate10 手机 ','送华为原装视窗保护套+华为原装蓝牙耳机+乐心运动手环+钢化膜等！<a href=\"https://item.jd.com/18180585426.html\" target=\"_blank\">mate10pro</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:56','2018-04-21 16:00:56'),(167,'华为（HUAWEI） 畅享6S 移动联通电信4G手机 ','【正品国行,全新原封】骁龙芯片！金属机身！享看又享玩！<a href=\"https://item.jd.com/12207790357.html\" target=\"_blank\">荣耀8青春热卖中！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:57','2018-04-21 16:00:57'),(168,'小米（MI） 小米5X 手机 ','【爆款低价 移动/公开全网通不做混发，请放心购买！】5.5”屏幕，变焦双摄！<a href=\"https://item.jd.com/12068579160.html\" target=\"_blank\">戳戳小米6~</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:00:59','2018-04-21 16:00:59'),(169,'华为（HUAWEI） 荣耀V10手机 ','【下单立减】送荣耀自拍杆+荣耀2合1数据线+荣耀手机支架+壳膜套装!<a href=\"https://item.jd.com/25749144099.html\" target=\"_blank\">荣耀畅玩7X</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:02','2018-04-21 16:01:02'),(170,'魅族（MEIZU） 魅族 魅蓝A5 4G手机 双卡双待 ','魅族新品千元机',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:03','2018-04-21 16:01:03'),(171,'华为（HUAWEI） 华为P20 Pro 全面屏 手机 ','【全国多仓发货】送价值158元原装礼盒（自拍杆+数据线+指环扣）+原装耳机！<a href=\"https://item.jd.com/13039618422.html\" target=\"_blank\">抢华为P20</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:05','2018-04-21 16:01:05'),(172,'华为（HUAWEI） 华为 畅享6S 手机 ','京东配送！  骁龙芯片！金属机身！  <a href=\"https://item.jd.com/21669543700.html\" target=\"_blank\">【新品畅享7s】</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:07','2018-04-21 16:01:07'),(173,'华为（HUAWEI） 荣耀 畅玩6 全网通4G智能手机 双卡双待 2G+16G ','【京东仓发货 正品保证】柔光自拍，舒适握感，长续航！<a href=\"https://item.jd.com/26134956416.html\" target=\"_blank\">新品荣耀畅玩7C！</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:08','2018-04-21 16:01:08'),(174,'小米（MI） 红米5 Plus 4+64G 全面屏手机 双卡双待 ','下单送好礼 自营配送 18:9千元全面屏 前置柔光自拍 4000毫安大电池 骁龙八核处理器',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:10','2018-04-21 16:01:10'),(175,'华为（HUAWEI） nova 3e 手机 ','【现货，送五重好礼】前置2400万自然美妆，送华为原装耳机等！<a href=\"https://item.jd.com/21698630782.html\" target=\"_blank\">华为nova2s热销中~</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:13','2018-04-21 16:01:13'),(176,'vivo X21 屏幕指纹 双摄拍照手机 6GB+128GB 移动联通电信4G 双卡双待 ','【稀缺货品】屏幕指纹识别·3D曲面背部玻璃·AI智慧拍照·照亮你的美·<a href=\"https://sale.jd.com/act/vGWKogOy2nbPpQ.html\" target=\"_blank\">更多精彩点击</a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:14','2018-04-21 16:01:14'),(177,'小米（MI） 小米Max2 手机 双卡双待 ','【小米大屏手机】6.44英寸屏，5300毫安电池。大屏玩王者荣耀更爽！<a href=\"https://item.jd.com/13038819059.html\" target=\"_blank\">变焦双摄小米5X</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:16','2018-04-21 16:01:16'),(178,'华为（HUAWEI） 荣耀 畅玩6 手机 ','【京仓直发】柔光自拍，舒适握感，长续航！<a href=\"https://item.jd.com/25882037762.html\" target=\"_blank\">【荣耀</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:17','2018-04-21 16:01:17'),(179,'华为（HUAWEI） 荣耀7C 畅玩7C手机 全网通4G 全面屏 ','【官方正品 全国联保】人脸识别 双摄美拍！高配拍送荣耀耳机<a href=\"https://item.jd.com/26131514041.html\" target=\"_blank\">@64G优惠购</a>',NULL,74,75,76,8557,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:19','2018-04-21 16:01:19'),(180,'魅族（MEIZU） pro 6 plus手机 移动联通版 ','【现货 劲爆价促销】<a href=\"https://item.jd.com/25109782095.html\" target=\"_blank\">魅蓝6 低至649元 评价更有好礼送</a>',NULL,74,75,76,12669,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:21','2018-04-21 16:01:21'),(181,'vivo Y75 全面屏手机 4GB+32GB 移动联通电信4G手机 双卡双待 ','<a href=\"https://sale.jd.com/act/vGWKogOy2nbPpQ.html\" target=\"_blank\">vivo X21新一代全面屏·6+128G大内存·AI智慧拍照·照亮你的美·现货抢购中</a>',NULL,74,75,76,25591,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:24','2018-04-21 16:01:24'),(182,'小米（MI） 小米5X 全网通4G智能手机 ','骁龙 八核CPU处理器 5.5英寸屏幕<a href=\"https://item.jd.com/26438399057.html\" target=\"_blank\">【小米新品】~红米note5 AI智能双摄</a>',NULL,74,75,76,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-21 16:01:27','2018-04-21 16:01:27'),(202,'ESK  Plus抗蓝光钢化膜','苹果8plus钢化膜 苹果7plus钢化膜 苹果6plus钢化膜 苹果6s plus钢化膜 iPhone8 plus钢化膜 iPhone7 plus钢化膜 iphone6 plus钢化膜',NULL,74,83,90,325398,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-22 00:27:26','2018-04-22 00:27:26'),(203,'亿色(ESR) 苹果8/7/6s/6钢化膜','配件大焕新~亿色自营官方旗舰店优质好货,低至5.9元!手机保护充电线材任君挑选，凑单还能省运费点我进店抢购(此商品不参加上述活动)',NULL,74,83,90,325399,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-22 00:30:24','2018-04-22 00:30:24'),(204,'小米（MI）电视','电视新品上新 !',NULL,103,104,105,18374,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-22 09:36:08','2018-04-22 09:36:08'),(206,'海尔模卡（MOOKA）U55H3 ','【预约，4月23日2099限量抢】海尔匠心打造，互联网定制，55英寸客厅尊贵机皇，高颜值外观！55吋曲面性价比甄选戳这里',NULL,103,104,105,7817,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-22 09:57:44','2018-04-29 09:38:48'),(207,'oopp2','ppoo',NULL,74,75,76,2032,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-04-29 09:46:15','2018-04-29 10:04:15'),(215,'黑马游戏手机2','流畅游戏体验，快到你不敢相信自己的手',NULL,74,75,76,325401,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-05-15 21:39:34','2018-05-15 23:59:27');

/*Table structure for table `tb_user` */

DROP TABLE IF EXISTS `tb_user`;

CREATE TABLE `tb_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Email',
  `mobile` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '手机号码',
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '昵称',
  `password` char(60) COLLATE utf8_unicode_ci NOT NULL COMMENT '密码',
  `face` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '头像',
  `expriece` int(10) unsigned DEFAULT '0' COMMENT '经验值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_mobile_unique` (`mobile`),
  UNIQUE KEY `users_name_unique` (`username`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `tb_user` */

insert  into `tb_user`(`id`,`created_at`,`updated_at`,`email`,`mobile`,`username`,`password`,`face`,`expriece`) values (1,'2018-07-24 16:40:56','2018-08-04 16:40:59','abcdefg@126.com','13344445555','jack','$2a$10$fzcFKxNqE1BrJN/OzQDhL.F4JzO/b4TSMmr7BCckjHZbHJmvND326','images/user3.jpg',0),(2,'2018-06-20 11:13:34','2018-06-20 11:13:37','abcdefg6@126.com','13344445556','rose','$2a$10$yqfB.YYHLCCTMvoB80mE5e6xnhnkx6WIafoH/o7vIDr9KmfReaIYm','2.jpg',0);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

3.2 后端环境

3.2.1 父工程：changgou4_parent_ali
修改pom.xml文件，确定spring boot、spring cloud、spring cloud Alibaba 等版本

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.czxy.changgou</groupId>
    <artifactId>changgou4-parent-ali</artifactId>
    <packaging>pom</packaging>
    <version>1.0-SNAPSHOT</version>
    <modules>
        <module>changgou4_common</module>
        <module>changgou4_common_auth</module>
        <module>changgou4_common_db</module>
        <module>changgou4_gateway</module>
        <module>changgou4_pojo</module>
        <module>changgou4_service_web</module>
    </modules>

    <!-- 1 确定spring boot的版本-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.2.5.RELEASE</version>
    </parent>

    <!--2  确定版本-->
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <java.version>1.8</java.version>
        <spring-cloud-release.version>Hoxton.SR3</spring-cloud-release.version>
        <nacos.version>1.1.0</nacos.version>
        <alibaba.cloud.version>2.2.1.RELEASE</alibaba.cloud.version>
        <mysql.version>5.1.32</mysql.version>
        <mybatis.plus.version>3.4.0</mybatis.plus.version>
        <druid.starter.version>1.1.9</druid.starter.version>
        <jwt.jjwt.version>0.9.0</jwt.jjwt.version>
        <jwt.joda.version>2.9.7</jwt.joda.version>
        <swagger.version>2.7.0</swagger.version>
        <beanutils.version>1.9.3</beanutils.version>
        <aliyun.sdk.core.version>3.3.1</aliyun.sdk.core.version>
        <aliyun.sdk.dysmsapi.version>1.0.0</aliyun.sdk.dysmsapi.version>
        <changgou4.common.version>1.0-SNAPSHOT</changgou4.common.version>
        <changgou4.common.auth.version>1.0-SNAPSHOT</changgou4.common.auth.version>
        <changgou4.common.db.version>1.0-SNAPSHOT</changgou4.common.db.version>
        <changgou4.pojo.version>1.0-SNAPSHOT</changgou4.pojo.version>

    </properties>

    <!-- 3 锁定版本-->
    <dependencyManagement>
        <dependencies>
            <!-- sprig cloud-->
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-dependencies</artifactId>
                <version>${spring-cloud-release.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
            <!--nacos -->
            <dependency>
                <groupId>com.alibaba.nacos</groupId>
                <artifactId>nacos-client</artifactId>
                <version>${nacos.version}</version>
            </dependency>

            <!--nacos cloud 发现 -->
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
                <version>${alibaba.cloud.version}</version>
            </dependency>

            <!--nacos cloud 配置 -->
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
                <version>${alibaba.cloud.version}</version>
            </dependency>

            <!-- https://mvnrepository.com/artifact/com.alibaba.cloud/spring-cloud-starter-alibaba-sentinel -->
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-alibaba-sentinel</artifactId>
                <version>${alibaba.cloud.version}</version>
            </dependency>

            <!-- mybatis plus-->
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatis.plus.version}</version>
            </dependency>
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-annotation</artifactId>
                <version>${mybatis.plus.version}</version>
            </dependency>

            <!-- mysql驱动 -->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>

            <!-- druid启动器 -->
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>${druid.starter.version}</version>
            </dependency>

            <!--swagger2-->
            <dependency>
                <groupId>io.springfox</groupId>
                <artifactId>springfox-swagger2</artifactId>
                <version>${swagger.version}</version>
            </dependency>
            <dependency>
                <groupId>io.springfox</groupId>
                <artifactId>springfox-swagger-ui</artifactId>
                <version>${swagger.version}</version>
            </dependency>

            <!--jwt-->
            <!--JavaBean工具类，用于JavaBean数据封装-->
            <dependency>
                <groupId>commons-beanutils</groupId>
                <artifactId>commons-beanutils</artifactId>
                <version>${beanutils.version}</version>
            </dependency>

            <!--jwt工具-->
            <dependency>
                <groupId>io.jsonwebtoken</groupId>
                <artifactId>jjwt</artifactId>
                <version>${jwt.jjwt.version}</version>
            </dependency>

            <!--joda 时间工具类 -->
            <dependency>
                <groupId>joda-time</groupId>
                <artifactId>joda-time</artifactId>
                <version>${jwt.joda.version}</version>
            </dependency>

            <!--短信-->
            <dependency>
                <groupId>com.aliyuncs</groupId>
                <artifactId>aliyun-java-sdk-core</artifactId>
                <version>${aliyun.sdk.core.version}</version>
            </dependency>
            <dependency>
                <groupId>com.aliyuncs.dysmsapi</groupId>
                <artifactId>aliyun-java-sdk-dysmsapi</artifactId>
                <version>${aliyun.sdk.dysmsapi.version}</version>
            </dependency>

            <!--自定义项目-->
            <dependency>
                <groupId>com.czxy.changgou</groupId>
                <artifactId>changgou4_common</artifactId>
                <version>${changgou4.common.version}</version>
            </dependency>
            <dependency>
                <groupId>com.czxy.changgou</groupId>
                <artifactId>changgou4_common_auth</artifactId>
                <version>${changgou4.common.auth.version}</version>
            </dependency>
            <dependency>
                <groupId>com.czxy.changgou</groupId>
                <artifactId>changgou4_common_db</artifactId>
                <version>${changgou4.common.db.version}</version>
            </dependency>
            <dependency>
                <groupId>com.czxy.changgou</groupId>
                <artifactId>changgou4_pojo</artifactId>
                <version>${changgou4.pojo.version}</version>
            </dependency>


        </dependencies>

    </dependencyManagement>



</project>

3.2.2 公共项目（基础）：changgou4-common
在这里插入图片描述
通用工具项目
基于spring cloud开发基本依赖
web开发常见的工具类

步骤一：修改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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>changgou4-parent-ali</artifactId>
        <groupId>com.czxy.changgou</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>changgou4-common</artifactId>

    <dependencies>
        <!--短信-->
        <dependency>
            <groupId>com.aliyuncs</groupId>
            <artifactId>aliyun-java-sdk-core</artifactId>
        </dependency>
        <dependency>
            <groupId>com.aliyuncs.dysmsapi</groupId>
            <artifactId>aliyun-java-sdk-dysmsapi</artifactId>
        </dependency>
        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>


</project>

步骤二：拷贝工具类(因为代码量的原因，需要工具类的可以私信我)
在这里插入图片描述
3.2.3 公共项目（认证）：changgou4-common-auth
认证通用工具项目

步骤一：修改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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>changgou4-parent-ali</artifactId>
        <groupId>com.czxy.changgou</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>changgou4-common-auth</artifactId>

    <dependencies>
        <!--通用基础-->
        <dependency>
            <groupId>com.czxy.changgou</groupId>
            <artifactId>changgou4_common</artifactId>
        </dependency>
        <!--JavaBean工具类，用于JavaBean数据封装-->
        <dependency>
            <groupId>commons-beanutils</groupId>
            <artifactId>commons-beanutils</artifactId>
        </dependency>

        <!--jwt工具-->
        <dependency>
            <groupId>io.jsonwebtoken</groupId>
            <artifactId>jjwt</artifactId>
        </dependency>

        <!--joda 时间工具类 -->
        <dependency>
            <groupId>joda-time</groupId>
            <artifactId>joda-time</artifactId>
        </dependency>
    </dependencies>


</project>

步骤二：拷贝工具类
在这里插入图片描述
3.2.4 公共项目（数据库）：changgou4-common-db
数据库通用工具项目

步骤一：修改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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>changgou4-parent-ali</artifactId>
        <groupId>com.czxy.changgou</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>changgou4-common-db</artifactId>

    <dependencies>
        <!--通用基础-->
        <dependency>
            <groupId>com.czxy.changgou</groupId>
            <artifactId>changgou4-common</artifactId>
        </dependency>
        <!-- mybatis plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>
        <!-- mysql驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- druid启动器 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
        </dependency>
    </dependencies>

</project>

步骤二：配置类
要求所有的服务项目包名必须是“com.czxy.changgou4”，否则配置无法扫描，就需要每个项目单独拷贝。

在这里插入图片描述

3.2.5 POJO项目：changgou4-pojo
统一管理所有的JavaBean

修改pom.xml文件

<dependencies>
    <!--lombok , @Data 等-->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
    </dependency>
    <!--jackson , @JsonFormat-->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-json</artifactId>
    </dependency>
    <!--mybatis-plus , @TableName @TableId 等 -->
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-annotation</artifactId>
    </dependency>
</dependencies>

3.2.6 网关：changgou4-gateway
修改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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>changgou4-parent-ali</artifactId>
        <groupId>com.czxy.changgou</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>changgou4-gateway</artifactId>

    <dependencies>
        <!--自定义项目-->
        <dependency>
            <groupId>com.czxy.changgou</groupId>
            <artifactId>changgou4-common-auth</artifactId>
        </dependency>
        <dependency>
            <groupId>com.czxy.changgou</groupId>
            <artifactId>changgou4-pojo</artifactId>
        </dependency>
        <!-- 网关 -->
        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-gateway</artifactId>
        </dependency>

        <!-- nacos 服务发现 -->
        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
        </dependency>
    </dependencies>


</project>

创建application.yml文档

#端口号
server:
  port: 10010
spring:
  application:
    name: changgou4-gateway
  servlet:
    multipart:
      max-file-size: 2MB    #上传文件的大小
  cloud:
    nacos:
      discovery:
        server-addr: 127.0.0.1:8848   #nacos服务地址
    gateway:
      discovery:
        locator:
          enabled: true               #开启服务注册和发现的功能，自动创建router以服务名开头的请求路径转发到对应的服务
          lowerCaseServiceId: true    #将请求路径上的服务名配置为小写

拷贝跨域配置类 GlobalCorsConfig

在这里插入图片描述

package com.czxy.changgou4.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpMethod;
import org.springframework.http.HttpStatus;
import org.springframework.http.server.reactive.ServerHttpRequest;
import org.springframework.http.server.reactive.ServerHttpResponse;
import org.springframework.web.cors.reactive.CorsUtils;
import org.springframework.web.server.ServerWebExchange;
import org.springframework.web.server.WebFilter;
import org.springframework.web.server.WebFilterChain;
import reactor.core.publisher.Mono;

@Configuration
public class GlobalCorsConfig {

    @Bean
    public WebFilter corsFilter2() {
        return (ServerWebExchange ctx, WebFilterChain chain) -> {
            ServerHttpRequest request = ctx.getRequest();
            if (CorsUtils.isCorsRequest(request)) {
                HttpHeaders requestHeaders = request.getHeaders();
                ServerHttpResponse response = ctx.getResponse();
                HttpMethod requestMethod = requestHeaders.getAccessControlRequestMethod();
                HttpHeaders headers = response.getHeaders();
                headers.add(HttpHeaders.ACCESS_CONTROL_ALLOW_ORIGIN, requestHeaders.getOrigin());
                headers.addAll(HttpHeaders.ACCESS_CONTROL_ALLOW_HEADERS,
                        requestHeaders.getAccessControlRequestHeaders());
                if (requestMethod != null) {
                    headers.add(HttpHeaders.ACCESS_CONTROL_ALLOW_METHODS, requestMethod.name());
                }
                headers.add(HttpHeaders.ACCESS_CONTROL_ALLOW_CREDENTIALS, "true");
                headers.add(HttpHeaders.ACCESS_CONTROL_EXPOSE_HEADERS, "*");
                if (request.getMethod() == HttpMethod.OPTIONS) {
                    response.setStatusCode(HttpStatus.OK);
                    return Mono.empty();
                }
            }
            return chain.filter(ctx);
        };
    }

}

创建启动类

在这里插入图片描述

package com.czxy.changgou4;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.cloud.client.discovery.EnableDiscoveryClient;


@SpringBootApplication
@EnableDiscoveryClient
public class CGGatewayApplication {
    public static void main(String[] args) {
        SpringApplication.run(CGGatewayApplication.class, args );
    }
}

至此，后端环境搭建完毕

3.3 前端环境

3.3.1 构建项目：changgou4-fore

步骤一：使用脚手架构建项目

npx create-nuxt-app changgou4-fore

步骤二：npm打包方式、axios第三方模块、SSR渲染模式

3.3.2 整合axios
步骤一：创建~/plugins/apiclient.js文件
步骤二：编写nuxt整合模板，用于统一管理ajax请求路径

const request = {
  test : ()=> {
    return axios.get('/test')
  }
}

var axios = null
export default ({ $axios, redirect }, inject) => {

  //赋值
  axios = $axios

  //4) 将自定义函数交于nuxt
  // 使用方式1：在vue中，this.$request.xxx()
  // 使用方式2：在nuxt的asyncData中，content.app.$request.xxx()
  inject('request', request)
}

步骤三：配置apiclient.js插件，修改nuxt.conf.js配置文件完成操作
在这里插入图片描述

  plugins: [
    { src: '~plugins/apiclient.js'}
  ],

步骤四：修改nuxt.conf.js配置文件，配置axios通用设置
在这里插入图片描述

  axios: {
    baseURL: 'http://localhost:10010'
  },

步骤五：测试 apiclient.js是否配置成功，访问test时，出现404

  async mounted() {
    let { data } = await this.$request.test()
    console.info(data)
  },

3.3.3 拷贝静态资源
将所有静态资源拷贝到static目录中
在这里插入图片描述
通过浏览器访问静态页面
http://localhost:3000/index.html

3.3.4 修改Nuxt项目默认项
修改默认布局，删除已有样式

删除pages目录下的所有内容

3.3.5 配置公共js和css
修改默认布局，添加公共js和css

<template>
  <div>
    <nuxt />
  </div>
</template>

<script>
export default {
  head: {
    title: '首页',
    link: [
      {rel:'stylesheet',href: '/style/base.css'},
      {rel:'stylesheet',href: '/style/global.css'},
      {rel:'stylesheet',href: '/style/header.css'},
      {rel:'stylesheet',href: '/style/footer.css'}
    ],
    script: [
      { type: 'text/javascript', src: '/js/jquery-1.8.3.min.js' }
    ]
  }
}
</script>

<style>

</style>

项目搭建完成

啊是可莉

关注

0
点赞
踩
8

收藏

觉得还不错? 一键收藏
0
评论
畅购商城项目--搭建项目（仅项目架构）（后端+前端）

本项目供学习使用，包含静态页面和后端javabean，因为代码量的缘故，私信我获取1.1 电商行业分析近年来，世界经济正向数字化转型，大力发展数字经济成为全球共识。党的十九大报告明确提出要建设“数字中国”“网络强国”，我国数字经济发展进入新阶段，市场规模位居全球第二，数字经济与实体经济深度融合，有力促进了供给侧结构性改革。电子商务是数字经济的重要组成部分，是数字经济最活跃、最集中的表现形式之一。我国电子商务交易规模继续扩大，全国电子商务交易额达保持高速增长。国家统计局数据显示，2017年29.16万亿
复制链接

扫一扫