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 (
    87448, 87449, 89252, 90616, 90979, 91149, 
    91150, 91303, 91344, 91345, 91397, 
    91401, 91402, 91403, 91432, 91433, 
    91440, 91447, 91579, 91580
  )

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
87448 S
87449 S
89252 S
90616 S
90979 S
91149 S
91150 S
91303 S
91344 S
91345 S
91397 S
91401 S
91402 S
91403 S
91432 S
91433 S
91440 S
91447 S
91579 S
91580 S