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 (
    71171, 71172, 71173, 71174, 71175, 71176, 
    71177, 71283, 71458, 71497, 71889, 
    71890, 71891, 72040, 72074, 72088, 
    72234, 72304, 72489, 72500
  )

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 20 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
71171 S
71172 S
71173 S
71174 S
71175 S
71176 S
71177 S
71283 S
71458 S
71497 S
71889 S
71890 S
71891 S
72040 S
72074 S
72088 S
72234 S
72304 S
72489 S
72500 S