1	PRIMARY			<subquery2>		ALL	distinct_key														36966	100
1	PRIMARY			ARTICLE_LISTS	ALL																		2463790	100		Using where
2	MATERIALIZED	MANUFACTURERS	ALL	PRIMARY,MFA_BRAND													387		26.1	Using where
2	MATERIALIZED	BRANDS			ref	PRIMARY,BRA_BRAND	BRA_BRAND	63	db0.MANUFACTURERS.MFA_BRAND		1		100		Using where
2	MATERIALIZED	ART_LOOKUP		ref	PRIMARY,ARL_BRA_ID	ARL_BRA_ID	2	db0.BRANDS.BRA_ID				366		100		Using index