http://www.viewpoint.asb-digital.fr/products/rodent

id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE p0_ index PRIMARY, IDX_D34A04AD12469DE2, IDX_D34A04ADF7BFE87C, IDX_D34A04ADA9CED711, IDX_D34A04AD61220EA6 PRIMARY 4 23 10.00 Using where; Using temporary; Using filesort
1 SIMPLE p2_ ref IDX_3147D5F34584665A, IDX_3147D5F3F7BFE87C IDX_3147D5F34584665A 5 viewpoint_dev.p0_.id 1 100.00
1 SIMPLE s3_ eq_ref PRIMARY, IDX_BCE3F79812469DE2 PRIMARY 4 viewpoint_dev.p2_.sub_category_id 1 41.67 Using where
1 SIMPLE p5_ ref PRIMARY, IDX_11A8C6944584665A IDX_11A8C6944584665A 4 viewpoint_dev.p0_.id 1 100.00 Using index
1 SIMPLE p4_ eq_ref PRIMARY PRIMARY 4 viewpoint_dev.p5_.phase_evolution_id 1 100.00 Using index
1 SIMPLE p6_ ref IDX_912EFC664584665A IDX_912EFC664584665A 5 viewpoint_dev.p0_.id 6 100.00 Using index
1 SIMPLE p7_ ref IDX_D6444AA14584665A IDX_D6444AA14584665A 5 viewpoint_dev.p0_.id 2 100.00 Using index
1 SIMPLE p1_ ref product_translation_unique_translation, IDX_1846DB702C2AC5D3 IDX_1846DB702C2AC5D3 5 viewpoint_dev.p0_.id 2 100.00 Using index