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 (
    87049, 87411, 87437, 87559, 88253, 88626, 
    88821, 88840, 88995, 88996, 89001, 
    89002, 89003, 89004, 89005, 89006, 
    89008, 89043, 89065, 89163
  )

Query time 0.00033

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
87049 S
87411 S
87437 S
87559 S
88253 S
88626 S
88821 S
88840 S
88995 S
88996 S
89001 S
89002 S
89003 S
89004 S
89005 S
89006 S
89008 S
89043 S
89065 S
89163 S