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 (
    6786, 6791, 6856, 6863, 6906, 6909, 7034, 
    7301, 7304, 7434, 7489, 7581, 7695, 
    7906, 7970, 7978, 8043, 8061, 14100, 
    17099
  )

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
6786 S
6791 S
6856 S
6863 S
6906 S
6909 S
7034 S
7301 S
7304 S
7434 S
7489 S
7581 S
7695 S
7906 S
7970 S
7978 S
8043 S
8061 S
14100 S
17099 S