SELECT
`CustomerId` AS `CustomerId`,
`CategoryId` AS `CategoryId`,
`AttributeId` AS `AttributeId`,
`Locale` AS `Locale`,
`ShowTypeValue` AS `ShowTypeValue`,
`CustomizedName` AS `CustomizedName`,
`CustomizedPic` AS `CustomizedPic`,
`InputType` AS `InputType`,
`KeyAttribute` AS `KeyAttribute`,
`Name` AS `Name`,
`NameCn` AS `NameCn`,
`Required` AS `Required`,
`Sku` AS `Sku`,
`SkuStyleValue` AS `SkuStyleValue`,
`Spec` AS `Spec`,
`Visible` AS `Visible`,
`Features` AS `Features`,
`Id` AS `Id`
FROM
`M_AliExpress_Attribute`
WHERE
((
`CustomerId` = 1
)
AND ( `CategoryId` = 200000219 ));
任务描述
需求描述
业务背景
1)业务方临时数据处理、统计、导出等无法得到及时帮助
2)生产问题排查排期周期过长
业务文档
https://alidocs.dingtalk.com/i/nodes/mExel2BLV541nqKkSZX5MzAlWgk9rpMq?utm_scene=team_space
验收标准
及时响应业务问题并处理妥善,保持系统稳定性
查询已添加索引,查询返回数量大,400万+,加载慢 且耗内存,需调整相关业务进行优化,