id |
select_type |
table |
partitions |
type |
possible_keys |
key |
key_len |
ref |
rows |
filtered |
Extra |
1 |
PRIMARY |
<derived2> |
NULL |
ALL |
NULL |
NULL |
NULL |
NULL |
104083 |
100.00 |
NULL |
2 |
DERIVED |
products |
NULL |
index |
PRIMARY |
PRODUCT_UNIQUE |
767 |
NULL |
20442 |
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 |