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 (
    10051, 10061, 10026, 10058, 10054, 10048, 
    10053, 10459, 10050, 10056, 10021, 
    10031
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00112

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 16 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
25847 10031 product 0 21422 A 0
25848 10031 product 0 21423 A 0
26862 10026 product 0 22437 A 0
26863 10026 product 0 22438 A 0
26864 10026 product 0 22439 A 0
26865 10026 product 0 22440 A 0
26941 10056 product 0 22516 A 0
26942 10056 product 0 22517 A 0
26948 10056 product 0 22523 A 0
26949 10056 product 0 22524 A 0
26950 10056 product 0 22525 A 0
26951 10056 product 0 22526 A 0
26952 10056 product 0 22527 A 0
26959 10058 product 0 22534 A 0
26960 10058 product 0 22535 A 0
26961 10058 product 0 22536 A 0
26987 10051 product 0 22562 A 0
26988 10051 product 0 22563 A 0
26991 10053 product 0 22566 A 0
26992 10053 product 0 22567 A 0
26993 10054 product 0 22568 A 0
26994 10054 product 0 22569 A 0
26995 10051 product 0 22570 A 0
27009 10053 product 0 22584 A 0
27010 10053 product 0 22585 A 0
27011 10053 product 0 22586 A 0
27012 10053 product 0 22587 A 0
27016 10054 product 0 22591 A 0
27017 10054 product 0 22592 A 0
27018 10054 product 0 22593 A 0
27031 10061 product 0 22606 A 0
27032 10061 product 0 22607 A 0
27048 10061 product 0 22623 A 0
27063 10048 product 0 22638 A 0
27064 10048 product 0 22639 A 0
27067 10050 product 0 22642 A 0
27068 10050 product 0 22643 A 0
27069 10048 product 0 22644 A 0
30192 10459 product 0 25769 A 0
30193 10459 product 0 25770 A 0
30199 10459 product 0 25776 A 0
30200 10459 product 0 25777 A 0
30201 10459 product 0 25778 A 0
30202 10459 product 0 25779 A 0
30287 10048 product 0 25864 A 0
31431 10031 product 0 27009 A 0
31432 10031 product 0 27010 A 0
31433 10031 product 0 27011 A 0
31434 10031 product 0 27012 A 0
31435 10031 product 0 27013 A 0
32275 10021 product 0 27853 A 0
25810 10021 product 0 21385 A 1
25811 10021 product 0 21386 A 2