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 (
    68974, 68973, 68972, 68971, 68970, 68969, 
    68968, 68967, 68966, 68965, 68964, 
    68963, 68962, 68961, 68960, 68959, 
    68958, 68957, 68956, 68955, 68954, 
    68953, 68952, 68951, 68950, 68949, 
    68948, 68947, 68946, 68945, 68321, 
    68290, 68289, 68288, 68286, 68285, 
    68284, 68283, 68282, 68281
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00087

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 70550 68281 product 74073 M 0
0 70551 68282 product 74074 M 0
0 70552 68283 product 74075 M 0
0 70553 68284 product 74076 M 0
0 70554 68285 product 74077 M 0
0 70555 68286 product 74078 M 0
0 70557 68288 product 74080 M 0
0 70558 68289 product 74081 M 0
0 70559 68290 product 74082 M 0
0 70590 68321 product 74113 M 0
0 71215 68945 product 74738 M 0
0 71216 68946 product 74739 M 0
0 71217 68947 product 74740 M 0
0 71218 68948 product 74741 M 0
0 71219 68949 product 74742 M 0
0 71220 68950 product 74743 M 0
0 71221 68951 product 74744 M 0
0 71222 68952 product 74745 M 0
0 71223 68953 product 74746 M 0
0 71224 68954 product 74747 M 0
0 71225 68955 product 74748 M 0
0 71226 68956 product 74749 M 0
0 71227 68957 product 74750 M 0
0 71228 68958 product 74751 M 0
0 71229 68959 product 74752 M 0
0 71230 68960 product 74753 M 0
0 71231 68961 product 74754 M 0
0 71232 68962 product 74755 M 0
0 71233 68963 product 74756 M 0
0 71234 68964 product 74757 M 0
0 71235 68965 product 74758 M 0
0 71236 68966 product 74759 M 0
0 71237 68967 product 74760 M 0
0 71238 68968 product 74761 M 0
0 71239 68969 product 74762 M 0
0 71240 68970 product 74763 M 0
0 71241 68971 product 74764 M 0
0 71242 68972 product 74765 M 0
0 71243 68973 product 74766 M 0
0 71244 68974 product 74767 M 0