1 |
PRIMARY |
d0_ |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
Using temporary; Using filesort |
1 |
PRIMARY |
d1_ |
ref |
IDX_35DCD7318C22AA1A |
IDX_35DCD7318C22AA1A |
4 |
const |
9 |
Using where |
1 |
PRIMARY |
d2_ |
eq_ref |
PRIMARY, IDX_6B54DCBDD380F18A |
PRIMARY |
4 |
xb235735_stageb.d1_.block_id |
1 |
Using where |
5 |
DEPENDENT SUBQUERY |
plg_schedule_time |
unique_subquery |
PRIMARY, IDX_1B30AA8F27BFAF1B |
PRIMARY |
4 |
func |
1 |
Using where |
6 |
DEPENDENT SUBQUERY |
plg_schedule_time |
unique_subquery |
PRIMARY |
PRIMARY |
4 |
func |
1 |
Using where; Full scan on NULL key |
2 |
MATERIALIZED |
dtb_block |
index |
PRIMARY, IDX_6B54DCBDD380F18A |
IDX_6B54DCBDD380F18A |
5 |
|
30 |
Using where; Using index |
3 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY, IDX_1B30AA8F27BFAF1B |
|
|
|
83 |
Using where |
4 |
MATERIALIZED |
plg_schedule_time |
ALL |
PRIMARY |
|
|
|
83 |
Using where |