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 (
    63083, 63084, 63085, 63086, 63087, 63088, 
    63089, 63090, 63091, 63092, 63093, 
    63094, 63095, 63096, 63097, 63098, 
    63099, 63100, 63101, 63102, 63966, 
    64100, 64256, 64262, 64362, 64595, 
    64597, 64647, 64656, 64677, 64692, 
    64694, 64704, 64747, 64749, 64750, 
    64751, 64855, 64856, 64857
  )

Query time 0.00039

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
63083 S
63084 S
63085 S
63086 S
63087 S
63088 S
63089 S
63090 S
63091 S
63092 S
63093 S
63094 S
63095 S
63096 S
63097 S
63098 S
63099 S
63100 S
63101 S
63102 S
63966 S
64100 S
64256 S
64262 S
64362 S
64595 S
64597 S
64647 S
64656 S
64677 S
64692 S
64694 S
64704 S
64747 S
64749 S
64750 S
64751 S
64855 S
64856 S
64857 S