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 (
    70121, 70812, 70727, 70339, 70697, 70696, 
    70695, 70694, 70640, 70600, 70584, 
    70539, 70432, 70357, 70587, 70586, 
    70583, 70579, 70537, 70493, 70120, 
    69978, 69977, 70358, 70462, 70459, 
    70458, 70433, 69982, 70435, 70434, 
    70362, 70015, 70014, 70235, 70234, 
    70161, 70119, 69980, 69745
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00061

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 72022 69745 product 75545 M 0
0 72380 69977 product 75903 M 0
0 72381 69978 product 75904 M 0
0 72383 69980 product 75906 M 0
0 72385 69982 product 75908 M 0
0 72477 70014 product 76000 M 0
0 72478 70015 product 76001 M 0
0 72620 70119 product 76143 M 0
0 72621 70120 product 76144 M 0
0 72622 70121 product 76145 M 0
0 72661 70161 product 76184 M 0
0 72775 70234 product 76298 M 0
0 72776 70235 product 76299 M 0
0 72984 70339 product 76507 M 0
0 73002 70357 product 76525 M 0
0 73003 70358 product 76526 M 0
0 73078 70433 product 76601 M 0
0 73079 70434 product 76602 M 0
0 73080 70435 product 76603 M 0
0 73081 70362 product 76604 M 0
0 73104 70458 product 76627 M 0
0 73105 70432 product 76628 M 0
0 73106 70459 product 76629 M 0
0 73109 70462 product 76632 M 0
0 73140 70493 product 76663 M 0
0 73188 70537 product 76711 M 0
0 73190 70539 product 76713 M 0
0 73230 70579 product 76753 M 0
0 73234 70583 product 76757 M 0
0 73235 70584 product 76758 M 0
0 73237 70586 product 76760 M 0
0 73238 70587 product 76761 M 0
0 73296 70600 product 76819 M 0
0 73370 70640 product 76893 M 0
0 73424 70694 product 76947 M 0
0 73425 70695 product 76948 M 0
0 73426 70696 product 76949 M 0
0 73427 70697 product 76950 M 0
0 73457 70727 product 76980 M 0
0 73551 70812 product 77074 M 0