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 (
    45523, 45524, 45525, 45526, 45527, 45528, 
    45555, 45556, 45626, 45712, 45744, 
    45762, 45763, 45828, 45835, 45840, 
    45847, 45928, 45937, 45938, 45939, 
    45940, 45941, 45942, 45962, 45964, 
    45986, 45987, 45993, 46011, 46015, 
    46040, 46041, 46042, 46043, 46051, 
    46058, 46067, 46068, 46069, 46070, 
    46071, 46098, 46138, 46153, 46154, 
    46155, 46156, 46171, 46185, 46188, 
    46189, 46191, 46192, 46193, 46194, 
    46195, 46196, 46197, 46198, 46199, 
    46200, 46201, 46202, 46203, 46204, 
    46205, 46213, 46214, 46215, 46216, 
    46228, 46229, 46230, 46596, 53370, 
    86226, 86227, 86228, 105329
  )

Query time 0.00073

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 80 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
45523 S
45524 S
45525 S
45526 S
45527 S
45528 S
45555 S
45556 S
45626 S
45712 S
45744 S
45762 S
45763 S
45828 S
45835 S
45840 S
45847 S
45928 S
45937 S
45938 S
45939 S
45940 S
45941 S
45942 S
45962 S
45964 S
45986 S
45987 S
45993 S
46011 S
46015 S
46040 S
46041 S
46042 S
46043 S
46051 S
46058 S
46067 S
46068 S
46069 S
46070 S
46071 S
46098 S
46138 S
46153 S
46154 S
46155 S
46156 S
46171 S
46185 S
46188 S
46189 S
46191 S
46192 S
46193 S
46194 S
46195 S
46196 S
46197 S
46198 S
46199 S
46200 S
46201 S
46202 S
46203 S
46204 S
46205 S
46213 S
46214 S
46215 S
46216 S
46228 S
46229 S
46230 S
46596 S
53370 S
86226 S
86227 S
86228 S
105329 S