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 (
    68534, 68533, 68459, 68363, 68362, 68360, 
    68358, 68357, 68135, 68065, 68064, 
    67902, 67896, 67685, 67684, 66983, 
    68359, 67955, 68319, 68312, 67848, 
    67845, 67839, 67686, 67683, 66841, 
    66840, 66839, 67958, 68200, 67770, 
    67769, 67768, 67767, 67766, 67765, 
    67764, 67763, 67762, 67761
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00057

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 69103 66839 product 72626 M 0
0 69104 66840 product 72627 M 0
0 69105 66841 product 72628 M 0
0 69948 67683 product 73471 M 0
0 69949 67684 product 73472 M 0
0 69950 67685 product 73473 M 0
0 69951 67686 product 73474 M 0
0 70027 67761 product 73550 M 0
0 70028 67762 product 73551 M 0
0 70029 67763 product 73552 M 0
0 70030 67764 product 73553 M 0
0 70031 67765 product 73554 M 0
0 70032 67766 product 73555 M 0
0 70033 67767 product 73556 M 0
0 70034 67768 product 73557 M 0
0 70035 67769 product 73558 M 0
0 70036 67770 product 73559 M 0
0 70105 67839 product 73628 M 0
0 70111 67845 product 73634 M 0
0 70114 67848 product 73637 M 0
0 70162 67896 product 73685 M 0
0 70168 67902 product 73691 M 0
0 70221 67955 product 73744 M 0
0 70224 67958 product 73747 M 0
0 70332 68064 product 73855 M 0
0 70333 68065 product 73856 M 0
0 70403 68135 product 73926 M 0
0 70469 68200 product 73992 M 0
0 70581 68312 product 74104 M 0
0 70588 68319 product 74111 M 0
0 70626 68357 product 74149 M 0
0 70627 68358 product 74150 M 0
0 70628 68359 product 74151 M 0
0 70630 68360 product 74153 M 0
0 70632 68362 product 74155 M 0
0 70633 68363 product 74156 M 0
0 70729 68459 product 74252 M 0
0 70803 68533 product 74326 M 0
0 70804 68534 product 74327 M 0
0 100708 66983 product 104231 M 0