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 (
    69744, 70160, 70124, 70080, 69934, 70084, 
    70083, 70079, 70078, 69981, 69817, 
    69729, 69623, 70081, 69727, 69777, 
    69979, 69906, 69874, 69504, 69983, 
    68700, 69905, 69574, 69826, 69754, 
    69825, 69468, 69755, 69753, 69614, 
    69548, 68699, 69704, 69703, 69700, 
    69699, 69347, 69318, 69619
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00084

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 70968 68699 product 74491 M 0
0 70969 68700 product 74492 M 0
0 71590 69318 product 75113 M 0
0 71621 69347 product 75144 M 0
0 71743 69468 product 75266 M 0
0 71779 69504 product 75302 M 0
0 71823 69548 product 75346 M 0
0 71850 69574 product 75373 M 0
0 71890 69614 product 75413 M 0
0 71896 69619 product 75419 M 0
0 71900 69623 product 75423 M 0
0 71976 69699 product 75499 M 0
0 71977 69700 product 75500 M 0
0 71980 69703 product 75503 M 0
0 71981 69704 product 75504 M 0
0 72004 69727 product 75527 M 0
0 72006 69729 product 75529 M 0
0 72021 69744 product 75544 M 0
0 72031 69753 product 75554 M 0
0 72032 69754 product 75555 M 0
0 72033 69755 product 75556 M 0
0 72099 69817 product 75622 M 0
0 72107 69825 product 75630 M 0
0 72108 69826 product 75631 M 0
0 72244 69874 product 75767 M 0
0 72294 69905 product 75817 M 0
0 72295 69777 product 75818 M 0
0 72296 69906 product 75819 M 0
0 72337 69934 product 75860 M 0
0 72382 69979 product 75905 M 0
0 72384 69981 product 75907 M 0
0 72386 69983 product 75909 M 0
0 72541 70078 product 76064 M 0
0 72542 70079 product 76065 M 0
0 72543 70080 product 76066 M 0
0 72544 70081 product 76067 M 0
0 72546 70083 product 76069 M 0
0 72547 70084 product 76070 M 0
0 72625 70124 product 76148 M 0
0 72701 70160 product 76224 M 0