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 = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    9868, 9876, 9820, 8285, 9482, 8273, 10423, 
    9819, 8283, 9483, 9879, 9875
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00111

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 23 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

Result

pair_id object_id object_type image_id detailed_id type position emo_md5 image_path alt image_x image_y images_image_id
13343 9819 product 0 8930 A 0
13345 9820 product 0 8932 A 0
25195 9879 product 0 20782 A 0
25796 8273 product 0 21371 A 0
25842 9879 product 0 21417 A 0
26842 8283 product 0 22417 A 0
26843 8283 product 0 22418 A 0
26844 8283 product 0 22419 A 0
26845 8283 product 0 22420 A 0
26858 8285 product 0 22433 A 0
26859 8285 product 0 22434 A 0
26956 9875 product 0 22531 A 0
26962 9875 product 0 22537 A 0
27055 9482 product 0 22630 A 0
27056 9482 product 0 22631 A 0
27057 9483 product 0 22632 A 0
27058 9483 product 0 22633 A 0
27082 9868 product 0 22657 A 0
27086 9868 product 0 22661 A 0
27985 9876 product 0 23560 A 0
27986 9876 product 0 23561 A 0
28326 9819 product 0 23901 A 0
28327 9820 product 0 23902 A 0
29843 10423 product 0 25420 A 0
29844 10423 product 0 25421 A 0
29859 10423 product 0 25436 A 0
29860 10423 product 0 25437 A 0
29861 10423 product 0 25438 A 0
30228 9879 product 0 25805 A 0
30229 9879 product 0 25806 A 0
30243 9819 product 0 25820 A 0
30244 9820 product 0 25821 A 0
30245 9820 product 0 25822 A 0
30246 9820 product 0 25823 A 0
30285 9482 product 0 25862 A 0
30286 9482 product 0 25863 A 0
31471 8285 product 0 27049 A 0
31472 8285 product 0 27050 A 0
31473 9482 product 0 27051 A 0
25134 9868 product 0 20721 A 1
31470 9868 product 0 27048 A 1
25797 8273 product 0 21372 A 2
25918 9876 product 0 21493 A 2
31407 8283 product 0 26985 A 2
31408 8283 product 0 26986 A 2
31462 9876 product 0 27040 A 2
10882 8273 product 0 7734 A 3
28308 8273 product 0 23883 A 4
10883 8273 product 0 7735 A 5
10884 8273 product 0 7736 A 6
10885 8273 product 0 7737 A 7
10886 8273 product 0 7738 A 8
10887 8273 product 0 7739 A 9
10888 8273 product 0 7740 A 10
10889 8273 product 0 7741 A 11
10890 8273 product 0 7742 A 12
10891 8273 product 0 7743 A 13
10892 8273 product 0 7744 A 14