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.detailed_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 (
    10167, 10152, 10168, 10148, 10145, 10170, 
    10147, 10143, 10146, 10153, 10144, 
    10150, 10151, 10149, 10154, 10156, 
    10169, 10171
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00124

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 18 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_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
27269 10143 product 0 22844 M 0 ap_pusty_0x.jpg 399 399 22844
27274 10144 product 0 22849 M 0 ap_morze_0x.jpg 248 247 22849
27277 10145 product 0 22852 M 0 ap_falas_0x.jpg 247 241 22852
27290 10147 product 0 22865 M 0 ap_denal_00.jpg 243 241 22865
27293 10148 product 0 22868 M 0 ap_quadr_00.jpg 240 243 22868
27302 10149 product 0 22877 M 0 ap_lumi_00.jpg 240 242 22877
27311 10150 product 0 22886 M 0 ap_vente_00.jpg 257 252 22886
27329 10151 product 0 22904 M 0 ap_solan_0x.jpg 215 212 22904
27332 10152 product 0 22907 M 0 ap_falam_0x.jpg 286 277 22907
27335 10153 product 0 22910 M 0 ap_mokom_00.jpg 232 232 22910
27341 10154 product 0 22916 M 0 ap_polar_00.jpg 236 235 22916
27347 10156 product 0 22922 M 0 ap_mokos_00.jpg 233 229 22922
27446 10167 product 0 23021 M 0 ap_hexag_0x.jpg 415 398 23021
27459 10168 product 0 23034 M 0 ap_indus_0x.jpg 1251 1245 23034
27465 10169 product 0 23040 M 0 ap_karat_0x.jpg 322 312 23040
27477 10170 product 0 23052 M 0 ap_kwiat_0x.jpg 402 402 23052
27485 10171 product 0 23060 M 0 ap_kola_0x.jpg 380 373 23060
32566 10146 product 0 28144 M 0 Rubik.png 600 600 28144