http://stage.neue-zeile.com/pig-pig-754?standard=MultiCam%20%2F%20S

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE d0_ const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort
1 SIMPLE d1_ ref IDX_1A11D1BA4584665A IDX_1A11D1BA4584665A 5 const 1 Using where
1 SIMPLE d2_ eq_ref PRIMARY PRIMARY 4 xb235735_stageb.d1_.class_category_id1 1 Using where
1 SIMPLE d3_ eq_ref PRIMARY PRIMARY 4 xb235735_stageb.d1_.class_category_id2 1 Using where
1 SIMPLE d4_ ref IDX_3267CC7A4584665A IDX_3267CC7A4584665A 5 const 13 Using where
1 SIMPLE d5_ ref IDX_4433E7214584665A IDX_4433E7214584665A 5 const 1 Using where