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, 9848, 9838, 
    9850, 9839, 9855, 9854, 9844, 9840, 
    9841, 9852
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00216

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 45 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
13554 9839 product 0 9141 A 0
13556 9838 product 0 9143 A 0
13557 9838 product 0 9144 A 0
13558 9838 product 0 9145 A 0
13566 9840 product 0 9153 A 0
13574 9850 product 0 9161 A 0
13575 9850 product 0 9162 A 0
13576 9850 product 0 9163 A 0
13577 9850 product 0 9164 A 0
13578 9850 product 0 9165 A 0
13580 9851 product 0 9167 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
25100 9838 product 0 20687 A 0
25101 9838 product 0 20688 A 0
28224 9854 product 0 23799 A 0
28225 9855 product 0 23800 A 0
28228 9855 product 0 23803 A 0
28234 9855 product 0 23809 A 0
28237 9855 product 0 23812 A 0
28243 9855 product 0 23818 A 0
28246 9855 product 0 23821 A 0
28247 9855 product 0 23822 A 0
28249 9855 product 0 23824 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
30479 9844 product 0 26056 A 0
30480 9844 product 0 26057 A 0
30481 9844 product 0 26058 A 0
30482 9844 product 0 26059 A 0
30483 9844 product 0 26060 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
13550 9839 product 0 9137 A 1
13585 9851 product 0 9172 A 1
28223 480 product 0 23798 A 1
28229 9854 product 0 23804 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
13551 9839 product 0 9138 A 2
13581 9851 product 0 9168 A 2
28230 9853 product 0 23805 A 2
28235 9854 product 0 23810 A 2
28563 478 product 0 24138 A 2
32519 8295 product 0 28097 A 2
13552 9839 product 0 9139 A 3
28231 9853 product 0 23806 A 3
28248 9854 product 0 23823 A 3
28564 478 product 0 24139 A 3
30786 9851 product 0 26364 A 3
32520 8295 product 0 28098 A 3
13553 9839 product 0 9140 A 4
13582 9851 product 0 9169 A 4
28227 9853 product 0 23802 A 4
28236 9854 product 0 23811 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
28244 9854 product 0 23819 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
28245 9854 product 0 23820 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