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 (
    10076, 10945, 8864, 397, 479, 10219, 
    3317, 10188, 9848, 8880, 404, 524
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00130

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
1962 397 product 0 1908 A 0
12448 8864 product 0 8354 A 0
12507 8880 product 0 8416 A 0
12508 8880 product 0 8417 A 0
12509 8880 product 0 8418 A 0
12510 8880 product 0 8419 A 0
12511 8880 product 0 8420 A 0
12512 8880 product 0 8421 A 0
13592 9848 product 0 9179 A 0
13593 9848 product 0 9180 A 0
13594 9848 product 0 9181 A 0
13595 9848 product 0 9182 A 0
13597 9848 product 0 9184 A 0
26005 10076 product 0 21580 A 0
28020 10219 product 0 23595 A 0
28251 479 product 0 23826 A 0
28252 479 product 0 23827 A 0
28253 479 product 0 23828 A 0
28336 404 product 0 23911 A 0
30788 10219 product 0 26366 A 0
31308 524 product 0 26886 A 0
31553 10188 product 0 27131 A 0
31982 10945 product 0 27560 A 0
1077 397 product 0 1054 A 1
12449 8864 product 0 8355 A 1
27136 10076 product 0 22711 A 1
27611 10188 product 0 23186 A 1
28337 404 product 0 23912 A 1
32005 10945 product 0 27583 A 1
32492 524 product 0 28070 A 1
32546 3317 product 0 28124 A 1
1963 397 product 0 1909 A 2
12450 8864 product 0 8356 A 2
27137 10076 product 0 22712 A 2
28338 404 product 0 23913 A 2
31554 10188 product 0 27132 A 2
31985 10945 product 0 27563 A 2
32493 524 product 0 28071 A 2
11857 404 product 0 8331 A 3
12533 8864 product 0 8446 A 3
31217 397 product 0 26795 A 3
31555 10188 product 0 27133 A 3
32006 10945 product 0 27584 A 3
32494 524 product 0 28072 A 3
32548 3317 product 0 28126 A 3
32550 3317 product 0 28128 A 3
32551 3317 product 0 28129 A 3
32552 3317 product 0 28130 A 3
32553 3317 product 0 28131 A 3
32554 3317 product 0 28132 A 3
32555 3317 product 0 28133 A 3
32556 3317 product 0 28134 A 3
32557 3317 product 0 28135 A 3
32558 3317 product 0 28136 A 3
32559 3317 product 0 28137 A 3
12535 8864 product 0 8448 A 4
31556 10188 product 0 27134 A 4
31612 404 product 0 27190 A 4
31986 10945 product 0 27564 A 4
32495 524 product 0 28073 A 4
12536 8864 product 0 8449 A 5
26010 10076 product 0 21585 A 5
31309 524 product 0 26887 A 5
31367 10076 product 0 26945 A 5
31368 10076 product 0 26946 A 5
31369 10076 product 0 26947 A 5
31370 10076 product 0 26948 A 5
31371 10076 product 0 26949 A 5
31372 10076 product 0 26950 A 5
31373 10076 product 0 26951 A 5
31557 10188 product 0 27135 A 5
12534 8864 product 0 8447 A 6
31558 10188 product 0 27136 A 6
31559 10188 product 0 27137 A 7
27612 10188 product 0 23187 A 8
27613 10188 product 0 23188 A 9
27614 10188 product 0 23189 A 10
27615 10188 product 0 23190 A 11
27616 10188 product 0 23191 A 12
27617 10188 product 0 23192 A 13