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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    3322, 11485, 10960, 9845, 9853, 717, 
    9843, 10065, 10707, 478, 3325, 428
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00202

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 38 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
13544 9843 product 0 9131 A 0
13545 9843 product 0 9132 A 0
13546 9843 product 0 9133 A 0
13547 9843 product 0 9134 A 0
13548 9843 product 0 9135 A 0
26323 428 product 0 21898 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
30214 9845 product 0 25791 A 0
30475 9843 product 0 26052 A 0
30476 9845 product 0 26053 A 0
30477 9845 product 0 26054 A 0
30478 9845 product 0 26055 A 0
30487 9845 product 0 26064 A 0
30524 3325 product 0 26101 A 0
30525 3325 product 0 26102 A 0
30550 3322 product 0 26127 A 0
30551 3322 product 0 26128 A 0
30552 3322 product 0 26129 A 0
30557 3322 product 0 26134 A 0
30558 3322 product 0 26135 A 0
30559 3322 product 0 26136 A 0
30560 3322 product 0 26137 A 0
31188 717 product 0 26766 A 0
31189 717 product 0 26767 A 0
31190 717 product 0 26768 A 0
31191 717 product 0 26769 A 0
31192 717 product 0 26770 A 0
31193 717 product 0 26771 A 0
31200 10065 product 0 26778 A 0
31212 717 product 0 26790 A 0
31213 717 product 0 26791 A 0
31214 717 product 0 26792 A 0
31215 717 product 0 26793 A 0
31216 717 product 0 26794 A 0
31321 3325 product 0 26899 A 0
31322 3325 product 0 26900 A 0
31323 3325 product 0 26901 A 0
31324 3325 product 0 26902 A 0
31325 3325 product 0 26903 A 0
31386 428 product 0 26964 A 0
31387 428 product 0 26965 A 0
31624 9853 product 0 27202 A 0
31882 10707 product 0 27460 A 0
32482 3322 product 0 28060 A 0
32483 3322 product 0 28061 A 0
32486 3325 product 0 28064 A 0
32487 3325 product 0 28065 A 0
32666 11485 product 0 28244 A 0
32667 11485 product 0 28245 A 0
32668 11485 product 0 28246 A 0
32669 11485 product 0 28247 A 0
32670 11485 product 0 28248 A 0
32678 10960 product 0 28256 A 0
32701 478 product 0 28279 A 0
28562 478 product 0 24137 A 1
31201 10065 product 0 26779 A 1
31625 9853 product 0 27203 A 1
31883 10707 product 0 27461 A 1
32672 10960 product 0 28250 A 1
26130 10065 product 0 21705 A 2
28230 9853 product 0 23805 A 2
28563 478 product 0 24138 A 2
31884 10707 product 0 27462 A 2
32673 10960 product 0 28251 A 2
28231 9853 product 0 23806 A 3
28564 478 product 0 24139 A 3
31909 10707 product 0 27487 A 3
32674 10960 product 0 28252 A 3
28227 9853 product 0 23802 A 4
28565 478 product 0 24140 A 4
31910 10707 product 0 27488 A 4
32675 10960 product 0 28253 A 4
28226 9853 product 0 23801 A 5
31337 478 product 0 26915 A 5
31911 10707 product 0 27489 A 5
32676 10960 product 0 28254 A 5
28238 9853 product 0 23813 A 6
31338 478 product 0 26916 A 6
31912 10707 product 0 27490 A 6
32677 10960 product 0 28255 A 6
28240 9853 product 0 23815 A 7
31906 10707 product 0 27484 A 7
28239 9853 product 0 23814 A 8
31907 10707 product 0 27485 A 8
28242 9853 product 0 23817 A 9
31905 10707 product 0 27483 A 9
28241 9853 product 0 23816 A 10
31908 10707 product 0 27486 A 10
31626 9853 product 0 27204 A 11