[ DB ] CONNECT:[ UseTime:0.000723s ] mysql:host=192.168.2.133;port=3306;dbname=zwdcsandbox;charset=utf8
[ SQL ] SELECT * FROM `zwdc_group` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000554s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_group_level` WHERE `status` = 1 ORDER BY `annual_fee` asc,`id` asc [ RunTime:0.000377s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (3) GROUP BY `product_type_id` [ RunTime:0.000412s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_bw_list` WHERE `group_id` = 0 AND `bw_type` = 2 [ RunTime:0.000328s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (2) GROUP BY `product_type_id` [ RunTime:0.000371s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (4) GROUP BY `product_type_id` [ RunTime:0.000463s ]
[ 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.000357s ]
[ 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` = 10130 LIMIT 1 [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10130 LIMIT 1 [ RunTime:0.000547s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (131,30,38) ORDER BY position asc [ RunTime:0.000360s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29,32,34,105,31) ORDER BY position asc [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10130 [ RunTime:0.000531s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120200 LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120203 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120204 LIMIT 1 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120201 LIMIT 1 [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4735807 LIMIT 1 [ RunTime:0.000303s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120199 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120202 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120171 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120172 LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120173 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120175 LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120176 LIMIT 1 [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120177 LIMIT 1 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120179 LIMIT 1 [ RunTime:0.000276s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120178 LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120180 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120181 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120182 LIMIT 1 [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120183 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120184 LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120185 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120186 LIMIT 1 [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120187 LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120188 LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120189 LIMIT 1 [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120190 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120191 LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120192 LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120193 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120194 LIMIT 1 [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120195 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120196 LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120197 LIMIT 1 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120198 LIMIT 1 [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120230 LIMIT 1 [ RunTime:0.000281s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120231 LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120232 LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4735806 LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4735808 LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10130 [ RunTime:0.000545s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 96871 LIMIT 1 [ RunTime:0.000335s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120206 LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120207 LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120208 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120209 LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120210 LIMIT 1 [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120228 LIMIT 1 [ RunTime:0.000319s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120229 LIMIT 1 [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120234 LIMIT 1 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 120235 LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4735809 LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4735810 LIMIT 1 [ RunTime:0.000318s ]
[ DB ] CONNECT:[ UseTime:0.000886s ] mysql:host=192.168.2.81;port=3306;dbname=zwdc_product;charset=utf8
[ SQL ] SHOW COLUMNS FROM `zwdc_product` [ RunTime:0.001066s ]
[ SQL ] SELECT * FROM `zwdc_product` WHERE `id` = 1028097 LIMIT 1 [ RunTime:0.000723s ]
[ 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` = 10130 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000581s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10130 LIMIT 1 [ RunTime:0.000457s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10130 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` = 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.000683s ]
[ 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.000369s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 353 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` = 'SKU08312' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000397s ]
[ 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.000328s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 353 LIMIT 1 [ RunTime:0.000555s ]
[ 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.000339s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000270s ]
[ 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.000309s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10132 LIMIT 1 [ RunTime:0.000450s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30,38) ORDER BY position asc [ RunTime:0.000312s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29,31,30) ORDER BY position asc [ RunTime:0.000315s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10132 LIMIT 1 [ RunTime:0.000444s ]
[ 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.000533s ]
[ 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.000333s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 357 LIMIT 1 [ RunTime:0.000569s ]
[ 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.000310s ]
[ 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.000309s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 357 LIMIT 1 [ RunTime:0.000556s ]
[ 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.000318s ]
[ 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` = 10286 LIMIT 1 [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10286 LIMIT 1 [ RunTime:0.000486s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30,31,32,38,33) ORDER BY position asc [ RunTime:0.000333s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (34,31) ORDER BY position asc [ RunTime:0.000311s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10286 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728042 LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 124866 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728047 LIMIT 1 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728181 LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728183 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728184 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728043 LIMIT 1 [ RunTime:0.000258s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728044 LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728045 LIMIT 1 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728046 LIMIT 1 [ RunTime:0.000261s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728182 LIMIT 1 [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728185 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4728186 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10286 [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727685 LIMIT 1 [ RunTime:0.000314s ]
[ 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` = 10286 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000569s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` = 34 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,34) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000537s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,34) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,34) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,34) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000455s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,34) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000406s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,34) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` = 31 LIMIT 1 [ RunTime:0.000352s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000340s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10286 AND `view_id` = 1 AND `position` = 3 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10286 LIMIT 1 [ RunTime:0.000475s ]
[ 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` = 10286 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32','38','33') AND `stockSkuItems`.`color_id` IN ('34','31') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000628s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10286 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 552 LIMIT 1 [ RunTime:0.000550s ]
[ 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` = 't-a111' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000322s ]
[ 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` = 10286 LIMIT 1 [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 552 LIMIT 1 [ RunTime:0.000521s ]
[ 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.000309s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000268s ]
[ 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` = 10368 LIMIT 1 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10368 LIMIT 1 [ RunTime:0.000421s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (158) ORDER BY position asc [ RunTime:0.000268s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (102) ORDER BY position asc [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10368 LIMIT 1 [ RunTime:0.000423s ]
[ 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` = 10368 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('158') AND `stockSkuItems`.`color_id` IN ('102') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000429s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10368 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 656 LIMIT 1 [ RunTime:0.000529s ]
[ 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` = 'Two' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000327s ]
[ 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` = 10368 LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 656 LIMIT 1 [ RunTime:0.000517s ]
[ 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.000315s ]
[ 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` = 10346 LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10346 LIMIT 1 [ RunTime:0.000446s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10346 [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4732847 LIMIT 1 [ RunTime:0.000281s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4732848 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4732849 LIMIT 1 [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4732850 LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4732851 LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10346 [ RunTime:0.000312s ]
[ 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` = 10346 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000631s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` = 102 LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000376s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000372s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000379s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000389s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10346 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,102) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10346 LIMIT 1 [ RunTime:0.000511s ]
[ 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` = 10346 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('158') AND `stockSkuItems`.`color_id` IN ('102') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000586s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10346 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 637 LIMIT 1 [ RunTime:0.000660s ]
[ 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` = 'Duom' 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` = 10346 LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 637 LIMIT 1 [ RunTime:0.000636s ]
[ 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.000363s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000309s ]
[ 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.000344s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10344 LIMIT 1 [ RunTime:0.000532s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29) ORDER BY position asc [ RunTime:0.000326s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (30) ORDER BY position asc [ RunTime:0.000362s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10344 LIMIT 1 [ RunTime:0.000507s ]
[ 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.000626s ]
[ 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.000374s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 606 LIMIT 1 [ RunTime:0.000633s ]
[ 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.000360s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 606 LIMIT 1 [ RunTime:0.000607s ]
[ 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.000310s ]
[ 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` = 10342 LIMIT 1 [ RunTime:0.000352s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10342 LIMIT 1 [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10342 LIMIT 1 [ RunTime:0.000491s ]
[ 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` = 10342 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.000540s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10342 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000468s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 605 LIMIT 1 [ RunTime:0.000605s ]
[ 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` = 10342 LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 605 LIMIT 1 [ RunTime:0.000558s ]
[ 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.000345s ]
[ 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` = 10338 LIMIT 1 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10338 LIMIT 1 [ RunTime:0.000461s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (30,48) ORDER BY position asc [ RunTime:0.000334s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (29) ORDER BY position asc [ RunTime:0.000305s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10338 LIMIT 1 [ RunTime:0.000472s ]
[ 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` = 10338 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('30','48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000576s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10338 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 601 LIMIT 1 [ RunTime:0.000554s ]
[ 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` = 'ZH-kouzao-1003' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000338s ]
[ 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` = 10338 LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 601 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.000319s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000274s ]
[ 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` = 10334 LIMIT 1 [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10334 LIMIT 1 [ RunTime:0.000425s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30,31) ORDER BY position asc [ RunTime:0.000312s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (31,29,30) ORDER BY position asc [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10334 [ RunTime:0.000331s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4732373 LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10334 [ RunTime:0.000311s ]
[ 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` = 10334 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000572s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` = 31 LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000386s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` = 29 LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` = 30 LIMIT 1 [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000370s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000357s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10334 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10334 LIMIT 1 [ RunTime:0.000448s ]
[ 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` = 10334 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('31','29','30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000624s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10334 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000331s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 591 LIMIT 1 [ RunTime:0.000553s ]
[ 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` = 10334 LIMIT 1 [ RunTime:0.000341s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 591 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.000317s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000287s ]
[ 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` = 10333 LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10333 LIMIT 1 [ RunTime:0.000453s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10333 [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4732359 LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10333 [ RunTime:0.000307s ]
[ 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` = 10333 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000490s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10333 AND `view_id` = 1 AND `position` = 2 AND `color_id` = 29 LIMIT 1 [ RunTime:0.000355s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10333 AND `view_id` = 1 AND `position` = 2 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10333 AND `view_id` = 1 AND `position` = 2 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10333 AND `view_id` = 1 AND `position` = 2 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10333 LIMIT 1 [ RunTime:0.000447s ]
[ 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` = 10333 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000452s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10333 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 590 LIMIT 1 [ RunTime:0.000569s ]
[ 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` = 10333 LIMIT 1 [ RunTime:0.000318s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 590 LIMIT 1 [ RunTime:0.000538s ]
[ 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.000325s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10209) [ RunTime:0.000310s ]
[ 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` = 10331 LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10331 LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10331 LIMIT 1 [ RunTime:0.000494s ]
[ 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` = 10331 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('31','29','30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000722s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10331 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000425s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 589 LIMIT 1 [ RunTime:0.000717s ]
[ 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` = 10331 LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 589 LIMIT 1 [ RunTime:0.000634s ]
[ 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.000441s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000299s ]
[ 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` = 10313 LIMIT 1 [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10313 LIMIT 1 [ RunTime:0.000474s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (33,31,29,30) ORDER BY position asc [ RunTime:0.002179s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 [ RunTime:0.000418s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727237 LIMIT 1 [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4726974 LIMIT 1 [ RunTime:0.000318s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727241 LIMIT 1 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4726976 LIMIT 1 [ RunTime:0.000310s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727242 LIMIT 1 [ RunTime:0.000298s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727244 LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727236 LIMIT 1 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727238 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727239 LIMIT 1 [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727240 LIMIT 1 [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727243 LIMIT 1 [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727245 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 4727944 LIMIT 1 [ RunTime:0.000290s ]
[ 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` = 10313 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000633s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 1 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 1 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000376s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 2 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` = 10313 AND `view_id` = 2 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 3 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000431s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 3 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000363s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 2 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 2 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 3 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 3 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000357s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 2 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 2 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 3 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000376s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 3 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000379s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 2 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000474s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 2 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10313 AND `view_id` = 3 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000457s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10313 AND `view_id` = 3 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000400s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10313 LIMIT 1 [ RunTime:0.000500s ]
[ 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` = 10313 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29') AND `stockSkuItems`.`color_id` IN ('33','31','29','30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000736s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10313 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000372s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000603s ]
[ 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` = '1500W-VE' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000362s ]
[ 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` = 10313 LIMIT 1 [ RunTime:0.000534s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000563s ]
[ 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.000343s ]
[ 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` = 10306 LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10306 LIMIT 1 [ RunTime:0.000442s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (32,30,33) ORDER BY position asc [ RunTime:0.000338s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10306 LIMIT 1 [ RunTime:0.000440s ]
[ 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` = 10306 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32','38','33') AND `stockSkuItems`.`color_id` IN ('32','30','33') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000806s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10306 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000474s ]
[ 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` = 10306 LIMIT 1 [ RunTime:0.000352s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 552 LIMIT 1 [ RunTime:0.000636s ]
[ 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.000383s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000367s ]
[ 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` = 10213 LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10213 LIMIT 1 [ RunTime:0.000431s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,31) ORDER BY position asc [ RunTime:0.000340s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (107,106) ORDER BY position asc [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10213 [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 100179 LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 100180 LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10213 [ RunTime:0.000278s ]
[ 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` = 10213 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000513s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10213 AND `view_id` = 1 AND `position` = 1 AND `color_id` = 107 LIMIT 1 [ RunTime:0.000337s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10213 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,107) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000365s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10213 AND `view_id` = 1 AND `position` = 1 AND `color_id` = 106 LIMIT 1 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10213 AND `view_id` = 1 AND `position` = 1 AND `color_id` IN (0,106) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000341s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10213 LIMIT 1 [ RunTime:0.000431s ]
[ 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` = 10213 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','31') AND `stockSkuItems`.`color_id` IN ('107','106') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000518s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10213 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 459 LIMIT 1 [ RunTime:0.000602s ]
[ 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` = 'zmcsa' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000325s ]
[ 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` = 10213 LIMIT 1 [ RunTime:0.000325s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 459 LIMIT 1 [ RunTime:0.000567s ]
[ 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.000262s ]
[ 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.000298s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10207 LIMIT 1 [ RunTime:0.000428s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (45) ORDER BY position asc [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10207 [ RunTime:0.000315s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 95290 LIMIT 1 [ RunTime:0.000302s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10207 [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 95291 LIMIT 1 [ RunTime:0.000292s ]
[ 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.000479s ]
[ 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.000369s ]
[ 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.000376s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10207 LIMIT 1 [ RunTime:0.000469s ]
[ 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.000503s ]
[ 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.000356s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 452 LIMIT 1 [ RunTime:0.000586s ]
[ 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.000327s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 452 LIMIT 1 [ RunTime:0.000559s ]
[ 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.000354s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000310s ]
[ 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` = 10188 LIMIT 1 [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10188 LIMIT 1 [ RunTime:0.000441s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,31,30,38) ORDER BY position asc [ RunTime:0.000357s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (37,33) ORDER BY position asc [ RunTime:0.000331s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10188 [ RunTime:0.000416s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90812 LIMIT 1 [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90813 LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90814 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90815 LIMIT 1 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90816 LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90817 LIMIT 1 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93462 LIMIT 1 [ RunTime:0.000281s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93463 LIMIT 1 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93464 LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93465 LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10188 [ RunTime:0.000309s ]
[ 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` = 10188 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000725s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` = 37 LIMIT 1 [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000355s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000341s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000363s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000355s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000386s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000394s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000352s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` = 33 LIMIT 1 [ RunTime:0.000375s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000341s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000338s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000338s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000355s ]
[ SQL ] SELECT * FROM `zwdc_product_type_detail_texture_image` WHERE `product_type_id` = 10188 AND `view_id` = 1 AND `position` = 7 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000334s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10188 LIMIT 1 [ RunTime:0.000518s ]
[ 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` = 10188 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','31','30','38') AND `stockSkuItems`.`color_id` IN ('37','33') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000643s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10188 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 383 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` = '0307001' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000352s ]
[ 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` = 10188 LIMIT 1 [ RunTime:0.000331s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 383 LIMIT 1 [ RunTime:0.000554s ]
[ 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.000392s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000366s ]
[ 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` = 10187 LIMIT 1 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10187 LIMIT 1 [ RunTime:0.000442s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (33,30) ORDER BY position asc [ RunTime:0.000357s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10187 [ RunTime:0.000379s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90742 LIMIT 1 [ RunTime:0.000315s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90745 LIMIT 1 [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90746 LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90748 LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90750 LIMIT 1 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90751 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90754 LIMIT 1 [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90756 LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90757 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90759 LIMIT 1 [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90760 LIMIT 1 [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93433 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93434 LIMIT 1 [ RunTime:0.000407s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93435 LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93439 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10187 [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90743 LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90744 LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90747 LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90749 LIMIT 1 [ RunTime:0.000281s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90752 LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90753 LIMIT 1 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90755 LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 90758 LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93436 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93437 LIMIT 1 [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93438 LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 93440 LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] SELECT * FROM `zwdc_product` WHERE `id` = 1027608 LIMIT 1 [ RunTime:0.000927s ]
[ 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` = 10187 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000826s ]
[ SQL ] SELECT `id` FROM `zwdc_product_type_detail_print_area` WHERE `product_type_id` = 10187 AND `position` = 5 AND `type` = 2 LIMIT 1 [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10187 LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SELECT `id` FROM `zwdc_product_type_detail_print_area` WHERE `product_type_id` = 10187 AND `position` = 4 AND `type` = 2 LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10187 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` = 10187 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','31','30','38') AND `stockSkuItems`.`color_id` IN ('33','30') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000780s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10187 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000465s ]
[ 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` = 10187 LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 383 LIMIT 1 [ RunTime:0.000739s ]
[ 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.000432s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000335s ]
[ 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` = 10162 LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10162 LIMIT 1 [ RunTime:0.000491s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (131) ORDER BY position asc [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10162 [ RunTime:0.000413s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 86702 LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10162 [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `zwdc_product` WHERE `id` = 582009 LIMIT 1 [ RunTime:0.000703s ]
[ 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` = 10162 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000616s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10162 LIMIT 1 [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10162 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` = 10162 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('131') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000567s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10162 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000376s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 407 LIMIT 1 [ RunTime:0.000609s ]
[ 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` = '01001' 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` = 10162 LIMIT 1 [ RunTime:0.000425s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 407 LIMIT 1 [ RunTime:0.000609s ]
[ 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.000382s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10209) [ RunTime:0.000349s ]
[ 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` = 10151 LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10151 LIMIT 1 [ RunTime:0.000464s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_stock_size` WHERE `id` IN (29,30,31,38) ORDER BY position asc [ RunTime:0.000385s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (30,29) ORDER BY position asc [ RunTime:0.000341s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10151 [ RunTime:0.000383s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 84546 LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 84547 LIMIT 1 [ RunTime:0.000337s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 88423 LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 88424 LIMIT 1 [ RunTime:0.000312s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10151 [ RunTime:0.000346s ]
[ 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` = 10151 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000694s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10151 AND `view_id` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10151 AND `view_id` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000390s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10151 AND `view_id` = 2 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000394s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10151 AND `view_id` = 2 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10151 AND `view_id` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000430s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10151 AND `view_id` = 1 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10151 AND `view_id` = 2 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10151 AND `view_id` = 2 AND `color_id` IN (0,29) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000351s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10151 LIMIT 1 [ RunTime:0.000514s ]
[ 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` = 10151 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','38') AND `stockSkuItems`.`color_id` IN ('30','29') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000765s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10151 AND `group_id` = 0 AND `bw_type` = 1 LIMIT 1 [ RunTime:0.000562s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000627s ]
[ 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` = '0307002' AND `stockSku`.`status` = 1 AND `skuAuthGroup`.`group_id` = 0 ORDER BY stockSku.id asc LIMIT 1 [ RunTime:0.000361s ]
[ 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` = 10151 LIMIT 1 [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 393 LIMIT 1 [ RunTime:0.000590s ]
[ 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.000374s ]
[ SQL ] SELECT `code` FROM `zwdc_customer` WHERE `id` IN (10120) [ RunTime:0.000306s ]
[ 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` = 10147 LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10147 LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SELECT `id`,`name`,`en_name` FROM `zwdc_stock_color` WHERE `id` IN (37,31,30,33) ORDER BY position asc [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 [ RunTime:0.000368s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 84247 LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 84248 LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 84249 LIMIT 1 [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 84250 LIMIT 1 [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 88475 LIMIT 1 [ RunTime:0.000366s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 88476 LIMIT 1 [ RunTime:0.000357s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 88477 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `zwdc_fastdfs_image` WHERE `id` = 88478 LIMIT 1 [ RunTime:0.000290s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 [ RunTime:0.000383s ]
[ 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` = 10147 AND `detailPrintArea`.`distortParams` <> '' GROUP BY detailImage.position,detailImage.color_id [ RunTime:0.000608s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 AND `view_id` = 1 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 AND `view_id` = 1 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 AND `view_id` = 2 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000394s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 AND `view_id` = 2 AND `color_id` IN (0,37) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000530s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 AND `view_id` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000515s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 AND `view_id` = 1 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000490s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 AND `view_id` = 2 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 AND `view_id` = 2 AND `color_id` IN (0,31) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000419s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 AND `view_id` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000517s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 AND `view_id` = 1 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000466s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 AND `view_id` = 2 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000424s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 AND `view_id` = 2 AND `color_id` IN (0,30) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000363s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 AND `view_id` = 1 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000434s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 AND `view_id` = 1 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000378s ]
[ SQL ] SELECT * FROM `zwdc_product_type_bottom_template` WHERE `product_id` = 10147 AND `view_id` = 2 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000390s ]
[ SQL ] SELECT * FROM `zwdc_product_type_texture` WHERE `product_id` = 10147 AND `view_id` = 2 AND `color_id` IN (0,33) ORDER BY color_id desc LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `zwdc_product_type` WHERE `id` = 10147 LIMIT 1 [ RunTime:0.000497s ]
[ 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` = 10147 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','31','30','38') AND `stockSkuItems`.`color_id` IN ('37','31','30','33') ORDER BY `stockSkuItems`.`color_id` asc,`stockSkuItems`.`size_id` asc [ RunTime:0.000733s ]
[ SQL ] SELECT `is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` = 10147 AND `group_id` = 0 AND `bw_type` = 1 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` = 10147 LIMIT 1 [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `zwdc_stock_sku` WHERE `id` = 383 LIMIT 1 [ RunTime:0.000607s ]
