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 (
    83867, 92060, 92893, 92939, 92997, 92998, 
    93002, 93267, 93482, 93483, 93488, 
    93490, 93491, 93575, 93615, 93618, 
    93619, 93629, 93631, 93632
  )

Query time 0.00041

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
83867 S
92060 S
92893 S
92939 S
92997 S
92998 S
93002 S
93267 S
93482 S
93483 S
93488 S
93490 S
93491 S
93575 S
93615 S
93618 S
93619 S
93629 S
93631 S
93632 S