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 (
    41282, 41297, 41339, 41376, 41462, 41463, 
    41496, 41504, 41511, 41512, 41513, 
    41514, 41515, 41517, 41521, 41522, 
    41526, 41527, 41528, 41529, 41530, 
    41531, 41532, 41592, 41593, 41594, 
    41617, 41618, 41619, 41620, 41621, 
    41622, 41623, 41624, 41625, 41626, 
    41627, 41628, 41629, 41633, 41640, 
    41682, 41683, 41684, 41685, 41686, 
    41687, 41688, 41689, 41690, 41691, 
    41692, 41693, 41694, 41696, 41773, 
    41776, 41777, 41778, 41779, 41780, 
    41781, 41782, 41783, 41784, 41785, 
    41786, 41787, 41788, 41789, 41790, 
    41791, 41808, 41810, 41811, 41824, 
    42021, 42056, 45703, 45705
  )

Query time 0.00067

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
41282 S
41297 S
41339 S
41376 S
41462 S
41463 S
41496 S
41504 S
41511 S
41512 S
41513 S
41514 S
41515 S
41517 S
41521 S
41522 S
41526 S
41527 S
41528 S
41529 S
41530 S
41531 S
41532 S
41592 S
41593 S
41594 S
41617 S
41618 S
41619 S
41620 S
41621 S
41622 S
41623 S
41624 S
41625 S
41626 S
41627 S
41628 S
41629 S
41633 S
41640 S
41682 S
41683 S
41684 S
41685 S
41686 S
41687 S
41688 S
41689 S
41690 S
41691 S
41692 S
41693 S
41694 S
41696 S
41773 S
41776 S
41777 S
41778 S
41779 S
41780 S
41781 S
41782 S
41783 S
41784 S
41785 S
41786 S
41787 S
41788 S
41789 S
41790 S
41791 S
41808 S
41810 S
41811 S
41824 S
42021 S
42056 S
45703 S
45705 S