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 (
    426, 508, 2564, 2638, 2649, 4403, 6336, 
    6351, 6512, 6625, 6689, 6690, 6691, 
    6692, 6717, 6784, 10072, 10081, 10089, 
    27025
  )

Query time 0.00052

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
426 S
508 S
2564 S
2638 S
2649 S
4403 S
6336 S
6351 S
6512 S
6625 S
6689 S
6690 S
6691 S
6692 S
6717 S
6784 S
10072 S
10081 S
10089 S
27025 S