Sandbox

SELECT 
  b.variant_name, 
  a.* 
FROM 
  cscart_product_option_variants AS a 
  LEFT JOIN cscart_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 (363, 364) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00165

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "164.31"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "91.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": 91,
            "rows_produced_per_join": 91,
            "filtered": "100.00",
            "index_condition": "((`cscartdb`.`a`.`option_id` in (363,364)) and (`cscartdb`.`a`.`status` = 'A'))",
            "cost_info": {
              "read_cost": "32.36",
              "eval_cost": "9.10",
              "prefix_cost": "41.46",
              "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",
              "note_required"
            ]
          }
        },
        {
          "table": {
            "table_name": "b",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "variant_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "cscartdb.a.variant_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 91,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "22.75",
              "eval_cost": "9.10",
              "prefix_cost": "73.31",
              "data_read_per_join": "69K"
            },
            "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
None	12365	364	1	0.000	A	A	A	A
Surprise Me!	12304	363	2	0.000	A	A	A	A
Surprise Me!	12366	364	2	0.000	A	A	A	A
Neon / UV-reactive Yellow	12305	363	3	0.000	A	A	A	A
Glow in the Dark Blue	12367	364	3	10.850	A	A	A	A
Neon / UV-reactive Pink	12306	363	4	0.000	A	A	A	A
Glow in the Dark Green	12368	364	4	10.850	A	A	A	A
Neon / UV-reactive Green	12307	363	5	0.000	A	A	A	A
Neon / UV-reactive Green	12369	364	5	0.000	A	A	A	A
Neon / UV-reactive Blue	12308	363	6	0.000	A	A	A	A
Neon / UV-reactive Yellow	12370	364	6	0.000	A	A	A	A
Glow in the Dark Green	12309	363	7	10.850	A	A	A	A
Neon / UV-reactive Blue	12371	364	7	0.000	A	A	A	A
Glow in the Dark Blue	12310	363	8	10.850	A	A	A	A
Neon / UV-reactive Pink	12372	364	8	0.000	A	A	A	A
Chestnut Brown	12311	363	9	0.000	A	A	A	A
Beige	12373	364	9	0.000	A	A	A	A
Tropical Temptations	12312	363	10	0.000	A	A	A	A
Black	12374	364	10	0.000	A	A	A	A
Electric Blue	12313	363	11	0.000	A	A	A	A
Blue	12375	364	11	0.000	A	A	A	A
Beige	12314	363	12	0.000	A	A	A	A
Bronze	12376	364	12	0.000	A	A	A	A
Black	12315	363	13	0.000	A	A	A	A
Brown	12377	364	13	0.000	A	A	A	A
Blue	12316	363	14	0.000	A	A	A	A
Copper	12378	364	14	0.000	A	A	A	A
Bronze	12317	363	15	0.000	A	A	A	A
Gold	12379	364	15	0.000	A	A	A	A
Brown	12318	363	16	0.000	A	A	A	A
Grey	12380	364	16	0.000	A	A	A	A
Copper	12319	363	17	0.000	A	A	A	A
Green	12381	364	17	0.000	A	A	A	A
Gold	12320	363	18	0.000	A	A	A	A
Orange	12382	364	18	0.000	A	A	A	A
Grey	12321	363	19	0.000	A	A	A	A
Pink	12383	364	19	0.000	A	A	A	A
Green	12322	363	20	0.000	A	A	A	A
Purple	12384	364	20	0.000	A	A	A	A
Orange	12323	363	21	0.000	A	A	A	A
Red	12385	364	21	0.000	A	A	A	A
Pink	12324	363	22	0.000	A	A	A	A
Silver	12386	364	22	0.000	A	A	A	A
Purple	12325	363	23	0.000	A	A	A	A
White	12387	364	23	0.000	A	A	A	A
Red	12326	363	24	0.000	A	A	A	A
Yellow	12388	364	24	0.000	A	A	A	A
Silver	12327	363	25	0.000	A	A	A	A
Sparkling Gold	12389	364	25	0.000	A	A	A	A
White	12328	363	26	0.000	A	A	A	A
Arctic White	12390	364	26	0.000	A	A	A	A
Yellow	12329	363	27	0.000	A	A	A	A
Icicle White	12391	364	27	0.000	A	A	A	A
Sparkling Gold	12330	363	28	0.000	A	A	A	A
Créme de la Créme	12392	364	28	0.000	A	A	A	A
Arctic White	12331	363	29	0.000	A	A	A	A
Lemon sherbert sparkle	12393	364	29	0.000	A	A	A	A
Icicle White	12332	363	30	0.000	A	A	A	A
Bonny Buttercup Sparkle	12394	364	30	0.000	A	A	A	A
Créme de la Créme	12333	363	31	0.000	A	A	A	A
Golden Pumpkin	12395	364	31	0.000	A	A	A	A
Lemon sherbert sparkle	12334	363	32	0.000	A	A	A	A
Lime	12396	364	32	0.000	A	A	A	A
Bonny Buttercup Sparkle	12335	363	33	0.000	A	A	A	A
Pistachio	12397	364	33	0.000	A	A	A	A
Golden Pumpkin	12336	363	34	0.000	A	A	A	A
Evergreen	12398	364	34	0.000	A	A	A	A
Lime	12337	363	35	0.000	A	A	A	A
Emerald Lagoon	12399	364	35	0.000	A	A	A	A
Pistachio	12338	363	36	0.000	A	A	A	A
Aquarius	12400	364	36	0.000	A	A	A	A
Evergreen	12339	363	37	0.000	A	A	A	A
Silver Sparks	12401	364	37	0.000	A	A	A	A
Emerald Lagoon	12340	363	38	0.000	A	A	A	A
Misty Blue	12402	364	38	0.000	A	A	A	A
Aquarius	12341	363	39	0.000	A	A	A	A
Almost Ice	12403	364	39	0.000	A	A	A	A
Silver Sparks	12342	363	40	0.000	A	A	A	A
Electric Blue	12404	364	40	0.000	A	A	A	A
Misty Blue	12343	363	41	0.000	A	A	A	A
Dreamy Aquamarine	12405	364	41	0.000	A	A	A	A
Almost Ice	12344	363	42	0.000	A	A	A	A
Tropical Temptations	12406	364	42	0.000	A	A	A	A
Electric Blue	12345	363	43	0.000	A	A	A	A
Nebula Silver	12407	364	43	0.000	A	A	A	A
Dreamy Aquamarine	12346	363	44	0.000	A	A	A	A
Sapphire	12408	364	44	0.000	A	A	A	A
Tropical Temptations	12347	363	45	0.000	A	A	A	A
Tanzanite Gem Purple	12409	364	45	0.000	A	A	A	A
Nebula Silver	12348	363	46	0.000	A	A	A	A
Virtuous Violet	12410	364	46	0.000	A	A	A	A
Sapphire	12349	363	47	0.000	A	A	A	A
Soft Amethyst Purple	12411	364	47	0.000	A	A	A	A
Tanzanite Gem Purple	12350	363	48	0.000	A	A	A	A
Purple Heart	12412	364	48	0.000	A	A	A	A
Virtuous Violet	12351	363	49	0.000	A	A	A	A
Burlesque purple	12413	364	49	0.000	A	A	A	A
Soft Amethyst Purple	12352	363	50	0.000	A	A	A	A
Silken Deep Rose	12414	364	50	0.000	A	A	A	A
Purple Heart	12353	363	51	0.000	A	A	A	A
Fiery Fusion Pink	12415	364	51	0.000	A	A	A	A
Burlesque purple	12354	363	52	0.000	A	A	A	A
Candy pink	12416	364	52	0.000	A	A	A	A
Silken Deep Rose	12355	363	53	0.000	A	A	A	A
Sugar Plum purple	12417	364	53	0.000	A	A	A	A
Fiery Fusion Pink	12356	363	54	0.000	A	A	A	A
Coppery Blush	12418	364	54	0.000	A	A	A	A
Candy pink	12357	363	55	0.000	A	A	A	A
Tigers Eye Orange	12419	364	55	0.000	A	A	A	A
Sugar Plum purple	12358	363	56	0.000	A	A	A	A
Chock n Ice	12420	364	56	0.000	A	A	A	A
Coppery Blush	12359	363	57	0.000	A	A	A	A
Chestnut Brown	12421	364	57	0.000	A	A	A	A
Tigers Eye Orange	12360	363	58	0.000	A	A	A	A
Steely Grey	12422	364	58	0.000	A	A	A	A
Chock n Ice	12361	363	59	0.000	A	A	A	A
Moonkissed Nights	12423	364	59	0.000	A	A	A	A
Chestnut Brown	12362	363	60	0.000	A	A	A	A
Steely Grey	12363	363	61	0.000	A	A	A	A
Moonkissed Nights	12364	363	62	0.000	A	A	A	A