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 (
    68892, 68891, 68868, 68802, 68711, 68464, 
    68369, 68742, 68888, 68887, 68886, 
    68885, 68884, 68883, 68882, 68881, 
    68880, 68879, 68878, 68877, 68876, 
    68875, 68874, 68873, 68872, 68871, 
    68415, 68437, 68410, 68409, 68408, 
    68407, 68406, 68405, 68738, 68710, 
    68709, 68463, 119471, 68344
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00118

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	137202	68344	1	0.000	A	A	A	A
MP3	137252	68369	1	0.000	A	A	A	A
MP3	137324	68405	1	0.000	A	A	A	A
MP3	137326	68406	1	0.000	A	A	A	A
MP3	137328	68407	1	0.000	A	A	A	A
MP3	137330	68408	1	0.000	A	A	A	A
MP3	137332	68409	1	0.000	A	A	A	A
MP3	137334	68410	1	0.000	A	A	A	A
MP3	137344	68415	1	0.000	A	A	A	A
MP3	137388	68437	1	0.000	A	A	A	A
MP3	137440	68463	1	0.000	A	A	A	A
MP3	137442	68464	1	0.000	A	A	A	A
MP3	137932	68709	1	0.000	A	A	A	A
MP3	137934	68710	1	0.000	A	A	A	A
MP3	137936	68711	1	0.000	A	A	A	A
MP3	137990	68738	1	0.000	A	A	A	A
MP3	137998	68742	1	0.000	A	A	A	A
MP3	138118	68802	1	0.000	A	A	A	A
MP3	138250	68868	1	0.000	A	A	A	A
MP3	138256	68871	1	0.000	A	A	A	A
MP3	138258	68872	1	0.000	A	A	A	A
MP3	138260	68873	1	0.000	A	A	A	A
MP3	138262	68874	1	0.000	A	A	A	A
MP3	138264	68875	1	0.000	A	A	A	A
MP3	138266	68876	1	0.000	A	A	A	A
MP3	138268	68877	1	0.000	A	A	A	A
MP3	138270	68878	1	0.000	A	A	A	A
MP3	138272	68879	1	0.000	A	A	A	A
MP3	138274	68880	1	0.000	A	A	A	A
MP3	138276	68881	1	0.000	A	A	A	A
MP3	138278	68882	1	0.000	A	A	A	A
MP3	138280	68883	1	0.000	A	A	A	A
MP3	138282	68884	1	0.000	A	A	A	A
MP3	138284	68885	1	0.000	A	A	A	A
MP3	138286	68886	1	0.000	A	A	A	A
MP3	138288	68887	1	0.000	A	A	A	A
MP3	138290	68888	1	0.000	A	A	A	A
MP3	138296	68891	1	0.000	A	A	A	A
MP3	138298	68892	1	0.000	A	A	A	A
MP3	239478	119471	1	0.000	A	A	A	A
WAV	137203	68344	2	0.300	A	A	A	A
WAV	137253	68369	2	0.300	A	A	A	A
WAV	137325	68405	2	0.300	A	A	A	A
WAV	137327	68406	2	0.300	A	A	A	A
WAV	137329	68407	2	0.300	A	A	A	A
WAV	137331	68408	2	0.300	A	A	A	A
WAV	137333	68409	2	0.300	A	A	A	A
WAV	137335	68410	2	0.300	A	A	A	A
WAV	137345	68415	2	0.300	A	A	A	A
WAV	137389	68437	2	0.300	A	A	A	A
WAV	137441	68463	2	0.300	A	A	A	A
WAV	137443	68464	2	0.300	A	A	A	A
WAV	137933	68709	2	0.300	A	A	A	A
WAV	137935	68710	2	0.300	A	A	A	A
WAV	137937	68711	2	0.300	A	A	A	A
WAV	137991	68738	2	0.300	A	A	A	A
WAV	137999	68742	2	0.300	A	A	A	A
WAV	138119	68802	2	0.300	A	A	A	A
WAV	138251	68868	2	0.300	A	A	A	A
WAV	138257	68871	2	0.300	A	A	A	A
WAV	138259	68872	2	0.300	A	A	A	A
WAV	138261	68873	2	0.300	A	A	A	A
WAV	138263	68874	2	0.300	A	A	A	A
WAV	138265	68875	2	0.300	A	A	A	A
WAV	138267	68876	2	0.300	A	A	A	A
WAV	138269	68877	2	0.300	A	A	A	A
WAV	138271	68878	2	0.300	A	A	A	A
WAV	138273	68879	2	0.300	A	A	A	A
WAV	138275	68880	2	0.300	A	A	A	A
WAV	138277	68881	2	0.300	A	A	A	A
WAV	138279	68882	2	0.300	A	A	A	A
WAV	138281	68883	2	0.300	A	A	A	A
WAV	138283	68884	2	0.300	A	A	A	A
WAV	138285	68885	2	0.300	A	A	A	A
WAV	138287	68886	2	0.300	A	A	A	A
WAV	138289	68887	2	0.300	A	A	A	A
WAV	138291	68888	2	0.300	A	A	A	A
WAV	138297	68891	2	0.300	A	A	A	A
WAV	138299	68892	2	0.300	A	A	A	A
WAV	239479	119471	2	1.500	A	A	A	A