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 (
    88313, 88312, 88311, 88310, 88261, 88260, 
    88259, 89141, 88890, 88747, 88679, 
    88678, 88336, 88392, 88206, 88205, 
    88204, 88203, 88202, 88201
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00052

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.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 90971 88201 product 94494 M 0
0 90972 88202 product 94495 M 0
0 90973 88203 product 94496 M 0
0 90974 88204 product 94497 M 0
0 90975 88205 product 94498 M 0
0 90976 88206 product 94499 M 0
0 91031 88259 product 94554 M 0
0 91032 88260 product 94555 M 0
0 91033 88261 product 94556 M 0
0 91083 88310 product 94606 M 0
0 91084 88311 product 94607 M 0
0 91085 88312 product 94608 M 0
0 91086 88313 product 94609 M 0
0 91110 88336 product 94633 M 0
0 91190 88392 product 94713 M 0
0 91477 88678 product 95000 M 0
0 91478 88679 product 95001 M 0
0 91546 88747 product 95069 M 0
0 91689 88890 product 95212 M 0
0 91944 89141 product 95467 M 0