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 (
    89205, 89206, 89207, 89208, 89209, 89210, 
    89211, 89212, 89213, 89214, 89215, 
    89216, 89217, 89218, 89219, 89220, 
    90049, 90050, 90051, 90052, 90053, 
    90054, 90055, 90056, 90057, 90058, 
    90059, 90060, 90061, 90062, 90063, 
    90064, 90065, 90066, 90067, 90068, 
    90069, 90070, 90071, 90072
  )

Query time 0.00055

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 40 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
89205 S
89206 S
89207 S
89208 S
89209 S
89210 S
89211 S
89212 S
89213 S
89214 S
89215 S
89216 S
89217 S
89218 S
89219 S
89220 S
90049 S
90050 S
90051 S
90052 S
90053 S
90054 S
90055 S
90056 S
90057 S
90058 S
90059 S
90060 S
90061 S
90062 S
90063 S
90064 S
90065 S
90066 S
90067 S
90068 S
90069 S
90070 S
90071 S
90072 S