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 (
    9882, 8288, 8733, 8362, 8305, 8299, 9877, 
    9820, 9482, 10423, 9819, 9483
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00140

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 22 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
11182 8299 product 0 7997 A 0
11188 8305 product 0 8003 A 0
13343 9819 product 0 8930 A 0
13345 9820 product 0 8932 A 0
25185 9877 product 0 20772 A 0
25205 9882 product 0 20792 A 0
25846 8299 product 0 21421 A 0
25864 9877 product 0 21439 A 0
26888 8288 product 0 22463 A 0
26889 8288 product 0 22464 A 0
26890 8288 product 0 22465 A 0
26891 8288 product 0 22466 A 0
26892 8288 product 0 22467 A 0
26893 8288 product 0 22468 A 0
27021 8733 product 0 22596 A 0
27022 8733 product 0 22597 A 0
27043 8733 product 0 22618 A 0
27044 8733 product 0 22619 A 0
27055 9482 product 0 22630 A 0
27056 9482 product 0 22631 A 0
27057 9483 product 0 22632 A 0
27058 9483 product 0 22633 A 0
27083 8362 product 0 22658 A 0
27092 8362 product 0 22667 A 0
27093 8362 product 0 22668 A 0
27094 8362 product 0 22669 A 0
27095 8362 product 0 22670 A 0
28307 9882 product 0 23882 A 0
28318 9877 product 0 23893 A 0
28319 9877 product 0 23894 A 0
28320 9877 product 0 23895 A 0
28321 9877 product 0 23896 A 0
28326 9819 product 0 23901 A 0
28327 9820 product 0 23902 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
30215 9882 product 0 25792 A 0
30243 9819 product 0 25820 A 0
30244 9820 product 0 25821 A 0
30245 9820 product 0 25822 A 0
30246 9820 product 0 25823 A 0
30276 8733 product 0 25853 A 0
30277 8733 product 0 25854 A 0
30285 9482 product 0 25862 A 0
30286 9482 product 0 25863 A 0
31473 9482 product 0 27051 A 0
31700 8299 product 0 27278 A 0
25869 8305 product 0 21444 A 1
10744 8305 product 0 7596 A 2
10745 8305 product 0 7597 A 3
10746 8305 product 0 7598 A 4
31468 8305 product 0 27046 A 5