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 (
    61885, 61787, 61767, 61766, 61519, 61518, 
    61116, 60266, 59324, 61789, 61788, 
    61217, 59956, 61633, 61112, 61007, 
    61006, 60975, 60963, 60854, 60265, 
    61632, 61613, 61523, 61583, 61565, 
    58785, 61509, 61418, 61407, 61406, 
    61391, 61016, 60853, 60264, 59808, 
    61508, 60867, 61409, 61157
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00106

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_274.jpg 1400 1400 60319 58785 product 63842 M 0 63842
0 Fireball_Recordings_275.jpg 1400 1400 60854 59324 product 64377 M 0 64377
0 ENC084.jpg 1400 1400 61344 59808 product 64867 M 0 64867
0 TB182.jpg 1400 1400 61491 59956 product 65014 M 0 65014
0 ACID_HOUSE_PARTY_-_94.jpg 1000 1000 61801 60264 product 65324 M 0 65324
0 STEP_BACK_-_95.jpg 1000 1000 61802 60265 product 65325 M 0 65325
0 I_DONT_TECHNO_SHIT_-_96.jpg 1000 1000 61803 60266 product 65326 M 0 65326
0 CRAIG_MAC_–_WHAT'S_GOING_ON.jpg 960 960 62624 60853 product 66147 M 0 66147
0 KID_RICH_&_RANDOM_BUT_RAW_VS_FRANK_FARRELL_–_BUG_HUNT.jpg 960 960 62625 60854 product 66148 M 0 66148
0 DS032A.jpg 2048 2048 62638 60867 product 66161 M 0 66161
0 18339026_10158483832715391_1379056781_o.jpg 1400 1400 62749 60963 product 66272 M 0 66272
0 5054283064353.jpg 1000 1000 62761 60975 product 66284 M 0 66284
0 macandcheesesleevefinal.png 1600 1602 62792 61006 product 66315 M 0 66315
0 macandcheesesleevefinal_7grt-ps.png 1600 1602 62793 61007 product 66316 M 0 66316
0 5054283169294.jpg 1000 1000 62802 61016 product 66325 M 0 66325
0 5054283169331.jpg 1000 1000 62898 61112 product 66421 M 0 66421
0 5054283172966.jpg 1000 1000 62902 61116 product 66425 M 0 66425
0 DC031-Sub-Ctrl-_Stop_Squaring.jpg 1000 1000 62943 61157 product 66466 M 0 66466
0 5054283182590.jpg 1000 1000 63003 61217 product 66526 M 0 66526
0 Neverland_kxwz-09.jpg 1000 1000 63190 61406 product 66713 M 0 66713
0 001-1000x1000.jpg 1000 1000 63192 61409 product 66715 M 0 66715
0 Bezerk.jpg 300 300 63202 61418 product 66725 M 0 66725
0 iod037.jpg 900 900 63292 61508 product 66815 M 0 66815
0 Fist_Pump.jpg 240 240 63295 61391 product 66818 M 0 66818
0 Fist_Pump_gbqy-yv.jpg 240 240 63296 61407 product 66819 M 0 66819
0 SSD024-Release-Artwork-OWB.jpg 3000 3000 63297 61509 product 66820 M 0 66820
0 5054283200522.jpg 1000 1000 63306 61518 product 66829 M 0 66829
0 5054283200522_o3zp-e6.jpg 1000 1000 63307 61519 product 66830 M 0 66830
0 TMP090.png 1400 1400 63311 61523 product 66834 M 0 66834
0 ORRIBLE_NOIZE.jpg 960 960 63353 61565 product 66876 M 0 66876
0 Fist_Pump_5gl7-gn.jpg 240 240 63371 61583 product 66894 M 0 66894
0 dd120.jpg 1000 1000 63401 61613 product 66924 M 0 66924
0 SPEAK003.jpg 1400 1400 63421 61632 product 66944 M 0 66944
0 Vicious_Circle_Recordings_247a_Artwork.jpg 1400 1400 63553 61766 product 67076 M 0 67076
0 Vicious_Circle_Recordings_247_Artwork_ectm-0u.jpg 1400 1400 63554 61767 product 67077 M 0 67077
0 UNBND002-1680x1680.jpg 1680 1680 63574 61787 product 67097 M 0 67097
0 Smiles.jpg 2009 1885 63575 61788 product 67098 M 0 67098
0 HFV7.jpg 300 300 63576 61789 product 67099 M 0 67099
0 TMP091.png 1400 1400 63672 61885 product 67195 M 0 67195
0 03_HELIX_cover_HLXR041.jpg 1400 1400 98837 61633 product 102360 M 0 102360