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.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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    88722, 88721, 88720, 88719, 88718, 88717, 
    88716, 88715, 88714, 88713, 88712, 
    88711, 88710, 88709, 88708, 88707, 
    88706, 89080, 89079, 89078, 88676, 
    88675, 88674, 88920, 88919, 88493, 
    89075, 88916, 88491, 89082, 89030, 
    89029, 89028, 88996, 88995, 88994, 
    88993, 88981, 88520, 88495
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00064

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 40 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.image_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 91289 88491 product 94812 M 0
0 91291 88493 product 94814 M 0
0 91293 88495 product 94816 M 0
0 91318 88520 product 94841 M 0
0 91473 88674 product 94996 M 0
0 91474 88675 product 94997 M 0
0 91475 88676 product 94998 M 0
0 91505 88706 product 95028 M 0
0 91506 88707 product 95029 M 0
0 91507 88708 product 95030 M 0
0 91508 88709 product 95031 M 0
0 91509 88710 product 95032 M 0
0 91510 88711 product 95033 M 0
0 91511 88712 product 95034 M 0
0 91512 88713 product 95035 M 0
0 91513 88714 product 95036 M 0
0 91514 88715 product 95037 M 0
0 91515 88716 product 95038 M 0
0 91516 88717 product 95039 M 0
0 91517 88718 product 95040 M 0
0 91518 88719 product 95041 M 0
0 91519 88720 product 95042 M 0
0 91520 88721 product 95043 M 0
0 91521 88722 product 95044 M 0
0 91715 88916 product 95238 M 0
0 91718 88919 product 95241 M 0
0 91719 88920 product 95242 M 0
0 91782 88981 product 95305 M 0
0 91794 88993 product 95317 M 0
0 91795 88994 product 95318 M 0
0 91796 88995 product 95319 M 0
0 91797 88996 product 95320 M 0
0 91830 89028 product 95353 M 0
0 91831 89029 product 95354 M 0
0 91832 89030 product 95355 M 0
0 91877 89075 product 95400 M 0
0 91880 89078 product 95403 M 0
0 91881 89079 product 95404 M 0
0 91882 89080 product 95405 M 0
0 91884 89082 product 95407 M 0