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 (
    63561, 63562, 63563, 63564, 63565, 63566, 
    63568, 63569, 63570, 63600, 64205, 
    64206, 64207, 64208, 64209, 64210, 
    64211, 64212, 64213, 64214, 64215, 
    64216, 64217, 64218, 64219, 64220, 
    64221, 64222, 64223, 64224, 64225, 
    64226, 64227, 64228, 64229, 64230, 
    64231, 64232, 64233, 64234
  )

Query time 0.00058

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
63561 S
63562 S
63563 S
63564 S
63565 S
63566 S
63568 S
63569 S
63570 S
63600 S
64205 S
64206 S
64207 S
64208 S
64209 S
64210 S
64211 S
64212 S
64213 S
64214 S
64215 S
64216 S
64217 S
64218 S
64219 S
64220 S
64221 S
64222 S
64223 S
64224 S
64225 S
64226 S
64227 S
64228 S
64229 S
64230 S
64231 S
64232 S
64233 S
64234 S