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 (
    91821, 92682, 89223, 92807, 92769, 92768, 
    92767, 92760, 92759, 92757, 92256, 
    92572, 92523, 92280, 92259, 92237, 
    92674, 92571, 92524, 92460
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00043

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 94668 91821 product 98191 M 0
0 95091 92237 product 98614 M 0
0 95110 92256 product 98633 M 0
0 95113 92259 product 98636 M 0
0 95134 92280 product 98657 M 0
0 95316 92460 product 98839 M 0
0 95381 92523 product 98904 M 0
0 95382 92524 product 98905 M 0
0 95429 92571 product 98952 M 0
0 95430 92572 product 98953 M 0
0 95533 92674 product 99056 M 0
0 95540 92682 product 99063 M 0
0 95615 92757 product 99138 M 0
0 95617 92759 product 99140 M 0
0 95618 92760 product 99141 M 0
0 95625 92767 product 99148 M 0
0 95626 92768 product 99149 M 0
0 95627 92769 product 99150 M 0
0 95665 92807 product 99188 M 0
0 95742 89223 product 99265 M 0