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 (
    71200, 71013, 70292, 70814, 71176, 71156, 
    71155, 71154, 71153, 70919, 71125, 
    71078, 71113, 70994, 70541, 71108, 
    71015, 70830, 71012, 70827, 71064, 
    71062, 71061, 71011, 70545, 70544, 
    70122, 70813, 70817, 70952, 70947, 
    70540, 70359, 70882, 70881, 70829, 
    70828, 70538, 70230, 70229
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00064

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 72623 70122 product 76146 M 0
0 72770 70229 product 76293 M 0
0 72771 70230 product 76294 M 0
0 72833 70292 product 76356 M 0
0 73004 70359 product 76527 M 0
0 73189 70538 product 76712 M 0
0 73191 70540 product 76714 M 0
0 73192 70541 product 76715 M 0
0 73195 70544 product 76718 M 0
0 73196 70545 product 76719 M 0
0 73543 70813 product 77066 M 0
0 73544 70814 product 77067 M 0
0 73547 70817 product 77070 M 0
0 73558 70827 product 77081 M 0
0 73559 70828 product 77082 M 0
0 73560 70829 product 77083 M 0
0 73566 70830 product 77089 M 0
0 73617 70881 product 77140 M 0
0 73618 70882 product 77141 M 0
0 73656 70919 product 77179 M 0
0 73684 70947 product 77207 M 0
0 73689 70952 product 77212 M 0
0 73738 70994 product 77261 M 0
0 73755 71011 product 77278 M 0
0 73756 71012 product 77279 M 0
0 73757 71013 product 77280 M 0
0 73759 71015 product 77282 M 0
0 73805 71061 product 77328 M 0
0 73806 71062 product 77329 M 0
0 73808 71064 product 77331 M 0
0 73822 71078 product 77345 M 0
0 73907 71108 product 77430 M 0
0 73912 71113 product 77435 M 0
0 73924 71125 product 77447 M 0
0 73953 71153 product 77476 M 0
0 73954 71154 product 77477 M 0
0 73955 71155 product 77478 M 0
0 73959 71156 product 77482 M 0
0 73979 71176 product 77502 M 0
0 74001 71200 product 77524 M 0