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 (
    10707, 428, 10070, 8295, 714, 552, 10364, 
    10122
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00094

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 19 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
1120 428 product 0 1097 A 0
3737 428 product 0 3041 A 0
25989 10070 product 0 21564 A 0
26323 428 product 0 21898 A 0
27146 10122 product 0 22721 A 0
28515 714 product 0 24090 A 0
28516 714 product 0 24091 A 0
29738 428 product 0 25315 A 0
29739 428 product 0 25316 A 0
29740 428 product 0 25317 A 0
29741 428 product 0 25318 A 0
30930 8295 product 0 26508 A 0
31386 428 product 0 26964 A 0
31387 428 product 0 26965 A 0
31394 714 product 0 26972 A 0
31400 10122 product 0 26978 A 0
31401 10122 product 0 26979 A 0
31882 10707 product 0 27460 A 0
32463 10364 product 0 28041 A 0
32464 10364 product 0 28042 A 0
31399 10070 product 0 26977 A 1
31883 10707 product 0 27461 A 1
32515 8295 product 0 28093 A 1
25990 10070 product 0 21565 A 2
31884 10707 product 0 27462 A 2
32519 8295 product 0 28097 A 2
25991 10070 product 0 21566 A 3
31909 10707 product 0 27487 A 3
32520 8295 product 0 28098 A 3
25992 10070 product 0 21567 A 4
31910 10707 product 0 27488 A 4
32513 8295 product 0 28091 A 4
30897 8295 product 0 26475 A 5
31911 10707 product 0 27489 A 5
30896 8295 product 0 26474 A 6
31912 10707 product 0 27490 A 6
30898 8295 product 0 26476 A 7
31906 10707 product 0 27484 A 7
30899 8295 product 0 26477 A 8
31907 10707 product 0 27485 A 8
31905 10707 product 0 27483 A 9
32521 8295 product 0 28099 A 9
30931 8295 product 0 26509 A 10
31908 10707 product 0 27486 A 10