| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | d2_ | ALL | PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 | 7 | 14.29 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | d0_ | eq_ref | PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630, IDX_C49DE22F68DA5EC3 | PRIMARY | 4 | ratorin_eccube.d2_.product_id | 1 | 50.00 | 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 | ratorin_eccube.d2_.product_id | 5 | 9.09 | Using where |