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 (
    10225, 10463, 10527, 10544, 10638, 10689, 
    10872, 10902, 10964, 10965, 10968, 
    10983, 11097, 11151, 11307, 11340, 
    33856, 33861, 33865, 33876
  )

Query time 0.00030

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
10225 S
10463 S
10527 S
10544 S
10638 S
10689 S
10872 S
10902 S
10964 S
10965 S
10968 S
10983 S
11097 S
11151 S
11307 S
11340 S
33856 S
33861 S
33865 S
33876 S