| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | d1_ | ALL | IDX_1A11D1BA4584665A | 11 | 9.09 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | d0_ | eq_ref | PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630, IDX_C49DE22F68DA5EC3 | PRIMARY | 4 | ratorin_eccube.d1_.product_id | 1 | 50.00 | Using where |