SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    85913, 85912, 85911, 86694, 85855, 85819, 
    85809, 86655, 86584, 86583, 86582, 
    85751, 85702, 85701, 85691, 86647, 
    85891, 85890, 85889, 85888
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00061

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 20 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.detailed_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where

Result

image_id image_path image_x image_y pair_id object_id object_type detailed_id type position alt images_image_id
0 5054285001202.jpg 1000 1000 88637 85691 product 92160 M 0 92160
0 5054285036761.jpg 1000 1000 88647 85701 product 92170 M 0 92170
0 5054285022412.jpg 1000 1000 88648 85702 product 92171 M 0 92171
0 5054285066980.jpg 1000 1000 88700 85751 product 92223 M 0 92223
0 5054284594392_80o1-65.jpg 1000 1000 88758 85809 product 92281 M 0 92281
0 5054284594392_xldq-3z.jpg 1000 1000 88768 85819 product 92291 M 0 92291
0 5054285054147.jpg 1000 1000 88804 85855 product 92327 M 0 92327
0 5054285078648_l4qt-qx.jpg 1000 1000 88838 85888 product 92361 M 0 92361
0 5054285078648_c0ae-pn.jpg 1000 1000 88839 85889 product 92362 M 0 92362
0 5054285078648_3asy-0z.jpg 1000 1000 88840 85890 product 92363 M 0 92363
0 5054285078648_8hg5-in.jpg 1000 1000 88841 85891 product 92364 M 0 92364
0 5054285057629.jpg 1000 1000 88861 85911 product 92384 M 0 92384
0 5054285057629_6vrs-o1.jpg 1000 1000 88862 85912 product 92385 M 0 92385
0 5054285057629_5b4v-s2.jpg 1000 1000 88863 85913 product 92386 M 0 92386
0 5054285114469_gu69-2e.jpg 1000 1000 89315 86582 product 92838 M 0 92838
0 5054285114469_1bg1-sv.jpg 1000 1000 89316 86583 product 92839 M 0 92839
0 5054285114469_owx5-b1.jpg 1000 1000 89317 86584 product 92840 M 0 92840
0 5054285102435.jpg 1000 1000 89380 86647 product 92903 M 0 92903
0 5054285125090.jpg 1000 1000 89388 86655 product 92911 M 0 92911
0 5054285118634.jpg 1000 1000 89427 86694 product 92950 M 0 92950