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 (
    87443, 87855, 89481, 89482, 89632, 89768, 
    89992, 90001, 90151, 90189, 90190, 
    90191, 90192, 90246, 90247, 90280, 
    90281, 90296, 90309, 90318
  )

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
87443 S
87855 S
89481 S
89482 S
89632 S
89768 S
89992 S
90001 S
90151 S
90189 S
90190 S
90191 S
90192 S
90246 S
90247 S
90280 S
90281 S
90296 S
90309 S
90318 S