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 (
    95595, 95594, 95593, 95592, 95591, 95590, 
    95589, 95588, 95587, 95586, 95585, 
    95584, 95583, 95582, 95581, 95580, 
    95579, 95578, 95577, 95576, 95575, 
    95574, 95573, 95572, 95571, 94905, 
    95440, 95439, 94679, 94678, 94677, 
    94676, 94675, 94674, 94673, 94672, 
    94659, 94629, 94628, 94626
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00126

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range PRIMARY,c_status c_status 6 40 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
89110 94626 1 S N N N 0 M A 0 Files Type Files Type
89111 94628 1 S N N N 0 M A 0 Files Type Files Type
89112 94629 1 S N N N 0 M A 0 Files Type Files Type
89378 94905 1 S N N N 0 M A 0 Files Type Files Type
89901 95439 1 S N N N 0 M A 0 Files Type Files Type
89141 94659 1 S N N N 0 M A 0 Files Type Files Type
89154 94672 1 S N N N 0 M A 0 Files Type Files Type
89155 94673 1 S N N N 0 M A 0 Files Type Files Type
89156 94674 1 S N N N 0 M A 0 Files Type Files Type
89157 94675 1 S N N N 0 M A 0 Files Type Files Type
89158 94676 1 S N N N 0 M A 0 Files Type Files Type
89159 94677 1 S N N N 0 M A 0 Files Type Files Type
89160 94678 1 S N N N 0 M A 0 Files Type Files Type
89161 94679 1 S N N N 0 M A 0 Files Type Files Type
90024 95571 1 S N N N 0 M A 0 Files Type Files Type
90025 95572 1 S N N N 0 M A 0 Files Type Files Type
90026 95573 1 S N N N 0 M A 0 Files Type Files Type
90027 95574 1 S N N N 0 M A 0 Files Type Files Type
90028 95575 1 S N N N 0 M A 0 Files Type Files Type
90029 95576 1 S N N N 0 M A 0 Files Type Files Type
90030 95577 1 S N N N 0 M A 0 Files Type Files Type
90031 95578 1 S N N N 0 M A 0 Files Type Files Type
90032 95579 1 S N N N 0 M A 0 Files Type Files Type
90033 95580 1 S N N N 0 M A 0 Files Type Files Type
90034 95581 1 S N N N 0 M A 0 Files Type Files Type
90035 95582 1 S N N N 0 M A 0 Files Type Files Type
90036 95583 1 S N N N 0 M A 0 Files Type Files Type
90037 95584 1 S N N N 0 M A 0 Files Type Files Type
90038 95585 1 S N N N 0 M A 0 Files Type Files Type
90039 95586 1 S N N N 0 M A 0 Files Type Files Type
90040 95587 1 S N N N 0 M A 0 Files Type Files Type
90041 95588 1 S N N N 0 M A 0 Files Type Files Type
90042 95589 1 S N N N 0 M A 0 Files Type Files Type
90043 95590 1 S N N N 0 M A 0 Files Type Files Type
90044 95591 1 S N N N 0 M A 0 Files Type Files Type
90045 95592 1 S N N N 0 M A 0 Files Type Files Type
90046 95593 1 S N N N 0 M A 0 Files Type Files Type
90047 95594 1 S N N N 0 M A 0 Files Type Files Type
90048 95595 1 S N N N 0 M A 0 Files Type Files Type