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 (
    67379, 65598, 68248, 68243, 66692, 68061, 
    67997, 67996, 67994, 66937, 66416, 
    66390, 66389, 66639, 66368, 66938, 
    66340, 66393, 36749, 66787, 66786, 
    66529, 66752, 66640, 65359, 66665, 
    66229, 65597, 66555, 66554, 66497, 
    66392, 66530, 66502, 66325, 66237, 
    66496, 66489, 66442, 66441
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00173

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		80	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	73564	36749	1	0.000	A	A	A	A
MP3	130944	65359	1	0.000	A	A	A	A
MP3	131628	65597	1	0.000	A	A	A	A
MP3	131630	65598	1	0.000	A	A	A	A
MP3	132916	66229	1	0.000	A	A	A	A
MP3	132932	66237	1	0.000	A	A	A	A
MP3	133164	66325	1	0.000	A	A	A	A
MP3	133194	66340	1	0.000	A	A	A	A
MP3	133250	66368	1	0.000	A	A	A	A
MP3	133292	66389	1	0.000	A	A	A	A
MP3	133294	66390	1	0.000	A	A	A	A
MP3	133298	66392	1	0.000	A	A	A	A
MP3	133300	66393	1	0.000	A	A	A	A
MP3	133346	66416	1	0.000	A	A	A	A
MP3	133396	66441	1	0.000	A	A	A	A
MP3	133398	66442	1	0.000	A	A	A	A
MP3	133492	66489	1	0.000	A	A	A	A
MP3	133506	66496	1	0.000	A	A	A	A
MP3	133508	66497	1	0.000	A	A	A	A
MP3	133518	66502	1	0.000	A	A	A	A
MP3	133572	66529	1	0.000	A	A	A	A
MP3	133574	66530	1	0.000	A	A	A	A
MP3	133622	66554	1	0.000	A	A	A	A
MP3	133624	66555	1	0.000	A	A	A	A
MP3	133792	66639	1	0.000	A	A	A	A
MP3	133794	66640	1	0.000	A	A	A	A
MP3	133844	66665	1	0.000	A	A	A	A
MP3	133898	66692	1	0.000	A	A	A	A
MP3	134018	66752	1	0.000	A	A	A	A
MP3	134086	66786	1	0.000	A	A	A	A
MP3	134088	66787	1	0.000	A	A	A	A
MP3	134388	66937	1	0.000	A	A	A	A
MP3	134390	66938	1	0.000	A	A	A	A
MP3	135272	67379	1	0.000	A	A	A	A
MP3	136502	67994	1	0.000	A	A	A	A
MP3	136506	67996	1	0.000	A	A	A	A
MP3	136508	67997	1	0.000	A	A	A	A
MP3	136636	68061	1	0.000	A	A	A	A
MP3	137000	68243	1	0.000	A	A	A	A
MP3	137010	68248	1	0.000	A	A	A	A
WAV	73565	36749	2	0.300	A	A	A	A
WAV	130945	65359	2	0.300	A	A	A	A
WAV	131629	65597	2	0.300	A	A	A	A
WAV	131631	65598	2	0.300	A	A	A	A
WAV	132917	66229	2	0.300	A	A	A	A
WAV	132933	66237	2	0.300	A	A	A	A
WAV	133165	66325	2	0.300	A	A	A	A
WAV	133195	66340	2	0.300	A	A	A	A
WAV	133251	66368	2	0.300	A	A	A	A
WAV	133293	66389	2	0.300	A	A	A	A
WAV	133295	66390	2	0.300	A	A	A	A
WAV	133299	66392	2	0.300	A	A	A	A
WAV	133301	66393	2	0.300	A	A	A	A
WAV	133347	66416	2	0.300	A	A	A	A
WAV	133397	66441	2	0.300	A	A	A	A
WAV	133399	66442	2	0.300	A	A	A	A
WAV	133493	66489	2	0.300	A	A	A	A
WAV	133507	66496	2	0.300	A	A	A	A
WAV	133509	66497	2	0.300	A	A	A	A
WAV	133519	66502	2	0.300	A	A	A	A
WAV	133573	66529	2	0.300	A	A	A	A
WAV	133575	66530	2	0.300	A	A	A	A
WAV	133623	66554	2	0.300	A	A	A	A
WAV	133625	66555	2	0.300	A	A	A	A
WAV	133793	66639	2	0.300	A	A	A	A
WAV	133795	66640	2	0.300	A	A	A	A
WAV	133845	66665	2	0.300	A	A	A	A
WAV	133899	66692	2	0.300	A	A	A	A
WAV	134019	66752	2	0.300	A	A	A	A
WAV	134087	66786	2	0.300	A	A	A	A
WAV	134089	66787	2	0.300	A	A	A	A
WAV	134389	66937	2	0.300	A	A	A	A
WAV	134391	66938	2	0.300	A	A	A	A
WAV	135273	67379	2	0.300	A	A	A	A
WAV	136503	67994	2	0.300	A	A	A	A
WAV	136507	67996	2	0.300	A	A	A	A
WAV	136509	67997	2	0.300	A	A	A	A
WAV	136637	68061	2	0.300	A	A	A	A
WAV	137001	68243	2	0.300	A	A	A	A
WAV	137011	68248	2	0.300	A	A	A	A