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 (
    9533, 9532, 9531, 9534, 8593, 8592, 8507, 
    8506, 8501, 8502, 8503, 8504, 8505, 
    8495, 8496, 8498, 8497, 8499, 8500, 
    8813, 8812, 8811, 8810, 23843, 23842, 
    32869
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00772

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "587.16"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "202.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": 202,
            "rows_produced_per_join": 202,
            "filtered": "100.00",
            "index_condition": "((`goimagine`.`a`.`option_id` in (9533,9532,9531,9534,8593,8592,8507,8506,8501,8502,8503,8504,8505,8495,8496,8498,8497,8499,8500,8813,8812,8811,8810,23843,23842,32869)) and (`goimagine`.`a`.`status` = 'A'))",
            "cost_info": {
              "read_cost": "184.13",
              "eval_cost": "20.20",
              "prefix_cost": "204.33",
              "data_read_per_join": "9K"
            },
            "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": 202,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "160.64",
              "eval_cost": "20.20",
              "prefix_cost": "385.16",
              "data_read_per_join": "154K"
            },
            "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_type	status
12 x 12in diagonal weathered white sign	38054	8495	0	2.000	A	0.000	A	A	A
Mandala 1	38056	8496	0	0.000	A	0.000	A	A	A
	38064	8498	0	0.000	A	0.000	A	A	A
	38066	8500	0	0.000	A	0.000	A	A	A
Single bracelet	38067	8501	0	0.000	A	0.000	A	A	A
A	38070	8502	0	0.000	A	0.000	A	A	A
1	38072	8503	0	0.000	A	0.000	A	A	A
2	38073	8503	0	0.000	A	0.000	A	A	A
3	38074	8503	0	0.000	A	0.000	A	A	A
4	38075	8503	0	0.000	A	0.000	A	A	A
N/A	38304	8505	0	0.000	A	0.000	A	A	A
Non Adjustable	38364	8592	0	0.000	A	0.000	A	A	A
Adjustable Ear Straps with Filter Slot	38365	8592	0	1.000	A	0.000	A	A	A
Adjustable Ear Strap with Filter Slot and two Filters	38366	8592	0	2.000	A	0.000	A	A	A
White	38367	8593	0	0.000	A	0.000	A	A	A
Neon Blue	38368	8593	0	0.000	A	0.000	A	A	A
Reflective Rainbow	38369	8593	0	0.000	A	0.000	A	A	A
Reflective Silver	38370	8593	0	0.000	A	0.000	A	A	A
Holo rainbow silver	38371	8593	0	0.000	A	0.000	A	A	A
Green glow in the dark	38372	8593	0	0.000	A	0.000	A	A	A
Holo crystal silver	38373	8593	0	0.000	A	0.000	A	A	A
Red	38374	8593	0	0.000	A	0.000	A	A	A
Bright red	38375	8593	0	0.000	A	0.000	A	A	A
Metallic gold	38376	8593	0	0.000	A	0.000	A	A	A
Metallic silver	38377	8593	0	0.000	A	0.000	A	A	A
Metallic purple	38378	8593	0	0.000	A	0.000	A	A	A
Neon green	38379	8593	0	0.000	A	0.000	A	A	A
Neon pink	38380	8593	0	0.000	A	0.000	A	A	A
Glitter gold	38381	8593	0	0.000	A	0.000	A	A	A
Glitter silver	38382	8593	0	0.000	A	0.000	A	A	A
Glitter red	38383	8593	0	0.000	A	0.000	A	A	A
Chameleon purple/green	38384	8593	0	0.000	A	0.000	A	A	A
Chameleon purple/blue	38385	8593	0	0.000	A	0.000	A	A	A
Mint	38386	8593	0	0.000	A	0.000	A	A	A
Reflective Black	38530	8593	0	0.000	A	0.000	A	A	A
G1	38968	8811	0	1.000	A	0.000	A	A	A
G1	39005	8812	0	1.000	A	0.000	A	A	A
DIY No Paint	42037	9531	0	0.000	A	0.000	A	A	A
A one layer	42069	9532	0	0.000	A	0.000	A	A	A
Maple	71429	9533	0	0.000	A	0.000	A	A	A
Girl	93934	23842	0	0.000	A	0.000	A	A	A
Boy	93935	23842	0	0.000	A	0.000	A	A	A
One Layer	93936	23843	0	0.000	A	0.000	A	A	A
Two Layer	93937	23843	0	2.000	A	0.000	A	A	A
MR.	129440	32869	0	0.000	A	0.000	A	A	A
10 x 10in diagonal weathered white	38055	8495	1	0.000	A	0.000	A	A	A
Mandala 2	38057	8496	1	0.000	A	0.000	A	A	A
	38063	8498	1	3.000	A	0.000	A	A	A
	38065	8500	1	5.000	A	0.000	A	A	A
