http://www.viewpoint.asb-digital.fr/product/zebrafish/fish-behavior-monitoring/zebratower

id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE p1_ ref PRIMARY, IDX_11A8C6944584665A, IDX_11A8C6942B200B63 PRIMARY 4 const 1 100.00 Using index; Using temporary; Using filesort
1 SIMPLE p0_ eq_ref PRIMARY PRIMARY 4 viewpoint_dev.p1_.phase_evolution_id 1 100.00