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 (
    8368, 8730, 9817, 8732, 8731, 8291, 8734, 
    8728, 8729, 10430, 9484, 8284
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00115

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 20 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
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
26979 8728 product 0 22554 A 0
26980 8728 product 0 22555 A 0
26981 8729 product 0 22556 A 0
26982 8729 product 0 22557 A 0
26983 8730 product 0 22558 A 0
26984 8730 product 0 22559 A 0
26985 8731 product 0 22560 A 0
26986 8731 product 0 22561 A 0
26996 8728 product 0 22571 A 0
26997 8729 product 0 22572 A 0
26998 8729 product 0 22573 A 0
26999 8729 product 0 22574 A 0
27000 8729 product 0 22575 A 0
27005 8730 product 0 22580 A 0
27006 8730 product 0 22581 A 0
27007 8730 product 0 22582 A 0
27008 8730 product 0 22583 A 0
27013 8731 product 0 22588 A 0
27014 8731 product 0 22589 A 0
27015 8731 product 0 22590 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
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
27059 9484 product 0 22634 A 0
27060 9484 product 0 22635 A 0
29916 10430 product 0 25493 A 0
31477 8728 product 0 27055 A 0
12912 8291 product 0 8825 A 1
26851 8284 product 0 22426 A 1
29912 10430 product 0 25489 A 1
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
31476 8284 product 0 27054 A 3
26853 8284 product 0 22428 A 4
29915 10430 product 0 25492 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