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