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 (
    89019, 89018, 89017, 89016, 89015, 89014, 
    88971, 89484, 89444, 89278, 88869, 
    88868, 89442, 89441, 89440, 89439, 
    89438, 89139, 89138, 89137, 89136, 
    89135, 89134, 89133, 89132, 89131, 
    89130, 89129, 89128, 89127, 89126, 
    89125, 89124, 89123, 89122, 88918, 
    88726, 88725, 88724, 88723
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00132

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
83759 89122 1 S N N N 0 M A 0 Files Type Files Type
83760 89123 1 S N N N 0 M A 0 Files Type Files Type
83761 89124 1 S N N N 0 M A 0 Files Type Files Type
83762 89125 1 S N N N 0 M A 0 Files Type Files Type
83763 89126 1 S N N N 0 M A 0 Files Type Files Type
83764 89127 1 S N N N 0 M A 0 Files Type Files Type
83765 89128 1 S N N N 0 M A 0 Files Type Files Type
83766 89129 1 S N N N 0 M A 0 Files Type Files Type
83511 88868 1 S N N N 0 M A 0 Files Type Files Type
83767 89130 1 S N N N 0 M A 0 Files Type Files Type
83512 88869 1 S N N N 0 M A 0 Files Type Files Type
83768 89131 1 S N N N 0 M A 0 Files Type Files Type
83769 89132 1 S N N N 0 M A 0 Files Type Files Type
83770 89133 1 S N N N 0 M A 0 Files Type Files Type
83771 89134 1 S N N N 0 M A 0 Files Type Files Type
83772 89135 1 S N N N 0 M A 0 Files Type Files Type
83773 89136 1 S N N N 0 M A 0 Files Type Files Type
83774 89137 1 S N N N 0 M A 0 Files Type Files Type
83775 89138 1 S N N N 0 M A 0 Files Type Files Type
83776 89139 1 S N N N 0 M A 0 Files Type Files Type
84065 89438 1 S N N N 0 M A 0 Files Type Files Type
84066 89439 1 S N N N 0 M A 0 Files Type Files Type
84067 89440 1 S N N N 0 M A 0 Files Type Files Type
84068 89441 1 S N N N 0 M A 0 Files Type Files Type
84069 89442 1 S N N N 0 M A 0 Files Type Files Type
84071 89444 1 S N N N 0 M A 0 Files Type Files Type
83560 88918 1 S N N N 0 M A 0 Files Type Files Type
84110 89484 1 S N N N 0 M A 0 Files Type Files Type
83612 88971 1 S N N N 0 M A 0 Files Type Files Type
83369 88723 1 S N N N 0 M A 0 Files Type Files Type
83370 88724 1 S N N N 0 M A 0 Files Type Files Type
83371 88725 1 S N N N 0 M A 0 Files Type Files Type
83372 88726 1 S N N N 0 M A 0 Files Type Files Type
83910 89278 1 S N N N 0 M A 0 Files Type Files Type
83655 89014 1 S N N N 0 M A 0 Files Type Files Type
83656 89015 1 S N N N 0 M A 0 Files Type Files Type
83657 89016 1 S N N N 0 M A 0 Files Type Files Type
83658 89017 1 S N N N 0 M A 0 Files Type Files Type
83659 89018 1 S N N N 0 M A 0 Files Type Files Type
83660 89019 1 S N N N 0 M A 0 Files Type Files Type