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 (
    51844, 52449, 52672, 52731, 52804, 52859, 
    52933, 52985, 52986, 52987, 52988, 
    52989, 52990, 52991, 52992, 52993, 
    52994, 52995, 52996, 52997, 52998, 
    52999, 53000, 53001, 53002, 53003, 
    53004, 53005, 53006, 53007, 53008, 
    53009, 53010, 53011, 53012, 53013, 
    53014, 53015, 53016, 53161
  )

Query time 0.00056

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
51844 S
52449 S
52672 S
52731 S
52804 S
52859 S
52933 S
52985 S
52986 S
52987 S
52988 S
52989 S
52990 S
52991 S
52992 S
52993 S
52994 S
52995 S
52996 S
52997 S
52998 S
52999 S
53000 S
53001 S
53002 S
53003 S
53004 S
53005 S
53006 S
53007 S
53008 S
53009 S
53010 S
53011 S
53012 S
53013 S
53014 S
53015 S
53016 S
53161 S