SELECT 
  b.variant_name, 
  a.* 
FROM 
  product_option_variants AS a 
  LEFT JOIN product_option_variants_descriptions AS b ON b.variant_id = a.variant_id 
  AND b.lang_code = 'en' 
WHERE 
  1 
  AND a.option_id IN (
    35717, 36763, 36748, 35699, 35700, 35793, 
    35790, 35797
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00566

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "221.74"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "77.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "a",
            "access_type": "range",
            "possible_keys": [
              "status",
              "option_id",
              "option_id_2"
            ],
            "key": "option_id",
            "used_key_parts": [
              "option_id",
              "status"
            ],
            "key_length": "6",
            "rows_examined_per_scan": 77,
            "rows_produced_per_join": 77,
            "filtered": "100.00",
            "index_condition": "((`goimagine`.`a`.`option_id` in (35717,36763,36748,35699,35700,35793,35790,35797)) and (`goimagine`.`a`.`status` = 'A'))",
            "cost_info": {
              "read_cost": "69.08",
              "eval_cost": "7.70",
              "prefix_cost": "76.78",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "variant_id",
              "option_id",
              "position",
              "modifier",
              "modifier_type",
              "weight_modifier",
              "weight_modifier_type",
              "point_modifier",
              "point_modifier_type",
              "status",
              "etsy_variant_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "b",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "variant_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "goimagine.a.variant_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 77,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "60.27",
              "eval_cost": "7.70",
              "prefix_cost": "144.74",
              "data_read_per_join": "58K"
            },
            "used_columns": [
              "variant_id",
              "lang_code",
              "variant_name"
            ]
          }
        }
      ]
    }
  }
}

Result

