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 (
    63472, 63487, 63554, 63555, 63556, 63557, 
    63558, 63559, 63560, 63653, 63672, 
    63683, 63846, 73219, 73220, 73221, 
    73222, 73223, 73224, 73225, 73226, 
    73227, 73228, 73229, 73230, 73231, 
    73232, 73233, 73234, 73235, 73236, 
    73237, 73238, 73239, 73240, 73241, 
    73242, 73243, 73244, 73245
  )

Query time 0.00049

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
63472 S
63487 S
63554 S
63555 S
63556 S
63557 S
63558 S
63559 S
63560 S
63653 S
63672 S
63683 S
63846 S
73219 S
73220 S
73221 S
73222 S
73223 S
73224 S
73225 S
73226 S
73227 S
73228 S
73229 S
73230 S
73231 S
73232 S
73233 S
73234 S
73235 S
73236 S
73237 S
73238 S
73239 S
73240 S
73241 S
73242 S
73243 S
73244 S
73245 S