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.image_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.00070

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.image_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 63542 61755 product 67065 M 0
0 63562 61775 product 67085 M 0
0 63678 61891 product 67201 M 0
0 65411 63197 product 68934 M 0
0 65514 63300 product 69037 M 0
0 65515 63301 product 69038 M 0
0 65788 63572 product 69311 M 0
0 65789 63573 product 69312 M 0
0 65935 63718 product 69458 M 0
0 65944 63727 product 69467 M 0
0 65992 63775 product 69515 M 0
0 66088 63871 product 69611 M 0
0 66114 63897 product 69637 M 0
0 66115 63898 product 69638 M 0
0 66136 63919 product 69659 M 0
0 66296 64079 product 69819 M 0
0 66297 64080 product 69820 M 0
0 66313 64099 product 69836 M 0
0 66314 64100 product 69837 M 0
0 66334 64120 product 69857 M 0
0 66336 64121 product 69859 M 0
0 66337 64122 product 69860 M 0
0 66367 64145 product 69890 M 0
0 66430 64208 product 69953 M 0
0 66648 64424 product 70171 M 0
0 66654 64425 product 70177 M 0
0 66655 64427 product 70178 M 0
0 66732 64426 product 70255 M 0
0 66733 64429 product 70256 M 0
0 66734 64428 product 70257 M 0
0 66735 64505 product 70258 M 0
0 66736 64506 product 70259 M 0
0 66737 64507 product 70260 M 0
0 66738 64508 product 70261 M 0
0 66740 64509 product 70263 M 0
0 66755 64524 product 70278 M 0
0 66756 64525 product 70279 M 0
0 66762 64531 product 70285 M 0
0 66767 64535 product 70290 M 0
0 98840 64393 product 102363 M 0