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 (
    86662, 86818, 87006, 87046, 87065, 87066, 
    87142, 87191, 87262, 87301, 87302, 
    87303, 87304, 87331, 87332, 87355, 
    87356, 87532, 92979, 92980
  )

Query time 0.00043

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
86662 S
86818 S
87006 S
87046 S
87065 S
87066 S
87142 S
87191 S
87262 S
87301 S
87302 S
87303 S
87304 S
87331 S
87332 S
87355 S
87356 S
87532 S
92979 S
92980 S