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 (
    64103, 64104, 64105, 64106, 64110, 64113, 
    64115, 64116, 64117, 64118, 64119, 
    64120, 64121, 64174, 64176, 64178, 
    64179, 64183, 64184, 64185, 64186, 
    64187, 64188, 64189, 64190, 64191, 
    64192, 64193, 64194, 64195, 64197, 
    64198, 64199, 64385, 64386, 64502, 
    64536, 64650, 64651, 64658
  )

Query time 0.00066

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
64103 S
64104 S
64105 S
64106 S
64110 S
64113 S
64115 S
64116 S
64117 S
64118 S
64119 S
64120 S
64121 S
64174 S
64176 S
64178 S
64179 S
64183 S
64184 S
64185 S
64186 S
64187 S
64188 S
64189 S
64190 S
64191 S
64192 S
64193 S
64194 S
64195 S
64197 S
64198 S
64199 S
64385 S
64386 S
64502 S
64536 S
64650 S
64651 S
64658 S