Sandbox

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 (
    17557, 12532, 12182, 12074, 12184, 16807, 
    16116, 16117, 12530, 16288, 16289, 
    12183, 11981, 12137, 12186, 12188, 
    12385, 16287, 13247, 12267, 13246, 
    16291, 12371, 17517
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.01303

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "199.80"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "65.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": 65,
            "rows_produced_per_join": 65,
            "filtered": "100.00",
            "index_condition": "((`goimagine`.`a`.`option_id` in (17557,12532,12182,12074,12184,16807,16116,16117,12530,16288,16289,12183,11981,12137,12186,12188,12385,16287,13247,12267,13246,16291,12371,17517)) and (`goimagine`.`a`.`status` = 'A'))",
            "cost_info": {
              "read_cost": "70.77",
              "eval_cost": "6.50",
              "prefix_cost": "77.27",
              "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": 65,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "51.04",
              "eval_cost": "6.50",
              "prefix_cost": "134.80",
              "data_read_per_join": "49K"
            },
            "used_columns": [
              "variant_id",
              "lang_code",
              "variant_name"
            ]
          }
        }
      ]
    }
  }
}

Result

variant_name	variant_id	option_id	position	modifier_type	weight_modifier_type	point_modifier_type	status
	62552	16116	0	A	A	A	A
Blue	52281	12182	1	A	A	A	A
Snowflakes	52536	12267	1	A	A	A	A
Bear	53397	12530	1	A	A	A	A
Cow	53408	12532	1	A	A	A	A
Star	56031	13246	1	A	A	A	A
	62551	16116	1	A	A	A	A
Pink	63487	16287	1	A	A	A	A
Yes	63496	16288	1	A	A	A	A
Natural wood color on top of white backer	63500	16291	1	A	A	A	A
White Lettering on Natural Wood Background	65792	16807	1	A	A	A	A
Green	69015	17517	1	A	A	A	A
One bird	69183	17557	1	A	A	A	A
Pink	52282	12182	2	A	A	A	A
Swirls	52537	12267	2	A	A	A	A
Moose	53398	12530	2	A	A	A	A
Horse	53409	12532	2	A	A	A	A
Tree	56032	13246	2	A	A	A	A
Blue	63488	16287	2	A	A	A	A
No	63497	16288	2	A	A	A	A
White ornament layered on top of natural wood color backer	63501	16291	2	A	A	A	A
Gold Lettering on White Background	65793	16807	2	A	A	A	A
Bright Blue	69016	17517	2	A	A	A	A
2 birds	69184	17557	2	A	A	A	A
Natural Wood	52283	12182	3	A	A	A	A
Cut out swirls	52538	12267	3	A	A	A	A
Horse	53399	12530	3	A	A	A	A
Donkey	53410	12532	3	A	A	A	A
Angel	56033	13246	3	A	A	A	A
Red	63489	16287	3	A	A	A	A
Navy Lettering on White Background	65794	16807	3	A	A	A	A
Red Cardinal	53400	12530	4	A	A	A	A
Goat	53411	12532	4	A	A	A	A
Stocking	56034	13246	4	A	A	A	A
Purple	63490	16287	4	A	A	A	A
Green on White Background	65795	16807	4	A	A	A	A
Pink	69017	17517	4	A	A	A	A
Pink	69018	17517	4	A	A	A	A
Pink	69019	17517	4	A	A	A	A
Wolf	53401	12530	5	A	A	A	A
Pig	53412	12532	5	A	A	A	A
Gingerbread	56035	13246	5	A	A	A	A
Green	63491	16287	5	A	A	A	A
Peacock	69020	17517	5	A	A	A	A
Bigfoot	53402	12530	6	A	A	A	A
Chicken Hen	53413	12532	6	A	A	A	A
Mitten	56036	13246	6	A	A	A	A
Purple	63492	16287	6	A	A	A	A
Owl	53403	12530	7	A	A	A	A
Rooster	53414	12532	7	A	A	A	A
Orange	63493	16287	7	A	A	A	A
Yellow	63494	16287	8	A	A	A	A
White	63495	16287	9	A	A	A	A