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 (
    68343, 68342, 68341, 68340, 68339, 68338, 
    68337, 68336, 68335, 68334, 68333, 
    68332, 68331, 68330, 68329, 68328, 
    68327, 68326, 68325, 68324, 68737, 
    68736, 68735, 68734, 68733, 68732, 
    68731, 68730, 68729, 68728, 68727, 
    68726, 68627, 68412, 68368, 68531, 
    68525, 68524, 68462, 68461
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00130

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	137162	68324	1	0.000	A	A	A	A
MP3	137164	68325	1	0.000	A	A	A	A
MP3	137166	68326	1	0.000	A	A	A	A
MP3	137168	68327	1	0.000	A	A	A	A
MP3	137170	68328	1	0.000	A	A	A	A
MP3	137172	68329	1	0.000	A	A	A	A
MP3	137174	68330	1	0.000	A	A	A	A
MP3	137176	68331	1	0.000	A	A	A	A
MP3	137178	68332	1	0.000	A	A	A	A
MP3	137180	68333	1	0.000	A	A	A	A
MP3	137182	68334	1	0.000	A	A	A	A
MP3	137184	68335	1	0.000	A	A	A	A
MP3	137186	68336	1	0.000	A	A	A	A
MP3	137188	68337	1	0.000	A	A	A	A
MP3	137190	68338	1	0.000	A	A	A	A
MP3	137192	68339	1	0.000	A	A	A	A
MP3	137194	68340	1	0.000	A	A	A	A
MP3	137196	68341	1	0.000	A	A	A	A
MP3	137198	68342	1	0.000	A	A	A	A
MP3	137200	68343	1	0.000	A	A	A	A
MP3	137250	68368	1	0.000	A	A	A	A
MP3	137338	68412	1	0.000	A	A	A	A
MP3	137436	68461	1	0.000	A	A	A	A
MP3	137438	68462	1	0.000	A	A	A	A
MP3	137562	68524	1	0.000	A	A	A	A
MP3	137564	68525	1	0.000	A	A	A	A
MP3	137576	68531	1	0.000	A	A	A	A
MP3	137768	68627	1	0.000	A	A	A	A
MP3	137966	68726	1	0.000	A	A	A	A
MP3	137968	68727	1	0.000	A	A	A	A
MP3	137970	68728	1	0.000	A	A	A	A
MP3	137972	68729	1	0.000	A	A	A	A
MP3	137974	68730	1	0.000	A	A	A	A
MP3	137976	68731	1	0.000	A	A	A	A
MP3	137978	68732	1	0.000	A	A	A	A
MP3	137980	68733	1	0.000	A	A	A	A
MP3	137982	68734	1	0.000	A	A	A	A
MP3	137984	68735	1	0.000	A	A	A	A
MP3	137986	68736	1	0.000	A	A	A	A
MP3	137988	68737	1	0.000	A	A	A	A
WAV	137163	68324	2	0.300	A	A	A	A
WAV	137165	68325	2	0.300	A	A	A	A
WAV	137167	68326	2	0.300	A	A	A	A
WAV	137169	68327	2	0.300	A	A	A	A
WAV	137171	68328	2	0.300	A	A	A	A
WAV	137173	68329	2	0.300	A	A	A	A
WAV	137175	68330	2	0.300	A	A	A	A
WAV	137177	68331	2	0.300	A	A	A	A
WAV	137179	68332	2	0.300	A	A	A	A
WAV	137181	68333	2	0.300	A	A	A	A
WAV	137183	68334	2	0.300	A	A	A	A
WAV	137185	68335	2	0.300	A	A	A	A
WAV	137187	68336	2	0.300	A	A	A	A
WAV	137189	68337	2	0.300	A	A	A	A
WAV	137191	68338	2	0.300	A	A	A	A
WAV	137193	68339	2	0.300	A	A	A	A
WAV	137195	68340	2	0.300	A	A	A	A
WAV	137197	68341	2	0.300	A	A	A	A
WAV	137199	68342	2	0.300	A	A	A	A
WAV	137201	68343	2	0.300	A	A	A	A
WAV	137251	68368	2	0.300	A	A	A	A
WAV	137339	68412	2	0.300	A	A	A	A
WAV	137437	68461	2	0.300	A	A	A	A
WAV	137439	68462	2	0.300	A	A	A	A
WAV	137563	68524	2	0.300	A	A	A	A
WAV	137565	68525	2	0.300	A	A	A	A
WAV	137577	68531	2	0.300	A	A	A	A
WAV	137769	68627	2	0.300	A	A	A	A
WAV	137967	68726	2	0.300	A	A	A	A
WAV	137969	68727	2	0.300	A	A	A	A
WAV	137971	68728	2	0.300	A	A	A	A
WAV	137973	68729	2	0.300	A	A	A	A
WAV	137975	68730	2	0.300	A	A	A	A
WAV	137977	68731	2	0.300	A	A	A	A
WAV	137979	68732	2	0.300	A	A	A	A
WAV	137981	68733	2	0.300	A	A	A	A
WAV	137983	68734	2	0.300	A	A	A	A
WAV	137985	68735	2	0.300	A	A	A	A
WAV	137987	68736	2	0.300	A	A	A	A
WAV	137989	68737	2	0.300	A	A	A	A