| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s0_ | ref | PRIMARY, IDX_BCE3F79812469DE2, IDX_BCE3F798A9CED711, IDX_BCE3F79861220EA6 | IDX_BCE3F79812469DE2 | 5 | const | 5 | 10.00 | 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 |