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 (
    79320, 79366, 79368, 79369, 79395, 79396, 
    79407, 79568, 79569, 79570, 79571, 
    79572, 79573, 79574, 79575, 79654, 
    79655, 79656, 79657, 79658, 79659, 
    79660, 79661, 79662, 79663, 79664, 
    79665, 79673, 79674, 79675, 79676, 
    79677, 79699, 79700, 79705, 79707, 
    79709, 79710, 79711, 79733
  )

Query time 0.00055

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
79320 S
79366 S
79368 S
79369 S
79395 S
79396 S
79407 S
79568 S
79569 S
79570 S
79571 S
79572 S
79573 S
79574 S
79575 S
79654 S
79655 S
79656 S
79657 S
79658 S
79659 S
79660 S
79661 S
79662 S
79663 S
79664 S
79665 S
79673 S
79674 S
79675 S
79676 S
79677 S
79699 S
79700 S
79705 S
79707 S
79709 S
79710 S
79711 S
79733 S