Sandbox

SELECT 
  b.variant_name, 
  a.*, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier, 
    a.modifier
  ) as modifier, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier_type, 
    a.modifier_type
  ) as modifier_type 
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' 
  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id 
  AND shared_option_variants.company_id = 1 
WHERE 
  1 
  AND a.option_id IN (
    64857, 64856, 64855, 64704, 64694, 64647, 
    64597, 64751, 64750, 64749, 64747, 
    64692, 64656, 64256, 63966, 63102, 
    63101, 63100, 63099, 63098, 63097, 
    63096, 63095, 63094, 63093, 63092, 
    63091, 63090, 63089, 63088, 63087, 
    63086, 63085, 63084, 63083, 64362, 
    64677, 64595, 64262, 64100
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00169

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	status,option_id,option_id_2	option_id	6		80	Using index condition; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	9	toolboxdigitalshop_dev.a.variant_id,const	1	Using where
1	SIMPLE	shared_option_variants	eq_ref	PRIMARY,company_id	PRIMARY	7	toolboxdigitalshop_dev.a.variant_id,const	1

Result

variant_name	variant_id	option_id	position	modifier	modifier_type	weight_modifier_type	point_modifier_type	status
MP3	126234	63083	1	0.000	A	A	A	A
MP3	126236	63084	1	0.000	A	A	A	A
MP3	126238	63085	1	0.000	A	A	A	A
MP3	126240	63086	1	0.000	A	A	A	A
MP3	126242	63087	1	0.000	A	A	A	A
MP3	126244	63088	1	0.000	A	A	A	A
MP3	126246	63089	1	0.000	A	A	A	A
MP3	126248	63090	1	0.000	A	A	A	A
MP3	126250	63091	1	0.000	A	A	A	A
MP3	126252	63092	1	0.000	A	A	A	A
MP3	126254	63093	1	0.000	A	A	A	A
MP3	126256	63094	1	0.000	A	A	A	A
MP3	126258	63095	1	0.000	A	A	A	A
MP3	126260	63096	1	0.000	A	A	A	A
MP3	126262	63097	1	0.000	A	A	A	A
MP3	126264	63098	1	0.000	A	A	A	A
MP3	126266	63099	1	0.000	A	A	A	A
MP3	126268	63100	1	0.000	A	A	A	A
MP3	126270	63101	1	0.000	A	A	A	A
MP3	126272	63102	1	0.000	A	A	A	A
MP3	128000	63966	1	0.000	A	A	A	A
MP3	128268	64100	1	0.000	A	A	A	A
MP3	128580	64256	1	0.000	A	A	A	A
MP3	128592	64262	1	0.000	A	A	A	A
MP3	128792	64362	1	0.000	A	A	A	A
MP3	129258	64595	1	0.000	A	A	A	A
MP3	129262	64597	1	0.000	A	A	A	A
MP3	129362	64647	1	0.000	A	A	A	A
MP3	129380	64656	1	0.000	A	A	A	A
MP3	129422	64677	1	0.000	A	A	A	A
MP3	129452	64692	1	0.000	A	A	A	A
MP3	129456	64694	1	0.000	A	A	A	A
MP3	129476	64704	1	0.000	A	A	A	A
MP3	129562	64747	1	0.000	A	A	A	A
MP3	129566	64749	1	0.000	A	A	A	A
MP3	129568	64750	1	0.000	A	A	A	A
MP3	129570	64751	1	0.000	A	A	A	A
MP3	129778	64855	1	0.000	A	A	A	A
MP3	129780	64856	1	0.000	A	A	A	A
MP3	129782	64857	1	0.000	A	A	A	A
WAV	126235	63083	2	0.300	A	A	A	A
WAV	126237	63084	2	0.300	A	A	A	A
WAV	126239	63085	2	0.300	A	A	A	A
WAV	126241	63086	2	0.300	A	A	A	A
WAV	126243	63087	2	0.300	A	A	A	A
WAV	126245	63088	2	0.300	A	A	A	A
WAV	126247	63089	2	0.300	A	A	A	A
WAV	126249	63090	2	0.300	A	A	A	A
WAV	126251	63091	2	0.300	A	A	A	A
WAV	126253	63092	2	0.300	A	A	A	A
WAV	126255	63093	2	0.300	A	A	A	A
WAV	126257	63094	2	0.300	A	A	A	A
WAV	126259	63095	2	0.300	A	A	A	A
WAV	126261	63096	2	0.300	A	A	A	A
WAV	126263	63097	2	0.300	A	A	A	A
WAV	126265	63098	2	0.300	A	A	A	A
WAV	126267	63099	2	0.300	A	A	A	A
WAV	126269	63100	2	0.300	A	A	A	A
WAV	126271	63101	2	0.300	A	A	A	A
WAV	126273	63102	2	0.300	A	A	A	A
WAV	128001	63966	2	0.300	A	A	A	A
WAV	128269	64100	2	0.300	A	A	A	A
WAV	128581	64256	2	0.300	A	A	A	A
WAV	128593	64262	2	0.300	A	A	A	A
WAV	128793	64362	2	0.300	A	A	A	A
WAV	129259	64595	2	0.300	A	A	A	A
WAV	129263	64597	2	0.300	A	A	A	A
WAV	129363	64647	2	0.300	A	A	A	A
WAV	129381	64656	2	0.300	A	A	A	A
WAV	129423	64677	2	0.300	A	A	A	A
WAV	129453	64692	2	0.300	A	A	A	A
WAV	129457	64694	2	0.300	A	A	A	A
WAV	129477	64704	2	0.300	A	A	A	A
WAV	129563	64747	2	0.300	A	A	A	A
WAV	129567	64749	2	0.300	A	A	A	A
WAV	129569	64750	2	0.300	A	A	A	A
WAV	129571	64751	2	0.300	A	A	A	A
WAV	129779	64855	2	0.300	A	A	A	A
WAV	129781	64856	2	0.300	A	A	A	A
WAV	129783	64857	2	0.300	A	A	A	A