SELECT 
  option_id, 
  option_type 
FROM 
  cscart_product_options 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_product_options.option_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_options'
  ) 
WHERE 
  option_id IN (
    32854, 32855, 32856, 32857, 32858, 32859, 
    32860, 32861, 32862, 32863, 32864, 
    32865, 32866, 32867, 32868, 32869, 
    32870, 32871, 32872, 32873, 32874, 
    32875, 32876, 32877, 32878, 32879, 
    32880, 32881, 32882, 32883, 32884, 
    32885, 32886, 32887, 32888, 32889, 
    32890, 32891, 32894, 32895, 32896, 
    32897, 32898, 32899, 32900, 32901, 
    32902, 32903, 32905, 32906, 32910, 
    32911, 32929, 32934, 32943, 32944, 
    32945, 33023, 33036, 33044, 33045, 
    33089, 33090, 33107, 33256, 33257, 
    33274, 33275, 33276, 33277, 33278, 
    33279, 33280, 33313, 33708, 33720, 
    35058, 35127, 35279, 74816
  )

Query time 0.00073

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 80 Using where
1 SIMPLE cscart_ult_objects_sharing eq_ref PRIMARY PRIMARY 159 toolboxdigitalshop_dev.cscart_product_options.option_id,const,const 1 Using where; Using index

Result

option_id option_type
32854 S
32855 S
32856 S
32857 S
32858 S
32859 S
32860 S
32861 S
32862 S
32863 S
32864 S
32865 S
32866 S
32867 S
32868 S
32869 S
32870 S
32871 S
32872 S
32873 S
32874 S
32875 S
32876 S
32877 S
32878 S
32879 S
32880 S
32881 S
32882 S
32883 S
32884 S
32885 S
32886 S
32887 S
32888 S
32889 S
32890 S
32891 S
32894 S
32895 S
32896 S
32897 S
32898 S
32899 S
32900 S
32901 S
32902 S
32903 S
32905 S
32906 S
32910 S
32911 S
32929 S
32934 S
32943 S
32944 S
32945 S
33023 S
33036 S
33044 S
33045 S
33089 S
33090 S
33107 S
33256 S
33257 S
33274 S
33275 S
33276 S
33277 S
33278 S
33279 S
33280 S
33313 S
33708 S
33720 S
35058 S
35127 S
35279 S
74816 S