BUG #63112 性能优化-micro-orderstrategy-domqmessage 项目大量查询更新的字段类型和数据库不一致 - 技术中心-需求池

重现步骤

[步骤]

(@p1 decimal(8,7),@p2 bit,@p3 decimal(6,4),@p4 decimal(6,4),@p5 nvarchar(2),@p6 nvarchar(32),@p7 nvarchar(32),@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 datetime,@p13 datetime,@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(31),@p19 nvarchar(223),@p20 nvarchar(4000),@p21 int,

@p22 nvarchar(21)) UPDATE [RB_OrderInfo] SET [ExchangeRMB] = @p1, [IsPay] = @p2, [TotalPrice] = @p3, [ProductTotalPrice] = @p4, [Province] = @p5, [City] = @p6, [PostCode] = @p7, [ShipTime] = @p8, [UpdatePlatformTime] = @p9, [DownLoadUpdateTime] = @p10, [UpdateTime] = @p11, [DispatchUpdatePlatformTime] = @p12, [LastCDKTime] = @p13, [FBA_CarrierName] = @p14, [IsHadEmail] = @p15, [IsASingleInTheEnd] = @p16, [FBA_TransportName] = @p17, [PromotionType] = @p18, [AddressHash] = @p19, [IsHadBlueTag] = @p20 WHERE (([CustomerID] = @p21) AND ([OrderCode] = @p22))

(@p1 decimal(8,7),@p2 bit,@p3 nvarchar(7),@p4 nvarchar(32),@p5 nvarchar(32),@p6 datetime,@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 nvarchar(4000),@p13 nvarchar(4000),@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar

第二条
(234),@p17 nvarchar(4000),@p18 int,@p19 nvarchar(21))UPDATE [RB_OrderInfo] SET [ExchangeRMB] = @p1, [IsPay] = @p2, [Province] = @p3, [City] = @p4, [PostCode] = @p5, [ShipTime] = @p6, [UpdatePlatformTime] = @p7, [DownLoadUpdateTime] = @p8, [UpdateTime] = @p9, [DispatchUpdatePlatformTime] = @p10, [LastCDKTime] = @p11, [FBA_CarrierName] = @p12, [IsHadEmail] = @p13, [IsASingleInTheEnd] = @p14, [FBA_TransportName] = @p15, [AddressHash] = @p16, [IsHadBlueTag] = @p17 WHERE (([CustomerID] = @p18) AND ([OrderCode] = @p19))

第三条

(@p1 bit,@p2 decimal(6,4),@p3 decimal(6,4),@p4 nvarchar(2),@p5 nvarchar(32),@p6 nvarchar(32),@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 datetime,@p13 decimal(6,4),@p14 nvarchar(4000),@p15 datetime,@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(4000),@p19 nvarchar(31),@p20 nvarchar(232),@p21 nvarchar(4000),@p22 int,@p23 nvarchar(21))

UPDATE [RB_OrderInfo] SET [IsPay] = @p1, [TotalPrice] = @p2, [ProductTotalPrice] = @p3, [Province] = @p4, [City] = @p5, [PostCode] = @p6, [ShipTime] = @p7, [UpdatePlatformTime] = @p8, [DownLoadUpdateTime] = @p9, [UpdateTime] = @p10, [DispatchUpdatePlatformTime] = @p11, [LastCDKTime] = @p12, [PromotionDiscountAmount] = @p13, [FBA_CarrierName] = @p14, [LatestShipDate] = @p15, [IsHadEmail] = @p16, [IsASingleInTheEnd] = @p17, [FBA_TransportName] = @p18, [PromotionType] = @p19, [AddressHash] = @p20, [IsHadBlueTag] = @p21 WHERE (([CustomerID] = @p22) AND ([OrderCode] = @p23))

第四条

