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 (
    8862, 8860, 9845, 9853, 9843, 10065, 
    10101, 10172, 8878, 3315, 381, 480, 
    10067, 9851, 9842, 10063, 8861, 9849, 
    10076, 10945, 8864, 479, 10219, 3317, 
    9848, 8880, 8875, 8869, 8886, 9838, 
    8891, 10211, 8870, 9850, 8868, 10173, 
    8887, 8884, 10213, 10220, 10078, 8863, 
    9839, 10174, 8873, 9855, 8894, 10212, 
    8885, 8893, 8871, 10210, 9822, 3316, 
    8888, 9821, 8877, 9823, 10066, 10095, 
    10206, 10713, 9824, 10208, 556, 9854, 
    10139, 9844, 9840, 10946, 10096, 9841, 
    557, 10138, 558, 9852, 10217, 10142, 
    10141, 10140
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00384

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 80 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
1270 479 product 0 1228 M 0
1271 480 product 0 1229 M 0
1928 381 product 0 1873 M 0
5358 3315 product 0 3183 M 0
5359 3316 product 0 3184 M 0
5360 3317 product 0 3185 M 0
11866 8863 product 0 8350 M 0
11867 8864 product 0 8353 M 0
11871 8868 product 0 8457 M 0
11872 8869 product 0 8563 M 0
11873 8870 product 0 8589 M 0
11874 8871 product 0 8464 M 0
11876 8873 product 0 8480 M 0
11878 8875 product 0 8495 M 0
11880 8877 product 0 8512 M 0
11881 8878 product 0 8396 M 0
11883 8880 product 0 8415 M 0
11887 8884 product 0 8428 M 0
11888 8885 product 0 8434 M 0
11889 8886 product 0 8577 M 0
11890 8887 product 0 8603 M 0
11891 8888 product 0 8440 M 0
11894 8891 product 0 8532 M 0
11896 8893 product 0 8544 M 0
11897 8894 product 0 8550 M 0
12441 8861 product 0 8344 M 0
12472 8860 product 0 8378 M 0
12475 8862 product 0 8381 M 0
13539 9842 product 0 9126 M 0
13543 9843 product 0 9130 M 0
13549 9839 product 0 9136 M 0
13555 9838 product 0 9142 M 0
13573 9850 product 0 9160 M 0
13591 9848 product 0 9178 M 0
13598 9853 product 0 9185 M 0
13613 9840 product 0 9200 M 0
13614 9841 product 0 9201 M 0
13615 9844 product 0 9202 M 0
13616 9845 product 0 9203 M 0
13617 9849 product 0 9204 M 0
13618 9852 product 0 9205 M 0
13619 9854 product 0 9206 M 0
13621 9855 product 0 9208 M 0
26016 10076 product 0 21591 M 0
26035 10078 product 0 21610 M 0
26051 10095 product 0 21626 M 0
26052 10096 product 0 21627 M 0
26129 10065 product 0 21704 M 0
26135 10067 product 0 21710 M 0
26137 10066 product 0 21712 M 0
26138 10101 product 0 21713 M 0
27252 10138 product 0 22827 M 0
27257 10139 product 0 22832 M 0
27260 10140 product 0 22835 M 0
27263 10141 product 0 22838 M 0
27266 10142 product 0 22841 M 0
27500 10172 product 0 23075 M 0
27520 10174 product 0 23095 M 0
27543 10173 product 0 23118 M 0
27710 10206 product 0 23285 M 0
27723 10208 product 0 23298 M 0
27737 10210 product 0 23312 M 0
27743 10211 product 0 23318 M 0
27751 10212 product 0 23326 M 0
27757 10213 product 0 23332 M 0
27786 10217 product 0 23361 M 0
27857 10220 product 0 23432 M 0
28018 10219 product 0 23593 M 0
28029 10063 product 0 23604 M 0
28198 556 product 0 23773 M 0
28199 557 product 0 23774 M 0
28200 558 product 0 23775 M 0
30787 9851 product 0 26365 M 0
31637 9821 product 0 27215 M 0
31649 9823 product 0 27227 M 0
31660 9822 product 0 27238 M 0
31672 9824 product 0 27250 M 0
31948 10713 product 0 27526 M 0
32003 10946 product 0 27581 M 0
32004 10945 product 0 27582 M 0