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 (
    36750, 38896, 38897, 43836, 64089, 66688, 
    66689, 66690, 66691, 66888, 66900, 
    67215, 67979, 67995, 67998, 67999, 
    68000, 68001, 68154, 68242, 68246, 
    68247, 68250, 68285, 68286, 68345, 
    68364, 68366, 68367, 68379, 68397, 
    68398, 68411, 68473, 68474, 68475, 
    68476, 68526, 68527, 68528
  )

Query time 0.00063

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
36750 S
38896 S
38897 S
43836 S
64089 S
66688 S
66689 S
66690 S
66691 S
66888 S
66900 S
67215 S
67979 S
67995 S
67998 S
67999 S
68000 S
68001 S
68154 S
68242 S
68246 S
68247 S
68250 S
68285 S
68286 S
68345 S
68364 S
68366 S
68367 S
68379 S
68397 S
68398 S
68411 S
68473 S
68474 S
68475 S
68476 S
68526 S
68527 S
68528 S