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 (
    43553, 43552, 43548, 43547, 43546, 43530, 
    43535, 43534, 43528, 43527, 43526, 
    43525, 43523, 43520, 43781, 43780, 
    43779, 43778, 43777, 43776, 43775, 
    43774, 43773, 43772, 43771, 43770, 
    43769, 43768, 43423, 43420, 43416, 
    43411, 43410, 43409, 43378, 43377, 
    43333, 43332, 43331, 43349, 43348, 
    43347, 43342, 43341, 43340, 43339, 
    43338, 43337, 43336, 43335, 43334, 
    43328, 43326, 43325, 43292, 43555, 
    43529, 43288, 43287, 43286, 43281, 
    43280, 43279, 43619, 43513, 43508, 
    43290, 43289, 63106, 63105, 63104, 
    63103, 63102, 63101, 63100, 63099, 
    63098, 63097, 63096, 63095
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00238

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
38444 43768 1 S N N N 0 M A 0 Files Type Files Type
38445 43769 0 S N N N 0 M A 0 Files Type Files Type
38446 43770 0 S N N N 0 M A 0 Files Type Files Type
38191 43508 0 S N N N 0 M A 0 Files Type Files Type
38447 43771 0 S N N N 0 M A 0 Files Type Files Type
38448 43772 0 S N N N 0 M A 0 Files Type Files Type
38449 43773 0 S N N N 0 M A 0 Files Type Files Type
38450 43774 0 S N N N 0 M A 0 Files Type Files Type
38451 43775 0 S N N N 0 M A 0 Files Type Files Type
38196 43513 0 S N N N 0 M A 0 Files Type Files Type
38452 43776 0 S N N N 0 M A 0 Files Type Files Type
38453 43777 0 S N N N 0 M A 0 Files Type Files Type
38454 43778 0 S N N N 0 M A 0 Files Type Files Type
38455 43779 0 S N N N 0 M A 0 Files Type Files Type
38456 43780 0 S N N N 0 M A 0 Files Type Files Type
38457 43781 0 S N N N 0 M A 0 Files Type Files Type
38203 43520 1 S N N N 0 M A 0 Files Type Files Type
38208 43525 0 S N N N 0 M A 0 Files Type Files Type
38209 43526 0 S N N N 0 M A 0 Files Type Files Type
38210 43527 1 S N N N 0 M A 0 Files Type Files Type
38211 43528 0 S N N N 0 M A 0 Files Type Files Type
38212 43529 0 S N N N 0 M A 0 Files Type Files Type
38213 43530 0 S N N N 0 M A 0 Files Type Files Type
38216 43534 0 S N N N 0 M A 0 Files Type Files Type
38217 43535 1 S N N N 0 M A 0 Files Type Files Type
37966 43279 1 S N N N 0 M A 0 Files Type Files Type
37967 43280 0 S N N N 0 M A 0 Files Type Files Type
37968 43281 0 S N N N 0 M A 0 Files Type Files Type
38228 43546 0 S N N N 0 M A 0 Files Type Files Type
37973 43286 0 S N N N 0 M A 0 Files Type Files Type
38229 43547 1 S N N N 0 M A 0 Files Type Files Type
37974 43287 0 S N N N 0 M A 0 Files Type Files Type
38230 43548 0 S N N N 0 M A 0 Files Type Files Type
37975 43288 0 S N N N 0 M A 0 Files Type Files Type
37976 43289 1 S N N N 0 M A 0 Files Type Files Type
37977 43290 1 S N N N 0 M A 0 Files Type Files Type
38234 43552 0 S N N N 0 M A 0 Files Type Files Type
37979 43292 0 S N N N 0 M A 0 Files Type Files Type
38235 43553 0 S N N N 0 M A 0 Files Type Files Type
38237 43555 0 S N N N 0 M A 0 Files Type Files Type
38011 43325 1 S N N N 0 M A 0 Files Type Files Type
38012 43326 1 S N N N 0 M A 0 Files Type Files Type
56957 63095 1 S N N N 0 M A 0 Files Type Files Type
38014 43328 0 S N N N 0 M A 0 Files Type Files Type
56958 63096 1 S N N N 0 M A 0 Files Type Files Type
56959 63097 1 S N N N 0 M A 0 Files Type Files Type
56960 63098 1 S N N N 0 M A 0 Files Type Files Type
38017 43331 1 S N N N 0 M A 0 Files Type Files Type
56961 63099 1 S N N N 0 M A 0 Files Type Files Type
38018 43332 0 S N N N 0 M A 0 Files Type Files Type
56962 63100 1 S N N N 0 M A 0 Files Type Files Type
38019 43333 0 S N N N 0 M A 0 Files Type Files Type
56963 63101 1 S N N N 0 M A 0 Files Type Files Type
38020 43334 0 S N N N 0 M A 0 Files Type Files Type
56964 63102 1 S N N N 0 M A 0 Files Type Files Type
38021 43335 0 S N N N 0 M A 0 Files Type Files Type
56965 63103 1 S N N N 0 M A 0 Files Type Files Type
38022 43336 0 S N N N 0 M A 0 Files Type Files Type
56966 63104 1 S N N N 0 M A 0 Files Type Files Type
38023 43337 0 S N N N 0 M A 0 Files Type Files Type
56967 63105 1 S N N N 0 M A 0 Files Type Files Type
38024 43338 0 S N N N 0 M A 0 Files Type Files Type
56968 63106 1 S N N N 0 M A 0 Files Type Files Type
38025 43339 0 S N N N 0 M A 0 Files Type Files Type
38026 43340 0 S N N N 0 M A 0 Files Type Files Type
38027 43341 0 S N N N 0 M A 0 Files Type Files Type
38028 43342 0 S N N N 0 M A 0 Files Type Files Type
38032 43347 1 S N N N 0 M A 0 Files Type Files Type
38033 43348 0 S N N N 0 M A 0 Files Type Files Type
38034 43349 0 S N N N 0 M A 0 Files Type Files Type
38299 43619 1 S N N N 0 M A 0 Files Type Files Type
38061 43377 1 S N N N 0 M A 0 Files Type Files Type
38062 43378 0 S N N N 0 M A 0 Files Type Files Type
38093 43409 1 S N N N 0 M A 0 Files Type Files Type
38094 43410 0 S N N N 0 M A 0 Files Type Files Type
38095 43411 0 S N N N 0 M A 0 Files Type Files Type
38100 43416 1 S N N N 0 M A 0 Files Type Files Type
38104 43420 1 S N N N 0 M A 0 Files Type Files Type
38107 43423 0 S N N N 0 M A 0 Files Type Files Type