id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE s0_ index PRIMARY, IDX_BCE3F79812469DE2, IDX_BCE3F798A9CED711, IDX_BCE3F79861220EA6 PRIMARY 4 12 8.33 Using where; Using temporary; Using filesort
1 SIMPLE s1_ ref sub_category_translation_unique_translation, IDX_527AF4672C2AC5D3 IDX_527AF4672C2AC5D3 5 viewpoint_dev.s0_.id 2 100.00 Using index