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 (
    93632, 93629, 93619, 93618, 93615, 93575, 
    93491, 93488, 93483, 93267, 93002, 
    92998, 92997, 92939, 92060, 93631, 
    83867, 93490, 92893, 93482
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00072

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	168270	83867	1	0.000	A	A	A	A
MP3	184656	92060	1	0.000	A	A	A	A
MP3	186322	92893	1	0.000	A	A	A	A
MP3	186414	92939	1	0.000	A	A	A	A
MP3	186530	92997	1	0.000	A	A	A	A
MP3	186532	92998	1	0.000	A	A	A	A
MP3	186540	93002	1	0.000	A	A	A	A
MP3	187070	93267	1	0.000	A	A	A	A
MP3	187500	93482	1	0.000	A	A	A	A
MP3	187502	93483	1	0.000	A	A	A	A
MP3	187512	93488	1	0.000	A	A	A	A
MP3	187516	93490	1	0.000	A	A	A	A
MP3	187518	93491	1	0.000	A	A	A	A
MP3	187686	93575	1	0.000	A	A	A	A
MP3	187766	93615	1	0.000	A	A	A	A
MP3	187772	93618	1	0.000	A	A	A	A
MP3	187774	93619	1	0.000	A	A	A	A
MP3	187794	93629	1	0.000	A	A	A	A
MP3	187798	93631	1	0.000	A	A	A	A
MP3	187800	93632	1	0.000	A	A	A	A
WAV	168271	83867	2	0.300	A	A	A	A
WAV	184657	92060	2	0.300	A	A	A	A
WAV	186323	92893	2	0.300	A	A	A	A
WAV	186415	92939	2	0.300	A	A	A	A
WAV	186531	92997	2	0.300	A	A	A	A
WAV	186533	92998	2	0.300	A	A	A	A
WAV	186541	93002	2	0.300	A	A	A	A
WAV	187071	93267	2	0.300	A	A	A	A
WAV	187501	93482	2	0.300	A	A	A	A
WAV	187503	93483	2	0.300	A	A	A	A
WAV	187513	93488	2	0.300	A	A	A	A
WAV	187517	93490	2	0.300	A	A	A	A
WAV	187519	93491	2	0.300	A	A	A	A
WAV	187687	93575	2	0.300	A	A	A	A
WAV	187767	93615	2	0.300	A	A	A	A
WAV	187773	93618	2	0.300	A	A	A	A
WAV	187775	93619	2	0.300	A	A	A	A
WAV	187795	93629	2	0.300	A	A	A	A
WAV	187799	93631	2	0.300	A	A	A	A
WAV	187801	93632	2	0.300	A	A	A	A