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 (
    8299, 8369, 9877, 8277, 8720, 9868, 9876, 
    8370, 8363, 9820, 8285, 9482
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00115

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
11182 8299 product 0 7997 A 0
13345 9820 product 0 8932 A 0
25185 9877 product 0 20772 A 0
25846 8299 product 0 21421 A 0
25864 9877 product 0 21439 A 0
26858 8285 product 0 22433 A 0
26859 8285 product 0 22434 A 0
26954 8720 product 0 22529 A 0
26970 8720 product 0 22545 A 0
26971 8720 product 0 22546 A 0
26972 8720 product 0 22547 A 0
26973 8720 product 0 22548 A 0
26974 8720 product 0 22549 A 0
26975 8720 product 0 22550 A 0
26976 8720 product 0 22551 A 0
26978 8720 product 0 22553 A 0
27055 9482 product 0 22630 A 0
27056 9482 product 0 22631 A 0
27082 9868 product 0 22657 A 0
27085 8363 product 0 22660 A 0
27086 9868 product 0 22661 A 0
27087 8363 product 0 22662 A 0
27088 8363 product 0 22663 A 0
27985 9876 product 0 23560 A 0
27986 9876 product 0 23561 A 0
28277 8720 product 0 23852 A 0
28278 8720 product 0 23853 A 0
28279 8720 product 0 23854 A 0
28280 8720 product 0 23855 A 0
28281 8720 product 0 23856 A 0
28282 8720 product 0 23857 A 0
28318 9877 product 0 23893 A 0
28319 9877 product 0 23894 A 0
28320 9877 product 0 23895 A 0
28321 9877 product 0 23896 A 0
28327 9820 product 0 23902 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
31700 8299 product 0 27278 A 0
32282 8277 product 0 27860 A 0
25134 9868 product 0 20721 A 1
26817 8277 product 0 22392 A 1
31470 9868 product 0 27048 A 1
25918 9876 product 0 21493 A 2
26818 8277 product 0 22393 A 2
31462 9876 product 0 27040 A 2
26824 8277 product 0 22399 A 3
30221 8277 product 0 25798 A 4
30222 8277 product 0 25799 A 5
31469 8277 product 0 27047 A 6