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 (
    81311, 81312, 81313, 81400, 81536, 81546, 
    81547, 81548, 81549, 81550, 81551, 
    81583, 81678, 81679, 81707, 81708, 
    81717, 81720, 81764, 81765, 81766, 
    81838, 81839, 81840, 81841, 81854, 
    81855, 81860, 81956, 81976, 81977, 
    82042, 82119, 82120, 82143, 82159, 
    82741, 82742, 82743, 82744
  )

Query time 0.00054

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
81311 S
81312 S
81313 S
81400 S
81536 S
81546 S
81547 S
81548 S
81549 S
81550 S
81551 S
81583 S
81678 S
81679 S
81707 S
81708 S
81717 S
81720 S
81764 S
81765 S
81766 S
81838 S
81839 S
81840 S
81841 S
81854 S
81855 S
81860 S
81956 S
81976 S
81977 S
82042 S
82119 S
82120 S
82143 S
82159 S
82741 S
82742 S
82743 S
82744 S