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 (
    100320, 100321, 100322, 100323, 100324, 
    100339, 100348, 100349, 100350, 100352, 
    100390, 100443, 100444, 100823, 100824, 
    100838, 100839, 100840, 100841, 100842
  )

Query time 0.00023

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
100320 S
100321 S
100322 S
100323 S
100324 S
100339 S
100348 S
100349 S
100350 S
100352 S
100390 S
100443 S
100444 S
100823 S
100824 S
100838 S
100839 S
100840 S
100841 S
100842 S