【测试环境】测试环境,产品资料库,从正式环境迁移这四份sku数据相关联表数据时,发现产生了三份一模一样的数据,即使删除对应sku测试环境相关表数据,查询页面时仍然发现这些sku数据仍存在于页面,仍然是三份一模一样数据。
产生问题的系统sku:
16511633
16510975
16510429
16509854
数据库迁移-产品资料库相关表:(测试环境数据表均无这四个sku表相关数据)
select * from p_product where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');
select * from p_product_image where CustomerId=1 and Sku in ('16511633','16510975','16510429','16509854');
select * from p_market_product where CustomerId=1 and MarketId = 2 and Sku in ('16511633','16510975','16510429','16509854');
select * from p_market_product_review where CustomerId =1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');
select * from p_market_product_attribute where CustomerId=1 and MarketId =2 and Sku in ('16511633','16510975','16510429','16509854');
select * from p_market_product_variant where CustomerId=1 and MarketId=2 and Sku in ('16511633','16510975','16510429','16509854');
select * from p_product_inventory where Sku in ('16511633','16510975','16510429','16509854');
select * from p_product_groupsku where CustomerId =1 and GroupSku in ('16511633','16510975','16510429','16509854');
select * from P_Product_Inventory where Sku in ('16511633','16510975','16510429','16509854');
测试环境产品资料库:

正式环境查询这四个系统sku:(迁移后的数据测试环境数据,理应按照以下正式环境展示如下)

[步骤]
[结果]
[期望]
这是请求参数,剩下的我没看出什么问题
{
"input": {"SearchType": "1",
"SearchTimeKeys": [
"1",
[]
],
"BatchSearchType": "1",
"BatchSearchValue": [
"13551708"
]
},
"current": 1,
"language": "zh_cn"
}