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 (
    77538, 77537, 77028, 77529, 77528, 76938, 
    76936, 76909, 77308, 77103, 77356, 
    77354, 77351, 77316, 77313, 76858, 
    76900, 76899, 77353, 77352
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00038

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 20 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 79707 76858 product 83230 M 0
0 79749 76899 product 83272 M 0
0 79750 76900 product 83273 M 0
0 79759 76909 product 83282 M 0
0 79786 76936 product 83309 M 0
0 79788 76938 product 83311 M 0
0 79879 77028 product 83402 M 0
0 79956 77103 product 83479 M 0
0 80163 77308 product 83686 M 0
0 80168 77313 product 83691 M 0
0 80171 77316 product 83694 M 0
0 80206 77351 product 83729 M 0
0 80207 77352 product 83730 M 0
0 80208 77353 product 83731 M 0
0 80209 77354 product 83732 M 0
0 80211 77356 product 83734 M 0
0 80386 77528 product 83909 M 0
0 80387 77529 product 83910 M 0
0 80395 77537 product 83918 M 0
0 80396 77538 product 83919 M 0