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 (
    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.00057

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 5054284594521.jpg 1000 1000 84894 81977 product 88417 M 0 88417
0 5054284594521_4c1w-di.jpg 1000 1000 84895 81978 product 88418 M 0 88418
0 5054284722689_jyom-h8.jpg 1000 1000 84917 82000 product 88440 M 0 88440
0 5054284722689_ec1a-p5.jpg 1000 1000 84918 82001 product 88441 M 0 88441
0 5054284594354_z1zg-vx.jpg 1000 1000 85037 82120 product 88560 M 0 88560
0 5054284594354_ue74-i3.jpg 1000 1000 85038 82121 product 88561 M 0 88561
0 5054284744131.jpg 1000 1000 85069 82152 product 88592 M 0 88592
0 5054284752792.jpg 1000 1000 85147 82230 product 88670 M 0 88670
0 5054284750293.jpg 1000 1000 85152 82235 product 88675 M 0 88675
0 5054284756400.jpg 1000 1000 85278 82361 product 88801 M 0 88801
0 5054284764559.jpg 1000 1000 85349 82432 product 88872 M 0 88872
0 5054284764559_wo5g-fj.jpg 1000 1000 85350 82433 product 88873 M 0 88873
0 5054284763378.jpg 1000 1000 85351 82434 product 88874 M 0 88874
0 5054284767338.jpg 1000 1000 85384 82467 product 88907 M 0 88907
0 5054284767321.jpg 1000 1000 85400 82483 product 88923 M 0 88923
0 5054284769042.jpg 1000 1000 85457 82540 product 88980 M 0 88980
0 5054284769042_5vqd-np.jpg 1000 1000 85458 82541 product 88981 M 0 88981
0 5054284769042_edhy-qn.jpg 1000 1000 85460 82543 product 88983 M 0 88983
0 5054284777085.jpg 1000 1000 85489 82572 product 89012 M 0 89012
0 5054284741987_ystf-n4.jpg 1000 1000 86851 83931 product 90374 M 0 90374