SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_id AS images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id 
  LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id 
  AND cscart_common_descriptions.object_holder = 'images' 
  AND cscart_common_descriptions.lang_code = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    50847, 50829, 50828, 50824, 50638, 50629, 
    50627, 50783, 79929, 50734, 50674, 
    50648, 50647, 50644, 50643, 50679, 
    50678, 50677, 50448, 50979, 50978, 
    50977, 50976, 50474, 79925, 50791, 
    50478, 92373, 92372, 92371, 92370, 
    92369, 92368, 92367, 92366, 92365, 
    92364, 92363, 50821, 51308, 50919, 
    50632, 50619, 50618, 50594, 50607, 
    50606, 50605, 50604, 50603, 50602, 
    50601, 50599, 50598, 50597, 50590, 
    50449, 50397, 50578, 50577, 50576, 
    50575, 50384, 50574, 50553, 50552, 
    50551, 50550, 50327, 50278, 50240, 
    50239, 50238, 50559, 50171, 50527, 
    50526, 50525, 50524, 50523
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00078

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_images_links range object_id object_id 81 80 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.image_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where