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 (
    91515, 87455, 92251, 92524, 92523, 92522, 
    92467, 92466, 92465, 92464, 92463, 
    92455, 92454, 92414, 92413, 92412, 
    92411, 92410, 92409, 92408
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00071

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	175446	87455	1	0.000	A	A	A	A
MP3	183566	91515	1	0.000	A	A	A	A
MP3	185038	92251	1	0.000	A	A	A	A
MP3	185352	92408	1	0.000	A	A	A	A
MP3	185354	92409	1	0.000	A	A	A	A
MP3	185356	92410	1	0.000	A	A	A	A
MP3	185358	92411	1	0.000	A	A	A	A
MP3	185360	92412	1	0.000	A	A	A	A
MP3	185362	92413	1	0.000	A	A	A	A
MP3	185364	92414	1	0.000	A	A	A	A
MP3	185444	92454	1	0.000	A	A	A	A
MP3	185446	92455	1	0.000	A	A	A	A
MP3	185462	92463	1	0.000	A	A	A	A
MP3	185464	92464	1	0.000	A	A	A	A
MP3	185466	92465	1	0.000	A	A	A	A
MP3	185468	92466	1	0.000	A	A	A	A
MP3	185470	92467	1	0.000	A	A	A	A
MP3	185580	92522	1	0.000	A	A	A	A
MP3	185582	92523	1	0.000	A	A	A	A
MP3	185584	92524	1	0.000	A	A	A	A
WAV	175447	87455	2	0.300	A	A	A	A
WAV	183567	91515	2	0.300	A	A	A	A
WAV	185039	92251	2	0.300	A	A	A	A
WAV	185353	92408	2	0.300	A	A	A	A
WAV	185355	92409	2	0.300	A	A	A	A
WAV	185357	92410	2	0.300	A	A	A	A
WAV	185359	92411	2	0.300	A	A	A	A
WAV	185361	92412	2	0.300	A	A	A	A
WAV	185363	92413	2	0.300	A	A	A	A
WAV	185365	92414	2	0.300	A	A	A	A
WAV	185445	92454	2	0.300	A	A	A	A
WAV	185447	92455	2	0.300	A	A	A	A
WAV	185463	92463	2	0.300	A	A	A	A
WAV	185465	92464	2	0.300	A	A	A	A
WAV	185467	92465	2	0.300	A	A	A	A
WAV	185469	92466	2	0.300	A	A	A	A
WAV	185471	92467	2	0.300	A	A	A	A
WAV	185581	92522	2	0.300	A	A	A	A
WAV	185583	92523	2	0.300	A	A	A	A
WAV	185585	92524	2	0.300	A	A	A	A