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 (
    8304, 9885, 9882, 8288, 8275, 8733, 8362, 
    8305, 8299, 9877, 8277, 8720
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00138

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 30 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
11188 8305 product 0 8003 A 0
25185 9877 product 0 20772 A 0
25205 9882 product 0 20792 A 0
25846 8299 product 0 21421 A 0
25864 9877 product 0 21439 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
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
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
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
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
28307 9882 product 0 23882 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
30215 9882 product 0 25792 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
31700 8299 product 0 27278 A 0
32280 8275 product 0 27858 A 0
32282 8277 product 0 27860 A 0
25869 8305 product 0 21444 A 1
26814 8275 product 0 22389 A 1
26817 8277 product 0 22392 A 1
10744 8305 product 0 7596 A 2
26815 8275 product 0 22390 A 2
26818 8277 product 0 22393 A 2
10745 8305 product 0 7597 A 3
26824 8277 product 0 22399 A 3
31458 8275 product 0 27036 A 3
10746 8305 product 0 7598 A 4
30221 8277 product 0 25798 A 4
31459 8275 product 0 27037 A 4
30222 8277 product 0 25799 A 5
31457 8275 product 0 27035 A 5
31468 8305 product 0 27046 A 5
26825 8275 product 0 22400 A 6
31469 8277 product 0 27047 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