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 (
    90331, 90332, 90333, 90342, 90343, 90344, 
    90345, 90346, 90347, 90348, 90349, 
    90350, 90351, 90352, 90353, 90354, 
    90355, 90356, 90357, 90358, 90359, 
    90360, 90361, 90362, 90366, 90367, 
    90369, 90550, 90551, 91047, 91048, 
    91049, 91050, 91051, 91052, 91053, 
    91054, 91055, 91056, 91057
  )

Query time 0.00031

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
90331 S
90332 S
90333 S
90342 S
90343 S
90344 S
90345 S
90346 S
90347 S
90348 S
90349 S
90350 S
90351 S
90352 S
90353 S
90354 S
90355 S
90356 S
90357 S
90358 S
90359 S
90360 S
90361 S
90362 S
90366 S
90367 S
90369 S
90550 S
90551 S
91047 S
91048 S
91049 S
91050 S
91051 S
91052 S
91053 S
91054 S
91055 S
91056 S
91057 S