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 (
    81719, 81761, 81775, 81776, 81777, 81849, 
    81850, 81861, 82047, 82048, 82092, 
    82093, 82094, 82095, 82096, 82097, 
    82098, 82099, 82100, 82101, 82156, 
    82337, 82340, 82353, 82354, 82385, 
    82386, 82388, 82389, 82390, 82391, 
    82526, 82527, 82528, 82789, 82790, 
    82791, 82792, 82793, 82794
  )

Query time 0.00050

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
81719 S
81761 S
81775 S
81776 S
81777 S
81849 S
81850 S
81861 S
82047 S
82048 S
82092 S
82093 S
82094 S
82095 S
82096 S
82097 S
82098 S
82099 S
82100 S
82101 S
82156 S
82337 S
82340 S
82353 S
82354 S
82385 S
82386 S
82388 S
82389 S
82390 S
82391 S
82526 S
82527 S
82528 S
82789 S
82790 S
82791 S
82792 S
82793 S
82794 S