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 (
    518, 541, 544, 2571, 2581, 2584, 2604, 
    2606, 2619, 2626, 2627, 2628, 2629, 
    2630, 2631, 2634, 2645, 2650, 2689
  )

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 19 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
518 S
541 S
544 S
2571 S
2581 S
2584 S
2604 S
2606 S
2619 S
2626 S
2627 S
2628 S
2629 S
2630 S
2631 S
2634 S
2645 S
2650 S
2689 S