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 (
    68280, 68279, 68278, 68277, 68276, 68275, 
    68274, 68575, 68204, 68406, 68375, 
    78288, 78287, 78286, 78285, 78284, 
    78283, 78282, 78281, 78280, 78279, 
    78278, 78277, 78276, 78275, 78274, 
    78273, 78272, 78271, 78270, 78269, 
    78268, 78267, 78266, 78265, 78264, 
    78263, 78262, 68395, 68189
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00084

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 70458 68189 product 73981 M 0
0 70473 68204 product 73996 M 0
0 70543 68274 product 74066 M 0
0 70544 68275 product 74067 M 0
0 70545 68276 product 74068 M 0
0 70546 68277 product 74069 M 0
0 70547 68278 product 74070 M 0
0 70548 68279 product 74071 M 0
0 70549 68280 product 74072 M 0
0 70645 68375 product 74168 M 0
0 70665 68395 product 74188 M 0
0 70676 68406 product 74199 M 0
0 70845 68575 product 74368 M 0
0 81120 78262 product 84643 M 0
0 81121 78263 product 84644 M 0
0 81122 78264 product 84645 M 0
0 81123 78265 product 84646 M 0
0 81124 78266 product 84647 M 0
0 81125 78267 product 84648 M 0
0 81126 78268 product 84649 M 0
0 81127 78269 product 84650 M 0
0 81128 78270 product 84651 M 0
0 81129 78271 product 84652 M 0
0 81130 78272 product 84653 M 0
0 81131 78273 product 84654 M 0
0 81132 78274 product 84655 M 0
0 81133 78275 product 84656 M 0
0 81134 78276 product 84657 M 0
0 81135 78277 product 84658 M 0
0 81136 78278 product 84659 M 0
0 81137 78279 product 84660 M 0
0 81138 78280 product 84661 M 0
0 81139 78281 product 84662 M 0
0 81140 78282 product 84663 M 0
0 81141 78283 product 84664 M 0
0 81142 78284 product 84665 M 0
0 81143 78285 product 84666 M 0
0 81144 78286 product 84667 M 0
0 81145 78287 product 84668 M 0
0 81146 78288 product 84669 M 0