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 (
    9845, 9853, 9843, 478, 3321, 514, 8295, 
    480, 9851, 9842, 9849, 479
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00214

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 29 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
1279 480 product 0 1237 A 0
1280 480 product 0 1238 A 0
1282 480 product 0 1240 A 0
13540 9842 product 0 9127 A 0
13541 9842 product 0 9128 A 0
13542 9842 product 0 9129 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
13580 9851 product 0 9167 A 0
28251 479 product 0 23826 A 0
28252 479 product 0 23827 A 0
28253 479 product 0 23828 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
29248 3321 product 0 24825 A 0
29249 3321 product 0 24826 A 0
29252 3321 product 0 24829 A 0
29253 3321 product 0 24830 A 0
29254 3321 product 0 24831 A 0
29255 3321 product 0 24832 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
30484 9842 product 0 26061 A 0
30487 9845 product 0 26064 A 0
30930 8295 product 0 26508 A 0
31347 3321 product 0 26925 A 0
31624 9853 product 0 27202 A 0
31844 9842 product 0 27422 A 0
32489 3321 product 0 28067 A 0
32490 3321 product 0 28068 A 0
32701 478 product 0 28279 A 0
13585 9851 product 0 9172 A 1
28223 480 product 0 23798 A 1
28562 478 product 0 24137 A 1
30791 480 product 0 26369 A 1
31625 9853 product 0 27203 A 1
32515 8295 product 0 28093 A 1
13581 9851 product 0 9168 A 2
28230 9853 product 0 23805 A 2
28563 478 product 0 24138 A 2
32519 8295 product 0 28097 A 2
28231 9853 product 0 23806 A 3
28564 478 product 0 24139 A 3
30786 9851 product 0 26364 A 3
32520 8295 product 0 28098 A 3
13582 9851 product 0 9169 A 4
28227 9853 product 0 23802 A 4
28565 478 product 0 24140 A 4
32513 8295 product 0 28091 A 4
13583 9851 product 0 9170 A 5
28226 9853 product 0 23801 A 5
30897 8295 product 0 26475 A 5
31337 478 product 0 26915 A 5
13584 9851 product 0 9171 A 6
28238 9853 product 0 23813 A 6
30896 8295 product 0 26474 A 6
31338 478 product 0 26916 A 6
28240 9853 product 0 23815 A 7
30785 9851 product 0 26363 A 7
30898 8295 product 0 26476 A 7
28239 9853 product 0 23814 A 8
30899 8295 product 0 26477 A 8
28242 9853 product 0 23817 A 9
32521 8295 product 0 28099 A 9
28241 9853 product 0 23816 A 10
30931 8295 product 0 26509 A 10
31626 9853 product 0 27204 A 11