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 (
    48473, 48713, 48706, 48297, 48920, 48671, 
    48670, 48302, 48276, 48275, 48238, 
    48270, 48271, 48266, 48265, 48264, 
    48263, 48246, 48277, 48247, 48259, 
    48258, 48257, 48256, 48255, 48248, 
    48237, 48236, 48233, 48201, 48103, 
    48102, 48267, 48047, 48192, 48120, 
    48101, 48100, 48099, 48097, 47985, 
    47984, 48078, 48046, 48410, 48409, 
    48408, 48407, 48406, 48405, 48404, 
    48403, 48402, 48401, 48400, 48399, 
    48398, 48397, 48396, 48395, 48394, 
    48393, 48392, 48391, 48390, 48389, 
    48388, 48387, 48386, 48385, 48384, 
    48383, 48382, 48381, 48380, 48379, 
    48378, 48377, 48376, 48375
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00161

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
42768 48233 0 S N N N 0 M A 0 Files Type Files Type
42771 48236 0 S N N N 0 M A 0 Files Type Files Type
42772 48237 0 S N N N 0 M A 0 Files Type Files Type
42773 48238 1 S N N N 0 M A 0 Files Type Files Type
42781 48246 1 S N N N 0 M A 0 Files Type Files Type
42782 48247 1 S N N N 0 M A 0 Files Type Files Type
42783 48248 1 S N N N 0 M A 0 Files Type Files Type
42528 47984 0 S N N N 0 M A 0 Files Type Files Type
42529 47985 1 S N N N 0 M A 0 Files Type Files Type
42790 48255 0 S N N N 0 M A 0 Files Type Files Type
42791 48256 0 S N N N 0 M A 0 Files Type Files Type
42792 48257 0 S N N N 0 M A 0 Files Type Files Type
42793 48258 0 S N N N 0 M A 0 Files Type Files Type
42794 48259 0 S N N N 0 M A 0 Files Type Files Type
42798 48263 0 S N N N 0 M A 0 Files Type Files Type
42799 48264 0 S N N N 0 M A 0 Files Type Files Type
42800 48265 0 S N N N 0 M A 0 Files Type Files Type
42801 48266 0 S N N N 0 M A 0 Files Type Files Type
42802 48267 1 S N N N 0 M A 0 Files Type Files Type
42805 48270 1 S N N N 0 M A 0 Files Type Files Type
42806 48271 1 S N N N 0 M A 0 Files Type Files Type
42810 48275 1 S N N N 0 M A 0 Files Type Files Type
42811 48276 0 S N N N 0 M A 0 Files Type Files Type
42812 48277 1 S N N N 0 M A 0 Files Type Files Type
42831 48297 1 S N N N 0 M A 0 Files Type Files Type
42836 48302 1 S N N N 0 M A 0 Files Type Files Type
42586 48046 1 S N N N 0 M A 0 Files Type Files Type
42587 48047 0 S N N N 0 M A 0 Files Type Files Type
42617 48078 0 S N N N 0 M A 0 Files Type Files Type
42635 48097 1 S N N N 0 M A 0 Files Type Files Type
42637 48099 0 S N N N 0 M A 0 Files Type Files Type
42638 48100 0 S N N N 0 M A 0 Files Type Files Type
42639 48101 0 S N N N 0 M A 0 Files Type Files Type
42640 48102 1 S N N N 0 M A 0 Files Type Files Type
42641 48103 1 S N N N 0 M A 0 Files Type Files Type
42907 48375 0 S N N N 0 M A 0 Files Type Files Type
42908 48376 0 S N N N 0 M A 0 Files Type Files Type
42909 48377 0 S N N N 0 M A 0 Files Type Files Type
42910 48378 0 S N N N 0 M A 0 Files Type Files Type
42911 48379 0 S N N N 0 M A 0 Files Type Files Type
42912 48380 0 S N N N 0 M A 0 Files Type Files Type
42657 48120 1 S N N N 0 M A 0 Files Type Files Type
42913 48381 1 S N N N 0 M A 0 Files Type Files Type
42914 48382 0 S N N N 0 M A 0 Files Type Files Type
42915 48383 0 S N N N 0 M A 0 Files Type Files Type
42916 48384 0 S N N N 0 M A 0 Files Type Files Type
42917 48385 0 S N N N 0 M A 0 Files Type Files Type
42918 48386 0 S N N N 0 M A 0 Files Type Files Type
42919 48387 0 S N N N 0 M A 0 Files Type Files Type
42920 48388 0 S N N N 0 M A 0 Files Type Files Type
42921 48389 0 S N N N 0 M A 0 Files Type Files Type
43433 48920 1 S N N N 0 M A 0 Files Type Files Type
42922 48390 0 S N N N 0 M A 0 Files Type Files Type
42923 48391 0 S N N N 0 M A 0 Files Type Files Type
42924 48392 0 S N N N 0 M A 0 Files Type Files Type
42925 48393 0 S N N N 0 M A 0 Files Type Files Type
42926 48394 0 S N N N 0 M A 0 Files Type Files Type
42927 48395 0 S N N N 0 M A 0 Files Type Files Type
42928 48396 0 S N N N 0 M A 0 Files Type Files Type
42929 48397 0 S N N N 0 M A 0 Files Type Files Type
42930 48398 0 S N N N 0 M A 0 Files Type Files Type
42931 48399 0 S N N N 0 M A 0 Files Type Files Type
42932 48400 1 S N N N 0 M A 0 Files Type Files Type
42933 48401 0 S N N N 0 M A 0 Files Type Files Type
42934 48402 0 S N N N 0 M A 0 Files Type Files Type
42935 48403 0 S N N N 0 M A 0 Files Type Files Type
42936 48404 0 S N N N 0 M A 0 Files Type Files Type
43192 48670 0 S N N N 0 M A 0 Files Type Files Type
42937 48405 1 S N N N 0 M A 0 Files Type Files Type
43193 48671 0 S N N N 0 M A 0 Files Type Files Type
42938 48406 0 S N N N 0 M A 0 Files Type Files Type
42939 48407 0 S N N N 0 M A 0 Files Type Files Type
42940 48408 0 S N N N 0 M A 0 Files Type Files Type
42941 48409 0 S N N N 0 M A 0 Files Type Files Type
42942 48410 0 S N N N 0 M A 0 Files Type Files Type
43227 48706 1 S N N N 0 M A 0 Files Type Files Type
43234 48713 0 S N N N 0 M A 0 Files Type Files Type
42728 48192 1 S N N N 0 M A 0 Files Type Files Type
42737 48201 0 S N N N 0 M A 0 Files Type Files Type
43002 48473 1 S N N N 0 M A 0 Files Type Files Type