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 (
    32934, 32906, 32905, 32903, 32902, 32901, 
    32900, 32899, 32898, 32897, 32896, 
    32895, 32894, 32891, 32890, 32889, 
    32888, 32887, 32886, 32885, 32884, 
    32883, 32882, 32881, 32880, 32879, 
    32878, 32877, 32876, 32875, 32874, 
    32873, 32872, 32871, 32870, 32869, 
    32868, 32867, 32866, 32865, 32864, 
    32863, 32862, 32861, 32860, 32859, 
    32858, 35058, 33708, 33023, 74816, 
    33089, 32945, 32944, 32943, 32857, 
    32856, 32855, 33313, 33280, 33279, 
    33278, 33277, 33276, 33275, 33274, 
    33257, 33256, 33107, 33090, 33036, 
    32854, 35279, 33045, 33044, 35127, 
    33720, 32929, 32911, 32910
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00209

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		160	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	65774	32854	1	0.000	A	A	A	A
MP3	65776	32855	1	0.000	A	A	A	A
MP3	65778	32856	1	0.000	A	A	A	A
MP3	65780	32857	1	0.000	A	A	A	A
MP3	65782	32858	1	0.000	A	A	A	A
MP3	65784	32859	1	0.000	A	A	A	A
MP3	65786	32860	1	0.000	A	A	A	A
MP3	65788	32861	1	0.000	A	A	A	A
MP3	65790	32862	1	0.000	A	A	A	A
MP3	65792	32863	1	0.000	A	A	A	A
MP3	65794	32864	1	0.000	A	A	A	A
MP3	65796	32865	1	0.000	A	A	A	A
MP3	65798	32866	1	0.000	A	A	A	A
MP3	65800	32867	1	0.000	A	A	A	A
MP3	65802	32868	1	0.000	A	A	A	A
MP3	65804	32869	1	0.000	A	A	A	A
MP3	65806	32870	1	0.000	A	A	A	A
MP3	65808	32871	1	0.000	A	A	A	A
MP3	65810	32872	1	0.000	A	A	A	A
MP3	65812	32873	1	0.000	A	A	A	A
MP3	65814	32874	1	0.000	A	A	A	A
MP3	65816	32875	1	0.000	A	A	A	A
MP3	65818	32876	1	0.000	A	A	A	A
MP3	65820	32877	1	0.000	A	A	A	A
MP3	65822	32878	1	0.000	A	A	A	A
MP3	65824	32879	1	0.000	A	A	A	A
MP3	65826	32880	1	0.000	A	A	A	A
MP3	65828	32881	1	0.000	A	A	A	A
MP3	65830	32882	1	0.000	A	A	A	A
MP3	65832	32883	1	0.000	A	A	A	A
MP3	65834	32884	1	0.000	A	A	A	A
MP3	65836	32885	1	0.000	A	A	A	A
MP3	65838	32886	1	0.000	A	A	A	A
MP3	65840	32887	1	0.000	A	A	A	A
MP3	65842	32888	1	0.000	A	A	A	A
MP3	65844	32889	1	0.000	A	A	A	A
MP3	65846	32890	1	0.000	A	A	A	A
MP3	65848	32891	1	0.000	A	A	A	A
MP3	65854	32894	1	0.000	A	A	A	A
MP3	65856	32895	1	0.000	A	A	A	A
MP3	65858	32896	1	0.000	A	A	A	A
MP3	65860	32897	1	0.000	A	A	A	A
MP3	65862	32898	1	0.000	A	A	A	A
MP3	65864	32899	1	0.000	A	A	A	A
MP3	65866	32900	1	0.000	A	A	A	A
MP3	65868	32901	1	0.000	A	A	A	A
MP3	65870	32902	1	0.000	A	A	A	A
MP3	65872	32903	1	0.000	A	A	A	A
MP3	65876	32905	1	0.000	A	A	A	A
MP3	65878	32906	1	0.000	A	A	A	A
MP3	65886	32910	1	0.000	A	A	A	A
MP3	65888	32911	1	0.000	A	A	A	A
MP3	65924	32929	1	0.000	A	A	A	A
MP3	65934	32934	1	0.000	A	A	A	A
MP3	65952	32943	1	0.000	A	A	A	A
MP3	65954	32944	1	0.000	A	A	A	A
MP3	65956	32945	1	0.000	A	A	A	A
MP3	66112	33023	1	0.000	A	A	A	A
MP3	66138	33036	1	0.000	A	A	A	A
MP3	66154	33044	1	0.000	A	A	A	A
MP3	66156	33045	1	0.000	A	A	A	A
MP3	66244	33089	1	0.000	A	A	A	A
MP3	66246	33090	1	0.000	A	A	A	A
MP3	66280	33107	1	0.000	A	A	A	A
MP3	66578	33256	1	0.000	A	A	A	A
MP3	66580	33257	1	0.000	A	A	A	A
MP3	66614	33274	1	0.000	A	A	A	A
MP3	66616	33275	1	0.000	A	A	A	A
MP3	66618	33276	1	0.000	A	A	A	A
MP3	66620	33277	1	0.000	A	A	A	A
MP3	66622	33278	1	0.000	A	A	A	A
MP3	66624	33279	1	0.000	A	A	A	A
MP3	66626	33280	1	0.000	A	A	A	A
MP3	66692	33313	1	0.000	A	A	A	A
MP3	67482	33708	1	0.000	A	A	A	A
MP3	67506	33720	1	0.000	A	A	A	A
MP3	70182	35058	1	0.000	A	A	A	A
MP3	70320	35127	1	0.000	A	A	A	A
MP3	70624	35279	1	0.000	A	A	A	A
MP3	150168	74816	1	0.000	A	A	A	A
WAV	65775	32854	2	0.300	A	A	A	A
WAV	65777	32855	2	0.300	A	A	A	A
WAV	65779	32856	2	0.300	A	A	A	A
WAV	65781	32857	2	0.300	A	A	A	A
WAV	65783	32858	2	0.300	A	A	A	A
WAV	65785	32859	2	0.300	A	A	A	A
WAV	65787	32860	2	0.300	A	A	A	A
WAV	65789	32861	2	0.300	A	A	A	A
WAV	65791	32862	2	0.300	A	A	A	A
WAV	65793	32863	2	0.300	A	A	A	A
WAV	65795	32864	2	0.300	A	A	A	A
WAV	65797	32865	2	0.300	A	A	A	A
WAV	65799	32866	2	0.300	A	A	A	A
WAV	65801	32867	2	0.300	A	A	A	A
WAV	65803	32868	2	0.300	A	A	A	A
WAV	65805	32869	2	0.300	A	A	A	A
WAV	65807	32870	2	0.300	A	A	A	A
WAV	65809	32871	2	0.300	A	A	A	A
WAV	65811	32872	2	0.300	A	A	A	A
WAV	65813	32873	2	0.300	A	A	A	A
WAV	65815	32874	2	0.300	A	A	A	A
WAV	65817	32875	2	0.300	A	A	A	A
WAV	65819	32876	2	0.300	A	A	A	A
WAV	65821	32877	2	0.300	A	A	A	A
WAV	65823	32878	2	0.300	A	A	A	A
WAV	65825	32879	2	0.300	A	A	A	A
WAV	65827	32880	2	0.300	A	A	A	A
WAV	65829	32881	2	0.300	A	A	A	A
WAV	65831	32882	2	0.300	A	A	A	A
WAV	65833	32883	2	0.300	A	A	A	A
WAV	65835	32884	2	0.300	A	A	A	A
WAV	65837	32885	2	0.300	A	A	A	A
WAV	65839	32886	2	0.300	A	A	A	A
WAV	65841	32887	2	0.300	A	A	A	A
WAV	65843	32888	2	0.300	A	A	A	A
WAV	65845	32889	2	0.300	A	A	A	A
WAV	65847	32890	2	0.300	A	A	A	A
WAV	65849	32891	2	0.300	A	A	A	A
WAV	65855	32894	2	0.300	A	A	A	A
WAV	65857	32895	2	0.300	A	A	A	A
WAV	65859	32896	2	0.300	A	A	A	A
WAV	65861	32897	2	0.300	A	A	A	A
WAV	65863	32898	2	0.300	A	A	A	A
WAV	65865	32899	2	0.300	A	A	A	A
WAV	65867	32900	2	0.300	A	A	A	A
WAV	65869	32901	2	0.300	A	A	A	A
WAV	65871	32902	2	0.300	A	A	A	A
WAV	65873	32903	2	0.300	A	A	A	A
WAV	65877	32905	2	0.300	A	A	A	A
WAV	65879	32906	2	0.300	A	A	A	A
WAV	65887	32910	2	0.300	A	A	A	A
WAV	65889	32911	2	0.300	A	A	A	A
WAV	65925	32929	2	0.300	A	A	A	A
WAV	65935	32934	2	0.300	A	A	A	A
WAV	65953	32943	2	0.300	A	A	A	A
WAV	65955	32944	2	0.300	A	A	A	A
WAV	65957	32945	2	0.300	A	A	A	A
WAV	66113	33023	2	0.300	A	A	A	A
WAV	66139	33036	2	0.300	A	A	A	A
WAV	66155	33044	2	0.300	A	A	A	A
WAV	66157	33045	2	0.300	A	A	A	A
WAV	66245	33089	2	0.300	A	A	A	A
WAV	66247	33090	2	0.300	A	A	A	A
WAV	66281	33107	2	0.300	A	A	A	A
WAV	66579	33256	2	0.300	A	A	A	A
WAV	66581	33257	2	0.300	A	A	A	A
WAV	66615	33274	2	0.300	A	A	A	A
WAV	66617	33275	2	0.300	A	A	A	A
WAV	66619	33276	2	0.300	A	A	A	A
WAV	66621	33277	2	0.300	A	A	A	A
WAV	66623	33278	2	0.300	A	A	A	A
WAV	66625	33279	2	0.300	A	A	A	A
WAV	66627	33280	2	0.300	A	A	A	A
WAV	66693	33313	2	0.300	A	A	A	A
WAV	67483	33708	2	0.300	A	A	A	A
WAV	67507	33720	2	0.300	A	A	A	A
WAV	70183	35058	2	0.300	A	A	A	A
WAV	70321	35127	2	0.300	A	A	A	A
WAV	70625	35279	2	0.300	A	A	A	A
WAV	150169	74816	2	0.300	A	A	A	A