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 (
    87456, 87457, 87458, 91516, 92207, 92289, 
    92754, 92755, 92756, 92757, 92763, 
    92768, 92769, 92806, 92842, 92843, 
    92844, 92845, 92846, 92847
  )

Query time 0.00044

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
87456 S
87457 S
87458 S
91516 S
92207 S
92289 S
92754 S
92755 S
92756 S
92757 S
92763 S
92768 S
92769 S
92806 S
92842 S
92843 S
92844 S
92845 S
92846 S
92847 S