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 (
    52499, 52498, 52497, 52496, 52495, 52494, 
    52493, 52492, 52491, 52490, 52489, 
    52488, 52487, 52486, 52485, 52484, 
    52483, 52482, 52481, 52480, 52479, 
    52478, 52477, 111379, 111375, 52473, 
    52472, 52471, 52470, 52469, 52468, 
    52467, 52466, 52626, 52458, 52457, 
    52456, 52455, 52454, 52453, 52451, 
    52450, 52449, 52448, 59351, 52580, 
    52579, 52447, 52446, 52431, 52426, 
    52423, 52416, 52411, 52683, 52399, 
    52398, 52394, 52393, 52392, 52391, 
    52390, 52389, 52388, 52387, 52386, 
    52385, 52384, 52383, 52382, 52381, 
    52380, 52379, 52378, 52377, 52376, 
    52375, 52374, 52373, 52372
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00137

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
46848 52473 0 S N N N 0 M A 0 Files Type Files Type
46852 52477 0 S N N N 0 M A 0 Files Type Files Type
46853 52478 0 S N N N 0 M A 0 Files Type Files Type
46854 52479 0 S N N N 0 M A 0 Files Type Files Type
46855 52480 0 S N N N 0 M A 0 Files Type Files Type
46856 52481 0 S N N N 0 M A 0 Files Type Files Type
46857 52482 0 S N N N 0 M A 0 Files Type Files Type
46858 52483 0 S N N N 0 M A 0 Files Type Files Type
46859 52484 0 S N N N 0 M A 0 Files Type Files Type
46860 52485 0 S N N N 0 M A 0 Files Type Files Type
46861 52486 0 S N N N 0 M A 0 Files Type Files Type
46862 52487 0 S N N N 0 M A 0 Files Type Files Type
46863 52488 0 S N N N 0 M A 0 Files Type Files Type
46864 52489 0 S N N N 0 M A 0 Files Type Files Type
46865 52490 0 S N N N 0 M A 0 Files Type Files Type
46866 52491 0 S N N N 0 M A 0 Files Type Files Type
46867 52492 0 S N N N 0 M A 0 Files Type Files Type
46868 52493 0 S N N N 0 M A 0 Files Type Files Type
46869 52494 0 S N N N 0 M A 0 Files Type Files Type
46870 52495 0 S N N N 0 M A 0 Files Type Files Type
46871 52496 0 S N N N 0 M A 0 Files Type Files Type
46872 52497 0 S N N N 0 M A 0 Files Type Files Type
46873 52498 0 S N N N 0 M A 0 Files Type Files Type
46874 52499 0 S N N N 0 M A 0 Files Type Files Type
46951 52579 1 S N N N 0 M A 0 Files Type Files Type
46952 52580 1 S N N N 0 M A 0 Files Type Files Type
105322 111375 1 S N N N 0 M A 0 Files Type Files Type
105326 111379 1 S N N N 0 M A 0 Files Type Files Type
53384 59351 0 S N N N 0 M A 0 Files Type Files Type
46997 52626 0 S N N N 0 M A 0 Files Type Files Type
46749 52372 0 S N N N 0 M A 0 Files Type Files Type
46750 52373 0 S N N N 0 M A 0 Files Type Files Type
46751 52374 0 S N N N 0 M A 0 Files Type Files Type
46752 52375 0 S N N N 0 M A 0 Files Type Files Type
46753 52376 0 S N N N 0 M A 0 Files Type Files Type
46754 52377 0 S N N N 0 M A 0 Files Type Files Type
46755 52378 0 S N N N 0 M A 0 Files Type Files Type
46756 52379 0 S N N N 0 M A 0 Files Type Files Type
46757 52380 0 S N N N 0 M A 0 Files Type Files Type
46758 52381 0 S N N N 0 M A 0 Files Type Files Type
46759 52382 0 S N N N 0 M A 0 Files Type Files Type
46760 52383 0 S N N N 0 M A 0 Files Type Files Type
46761 52384 0 S N N N 0 M A 0 Files Type Files Type
46762 52385 0 S N N N 0 M A 0 Files Type Files Type
46763 52386 0 S N N N 0 M A 0 Files Type Files Type
46764 52387 0 S N N N 0 M A 0 Files Type Files Type
46765 52388 0 S N N N 0 M A 0 Files Type Files Type
46766 52389 0 S N N N 0 M A 0 Files Type Files Type
46767 52390 0 S N N N 0 M A 0 Files Type Files Type
46768 52391 0 S N N N 0 M A 0 Files Type Files Type
46769 52392 0 S N N N 0 M A 0 Files Type Files Type
46770 52393 0 S N N N 0 M A 0 Files Type Files Type
46771 52394 0 S N N N 0 M A 0 Files Type Files Type
46775 52398 0 S N N N 0 M A 0 Files Type Files Type
46776 52399 0 S N N N 0 M A 0 Files Type Files Type
46787 52411 0 S N N N 0 M A 0 Files Type Files Type
46792 52416 0 S N N N 0 M A 0 Files Type Files Type
47054 52683 0 S N N N 0 M A 0 Files Type Files Type
46799 52423 1 S N N N 0 M A 0 Files Type Files Type
46802 52426 1 S N N N 0 M A 0 Files Type Files Type
46807 52431 1 S N N N 0 M A 0 Files Type Files Type
46821 52446 0 S N N N 0 M A 0 Files Type Files Type
46822 52447 0 S N N N 0 M A 0 Files Type Files Type
46823 52448 1 S N N N 0 M A 0 Files Type Files Type
46824 52449 1 S N N N 0 M A 0 Files Type Files Type
46825 52450 1 S N N N 0 M A 0 Files Type Files Type
46826 52451 1 S N N N 0 M A 0 Files Type Files Type
46828 52453 0 S N N N 0 M A 0 Files Type Files Type
46829 52454 0 S N N N 0 M A 0 Files Type Files Type
46830 52455 0 S N N N 0 M A 0 Files Type Files Type
46831 52456 0 S N N N 0 M A 0 Files Type Files Type
46832 52457 0 S N N N 0 M A 0 Files Type Files Type
46833 52458 0 S N N N 0 M A 0 Files Type Files Type
46841 52466 0 S N N N 0 M A 0 Files Type Files Type
46842 52467 0 S N N N 0 M A 0 Files Type Files Type
46843 52468 0 S N N N 0 M A 0 Files Type Files Type
46844 52469 0 S N N N 0 M A 0 Files Type Files Type
46845 52470 0 S N N N 0 M A 0 Files Type Files Type
46846 52471 0 S N N N 0 M A 0 Files Type Files Type
46847 52472 0 S N N N 0 M A 0 Files Type Files Type