1	PRIMARY	<subquery2>	ALL	distinct_key				31613
1	PRIMARY	ARTICLES	ALL	PRIMARY				5212246	Using where; Using join buffer (flat, BNL join)
2	MATERIALIZED	MANUFACTURERS	ALL	PRIMARY,MFA_BRAND				387	Using where
2	MATERIALIZED	BRANDS	ref	PRIMARY,BRAND	BRAND	63	db1.MANUFACTURERS.BRAND	1	Using where
2	MATERIALIZED	LOOKUP	ref	PRIMARY,BRA_ID	BRA_ID	2	db1.BRANDS.ID	313	Using index