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 (
    50522, 50521, 50520, 50519, 50518, 50517, 
    50516, 50515, 51281, 50485, 50484, 
    50462, 50461, 50103, 50447, 50408, 
    50465, 50464, 50463, 50393, 50389, 
    50388, 50387, 50072, 50267, 50234, 
    50233, 50232, 50231, 50230, 50229, 
    50228, 50227, 50226, 50225, 50224, 
    50223, 50067, 50066, 50065, 50064, 
    50275, 50274, 50269, 50265, 50039, 
    50001, 88490, 88489, 50040, 50034, 
    50033, 50025, 50152, 50151, 50124, 
    50123, 50122, 49944, 50110, 50107, 
    49954, 49953, 49952, 49951, 49950, 
    50219, 50218, 50217, 50216, 50215, 
    50214, 50213, 50212, 50211, 50210, 
    50209, 50208, 50207, 50206
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00208

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
44570 50103 1 S N N N 0 M A 0 Files Type Files Type
44574 50107 0 S N N N 0 M A 0 Files Type Files Type
44577 50110 0 S N N N 0 M A 0 Files Type Files Type
44843 50387 0 S N N N 0 M A 0 Files Type Files Type
44588 50122 0 S N N N 0 M A 0 Files Type Files Type
44844 50388 0 S N N N 0 M A 0 Files Type Files Type
44589 50123 1 S N N N 0 M A 0 Files Type Files Type
44845 50389 0 S N N N 0 M A 0 Files Type Files Type
44590 50124 1 S N N N 0 M A 0 Files Type Files Type
44849 50393 1 S N N N 0 M A 0 Files Type Files Type
44864 50408 0 S N N N 0 M A 0 Files Type Files Type
44616 50151 0 S N N N 0 M A 0 Files Type Files Type
44617 50152 1 S N N N 0 M A 0 Files Type Files Type
44902 50447 0 S N N N 0 M A 0 Files Type Files Type
44916 50461 0 S N N N 0 M A 0 Files Type Files Type
44917 50462 0 S N N N 0 M A 0 Files Type Files Type
44918 50463 0 S N N N 0 M A 0 Files Type Files Type
44919 50464 0 S N N N 0 M A 0 Files Type Files Type
44920 50465 0 S N N N 0 M A 0 Files Type Files Type
44669 50206 0 S N N N 0 M A 0 Files Type Files Type
44414 49944 1 S N N N 0 M A 0 Files Type Files Type
44670 50207 0 S N N N 0 M A 0 Files Type Files Type
44671 50208 0 S N N N 0 M A 0 Files Type Files Type
44672 50209 0 S N N N 0 M A 0 Files Type Files Type
44673 50210 0 S N N N 0 M A 0 Files Type Files Type
44674 50211 0 S N N N 0 M A 0 Files Type Files Type
44675 50212 0 S N N N 0 M A 0 Files Type Files Type
44420 49950 0 S N N N 0 M A 0 Files Type Files Type
44676 50213 0 S N N N 0 M A 0 Files Type Files Type
44421 49951 0 S N N N 0 M A 0 Files Type Files Type
44677 50214 0 S N N N 0 M A 0 Files Type Files Type
44422 49952 0 S N N N 0 M A 0 Files Type Files Type
44678 50215 0 S N N N 0 M A 0 Files Type Files Type
44423 49953 0 S N N N 0 M A 0 Files Type Files Type
44679 50216 0 S N N N 0 M A 0 Files Type Files Type
44424 49954 0 S N N N 0 M A 0 Files Type Files Type
44680 50217 0 S N N N 0 M A 0 Files Type Files Type
44681 50218 0 S N N N 0 M A 0 Files Type Files Type
44682 50219 0 S N N N 0 M A 0 Files Type Files Type
44938 50484 1 S N N N 0 M A 0 Files Type Files Type
45706 51281 0 S N N N 0 M A 0 Files Type Files Type
44939 50485 1 S N N N 0 M A 0 Files Type Files Type
44685 50223 0 S N N N 0 M A 0 Files Type Files Type
44686 50224 0 S N N N 0 M A 0 Files Type Files Type
44687 50225 0 S N N N 0 M A 0 Files Type Files Type
44688 50226 0 S N N N 0 M A 0 Files Type Files Type
44689 50227 0 S N N N 0 M A 0 Files Type Files Type
44690 50228 0 S N N N 0 M A 0 Files Type Files Type
44691 50229 0 S N N N 0 M A 0 Files Type Files Type
44692 50230 0 S N N N 0 M A 0 Files Type Files Type
44693 50231 0 S N N N 0 M A 0 Files Type Files Type
44694 50232 0 S N N N 0 M A 0 Files Type Files Type
44695 50233 0 S N N N 0 M A 0 Files Type Files Type
44696 50234 0 S N N N 0 M A 0 Files Type Files Type
44969 50515 0 S N N N 0 M A 0 Files Type Files Type
44970 50516 0 S N N N 0 M A 0 Files Type Files Type
44971 50517 0 S N N N 0 M A 0 Files Type Files Type
44972 50518 0 S N N N 0 M A 0 Files Type Files Type
44973 50519 0 S N N N 0 M A 0 Files Type Files Type
44974 50520 0 S N N N 0 M A 0 Files Type Files Type
44975 50521 0 S N N N 0 M A 0 Files Type Files Type
44976 50522 0 S N N N 0 M A 0 Files Type Files Type
44469 50001 1 S N N N 0 M A 0 Files Type Files Type
44726 50265 1 S N N N 0 M A 0 Files Type Files Type
44727 50267 1 S N N N 0 M A 0 Files Type Files Type
44729 50269 1 S N N N 0 M A 0 Files Type Files Type
44734 50274 1 S N N N 0 M A 0 Files Type Files Type
44735 50275 1 S N N N 0 M A 0 Files Type Files Type
83141 88489 1 S N N N 0 M A 0 Files Type Files Type
83142 88490 1 S N N N 0 M A 0 Files Type Files Type
44492 50025 1 S N N N 0 M A 0 Files Type Files Type
44500 50033 0 S N N N 0 M A 0 Files Type Files Type
44501 50034 0 S N N N 0 M A 0 Files Type Files Type
44506 50039 1 S N N N 0 M A 0 Files Type Files Type
44507 50040 1 S N N N 0 M A 0 Files Type Files Type
44531 50064 0 S N N N 0 M A 0 Files Type Files Type
44532 50065 0 S N N N 0 M A 0 Files Type Files Type
44533 50066 0 S N N N 0 M A 0 Files Type Files Type
44534 50067 0 S N N N 0 M A 0 Files Type Files Type
44539 50072 1 S N N N 0 M A 0 Files Type Files Type