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 (
    43643, 43644, 43645, 43646, 43655, 43656, 
    43657, 43658, 43670, 43674, 43675, 
    43676, 43677, 43678, 43679, 43680, 
    43681, 43682, 43683, 43684, 43685, 
    43686, 43687, 43688, 43692, 43693, 
    43694, 43710, 43725, 43726, 43738, 
    43739, 43740, 43743, 43744, 43745, 
    43781, 43782, 43790, 43791, 43801, 
    43802, 43803, 43827, 43828, 43841, 
    43844, 43845, 43846, 43903, 43930, 
    43945, 43948, 43949, 43954, 43992, 
    43993, 43994, 43995, 44046, 44047, 
    44051, 44056, 44095, 44096, 44097, 
    44098, 44099, 44100, 44101, 44102, 
    44103, 44104, 44105, 44106, 44107, 
    44108, 44213, 44378, 44543
  )

Query time 0.00076

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 80 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
43643 S
43644 S
43645 S
43646 S
43655 S
43656 S
43657 S
43658 S
43670 S
43674 S
43675 S
43676 S
43677 S
43678 S
43679 S
43680 S
43681 S
43682 S
43683 S
43684 S
43685 S
43686 S
43687 S
43688 S
43692 S
43693 S
43694 S
43710 S
43725 S
43726 S
43738 S
43739 S
43740 S
43743 S
43744 S
43745 S
43781 S
43782 S
43790 S
43791 S
43801 S
43802 S
43803 S
43827 S
43828 S
43841 S
43844 S
43845 S
43846 S
43903 S
43930 S
43945 S
43948 S
43949 S
43954 S
43992 S
43993 S
43994 S
43995 S
44046 S
44047 S
44051 S
44056 S
44095 S
44096 S
44097 S
44098 S
44099 S
44100 S
44101 S
44102 S
44103 S
44104 S
44105 S
44106 S
44107 S
44108 S
44213 S
44378 S
44543 S