1 |
PRIMARY |
<derived2> |
|
ALL |
|
|
|
|
2 |
100 |
|
2 |
DERIVED |
b0_ |
|
ALL |
PRIMARY, UNIQ_9FA05F8AD17F50A6, UNIQ_9FA05F8A6FC27B12, UNIQ_9FA05F8A6C98D401, UNIQ_9FA05F8A32C8A3DE |
|
|
|
2 |
50 |
Using where; Using temporary |
2 |
DERIVED |
s5_ |
|
ref |
IDX_677B9B74F603EE73 |
IDX_677B9B74F603EE73 |
5 |
open_marketplace.b0_.id |
6 |
10 |
Using where; Distinct |
2 |
DERIVED |
b1_ |
|
eq_ref |
PRIMARY |
PRIMARY |
4 |
open_marketplace.b0_.vendor_address_id |
1 |
100 |
Using index; Distinct |
2 |
DERIVED |
b2_ |
|
eq_ref |
PRIMARY |
PRIMARY |
4 |
open_marketplace.b0_.organization_id |
1 |
100 |
Using index; Distinct |
2 |
DERIVED |
s3_ |
|
ref |
PRIMARY, IDX_7E82D5E632C8A3DE |
IDX_7E82D5E632C8A3DE |
5 |
open_marketplace.b0_.organization_id |
1 |
100 |
Using index; Distinct |
2 |
DERIVED |
s4_ |
|
eq_ref |
UNIQ_7C2B74809395C3F3 |
UNIQ_7C2B74809395C3F3 |
4 |
open_marketplace.s3_.id |
1 |
50 |
Using where; Distinct |