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 (
    89116, 89117, 89118, 89119, 89120, 89121, 
    89122, 89123, 89124, 89125, 89126, 
    89127, 89128, 89129, 89130, 89131, 
    89132, 89133, 89134, 89135
  )

Query time 0.00028

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
89116 S
89117 S
89118 S
89119 S
89120 S
89121 S
89122 S
89123 S
89124 S
89125 S
89126 S
89127 S
89128 S
89129 S
89130 S
89131 S
89132 S
89133 S
89134 S
89135 S