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 = 'se' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    10705, 10195, 10670, 9457, 8862, 11485, 
    10960, 10172, 10201, 10945, 397, 10188
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00155

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 36 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
1962 397 product 0 1908 A 0
12444 8862 product 0 8348 A 0
12445 8862 product 0 8349 A 0
12476 8862 product 0 8382 A 0
12477 8862 product 0 8383 A 0
12478 8862 product 0 8384 A 0
12479 8862 product 0 8385 A 0
12480 8862 product 0 8386 A 0
12481 8862 product 0 8387 A 0
12482 8862 product 0 8388 A 0
12483 8862 product 0 8389 A 0
12484 8862 product 0 8390 A 0
27489 10172 product 0 23064 A 0
27490 10172 product 0 23065 A 0
27669 10201 product 0 23244 A 0
31553 10188 product 0 27131 A 0
31635 10670 product 0 27213 A 0
31982 10945 product 0 27560 A 0
32484 10195 product 0 28062 A 0
32503 9457 product 0 28081 A 0
32522 10705 product 0 28100 A 0
32666 11485 product 0 28244 A 0
32667 11485 product 0 28245 A 0
32668 11485 product 0 28246 A 0
32669 11485 product 0 28247 A 0
32670 11485 product 0 28248 A 0
32678 10960 product 0 28256 A 0
1077 397 product 0 1054 A 1
27611 10188 product 0 23186 A 1
27650 10195 product 0 23225 A 1
27670 10201 product 0 23245 A 1
31842 10705 product 0 27420 A 1
32005 10945 product 0 27583 A 1
32504 9457 product 0 28082 A 1
32672 10960 product 0 28250 A 1
1963 397 product 0 1909 A 2
27668 10201 product 0 23243 A 2
29372 9457 product 0 24949 A 2
31554 10188 product 0 27132 A 2
31630 10670 product 0 27208 A 2
31836 10705 product 0 27414 A 2
31985 10945 product 0 27563 A 2
32509 10195 product 0 28087 A 2
32673 10960 product 0 28251 A 2
27671 10201 product 0 23246 A 3
29368 9457 product 0 24945 A 3
31217 397 product 0 26795 A 3
31555 10188 product 0 27133 A 3
31631 10670 product 0 27209 A 3
31834 10705 product 0 27412 A 3
32006 10945 product 0 27584 A 3
32480 10172 product 0 28058 A 3
32508 10195 product 0 28086 A 3
32674 10960 product 0 28252 A 3
27494 10172 product 0 23069 A 4
27672 10201 product 0 23247 A 4
31556 10188 product 0 27134 A 4
31632 10670 product 0 27210 A 4
31837 10705 product 0 27415 A 4
31986 10945 product 0 27564 A 4
32501 9457 product 0 28079 A 4
32510 10195 product 0 28088 A 4
32675 10960 product 0 28253 A 4
27495 10172 product 0 23070 A 5
27632 10195 product 0 23207 A 5
31557 10188 product 0 27135 A 5
31628 10670 product 0 27206 A 5
31839 10705 product 0 27417 A 5
32502 9457 product 0 28080 A 5
32676 10960 product 0 28254 A 5
27496 10172 product 0 23071 A 6
27647 10195 product 0 23222 A 6
31558 10188 product 0 27136 A 6
31838 10705 product 0 27416 A 6
32505 9457 product 0 28083 A 6
32677 10960 product 0 28255 A 6
27497 10172 product 0 23072 A 7
31210 10195 product 0 26788 A 7
31559 10188 product 0 27137 A 7
31634 10670 product 0 27212 A 7
31823 10705 product 0 27401 A 7
32506 9457 product 0 28084 A 7
27498 10172 product 0 23073 A 8
27612 10188 product 0 23187 A 8
31208 10195 product 0 26786 A 8
31826 10705 product 0 27404 A 8
32507 9457 product 0 28085 A 8
27499 10172 product 0 23074 A 9
27613 10188 product 0 23188 A 9
31209 10195 product 0 26787 A 9
31827 10705 product 0 27405 A 9
27614 10188 product 0 23189 A 10
27636 10195 product 0 23211 A 10
31828 10705 product 0 27406 A 10
27615 10188 product 0 23190 A 11
27637 10195 product 0 23212 A 11
31829 10705 product 0 27407 A 11
27616 10188 product 0 23191 A 12
27638 10195 product 0 23213 A 12
31832 10705 product 0 27410 A 12
27617 10188 product 0 23192 A 13
31830 10705 product 0 27408 A 13