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 (
    72204, 70361, 73117, 73112, 71487, 72922, 
    72854, 72853, 72851, 71741, 71202, 
    71175, 71174, 71432, 71152, 71742, 
    71123, 71178, 42032, 71586, 71585, 
    71318, 71549, 71433, 70126, 71459, 
    71014, 70360, 71345, 71344, 71285, 
    71177, 71319, 71290, 71107, 71022, 
    71284, 71277, 71228, 71227
  ) 
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 twistedtraxx.jpg 960 960 43546 42032 product 47069 M 0 47069
0 Fireball_Recordings_302.jpg 1400 1400 72627 70126 product 76150 M 0 76150
0 TBR188.jpg 1400 1400 73005 70360 product 76528 M 0 76528
0 5054283919837.jpg 1000 1000 73758 71014 product 77281 M 0 77281
0 5054283917673.jpg 1000 1000 73766 71022 product 77289 M 0 77289
0 5054283932133.jpg 1000 1000 73906 71107 product 77429 M 0 77429
0 5054283928129.jpg 1000 1000 73922 71123 product 77445 M 0 77445
0 5054283898569.jpg 1000 1000 73952 71152 product 77475 M 0 77475
0 5054283927511.jpg 1000 1000 73975 71174 product 77498 M 0 77498
0 5054283927511_3jtz-3h.jpg 1000 1000 73976 71175 product 77499 M 0 77499
0 image__4_.jpg 800 800 73977 71177 product 77500 M 0 77500
0 image__7_.jpg 800 800 73978 71178 product 77501 M 0 77501
0 5054283941999.jpg 1000 1000 74003 71202 product 77526 M 0 77526
0 SSD036-Release-Artwork-2.jpg 3000 3000 74028 71227 product 77551 M 0 77551
0 FR064_-_Tim_Sloan___Ross_Farley_vs_Random_But_Raw_-_The_Nun.jpg 2000 2000 74029 71228 product 77552 M 0 77552
0 SS080.png 1400 1400 74078 71277 product 77601 M 0 77601
0 TMP0114.png 1400 1400 74085 71284 product 77608 M 0 77608
0 TMP0115.png 1400 1400 74086 71285 product 77609 M 0 77609
0 Labelworx.jpg 2400 2400 74091 71290 product 77614 M 0 77614
0 5054283949889.jpg 1000 1000 74119 71318 product 77642 M 0 77642
0 DD141.jpg 1000 1000 74144 71319 product 77667 M 0 77667
0 45186773_2395757633799501_8675921147230945280_n.jpg 600 600 74145 71344 product 77668 M 0 77668
0 FR065_-_Random_But_Raw_-_Radicalade.jpg 2000 2000 74146 71345 product 77669 M 0 77669
0 damaged_gudz___mark_heyes_pow_dong.jpg 480 480 74233 71432 product 77756 M 0 77756
0 Bootie-Shaker-Artwork_1400x1400.png 1400 1400 74234 71433 product 77757 M 0 77757
0 420rekords_fojo-kp_famp-ve.jpg 727 443 74260 71459 product 77783 M 0 77783
0 5054283960211.jpg 1000 1000 74294 71487 product 77817 M 0 77817
0 HELL009_-_Tribute.jpg 3600 3600 74358 71549 product 77881 M 0 77881
0 d23.jpg 1400 1400 74394 71585 product 77917 M 0 77917
0 d24.jpg 1400 1396 74395 71586 product 77918 M 0 77918
0 Fresh-To-The-Familar-Artwork_1400x1400_.png 1400 1400 74550 71741 product 78073 M 0 78073
0 dd142.jpg 1000 1000 74551 71742 product 78074 M 0 78074
0 5054283987621.jpg 1000 1000 75013 72204 product 78536 M 0 78536
0 Fireball_Recordings_303.jpg 1400 1400 75660 72851 product 79183 M 0 79183
0 Vicious_Circle_Recordings_271_Artwork.jpg 1400 1400 75662 72853 product 79185 M 0 79185
0 JAM029_Dave_Neale_-_Stalker.jpg 1400 1400 75663 72854 product 79186 M 0 79186
0 TMP0116.png 1400 1400 75732 72922 product 79255 M 0 79255
0 SSD037-Release-Artwork.jpg 3000 3000 75922 73112 product 79445 M 0 79445
0 image__8_.jpg 800 800 75927 73117 product 79450 M 0 79450
0 hybridzed.jpg 1400 1400 75962 70361 product 79485 M 0 79485