MySQL root@(none):meiduo> select * from tb_spu where id=1; +----+----------------------------+----------------------------+--------------------------+------- | id | create_time | update_time | name | sales | comments | brand_id | category1_id | category2_id | category3_id | desc_detail | desc_pack | desc_service | +----+----------------------------+----------------------------+--------------------------+------- | 1 | 2018-04-11 16:01:28.547507 | 2018-04-25 12:09:42.593672 | Apple MacBook Pro 笔记本 | 1 | 1 | 1 | 4 | 45 | 157 | 描述 | 包装 | 服务 | +----+----------------------------+----------------------------+--------------------------+------- MySQL root@(none):meiduo> select * from tb_sku where spu_id=1; +-------------+-------------+--------+-----------------------------------------------------+ | id | create_time | update_time | name | caption | price | cost_price | market_price | stock | sales | comments | is_launched | category_id | spu_id | default_image | +-------------+-------------+--------+-----------------------------------------------------+ | 1 | 2018-04-11 17:28:21.804713 | 2018-04-25 11:09:04.532866 | Apple MacBook Pro 13.3英寸笔记本 银色 | 【全新2017款】MacBook Pro,一身才华，一触，即发 了解【黑五返场特惠】 更多产品请点击【美多官方Apple旗舰店】 | 11388.00 | 10350.00 | 13388.00 | 5 | 5 | 1 | 1 | 157 | 1 | group1/M00/00/02/CtM3BVrPB4GAWkTlAAGuN6wB9fU4220429 | | 2 | 2018-04-12 06:53:54.575306 | 2018-04-23 11:44:03.825103 | Apple MacBook Pro 13.3英寸笔记本 深灰色 | 【全新2017款】MacBook Pro,一身才华，一触，即发 了解【黑五返场特惠】 更多产品请点击【美多官方Apple旗舰店】 | 11398.00 | 10388.00 | 13398.00 | 0 | 1 | 0 | 1 | 157 | 1 | group1/M00/00/02/CtM3BVrPCAOAIKRBAAGvaeRBMfc0463515 | +-------------+-------------+--------+-----------------------------------------------------+ MySQL root@(none):meiduo> select * from tb_spu_specification where spu_id=1; +----+----------------------------+----------------------------+----------+--------+ | id | create_time | update_time | name | spu_id | +----+----------------------------+----------------------------+----------+--------+ | 1 | 2018-04-11 17:20:30.142577 | 2018-04-11 17:20:30.142657 | 屏幕尺寸 | 1 | | 2 | 2018-04-11 17:21:57.862419 | 2018-04-11 17:21:57.862464 | 颜色 | 1 | | 3 | 2018-04-11 17:22:04.687913 | 2018-04-11 17:22:04.687956 | 版本 | 1 | +----+----------------------------+----------------------------+----------+--------+ MySQL root@(none):meiduo> select * from tb_sku_specification where sku_id=1; +----+----------------------------+----------------------------+-----------+--------+---------+ | id | create_time | update_time | option_id | sku_id | spec_id | +----+----------------------------+----------------------------+-----------+--------+---------+ | 1 | 2018-04-11 17:53:37.178101 | 2018-04-11 17:53:37.178148 | 1 | 1 | 1 | | 2 | 2018-04-11 17:56:00.141036 | 2018-04-11 17:56:00.141078 | 4 | 1 | 2 | | 3 | 2018-04-11 17:56:17.907973 | 2018-04-11 17:56:17.908017 | 7 | 1 | 3 | +----+----------------------------+----------------------------+-----------+--------+---------+ MySQL root@(none):meiduo> select * from tb_specification_option where spec_id in (1, 2, 3); +----+----------------------------+----------------------------+-------------------------+---------+ | id | create_time | update_time | value | spec_id | +----+----------------------------+----------------------------+-------------------------+---------+ | 1 | 2018-04-11 17:22:55.126053 | 2018-04-11 17:22:55.126095 | 13.3英寸 | 1 | | 2 | 2018-04-11 17:24:04.841221 | 2018-04-11 17:24:04.841265 | 15.4英寸 | 1 | | 3 | 2018-04-11 17:24:23.862341 | 2018-04-11 17:24:23.862385 | 深灰色 | 2 | | 4 | 2018-04-11 17:24:35.256820 | 2018-04-11 17:24:35.256868 | 银色 | 2 | | 5 | 2018-04-11 17:25:04.607535 | 2018-04-11 17:25:04.607604 | core i5/8G内存/256G存储 | 3 | | 6 | 2018-04-11 17:25:15.969671 | 2018-04-11 17:25:15.969714 | core i5/8G内存/128G存储 | 3 | | 7 | 2018-04-11 17:25:35.025857 | 2018-04-12 07:12:08.090494 | core i5/8G内存/512G存储 | 3 | +----+----------------------------+----------------------------+-------------------------+---------+