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 (
    67257, 67256, 66534, 67158, 67208, 67196, 
    67195, 66979, 66878, 66812, 66787, 
    66527, 65967, 66881, 67016, 67014, 
    66981, 66980, 66784, 66622, 66621, 
    66393, 61786, 66986, 66985, 66978, 
    66846, 66843, 66842, 66783, 66780, 
    66286, 66283, 66214, 66779, 65966, 
    66533, 66729, 66594, 66287
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00102

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 63573 61786 product 67096 M 0
0 68227 65966 product 71750 M 0
0 68228 65967 product 71751 M 0
0 68475 66214 product 71998 M 0
0 68544 66283 product 72067 M 0
0 68547 66286 product 72070 M 0
0 68548 66287 product 72071 M 0
0 68655 66393 product 72178 M 0
0 68790 66527 product 72313 M 0
0 68796 66533 product 72319 M 0
0 68797 66534 product 72320 M 0
0 68857 66594 product 72380 M 0
0 68884 66621 product 72407 M 0
0 68885 66622 product 72408 M 0
0 68993 66729 product 72516 M 0
0 69043 66779 product 72566 M 0
0 69044 66780 product 72567 M 0
0 69047 66783 product 72570 M 0
0 69048 66784 product 72571 M 0
0 69051 66787 product 72574 M 0
0 69076 66812 product 72599 M 0
0 69106 66842 product 72629 M 0
0 69107 66843 product 72630 M 0
0 69110 66846 product 72633 M 0
0 69142 66878 product 72665 M 0
0 69145 66881 product 72668 M 0
0 69242 66978 product 72765 M 0
0 69243 66979 product 72766 M 0
0 69249 66985 product 72772 M 0
0 69250 66986 product 72773 M 0
0 69278 67014 product 72801 M 0
0 69280 67016 product 72803 M 0
0 69422 67158 product 72945 M 0
0 69459 67195 product 72982 M 0
0 69460 67196 product 72983 M 0
0 69472 67208 product 72995 M 0
0 69520 67256 product 73043 M 0
0 69521 67257 product 73044 M 0
0 100705 66980 product 104228 M 0
0 100706 66981 product 104229 M 0