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 (
    105622, 105628, 105629, 105630, 105631, 
    105632, 105633, 105634, 105635, 105636, 
    105637, 105638, 105639, 105640, 105641, 
    105642, 105643, 105644, 105778, 105836
  )

Query time 0.00037

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
105622 S
105628 S
105629 S
105630 S
105631 S
105632 S
105633 S
105634 S
105635 S
105636 S
105637 S
105638 S
105639 S
105640 S
105641 S
105642 S
105643 S
105644 S
105778 S
105836 S