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 (
    63658, 63734, 63882, 63933, 63937, 63938, 
    63939, 63940, 63941, 63942, 64375, 
    64382, 64508, 64509, 64510, 64511, 
    64512, 64513, 64514, 64515, 64516, 
    64517, 64518, 64519, 64520, 64521, 
    64522, 64523, 64524, 64525, 64526, 
    64527, 64528, 64529, 64530, 64531, 
    64532, 64533, 64534, 64535
  )

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
63658 S
63734 S
63882 S
63933 S
63937 S
63938 S
63939 S
63940 S
63941 S
63942 S
64375 S
64382 S
64508 S
64509 S
64510 S
64511 S
64512 S
64513 S
64514 S
64515 S
64516 S
64517 S
64518 S
64519 S
64520 S
64521 S
64522 S
64523 S
64524 S
64525 S
64526 S
64527 S
64528 S
64529 S
64530 S
64531 S
64532 S
64533 S
64534 S
64535 S