| 1 |
PRIMARY |
m1_ |
const |
PRIMARY |
PRIMARY |
8 |
const |
1 |
Using index; Using temporary; Using filesort |
| 1 |
PRIMARY |
s2_ |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
Using index |
| 1 |
PRIMARY |
m0_ |
ref |
PRIMARY, IDX_3C64B0FAF135F7F5 |
IDX_3C64B0FAF135F7F5 |
9 |
const |
373 |
Using where |
| 1 |
PRIMARY |
a3_ |
eq_ref |
PRIMARY, IDX_ad_ad_id, IDX_as_site_id |
PRIMARY |
12 |
roofers_staging2.m0_.id, const |
1 |
Using index |
| 2 |
DEPENDENT SUBQUERY |
m4_ |
eq_ref |
PRIMARY |
PRIMARY |
8 |
func |
1 |
Using index |
| 2 |
DEPENDENT SUBQUERY |
a5_ |
ALL |
|
|
|
|
7 |
Using where; Using join buffer (flat, BNL join) |