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 (
    69285, 69284, 69283, 69282, 69281, 69280, 
    69279, 69278, 69277, 69276, 69275, 
    69274, 69273, 69272, 69271, 69270, 
    69269, 69268, 69267, 69266, 69265, 
    69264, 69263, 69262, 69261, 69260, 
    69259, 69258, 69128, 68673, 68672, 
    68671, 68670, 68669, 68668, 69121, 
    68664, 68460, 68380, 68611
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00082

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 70650 68380 product 74173 M 0
0 70730 68460 product 74253 M 0
0 70881 68611 product 74404 M 0
0 70934 68664 product 74457 M 0
0 70938 68668 product 74461 M 0
0 70939 68669 product 74462 M 0
0 70940 68670 product 74463 M 0
0 70941 68671 product 74464 M 0
0 70942 68672 product 74465 M 0
0 70943 68673 product 74466 M 0
0 71392 69121 product 74915 M 0
0 71399 69128 product 74922 M 0
0 71530 69258 product 75053 M 0
0 71531 69259 product 75054 M 0
0 71532 69260 product 75055 M 0
0 71533 69261 product 75056 M 0
0 71534 69262 product 75057 M 0
0 71535 69263 product 75058 M 0
0 71536 69264 product 75059 M 0
0 71537 69265 product 75060 M 0
0 71538 69266 product 75061 M 0
0 71539 69267 product 75062 M 0
0 71540 69268 product 75063 M 0
0 71541 69269 product 75064 M 0
0 71542 69270 product 75065 M 0
0 71543 69271 product 75066 M 0
0 71544 69272 product 75067 M 0
0 71545 69273 product 75068 M 0
0 71546 69274 product 75069 M 0
0 71547 69275 product 75070 M 0
0 71548 69276 product 75071 M 0
0 71549 69277 product 75072 M 0
0 71550 69278 product 75073 M 0
0 71551 69279 product 75074 M 0
0 71552 69280 product 75075 M 0
0 71553 69281 product 75076 M 0
0 71554 69282 product 75077 M 0
0 71555 69283 product 75078 M 0
0 71556 69284 product 75079 M 0
0 71557 69285 product 75080 M 0