修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决日期，旧值为 ""，新值为 "2022-12-26 20:21:19"。
修改了 指派给 ，旧值为 "jialipeng"，新值为 "yanfeng"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "jialipeng"。

修改了 指派给 ，旧值为 "yanfeng"，新值为 "jialipeng"。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "active"。
修改了 激活日期，旧值为 ""，新值为 "2022-12-27 19:45:45"。
修改了 激活次数，旧值为 "0"，新值为 "1"。
修改了 解决方案，旧值为 "code"，新值为 ""。
修改了 解决日期，旧值为 "2022-12-26 20:21:19"，新值为 "0000-00-00"。
修改了 解决者 ，旧值为 "jialipeng"，新值为 ""。
修改了 关闭日期，旧值为 ""，新值为 "0000-00-00"。

修改了 重现步骤，区别为：

008- SELECT rp.id, rp.customer_id AS customerId, rp.sku AS sku, rp.is_group 组合产品, rp.is_main_group_sku 产品类型, rp.product_state 产品状态, rp.product_property 产品侵权风险, rp.brand_id 品牌, rp.with_battery 物流属性, rp.pack_weight 包裹重, rp.gross_weight 产品重, (SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) AS 可用库存,-- IF(rp.pack_length=0,rp.length,rp.pack_length) AS 长,-- IF(rp.pack_width=0,rp.width,rp.pack_width) AS 宽,-- IF(rp.pack_height=0,rp.height,rp.pack_height) AS 高,-- IF(rp.pack_width=0,rp.length+rp.width+rp.height,rp.pack_length+rp.pack_width+rp.pack_height) AS 三边之和,-- IF(rp.pack_weight=0,rp.gross_weight,rp.pack_weight) AS 包裹重,-- IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000) AS 体积重-- IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000)/IF(rp.pack_weight=0,rp.gross_weight,rp.pack_weight)*1000 AS 抛率 rp.plug_relate_type 强电插头选项FROM`zhcxkj-center-product`.rb_product rpJOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_idAND rpa.sku = rp.skuAND rpa.check_status = 1WHERErp.customer_id = 1AND rp.class_id IN ( 4711 ) -- erp分类AND rp.is_group=0 -- 是否组合产品AND rp.is_main_group_sku=1 -- 是否多变体AND rp.product_state=0 -- 产品状态AND rp.product_property=1 -- 侵权风险AND ((SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) BETWEEN 0 AND 2 OR (SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) IS NULL)-- AND rp.with_battery =12 -- 产品物流属性-- AND rp.brand_id !=0 -- 品牌产品-- AND IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000) BETWEEN 0.07 AND 0.08-- AND IF(rp.pack_width=0,rp.length+rp.width+rp.height,rp.pack_length+rp.pack_width+rp.pack_height) BETWEEN 26 AND 26-- AND rp.plug_relate_type not in (0,1,2,3,4,5)-- AND (((rp.length BETWEEN 1 AND 10 ) AND (rp.width BETWEEN 1 AND 10 ) AND (rp.height BETWEEN 1 AND 10 )) OR((rp.pack_length BETWEEN 1 AND 10)AND (rp.pack_width BETWEEN 1 AND 10) AND (rp.pack_height BETWEEN 1 AND 10)))-- AND (((rp.pack_length + rp.pack_width + rp.pack_height) BETWEEN 1 AND 10) OR ((rp.length+rp.width+rp.height) BETWEEN 1 AND 10 ))ORDER BY rp.add_time DESC
008+ SELECT rp.id, rp.customer_id AS customerId, rp.sku AS sku, rp.is_group 组合产品, rp.is_main_group_sku 产品类型, rp.product_state 产品状态, rp.product_property 产品侵权风险, rp.brand_id 品牌, rp.with_battery 物流属性, rp.pack_weight 包裹重, rp.gross_weight 产品重, (SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) AS 可用库存,-- IF(rp.pack_length=0,rp.length,rp.pack_length) AS 长,-- IF(rp.pack_width=0,rp.width,rp.pack_width) AS 宽,-- IF(rp.pack_height=0,rp.height,rp.pack_height) AS 高,-- IF(rp.pack_width=0,rp.length+rp.width+rp.height,rp.pack_length+rp.pack_width+rp.pack_height) AS 三边之和,-- IF(rp.pack_weight=0,rp.gross_weight,rp.pack_weight) AS 包裹重,-- IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000) AS 体积重-- IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000)/IF(rp.pack_weight=0,rp.gross_weight,rp.pack_weight)*1000 AS 抛率 rp.plug_relate_type 强电插头选项FROM`zhcxkj-center-product`.rb_product rpJOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_idAND rpa.sku = rp.skuAND rpa.check_status = 1WHERErp.customer_id = 1AND rp.class_id IN ( 4711 ) -- erp分类AND rp.is_group=0 -- 是否组合产品AND rp.is_main_group_sku=1 -- 是否多变体AND rp.product_state=0 -- 产品状态AND rp.product_property=1 -- 侵权风险AND ((SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) BETWEEN 0 AND 2 OR (SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) IS NULL)-- AND rp.with_battery =12 -- 产品物流属性-- AND rp.brand_id !=0 -- 品牌产品-- AND IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000) BETWEEN 0.07 AND 0.08-- AND IF(rp.pack_width=0,rp.length+rp.width+rp.height,rp.pack_length+rp.pack_width+rp.pack_height) BETWEEN 26 AND 26-- AND rp.plug_relate_type not in (0,1,2,3,4,5)-- AND (((rp.length BETWEEN 1 AND 10 ) AND (rp.width BETWEEN 1 AND 10 ) AND (rp.height BETWEEN 1 AND 10 )) OR((rp.pack_length BETWEEN 1 AND 10)AND (rp.pack_width BETWEEN 1 AND 10) AND (rp.pack_height BETWEEN 1 AND 10)))-- AND (((rp.pack_length + rp.pack_width + rp.pack_height) BETWEEN 1 AND 10) OR ((rp.length+rp.width+rp.height) BETWEEN 1 AND 10 ))ORDER BY rp.add_time DESC

