| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | d0_ | const | PRIMARY, IDX_C49DE22F557B630 | PRIMARY | 4 | const | 1 | 100.00 | ||
| 1 | SIMPLE | d2_ | range | PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 | PRIMARY | 8 | 3 | 14.29 | Using where | ||
| 1 | SIMPLE | d3_ | eq_ref | PRIMARY | PRIMARY | 4 | ratorin_eccube.d2_.category_id | 1 | 16.67 | Using where | |
| 1 | SIMPLE | d1_ | ref | IDX_1A11D1BA4584665A | IDX_1A11D1BA4584665A | 5 | const | 10 | 9.09 | Using index condition; Using where |