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 = 'M' 
  AND cscart_images_links.object_id IN (
    430, 9470, 10705, 750, 10195, 426, 10670, 
    9457, 10157, 9938, 8862, 8860, 3322, 
    11485, 10960, 9845, 9853, 717, 9843, 
    10065, 10707, 478, 3325, 428, 3321, 
    10101, 10172, 8878, 514, 10070, 8295, 
    3315, 7353, 4939, 480, 3318, 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.00274

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 48 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
1066 407 product 0 1043 M 0
1087 426 product 0 1064 M 0
1089 428 product 0 1066 M 0
1091 430 product 0 1068 M 0
1269 478 product 0 1227 M 0
1271 480 product 0 1229 M 0
1303 405 product 0 1869 M 0
1915 717 product 0 1860 M 0
1939 750 product 0 1884 M 0
5358 3315 product 0 3183 M 0
7136 4939 product 0 3381 M 0
9553 7353 product 0 6431 M 0
11881 8878 product 0 8396 M 0
12441 8861 product 0 8344 M 0
12472 8860 product 0 8378 M 0
12475 8862 product 0 8381 M 0
12797 9470 product 0 8710 M 0
13539 9842 product 0 9126 M 0
13543 9843 product 0 9130 M 0
13598 9853 product 0 9185 M 0
13616 9845 product 0 9203 M 0
13617 9849 product 0 9204 M 0
25436 9938 product 0 21023 M 0
25993 10070 product 0 21568 M 0
26129 10065 product 0 21704 M 0
26135 10067 product 0 21710 M 0
26138 10101 product 0 21713 M 0
26146 10104 product 0 21721 M 0
27500 10172 product 0 23075 M 0
27639 10195 product 0 23214 M 0
27673 10201 product 0 23248 M 0
27984 514 product 0 23559 M 0
28029 10063 product 0 23604 M 0
28328 9457 product 0 23903 M 0
28566 3318 product 0 24141 M 0
28573 3319 product 0 24148 M 0
28579 3320 product 0 24154 M 0
28900 3321 product 0 24475 M 0
28939 3322 product 0 24514 M 0
30517 3325 product 0 26094 M 0
30787 9851 product 0 26365 M 0
30929 8295 product 0 26507 M 0
31791 10670 product 0 27369 M 0
31833 10705 product 0 27411 M 0
31868 10707 product 0 27446 M 0
32479 10157 product 0 28057 M 0
32665 11485 product 0 28243 M 0
32679 10960 product 0 28257 M 0