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 (
    82152, 82121, 82120, 82572, 82433, 82432, 
    82543, 82541, 82540, 82467, 83931, 
    82483, 82434, 81978, 81977, 82361, 
    82230, 82235, 82001, 82000
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 84894 81977 product 88417 M 0
0 84895 81978 product 88418 M 0
0 84917 82000 product 88440 M 0
0 84918 82001 product 88441 M 0
0 85037 82120 product 88560 M 0
0 85038 82121 product 88561 M 0
0 85069 82152 product 88592 M 0
0 85147 82230 product 88670 M 0
0 85152 82235 product 88675 M 0
0 85278 82361 product 88801 M 0
0 85349 82432 product 88872 M 0
0 85350 82433 product 88873 M 0
0 85351 82434 product 88874 M 0
0 85384 82467 product 88907 M 0
0 85400 82483 product 88923 M 0
0 85457 82540 product 88980 M 0
0 85458 82541 product 88981 M 0
0 85460 82543 product 88983 M 0
0 85489 82572 product 89012 M 0
0 86851 83931 product 90374 M 0