| 1 |
SIMPLE |
c1_ |
const |
PRIMARY |
PRIMARY |
8 |
const |
1 |
Using index; Using temporary; Using filesort |
| 1 |
SIMPLE |
c2_ |
ref |
PRIMARY, IDX_E21894179395C3F3, IDX_E218941784A0A3ED |
PRIMARY |
8 |
const |
40 |
Using index |
| 1 |
SIMPLE |
c0_ |
eq_ref |
PRIMARY, published_at_index, IDX_get_content |
PRIMARY |
8 |
roofers_staging2.c2_.content_id |
1 |
Using where |
| 1 |
SIMPLE |
c4_ |
ref |
PRIMARY, IDX_54FBF32E84A0A3ED, IDX_54FBF32E12469DE2 |
PRIMARY |
8 |
roofers_staging2.c2_.content_id |
1 |
Using index |
| 1 |
SIMPLE |
c3_ |
eq_ref |
PRIMARY, slug_index |
PRIMARY |
8 |
roofers_staging2.c4_.category_id |
1 |
|
| 1 |
SIMPLE |
c5_ |
eq_ref |
PRIMARY |
PRIMARY |
8 |
roofers_staging2.c3_.prnt_id |
1 |
Using where |
| 1 |
SIMPLE |
c6_ |
eq_ref |
PRIMARY |
PRIMARY |
8 |
roofers_staging2.c5_.prnt_id |
1 |
Using where |
| 1 |
SIMPLE |
c7_ |
eq_ref |
PRIMARY |
PRIMARY |
8 |
roofers_staging2.c6_.prnt_id |
1 |
Using where |