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.detailed_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.00076

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.detailed_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 Fireball_Recordings_300.jpg 1400 1400 72623 70122 product 76146 M 0 76146
0 5054283782387.jpg 1000 1000 72770 70229 product 76293 M 0 76293
0 5054283782387_9k89-j1.jpg 1000 1000 72771 70230 product 76294 M 0 76294
0 Fireball_Recordings_301_-_UPDATED.jpg 1400 1400 72833 70292 product 76356 M 0 76356
0 TBR187.jpg 1400 1400 73004 70359 product 76527 M 0 76527
0 40684347_310593839736814_4400437386253697024_n.png 960 960 73189 70538 product 76712 M 0 76712
0 image__2_.jpg 800 800 73191 70540 product 76714 M 0 76714
0 D-_FI.jpg 800 800 73192 70541 product 76715 M 0 76715
0 5054283837391.jpg 1000 1000 73195 70544 product 76718 M 0 76718
0 5054283837391_euxc-sj.jpg 1000 1000 73196 70545 product 76719 M 0 76719
0 IOD066_wh73-bo.jpg 900 900 73543 70813 product 77066 M 0 77066
0 IOD067_.jpg 900 900 73544 70814 product 77067 M 0 77067
0 5054283893960.jpg 1000 1000 73547 70817 product 77070 M 0 77070
0 5054283893984.jpg 1000 1000 73558 70827 product 77081 M 0 77081
0 mlh.jpg 960 960 73559 70828 product 77082 M 0 77082
0 Stereophonic-Sound-Track-Artwork.png 2481 2481 73560 70829 product 77083 M 0 77083
0 5054283898194.jpg 1000 1000 73566 70830 product 77089 M 0 77089
0 TURTLEDOG_LOGO_RGB.jpg 802 888 73617 70881 product 77140 M 0 77140
0 TURTLEDOG_LOGO__1_.jpg 802 888 73618 70882 product 77141 M 0 77141
0 5054283904451.jpg 1000 1000 73656 70919 product 77179 M 0 77179
0 42099747_357539155068230_5276859157020934144_n.jpg 1600 1600 73684 70947 product 77207 M 0 77207
0 Tim_Sloan_Slender_Man_PIC_420.jpg 2000 2000 73689 70952 product 77212 M 0 77212
0 Embrace-Me-Artwork_1x.png 2481 2481 73738 70994 product 77261 M 0 77261
0 Having-Fun-Track-Artwork_v5.png 2481 2481 73755 71011 product 77278 M 0 77278
0 SS079.jpg 1400 1400 73756 71012 product 77279 M 0 77279
0 5054283919820.jpg 1000 1000 73757 71013 product 77280 M 0 77280
0 5054283919202.jpg 1000 1000 73759 71015 product 77282 M 0 77282
0 43649904_2192734807466992_5868859659347034112_n.png 960 960 73805 71061 product 77328 M 0 77328
0 FR063_-_Will_Shepherd_-_Free.jpg 2000 2000 73806 71062 product 77329 M 0 77329
0 TMP0113.png 1400 1400 73808 71064 product 77331 M 0 77331
0 mark_hard_dan_dyson_systematic_error.jpg 480 480 73822 71078 product 77345 M 0 77345
0 F4A007_-_Craig_Jones_-_Fear_Not.jpg 3000 3000 73907 71108 product 77430 M 0 77430
0 JAM028_Tom_Whyld_-_Spellcaster.jpg 1400 1400 73912 71113 product 77435 M 0 77435
0 LOGO_SQUARE_Cropped.jpg 375 375 73924 71125 product 77447 M 0 77447
0 Dreamin.jpg 1080 1080 73953 71153 product 77476 M 0 77476
0 Dreamzone.jpg 300 300 73954 71154 product 77477 M 0 77477
0 Fantasy.jpg 300 300 73955 71155 product 77478 M 0 77478
0 Desire_remix.jpg 300 300 73959 71156 product 77482 M 0 77482
0 43565445_173339510252652_8945801086631936000_n.png 960 960 73979 71176 product 77502 M 0 77502
0 All-It-Takes-Track-Artwork_.png 1400 1400 74001 71200 product 77524 M 0 77524