id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived2>	NULL	ALL	NULL	NULL	NULL	NULL	102192	100.00	NULL
2	DERIVED	products	NULL	index	PRIMARY	PRODUCT_UNIQUE	767	NULL	20182	100.00	Using index
2	DERIVED	wish_list	NULL	ref	WPRODUCT_ID,WBRANCH_ID	WPRODUCT_ID	4	mytest.products.ID	5	100.00	Using index condition
2	DERIVED	branches	NULL	eq_ref	PRIMARY	PRIMARY	4	mytest.wish_list.BRANCH_ID	1	100.00	NULL
3	DEPENDENT SUBQUERY	branches_stocks	NULL	ref	BSPRODUCT_ID	BSPRODUCT_ID	9	mytest.wish_list.PRODUCT_ID	11	81.00	Using index condition; Using where
4	DEPENDENT SUBQUERY	branches_stocks	NULL	ref	BSBRANCH_ID,BSPRODUCT_ID	BSPRODUCT_ID	9	mytest.wish_list.PRODUCT_ID	11	10.00	Using index condition; Using where
5	DEPENDENT SUBQUERY	branches_stocks	NULL	ref	BSBRANCH_ID,BSPRODUCT_ID	BSPRODUCT_ID	9	mytest.wish_list.PRODUCT_ID	11	10.00	Using index condition; Using where