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 (
    63967, 63968, 64566, 64594, 64713, 64748, 
    64790, 64815, 64854, 64858, 64861, 
    64934, 64935, 64938, 64939, 64961, 
    64963, 64977, 64986, 64987, 64988, 
    65009, 65045, 65053, 65054, 65108, 
    65138, 65139, 65168, 65211, 65213, 
    65215, 65309, 65310, 65311, 65312, 
    65314, 65315, 65357, 65391
  )

Query time 0.00060

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
63967 S
63968 S
64566 S
64594 S
64713 S
64748 S
64790 S
64815 S
64854 S
64858 S
64861 S
64934 S
64935 S
64938 S
64939 S
64961 S
64963 S
64977 S
64986 S
64987 S
64988 S
65009 S
65045 S
65053 S
65054 S
65108 S
65138 S
65139 S
65168 S
65211 S
65213 S
65215 S
65309 S
65310 S
65311 S
65312 S
65314 S
65315 S
65357 S
65391 S