https://dev.kmj-tv.jp/products/list

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE d0_ range PRIMARY PRIMARY 4 4 Using where; Using temporary; Using filesort
1 SIMPLE d1_ ref PRIMARY, IDX_1A11D1BA4584665A IDX_1A11D1BA4584665A 5 mahjontv1326_dev.d0_.id 1 Using where
1 SIMPLE d2_ ALL IDX_59F696DE21B06187 1 Using where; Using join buffer (flat, BNL join)
1 SIMPLE d4_ eq_ref PRIMARY PRIMARY 4 mahjontv1326_dev.d1_.class_category_id1 1 Using where
1 SIMPLE d5_ eq_ref PRIMARY PRIMARY 4 mahjontv1326_dev.d1_.class_category_id2 1 Using where
1 SIMPLE d6_ ref IDX_3267CC7A4584665A IDX_3267CC7A4584665A 5 mahjontv1326_dev.d0_.id 1 Using where
1 SIMPLE d7_ ALL IDX_4433E7214584665A 1 Using where; Using join buffer (flat, BNL join)
1 SIMPLE d3_ ref IDX_BC6C9E4521B06187 IDX_BC6C9E4521B06187 5 mahjontv1326_dev.d1_.id 1 Using where