(@p1 nvarchar(14),@p2 decimal(8,7),@p3 decimal(21,20),@p4 bit,@p5 decimal(6,4),@p6 decimal(6,4),@p7 nvarchar(96),@p8 nvarchar(32),@p9 nvarchar(6),@p10 nvarchar(32),@p11 nvarchar(96),@p12 nvarchar(32),@p13 datetime,@p14 datetime,@p15 datetime,@p16 datetime,@p17 datetime,@p18 datetime,@p19 nvarchar(96),@p20 nvarchar(4000),@p21 nvarchar(4000),@p22 nvarchar(4000),@p23 nvarchar(4000),@p24 nvarchar(234),@p25 nvarchar(4000),@p26 int,@p27 nvarchar(21))UPDATE [RB_OrderInfo] SET [PayerId] = @p1, [ExchangeRMB] = @p2, [ExchangeUSD] = @p3, [IsPay] = @p4, [TotalPrice] = @p5, [ProductTotalPrice] = @p6, [FirstName] = @p7, [LastName] = @p8, [Province] = @p9, [City] = @p10, [Address] = @p11, [PostCode] = @p12, [ShipTime] = @p13, [UpdatePlatformTime] = @p14, [DownLoadUpdateTime] = @p15, [UpdateTime] = @p16, [DispatchUpdatePlatformTime] = @p17, [LastCDKTime] = @p18, [Address1] = @p19, [FBA_CarrierName] = @p20, [IsHadEmail] = @p21, [IsASingleInTheEnd] = @p22, [FBA_TransportName] = @p23, [AddressHash] = @p24, [IsHadBlueTag] = @p25 WHERE (([CustomerID] = @p26) AND ([OrderCode] = @p27))

[结果]

[期望]

请通盘检查保证数据类型和数据库一致，否则容易出现参数嗅探导致独占锁系统阻塞

历史记录

2026-04-24 10:49:38, 由 袁慧斌 创建。
2026-04-24 10:50:10, 由 李乐同 指派给 张明磊。
修改了 指派给，旧值为 "liletong"，新值为 "zhangminglei"。
2026-05-07 20:04:13, 由 张明磊 指派给黄凤。
修改了 指派给，旧值为 "zhangminglei"，新值为 "huangfeng"。

