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 (
    41546, 41545, 41544, 41543, 41429, 41268, 
    41267, 41361, 41572, 41571, 41246, 
    41245, 41244, 41243, 41242, 41220, 
    41218, 41173, 41167, 41644, 41643, 
    41642, 41641, 41640, 41639, 41159, 
    41154, 41128, 41117, 41116, 41113, 
    41146, 41145, 41211, 41213, 41192, 
    41058, 41054, 41053, 41103, 41017, 
    40942, 40941, 40940, 40934, 40933, 
    40932, 40931, 40930, 40929, 40928, 
    40927, 40926, 40925, 40923, 40922, 
    40921, 40920, 40919, 40918, 40917, 
    40916, 40915, 40914, 40913, 40912, 
    40911, 40910, 40909, 40908, 40907, 
    40906, 40905, 40904, 40903, 40902, 
    40901, 40900, 40899, 41623
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00160

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range PRIMARY,c_status c_status 6 80 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
35851 41103 0 S N N N 0 M A 0 Files Type Files Type
36366 41639 0 S N N N 0 M A 0 Files Type Files Type
36367 41640 0 S N N N 0 M A 0 Files Type Files Type
36368 41641 1 S N N N 0 M A 0 Files Type Files Type
36369 41642 0 S N N N 0 M A 0 Files Type Files Type
36370 41643 1 S N N N 0 M A 0 Files Type Files Type
35859 41113 1 S N N N 0 M A 0 Files Type Files Type
36371 41644 0 S N N N 0 M A 0 Files Type Files Type
35862 41116 0 S N N N 0 M A 0 Files Type Files Type
35863 41117 0 S N N N 0 M A 0 Files Type Files Type
35874 41128 1 S N N N 0 M A 0 Files Type Files Type
35884 41145 1 S N N N 0 M A 0 Files Type Files Type
35885 41146 0 S N N N 0 M A 0 Files Type Files Type
35893 41154 1 S N N N 0 M A 0 Files Type Files Type
35898 41159 1 S N N N 0 M A 0 Files Type Files Type
36161 41429 1 S N N N 0 M A 0 Files Type Files Type
35906 41167 1 S N N N 0 M A 0 Files Type Files Type
35655 40899 0 S N N N 0 M A 0 Files Type Files Type
35656 40900 0 S N N N 0 M A 0 Files Type Files Type
35912 41173 1 S N N N 0 M A 0 Files Type Files Type
35657 40901 0 S N N N 0 M A 0 Files Type Files Type
35658 40902 0 S N N N 0 M A 0 Files Type Files Type
35659 40903 0 S N N N 0 M A 0 Files Type Files Type
35660 40904 0 S N N N 0 M A 0 Files Type Files Type
35661 40905 0 S N N N 0 M A 0 Files Type Files Type
35662 40906 0 S N N N 0 M A 0 Files Type Files Type
35663 40907 0 S N N N 0 M A 0 Files Type Files Type
35664 40908 0 S N N N 0 M A 0 Files Type Files Type
35665 40909 0 S N N N 0 M A 0 Files Type Files Type
35666 40910 0 S N N N 0 M A 0 Files Type Files Type
35667 40911 0 S N N N 0 M A 0 Files Type Files Type
35668 40912 0 S N N N 0 M A 0 Files Type Files Type
35669 40913 0 S N N N 0 M A 0 Files Type Files Type
35670 40914 0 S N N N 0 M A 0 Files Type Files Type
35671 40915 0 S N N N 0 M A 0 Files Type Files Type
35672 40916 0 S N N N 0 M A 0 Files Type Files Type
35673 40917 0 S N N N 0 M A 0 Files Type Files Type
35674 40918 0 S N N N 0 M A 0 Files Type Files Type
35675 40919 0 S N N N 0 M A 0 Files Type Files Type
35931 41192 0 S N N N 0 M A 0 Files Type Files Type
35676 40920 0 S N N N 0 M A 0 Files Type Files Type
35677 40921 0 S N N N 0 M A 0 Files Type Files Type
35678 40922 0 S N N N 0 M A 0 Files Type Files Type
35679 40923 0 S N N N 0 M A 0 Files Type Files Type
35680 40925 0 S N N N 0 M A 0 Files Type Files Type
35681 40926 0 S N N N 0 M A 0 Files Type Files Type
35682 40927 0 S N N N 0 M A 0 Files Type Files Type
35683 40928 0 S N N N 0 M A 0 Files Type Files Type
35684 40929 0 S N N N 0 M A 0 Files Type Files Type
35685 40930 0 S N N N 0 M A 0 Files Type Files Type
35686 40931 1 S N N N 0 M A 0 Files Type Files Type
35687 40932 0 S N N N 0 M A 0 Files Type Files Type
35688 40933 0 S N N N 0 M A 0 Files Type Files Type
35689 40934 0 S N N N 0 M A 0 Files Type Files Type
35949 41211 1 S N N N 0 M A 0 Files Type Files Type
35694 40940 0 S N N N 0 M A 0 Files Type Files Type
35695 40941 0 S N N N 0 M A 0 Files Type Files Type
35951 41213 0 S N N N 0 M A 0 Files Type Files Type
35696 40942 0 S N N N 0 M A 0 Files Type Files Type
35956 41218 1 S N N N 0 M A 0 Files Type Files Type
35958 41220 0 S N N N 0 M A 0 Files Type Files Type
35979 41242 1 S N N N 0 M A 0 Files Type Files Type
35980 41243 0 S N N N 0 M A 0 Files Type Files Type
35981 41244 0 S N N N 0 M A 0 Files Type Files Type
35982 41245 0 S N N N 0 M A 0 Files Type Files Type
35983 41246 0 S N N N 0 M A 0 Files Type Files Type
36002 41267 0 S N N N 0 M A 0 Files Type Files Type
36003 41268 0 S N N N 0 M A 0 Files Type Files Type
36272 41543 0 S N N N 0 M A 0 Files Type Files Type
36273 41544 0 S N N N 0 M A 0 Files Type Files Type
36274 41545 0 S N N N 0 M A 0 Files Type Files Type
36275 41546 0 S N N N 0 M A 0 Files Type Files Type
35768 41017 0 S N N N 0 M A 0 Files Type Files Type
36299 41571 1 S N N N 0 M A 0 Files Type Files Type
36300 41572 1 S N N N 0 M A 0 Files Type Files Type
35802 41053 0 S N N N 0 M A 0 Files Type Files Type
35803 41054 0 S N N N 0 M A 0 Files Type Files Type
35807 41058 1 S N N N 0 M A 0 Files Type Files Type
36094 41361 1 S N N N 0 M A 0 Files Type Files Type
36351 41623 0 S N N N 0 M A 0 Files Type Files Type