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 (
    69618, 69616, 69615, 69459, 69449, 69401, 
    69350, 69507, 69506, 69505, 69503, 
    69447, 69410, 68998, 68698, 67810, 
    67809, 67808, 67807, 67806, 67805, 
    67804, 67803, 67802, 67801, 67800, 
    67799, 67798, 67797, 67796, 67795, 
    67794, 67793, 67792, 67791, 69107, 
    69432, 69348, 69005, 68836
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00099

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
64256 68998 1 S N N N 0 M A 0 Files Type Files Type
64262 69005 1 S N N N 0 M A 0 Files Type Files Type
64595 69348 1 S N N N 0 M A 0 Files Type Files Type
64597 69350 1 S N N N 0 M A 0 Files Type Files Type
64855 69615 1 S N N N 0 M A 0 Files Type Files Type
64856 69616 1 S N N N 0 M A 0 Files Type Files Type
64857 69618 1 S N N N 0 M A 0 Files Type Files Type
64100 68836 1 S N N N 0 M A 0 Files Type Files Type
64362 69107 1 S N N N 0 M A 0 Files Type Files Type
63083 67791 1 S N N N 0 M A 0 Files Type Files Type
63084 67792 1 S N N N 0 M A 0 Files Type Files Type
63085 67793 1 S N N N 0 M A 0 Files Type Files Type
63086 67794 1 S N N N 0 M A 0 Files Type Files Type
63087 67795 1 S N N N 0 M A 0 Files Type Files Type
63088 67796 1 S N N N 0 M A 0 Files Type Files Type
63089 67797 1 S N N N 0 M A 0 Files Type Files Type
63090 67798 1 S N N N 0 M A 0 Files Type Files Type
63091 67799 1 S N N N 0 M A 0 Files Type Files Type
63092 67800 1 S N N N 0 M A 0 Files Type Files Type
63093 67801 1 S N N N 0 M A 0 Files Type Files Type
63094 67802 1 S N N N 0 M A 0 Files Type Files Type
63095 67803 1 S N N N 0 M A 0 Files Type Files Type
63096 67804 1 S N N N 0 M A 0 Files Type Files Type
63097 67805 1 S N N N 0 M A 0 Files Type Files Type
63098 67806 1 S N N N 0 M A 0 Files Type Files Type
63099 67807 1 S N N N 0 M A 0 Files Type Files Type
63100 67808 1 S N N N 0 M A 0 Files Type Files Type
63101 67809 1 S N N N 0 M A 0 Files Type Files Type
63102 67810 1 S N N N 0 M A 0 Files Type Files Type
64647 69401 1 S N N N 0 M A 0 Files Type Files Type
64656 69410 1 S N N N 0 M A 0 Files Type Files Type
64677 69432 1 S N N N 0 M A 0 Files Type Files Type
64692 69447 1 S N N N 0 M A 0 Files Type Files Type
64694 69449 1 S N N N 0 M A 0 Files Type Files Type
64704 69459 1 S N N N 0 M A 0 Files Type Files Type
63966 68698 1 S N N N 0 M A 0 Files Type Files Type
64747 69503 1 S N N N 0 M A 0 Files Type Files Type
64749 69505 1 S N N N 0 M A 0 Files Type Files Type
64750 69506 1 S N N N 0 M A 0 Files Type Files Type
64751 69507 1 S N N N 0 M A 0 Files Type Files Type