1 |
SIMPLE |
s2_ |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
Using index; Using temporary; Using filesort |
1 |
SIMPLE |
a4_ |
ALL |
|
|
|
|
10 |
Using where |
1 |
SIMPLE |
a3_ |
eq_ref |
PRIMARY, IDX_ad_ad_id, IDX_as_site_id |
PRIMARY |
12 |
roofers_staging2.a4_.media_group_item_id, const |
1 |
Using index |
1 |
SIMPLE |
m0_ |
eq_ref |
PRIMARY, IDX_3C64B0FAF135F7F5 |
PRIMARY |
8 |
roofers_staging2.a4_.media_group_item_id |
1 |
Using where |
1 |
SIMPLE |
m1_ |
eq_ref |
PRIMARY |
PRIMARY |
8 |
roofers_staging2.m0_.media_group_id |
1 |
Using where |
1 |
SIMPLE |
m5_ |
ALL |
|
|
|
|
2407 |
Using where; Using join buffer (flat, BNL join) |
1 |
SIMPLE |
m6_ |
ALL |
|
|
|
|
2407 |
Using where; Using join buffer (incremental, BNL join) |
1 |
SIMPLE |
m7_ |
ALL |
|
|
|
|
2407 |
Using where; Using join buffer (incremental, BNL join) |