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 (
    46898, 46915, 46950, 46957, 46958, 46959, 
    46960, 46961, 47003, 47004, 47006, 
    47007, 47013, 47014, 47015, 47016, 
    47040, 47041, 47042, 47048, 47053, 
    47056, 47057, 47058, 47078, 47080, 
    47116, 47117, 47118, 47119, 47127, 
    47128, 47144, 47148, 47154, 47155, 
    47156, 47174, 47175, 47176, 47177, 
    47188, 47189, 47197, 47224, 47225, 
    47226, 47227, 47228, 47229, 47230, 
    47231, 47232, 47233, 47234, 47235, 
    47236, 47237, 47238, 47239, 47240, 
    47241, 47242, 47247, 47255, 47256, 
    47257, 47258, 47275, 47302, 47303, 
    47304, 47305, 47341, 47390, 47391, 
    47446, 47496, 47497, 53378
  )

Query time 0.00072

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
46898 S
46915 S
46950 S
46957 S
46958 S
46959 S
46960 S
46961 S
47003 S
47004 S
47006 S
47007 S
47013 S
47014 S
47015 S
47016 S
47040 S
47041 S
47042 S
47048 S
47053 S
47056 S
47057 S
47058 S
47078 S
47080 S
47116 S
47117 S
47118 S
47119 S
47127 S
47128 S
47144 S
47148 S
47154 S
47155 S
47156 S
47174 S
47175 S
47176 S
47177 S
47188 S
47189 S
47197 S
47224 S
47225 S
47226 S
47227 S
47228 S
47229 S
47230 S
47231 S
47232 S
47233 S
47234 S
47235 S
47236 S
47237 S
47238 S
47239 S
47240 S
47241 S
47242 S
47247 S
47255 S
47256 S
47257 S
47258 S
47275 S
47302 S
47303 S
47304 S
47305 S
47341 S
47390 S
47391 S
47446 S
47496 S
47497 S
53378 S