框架问题，耗时费力，转需求处理下
2026-05-07 20:25:29, 由黄凤转为需求，编号为 #35188 OMS：性能优化-micro-orderstrategy-domqmessage 项目 。
2026-05-07 20:25:29, 由黄凤关闭。
2026-05-08 16:08:58, 由 陈莉珍 编辑。
修改了 测试责任人，旧值为 ""，新值为 "huangfeng"。
修改了 解决时效 ，旧值为 "0"，新值为 "153.60"。
修改了 解决版本 ，旧值为 ""，新值为 "trunk"。
修改了 解决方案 ，旧值为 "tostory"，新值为 "bydesign"。
修改了 是否确认 ，旧值为 "0"，新值为 "1"。
修改了 重现步骤 ，区别为：
004- (@p1 decimal(8,7),@p2 bit,@p3 nvarchar(7),@p4 nvarchar(32),@p5 nvarchar(32),@p6 datetime,@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 nvarchar(4000),@p13 nvarchar(4000),@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar第二条(234),@p17 nvarchar(4000),@p18 int,@p19 nvarchar(21))UPDATE [RB_OrderInfo] SET [ExchangeRMB] = @p1, [IsPay] = @p2, [Province] = @p3, [City] = @p4, [PostCode] = @p5, [ShipTime] = @p6, [UpdatePlatformTime] = @p7, [DownLoadUpdateTime] = @p8, [UpdateTime] = @p9, [DispatchUpdatePlatformTime] = @p10, [LastCDKTime] = @p11, [FBA_CarrierName] = @p12, [IsHadEmail] = @p13, [IsASingleInTheEnd] = @p14, [FBA_TransportName] = @p15, [AddressHash] = @p16, [IsHadBlueTag] = @p17 WHERE (([CustomerID] = @p18) AND ([OrderCode] = @p19))
004+ (@p1 decimal(8,7),@p2 bit,@p3 nvarchar(7),@p4 nvarchar(32),@p5 nvarchar(32),@p6 datetime,@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 nvarchar(4000),@p13 nvarchar(4000),@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar第二条(234),@p17 nvarchar(4000),@p18 int,@p19 nvarchar(21))UPDATE [RB_OrderInfo] SET [ExchangeRMB] = @p1, [IsPay] = @p2, [Province] = @p3, [City] = @p4, [PostCode] = @p5, [ShipTime] = @p6, [UpdatePlatformTime] = @p7, [DownLoadUpdateTime] = @p8, [UpdateTime] = @p9, [DispatchUpdatePlatformTime] = @p10, [LastCDKTime] = @p11, [FBA_CarrierName] = @p12, [IsHadEmail] = @p13, [IsASingleInTheEnd] = @p14, [FBA_TransportName] = @p15, [AddressHash] = @p16, [IsHadBlueTag] = @p17 WHERE (([CustomerID] = @p18) AND ([OrderCode] = @p19))第三条
005- ~~第三条~~
005+ (@p1 bit,@p2 decimal(6,4),@p3 decimal(6,4),@p4 nvarchar(2),@p5 nvarchar(32),@p6 nvarchar(32),@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 datetime,@p13 decimal(6,4),@p14 nvarchar(4000),@p15 datetime,@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(4000),@p19 nvarchar(31),@p20 nvarchar(232),@p21 nvarchar(4000),@p22 int,@p23 nvarchar(21))UPDATE [RB_OrderInfo] SET [IsPay] = @p1, [TotalPrice] = @p2, [ProductTotalPrice] = @p3, [Province] = @p4, [City] = @p5, [PostCode] = @p6, [ShipTime] = @p7, [UpdatePlatformTime] = @p8, [DownLoadUpdateTime] = @p9, [UpdateTime] = @p10, [DispatchUpdatePlatformTime] = @p11, [LastCDKTime] = @p12, [PromotionDiscountAmount] = @p13, [FBA_CarrierName] = @p14, [LatestShipDate] = @p15, [IsHadEmail] = @p16, [IsASingleInTheEnd] = @p17, [FBA_TransportName] = @p18, [PromotionType] = @p19, [AddressHash] = @p20, [IsHadBlueTag] = @p21 WHERE (([CustomerID] = @p22) AND ([OrderCode] = @p23))
006- (@p1 bit,@p2 decimal(6,4),@p3 decimal(6,4),@p4 nvarchar(2),@p5 nvarchar(32),@p6 nvarchar(32),@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 datetime,@p13 decimal(6,4),@p14 nvarchar(4000),@p15 datetime,@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(4000),@p19 nvarchar(31),@p20 nvarchar(232),@p21 nvarchar(4000),@p22 int,@p23 nvarchar(21))UPDATE [RB_OrderInfo] SET [IsPay] = @p1, [TotalPrice] = @p2, [ProductTotalPrice] = @p3, [Province] = @p4, [City] = @p5, [PostCode] = @p6, [ShipTime] = @p7, [UpdatePlatformTime] = @p8, [DownLoadUpdateTime] = @p9, [UpdateTime] = @p10, [DispatchUpdatePlatformTime] = @p11, [LastCDKTime] = @p12, [PromotionDiscountAmount] = @p13, [FBA_CarrierName] = @p14, [LatestShipDate] = @p15, [IsHadEmail] = @p16, [IsASingleInTheEnd] = @p17, [FBA_TransportName] = @p18, [PromotionType] = @p19, [AddressHash] = @p20, [IsHadBlueTag] = @p21 WHERE (([CustomerID] = @p22) AND ([OrderCode] = @p23))
006+
007-
007+ 第四条
008- ~~第四条~~
008+
009-
009+ (@p1 nvarchar(14),@p2 decimal(8,7),@p3 decimal(21,20),@p4 bit,@p5 decimal(6,4),@p6 decimal(6,4),@p7 nvarchar(96),@p8 nvarchar(32),@p9 nvarchar(6),@p10 nvarchar(32),@p11 nvarchar(96),@p12 nvarchar(32),@p13 datetime,@p14 datetime,@p15 datetime,@p16 datetime,@p17 datetime,@p18 datetime,@p19 nvarchar(96),@p20 nvarchar(4000),@p21 nvarchar(4000),@p22 nvarchar(4000),@p23 nvarchar(4000),@p24 nvarchar(234),@p25 nvarchar(4000),@p26 int,@p27 nvarchar(21))UPDATE [RB_OrderInfo] SET [PayerId] = @p1, [ExchangeRMB] = @p2, [ExchangeUSD] = @p3, [IsPay] = @p4, [TotalPrice] = @p5, [ProductTotalPrice] = @p6, [FirstName] = @p7, [LastName] = @p8, [Province] = @p9, [City] = @p10, [Address] = @p11, [PostCode] = @p12, [ShipTime] = @p13, [UpdatePlatformTime] = @p14, [DownLoadUpdateTime] = @p15, [UpdateTime] = @p16, [DispatchUpdatePlatformTime] = @p17, [LastCDKTime] = @p18, [Address1] = @p19, [FBA_CarrierName] = @p20, [IsHadEmail] = @p21, [IsASingleInTheEnd] = @p22, [FBA_TransportName] = @p23, [AddressHash] = @p24, [IsHadBlueTag] = @p25 WHERE (([CustomerID] = @p26) AND ([OrderCode] = @p27))
010- (@p1 nvarchar(14),@p2 decimal(8,7),@p3 decimal(21,20),@p4 bit,@p5 decimal(6,4),@p6 decimal(6,4),@p7 nvarchar(96),@p8 nvarchar(32),@p9 nvarchar(6),@p10 nvarchar(32),@p11 nvarchar(96),@p12 nvarchar(32),@p13 datetime,@p14 datetime,@p15 datetime,@p16 datetime,@p17 datetime,@p18 datetime,@p19 nvarchar(96),@p20 nvarchar(4000),@p21 nvarchar(4000),@p22 nvarchar(4000),@p23 nvarchar(4000),@p24 nvarchar(234),@p25 nvarchar(4000),@p26 int,@p27 nvarchar(21))UPDATE [RB_OrderInfo] SET [PayerId] = @p1, [ExchangeRMB] = @p2, [ExchangeUSD] = @p3, [IsPay] = @p4, [TotalPrice] = @p5, [ProductTotalPrice] = @p6, [FirstName] = @p7, [LastName] = @p8, [Province] = @p9, [City] = @p10, [Address] = @p11, [PostCode] = @p12, [ShipTime] = @p13, [UpdatePlatformTime] = @p14, [DownLoadUpdateTime] = @p15, [UpdateTime] = @p16, [DispatchUpdatePlatformTime] = @p17, [LastCDKTime] = @p18, [Address1] = @p19, [FBA_CarrierName] = @p20, [IsHadEmail] = @p21, [IsASingleInTheEnd] = @p22, [FBA_TransportName] = @p23, [AddressHash] = @p24, [IsHadBlueTag] = @p25 WHERE (([CustomerID] = @p26) AND ([OrderCode] = @p27))
010+ [结果]
011- ~~[结果]~~
011+ [期望]
012- ~~[期望]~~
012+ 请通盘检查保证数据类型和数据库一致，否则容易出现参数嗅探导致独占锁系统阻塞
013- ~~请通盘检查保证数据类型和数据库一致，否则容易出现参数嗅探导致独占锁系统阻塞~~

