[ DB ] CONNECT:[ UseTime:0.012981s ] mysql:host=192.168.2.133;port=3306;dbname=zwdcsandbox;charset=utf8
[ SQL ] SELECT * FROM `zwdc_group` WHERE `id` = 0 LIMIT 1 [ RunTime:0.008000s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_group_level` WHERE `status` = 1 ORDER BY `annual_fee` asc,`id` asc [ RunTime:0.047400s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (3) GROUP BY `product_type_id` [ RunTime:0.010346s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_bw_list` WHERE `group_id` = 0 AND `bw_type` = 2 [ RunTime:0.025398s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (2) GROUP BY `product_type_id` [ RunTime:0.005612s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (4) GROUP BY `product_type_id` [ RunTime:0.019618s ]
[ 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.016196s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.003392s ]
[ 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` = 10292 LIMIT 1 [ RunTime:0.011419s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10292 LIMIT 1 [ RunTime:0.025591s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30) ORDER BY position asc [ RunTime:0.024453s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29) ORDER BY position asc [ RunTime:0.014566s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10292 LIMIT 1 [ RunTime:0.025224s ]
[ 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` = 10292 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.023005s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10292 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.022302s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 389 LIMIT 1 [ RunTime:0.012118s ]
[ 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.028843s ]
[ 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` = 10292 LIMIT 1 [ RunTime:0.028355s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 389 LIMIT 1 [ RunTime:0.026200s ]
[ 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` = '10209' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.038725s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10209) [ RunTime:0.011775s ]
[ 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` = 10243 LIMIT 1 [ RunTime:0.008102s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10243 LIMIT 1 [ RunTime:0.038636s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (136) ORDER BY position asc [ RunTime:0.010739s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10243 LIMIT 1 [ RunTime:0.009438s ]
[ 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` = 10243 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.015892s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10243 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.019738s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 516 LIMIT 1 [ RunTime:0.029223s ]
[ 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` = 10243 LIMIT 1 [ RunTime:0.017555s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 516 LIMIT 1 [ RunTime:0.027778s ]
[ 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` = '10209' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.021238s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10209) [ RunTime:0.015885s ]
[ 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` = 10223 LIMIT 1 [ RunTime:0.022773s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10223 LIMIT 1 [ RunTime:0.029425s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (48) ORDER BY position asc [ RunTime:0.007431s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (33,32,34,35,103,29) ORDER BY position asc [ RunTime:0.018980s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10223 LIMIT 1 [ RunTime:0.049277s ]
[ 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` = 10223 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('33','32','34','35','103','29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.012710s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10223 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.021943s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 477 LIMIT 1 [ RunTime:0.010829s ]
[ 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` = 'NC011-' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.045163s ]
[ 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` = 10223 LIMIT 1 [ RunTime:0.008332s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 477 LIMIT 1 [ RunTime:0.005257s ]
[ 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` = '10209' AND `factoryGroupManageExtra`.`status` = 1 LIMIT 1 [ RunTime:0.009452s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10209) [ RunTime:0.013569s ]
[ 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` = 10235 LIMIT 1 [ RunTime:0.016707s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10235 LIMIT 1 [ RunTime:0.005544s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (142,137,139,140) ORDER BY position asc [ RunTime:0.014201s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (100,101) ORDER BY position asc [ RunTime:0.026492s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10235 LIMIT 1 [ RunTime:0.003994s ]
[ 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` = 10235 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('142','137','139','140') AND `stockSkuItems`.`color_id` IN ('100','101') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000771s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10235 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.009283s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 492 LIMIT 1 [ RunTime:0.003921s ]
[ 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` = 'ZY0609' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000366s ]
[ 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` = 10235 LIMIT 1 [ RunTime:0.002005s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 492 LIMIT 1 [ RunTime:0.007291s ]
[ 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.002177s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000297s ]
[ 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.000335s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10130 LIMIT 1 [ RunTime:0.001417s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (131,30,38) ORDER BY position asc [ RunTime:0.002545s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29,32,34,105,31) ORDER BY position asc [ RunTime:0.002543s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10130 LIMIT 1 [ RunTime:0.002088s ]
[ 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.000952s ]
[ 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.005589s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 353 LIMIT 1 [ RunTime:0.000699s ]
[ 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.000617s ]
[ 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.004483s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 353 LIMIT 1 [ RunTime:0.000625s ]
[ 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.002250s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.003662s ]
[ 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` = 10184 LIMIT 1 [ RunTime:0.000395s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10184 LIMIT 1 [ RunTime:0.000477s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (131) ORDER BY position asc [ RunTime:0.000288s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (104) ORDER BY position asc [ RunTime:0.000639s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10184 LIMIT 1 [ RunTime:0.000760s ]
[ 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` = 10184 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('131') AND `stockSkuItems`.`color_id` IN ('104') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.002192s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10184 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000406s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 439 LIMIT 1 [ RunTime:0.000739s ]
[ 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` = '0725' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000394s ]
[ 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` = 10184 LIMIT 1 [ RunTime:0.000415s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 439 LIMIT 1 [ RunTime:0.000591s ]
[ 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.000328s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000285s ]
[ 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` = 10132 LIMIT 1 [ RunTime:0.001045s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10132 LIMIT 1 [ RunTime:0.000461s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30,38) ORDER BY position asc [ RunTime:0.000348s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29,31,30) ORDER BY position asc [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10132 LIMIT 1 [ RunTime:0.000508s ]
[ 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` = 10132 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','38') AND `stockSkuItems`.`color_id` IN ('29','31','30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000573s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10132 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 357 LIMIT 1 [ RunTime:0.000596s ]
[ 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` = '09122' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000418s ]
[ 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` = 10132 LIMIT 1 [ RunTime:0.000401s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 357 LIMIT 1 [ RunTime:0.004952s ]
[ 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.000285s ]
[ 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` = 10307 LIMIT 1 [ RunTime:0.000484s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10307 LIMIT 1 [ RunTime:0.000482s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30,31,32) ORDER BY position asc [ RunTime:0.000336s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29,102,33) ORDER BY position asc [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10307 LIMIT 1 [ RunTime:0.000468s ]
[ 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` = 10307 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32') AND `stockSkuItems`.`color_id` IN ('29','102','33') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.002811s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10307 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 570 LIMIT 1 [ RunTime:0.000565s ]
[ 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` = 10307 LIMIT 1 [ RunTime:0.000337s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 570 LIMIT 1 [ RunTime:0.000550s ]
[ 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.005376s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000292s ]
[ 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` = 10230 LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10230 LIMIT 1 [ RunTime:0.000535s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (102,103) ORDER BY position asc [ RunTime:0.000360s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (34,29) ORDER BY position asc [ RunTime:0.000335s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10230 LIMIT 1 [ RunTime:0.000509s ]
[ 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` = 10230 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('102','103') AND `stockSkuItems`.`color_id` IN ('34','29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000585s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10230 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.003807s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 489 LIMIT 1 [ RunTime:0.000800s ]
[ 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` = 'GZY00101' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000487s ]
[ 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` = 10230 LIMIT 1 [ RunTime:0.000548s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 489 LIMIT 1 [ RunTime:0.000769s ]
[ 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.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` = 10136 LIMIT 1 [ RunTime:0.004722s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10136 LIMIT 1 [ RunTime:0.000612s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,31,30,32,33) ORDER BY position asc [ RunTime:0.000441s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10136 LIMIT 1 [ RunTime:0.000602s ]
[ 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` = 10136 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','31','30','32','33') AND `stockSkuItems`.`color_id` IN ('29','31','30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000715s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10136 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000772s ]
[ 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` = '4400M-VE' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.002100s ]
[ 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` = 10136 LIMIT 1 [ RunTime:0.000471s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000674s ]
[ 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.002079s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000325s ]
[ 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` = 10007 LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10007 LIMIT 1 [ RunTime:0.000668s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29,106) ORDER BY position asc [ RunTime:0.000434s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10007 LIMIT 1 [ RunTime:0.000647s ]
[ 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` = 10007 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29','106') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.001917s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10007 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.003718s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 11 LIMIT 1 [ RunTime:0.002529s ]
[ 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` = 'IP60D-VE' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000943s ]
[ 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` = 10007 LIMIT 1 [ RunTime:0.003858s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000976s ]
[ 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.000433s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000298s ]
[ 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` = 10290 LIMIT 1 [ RunTime:0.000386s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10290 LIMIT 1 [ RunTime:0.000536s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (30) ORDER BY position asc [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10290 LIMIT 1 [ RunTime:0.000454s ]
[ 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` = 10290 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.000468s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10290 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000351s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 557 LIMIT 1 [ RunTime:0.000638s ]
[ 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` = 10290 LIMIT 1 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 557 LIMIT 1 [ RunTime:0.000595s ]
[ 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.000321s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000317s ]
[ 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` = 10363 LIMIT 1 [ RunTime:0.000341s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10363 LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (156,157,29,30,31) ORDER BY position asc [ RunTime:0.000347s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (112,111,104) ORDER BY position asc [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10363 LIMIT 1 [ RunTime:0.000534s ]
[ 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` = 10363 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('156','157','29','30','31') AND `stockSkuItems`.`color_id` IN ('112','111','104') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000744s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10363 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000341s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 586 LIMIT 1 [ RunTime:0.000655s ]
[ 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` = 'cgspyhl1' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000463s ]
[ 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` = 10363 LIMIT 1 [ RunTime:0.000335s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 586 LIMIT 1 [ RunTime:0.000647s ]
[ 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.000319s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000264s ]
[ 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` = 10361 LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10361 LIMIT 1 [ RunTime:0.000439s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30,31) ORDER BY position asc [ RunTime:0.000306s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (113,112,111) ORDER BY position asc [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10361 LIMIT 1 [ RunTime:0.000430s ]
[ 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` = 10361 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('113','112','111') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000608s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10361 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000319s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 642 LIMIT 1 [ RunTime:0.000574s ]
[ 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` = 'cgspyhl4' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000398s ]
[ 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` = 10361 LIMIT 1 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 642 LIMIT 1 [ RunTime:0.000653s ]
[ 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.000331s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000264s ]
[ 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` = 10358 LIMIT 1 [ RunTime:0.000313s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10358 LIMIT 1 [ RunTime:0.000456s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (159,160) ORDER BY position asc [ RunTime:0.000323s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (102) ORDER BY position asc [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10358 LIMIT 1 [ RunTime:0.000463s ]
[ 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` = 10358 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('159','160') AND `stockSkuItems`.`color_id` IN ('102') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000535s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10358 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000312s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 647 LIMIT 1 [ RunTime:0.000551s ]
[ 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` = 'zhspyhl6' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000330s ]
[ 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` = 10358 LIMIT 1 [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 647 LIMIT 1 [ RunTime:0.000528s ]
[ 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.000305s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000295s ]
[ 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` = 10354 LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10354 LIMIT 1 [ RunTime:0.000455s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10354 LIMIT 1 [ RunTime:0.000487s ]
[ 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` = 10354 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000532s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10354 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 636 LIMIT 1 [ RunTime:0.000582s ]
[ 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` = 'KZ004-N' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000376s ]
[ 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` = 10354 LIMIT 1 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 636 LIMIT 1 [ RunTime:0.000528s ]
[ 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.000307s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000261s ]
[ 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` = 10352 LIMIT 1 [ RunTime:0.000303s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10352 LIMIT 1 [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10352 LIMIT 1 [ RunTime:0.000580s ]
[ 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` = 10352 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('113','112','111') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000612s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10352 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 645 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` = 'zhspyhl4' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000328s ]
[ 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` = 10352 LIMIT 1 [ RunTime:0.000320s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 645 LIMIT 1 [ RunTime:0.000537s ]
[ 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.000305s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000267s ]
[ 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` = 10348 LIMIT 1 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10348 LIMIT 1 [ RunTime:0.000441s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (30,31,32,33,34,35,36,37) ORDER BY position asc [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10348 LIMIT 1 [ RunTime:0.000473s ]
[ 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` = 10348 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('30','31','32','33','34','35','36','37') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000570s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10348 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 631 LIMIT 1 [ RunTime:0.000626s ]
[ 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` = '1000M-5210N' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.001359s ]
[ 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` = 10348 LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 631 LIMIT 1 [ RunTime:0.000549s ]
[ 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.000317s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000265s ]
[ 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` = 10344 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10344 LIMIT 1 [ RunTime:0.000430s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29) ORDER BY position asc [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10344 LIMIT 1 [ RunTime:0.000434s ]
[ 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` = 10344 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000485s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10344 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 606 LIMIT 1 [ RunTime:0.000551s ]
[ 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` = 10344 LIMIT 1 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 606 LIMIT 1 [ RunTime:0.000525s ]
[ 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.000320s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000267s ]
[ 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` = 10343 LIMIT 1 [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10343 LIMIT 1 [ RunTime:0.000443s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (102,30) ORDER BY position asc [ RunTime:0.000536s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10343 LIMIT 1 [ RunTime:0.000626s ]
[ 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` = 10343 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('102','30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000579s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10343 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 588 LIMIT 1 [ RunTime:0.000754s ]
[ 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` = 'cgspyhl3' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000496s ]
[ 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` = 10343 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 588 LIMIT 1 [ RunTime:0.000585s ]
