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 (
    95843, 95880, 95881, 95883, 95888, 95889, 
    95890, 95891, 95892, 95893, 95894, 
    95896, 95897, 95899, 95900, 95901, 
    96409, 96410, 96411, 96412
  )

Query time 0.00038

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 20 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
95843 S
95880 S
95881 S
95883 S
95888 S
95889 S
95890 S
95891 S
95892 S
95893 S
95894 S
95896 S
95897 S
95899 S
95900 S
95901 S
96409 S
96410 S
96411 S
96412 S