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 (
    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.00083

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 5054283722703_h827-h4.jpg 1000 1000 72022 69745 product 75545 M 0 75545
0 5054283724554.jpg 1000 1000 72380 69977 product 75903 M 0 75903
0 5054283724554_13p1-ix.jpg 1000 1000 72381 69978 product 75904 M 0 75904
0 37488211_650391488692875_4721857826559885312_n.png 960 960 72383 69980 product 75906 M 0 75906
0 image.jpg 800 800 72385 69982 product 75908 M 0 75908
0 5054283836950.jpg 1000 1000 72477 70014 product 76000 M 0 76000
0 5054283837704.jpg 1000 1000 72478 70015 product 76001 M 0 76001
0 Fireball_Recordings_297.jpg 1400 1400 72620 70119 product 76143 M 0 76143
0 Fireball_Recordings_298.jpg 1400 1400 72621 70120 product 76144 M 0 76144
0 Fireball_Recordings_299.jpg 1400 1400 72622 70121 product 76145 M 0 76145
0 Unreadable-Track-Artwork.png 2481 2481 72661 70161 product 76184 M 0 76184
0 SSD035-Release-Artwork-2.jpg 3000 3000 72775 70234 product 76298 M 0 76298
0 FF060_-_Matt_Clarkson_-_It's_A_Dream.jpg 2000 2000 72776 70235 product 76299 M 0 76299
0 5054283857535.jpg 1000 1000 72984 70339 product 76507 M 0 76507
0 5054283857511.jpg 1000 1000 73002 70357 product 76525 M 0 76525
0 edited.jpg 1400 1400 73003 70358 product 76526 M 0 76526
0 FR061_-_Random_But_Raw_-_Fired_Up.jpg 2000 2000 73078 70433 product 76601 M 0 76601
0 ONLY_UR_LOVIN.jpg 2000 2000 73079 70434 product 76602 M 0 76602
0 SLIM_BOY_FAT_COVER.jpg 2000 2000 73080 70435 product 76603 M 0 76603
0 IOD062.jpg 1400 1400 73081 70362 product 76604 M 0 76604
0 Vicious_Circle_Recordings_270_Artwork.jpg 1400 1400 73104 70458 product 76627 M 0 76627
0 WAIT_FOR_ME.jpg 480 480 73105 70432 product 76628 M 0 76628
0 TURTLEDOG_LOGO_RGB.jpg 802 888 73106 70459 product 76629 M 0 76629
0 LOGO_SQUARE_Cropped_6x8y-0i.jpg 375 375 73109 70462 product 76632 M 0 76632
0 Man-Hunt-Track-Artwork.png 2481 2481 73140 70493 product 76663 M 0 76663
0 40756494_1890101784416465_1310216985241452544_n.png 960 960 73188 70537 product 76711 M 0 76711
0 image__1_.jpg 800 800 73190 70539 product 76713 M 0 76713
0 TURTLEDOG_LOGO_LABELWORX.jpg 1000 1000 73230 70579 product 76753 M 0 76753
0 TMP0111.png 1400 1400 73234 70583 product 76757 M 0 76757
0 TMP0112.png 1400 1400 73235 70584 product 76758 M 0 76758
0 LOGO_SQUARE_Cropped_f7d4-gd.jpg 375 375 73237 70586 product 76760 M 0 76760
0 LOGO_SQUARE_Cropped_pdly-6r.jpg 375 375 73238 70587 product 76761 M 0 76761
0 FR062_-_Random_But_Raw_-_Luna.jpg 2000 2000 73296 70600 product 76819 M 0 76819
0 42099708_1845896592112423_1096628519309410304_n.jpg 1600 1600 73370 70640 product 76893 M 0 76893
0 JAM027_Leighton_Smith_-_4Ever.jpg 1400 1400 73424 70694 product 76947 M 0 76947
0 TURTLEDOG_LOGO_RGB_xxku-e9.jpg 802 888 73425 70695 product 76948 M 0 76948
0 TURTLEDOG_LOGO_RGB_aorw-c0.jpg 802 888 73426 70696 product 76949 M 0 76949
0 TURTLEDOG_LOGO_RGB_tlhl-4f.jpg 802 888 73427 70697 product 76950 M 0 76950
0 LOGO_SQUARE_Cropped_tywt-xi.jpg 375 375 73457 70727 product 76980 M 0 76980
0 IOD065.jpg 900 900 73551 70812 product 77074 M 0 77074