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 (
    36749, 65359, 65597, 65598, 66229, 66237, 
    66325, 66340, 66368, 66389, 66390, 
    66392, 66393, 66416, 66441, 66442, 
    66489, 66496, 66497, 66502, 66529, 
    66530, 66554, 66555, 66639, 66640, 
    66665, 66692, 66752, 66786, 66787, 
    66937, 66938, 67379, 67994, 67996, 
    67997, 68061, 68243, 68248
  )

Query time 0.00049

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
36749 S
65359 S
65597 S
65598 S
66229 S
66237 S
66325 S
66340 S
66368 S
66389 S
66390 S
66392 S
66393 S
66416 S
66441 S
66442 S
66489 S
66496 S
66497 S
66502 S
66529 S
66530 S
66554 S
66555 S
66639 S
66640 S
66665 S
66692 S
66752 S
66786 S
66787 S
66937 S
66938 S
67379 S
67994 S
67996 S
67997 S
68061 S
68243 S
68248 S