1 |
PRIMARY |
d4_ |
ALL |
IDX_1A11D1BA4584665A |
|
|
|
6045 |
Using where |
1 |
PRIMARY |
d1_ |
ref |
PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 |
PRIMARY |
4 |
xb235735_stageb.d4_.product_id |
2 |
Using where |
1 |
PRIMARY |
d0_ |
eq_ref |
PRIMARY, IDX_C49DE22F557B630 |
PRIMARY |
4 |
xb235735_stageb.d4_.product_id |
1 |
Using where |
1 |
PRIMARY |
p3_ |
eq_ref |
PRIMARY |
PRIMARY |
4 |
xb235735_stageb.d0_.schedule_time_id |
1 |
Using where |
1 |
PRIMARY |
d2_ |
eq_ref |
PRIMARY |
PRIMARY |
4 |
xb235735_stageb.d1_.category_id |
1 |
Using where |
3 |
MATERIALIZED |
p11_ |
ALL |
PRIMARY, IDX_1B30AA8F27BFAF1B |
|
|
|
83 |
Using where |
3 |
MATERIALIZED |
d10_ |
ref |
PRIMARY, IDX_5ED2C2B796A8F92, IDX_5ED2C2B61220EA6, IDX_5ED2C2BD380F18A |
IDX_5ED2C2BD380F18A |
5 |
xb235735_stageb.p11_.schedule_time_id |
1 |
Using where |
3 |
MATERIALIZED |
d9_ |
ref |
PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 |
IDX_B057789112469DE2 |
4 |
xb235735_stageb.d10_.id |
106 |
Using where |
3 |
MATERIALIZED |
d8_ |
eq_ref |
PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630, IDX_C49DE22FD380F18A |
PRIMARY |
4 |
xb235735_stageb.d9_.product_id |
1 |
Using where |
2 |
MATERIALIZED |
p6_ |
ALL |
PRIMARY |
|
|
|
9 |
Using where |
2 |
MATERIALIZED |
p7_ |
ref |
PRIMARY, IDX_607C752D4584665A, IDX_607C752DFE54D947 |
IDX_607C752DFE54D947 |
4 |
xb235735_stageb.p6_.id |
1 |
Using index |
2 |
MATERIALIZED |
d5_ |
eq_ref |
PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630, IDX_C49DE22FD380F18A |
PRIMARY |
4 |
xb235735_stageb.p7_.product_id |
1 |
Using where |