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 (
    8306, 8289, 8361, 8304, 9885, 8367, 9882, 
    8288, 8275, 8733, 8362, 8305
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00186

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 26 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
10750 8306 product 0 7602 A 0
11188 8305 product 0 8003 A 0
11189 8306 product 0 8004 A 0
25205 9882 product 0 20792 A 0
26885 8289 product 0 22460 A 0
26886 8289 product 0 22461 A 0
26887 8289 product 0 22462 A 0
26888 8288 product 0 22463 A 0
26889 8288 product 0 22464 A 0
26890 8288 product 0 22465 A 0
26891 8288 product 0 22466 A 0
26892 8288 product 0 22467 A 0
26893 8288 product 0 22468 A 0
26919 8304 product 0 22494 A 0
26920 8304 product 0 22495 A 0
26936 8304 product 0 22511 A 0
26937 8304 product 0 22512 A 0
26938 8304 product 0 22513 A 0
26939 9885 product 0 22514 A 0
26940 9885 product 0 22515 A 0
26943 9885 product 0 22518 A 0
26944 9885 product 0 22519 A 0
26945 9885 product 0 22520 A 0
26946 9885 product 0 22521 A 0
26947 9885 product 0 22522 A 0
27021 8733 product 0 22596 A 0
27022 8733 product 0 22597 A 0
27043 8733 product 0 22618 A 0
27044 8733 product 0 22619 A 0
27083 8362 product 0 22658 A 0
27084 8361 product 0 22659 A 0
27089 8361 product 0 22664 A 0
27090 8361 product 0 22665 A 0
27092 8362 product 0 22667 A 0
27093 8362 product 0 22668 A 0
27094 8362 product 0 22669 A 0
27095 8362 product 0 22670 A 0
28307 9882 product 0 23882 A 0
28322 8306 product 0 23897 A 0
28323 8306 product 0 23898 A 0
28324 8306 product 0 23899 A 0
30215 9882 product 0 25792 A 0
30217 8289 product 0 25794 A 0
30218 8289 product 0 25795 A 0
30219 8289 product 0 25796 A 0
30220 8289 product 0 25797 A 0
30276 8733 product 0 25853 A 0
30277 8733 product 0 25854 A 0
31455 9885 product 0 27033 A 0
31456 9885 product 0 27034 A 0
32280 8275 product 0 27858 A 0
11046 8361 product 0 7860 A 1
25869 8305 product 0 21444 A 1
25870 8306 product 0 21445 A 1
26814 8275 product 0 22389 A 1
10744 8305 product 0 7596 A 2
26815 8275 product 0 22390 A 2
10745 8305 product 0 7597 A 3
10751 8306 product 0 7603 A 3
31458 8275 product 0 27036 A 3
10746 8305 product 0 7598 A 4
10752 8306 product 0 7604 A 4
31459 8275 product 0 27037 A 4
31457 8275 product 0 27035 A 5
31468 8305 product 0 27046 A 5
26825 8275 product 0 22400 A 6
26826 8275 product 0 22401 A 7
26827 8275 product 0 22402 A 8
31460 8275 product 0 27038 A 9
26829 8275 product 0 22404 A 10