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 (
    90994, 90981, 90549, 90370, 87446, 91036, 
    90921, 90198, 90197, 90989, 90922, 
    90340, 90339, 89299, 90978, 90945, 
    90944, 90943, 90942, 90941
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00120

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		40	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	175428	87446	1	0.000	A	A	A	A
MP3	179134	89299	1	0.000	A	A	A	A
MP3	180930	90197	1	0.000	A	A	A	A
MP3	180932	90198	1	0.000	A	A	A	A
MP3	181214	90339	1	0.000	A	A	A	A
MP3	181216	90340	1	0.000	A	A	A	A
MP3	181276	90370	1	0.000	A	A	A	A
MP3	181634	90549	1	0.000	A	A	A	A
MP3	182378	90921	1	0.000	A	A	A	A
MP3	182380	90922	1	0.000	A	A	A	A
MP3	182418	90941	1	0.000	A	A	A	A
MP3	182420	90942	1	0.000	A	A	A	A
MP3	182422	90943	1	0.000	A	A	A	A
MP3	182424	90944	1	0.000	A	A	A	A
MP3	182426	90945	1	0.000	A	A	A	A
MP3	182492	90978	1	0.000	A	A	A	A
MP3	182498	90981	1	0.000	A	A	A	A
MP3	182514	90989	1	0.000	A	A	A	A
MP3	182524	90994	1	0.000	A	A	A	A
MP3	182608	91036	1	0.000	A	A	A	A
WAV	175429	87446	2	0.300	A	A	A	A
WAV	179135	89299	2	0.300	A	A	A	A
WAV	180931	90197	2	0.300	A	A	A	A
WAV	180933	90198	2	0.300	A	A	A	A
WAV	181215	90339	2	0.300	A	A	A	A
WAV	181217	90340	2	0.300	A	A	A	A
WAV	181277	90370	2	0.300	A	A	A	A
WAV	181635	90549	2	0.300	A	A	A	A
WAV	182379	90921	2	0.300	A	A	A	A
WAV	182381	90922	2	0.300	A	A	A	A
WAV	182419	90941	2	0.300	A	A	A	A
WAV	182421	90942	2	0.300	A	A	A	A
WAV	182423	90943	2	0.300	A	A	A	A
WAV	182425	90944	2	0.300	A	A	A	A
WAV	182427	90945	2	0.300	A	A	A	A
WAV	182493	90978	2	0.300	A	A	A	A
WAV	182499	90981	2	0.300	A	A	A	A
WAV	182515	90989	2	0.300	A	A	A	A
WAV	182525	90994	2	0.300	A	A	A	A
WAV	182609	91036	2	0.300	A	A	A	A