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 (
    10137, 10139, 10140, 10138, 10141, 10447, 
    10145, 10146, 10279, 10394, 10395, 
    10278, 23086, 10892, 10894, 23255, 
    23257, 10890, 10893, 18380, 11163, 
    23383, 25502, 20936, 20933, 20937, 
    20938, 33070, 33040, 31832
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.02035

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "377.44"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "135.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": 135,
            "rows_produced_per_join": 135,
            "filtered": "100.00",
            "index_condition": "((`goimagine`.`a`.`option_id` in (10137,10139,10140,10138,10141,10447,10145,10146,10279,10394,10395,10278,23086,10892,10894,23255,23257,10890,10893,18380,11163,23383,25502,20936,20933,20937,20938,33070,33040,31832)) and (`goimagine`.`a`.`status` = 'A'))",
            "cost_info": {
              "read_cost": "119.28",
              "eval_cost": "13.50",
              "prefix_cost": "132.78",
              "data_read_per_join": "6K"
            },
            "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": 135,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "96.16",
              "eval_cost": "13.50",
              "prefix_cost": "242.44",
              "data_read_per_join": "103K"
            },
            "used_columns": [
              "variant_id",
              "lang_code",
              "variant_name"
            ]
          }
        }
      ]
    }
  }
}

Result

variant_name	variant_id	option_id	position	modifier	modifier_type	weight_modifier_type	point_modifier_type	status
Blue	44487	10137	0	0.000	A	A	A	A
Beige	44488	10137	0	0.000	A	A	A	A
Bronze	44489	10137	0	0.000	A	A	A	A
Brown	44490	10137	0	0.000	A	A	A	A
Copper	44491	10137	0	0.000	A	A	A	A
Gold	44492	10137	0	0.000	A	A	A	A
Green	44493	10137	0	0.000	A	A	A	A
Orange	44494	10137	0	0.000	A	A	A	A
Pink	44495	10137	0	0.000	A	A	A	A
Purple	44496	10137	0	0.000	A	A	A	A
Red	44497	10137	0	0.000	A	A	A	A
Silver	44498	10137	0	0.000	A	A	A	A
Yellow	44499	10137	0	0.000	A	A	A	A
Black	44500	10137	0	0.000	A	A	A	A
Grey	44501	10137	0	0.000	A	A	A	A
White	44502	10137	0	0.000	A	A	A	A
Unfinished	44503	10137	0	0.000	A	A	A	A
Light natural wood	44504	10137	0	0.000	A	A	A	A
Dark natural wood	44505	10137	0	0.000	A	A	A	A
Multi color (2 colors)	44506	10137	0	1.000	A	A	A	A
Multi color ( all different colors)	44507	10137	0	2.000	A	A	A	A
Pastel (1 or 2 color)	44508	10137	0	3.000	A	A	A	A
Pastel ( all different color)	44509	10137	0	4.000	A	A	A	A
	44528	10141	0	0.000	A	A	A	A
Blue	44535	10146	0	0.000	A	A	A	A
Red	44536	10146	0	0.000	A	A	A	A
Yellow	44537	10146	0	0.000	A	A	A	A
Black	44538	10146	0	0.000	A	A	A	A
Pink	44539	10146	0	0.000	A	A	A	A
Green	44540	10146	0	0.000	A	A	A	A
Gold	44541	10146	0	0.000	A	A	A	A
Pink	44542	10146	0	0.000	A	A	A	A
Orange	44543	10146	0	0.000	A	A	A	A
Silver	44544	10146	0	0.000	A	A	A	A
Purple	44545	10146	0	0.000	A	A	A	A
Coral	44546	10146	0	0.000	A	A	A	A
Brown	44547	10146	0	0.000	A	A	A	A
White	44548	10146	0	0.000	A	A	A	A
Bronze	44549	10146	0	0.000	A	A	A	A
Unfinished	44550	10146	0	0.000	A	A	A	A
Birch	47551	11163	0	0.000	A	A	A	A
Red oak	47552	11163	0	0.000	A	A	A	A
Mahogany	47553	11163	0	0.000	A	A	A	A
Poplar	47554	11163	0	0.000	A	A	A	A
Birch plywood	47555	11163	0	0.000	A	A	A	A
Angel	72303	18380	0	0.000	A	A	A	A
Candle	72304	18380	0	0.000	A	A	A	A
Candy	72305	18380	0	0.000	A	A	A	A
Gift	72306	18380	0	0.000	A	A	A	A
Gingerbread man	72307	18380	0	0.000	A	A	A	A
Hat	72308	18380	0	0.000	A	A	A	A
Snow man	72309	18380	0	0.000	A	A	A	A
Stocking	72310	18380	0	0.000	A	A	A	A
Tree	72311	18380	0	0.000	A	A	A	A
Hot drink	72370	18380	0	0.000	A	A	A	A
Reindeer	72371	18380	0	0.000	A	A	A	A
Snowflake	72372	18380	0	0.000	A	A	A	A
Name of dog	91944	23255	0	3.000	A	A	A	A
Walk me	91950	23255	0	0.000	A	A	A	A
9 1/2” tall	101073	25502	0	0.000	A	A	A	A
12” tall	101074	25502	0	7.000	A	A	A	A
18” tall	101075	25502	0	10.000	A	A	A	A
24” tall	101076	25502	0	15.000	A	A	A	A
	44527	10141	1	5.000	A	A	A	A
