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 (
    34689, 34690, 34699, 34705, 34731, 34741, 
    34743, 34747, 34748, 34749, 34750, 
    34751, 34752, 34753, 34754, 34755, 
    34756, 34757, 34758, 34760, 34762, 
    34771, 34774, 34777, 34785, 34786, 
    34787, 34849, 34859, 34865, 34866, 
    34870, 34874, 34875, 34876, 34877, 
    34879, 34880, 34883, 34884, 34888, 
    34889, 34928, 34929, 34930, 34934, 
    34935, 34943, 34944, 34945, 34952, 
    34963, 34964, 34965, 35007, 35298, 
    35380, 35384, 35385, 35393, 35532, 
    35533, 35534, 35535, 35538, 35539, 
    35615, 35702, 74833, 74837, 74847, 
    85618, 85619, 85620, 85621, 85622, 
    85623, 85624, 85625, 85626
  )

Query time 0.00068

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
34689 S
34690 S
34699 S
34705 S
34731 S
34741 S
34743 S
34747 S
34748 S
34749 S
34750 S
34751 S
34752 S
34753 S
34754 S
34755 S
34756 S
34757 S
34758 S
34760 S
34762 S
34771 S
34774 S
34777 S
34785 S
34786 S
34787 S
34849 S
34859 S
34865 S
34866 S
34870 S
34874 S
34875 S
34876 S
34877 S
34879 S
34880 S
34883 S
34884 S
34888 S
34889 S
34928 S
34929 S
34930 S
34934 S
34935 S
34943 S
34944 S
34945 S
34952 S
34963 S
34964 S
34965 S
35007 S
35298 S
35380 S
35384 S
35385 S
35393 S
35532 S
35533 S
35534 S
35535 S
35538 S
35539 S
35615 S
35702 S
74833 S
74837 S
74847 S
85618 S
85619 S
85620 S
85621 S
85622 S
85623 S
85624 S
85625 S
85626 S