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 (
    102927, 91964, 92564, 102923, 91934, 
    92067, 92066, 91948, 91906, 103010, 
    91866, 91865, 92104, 92103, 92093, 
    92092, 91693, 91691, 91683, 91929
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00085

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	183902	91683	1	0.000	A	A	A	A
MP3	183918	91691	1	0.000	A	A	A	A
MP3	183922	91693	1	0.000	A	A	A	A
MP3	184266	91865	1	0.000	A	A	A	A
MP3	184268	91866	1	0.000	A	A	A	A
MP3	184348	91906	1	0.000	A	A	A	A
MP3	184394	91929	1	0.000	A	A	A	A
MP3	184404	91934	1	0.000	A	A	A	A
MP3	184432	91948	1	0.000	A	A	A	A
MP3	184464	91964	1	0.000	A	A	A	A
MP3	184668	92066	1	0.000	A	A	A	A
MP3	184670	92067	1	0.000	A	A	A	A
MP3	184720	92092	1	0.000	A	A	A	A
MP3	184722	92093	1	0.000	A	A	A	A
MP3	184742	92103	1	0.000	A	A	A	A
MP3	184744	92104	1	0.000	A	A	A	A
MP3	185664	92564	1	0.000	A	A	A	A
MP3	206382	102923	1	0.000	A	A	A	A
MP3	206390	102927	1	0.000	A	A	A	A
MP3	206556	103010	1	0.000	A	A	A	A
WAV	183903	91683	2	0.300	A	A	A	A
WAV	183919	91691	2	0.300	A	A	A	A
WAV	183923	91693	2	0.300	A	A	A	A
WAV	184267	91865	2	0.300	A	A	A	A
WAV	184269	91866	2	0.300	A	A	A	A
WAV	184349	91906	2	0.300	A	A	A	A
WAV	184395	91929	2	0.300	A	A	A	A
WAV	184405	91934	2	0.300	A	A	A	A
WAV	184433	91948	2	0.300	A	A	A	A
WAV	184465	91964	2	0.300	A	A	A	A
WAV	184669	92066	2	0.300	A	A	A	A
WAV	184671	92067	2	0.300	A	A	A	A
WAV	184721	92092	2	0.300	A	A	A	A
WAV	184723	92093	2	0.300	A	A	A	A
WAV	184743	92103	2	0.300	A	A	A	A
WAV	184745	92104	2	0.300	A	A	A	A
WAV	185665	92564	2	0.300	A	A	A	A
WAV	206383	102923	2	0.300	A	A	A	A
WAV	206391	102927	2	0.300	A	A	A	A
WAV	206557	103010	2	0.300	A	A	A	A