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 (
    89345, 91011, 91012, 91013, 91014, 91015, 
    91037, 91043, 91151, 91341, 91395, 
    91582, 91583, 91584, 91619, 91639, 
    91640, 91642, 91644, 91807
  )

Query time 0.00029

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
89345 S
91011 S
91012 S
91013 S
91014 S
91015 S
91037 S
91043 S
91151 S
91341 S
91395 S
91582 S
91583 S
91584 S
91619 S
91639 S
91640 S
91642 S
91644 S
91807 S