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 (
    64978, 65209, 65210, 65212, 65214, 65248, 
    65249, 65352, 65353, 65354, 65392, 
    65465, 65466, 65577, 65594, 65595, 
    65599, 65666, 65667, 65668, 65669, 
    65691, 65692, 65695, 65725, 65766, 
    65768, 65807, 65811, 65812, 65814, 
    65815, 65827, 65866, 65918, 65919, 
    65920, 65921, 65949, 66032
  )

Query time 0.00047

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
64978 S
65209 S
65210 S
65212 S
65214 S
65248 S
65249 S
65352 S
65353 S
65354 S
65392 S
65465 S
65466 S
65577 S
65594 S
65595 S
65599 S
65666 S
65667 S
65668 S
65669 S
65691 S
65692 S
65695 S
65725 S
65766 S
65768 S
65807 S
65811 S
65812 S
65814 S
65815 S
65827 S
65866 S
65918 S
65919 S
65920 S
65921 S
65949 S
66032 S