儿童婴儿 | 按需设计 - 指纹定制让创业更简单

注册成功

恭喜您，账号已成功注册！

完成实名认证，获取15元无门槛优惠券！了解更多

温馨提示：为保障您的合法权益，建议您尽快完成实名认证。

暂不实名立即实名

异地登录提醒

系统检测到您的账号在异地登录，为了您的账号安全已向绑定手机号发送一条短信验证码，请验证后登录

短信验证码: 获取验证码

未设定销售价格

11021男款上衣

生产商：旺兴工厂（区域2）

查看...

0g

1个起

80%平均时效：45小时

平均发货时效：46小时

生产商承诺发货：暂无数据

￥18.60

435

生产商：旺兴工厂（区域2）

查看...

100g

牛津布

20.00

1-4个

19.70

5-20个

19.00

21-50个

18.60

51+个

80%平均时效：43小时

平均发货时效：52小时

生产商承诺发货：1小时

未设定销售价格

儿童颈部保暖围巾

生产商：江西工厂（江西）

查看...

500g

羊毛cotton

1件起

80%平均时效：45小时

平均发货时效：45小时

生产商承诺发货：1小时

￥20.70

婴儿短袖连体衣

生产商：旺兴工厂（区域2）

查看...

100g

棉

20.70

1+个

80%平均时效：45小时

平均发货时效：48小时

生产商承诺发货：暂无数据

儿童网格帽

登录查看价格

￥30.00

百变头巾

生产商： wangxin （区域3）

查看...

200g

30.00

1个起

80%平均时效：45小时

平均发货时效：46小时

生产商承诺发货：90小时

￥10.00

1219测试

生产商：旺兴工厂（区域2）

查看...

10g

10.00

1个起

80%平均时效：48小时

平均发货时效：49小时

生产商承诺发货：64小时

￥100.00

253

生产商：旺兴工厂（区域2）

查看...

233g

纱布

100.00

1个起

80%平均时效：41小时

平均发货时效：48小时

生产商承诺发货：36小时

￥30.00

女带帽无口袋卫衣

生产商：旺兴工厂（区域2）

查看...

1g

纱布

30.00

1个起

80%平均时效：45小时

平均发货时效：52小时

生产商承诺发货：64小时

￥27.75

0831测试2

生产商：旺兴工厂（区域2）

查看...

120g

塑料

30.00

1-9个

29.70

10-40个

29.40

41-99个

29.25

100-299个

28.35

300-888个

27.75

889+个

80%平均时效：46小时

平均发货时效：46小时

生产商承诺发货：3小时

￥100.00

1000M-圆领男T

生产商：旺兴工厂（区域2）

查看...

233g

纱布

100.00

1个起

80%平均时效：41小时

平均发货时效：48小时

生产商承诺发货：36小时

￥19.90

测试婴儿爬爬服

生产商：旺兴工厂（区域2）

查看...

100g

19.90

1个起

80%平均时效：47小时

平均发货时效：52小时

生产商承诺发货：暂无数据

￥17.91

儿童短袖T

生产商：旺兴工厂（区域2）

查看...

45g

19.90

1-4个

18.91

5-14个

18.51

15-29个

17.91

30+个

80%平均时效：43小时

平均发货时效：47小时

生产商承诺发货：96小时

儿童短袖T恤

登录查看价格

￥33.49

婴儿长袖爬爬服

生产商：

查看...

0g

34.58

5-14个

34.22

15-29个

33.49

30+个

80%平均时效：暂无数据

平均发货时效：暂无数据

生产商承诺发货：暂无数据

全局权限设定

全局权限设定针对全公司未添加分配过产品权限的子账号，默认这些账号全部产品可见，修改全局权限设定将会影响原来账号的产品权限，请谨慎使用。 SVIP和有单独添加分配过产品权限的子账号，不受该规则影响。

取消确定

请选择子账号

未分配产品的账号产品列表为空，已分配过产品的账号只能看到已分配的产品，重复添加无效。

品类权限为主账号所有产品的子账号不可再分配产品。

搜索