variant_name variant_id option_id position modifier modifier_type weight_modifier weight_modifier_type point_modifier point_modifier_type status etsy_variant_id
As is 140965 35699 0 0.000 A 0.000 A 0.000 A A
Personalize 140966 35699 0 5.000 A 0.000 A 0.000 A A
Oblong 141035 35717 0 0.000 A 0.000 A 0.000 A A
Storage Box 141219 35790 0 0.000 A 0.000 A 0.000 A A
Dominoes 141220 35790 0 9.000 A 0.500 A 0.000 A A
Set 141221 35790 0 24.000 A 0.500 A 0.000 A A
Storage Box 141280 35793 0 0.000 A 0.000 A 0.000 A A
Trays (2) 141281 35793 0 0.000 A 0.500 A 0.000 A A
Dominoes 141282 35793 0 9.000 A 0.500 A 0.000 A A
Box & Trays 141283 35793 0 16.000 A 0.500 A 0.000 A A
Dominoes and Box 141284 35793 0 25.000 A 0.500 A 0.000 A A
Dominoes and Trays 141285 35793 0 25.000 A 0.500 A 0.000 A A
Whole set 141286 35793 0 35.000 A 1.000 A 0.000 A A
1 Tray 141292 35797 0 0.000 A 0.000 A 0.000 A A
Storage Box 141294 35797 0 19.000 A 0.000 A 0.000 A A
Storage Box/1 tray 141295 35797 0 27.000 A 0.250 A 0.000 A A
Dominoes 141297 35797 0 31.000 A 0.250 A 0.000 A A
Dominoes/1 tray 141298 35797 0 39.000 A 0.500 A 0.000 A A
Dominoes/Box 141300 35797 0 48.000 A 0.750 A 0.000 A A
Whole set 141301 35797 0 56.000 A 1.000 A 0.000 A A
None 145177 36748 0 0.000 A 0.000 A 0.000 A A
Black 145178 36748 0 0.000 A 0.000 A 0.000 A A
White 145179 36748 0 0.000 A 0.000 A 0.000 A A
Red 145180 36748 0 0.000 A 0.000 A 0.000 A A
Dark red 145181 36748 0 0.000 A 0.000 A 0.000 A A
Orange 145182 36748 0 0.000 A 0.000 A 0.000 A A
Dark Orange 145183 36748 0 0.000 A 0.000 A 0.000 A A
Yellow 145184 36748 0 0.000 A 0.000 A 0.000 A A
Dark yellow 145185 36748 0 0.000 A 0.000 A 0.000 A A
Pale yellow 145186 36748 0 0.000 A 0.000 A 0.000 A A
Green 145187 36748 0 0.000 A 0.000 A 0.000 A A
Dark green 145188 36748 0 0.000 A 0.000 A 0.000 A A
Neon green 145189 36748 0 0.000 A 0.000 A 0.000 A A
Blue 145190 36748 0 0.000 A 0.000 A 0.000 A A
Light blue 145191 36748 0 0.000 A 0.000 A 0.000 A A
Navy blue 145192 36748 0 0.000 A 0.000 A 0.000 A A
Purple 145193 36748 0 0.000 A 0.000 A 0.000 A A
Lilac 145194 36748 0 0.000 A 0.000 A 0.000 A A
Pink 145195 36748 0 0.000 A 0.000 A 0.000 A A
Dark pink 145196 36748 0 0.000 A 0.000 A 0.000 A A
Gold 145197 36748 0 0.000 A 0.000 A 0.000 A A
Silver 145198 36748 0 0.000 A 0.000 A 0.000 A A
Copper 145199 36748 0 0.000 A 0.000 A 0.000 A A
Holographic 145200 36748 0 3.000 A 0.000 A 0.000 A A
None 146759 36763 1 0.000 A 0.000 A 0.000 A A
Anastacia 145236 36763 2 0.000 A 0.000 A 0.000 A A
Arimo 145239 36763 2 0.000 A 0.000 A 0.000 A A
Alice 145235 36763 4 0.000 A 0.000 A 0.000 A A
Alice in Wonderland 145264 36763 5 0.000 A 0.000 A 0.000 A A
Blanca 145260 36763 6 0.000 A 0.000 A 0.000 A A
Bethania 145240 36763 7 0.000 A 0.000 A 0.000 A A
Berkley 145237 36763 8 0.000 A 0.000 A 0.000 A A
Candara 145259 36763 9 0.000 A 0.000 A 0.000 A A
Cena 145261 36763 10 0.000 A 0.000 A 0.000 A A
Christy 145262 36763 11 0.000 A 0.000 A 0.000 A A
Destine 145238 36763 12 0.000 A 0.000 A 0.000 A A
Darling 145263 36763 13 0.000 A 0.000 A 0.000 A A
Essence 145258 36763 14 0.000 A 0.000 A 0.000 A A
Georgia 145241 36763 15 0.000 A 0.000 A 0.000 A A
Herman 145256 36763 16 0.000 A 0.000 A 0.000 A A
Jurassic 145242 36763 17 0.000 A 0.000 A 0.000 A A
Javanese 145250 36763 18 0.000 A 0.000 A 0.000 A A
Julian 145257 36763 19 0.000 A 0.000 A 0.000 A A
Jane 145255 36763 20 0.000 A 0.000 A 0.000 A A
Kyra 145243 36763 21 0.000 A 0.000 A 0.000 A A
Molly 145253 36763 22 0.000 A 0.000 A 0.000 A A
Mastura 145254 36763 23 0.000 A 0.000 A 0.000 A A
Mono 145244 36763 24 0.000 A 0.000 A 0.000 A A
Rembank 145252 36763 25 0.000 A 0.000 A 0.000 A A
Rosalia 145245 36763 26 0.000 A 0.000 A 0.000 A A
Stika 145246 36763 27 0.000 A 0.000 A 0.000 A A
Slasher 145247 36763 28 0.000 A 0.000 A 0.000 A A
Starbucks 145251 36763 29 0.000 A 0.000 A 0.000 A A
Teegan 145248 36763 30 0.000 A 0.000 A 0.000 A A
Terminal 145249 36763 31 0.000 A 0.000 A 0.000 A A
Agatha 145234 36763 32 0.000 A 0.000 A 0.000 A A