Two Bracelets(pair)	38068	8501	1	12.000	A	0.030	A	A	A
B	38071	8502	1	0.000	A	0.000	A	A	A
6in	38076	8504	1	0.000	A	0.000	A	A	A
6in	38082	8505	1	0.000	A	0.000	A	A	A
G2	38969	8811	1	1.000	A	0.000	A	A	A
G2	39006	8812	1	1.000	A	0.000	A	A	A
Burlap String for Basket	39046	8813	1	0.000	A	0.000	A	A	A
Engraved Details No Seal	42038	9531	1	0.500	A	0.000	A	A	A
B one layer	42070	9532	1	0.000	A	0.000	A	A	A
Walnut	42071	9533	1	1.000	A	0.000	A	A	A
MRS.	129441	32869	1	0.000	A	0.000	A	A	A
Mandala 3	38058	8496	2	0.000	A	0.000	A	A	A
C	38069	8502	2	0.000	A	0.000	A	A	A
6.5in	38077	8504	2	0.000	A	0.000	A	A	A
6.5in	38083	8505	2	0.000	A	0.000	A	A	A
G3	38970	8811	2	1.000	A	0.000	A	A	A
G3	39007	8812	2	1.000	A	0.000	A	A	A
1	39044	8813	2	1.000	A	0.000	A	A	A
A1. Black	42039	9531	2	1.000	A	0.000	A	A	A
C one layer	71430	9532	2	0.000	A	0.000	A	A	A
MS.	129442	32869	2	0.000	A	0.000	A	A	A
Mandala 4	38059	8496	3	0.000	A	0.000	A	A	A
7in	38078	8504	3	0.000	A	0.000	A	A	A
7in	38084	8505	3	0.000	A	0.000	A	A	A
G4	38971	8811	3	1.000	A	0.000	A	A	A
G4	39008	8812	3	1.000	A	0.000	A	A	A
2	39047	8813	3	1.000	A	0.000	A	A	A
A2. Tan	42040	9531	3	1.000	A	0.000	A	A	A
D two layers	71431	9532	3	2.000	A	0.000	A	A	A
MISS	129443	32869	3	0.000	A	0.000	A	A	A
Mandala 5	38060	8496	4	0.000	A	0.000	A	A	A
7.5in	38079	8504	4	0.000	A	0.000	A	A	A
7.5in	38085	8505	4	0.000	A	0.000	A	A	A
G5	38972	8811	4	1.000	A	0.000	A	A	A
G5	39009	8812	4	1.000	A	0.000	A	A	A
3	39048	8813	4	1.000	A	0.000	A	A	A
A3. Grey	42041	9531	4	1.000	A	0.000	A	A	A
E two Layers	71432	9532	4	2.000	A	0.000	A	A	A
MISTER	129444	32869	4	0.000	A	0.000	A	A	A
Mandala 6	38061	8496	5	0.000	A	0.000	A	A	A
8in	38080	8504	5	0.000	A	0.000	A	A	A
8in	38086	8505	5	0.000	A	0.000	A	A	A
G6	38973	8811	5	1.000	A	0.000	A	A	A
G6	39010	8812	5	1.000	A	0.000	A	A	A
4	39049	8813	5	1.000	A	0.000	A	A	A
A4. White	42042	9531	5	1.000	A	0.000	A	A	A
F two Layers	71433	9532	5	2.000	A	0.000	A	A	A
PROFESSOR	129445	32869	5	0.000	A	0.000	A	A	A
Mandala 7	38062	8496	6	0.000	A	0.000	A	A	A
8.5in	38081	8504	6	0.000	A	0.000	A	A	A
8.5in	38087	8505	6	0.000	A	0.000	A	A	A
G7	38974	8811	6	1.000	A	0.000	A	A	A
G7	39011	8812	6	1.000	A	0.000	A	A	A
5	39050	8813	6	1.000	A	0.000	A	A	A
A5. Pink	42043	9531	6	1.000	A	0.000	A	A	A
DR.	129446	32869	6	0.000	A	0.000	A	A	A
M1	38975	8811	7	1.000	A	0.000	A	A	A
M1	39012	8812	7	1.000	A	0.000	A	A	A
6	39051	8813	7	1.000	A	0.000	A	A	A
B1. Red	42044	9531	7	1.000	A	0.000	A	A	A
COACH	129447	32869	7	0.000	A	0.000	A	A	A
M2	38976	8811	8	1.000	A	0.000	A	A	A
M2	39013	8812	8	1.000	A	0.000	A	A	A
7	39052	8813	8	1.000	A	0.000	A	A	A
B2. Orange	42045	9531	8	1.000	A	0.000	A	A	A
M3	38977	8811	9	1.000	A	0.000	A	A	A
M3	39014	8812	9	1.000	A	0.000	A	A	A
8	39045	8813	9	1.000	A	0.000	A	A	A
B3. Pumpkin	42046	9531	9	1.000	A	0.000	A	A	A
P1	38978	8811	10	1.000	A	0.000	A	A	A
P1	39015	8812	10	1.000	A	0.000	A	A	A
B4. Cream	42047	9531	10	1.000	A	0.000	A	A	A
P2	38979	8811	11	1.000	A	0.000	A	A	A
P2	39016	8812	11	1.000	A	0.000	A	A	A
B5. Yellow	42048	9531	11	1.000	A	0.000	A	A	A
F1	38980	8811	12	0.000	A	0.000	A	A	A
F1	39017	8812	12	0.000	A	0.000	A	A	A
C1. Mint	42049	9531	12	1.000	A	0.000	A	A	A
F2	38981	8811	13	0.500	A	0.000	A	A	A
F2	39018	8812	13	0.000	A	0.000	A	A	A
C2. Green	42050	9531	13	1.000	A	0.000	A	A	A
F3	38982	8811	14	0.000	A	0.000	A	A	A
F3	39019	8812	14	0.000	A	0.000	A	A	A
C3. Sky Blue	42051	9531	14	1.000	A	0.000	A	A	A
T1	38983	8811	15	0.000	A	0.000	A	A	A
T1	39020	8812	15	0.000	A	0.000	A	A	A
C4. Royal Blue	42052	9531	15	1.000	A	0.000	A	A	A
T2	38984	8811	16	0.000	A	0.000	A	A	A
T2	39021	8812	16	0.000	A	0.000	A	A	A
C5. Purple	42053	9531	16	1.000	A	0.000	A	A	A
T3	38985	8811	17	0.000	A	0.000	A	A	A
T3	39022	8812	17	0.000	A	0.000	A	A	A
D1. Pastel Purple	42054	9531	17	1.000	A	0.000	A	A	A
T4	38986	8811	18	0.000	A	0.000	A	A	A
T4	39023	8812	18	0.000	A	0.000	A	A	A
D2. Pastel Blue	42055	9531	18	1.000	A	0.000	A	A	A
T5	38987	8811	19	0.000	A	0.000	A	A	A
T5	39024	8812	19	0.000	A	0.000	A	A	A
D3. Pastel Green	42056	9531	19	1.000	A	0.000	A	A	A
T6	39025	8812	20	0.000	A	0.000	A	A	A
T6	39043	8811	20	0.000	A	0.000	A	A	A
D4. Pastel Yellow	42057	9531	20	1.000	A	0.000	A	A	A
T7	38989	8811	21	0.000	A	0.000	A	A	A
T7	39026	8812	21	0.000	A	0.000	A	A	A
D5. Pastel Orange	42058	9531	21	1.000	A	0.000	A	A	A
T8	38990	8811	22	0.000	A	0.000	A	A	A
T8	39027	8812	22	0.000	A	0.000	A	A	A
E1. Pastel Red	42059	9531	22	1.000	A	0.000	A	A	A
T9	38991	8811	23	0.000	A	0.000	A	A	A
T9	39028	8812	23	0.000	A	0.000	A	A	A
E2. Pastel Pink	42060	9531	23	1.000	A	0.000	A	A	A
T10	38992	8811	24	0.000	A	0.000	A	A	A
T10	39029	8812	24	0.000	A	0.000	A	A	A
E3. Wine	42061	9531	24	1.000	A	0.000	A	A	A
T11	38988	8811	25	0.000	A	0.000	A	A	A
T11	39030	8812	25	0.000	A	0.000	A	A	A
E4. Rose Red	42062	9531	25	1.000	A	0.000	A	A	A
T12	38993	8811	26	0.000	A	0.000	A	A	A
T12	39031	8812	26	0.000	A	0.000	A	A	A
E5. Navy Blue	42063	9531	26	1.000	A	0.000	A	A	A
C1	38994	8811	27	0.000	A	0.000	A	A	A
C1	39032	8812	27	0.000	A	0.000	A	A	A
F1. Dark Brown	42064	9531	27	1.000	A	0.000	A	A	A
C2	38995	8811	28	0.000	A	0.000	A	A	A
C2	39042	8812	28	0.000	A	0.000	A	A	A
F2. Olive Green	42065	9531	28	1.000	A	0.000	A	A	A
C3	38996	8811	29	0.000	A	0.000	A	A	A
C3	39034	8812	29	0.000	A	0.000	A	A	A
F3. Metallic Gold	42066	9531	29	1.000	A	0.000	A	A	A
C4	38997	8811	30	0.000	A	0.000	A	A	A
C4	39035	8812	30	0.000	A	0.000	A	A	A
F4. Metallic Silver	42067	9531	30	1.000	A	0.000	A	A	A
C5	38998	8811	31	0.000	A	0.000	A	A	A
C5	39036	8812	31	0.000	A	0.000	A	A	A
F5. Sealed	42068	9531	31	1.000	A	0.000	A	A	A
C6	38999	8811	32	0.000	A	0.000	A	A	A
C6	39037	8812	32	0.000	A	0.000	A	A	A
C7	39000	8811	33	0.000	A	0.000	A	A	A
C7	39038	8812	33	0.000	A	0.000	A	A	A
C8	39001	8811	34	0.000	A	0.000	A	A	A
C8	39033	8812	34	0.000	A	0.000	A	A	A
C9	39002	8811	35	0.000	A	0.000	A	A	A
C9	39039	8812	35	0.000	A	0.000	A	A	A
A1	39003	8811	36	0.000	A	0.000	A	A	A
A1	39040	8812	36	0.000	A	0.000	A	A	A
A2	39004	8811	37	0.000	A	0.000	A	A	A
A2	39041	8812	37	0.000	A	0.000	A	A	A