008- <p>SELECT<br /><span> </span>rp.id,<br /><span> </span>rp.customer_id AS customerId,<br /><span> </span>rp.sku AS sku,<br /><span> </span>rp.is_group 组合产品,<br /><span> </span>rp.is_main_group_sku 产品类型,<br /><span> </span>rp.product_state 产品状态,<br /><span> </span>rp.product_property 产品侵权风险,<br /><span> </span>rp.brand_id 品牌,<br /><span> </span>rp.with_battery 物流属性,<br /><span> </span>rp.pack_weight 包裹重,<br /><span> </span>rp.gross_weight 产品重,<br /><span> </span>(SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) AS 可用库存,<br />-- <span> </span>IF(rp.pack_length=0,rp.length,rp.pack_length) AS 长,<br />-- <span> </span>IF(rp.pack_width=0,rp.width,rp.pack_width) AS 宽,<br />-- <span> </span>IF(rp.pack_height=0,rp.height,rp.pack_height) AS 高,<br />-- <span> </span>IF(rp.pack_width=0,rp.length+rp.width+rp.height,rp.pack_length+rp.pack_width+rp.pack_height) AS 三边之和,<br />-- <span> </span>IF(rp.pack_weight=0,rp.gross_weight,rp.pack_weight) AS 包裹重,<br />-- <span> </span>IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000) AS 体积重<br />-- <span> </span>IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000)/IF(rp.pack_weight=0,rp.gross_weight,rp.pack_weight)*1000 AS 抛率<br /><span> </span>rp.plug_relate_type 强电插头选项<br />FROM<br />`zhcxkj-center-product`.rb_product rp<br />JOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_id<br />AND rpa.sku = rp.sku<br />AND rpa.check_status = 1<br />WHERE<br />rp.customer_id = 1<br />AND rp.class_id IN ( 4711 ) -- erp分类<br />AND rp.is_group=0 -- 是否组合产品<br />AND rp.is_main_group_sku=1 -- 是否多变体<br />AND rp.product_state=0 -- 产品状态<br />AND rp.product_property=1 -- 侵权风险<br />AND ((SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) BETWEEN 0 AND 2<br /><span> </span>OR (SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) IS NULL)<br />-- AND rp.with_battery =12 -- 产品物流属性<br />-- AND rp.brand_id !=0 -- 品牌产品<br />-- AND IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000) BETWEEN 0.07 AND 0.08<br />-- AND IF(rp.pack_width=0,rp.length+rp.width+rp.height,rp.pack_length+rp.pack_width+rp.pack_height) BETWEEN 26 AND 26<br />-- AND rp.plug_relate_type not in (0,1,2,3,4,5)<br />-- AND (((rp.length BETWEEN 1 AND 10 ) AND (rp.width BETWEEN 1 AND 10 ) AND (rp.height BETWEEN 1 AND 10 )) OR((rp.pack_length BETWEEN 1 AND 10)AND (rp.pack_width BETWEEN 1 AND 10) AND (rp.pack_height BETWEEN 1 AND 10)))<br />-- AND (((rp.pack_length + rp.pack_width + rp.pack_height) BETWEEN 1 AND 10) OR ((rp.length+rp.width+rp.height) BETWEEN 1 AND 10 ))<br />ORDER BY rp.add_time DESC<br /></p>
008+ <p>SELECT<br /><span> </span>rp.id,<br /><span> </span>rp.customer_id AS customerId,<br /><span> </span>rp.sku AS sku,<br /><span> </span>rp.is_group 组合产品,<br /><span> </span>rp.is_main_group_sku 产品类型,<br /><span> </span>rp.product_state 产品状态,<br /><span> </span>rp.product_property 产品侵权风险,<br /><span> </span>rp.brand_id 品牌,<br /><span> </span>rp.with_battery 物流属性,<br /><span> </span>rp.pack_weight 包裹重,<br /><span> </span>rp.gross_weight 产品重,<br /><span> </span>(SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) AS 可用库存,<br />-- <span> </span>IF(rp.pack_length=0,rp.length,rp.pack_length) AS 长,<br />-- <span> </span>IF(rp.pack_width=0,rp.width,rp.pack_width) AS 宽,<br />-- <span> </span>IF(rp.pack_height=0,rp.height,rp.pack_height) AS 高,<br />-- <span> </span>IF(rp.pack_width=0,rp.length+rp.width+rp.height,rp.pack_length+rp.pack_width+rp.pack_height) AS 三边之和,<br />-- <span> </span>IF(rp.pack_weight=0,rp.gross_weight,rp.pack_weight) AS 包裹重,<br />-- <span> </span>IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000) AS 体积重<br />-- <span> </span>IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000)/IF(rp.pack_weight=0,rp.gross_weight,rp.pack_weight)*1000 AS 抛率<br /><span> </span>rp.plug_relate_type 强电插头选项<br />FROM<br />`zhcxkj-center-product`.rb_product rp<br />JOIN `zhcxkj-center-product`.rb_product_admin rpa ON rpa.customer_id = rp.customer_id<br />AND rpa.sku = rp.sku<br />AND rpa.check_status = 1<br />WHERE<br />rp.customer_id = 1<br />AND rp.class_id IN ( 4711 ) -- erp分类<br />AND rp.is_group=0 -- 是否组合产品<br />AND rp.is_main_group_sku=1 -- 是否多变体<br />AND rp.product_state=0 -- 产品状态<br />AND rp.product_property=1 -- 侵权风险<br />AND ((SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) BETWEEN 0 AND 2<br /><span> </span>OR (SELECT SUM(good_num )FROM `zhcxkj-center-warehouse`.dynamic_inventory a WHERE a.customer_id=rp.customer_id AND a.sku=rp.sku) IS NULL)<br />-- AND rp.with_battery =12 -- 产品物流属性<br />-- AND rp.brand_id !=0 -- 品牌产品<br />-- AND IF(rp.pack_length=0,(rp.length * rp.width * rp.height)/6000,(rp.pack_length * rp.pack_width * rp.pack_height)/6000) BETWEEN 0.07 AND 0.08<br />-- AND IF(rp.pack_width=0,rp.length+rp.width+rp.height,rp.pack_length+rp.pack_width+rp.pack_height) BETWEEN 26 AND 26<br />-- AND rp.plug_relate_type not in (0,1,2,3,4,5)<br />-- AND (((rp.length BETWEEN 1 AND 10 ) AND (rp.width BETWEEN 1 AND 10 ) AND (rp.height BETWEEN 1 AND 10 )) OR((rp.pack_length BETWEEN 1 AND 10)AND (rp.pack_width BETWEEN 1 AND 10) AND (rp.pack_height BETWEEN 1 AND 10)))<br />-- AND (((rp.pack_length + rp.pack_width + rp.pack_height) BETWEEN 1 AND 10) OR ((rp.length+rp.width+rp.height) BETWEEN 1 AND 10 ))<br />ORDER BY rp.add_time DESC</p>

修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决日期，旧值为 ""，新值为 "2022-12-29 15:34:52"。
修改了 指派给 ，旧值为 "jialipeng"，新值为 "yanfeng"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 解决者 ，旧值为 ""，新值为 "jialipeng"。

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "yanfeng"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "yanfeng"。
修改了 关闭日期，旧值为 ""，新值为 "2022-12-30 18:15:40"。

修改了 所属模块，旧值为 "1808"，新值为 "1876"。