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 (
    82356, 82406, 82407, 82408, 82409, 82439, 
    82525, 82710, 82750, 82751, 82755, 
    82756, 82757, 82758, 82759, 82760, 
    82761, 82762, 82763, 82764, 82815, 
    83056, 83057, 83058, 83059, 83060, 
    83061, 83181, 83182, 83183, 83223, 
    83224, 83225, 83272, 83273, 83274, 
    83275, 83276, 83277, 83278
  )

Query time 0.00034

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
82356 S
82406 S
82407 S
82408 S
82409 S
82439 S
82525 S
82710 S
82750 S
82751 S
82755 S
82756 S
82757 S
82758 S
82759 S
82760 S
82761 S
82762 S
82763 S
82764 S
82815 S
83056 S
83057 S
83058 S
83059 S
83060 S
83061 S
83181 S
83182 S
83183 S
83223 S
83224 S
83225 S
83272 S
83273 S
83274 S
83275 S
83276 S
83277 S
83278 S