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 (
    93481, 93480, 93479, 93478, 93465, 93463, 
    93458, 93413, 93332, 119920, 93131, 
    93130, 93129, 93128, 93127, 93126, 
    93125, 93124, 93123, 93122
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00104

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	186780	93122	1	0.000	A	A	A	A
MP3	186782	93123	1	0.000	A	A	A	A
MP3	186784	93124	1	0.000	A	A	A	A
MP3	186786	93125	1	0.000	A	A	A	A
MP3	186788	93126	1	0.000	A	A	A	A
MP3	186790	93127	1	0.000	A	A	A	A
MP3	186792	93128	1	0.000	A	A	A	A
MP3	186794	93129	1	0.000	A	A	A	A
MP3	186796	93130	1	0.000	A	A	A	A
MP3	186798	93131	1	0.000	A	A	A	A
MP3	187200	93332	1	0.000	A	A	A	A
MP3	187362	93413	1	0.000	A	A	A	A
MP3	187452	93458	1	0.000	A	A	A	A
MP3	187462	93463	1	0.000	A	A	A	A
MP3	187466	93465	1	0.000	A	A	A	A
MP3	187492	93478	1	0.000	A	A	A	A
MP3	187494	93479	1	0.000	A	A	A	A
MP3	187496	93480	1	0.000	A	A	A	A
MP3	187498	93481	1	0.000	A	A	A	A
MP3	240376	119920	1	0.000	A	A	A	A
WAV	186781	93122	2	0.300	A	A	A	A
WAV	186783	93123	2	0.300	A	A	A	A
WAV	186785	93124	2	0.300	A	A	A	A
WAV	186787	93125	2	0.300	A	A	A	A
WAV	186789	93126	2	0.300	A	A	A	A
WAV	186791	93127	2	0.300	A	A	A	A
WAV	186793	93128	2	0.300	A	A	A	A
WAV	186795	93129	2	0.300	A	A	A	A
WAV	186797	93130	2	0.300	A	A	A	A
WAV	186799	93131	2	0.300	A	A	A	A
WAV	187201	93332	2	0.300	A	A	A	A
WAV	187363	93413	2	0.300	A	A	A	A
WAV	187453	93458	2	0.300	A	A	A	A
WAV	187463	93463	2	0.300	A	A	A	A
WAV	187467	93465	2	0.300	A	A	A	A
WAV	187493	93478	2	0.300	A	A	A	A
WAV	187495	93479	2	0.300	A	A	A	A
WAV	187497	93480	2	0.300	A	A	A	A
WAV	187499	93481	2	0.300	A	A	A	A
WAV	240377	119920	2	1.500	A	A	A	A