深圳智汇创想科技有限公司

  智能刊登gaussdb 慢sql  top 10

全表扫描

1. 建议在数据表 irobotbox_marketpublish.M_AliExpress_Attribute_Value 的 CategoryId,CustomerId,AttributeId,ValueId 列上添加如下索引，以提高查询性能：
   ALTER TABLE `irobotbox_marketpublish`.`M_AliExpress_Attribute_Value` ADD INDEX `idx_CategoryId_CustomerId_AttributeId_ValueId` (`CategoryId`, `CustomerId`, `AttributeId`, `ValueId`)

3.原sql

SELECT v.*
FROM (SELECT `CustomerId` AS `CustomerId`, `CategoryId` AS `CategoryId`, `AttributeId` AS `AttributeId`, MIN(`ValueId`) AS `ValueId`
	FROM `M_AliExpress_Attribute_Value`
	WHERE `CustomerId` = 1
		AND `CategoryId` = 100008736
	GROUP BY `CustomerId`, `CategoryId`, `AttributeId`
	) g
	LEFT JOIN (SELECT `CustomerId`, `CategoryId`, `AttributeId`, `ValueId`, `Name`
			, `NameCn`, `LastModifierId`, `LastModifier`, `LastModificationTime`, `CreatorId`
			, `Creator`, `CreationTime`, `Id`
		FROM `M_AliExpress_Attribute_Value`
		) v ON `g`.`CustomerId` = `v`.`CustomerId`
		AND `g`.`CategoryId` = `v`.`CategoryId`
		AND `g`.`AttributeId` = `v`.`AttributeId`
		AND `g`.`ValueId` = `v`.`ValueId`