全选	编号	用户名	姓名	角色

关闭保存

授权独品：

关联账号全选

已授权账号全选

已选1个账号

说明！企业版用户可以将尊享独品授权给关联管理员账号

取消保存

返回
顶部

0件库存

先收钱，不压货

1件代发

无后勤，更专注

2倍赔偿

高信誉，安心卖

30天无忧售后

极速退，有保障

© 2013-2021 指纹科技版权所有 | 增值业务许可证：闽B2-20191001 | 闽ICP备15019889号-1 | 营业执照

在线客服

基本文件流程错误 SQL 调试

/data/www/sandbox/public/index.php ( 0.79 KB )
/data/www/sandbox/thinkphp/start.php ( 0.71 KB )
/data/www/sandbox/thinkphp/base.php ( 3.18 KB )
/data/www/sandbox/thinkphp/library/think/Loader.php ( 18.83 KB )
/data/www/sandbox/vendor/composer/autoload_namespaces.php ( 0.27 KB )
/data/www/sandbox/vendor/composer/autoload_psr4.php ( 0.86 KB )
/data/www/sandbox/vendor/composer/autoload_classmap.php ( 0.20 KB )
/data/www/sandbox/vendor/composer/autoload_files.php ( 0.62 KB )
/data/www/sandbox/vendor/swiftmailer/swiftmailer/lib/swift_required.php ( 0.66 KB )
/data/www/sandbox/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php ( 2.03 KB )
/data/www/sandbox/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
/data/www/sandbox/vendor/topthink/think-captcha/src/helper.php ( 1.61 KB )
/data/www/sandbox/thinkphp/library/think/Route.php ( 58.59 KB )
/data/www/sandbox/thinkphp/library/think/Config.php ( 6.16 KB )
/data/www/sandbox/thinkphp/library/think/Validate.php ( 39.43 KB )
/data/www/sandbox/vendor/topthink/think-queue/src/common.php ( 1.19 KB )
/data/www/sandbox/thinkphp/library/think/Console.php ( 20.52 KB )
/data/www/sandbox/thinkphp/library/think/Error.php ( 3.61 KB )
/data/www/sandbox/thinkphp/convention.php ( 10.10 KB )
/data/www/sandbox/thinkphp/library/think/App.php ( 20.27 KB )
/data/www/sandbox/thinkphp/library/think/Request.php ( 48.99 KB )
/data/www/sandbox/application/config.php ( 16.22 KB )
/data/www/sandbox/thinkphp/library/think/Env.php ( 1.21 KB )
/data/www/sandbox/application/database.php ( 2.00 KB )
/data/www/sandbox/application/extra/queue.php ( 1.18 KB )
/data/www/sandbox/application/extra/splitDb.php ( 1.66 KB )
/data/www/sandbox/thinkphp/library/think/Hook.php ( 4.63 KB )
/data/www/sandbox/application/tags.php ( 1.18 KB )
/data/www/sandbox/application/common.php ( 120.02 KB )
/data/www/sandbox/application/helper.php ( 0.00 KB )
/data/www/sandbox/thinkphp/helper.php ( 17.30 KB )
/data/www/sandbox/thinkphp/library/think/Lang.php ( 6.91 KB )
/data/www/sandbox/thinkphp/library/think/Log.php ( 5.63 KB )
/data/www/sandbox/thinkphp/lang/zh-cn.php ( 11.58 KB )
/data/www/sandbox/application/route.php ( 12.45 KB )
/data/www/sandbox/application/routes/open.php ( 2.27 KB )
/data/www/sandbox/thinkphp/library/think/Debug.php ( 6.85 KB )
/data/www/sandbox/application/common/behavior/Tags.php ( 0.66 KB )
/data/www/sandbox/application/helper/SystemConfigHelper.php ( 16.95 KB )
/data/www/sandbox/application/helper/BaseHelper.php ( 25.80 KB )
/data/www/sandbox/application/helper/RedisClusterCacheHelper.php ( 8.50 KB )
/data/www/sandbox/application/helper/CacheKeyHelper.php ( 15.31 KB )
/data/www/sandbox/application/frontend/config.php ( 1.06 KB )
/data/www/sandbox/application/common/behavior/WebLog.php ( 15.72 KB )
/data/www/sandbox/extend/org/Ip.php ( 2.90 KB )
/data/www/sandbox/thinkphp/library/think/Session.php ( 11.37 KB )
/data/www/sandbox/thinkphp/library/think/session/driver/Redis.php ( 3.47 KB )
/data/www/sandbox/extend/org/Agent.php ( 5.96 KB )
/data/www/sandbox/application/frontend/controller/ProductTypeController.php ( 33.02 KB )
/data/www/sandbox/application/frontend/controller/BaseController.php ( 12.22 KB )
/data/www/sandbox/thinkphp/library/think/Controller.php ( 5.99 KB )
/data/www/sandbox/thinkphp/library/traits/controller/Jump.php ( 6.21 KB )
/data/www/sandbox/thinkphp/library/think/View.php ( 6.75 KB )
/data/www/sandbox/thinkphp/library/think/view/driver/Think.php ( 5.67 KB )
/data/www/sandbox/thinkphp/library/think/Template.php ( 45.04 KB )
/data/www/sandbox/thinkphp/library/think/template/driver/File.php ( 2.17 KB )
/data/www/sandbox/application/helper/MapHelper.php ( 103.10 KB )
/data/www/sandbox/application/common/model/Customer.php ( 6.53 KB )
/data/www/sandbox/application/common/model/Base.php ( 3.37 KB )
/data/www/sandbox/thinkphp/library/think/Model.php ( 67.04 KB )
/data/www/sandbox/application/helper/CommonHelper.php ( 0.85 KB )
/data/www/sandbox/application/helper/ProductTypeHelper.php ( 204.59 KB )
/data/www/sandbox/application/frontend/helper/ProductTypeHelper.php ( 66.17 KB )
/data/www/sandbox/application/frontend/helper/BaseHelper.php ( 1.00 KB )
/data/www/sandbox/thinkphp/library/think/Cache.php ( 5.96 KB )
/data/www/sandbox/thinkphp/library/think/cache/driver/Redis.php ( 5.35 KB )
/data/www/sandbox/thinkphp/library/think/cache/Driver.php ( 6.05 KB )
/data/www/sandbox/application/merchant/helper/ProductTypeHelper.php ( 128.17 KB )
/data/www/sandbox/application/merchant/helper/BaseHelper.php ( 2.35 KB )
/data/www/sandbox/application/admin/model/ProductType.php ( 71.75 KB )
/data/www/sandbox/application/admin/model/Base.php ( 2.05 KB )
/data/www/sandbox/thinkphp/library/think/Db.php ( 6.45 KB )
/data/www/sandbox/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
/data/www/sandbox/thinkphp/library/think/db/Connection.php ( 29.13 KB )
/data/www/sandbox/thinkphp/library/think/db/Query.php ( 88.30 KB )
/data/www/sandbox/thinkphp/library/think/db/builder/Mysql.php ( 2.09 KB )
/data/www/sandbox/thinkphp/library/think/db/Builder.php ( 30.31 KB )
/data/www/sandbox/application/helper/HttpHelper.php ( 31.66 KB )
/data/www/sandbox/application/helper/GroupHelper.php ( 19.68 KB )
/data/www/sandbox/application/common/model/Group.php ( 3.41 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_group.php ( 5.51 KB )
/data/www/sandbox/application/helper/GradientPriceRuleHelper.php ( 194.56 KB )
/data/www/sandbox/application/helper/StockSizeHelper.php ( 16.81 KB )
/data/www/sandbox/application/helper/StockColorHelper.php ( 5.04 KB )
/data/www/sandbox/application/helper/StockSkuHelper.php ( 175.31 KB )
/data/www/sandbox/application/helper/GroupLevelHelper.php ( 12.96 KB )
/data/www/sandbox/application/admin/model/GroupLevel.php ( 2.55 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_group_level.php ( 14.21 KB )
/data/www/sandbox/application/helper/ProductTypeLevelPermissionHelper.php ( 2.79 KB )
/data/www/sandbox/application/admin/model/ProductTypeLevelPermission.php ( 0.18 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_product_type_level_permission.php ( 0.90 KB )
/data/www/sandbox/application/helper/ProductTypeBwListHelper.php ( 4.92 KB )
/data/www/sandbox/application/admin/model/ProductTypeBwList.php ( 0.36 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_product_type_bw_list.php ( 1.24 KB )
/data/www/sandbox/application/helper/CustomerHelper.php ( 43.70 KB )
/data/www/sandbox/application/helper/FactoryGroupManageExtraHelper.php ( 8.36 KB )
/data/www/sandbox/application/admin/model/FactoryGroupManage.php ( 0.34 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_factory_group_manage.php ( 2.57 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_customer.php ( 6.11 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_product_type.php ( 8.86 KB )
/data/www/sandbox/application/admin/model/StockSize.php ( 1.22 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_stock_size.php ( 1.58 KB )
/data/www/sandbox/thinkphp/library/think/model/Collection.php ( 2.67 KB )
/data/www/sandbox/thinkphp/library/think/Collection.php ( 8.70 KB )
/data/www/sandbox/application/admin/model/StockColor.php ( 1.00 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_stock_color.php ( 1.74 KB )
/data/www/sandbox/application/helper/ProductHelper.php ( 203.98 KB )
/data/www/sandbox/application/admin/model/StockSku.php ( 5.11 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_stock_sku.php ( 15.74 KB )
/data/www/sandbox/application/admin/model/GradientPriceRule.php ( 10.32 KB )
/data/www/sandbox/application/helper/GradientPriceFormulaHelper.php ( 2.43 KB )
/data/www/sandbox/application/helper/GradientPriceRuleDetHelper.php ( 1.25 KB )
/data/www/sandbox/application/admin/model/GradientPriceRuleDet.php ( 0.67 KB )
/data/www/sandbox/application/helper/PromotionHelper.php ( 2.20 KB )
/data/www/sandbox/application/admin/model/ProductTypeBottomTemplate.php ( 0.33 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_product_type_bottom_template.php ( 1.41 KB )
/data/www/sandbox/application/helper/DataHelper.php ( 30.37 KB )
/data/www/sandbox/application/helper/FastDFSHelper.php ( 22.50 KB )
/data/www/sandbox/extend/fastdfs/FastDFSUploader.php ( 7.93 KB )
/data/www/sandbox/application/admin/model/FastdfsImage.php ( 3.50 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_fastdfs_image.php ( 1.71 KB )
/data/www/sandbox/application/admin/model/ProductTypeTexture.php ( 1.93 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_product_type_texture.php ( 1.41 KB )
/data/www/sandbox/application/helper/ProductTypeDetailHelper.php ( 87.59 KB )
/data/www/sandbox/application/admin/model/ProductTypeDetailImage.php ( 0.29 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_product_type_detail_image.php ( 1.59 KB )
/data/www/sandbox/application/admin/model/Product.php ( 42.51 KB )
/data/www/sandbox/application/admin/model/ProductTypeDetailPrintArea.php ( 0.58 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_product_type_detail_print_area.php ( 4.59 KB )
/data/www/sandbox/application/helper/ProductTypeCategoryHelper.php ( 44.33 KB )
/data/www/sandbox/application/admin/model/ProductTypeCategory.php ( 3.19 KB )
/data/www/sandbox/runtime/schema/zwdcsandbox.zwdc_product_type_category.php ( 1.39 KB )
/data/www/sandbox/application/merchant/model/SvipConfig.php ( 0.71 KB )
/data/www/sandbox/application/merchant/model/Base.php ( 1.16 KB )
/data/www/sandbox/runtime/temp/99e3334ad9c9ebe51f4f179083b6624e.php ( 157.56 KB )
/data/www/sandbox/application/helper/LoginApiHelper.php ( 62.86 KB )
/data/www/sandbox/thinkphp/library/think/Response.php ( 8.33 KB )
/data/www/sandbox/thinkphp/library/think/debug/Html.php ( 4.16 KB )

[ LANG ] /data/www/sandbox/thinkphp/lang/zh-cn.php
[ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'frontend', 1 => 'productType', 2 => 'index', ), 'convert' => false, )
[ HEADER ] array ( 'host' => 'sandbox.zhiwendiy.com', 'x-real-ip' => '118.178.15.71', 'x-forwarded-for' => '54.236.62.49, 118.178.15.71', 'connection' => 'close', 'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'x-true-ip' => '54.236.62.49', 'web-server-type' => 'nginx', 'wl-proxy-client-ip' => '54.236.62.49', 'x-forwarded-proto' => 'https', 'x-forwarded-cluster' => 'waf,', 'eagleeye-traceid' => '76b20f4716142175609114487ea32a', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'accept-language' => 'en-US,en;q=0.5', 'accept-encoding' => 'br,gzip', 'eagleeye-rpcid' => '0.1', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'isSearch' => '1', 'cat_id' => '25', )
[ BEHAVIOR ] Run app\common\behavior\Tags @app_begin [ RunTime:0.001358s ]
[ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'zwdc', 'expire' => 86400, 'type' => 'redis', 'host' => '192.168.2.65', 'port' => '6379', 'select' => '12', 'auto_start' => true, )
[ BEHAVIOR ] Run app\common\behavior\WebLog @module_init [ RunTime:0.002555s ]
[ CACHE ] INIT redis
[ RUN ] app\frontend\controller\ProductTypeController->index[ /data/www/sandbox/application/frontend/controller/ProductTypeController.php ]
[ DB ] INIT mysql
[ DB ] INIT mysql
[ VIEW ] ../view/frontend/productType/list.php [ array ( 0 => 'DefaultCssList', 1 => 'DefaultJsList', 2 => 'pageSizeList', 3 => 'merchant', 4 => 'monitor_code', 5 => 'searchParam', 6 => 'cartNum', 7 => 'statistics_code', 8 => 'errorData', 9 => 'selection_search_hot_words', 10 => 'category_list', 11 => 'Gender', 12 => 'Seasonal', 13 => 'Imgfull', 14 => 'DeliverGoods', 15 => 'SizeAttribute', 16 => 'design_area_shape_list', 17 => 'list', 18 => 'subAccountList', 19 => 'ShowList', 20 => 'roleList', 21 => 'authority', 22 => 'groupLevelList', 23 => 'navData', 24 => 'params_attributes', 25 => 'typeList', 26 => 'purchasePriceList', 27 => 'weightList', 28 => 'titleName', 29 => 'MetaData', ) ]

[ DB ] CONNECT:[ UseTime:0.000679s ] mysql:host=192.168.2.133;port=3306;dbname=zwdcsandbox;charset=utf8
[ SQL ] SELECT * FROM `zwdc_group` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000609s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_group_level` WHERE `status` = 1 ORDER BY `annual_fee` asc,`id` asc [ RunTime:0.000524s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (3) GROUP BY `product_type_id` [ RunTime:0.000466s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_bw_list` WHERE `group_id` = 0 AND `bw_type` = 2 [ RunTime:0.000372s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (2) GROUP BY `product_type_id` [ RunTime:0.000438s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (4) GROUP BY `product_type_id` [ RunTime:0.000399s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000315s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10175 LIMIT 1 [ RunTime:0.000472s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10175 LIMIT 1 [ RunTime:0.000550s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (32) ORDER BY position asc [ RunTime:0.000314s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29) ORDER BY position asc [ RunTime:0.000320s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10175 LIMIT 1 [ RunTime:0.000492s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10175 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('32') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000530s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10175 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 426 LIMIT 1 [ RunTime:0.003489s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = '11021' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000529s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10175 LIMIT 1 [ RunTime:0.001936s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 426 LIMIT 1 [ RunTime:0.005982s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000289s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10155 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10155 LIMIT 1 [ RunTime:0.000473s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30) ORDER BY position asc [ RunTime:0.000325s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (30) ORDER BY position asc [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10155 LIMIT 1 [ RunTime:0.000470s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10155 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000545s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10155 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000340s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 389 LIMIT 1 [ RunTime:0.000630s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = 'xue-0308A' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.005368s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10155 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 389 LIMIT 1 [ RunTime:0.000641s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10221' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000376s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10221) [ RunTime:0.000276s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10297 LIMIT 1 [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10297 LIMIT 1 [ RunTime:0.000538s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (136) ORDER BY position asc [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10297 LIMIT 1 [ RunTime:0.000488s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10297 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('136') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000510s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10297 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000337s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 561 LIMIT 1 [ RunTime:0.000632s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10297 LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 561 LIMIT 1 [ RunTime:0.000645s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000330s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000294s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10207 LIMIT 1 [ RunTime:0.008382s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10207 LIMIT 1 [ RunTime:0.000541s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (45) ORDER BY position asc [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10207 [ RunTime:0.003716s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 95290 LIMIT 1 [ RunTime:0.000315s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10207 [ RunTime:0.002010s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 95291 LIMIT 1 [ RunTime:0.000389s ]
[ SQL ] SELECT `detailImage`.*,`detailPrintArea`.`use_view_id`,`detailPrintArea`.`master`,`detailPrintArea`.`is_major_img` FROM `zwdc_product_type_detail_image` `detailImage` INNER JOIN `zwdc_product_type_detail_print_area` `detailPrintArea` ON `detailPrintArea`.`product_type_id`=detailImage.product_type_id and detailPrintArea.view_id = detailImage.view_id and detailPrintArea.position = detailImage.position WHERE `detailImage`.`product_type_id` = 10207 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000684s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10207 AND `view_id` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.010492s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10207 AND `view_id` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.002353s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10207 LIMIT 1 [ RunTime:0.000622s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10207 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('45') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000519s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10207 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000337s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 452 LIMIT 1 [ RunTime:0.000640s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10207 LIMIT 1 [ RunTime:0.000319s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 452 LIMIT 1 [ RunTime:0.000569s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000352s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000288s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10158 LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10158 LIMIT 1 [ RunTime:0.000475s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (131,134,31,30) ORDER BY position asc [ RunTime:0.000334s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10158 LIMIT 1 [ RunTime:0.000486s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10158 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('131','134','31','30') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000569s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10158 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 403 LIMIT 1 [ RunTime:0.000591s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = '010102' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000354s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10158 LIMIT 1 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 403 LIMIT 1 [ RunTime:0.000630s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10192' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000411s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10192) [ RunTime:0.000361s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10145 LIMIT 1 [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10145 LIMIT 1 [ RunTime:0.000492s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (48) ORDER BY position asc [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10145 LIMIT 1 [ RunTime:0.000451s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10145 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000541s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10145 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 377 LIMIT 1 [ RunTime:0.000604s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = '2320T-' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10145 LIMIT 1 [ RunTime:0.000328s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 377 LIMIT 1 [ RunTime:0.000648s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000382s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000280s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10142 LIMIT 1 [ RunTime:0.000312s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10142 LIMIT 1 [ RunTime:0.000441s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30,38) ORDER BY position asc [ RunTime:0.000347s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (31,30,33) ORDER BY position asc [ RunTime:0.000348s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10142 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 82419 LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 82420 LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 82421 LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10142 [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 82422 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] SELECT `detailImage`.*,`detailPrintArea`.`use_view_id`,`detailPrintArea`.`master`,`detailPrintArea`.`is_major_img` FROM `zwdc_product_type_detail_image` `detailImage` INNER JOIN `zwdc_product_type_detail_print_area` `detailPrintArea` ON `detailPrintArea`.`product_type_id`=detailImage.product_type_id and detailPrintArea.view_id = detailImage.view_id and detailPrintArea.position = detailImage.position WHERE `detailImage`.`product_type_id` = 10142 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000508s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10142 AND `view_id` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000378s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10142 AND `view_id` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10142 AND `view_id` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000357s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10142 AND `view_id` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10142 AND `view_id` = 1 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10142 AND `view_id` = 1 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000399s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10142 LIMIT 1 [ RunTime:0.000623s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10142 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','38') AND `stockSkuItems`.`color_id` IN ('31','30','33') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000698s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10142 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 369 LIMIT 1 [ RunTime:0.000623s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = 'SKU1219' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10142 LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 369 LIMIT 1 [ RunTime:0.000629s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000983s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000308s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10134 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10134 LIMIT 1 [ RunTime:0.000497s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10134 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 80072 LIMIT 1 [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 80073 LIMIT 1 [ RunTime:0.000313s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10134 [ RunTime:0.000408s ]
[ DB ] CONNECT:[ UseTime:0.000806s ] mysql:host=192.168.2.81;port=3306;dbname=zwdc_product;charset=utf8
[ SQL ] SHOW COLUMNS FROM `zwdc_product` [ RunTime:0.001113s ]
[ SQL ] SELECT * FROM `zwdc_product` WHERE `id` = 123242 LIMIT 1 [ RunTime:0.000814s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'zwdc_product', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100, 'extra' => NULL, ) ]
[ SQL ] SELECT `detailImage`.*,`detailPrintArea`.`use_view_id`,`detailPrintArea`.`master`,`detailPrintArea`.`is_major_img` FROM `zwdc_product_type_detail_image` `detailImage` INNER JOIN `zwdc_product_type_detail_print_area` `detailPrintArea` ON `detailPrintArea`.`product_type_id`=detailImage.product_type_id and detailPrintArea.view_id = detailImage.view_id and detailPrintArea.position = detailImage.position WHERE `detailImage`.`product_type_id` = 10134 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000716s ]
[ SQL ] SELECT `id` FROM `zwdc_product_type_detail_print_area` WHERE `product_type_id` = 10134 AND `position` = 1 AND `type` = 2 LIMIT 1 [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10134 LIMIT 1 [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10134 LIMIT 1 [ RunTime:0.000549s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10134 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000556s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10134 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 355 LIMIT 1 [ RunTime:0.000620s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = 'D4060A' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000342s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10134 LIMIT 1 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 355 LIMIT 1 [ RunTime:0.000589s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000294s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10133 LIMIT 1 [ RunTime:0.000312s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10133 LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10133 LIMIT 1 [ RunTime:0.000485s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10133 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000605s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10133 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 361 LIMIT 1 [ RunTime:0.000632s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = '100000M-CS' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000408s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10133 LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 361 LIMIT 1 [ RunTime:0.000683s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000339s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10130 LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10130 LIMIT 1 [ RunTime:0.000518s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (131,30,38) ORDER BY position asc [ RunTime:0.000358s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29,32,34,105,31) ORDER BY position asc [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10130 LIMIT 1 [ RunTime:0.000466s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10130 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('131','30','38') AND `stockSkuItems`.`color_id` IN ('29','32','34','105','31') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000738s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10130 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 353 LIMIT 1 [ RunTime:0.000838s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = 'SKU08312' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000440s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10130 LIMIT 1 [ RunTime:0.000450s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 353 LIMIT 1 [ RunTime:0.000784s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000461s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000358s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10138 LIMIT 1 [ RunTime:0.000407s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10138 LIMIT 1 [ RunTime:0.000613s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10138 LIMIT 1 [ RunTime:0.000676s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10138 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000705s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10138 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000446s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10138 LIMIT 1 [ RunTime:0.000436s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 355 LIMIT 1 [ RunTime:0.000848s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000493s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000400s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10117 LIMIT 1 [ RunTime:0.000440s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10117 LIMIT 1 [ RunTime:0.000681s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (40,41,42,39) ORDER BY position asc [ RunTime:0.000530s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10117 [ RunTime:0.000529s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 76591 LIMIT 1 [ RunTime:0.000416s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 76626 LIMIT 1 [ RunTime:0.000398s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10117 [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 76592 LIMIT 1 [ RunTime:0.000403s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 76627 LIMIT 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `zwdc_product` WHERE `id` = 122885 LIMIT 1 [ RunTime:0.000783s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'zwdc_product', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100, 'extra' => NULL, ) ]
[ SQL ] SELECT `detailImage`.*,`detailPrintArea`.`use_view_id`,`detailPrintArea`.`master`,`detailPrintArea`.`is_major_img` FROM `zwdc_product_type_detail_image` `detailImage` INNER JOIN `zwdc_product_type_detail_print_area` `detailPrintArea` ON `detailPrintArea`.`product_type_id`=detailImage.product_type_id and detailPrintArea.view_id = detailImage.view_id and detailPrintArea.position = detailImage.position WHERE `detailImage`.`product_type_id` = 10117 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000716s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10117 LIMIT 1 [ RunTime:0.000615s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10117 LIMIT 1 [ RunTime:0.000544s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10117 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('40','41','42','39') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000793s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10117 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000712s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = 'TEST001-VE' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10117 LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000662s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000428s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000347s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10099 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10099 LIMIT 1 [ RunTime:0.000656s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (40,41,46,47) ORDER BY position asc [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10099 LIMIT 1 [ RunTime:0.000564s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10099 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('40','41','46','47') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000633s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10099 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000613s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = 'B1000-VE' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10099 LIMIT 1 [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000584s ]
[ SQL ] SELECT `factory_link` FROM `zwdc_factory_group_manage` `factoryGroupManage` LEFT JOIN `zwdc_factory_group_manage_extra` `factoryGroupManageExtra` ON `factoryGroupManageExtra`.`manage_id`=`factoryGroupManage`.`id` WHERE `factoryGroupManage`.`group_id` = '10120' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000329s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10049 LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10049 LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (38,29,30,31,32,33) ORDER BY position asc [ RunTime:0.000363s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10049 [ RunTime:0.000454s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 63614 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 63612 LIMIT 1 [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10049 [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 63613 LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 63615 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `zwdc_product` WHERE `id` = 119905 LIMIT 1 [ RunTime:0.000713s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'zwdc_product', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100, 'extra' => NULL, ) ]
[ SQL ] SELECT `detailImage`.*,`detailPrintArea`.`use_view_id`,`detailPrintArea`.`master`,`detailPrintArea`.`is_major_img` FROM `zwdc_product_type_detail_image` `detailImage` INNER JOIN `zwdc_product_type_detail_print_area` `detailPrintArea` ON `detailPrintArea`.`product_type_id`=detailImage.product_type_id and detailPrintArea.view_id = detailImage.view_id and detailPrintArea.position = detailImage.position WHERE `detailImage`.`product_type_id` = 10049 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000634s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10049 LIMIT 1 [ RunTime:0.000617s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10049 LIMIT 1 [ RunTime:0.000525s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10049 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('38','29','30','31','32','33') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000679s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10049 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000558s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000814s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = 'C1000-VE' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000471s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10049 LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000837s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`sort`,`new_time` FROM `zwdc_product_type` WHERE `id` = 10004 LIMIT 1 [ RunTime:0.002608s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10004 LIMIT 1 [ RunTime:0.002977s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (40,44,45,43,46,47) ORDER BY position asc [ RunTime:0.000412s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (31,30,103) ORDER BY position asc [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10004 LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 10004 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('40','44','45','43','46','47') AND `stockSkuItems`.`color_id` IN ('31','30','103') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000851s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10004 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000648s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zwdc_stock_sku` `stockSku` INNER JOIN `zwdc_sku_auth_group` `skuAuthGroup` ON `skuAuthGroup`.`sku_id`=`stockSku`.`id` WHERE `stockSku`.`sku` = '2380B' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000452s ]
[ SQL ] SELECT `id`,`code`,`color_ids`,`desc`,`name`,`size_ids`,`view_ids`,`product_id`,`is_promotion`,`is_preferred`,`stock_sku`,`new_time`,`status` FROM `zwdc_product_type` WHERE `id` = 10004 LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000562s ]
[ SQL ] SELECT * FROM `zwdc_product_type_category` WHERE `id` = 25 LIMIT 1 [ RunTime:0.000334s ]

0.351654s

ShowPageTrace