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 (
    89110, 89111, 89112, 89141, 89154, 89155, 
    89156, 89157, 89158, 89159, 89160, 
    89161, 89378, 89901, 90024, 90025, 
    90026, 90027, 90028, 90029, 90030, 
    90031, 90032, 90033, 90034, 90035, 
    90036, 90037, 90038, 90039, 90040, 
    90041, 90042, 90043, 90044, 90045, 
    90046, 90047, 90048
  )

Query time 0.00067

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 39 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
89110 S
89111 S
89112 S
89141 S
89154 S
89155 S
89156 S
89157 S
89158 S
89159 S
89160 S
89161 S
89378 S
89901 S
90024 S
90025 S
90026 S
90027 S
90028 S
90029 S
90030 S
90031 S
90032 S
90033 S
90034 S
90035 S
90036 S
90037 S
90038 S
90039 S
90040 S
90041 S
90042 S
90043 S
90044 S
90045 S
90046 S
90047 S
90048 S