Light wood	44949	10279	1	0.000	A	A	A	A
9 pcs 4x6	45453	10394	1	0.000	A	A	A	A
3 letters	70345	10140	1	0.000	A	A	A	A
Bow (girl)	82167	20938	1	0.000	A	A	A	A
1/2”	91154	23086	1	0.000	A	A	A	A
4 letters	44510	10140	2	4.000	A	A	A	A
Dark wood	44950	10279	2	0.000	A	A	A	A
20 pcs 4x6	45454	10394	2	4.000	A	A	A	A
Bow tie (boy)	82168	20938	2	0.000	A	A	A	A
5/8”	91155	23086	2	0.000	A	A	A	A
5 letters	44511	10140	3	8.000	A	A	A	A
30 pcs 4x6	45455	10394	3	8.000	A	A	A	A
None	82169	20938	3	0.000	A	A	A	A
3/4”	91156	23086	3	0.000	A	A	A	A
6 letters	44512	10140	4	12.000	A	A	A	A
42 pcs 4x6	45456	10394	4	12.000	A	A	A	A
7 letters	44513	10140	5	16.000	A	A	A	A
56 pcs 4x6	45457	10394	5	20.000	A	A	A	A
8 letters	44514	10140	6	20.000	A	A	A	A
72 pcs 4x6	45458	10394	6	28.000	A	A	A	A
9 letters	44515	10140	7	24.000	A	A	A	A
90 pcs 4x6	45459	10394	7	36.000	A	A	A	A
10 letters	44516	10140	8	28.000	A	A	A	A
110 pcs 4x6	45460	10394	8	42.000	A	A	A	A
11 letters	44517	10140	9	32.000	A	A	A	A
9 pcs 5x7	45461	10394	9	4.000	A	A	A	A
12 letters	44518	10140	10	36.000	A	A	A	A
16 pcs 5x7	45462	10394	10	8.000	A	A	A	A
Ship	45635	10447	10	0.000	A	A	A	A
Unfinished	130482	33040	10	0.000	A	A	A	A
13 letters	44519	10140	11	38.000	A	A	A	A
25 pcs 5x7	45463	10394	11	12.000	A	A	A	A
14 letters	44520	10140	12	42.000	A	A	A	A
36 pcs 5x7	45464	10394	12	16.000	A	A	A	A
15 letters	44521	10140	13	46.000	A	A	A	A
49 pcs 5x7	45465	10394	13	20.000	A	A	A	A
16 letters	44522	10140	14	50.000	A	A	A	A
64 pcs 5x7	45466	10394	14	25.000	A	A	A	A
17 letters	44523	10140	15	54.000	A	A	A	A
81 pcs 5x7	45467	10394	15	35.000	A	A	A	A
18 letters	44524	10140	16	58.000	A	A	A	A
100 pcs 5x7	137329	10394	16	44.000	A	A	A	A
19 letters	44525	10140	17	62.000	A	A	A	A
6 pcs 8x10	45468	10394	17	15.000	A	A	A	A
20 letters	44526	10140	18	66.000	A	A	A	A
12 pcs 8x10	45469	10394	18	18.000	A	A	A	A
20 pcs 8x10	45470	10394	19	20.000	A	A	A	A
35 pcs 8x10	45471	10394	20	22.000	A	A	A	A
Linseed oil finish	130483	33040	20	10.000	A	A	A	A
Pickup	130484	10447	20	-3.000	A	A	A	A
45 pcs 8x10	45472	10394	21	25.000	A	A	A	A
63 pcs 8x10	45473	10394	22	30.000	A	A	A	A
88 pcs 8x10	45474	10394	23	35.000	A	A	A	A
108 pcs 8x10	45475	10394	24	40.000	A	A	A	A
130 pcs 8x10	45476	10394	25	45.000	A	A	A	A