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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    9869, 10428, 8735, 8287, 9817, 8732, 
    8291, 8734, 10430, 8284, 9878, 10434
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00129

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 21 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
12913 8291 product 0 8826 A 0
25188 9878 product 0 20775 A 0
26836 9817 product 0 22411 A 0
26837 9817 product 0 22412 A 0
26838 9817 product 0 22413 A 0
26850 8284 product 0 22425 A 0
27019 8732 product 0 22594 A 0
27020 8732 product 0 22595 A 0
27023 8734 product 0 22598 A 0
27024 8734 product 0 22599 A 0
27025 8735 product 0 22600 A 0
27026 8735 product 0 22601 A 0
27035 8732 product 0 22610 A 0
27036 8732 product 0 22611 A 0
27037 8732 product 0 22612 A 0
27038 8732 product 0 22613 A 0
27047 8734 product 0 22622 A 0
27049 8735 product 0 22624 A 0
27050 8735 product 0 22625 A 0
27081 9869 product 0 22656 A 0
27091 9869 product 0 22666 A 0
28111 8287 product 0 23686 A 0
28112 8287 product 0 23687 A 0
29888 10428 product 0 25465 A 0
29889 10428 product 0 25466 A 0
29890 10428 product 0 25467 A 0
29892 10428 product 0 25469 A 0
29916 10430 product 0 25493 A 0
29941 10434 product 0 25518 A 0
29942 10434 product 0 25519 A 0
29943 10434 product 0 25520 A 0
29944 10434 product 0 25521 A 0
29945 10434 product 0 25522 A 0
29946 10434 product 0 25523 A 0
30248 9869 product 0 25825 A 0
30257 8287 product 0 25834 A 0
30258 8287 product 0 25835 A 0
30278 8735 product 0 25855 A 0
30279 8735 product 0 25856 A 0
30280 8735 product 0 25857 A 0
30281 8735 product 0 25858 A 0
30282 8735 product 0 25859 A 0
12912 8291 product 0 8825 A 1
26851 8284 product 0 22426 A 1
29912 10430 product 0 25489 A 1
31415 9878 product 0 26993 A 1
25839 9878 product 0 21414 A 2
29913 10430 product 0 25490 A 2
30241 8291 product 0 25818 A 2
31475 8284 product 0 27053 A 2
29914 10430 product 0 25491 A 3
30225 9878 product 0 25802 A 3
31476 8284 product 0 27054 A 3
26853 8284 product 0 22428 A 4
29915 10430 product 0 25492 A 4
30226 9878 product 0 25803 A 4
26852 8284 product 0 22427 A 5
29917 10430 product 0 25494 A 5
29918 10430 product 0 25495 A 6
29919 10430 product 0 25496 A 7