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 (
    94980, 94981, 94982, 94983, 94984, 94985, 
    94987, 94988, 94989, 95027, 95052, 
    95053, 95054, 95086, 95105, 95106, 
    95131, 95132, 95143, 95196
  )

Query time 0.00032

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
94980 S
94981 S
94982 S
94983 S
94984 S
94985 S
94987 S
94988 S
94989 S
95027 S
95052 S
95053 S
95054 S
95086 S
95105 S
95106 S
95131 S
95132 S
95143 S
95196 S