[ BEHAVIOR ] Run app\common\behavior\SkyWalking @app_end [ RunTime:0.000019s ]
[ DB ] CONNECT:[ UseTime:0.000374s ] mysql:host=192.168.2.210;port=3306;dbname=zwdc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `zwdc_banner` [ slave|RunTime:0.001506s ]
[ DB ] CONNECT:[ UseTime:0.000330s ] mysql:host=192.168.2.210;port=3306;dbname=zwdc;charset=utf8
[ SQL ] SELECT * FROM `zwdc_banner` WHERE `type` = 4 AND `status` = 1 AND `show_type` = 1 AND `start_time` <= '2025-06-14 00:10:33' AND `end_time` > '2025-06-14 00:10:33' ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000580s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_ad_set` [ slave|RunTime:0.001360s ]
[ SQL ] SELECT `adSetImages`.`id`,`adSetImages`.`fastdfs_id`,`adSetImages`.`title`,`adSetImages`.`url`,`adSetImages`.`position`,adSet.type type1,adSet.title title1,`adSet`.`status` FROM `zwdc_ad_set` `adSet` LEFT JOIN `zwdc_ad_set_images` `adSetImages` ON `adSet`.`id`=`adSetImages`.`ad_set_id` ORDER BY `adSetImages`.`position` DESC,`id` DESC [ slave|RunTime:0.000370s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_source_material_category` [ slave|RunTime:0.001126s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_source_material_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `position` ASC,`id` DESC LIMIT 0,21 [ slave|RunTime:0.000311s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_hot_search_words` [ slave|RunTime:0.001323s ]
[ SQL ] SELECT `name` FROM `zwdc_hot_search_words` WHERE `use_product_type` = 1 AND `status` = 1 ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000441s ]
[ SQL ] SELECT `name` FROM `zwdc_hot_search_words` WHERE `use_source` = 1 AND `status` = 1 ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000390s ]
[ SQL ] SELECT `name` FROM `zwdc_hot_search_words` WHERE `use_temp` = 1 AND `status` = 1 ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000370s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_product_type_bw_list` [ slave|RunTime:0.001200s ]
[ SQL ] SELECT `product_type_id`,`is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` IN (12496,12495,12493,12492,12488,12487,12481,12480) AND `group_id` = 0 AND `bw_type` = 1 [ slave|RunTime:0.000442s ]
[ 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` = 12496 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('32','33','34','35','36') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000473s ]
[ SQL ] SELECT `productType`.`id`,`productType`.`stock_sku`,stockSkuItems.id as sku_item_id,`stockSkuItems`.`color_id`,stockSkuItems.weight as sku_item_weight,`stockSkuItems`.`size_id`,`gradientPriceRuleRelation`.`rule_id`,`gradientPriceRule`.`is_enable` FROM `zwdc_product_type` `productType` INNER JOIN `zwdc_stock_sku_items` `stockSkuItems` ON `productType`.`stock_sku`=`stockSkuItems`.`stock_id` LEFT JOIN `zwdc_gradient_price_rule_relation` `gradientPriceRuleRelation` ON `stockSkuItems`.`id`=`gradientPriceRuleRelation`.`stock_item_id` LEFT JOIN `zwdc_gradient_price_rule` `gradientPriceRule` ON `gradientPriceRuleRelation`.`rule_id`=`gradientPriceRule`.`id` WHERE `productType`.`id` = 12495 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('32','33','34','35','36') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000713s ]
[ 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` = 12493 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000604s ]
[ 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` = 12492 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000521s ]
[ 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` = 12488 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000606s ]
[ 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` = 12487 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31') AND `stockSkuItems`.`color_id` IN ('29','30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000612s ]
[ 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` = 12481 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('248') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000516s ]
[ 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` = 12480 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('248') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000527s ]
[ SQL ] SELECT `product_type_id`,`is_source` FROM `zwdc_product_type_bw_list` WHERE `product_type_id` IN (12004,11979,12002,11909,11188,11488,11493,11481) AND `group_id` = 0 AND `bw_type` = 1 [ slave|RunTime:0.000634s ]
[ 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` = 12004 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000603s ]
[ 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` = 11979 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000596s ]
[ 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` = 12002 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000541s ]
[ 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` = 11909 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32','33','34') AND `stockSkuItems`.`color_id` IN ('29','37','30','103','31') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000808s ]
[ 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` = 11188 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000567s ]
[ 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` = 11488 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000482s ]
[ 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` = 11493 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('45','43','46','47','40') AND `stockSkuItems`.`color_id` IN ('29','30','31','32') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000716s ]
[ 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` = 11481 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30','31','32','33','34') AND `stockSkuItems`.`color_id` IN ('29','37','30','33','34','31') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000698s ]
[ SQL ] SELECT * FROM `zwdc_banner` WHERE `type` = 14 AND `status` = 1 AND `banner_type` = 1 ORDER BY `position` DESC,`id` DESC [ slave|RunTime:0.000645s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_product_type_category` [ slave|RunTime:0.001239s ]
[ SQL ] SELECT `id`,`name` FROM `zwdc_product_type_category` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `position` ASC,`id` ASC [ slave|RunTime:0.000336s ]
[ SQL ] SELECT * FROM `zwdc_source_material_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `position` ASC,`id` ASC [ slave|RunTime:0.000398s ]
[ SQL ] SELECT `galleryLabel`.* FROM `zwdc_gallery_label` `galleryLabel` WHERE `galleryLabel`.`is_del` = '-1' AND `galleryLabel`.`status` = '1' ORDER BY `position` DESC,`galleryLabel`.`id` DESC [ slave|RunTime:0.000261s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_gallery` [ slave|RunTime:0.001202s ]
[ SQL ] SELECT `id`,`code`,`group_id`,`customer_id` FROM `zwdc_gallery` WHERE `id` IN (63259350,64157156,62128838,67174291) [ slave|RunTime:0.000329s ]
[ SQL ] SELECT `id`,`code`,`group_id`,`customer_id`,`fastdfs_id` FROM `zwdc_gallery` WHERE `id` IN (60889368,64473958,60884876,62726797) [ slave|RunTime:0.000337s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_gallery_template_cfg` [ slave|RunTime:0.001155s ]
[ SQL ] SELECT `id`,`type`,`fastdfs_id`,`view_id` FROM `zwdc_gallery_template_cfg` WHERE `template_id` = 107224052 GROUP BY `view_id` ORDER BY `view_index` ASC [ slave|RunTime:0.000334s ]
[ SQL ] SELECT `id`,`type`,`fastdfs_id`,`view_id` FROM `zwdc_gallery_template_cfg` WHERE `template_id` = 89402339 GROUP BY `view_id` ORDER BY `view_index` ASC [ slave|RunTime:0.000265s ]
[ SQL ] SELECT `id`,`type`,`fastdfs_id`,`view_id` FROM `zwdc_gallery_template_cfg` WHERE `template_id` = 89330028 GROUP BY `view_id` ORDER BY `view_index` ASC [ slave|RunTime:0.007342s ]
[ SQL ] SELECT `id`,`type`,`fastdfs_id`,`view_id` FROM `zwdc_gallery_template_cfg` WHERE `template_id` = 89028378 GROUP BY `view_id` ORDER BY `view_index` ASC [ slave|RunTime:0.000343s ]
[ SQL ] SELECT * FROM `zwdc_gallery_template_cfg` WHERE `template_id` IN (63788451) AND `type` <> 0 ORDER BY `view_index` ASC [ slave|RunTime:0.006961s ]
[ SQL ] SHOW COLUMNS FROM `zwdc_gallery_check_det` [ slave|RunTime:0.001307s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (62372966) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000389s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (63684443) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000326s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (63688361) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000295s ]
[ 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` = 11415 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000512s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (7) GROUP BY `product_type_id` [ slave|RunTime:0.000353s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (3) GROUP BY `product_type_id` [ slave|RunTime:0.000297s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (2) GROUP BY `product_type_id` [ slave|RunTime:0.000294s ]
[ SQL ] SELECT `product_type_id` FROM `zwdc_product_type_level_permission` WHERE `group_level_id` IN (4) GROUP BY `product_type_id` [ slave|RunTime:0.000289s ]
[ 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` = 11867 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000527s ]
[ SQL ] SELECT * FROM `zwdc_gallery_template_cfg` WHERE `template_id` IN (64542852) AND `type` <> 0 ORDER BY `view_index` ASC [ slave|RunTime:0.005871s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (64410861) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000322s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (64410959) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000306s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (64410943) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000258s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (64410979) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000255s ]
[ 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` = 12365 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('314','244','245','246') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000411s ]
[ 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` = 12369 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000491s ]
[ SQL ] SELECT * FROM `zwdc_gallery_template_cfg` WHERE `template_id` IN (64509269) AND `type` <> 0 ORDER BY `view_index` ASC [ slave|RunTime:0.000479s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (64473950) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000437s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (64473924) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000436s ]
[ 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` = 10771 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('233','234','235') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000403s ]
[ 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` = 10804 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000376s ]
[ SQL ] SELECT * FROM `zwdc_gallery_template_cfg` WHERE `template_id` IN (62636650) AND `type` <> 0 ORDER BY `view_index` ASC [ slave|RunTime:0.005304s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (62562326) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000292s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (62562326) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000241s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (62562326) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000244s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (62562326) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000247s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (62562326) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000243s ]
[ SQL ] SELECT `id`,`type`,`check_type`,`percentage` FROM `zwdc_gallery_check_det` WHERE `gallery_id` IN (62562326) AND `check_type` <> 10 AND `percentage` >= 80 ORDER BY `percentage` DESC [ slave|RunTime:0.000238s ]
[ 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` = 11128 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('29','30') AND `stockSkuItems`.`color_id` IN ('29') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000439s ]
[ 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` = 11246 AND `stockSkuItems`.`status` = 1 AND `stockSkuItems`.`size_id` IN ('48') AND `stockSkuItems`.`color_id` IN ('30') ORDER BY `stockSkuItems`.`color_id` ASC,`stockSkuItems`.`size_id` ASC [ slave|RunTime:0.000347s ]
[ SQL ] SELECT `gallery_id`,`name` FROM `zwdc_gallery_zh_alias` WHERE `gallery_id` IN (64542852,64509269,63788451,62636650) [ slave|RunTime:0.000461s ]