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 (
    64531, 63919, 63727, 64535, 64525, 64524, 
    64509, 64424, 64100, 64099, 63197, 
    64508, 64507, 64506, 64505, 64429, 
    64428, 64427, 64426, 64425, 64393, 
    64208, 63573, 63572, 61775, 61755, 
    64145, 64122, 64121, 64120, 61891, 
    64080, 64079, 63775, 63898, 63897, 
    63871, 63718, 63301, 63300
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00120

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_282.jpg 1400 1400 63542 61755 product 67065 M 0 67065
0 Vicious_Circle_Recordings_254_Artwork.jpg 1400 1400 63562 61775 product 67085 M 0 67085
0 STEVE_THORNTON_–_RESONATOR.jpg 960 960 63678 61891 product 67201 M 0 67201
0 TB185.jpg 1400 1400 65411 63197 product 68934 M 0 68934
0 5054283313611_85ns-wb.jpg 1000 1000 65514 63300 product 69037 M 0 69037
0 5054283313611_znr6-rb.jpg 1000 1000 65515 63301 product 69038 M 0 69038
0 5054283313987.jpg 1000 1000 65788 63572 product 69311 M 0 69311
0 5054283313987_792b-fa.jpg 1000 1000 65789 63573 product 69312 M 0 69312
0 TURTLEDOG_LOGO_LABELWORX.jpg 1400 1400 65935 63718 product 69458 M 0 69458
0 5054283316155.jpg 1000 1000 65944 63727 product 69467 M 0 69467
0 Spectrum_myxt-ui.jpg 1100 1100 65992 63775 product 69515 M 0 69515
0 Bezerk.jpg 300 300 66088 63871 product 69611 M 0 69611
0 JAM018_Transformers.jpg 1400 1400 66114 63897 product 69637 M 0 69637
0 IOD044.jpg 900 900 66115 63898 product 69638 M 0 69638
0 23718404_10155762067666000_2094088848_n.jpg 720 720 66136 63919 product 69659 M 0 69659
0 10.jpg 454 454 66296 64079 product 69819 M 0 69819
0 Raw_Procedure.jpg 2000 2000 66297 64080 product 69820 M 0 69820
0 23828639_10155158897242060_1648279826_o.png 1000 930 66313 64099 product 69836 M 0 69836
0 23828639_10155158897242060_1648279826_o_i3ak-ft.png 1000 930 66314 64100 product 69837 M 0 69837
0 TND005.png 960 960 66334 64120 product 69857 M 0 69857
0 SSD027-Release-Artwork.jpg 3000 3000 66336 64121 product 69859 M 0 69859
0 Neverland.jpg 1000 1000 66337 64122 product 69860 M 0 69860
0 JTH006_preview.jpeg 1536 1536 66367 64145 product 69890 M 0 69890
0 FF_048_-_Random_But_Raw___Sinobe_-_Palpable_Shot__Leeroy_Remix_.jpg 2000 2000 66430 64208 product 69953 M 0 69953
0 7.jpg 1152 1152 66648 64424 product 70171 M 0 70171
0 donaldtrumpisanasshole.jpg 442 439 66654 64425 product 70177 M 0 70177
0 culture_aw.jpg 300 300 66655 64427 product 70178 M 0 70178
0 imagination_aw.jpg 736 1086 66732 64426 product 70255 M 0 70255
0 playa_sol.jpg 1600 1143 66733 64429 product 70256 M 0 70256
0 Like_this_aw.jpg 736 1104 66734 64428 product 70257 M 0 70257
0 TMP096.png 1400 1400 66735 64505 product 70258 M 0 70258
0 nightfly.jpg 1920 1080 66736 64506 product 70259 M 0 70259
0 miami_skyline.png 1024 576 66737 64507 product 70260 M 0 70260
0 little_fluffy_clouds.jpg 500 357 66738 64508 product 70261 M 0 70261
0 AR011.jpg 3000 3000 66740 64509 product 70263 M 0 70263
0 house_forever_art.jpg 640 356 66755 64524 product 70278 M 0 70278
0 terminator_endoskeleton_1020.0.jpg 1200 800 66756 64525 product 70279 M 0 70279
0 5054283320268.jpg 1000 1000 66762 64531 product 70285 M 0 70285
0 DD125.jpg 1000 1000 66767 64535 product 70290 M 0 70290
0 03_HELIX_cover_HLXR044.jpg 1400 1400 98840 64393 product 102363 M 0 102363