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 (
    516, 10213, 10220, 10078, 8863, 9839, 
    10174, 388, 395, 7352, 8873, 9855
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00164

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 32 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
1080 395 product 0 1057 A 0
1947 388 product 0 1892 A 0
9556 7352 product 0 6434 A 0
12447 8863 product 0 8352 A 0
12485 8863 product 0 8391 A 0
12487 8863 product 0 8393 A 0
12488 8863 product 0 8394 A 0
12489 8863 product 0 8395 A 0
12563 8873 product 0 8481 A 0
13554 9839 product 0 9141 A 0
27522 10174 product 0 23097 A 0
27525 10174 product 0 23100 A 0
27752 10213 product 0 23327 A 0
27753 10213 product 0 23328 A 0
27754 10213 product 0 23329 A 0
27755 10213 product 0 23330 A 0
27756 10213 product 0 23331 A 0
27858 10220 product 0 23433 A 0
27924 8873 product 0 23499 A 0
27925 8873 product 0 23500 A 0
27926 8873 product 0 23501 A 0
28085 10078 product 0 23660 A 0
28225 9855 product 0 23800 A 0
28228 9855 product 0 23803 A 0
28234 9855 product 0 23809 A 0
28237 9855 product 0 23812 A 0
28243 9855 product 0 23818 A 0
28246 9855 product 0 23821 A 0
28247 9855 product 0 23822 A 0
28249 9855 product 0 23824 A 0
29457 395 product 0 25034 A 0
29458 395 product 0 25035 A 0
31291 516 product 0 26869 A 0
31350 8863 product 0 26928 A 0
31351 8863 product 0 26929 A 0
31352 8863 product 0 26930 A 0
31353 8863 product 0 26931 A 0
31354 8863 product 0 26932 A 0
31379 10220 product 0 26957 A 0
31380 10220 product 0 26958 A 0
3098 395 product 0 2964 A 1
11093 388 product 0 7907 A 1
11814 7352 product 0 8288 A 1
12564 8873 product 0 8482 A 1
13550 9839 product 0 9137 A 1
26112 10078 product 0 21687 A 1
28084 10174 product 0 23659 A 1
31292 516 product 0 26870 A 1
1069 388 product 0 1046 A 2
13551 9839 product 0 9138 A 2
26115 10078 product 0 21690 A 2
27519 10174 product 0 23094 A 2
31293 516 product 0 26871 A 2
31538 7352 product 0 27116 A 2
1946 388 product 0 1891 A 3
13552 9839 product 0 9139 A 3
26100 10078 product 0 21675 A 3
27510 10174 product 0 23085 A 3
29459 395 product 0 25036 A 3
29460 395 product 0 25037 A 3
29461 395 product 0 25038 A 3
29462 395 product 0 25039 A 3
30771 7352 product 0 26349 A 3
31296 516 product 0 26874 A 3
11091 388 product 0 7905 A 4
12567 8873 product 0 8485 A 4
13553 9839 product 0 9140 A 4
26101 10078 product 0 21676 A 4
27523 10174 product 0 23098 A 4
31290 516 product 0 26868 A 4
31539 7352 product 0 27117 A 4
12569 8873 product 0 8487 A 5
26102 10078 product 0 21677 A 5
27524 10174 product 0 23099 A 5
31540 7352 product 0 27118 A 5
32496 516 product 0 28074 A 5
26030 10078 product 0 21605 A 6
32498 516 product 0 28076 A 6
26103 10078 product 0 21678 A 7
27526 10174 product 0 23101 A 7
32497 516 product 0 28075 A 7
26104 10078 product 0 21679 A 8
27527 10174 product 0 23102 A 8
32500 516 product 0 28078 A 8
26105 10078 product 0 21680 A 9
32499 516 product 0 28077 A 9
26123 10078 product 0 21698 A 10
31294 516 product 0 26872 A 10
31295 516 product 0 26873 A 11