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 (
    83051, 83067, 83114, 83115, 83116, 83134, 
    83135, 83136, 83165, 83473, 83474, 
    83475, 83476, 83485, 83486, 83587, 
    83588, 83589, 83590, 83591, 83592, 
    83593, 83623, 83624, 83625, 83626, 
    83627, 83628, 83629, 83630, 83631, 
    83632, 83633, 83652, 83653, 83654, 
    83830, 83831, 83832, 83987
  )

Query time 0.00094

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
83051 S
83067 S
83114 S
83115 S
83116 S
83134 S
83135 S
83136 S
83165 S
83473 S
83474 S
83475 S
83476 S
83485 S
83486 S
83587 S
83588 S
83589 S
83590 S
83591 S
83592 S
83593 S
83623 S
83624 S
83625 S
83626 S
83627 S
83628 S
83629 S
83630 S
83631 S
83632 S
83633 S
83652 S
83653 S
83654 S
83830 S
83831 S
83832 S
83987 S