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 (
    62636, 62635, 62634, 62633, 62632, 62631, 
    62630, 62629, 62628, 62627, 62626, 
    62625, 62611, 62609, 62607, 62569, 
    62456, 61887, 60269, 62370, 62342, 
    62098, 62097, 61770, 61769, 61704, 
    60784, 60268, 62217, 61403, 61442, 
    62055, 61886, 61768, 60787, 60267, 
    62105, 61512, 62019, 61960
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00086

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 61804 60267 product 65327 M 0
0 61805 60268 product 65328 M 0
0 61806 60269 product 65329 M 0
0 62555 60784 product 66078 M 0
0 62558 60787 product 66081 M 0
0 63187 61403 product 66710 M 0
0 63226 61442 product 66749 M 0
0 63300 61512 product 66823 M 0
0 63491 61704 product 67014 M 0
0 63555 61768 product 67078 M 0
0 63556 61769 product 67079 M 0
0 63557 61770 product 67080 M 0
0 63673 61886 product 67196 M 0
0 63674 61887 product 67197 M 0
0 63747 61960 product 67270 M 0
0 63806 62019 product 67329 M 0
0 63842 62055 product 67365 M 0
0 63884 62097 product 67407 M 0
0 63885 62098 product 67408 M 0
0 63892 62105 product 67415 M 0
0 64004 62217 product 67527 M 0
0 64269 62342 product 67792 M 0
0 64298 62370 product 67821 M 0
0 64631 62456 product 68154 M 0
0 64759 62569 product 68282 M 0
0 64797 62607 product 68320 M 0
0 64799 62609 product 68322 M 0
0 64801 62611 product 68324 M 0
0 64870 62625 product 68393 M 0
0 64871 62626 product 68394 M 0
0 64872 62627 product 68395 M 0
0 64873 62628 product 68396 M 0
0 64874 62629 product 68397 M 0
0 64875 62630 product 68398 M 0
0 64876 62631 product 68399 M 0
0 64877 62632 product 68400 M 0
0 64878 62633 product 68401 M 0
0 64879 62634 product 68402 M 0
0 64880 62635 product 68403 M 0
0 64881 62636 product 68404 M 0