1 |
SIMPLE |
s4_ |
|
ALL |
UNIQ_7C2B74809395C3F3 |
|
|
|
2 |
50 |
Using where; Using temporary; Using filesort |
1 |
SIMPLE |
s3_ |
|
eq_ref |
PRIMARY, IDX_7E82D5E632C8A3DE |
PRIMARY |
4 |
open_marketplace.s4_.customer_id |
1 |
100 |
Using where |
1 |
SIMPLE |
b0_ |
|
ref |
PRIMARY, UNIQ_9FA05F8A6FC27B12, UNIQ_9FA05F8A32C8A3DE |
UNIQ_9FA05F8A32C8A3DE |
5 |
open_marketplace.s3_.organization_id |
1 |
50 |
Using index condition; Using where |
1 |
SIMPLE |
s5_ |
|
ref |
IDX_677B9B74F603EE73 |
IDX_677B9B74F603EE73 |
5 |
open_marketplace.b0_.id |
6 |
10 |
Using where |
1 |
SIMPLE |
b1_ |
|
eq_ref |
PRIMARY |
PRIMARY |
4 |
open_marketplace.b0_.vendor_address_id |
1 |
100 |
Using index |
1 |
SIMPLE |
b2_ |
|
eq_ref |
PRIMARY |
PRIMARY |
4 |
open_marketplace.s3_.organization_id |
1 |
100 |
Using index |