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 (
    44414, 44420, 44421, 44422, 44423, 44424, 
    44469, 44492, 44500, 44501, 44506, 
    44507, 44531, 44532, 44533, 44534, 
    44539, 44570, 44574, 44577, 44588, 
    44589, 44590, 44616, 44617, 44669, 
    44670, 44671, 44672, 44673, 44674, 
    44675, 44676, 44677, 44678, 44679, 
    44680, 44681, 44682, 44685, 44686, 
    44687, 44688, 44689, 44690, 44691, 
    44692, 44693, 44694, 44695, 44696, 
    44726, 44727, 44729, 44734, 44735, 
    44843, 44844, 44845, 44849, 44864, 
    44902, 44916, 44917, 44918, 44919, 
    44920, 44938, 44939, 44969, 44970, 
    44971, 44972, 44973, 44974, 44975, 
    44976, 45706, 83141, 83142
  )

Query time 0.00089

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
44414 S
44420 S
44421 S
44422 S
44423 S
44424 S
44469 S
44492 S
44500 S
44501 S
44506 S
44507 S
44531 S
44532 S
44533 S
44534 S
44539 S
44570 S
44574 S
44577 S
44588 S
44589 S
44590 S
44616 S
44617 S
44669 S
44670 S
44671 S
44672 S
44673 S
44674 S
44675 S
44676 S
44677 S
44678 S
44679 S
44680 S
44681 S
44682 S
44685 S
44686 S
44687 S
44688 S
44689 S
44690 S
44691 S
44692 S
44693 S
44694 S
44695 S
44696 S
44726 S
44727 S
44729 S
44734 S
44735 S
44843 S
44844 S
44845 S
44849 S
44864 S
44902 S
44916 S
44917 S
44918 S
44919 S
44920 S
44938 S
44939 S
44969 S
44970 S
44971 S
44972 S
44973 S
44974 S
44975 S
44976 S
45706 S
83141 S
83142 S