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 (
    10067, 9851, 3320, 9842, 10104, 10063, 
    407, 8861, 405, 10201, 3319, 9849
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00131

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 31 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
12442 8861 product 0 8345 A 0
13540 9842 product 0 9127 A 0
13541 9842 product 0 9128 A 0
13542 9842 product 0 9129 A 0
13580 9851 product 0 9167 A 0
26147 10104 product 0 21722 A 0
26148 10104 product 0 21723 A 0
26149 10104 product 0 21724 A 0
27669 10201 product 0 23244 A 0
27853 10067 product 0 23428 A 0
28030 10063 product 0 23605 A 0
28574 3319 product 0 24149 A 0
28575 3319 product 0 24150 A 0
28576 3319 product 0 24151 A 0
28577 3319 product 0 24152 A 0
28578 3319 product 0 24153 A 0
28580 3320 product 0 24155 A 0
29117 9849 product 0 24692 A 0
29118 9849 product 0 24693 A 0
29119 9849 product 0 24694 A 0
29120 9849 product 0 24695 A 0
29121 9849 product 0 24696 A 0
29122 9849 product 0 24697 A 0
29123 9849 product 0 24698 A 0
30484 9842 product 0 26061 A 0
31263 10104 product 0 26841 A 0
31264 10104 product 0 26842 A 0
31265 10104 product 0 26843 A 0
31266 10104 product 0 26844 A 0
31267 10104 product 0 26845 A 0
31268 10104 product 0 26846 A 0
31269 10104 product 0 26847 A 0
31364 10067 product 0 26942 A 0
31365 10067 product 0 26943 A 0
31366 10067 product 0 26944 A 0
31525 405 product 0 27103 A 0
31844 9842 product 0 27422 A 0
12443 8861 product 0 8346 A 1
13585 9851 product 0 9172 A 1
26136 10067 product 0 21711 A 1
27670 10201 product 0 23245 A 1
28031 10063 product 0 23606 A 1
28581 3320 product 0 24156 A 1
31523 407 product 0 27101 A 1
31526 405 product 0 27104 A 1
9570 405 product 0 6448 A 2
12452 8861 product 0 8358 A 2
13581 9851 product 0 9168 A 2
27668 10201 product 0 23243 A 2
28250 10063 product 0 23825 A 2
28583 3320 product 0 24158 A 2
31524 407 product 0 27102 A 2
9567 407 product 0 6445 A 3
9571 405 product 0 6449 A 3
12456 8861 product 0 8362 A 3
27671 10201 product 0 23246 A 3
28582 3320 product 0 24157 A 3
30786 9851 product 0 26364 A 3
31357 10063 product 0 26935 A 3
9568 407 product 0 6446 A 4
12454 8861 product 0 8360 A 4
13582 9851 product 0 9169 A 4
27672 10201 product 0 23247 A 4
28032 10063 product 0 23607 A 4
28584 3320 product 0 24159 A 4
31528 405 product 0 27106 A 4
12455 8861 product 0 8361 A 5
13583 9851 product 0 9170 A 5
27804 407 product 0 23379 A 5
28047 10063 product 0 23622 A 5
28585 3320 product 0 24160 A 5
31527 405 product 0 27105 A 5
1924 405 product 0 1868 A 6
12453 8861 product 0 8359 A 6
13584 9851 product 0 9171 A 6
31316 3320 product 0 26894 A 6
9569 405 product 0 6447 A 7
12457 8861 product 0 8363 A 7
30785 9851 product 0 26363 A 7
31317 3320 product 0 26895 A 7
12458 8861 product 0 8364 A 8
31318 3320 product 0 26896 A 8
12459 8861 product 0 8365 A 9
31319 3320 product 0 26897 A 9
12460 8861 product 0 8366 A 10
31320 3320 product 0 26898 A 10