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 (
    54272, 54273, 54274, 54761, 54764, 55352, 
    55389, 55455, 55632, 55695, 55696, 
    55697, 55810, 55811, 55881, 55938, 
    55972, 56013, 56014, 56021, 56126, 
    56245, 56272, 56356, 56464, 56500, 
    56501, 56503, 56514, 56515, 56516, 
    56517, 56518, 56519, 56520, 56521, 
    56522, 56523, 56524, 56525
  )

Query time 0.00051

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
54272 S
54273 S
54274 S
54761 S
54764 S
55352 S
55389 S
55455 S
55632 S
55695 S
55696 S
55697 S
55810 S
55811 S
55881 S
55938 S
55972 S
56013 S
56014 S
56021 S
56126 S
56245 S
56272 S
56356 S
56464 S
56500 S
56501 S
56503 S
56514 S
56515 S
56516 S
56517 S
56518 S
56519 S
56520 S
56521 S
56522 S
56523 S
56524 S
56525 S