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 (
    15326, 15325, 15324, 15323, 15289, 15290, 
    42114, 42113, 42112, 42111, 15164, 
    15163, 15159, 15132, 15129, 15128, 
    15127, 15162, 15123, 14859, 14857, 
    14856, 14849, 14844, 14836, 14827, 
    14825, 14822, 14817, 14833, 14832, 
    14831, 14830, 14829, 14828, 14826, 
    14824, 14823, 14821, 14820
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00088

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
10500 14844 1 S N N N 0 M A 0 Files Type Files Type
10505 14849 1 S N N N 0 M A 0 Files Type Files Type
10512 14856 1 S N N N 0 M A 0 Files Type Files Type
10513 14857 1 S N N N 0 M A 0 Files Type Files Type
10515 14859 1 S N N N 0 M A 0 Files Type Files Type
10556 15123 1 S N N N 0 M A 0 Files Type Files Type
10560 15127 1 S N N N 0 M A 0 Files Type Files Type
10561 15128 1 S N N N 0 M A 0 Files Type Files Type
10562 15129 1 S N N N 0 M A 0 Files Type Files Type
10565 15132 1 S N N N 0 M A 0 Files Type Files Type
10591 15159 1 S N N N 0 M A 0 Files Type Files Type
10594 15162 1 S N N N 0 M A 0 Files Type Files Type
10595 15163 1 S N N N 0 M A 0 Files Type Files Type
10596 15164 1 S N N N 0 M A 0 Files Type Files Type
10639 15289 1 S N N N 0 M A 0 Files Type Files Type
10640 15290 1 S N N N 0 M A 0 Files Type Files Type
10673 15323 1 S N N N 0 M A 0 Files Type Files Type
10674 15324 1 S N N N 0 M A 0 Files Type Files Type
10675 15325 1 S N N N 0 M A 0 Files Type Files Type
10676 15326 1 S N N N 0 M A 0 Files Type Files Type
36827 42111 0 S N N N 0 M A 0 Files Type Files Type
36828 42112 0 S N N N 0 M A 0 Files Type Files Type
36829 42113 0 S N N N 0 M A 0 Files Type Files Type
36830 42114 0 S N N N 0 M A 0 Files Type Files Type
10474 14817 1 S N N N 0 M A 0 Files Type Files Type
10477 14820 1 S N N N 0 M A 0 Files Type Files Type
10478 14821 1 S N N N 0 M A 0 Files Type Files Type
10479 14822 1 S N N N 0 M A 0 Files Type Files Type
10480 14823 1 S N N N 0 M A 0 Files Type Files Type
10481 14824 1 S N N N 0 M A 0 Files Type Files Type
10482 14825 1 S N N N 0 M A 0 Files Type Files Type
10483 14826 1 S N N N 0 M A 0 Files Type Files Type
10484 14827 1 S N N N 0 M A 0 Files Type Files Type
10485 14828 1 S N N N 0 M A 0 Files Type Files Type
10486 14829 1 S N N N 0 M A 0 Files Type Files Type
10487 14830 1 S N N N 0 M A 0 Files Type Files Type
10488 14831 1 S N N N 0 M A 0 Files Type Files Type
10489 14832 1 S N N N 0 M A 0 Files Type Files Type
10490 14833 1 S N N N 0 M A 0 Files Type Files Type
10492 14836 1 S N N N 0 M A 0 Files Type Files Type