SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  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 = 'de' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    20439, 
    20432, 
    20433, 
    20434, 
    20435, 
    20436, 
    20437, 
    20438, 
    19808, 
    19809, 
    19822, 
    19810, 
    19811, 
    19821, 
    19812, 
    19813, 
    19814, 
    19815, 
    19816, 
    19817, 
    19823, 
    19818, 
    19819, 
    19820, 
    19936, 
    19937, 
    19950, 
    19938, 
    19939, 
    19949, 
    19940, 
    19941, 
    19942, 
    19943, 
    19944, 
    19945, 
    19946, 
    19947, 
    20406, 
    20407, 
    20408, 
    20409, 
    20410, 
    20411, 
    20412, 
    20413, 
    20416, 
    20417, 
    20418, 
    20419, 
    20420, 
    20421, 
    20422, 
    20386, 
    20388, 
    20390, 
    20812, 
    20813, 
    20816, 
    20818, 
    20819, 
    20820, 
    20821, 
    20823, 
    20824, 
    20825, 
    20826, 
    20827, 
    20828, 
    20829, 
    20830, 
    20831, 
    20832, 
    20922, 
    20923, 
    23835, 
    20926, 
    20928, 
    20929, 
    20930, 
    20931, 
    20934, 
    20935, 
    20936, 
    20937, 
    20938, 
    20940, 
    20941, 
    21121, 
    21122, 
    21124, 
    21125, 
    21126, 
    21127, 
    21128, 
    21129, 
    21131, 
    21132, 
    21133, 
    21134, 
    21135, 
    21136, 
    21137, 
    21138, 
    21139, 
    19576, 
    19578, 
    19579, 
    19580, 
    19581, 
    19582, 
    19577, 
    19600, 
    19602, 
    19603, 
    19604, 
    19605, 
    19606, 
    19601, 
    19612, 
    19614, 
    19615, 
    19616, 
    19617, 
    19618, 
    19613, 
    23928, 
    23929, 
    23930, 
    23931, 
    23932, 
    23933, 
    23934, 
    23935, 
    23937, 
    23938, 
    23939, 
    23940
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00302

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 138 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.image_id 1 Using where
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 mahm3t_cs443.cscart_images.image_id,const,const 1 Using where