1 |
PRIMARY |
d0_ |
ref |
IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A |
IDX_5ED2C2B796A8F92 |
5 |
const |
2 |
Using index condition; Using where; Using temporary; Using filesort |
1 |
PRIMARY |
d1_ |
ref |
IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A |
IDX_5ED2C2B796A8F92 |
5 |
xb235735_stageb.d0_.id |
6 |
Using where |
1 |
PRIMARY |
d2_ |
ref |
IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A |
IDX_5ED2C2B796A8F92 |
5 |
xb235735_stageb.d1_.id |
6 |
Using where |
1 |
PRIMARY |
d3_ |
ref |
IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A |
IDX_5ED2C2B796A8F92 |
5 |
xb235735_stageb.d2_.id |
6 |
Using where |
1 |
PRIMARY |
d4_ |
ref |
IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A |
IDX_5ED2C2B796A8F92 |
5 |
xb235735_stageb.d3_.id |
6 |
Using where |
10 |
DEPENDENT SUBQUERY |
plg_schedule_time |
unique_subquery |
PRIMARY, IDX_1B30AA8F27BFAF1B |
PRIMARY |
4 |
func |
1 |
Using where |
11 |
DEPENDENT SUBQUERY |
plg_schedule_time |
unique_subquery |
PRIMARY |
PRIMARY |
4 |
func |
1 |
Using where; Full scan on NULL key |
8 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY, IDX_1B30AA8F27BFAF1B |
|
|
|
83 |
Using where |
9 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY |
|
|
|
83 |
Using where |
6 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY, IDX_1B30AA8F27BFAF1B |
|
|
|
83 |
Using where |
7 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY |
|
|
|
83 |
Using where |
4 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY, IDX_1B30AA8F27BFAF1B |
|
|
|
83 |
Using where |
5 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY |
|
|
|
83 |
Using where |
2 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY, IDX_1B30AA8F27BFAF1B |
|
|
|
83 |
Using where |
3 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY |
|
|
|
83 |
Using where |