SELECT 
  a.*, 
  b.option_name, 
  b.internal_option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  cscart_product_options as a 
  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'en' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = a.option_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_options'
  ) 
WHERE 
  a.product_id IN (
    125358, 125461, 125089, 125066, 125487, 
    124934, 125127, 124797, 124795, 124990, 
    124970, 124816, 125134, 125133, 125030, 
    124778, 124470, 124653, 124477, 124475, 
    124857, 124312, 124309, 124180, 124483, 
    124302, 124301, 124033, 124449, 124269
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00118

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range PRIMARY,c_status c_status 6 30 Using index condition; Using filesort
1 SIMPLE b eq_ref PRIMARY PRIMARY 9 toolboxdigitalshop_dev.a.option_id,const 1 Using where
1 SIMPLE cscart_ult_objects_sharing eq_ref PRIMARY PRIMARY 159 toolboxdigitalshop_dev.a.option_id,const,const 1 Using where; Using index

Result

option_id product_id company_id option_type inventory regexp required multiupload allowed_extensions max_file_size missing_variants_handling status position value option_name internal_option_name option_text description inner_hint incorrect_message comment
118279 124816 1 S N N N 0 M A 0 Files Type Files Type
118544 125089 1 S N N N 0 M A 0 Files Type Files Type
117522 124033 1 S N N N 0 M A 0 Files Type Files Type
117780 124301 1 S N N N 0 M A 0 Files Type Files Type
117781 124302 1 S N N N 0 M A 0 Files Type Files Type
118807 125358 1 S N N N 0 M A 0 Files Type Files Type
117788 124309 1 S N N N 0 M A 0 Files Type Files Type
117791 124312 1 S N N N 0 M A 0 Files Type Files Type
118318 124857 1 S N N N 0 M A 0 Files Type Files Type
118581 125127 1 S N N N 0 M A 0 Files Type Files Type
118587 125133 1 S N N N 0 M A 0 Files Type Files Type
118588 125134 1 S N N N 0 M A 0 Files Type Files Type
118121 124653 1 S N N N 0 M A 0 Files Type Files Type
118393 124934 1 S N N N 0 M A 0 Files Type Files Type
118908 125461 1 S N N N 0 M A 0 Files Type Files Type
118934 125487 1 S N N N 0 M A 0 Files Type Files Type
118428 124970 1 S N N N 0 M A 0 Files Type Files Type
117664 124180 1 S N N N 0 M A 0 Files Type Files Type
117923 124449 1 S N N N 0 M A 0 Files Type Files Type
118448 124990 1 S N N N 0 M A 0 Files Type Files Type
117944 124470 1 S N N N 0 M A 0 Files Type Files Type
117949 124475 1 S N N N 0 M A 0 Files Type Files Type
117951 124477 1 S N N N 0 M A 0 Files Type Files Type
117957 124483 1 S N N N 0 M A 0 Files Type Files Type
118487 125030 1 S N N N 0 M A 0 Files Type Files Type
118241 124778 1 S N N N 0 M A 0 Files Type Files Type
118258 124795 1 S N N N 0 M A 0 Files Type Files Type
118260 124797 1 S N N N 0 M A 0 Files Type Files Type
117749 124269 1 S N N N 0 M A 0 Files Type Files Type
118522 125066 1 S N N N 0 M A 0 Files Type Files Type