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 (
    8875, 1655, 516, 388, 523, 517, 8871, 
    8888, 9871, 10183, 10181, 10961
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00127

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 24 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
1947 388 product 0 1892 A 0
11822 1655 product 0 8296 A 0
11823 1655 product 0 8297 A 0
12528 8888 product 0 8441 A 0
12529 8888 product 0 8442 A 0
12530 8888 product 0 8443 A 0
12531 8888 product 0 8444 A 0
12532 8888 product 0 8445 A 0
12549 8871 product 0 8465 A 0
12550 8871 product 0 8466 A 0
12551 8871 product 0 8467 A 0
12552 8871 product 0 8468 A 0
12553 8871 product 0 8469 A 0
12554 8871 product 0 8470 A 0
12576 8875 product 0 8496 A 0
25147 9871 product 0 20734 A 0
25148 9871 product 0 20735 A 0
25149 9871 product 0 20736 A 0
27674 1655 product 0 23249 A 0
29426 10181 product 0 25003 A 0
29427 10181 product 0 25004 A 0
29428 10181 product 0 25005 A 0
29429 10181 product 0 25006 A 0
29430 10181 product 0 25007 A 0
29431 10181 product 0 25008 A 0
29432 10181 product 0 25009 A 0
29433 10183 product 0 25010 A 0
29434 10183 product 0 25011 A 0
31291 516 product 0 26869 A 0
31297 517 product 0 26875 A 0
31298 517 product 0 26876 A 0
31299 517 product 0 26877 A 0
31300 517 product 0 26878 A 0
31302 523 product 0 26880 A 0
31303 523 product 0 26881 A 0
31304 523 product 0 26882 A 0
31305 523 product 0 26883 A 0
31306 523 product 0 26884 A 0
32040 10961 product 0 27618 A 0
32108 10961 product 0 27686 A 0
11093 388 product 0 7907 A 1
12578 8875 product 0 8498 A 1
31292 516 product 0 26870 A 1
1069 388 product 0 1046 A 2
12579 8875 product 0 8499 A 2
31293 516 product 0 26871 A 2
1946 388 product 0 1891 A 3
12580 8875 product 0 8500 A 3
31296 516 product 0 26874 A 3
11091 388 product 0 7905 A 4
12582 8875 product 0 8502 A 4
31290 516 product 0 26868 A 4
12577 8875 product 0 8497 A 5
32496 516 product 0 28074 A 5
12581 8875 product 0 8501 A 6
32498 516 product 0 28076 A 6
32497 516 product 0 28075 A 7
32500 516 product 0 28078 A 8
32499 516 product 0 28077 A 9
31294 516 product 0 26872 A 10
31295 516 product 0 26873 A 11