004- (@p1 decimal(8,7),@p2 bit,@p3 nvarchar(7),@p4 nvarchar(32),@p5 nvarchar(32),@p6 datetime,@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 nvarchar(4000),@p13 nvarchar(4000),@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar 第二条 (234),@p17 nvarchar(4000),@p18 int,@p19 nvarchar(21))UPDATE [RB_OrderInfo] SET [ExchangeRMB] = @p1, [IsPay] = @p2, [Province] = @p3, [City] = @p4, [PostCode] = @p5, [ShipTime] = @p6, [UpdatePlatformTime] = @p7, [DownLoadUpdateTime] = @p8, [UpdateTime] = @p9, [DispatchUpdatePlatformTime] = @p10, [LastCDKTime] = @p11, [FBA_CarrierName] = @p12, [IsHadEmail] = @p13, [IsASingleInTheEnd] = @p14, [FBA_TransportName] = @p15, [AddressHash] = @p16, [IsHadBlueTag] = @p17 WHERE (([CustomerID] = @p18) AND ([OrderCode] = @p19)) 
004+ (@p1 decimal(8,7),@p2 bit,@p3 nvarchar(7),@p4 nvarchar(32),@p5 nvarchar(32),@p6 datetime,@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 nvarchar(4000),@p13 nvarchar(4000),@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar 第二条 (234),@p17 nvarchar(4000),@p18 int,@p19 nvarchar(21))UPDATE [RB_OrderInfo] SET [ExchangeRMB] = @p1, [IsPay] = @p2, [Province] = @p3, [City] = @p4, [PostCode] = @p5, [ShipTime] = @p6, [UpdatePlatformTime] = @p7, [DownLoadUpdateTime] = @p8, [UpdateTime] = @p9, [DispatchUpdatePlatformTime] = @p10, [LastCDKTime] = @p11, [FBA_CarrierName] = @p12, [IsHadEmail] = @p13, [IsASingleInTheEnd] = @p14, [FBA_TransportName] = @p15, [AddressHash] = @p16, [IsHadBlueTag] = @p17 WHERE (([CustomerID] = @p18) AND ([OrderCode] = @p19)) 第三条
005- ~~第三条~~
005+ (@p1 bit,@p2 decimal(6,4),@p3 decimal(6,4),@p4 nvarchar(2),@p5 nvarchar(32),@p6 nvarchar(32),@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 datetime,@p13 decimal(6,4),@p14 nvarchar(4000),@p15 datetime,@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(4000),@p19 nvarchar(31),@p20 nvarchar(232),@p21 nvarchar(4000),@p22 int,@p23 nvarchar(21)) UPDATE [RB_OrderInfo] SET [IsPay] = @p1, [TotalPrice] = @p2, [ProductTotalPrice] = @p3, [Province] = @p4, [City] = @p5, [PostCode] = @p6, [ShipTime] = @p7, [UpdatePlatformTime] = @p8, [DownLoadUpdateTime] = @p9, [UpdateTime] = @p10, [DispatchUpdatePlatformTime] = @p11, [LastCDKTime] = @p12, [PromotionDiscountAmount] = @p13, [FBA_CarrierName] = @p14, [LatestShipDate] = @p15, [IsHadEmail] = @p16, [IsASingleInTheEnd] = @p17, [FBA_TransportName] = @p18, [PromotionType] = @p19, [AddressHash] = @p20, [IsHadBlueTag] = @p21 WHERE (([CustomerID] = @p22) AND ([OrderCode] = @p23))
006- (@p1 bit,@p2 decimal(6,4),@p3 decimal(6,4),@p4 nvarchar(2),@p5 nvarchar(32),@p6 nvarchar(32),@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 datetime,@p13 decimal(6,4),@p14 nvarchar(4000),@p15 datetime,@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(4000),@p19 nvarchar(31),@p20 nvarchar(232),@p21 nvarchar(4000),@p22 int,@p23 nvarchar(21)) UPDATE [RB_OrderInfo] SET [IsPay] = @p1, [TotalPrice] = @p2, [ProductTotalPrice] = @p3, [Province] = @p4, [City] = @p5, [PostCode] = @p6, [ShipTime] = @p7, [UpdatePlatformTime] = @p8, [DownLoadUpdateTime] = @p9, [UpdateTime] = @p10, [DispatchUpdatePlatformTime] = @p11, [LastCDKTime] = @p12, [PromotionDiscountAmount] = @p13, [FBA_CarrierName] = @p14, [LatestShipDate] = @p15, [IsHadEmail] = @p16, [IsASingleInTheEnd] = @p17, [FBA_TransportName] = @p18, [PromotionType] = @p19, [AddressHash] = @p20, [IsHadBlueTag] = @p21 WHERE (([CustomerID] = @p22) AND ([OrderCode] = @p23))
006+ 
007- ~~ ~~
007+ 第四条
008- ~~第四条~~
008+ 
009- ~~ ~~
009+ (@p1 nvarchar(14),@p2 decimal(8,7),@p3 decimal(21,20),@p4 bit,@p5 decimal(6,4),@p6 decimal(6,4),@p7 nvarchar(96),@p8 nvarchar(32),@p9 nvarchar(6),@p10 nvarchar(32),@p11 nvarchar(96),@p12 nvarchar(32),@p13 datetime,@p14 datetime,@p15 datetime,@p16 datetime,@p17 datetime,@p18 datetime,@p19 nvarchar(96),@p20 nvarchar(4000),@p21 nvarchar(4000),@p22 nvarchar(4000),@p23 nvarchar(4000),@p24 nvarchar(234),@p25 nvarchar(4000),@p26 int,@p27 nvarchar(21))UPDATE [RB_OrderInfo] SET [PayerId] = @p1, [ExchangeRMB] = @p2, [ExchangeUSD] = @p3, [IsPay] = @p4, [TotalPrice] = @p5, [ProductTotalPrice] = @p6, [FirstName] = @p7, [LastName] = @p8, [Province] = @p9, [City] = @p10, [Address] = @p11, [PostCode] = @p12, [ShipTime] = @p13, [UpdatePlatformTime] = @p14, [DownLoadUpdateTime] = @p15, [UpdateTime] = @p16, [DispatchUpdatePlatformTime] = @p17, [LastCDKTime] = @p18, [Address1] = @p19, [FBA_CarrierName] = @p20, [IsHadEmail] = @p21, [IsASingleInTheEnd] = @p22, [FBA_TransportName] = @p23, [AddressHash] = @p24, [IsHadBlueTag] = @p25 WHERE (([CustomerID] = @p26) AND ([OrderCode] = @p27))
010- (@p1 nvarchar(14),@p2 decimal(8,7),@p3 decimal(21,20),@p4 bit,@p5 decimal(6,4),@p6 decimal(6,4),@p7 nvarchar(96),@p8 nvarchar(32),@p9 nvarchar(6),@p10 nvarchar(32),@p11 nvarchar(96),@p12 nvarchar(32),@p13 datetime,@p14 datetime,@p15 datetime,@p16 datetime,@p17 datetime,@p18 datetime,@p19 nvarchar(96),@p20 nvarchar(4000),@p21 nvarchar(4000),@p22 nvarchar(4000),@p23 nvarchar(4000),@p24 nvarchar(234),@p25 nvarchar(4000),@p26 int,@p27 nvarchar(21))UPDATE [RB_OrderInfo] SET [PayerId] = @p1, [ExchangeRMB] = @p2, [ExchangeUSD] = @p3, [IsPay] = @p4, [TotalPrice] = @p5, [ProductTotalPrice] = @p6, [FirstName] = @p7, [LastName] = @p8, [Province] = @p9, [City] = @p10, [Address] = @p11, [PostCode] = @p12, [ShipTime] = @p13, [UpdatePlatformTime] = @p14, [DownLoadUpdateTime] = @p15, [UpdateTime] = @p16, [DispatchUpdatePlatformTime] = @p17, [LastCDKTime] = @p18, [Address1] = @p19, [FBA_CarrierName] = @p20, [IsHadEmail] = @p21, [IsASingleInTheEnd] = @p22, [FBA_TransportName] = @p23, [AddressHash] = @p24, [IsHadBlueTag] = @p25 WHERE (([CustomerID] = @p26) AND ([OrderCode] = @p27)) 
010+ [结果]
011- ~~[结果]~~
011+ [期望]
012- ~~ [期望]~~
012+ 请通盘检查保证数据类型和数据库一致，否则容易出现参数嗅探导致独占锁系统阻塞
013- ~~请通盘检查保证数据类型和数据库一致，否则容易出现参数嗅探导致独占锁系统阻塞~~
2026-05-19 10:18:12, 由曾倩编辑。
修改了 影响环境，旧值为 "pro627"，新值为 "proonline"。

基本信息
迭代/需求/任务

所属项目	技术中心-需求池
所属模块	财务客户订单
所属计划
所属迭代
Bug类型
严重程度	一般
优先级	P1
Bug状态	已关闭
业务部门	供应链管理中心
影响功能
开发责任人	黄凤
测试责任人	黄凤
解决时效	153.6
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2026-05-19 10:18:12
截止日期	0000-00-00
上线时间	2026-05-07 09:00:00
上线时效	142.17
操作系统
浏览器
关键词
抄送给

所属迭代
相关需求
相关任务

Bug的一生
其他相关

由谁创建	袁慧斌于 2026-04-24 10:49:37
影响环境	生产环境-线上测试
由谁解决	黄凤于 2026-05-07 20:25:28
解决版本	主干
解决方案	系统设计缺陷
由谁关闭	黄凤于 2026-05-07 20:25:28
最后修改	曾倩于 2026-05-19 10:18:12

相关Bug
转需求	#35188 OMS：性能优化-micro-orderstrategy-domqmessage 项目