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 (
    92641, 92640, 92639, 92638, 92637, 92636, 
    92635, 92634, 92633, 92632, 92631, 
    92630, 92629, 92628, 92627, 92626, 
    92625, 92624, 92623, 92622
  ) 
  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	185780	92622	1	0.000	A	A	A	A
MP3	185782	92623	1	0.000	A	A	A	A
MP3	185784	92624	1	0.000	A	A	A	A
MP3	185786	92625	1	0.000	A	A	A	A
MP3	185788	92626	1	0.000	A	A	A	A
MP3	185790	92627	1	0.000	A	A	A	A
MP3	185792	92628	1	0.000	A	A	A	A
MP3	185794	92629	1	0.000	A	A	A	A
MP3	185796	92630	1	0.000	A	A	A	A
MP3	185798	92631	1	0.000	A	A	A	A
MP3	185800	92632	1	0.000	A	A	A	A
MP3	185802	92633	1	0.000	A	A	A	A
MP3	185804	92634	1	0.000	A	A	A	A
MP3	185806	92635	1	0.000	A	A	A	A
MP3	185808	92636	1	0.000	A	A	A	A
MP3	185810	92637	1	0.000	A	A	A	A
MP3	185812	92638	1	0.000	A	A	A	A
MP3	185814	92639	1	0.000	A	A	A	A
MP3	185816	92640	1	0.000	A	A	A	A
MP3	185818	92641	1	0.000	A	A	A	A
WAV	185781	92622	2	0.300	A	A	A	A
WAV	185783	92623	2	0.300	A	A	A	A
WAV	185785	92624	2	0.300	A	A	A	A
WAV	185787	92625	2	0.300	A	A	A	A
WAV	185789	92626	2	0.300	A	A	A	A
WAV	185791	92627	2	0.300	A	A	A	A
WAV	185793	92628	2	0.300	A	A	A	A
WAV	185795	92629	2	0.300	A	A	A	A
WAV	185797	92630	2	0.300	A	A	A	A
WAV	185799	92631	2	0.300	A	A	A	A
WAV	185801	92632	2	0.300	A	A	A	A
WAV	185803	92633	2	0.300	A	A	A	A
WAV	185805	92634	2	0.300	A	A	A	A
WAV	185807	92635	2	0.300	A	A	A	A
WAV	185809	92636	2	0.300	A	A	A	A
WAV	185811	92637	2	0.300	A	A	A	A
WAV	185813	92638	2	0.300	A	A	A	A
WAV	185815	92639	2	0.300	A	A	A	A
WAV	185817	92640	2	0.300	A	A	A	A
WAV	185819	92641	2	0.300	A	A	A	A