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 (
    65355, 65460, 65461, 65521, 65596, 65767, 
    65769, 65770, 65773, 65774, 66033, 
    66034, 66037, 66047, 66048, 66049, 
    66050, 66100, 66101, 66138, 66165, 
    66170, 66210, 66226, 66227, 66228, 
    66230, 66275, 66276, 66278, 66292, 
    66326, 66331, 66342, 66369, 66370, 
    66371, 66372, 66391, 66414
  )

Query time 0.00052

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options range PRIMARY PRIMARY 3 40 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
65355 S
65460 S
65461 S
65521 S
65596 S
65767 S
65769 S
65770 S
65773 S
65774 S
66033 S
66034 S
66037 S
66047 S
66048 S
66049 S
66050 S
66100 S
66101 S
66138 S
66165 S
66170 S
66210 S
66226 S
66227 S
66228 S
66230 S
66275 S
66276 S
66278 S
66292 S
66326 S
66331 S
66342 S
66369 S
66370 S
66371 S
66372 S
66391 S
66414 S