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 (
    66793, 66792, 66791, 66790, 66789, 67007, 
    66714, 66711, 66706, 66704, 66697, 
    66696, 66692, 66725, 66721, 66312, 
    66282, 66281, 66662, 66619, 66618, 
    66617, 66616, 66615, 66614, 66613, 
    66612, 66611, 66610, 66609, 66608, 
    66526, 66206, 66205, 66204, 66203, 
    66202, 66201, 66200, 66199
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00065

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 68460 66199 product 71983 M 0
0 68461 66200 product 71984 M 0
0 68462 66201 product 71985 M 0
0 68463 66202 product 71986 M 0
0 68464 66203 product 71987 M 0
0 68465 66204 product 71988 M 0
0 68466 66205 product 71989 M 0
0 68467 66206 product 71990 M 0
0 68542 66281 product 72065 M 0
0 68543 66282 product 72066 M 0
0 68573 66312 product 72096 M 0
0 68789 66526 product 72312 M 0
0 68871 66608 product 72394 M 0
0 68872 66609 product 72395 M 0
0 68873 66610 product 72396 M 0
0 68874 66611 product 72397 M 0
0 68875 66612 product 72398 M 0
0 68876 66613 product 72399 M 0
0 68877 66614 product 72400 M 0
0 68878 66615 product 72401 M 0
0 68879 66616 product 72402 M 0
0 68880 66617 product 72403 M 0
0 68881 66618 product 72404 M 0
0 68882 66619 product 72405 M 0
0 68925 66662 product 72448 M 0
0 68955 66692 product 72478 M 0
0 68959 66696 product 72482 M 0
0 68960 66697 product 72483 M 0
0 68967 66704 product 72490 M 0
0 68969 66706 product 72492 M 0
0 68974 66711 product 72497 M 0
0 68977 66714 product 72500 M 0
0 68984 66721 product 72507 M 0
0 68988 66725 product 72511 M 0
0 69053 66789 product 72576 M 0
0 69054 66790 product 72577 M 0
0 69055 66791 product 72578 M 0
0 69056 66792 product 72579 M 0
0 69057 66793 product 72580 M 0
0 69271 67007 product 72794 M 0