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 (
    52244, 52243, 52242, 52241, 52240, 52239, 
    52238, 52237, 52236, 52268, 52576, 
    52163, 51992, 51991, 51988, 51990, 
    51989, 51933, 51932, 51931, 51930, 
    59344, 52572, 52571, 51899, 51892, 
    51891, 51888, 59349, 52575, 51879, 
    51878, 51877, 51876, 51875, 51874, 
    51873, 51872, 51871, 51870, 51869, 
    51868, 51867, 51866, 51865, 51864, 
    51863, 51862, 51861, 51860, 51859, 
    51858, 51857, 51856, 51855, 111374, 
    111373, 52569, 52568, 52567, 52566, 
    52565, 52564, 52563, 52562, 52561, 
    52560, 52559, 52558, 52557, 52556, 
    52555, 52554, 52553, 52552, 52551, 
    52550, 52549, 51834, 51831
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00157

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
46617 52236 0 S N N N 0 M A 0 Files Type Files Type
46618 52237 0 S N N N 0 M A 0 Files Type Files Type
46619 52238 0 S N N N 0 M A 0 Files Type Files Type
46620 52239 0 S N N N 0 M A 0 Files Type Files Type
46621 52240 0 S N N N 0 M A 0 Files Type Files Type
46622 52241 0 S N N N 0 M A 0 Files Type Files Type
46623 52242 0 S N N N 0 M A 0 Files Type Files Type
46624 52243 0 S N N N 0 M A 0 Files Type Files Type
46625 52244 0 S N N N 0 M A 0 Files Type Files Type
46381 51988 1 S N N N 0 M A 0 Files Type Files Type
46382 51989 0 S N N N 0 M A 0 Files Type Files Type
46383 51990 0 S N N N 0 M A 0 Files Type Files Type
46384 51991 1 S N N N 0 M A 0 Files Type Files Type
46385 51992 1 S N N N 0 M A 0 Files Type Files Type
46648 52268 1 S N N N 0 M A 0 Files Type Files Type
46922 52549 0 S N N N 0 M A 0 Files Type Files Type
46923 52550 0 S N N N 0 M A 0 Files Type Files Type
46924 52551 0 S N N N 0 M A 0 Files Type Files Type
46925 52552 0 S N N N 0 M A 0 Files Type Files Type
46926 52553 0 S N N N 0 M A 0 Files Type Files Type
46927 52554 0 S N N N 0 M A 0 Files Type Files Type
46928 52555 0 S N N N 0 M A 0 Files Type Files Type
46929 52556 0 S N N N 0 M A 0 Files Type Files Type
46930 52557 0 S N N N 0 M A 0 Files Type Files Type
46931 52558 0 S N N N 0 M A 0 Files Type Files Type
46932 52559 0 S N N N 0 M A 0 Files Type Files Type
46933 52560 0 S N N N 0 M A 0 Files Type Files Type
46934 52561 0 S N N N 0 M A 0 Files Type Files Type
46935 52562 0 S N N N 0 M A 0 Files Type Files Type
46936 52563 0 S N N N 0 M A 0 Files Type Files Type
46937 52564 0 S N N N 0 M A 0 Files Type Files Type
46938 52565 0 S N N N 0 M A 0 Files Type Files Type
46939 52566 0 S N N N 0 M A 0 Files Type Files Type
46940 52567 0 S N N N 0 M A 0 Files Type Files Type
46941 52568 0 S N N N 0 M A 0 Files Type Files Type
46942 52569 0 S N N N 0 M A 0 Files Type Files Type
46943 52571 1 S N N N 0 M A 0 Files Type Files Type
46944 52572 1 S N N N 0 M A 0 Files Type Files Type
46947 52575 1 S N N N 0 M A 0 Files Type Files Type
46948 52576 1 S N N N 0 M A 0 Files Type Files Type
105320 111373 1 S N N N 0 M A 0 Files Type Files Type
105321 111374 1 S N N N 0 M A 0 Files Type Files Type
53377 59344 0 S N N N 0 M A 0 Files Type Files Type
53382 59349 0 S N N N 0 M A 0 Files Type Files Type
46231 51831 1 S N N N 0 M A 0 Files Type Files Type
46234 51834 1 S N N N 0 M A 0 Files Type Files Type
46254 51855 0 S N N N 0 M A 0 Files Type Files Type
46255 51856 0 S N N N 0 M A 0 Files Type Files Type
46256 51857 0 S N N N 0 M A 0 Files Type Files Type
46257 51858 0 S N N N 0 M A 0 Files Type Files Type
46258 51859 0 S N N N 0 M A 0 Files Type Files Type
46259 51860 0 S N N N 0 M A 0 Files Type Files Type
46260 51861 0 S N N N 0 M A 0 Files Type Files Type
46261 51862 0 S N N N 0 M A 0 Files Type Files Type
46262 51863 0 S N N N 0 M A 0 Files Type Files Type
46263 51864 0 S N N N 0 M A 0 Files Type Files Type
46264 51865 0 S N N N 0 M A 0 Files Type Files Type
46265 51866 0 S N N N 0 M A 0 Files Type Files Type
46266 51867 0 S N N N 0 M A 0 Files Type Files Type
46267 51868 0 S N N N 0 M A 0 Files Type Files Type
46268 51869 0 S N N N 0 M A 0 Files Type Files Type
46269 51870 0 S N N N 0 M A 0 Files Type Files Type
46270 51871 0 S N N N 0 M A 0 Files Type Files Type
46271 51872 0 S N N N 0 M A 0 Files Type Files Type
46272 51873 0 S N N N 0 M A 0 Files Type Files Type
46273 51874 0 S N N N 0 M A 0 Files Type Files Type
46274 51875 0 S N N N 0 M A 0 Files Type Files Type
46275 51876 0 S N N N 0 M A 0 Files Type Files Type
46276 51877 0 S N N N 0 M A 0 Files Type Files Type
46277 51878 0 S N N N 0 M A 0 Files Type Files Type
46278 51879 0 S N N N 0 M A 0 Files Type Files Type
46286 51888 1 S N N N 0 M A 0 Files Type Files Type
46289 51891 1 S N N N 0 M A 0 Files Type Files Type
46290 51892 1 S N N N 0 M A 0 Files Type Files Type
46547 52163 1 S N N N 0 M A 0 Files Type Files Type
46297 51899 0 S N N N 0 M A 0 Files Type Files Type
46327 51930 1 S N N N 0 M A 0 Files Type Files Type
46328 51931 1 S N N N 0 M A 0 Files Type Files Type
46329 51932 1 S N N N 0 M A 0 Files Type Files Type
46330 51933 1 S N N N 0 M A 0 Files Type Files Type