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 (
    12425, 12426, 12485, 12433, 12466, 12451, 
    12440, 12442, 12427, 12473, 12474, 
    12482, 12490
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00545

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "252.43"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "88.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": 88,
            "rows_produced_per_join": 88,
            "filtered": "100.00",
            "index_condition": "((`goimagine`.`a`.`option_id` in (12425,12426,12485,12433,12466,12451,12440,12442,12427,12473,12474,12482,12490)) and (`goimagine`.`a`.`status` = 'A'))",
            "cost_info": {
              "read_cost": "79.73",
              "eval_cost": "8.80",
              "prefix_cost": "88.53",
              "data_read_per_join": "4K"
            },
            "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": 88,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "67.11",
              "eval_cost": "8.80",
              "prefix_cost": "164.43",
              "data_read_per_join": "67K"
            },
            "used_columns": [
              "variant_id",
              "lang_code",
              "variant_name"
            ]
          }
        }
      ]
    }
  }
}

Result

variant_name	variant_id	option_id	modifier	modifier_type	weight_modifier_type	point_modifier_type	status
S	53110	12425	0.000	A	A	A	A
M	53111	12425	0.000	A	A	A	A
L	53112	12425	0.000	A	A	A	A
XL	53113	12425	0.000	A	A	A	A
2XL	53114	12425	4.000	A	A	A	A
White	53115	12426	0.000	A	A	A	A
Sport Grey	53116	12426	0.000	A	A	A	A
Dark Heather	53117	12426	0.000	A	A	A	A
Graphite Heather	53118	12426	0.000	A	A	A	A
Ash	53119	12426	0.000	A	A	A	A
Black	53120	12426	0.000	A	A	A	A
Dark Chocolate	53121	12426	0.000	A	A	A	A
Navy	53122	12426	0.000	A	A	A	A
Irish Green	53123	12426	0.000	A	A	A	A
Forest Green	53124	12426	0.000	A	A	A	A
Safety Green	53125	12426	0.000	A	A	A	A
Safety Orange	53126	12426	0.000	A	A	A	A
Purple	53127	12426	0.000	A	A	A	A
Royal	53128	12426	0.000	A	A	A	A
Carolina Blue	53129	12426	0.000	A	A	A	A
Red	53130	12426	0.000	A	A	A	A
Maroon	53131	12426	0.000	A	A	A	A
Cardinal Red	53132	12426	0.000	A	A	A	A
Brock	53186	12473	0.000	A	A	A	A
Classy	53187	12473	0.000	A	A	A	A
Bittersweet	53188	12473	0.000	A	A	A	A
Harrington	53189	12473	0.000	A	A	A	A
Ballerina	53190	12473	0.000	A	A	A	A
Brush	53191	12473	0.000	A	A	A	A
Fine	53192	12473	0.000	A	A	A	A
Double	53193	12473	0.000	A	A	A	A
French	53194	12473	0.000	A	A	A	A
Giulia	53195	12473	0.000	A	A	A	A
Disney	53196	12473	0.000	A	A	A	A
Hoedown	53197	12473	0.000	A	A	A	A
Now or Never	53198	12473	0.000	A	A	A	A
Minimilist	53199	12473	0.000	A	A	A	A
Petit Bisou	53200	12473	0.000	A	A	A	A
Circus	53201	12473	0.000	A	A	A	A
Red	53202	12474	0.000	A	A	A	A
Dark Fuchsia	53203	12474	0.000	A	A	A	A
Tangerine	53204	12474	0.000	A	A	A	A
Vermillion	53205	12474	0.000	A	A	A	A
Deep Rose	53206	12474	0.000	A	A	A	A
Pink	53207	12474	0.000	A	A	A	A
Salmon Pink	53208	12474	0.000	A	A	A	A
Flesh Pink	53209	12474	0.000	A	A	A	A
Purple	53210	12474	0.000	A	A	A	A
Lilac	53211	12474	0.000	A	A	A	A
Magenta	53212	12474	0.000	A	A	A	A
Light Lilac	53213	12474	0.000	A	A	A	A
Cornflower Blue	53214	12474	0.000	A	A	A	A
Pewter	53215	12474	0.000	A	A	A	A
Linen	53216	12474	0.000	A	A	A	A
Beige	53217	12474	0.000	A	A	A	A
Light Blue	53218	12474	0.000	A	A	A	A
Sky Blue	53219	12474	0.000	A	A	A	A
Electric Blue	53220	12474	0.000	A	A	A	A
Blue	53221	12474	0.000	A	A	A	A
Prussian Blue	53222	12474	0.000	A	A	A	A
Dark Gray	53223	12474	0.000	A	A	A	A
Black	53224	12474	0.000	A	A	A	A
Clay Brown	53225	12474	0.000	A	A	A	A
Fresh Green	53226	12474	0.000	A	A	A	A
Moss Green	53227	12474	0.000	A	A	A	A
Lime Green	53228	12474	0.000	A	A	A	A
Mint Green	53229	12474	0.000	A	A	A	A
Teal Green	53230	12474	0.000	A	A	A	A
Emerald Green	53231	12474	0.000	A	A	A	A
Light Brown	53232	12474	0.000	A	A	A	A
Dark Brown	53233	12474	0.000	A	A	A	A
Orange	53234	12474	0.000	A	A	A	A
Deep Gold	53235	12474	0.000	A	A	A	A
Yellow	53236	12474	0.000	A	A	A	A
Cream Brown	53237	12474	0.000	A	A	A	A
Brass	53238	12474	0.000	A	A	A	A
Silver	53239	12474	0.000	A	A	A	A
White	53240	12474	0.000	A	A	A	A
Snow White	53241	12474	0.000	A	A	A	A