1 |
SIMPLE |
c1_ |
const |
PRIMARY |
PRIMARY |
8 |
const |
1 |
Using index; Using temporary; Using filesort |
1 |
SIMPLE |
s3_ |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
Using index |
1 |
SIMPLE |
c2_ |
range |
PRIMARY, IDX_54FBF32E84A0A3ED, IDX_54FBF32E12469DE2 |
IDX_54FBF32E12469DE2 |
16 |
|
137 |
Using where; Using index |
1 |
SIMPLE |
c0_ |
eq_ref |
PRIMARY, published_at_index |
PRIMARY |
8 |
roofers_staging2.c2_.content_id |
1 |
Using where |
1 |
SIMPLE |
c4_ |
eq_ref |
PRIMARY, IDX_54FBF32E84A0A3ED, IDX_cs_site_id |
PRIMARY |
12 |
roofers_staging2.c2_.content_id, const |
1 |
Using index; Distinct |