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 (
    88437, 87434, 87207, 88433, 88430, 88429, 
    88428, 88426, 88407, 88406, 88405, 
    88402, 88298, 88286, 88051, 87967, 
    87593, 87592, 88299, 88276
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00074

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	174950	87207	1	0.000	A	A	A	A
MP3	175404	87434	1	0.000	A	A	A	A
MP3	175720	87592	1	0.000	A	A	A	A
MP3	175722	87593	1	0.000	A	A	A	A
MP3	176470	87967	1	0.000	A	A	A	A
MP3	176638	88051	1	0.000	A	A	A	A
MP3	177088	88276	1	0.000	A	A	A	A
MP3	177108	88286	1	0.000	A	A	A	A
MP3	177132	88298	1	0.000	A	A	A	A
MP3	177134	88299	1	0.000	A	A	A	A
MP3	177340	88402	1	0.000	A	A	A	A
MP3	177346	88405	1	0.000	A	A	A	A
MP3	177348	88406	1	0.000	A	A	A	A
MP3	177350	88407	1	0.000	A	A	A	A
MP3	177388	88426	1	0.000	A	A	A	A
MP3	177392	88428	1	0.000	A	A	A	A
MP3	177394	88429	1	0.000	A	A	A	A
MP3	177396	88430	1	0.000	A	A	A	A
MP3	177402	88433	1	0.000	A	A	A	A
MP3	177410	88437	1	0.000	A	A	A	A
WAV	174951	87207	2	0.300	A	A	A	A
WAV	175405	87434	2	0.300	A	A	A	A
WAV	175721	87592	2	0.300	A	A	A	A
WAV	175723	87593	2	0.300	A	A	A	A
WAV	176471	87967	2	0.300	A	A	A	A
WAV	176639	88051	2	0.300	A	A	A	A
WAV	177089	88276	2	0.300	A	A	A	A
WAV	177109	88286	2	0.300	A	A	A	A
WAV	177133	88298	2	0.300	A	A	A	A
WAV	177135	88299	2	0.300	A	A	A	A
WAV	177341	88402	2	0.300	A	A	A	A
WAV	177347	88405	2	0.300	A	A	A	A
WAV	177349	88406	2	0.300	A	A	A	A
WAV	177351	88407	2	0.300	A	A	A	A
WAV	177389	88426	2	0.300	A	A	A	A
WAV	177393	88428	2	0.300	A	A	A	A
WAV	177395	88429	2	0.300	A	A	A	A
WAV	177397	88430	2	0.300	A	A	A	A
WAV	177403	88433	2	0.300	A	A	A	A
WAV	177411	88437	2	0.300	A	A	A	A