http://www.viewpoint.asb-digital.fr/products/zebrafish/cardiology

id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE s0_ ALL PRIMARY, IDX_BCE3F79812469DE2, IDX_BCE3F798A9CED711, IDX_BCE3F79861220EA6 12 100.00 Using temporary
1 SIMPLE s1_ ALL sub_category_translation_unique_translation, IDX_527AF4672C2AC5D3 24 4.17 Using where; Using join buffer (hash join)