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 (
    81089, 81090, 81091, 81092, 81093, 81094, 
    81095, 81096, 81097, 81098, 81099, 
    81158, 81159, 81160, 81161, 81182, 
    81183, 81184, 81219, 81689, 81690, 
    81691, 81692, 81693, 81694, 81695, 
    81696, 81809, 81906, 81907, 81908, 
    81909, 81910, 81911, 81912, 81913, 
    81914, 81915, 81916, 81917
  )

Query time 0.00050

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 40 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
81089 S
81090 S
81091 S
81092 S
81093 S
81094 S
81095 S
81096 S
81097 S
81098 S
81099 S
81158 S
81159 S
81160 S
81161 S
81182 S
81183 S
81184 S
81219 S
81689 S
81690 S
81691 S
81692 S
81693 S
81694 S
81695 S
81696 S
81809 S
81906 S
81907 S
81908 S
81909 S
81910 S
81911 S
81912 S
81913 S
81914 S
81915 S
81916 S
81917 S