1 |
SIMPLE |
d0_ |
range |
PRIMARY |
PRIMARY |
4 |
|
20 |
Using where; Using temporary; Using filesort |
1 |
SIMPLE |
d1_ |
ref |
PRIMARY, IDX_1A11D1BA4584665A |
IDX_1A11D1BA4584665A |
5 |
xb235735_stageb.d0_.id |
1 |
Using where |
1 |
SIMPLE |
d2_ |
ALL |
IDX_59F696DE21B06187 |
|
|
|
1 |
Using where; Using join buffer (flat, BNL join) |
1 |
SIMPLE |
d4_ |
eq_ref |
PRIMARY |
PRIMARY |
4 |
xb235735_stageb.d1_.class_category_id1 |
1 |
Using where |
1 |
SIMPLE |
d5_ |
eq_ref |
PRIMARY |
PRIMARY |
4 |
xb235735_stageb.d1_.class_category_id2 |
1 |
Using where |
1 |
SIMPLE |
d3_ |
ref |
IDX_BC6C9E4521B06187 |
IDX_BC6C9E4521B06187 |
5 |
xb235735_stageb.d1_.id |
1 |
Using where |
1 |
SIMPLE |
d6_ |
ref |
IDX_3267CC7A4584665A |
IDX_3267CC7A4584665A |
5 |
xb235735_stageb.d0_.id |
2 |
Using where |
1 |
SIMPLE |
d7_ |
ref |
IDX_4433E7214584665A |
IDX_4433E7214584665A |
5 |
xb235735_stageb.d0_.id |
1 |
Using where |