1 |
PRIMARY |
d2_ |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
1 |
PRIMARY |
d0_ |
range |
PRIMARY, IDX_C49DE22F557B630 |
IDX_C49DE22F557B630 |
7 |
|
20 |
Using index condition; Using where; Using filesort |
1 |
PRIMARY |
p3_ |
eq_ref |
PRIMARY |
PRIMARY |
4 |
xb235735_stageb.d0_.schedule_time_id |
1 |
Using where |
1 |
PRIMARY |
d1_ |
eq_ref |
PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 |
PRIMARY |
8 |
xb235735_stageb.d0_.id, const |
1 |
Using where |
1 |
PRIMARY |
d4_ |
ref |
IDX_1A11D1BA4584665A |
IDX_1A11D1BA4584665A |
5 |
xb235735_stageb.d0_.id |
1 |
Using where |
3 |
DEPENDENT SUBQUERY |
d8_ |
eq_ref |
PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630, IDX_C49DE22FD380F18A |
PRIMARY |
4 |
func |
1 |
Using where |
3 |
DEPENDENT SUBQUERY |
d9_ |
ref |
PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 |
PRIMARY |
4 |
xb235735_stageb.d8_.id |
2 |
Using where |
3 |
DEPENDENT SUBQUERY |
d10_ |
eq_ref |
PRIMARY, IDX_5ED2C2B796A8F92, IDX_5ED2C2B61220EA6, IDX_5ED2C2BD380F18A |
PRIMARY |
4 |
xb235735_stageb.d9_.category_id |
1 |
Using where |
3 |
DEPENDENT SUBQUERY |
p11_ |
eq_ref |
PRIMARY, IDX_1B30AA8F27BFAF1B |
PRIMARY |
4 |
xb235735_stageb.d10_.schedule_time_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 |