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 (
    8273, 10423, 9819, 9481, 8283, 9483, 
    9879, 9875, 9869, 10428, 8735, 8287
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00114

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 25 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
13343 9819 product 0 8930 A 0
25195 9879 product 0 20782 A 0
25796 8273 product 0 21371 A 0
25842 9879 product 0 21417 A 0
26842 8283 product 0 22417 A 0
26843 8283 product 0 22418 A 0
26844 8283 product 0 22419 A 0
26845 8283 product 0 22420 A 0
26956 9875 product 0 22531 A 0
26962 9875 product 0 22537 A 0
27025 8735 product 0 22600 A 0
27026 8735 product 0 22601 A 0
27049 8735 product 0 22624 A 0
27050 8735 product 0 22625 A 0
27053 9481 product 0 22628 A 0
27054 9481 product 0 22629 A 0
27057 9483 product 0 22632 A 0
27058 9483 product 0 22633 A 0
27070 9481 product 0 22645 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
28326 9819 product 0 23901 A 0
29843 10423 product 0 25420 A 0
29844 10423 product 0 25421 A 0
29859 10423 product 0 25436 A 0
29860 10423 product 0 25437 A 0
29861 10423 product 0 25438 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
30228 9879 product 0 25805 A 0
30229 9879 product 0 25806 A 0
30243 9819 product 0 25820 A 0
30248 9869 product 0 25825 A 0
30249 9481 product 0 25826 A 0
30250 9481 product 0 25827 A 0
30251 9481 product 0 25828 A 0
30252 9481 product 0 25829 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
25797 8273 product 0 21372 A 2
31407 8283 product 0 26985 A 2
31408 8283 product 0 26986 A 2
10882 8273 product 0 7734 A 3
28308 8273 product 0 23883 A 4
10883 8273 product 0 7735 A 5
10884 8273 product 0 7736 A 6
10885 8273 product 0 7737 A 7
10886 8273 product 0 7738 A 8
10887 8273 product 0 7739 A 9
10888 8273 product 0 7740 A 10
10889 8273 product 0 7741 A 11
10890 8273 product 0 7742 A 12
10891 8273 product 0 7743 A 13
10892 8273 product 0 7744 A 14