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 (
    14819, 14818, 39047, 14808, 14807, 23244, 
    23237, 14795, 14720, 14713, 14730, 
    14728, 14726, 14723, 14722, 14787, 
    14701, 76378, 76377, 14677, 14663, 
    14662, 14661, 14660, 14659, 14658, 
    14657, 14656, 14654, 14653, 14652, 
    14651, 14649, 14648, 14647, 14646, 
    14645, 14644, 14643, 14642
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00075

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 14655 14642 product 18178 M 0
0 14656 14643 product 18179 M 0
0 14657 14644 product 18180 M 0
0 14658 14645 product 18181 M 0
0 14659 14646 product 18182 M 0
0 14660 14647 product 18183 M 0
0 14661 14648 product 18184 M 0
0 14662 14649 product 18185 M 0
0 14664 14651 product 18187 M 0
0 14665 14652 product 18188 M 0
0 14666 14653 product 18189 M 0
0 14667 14654 product 18190 M 0
0 14669 14656 product 18192 M 0
0 14670 14657 product 18193 M 0
0 14671 14658 product 18194 M 0
0 14672 14659 product 18195 M 0
0 14673 14660 product 18196 M 0
0 14674 14661 product 18197 M 0
0 14675 14662 product 18198 M 0
0 14676 14663 product 18199 M 0
0 14690 14677 product 18213 M 0
0 14714 14701 product 18237 M 0
0 14726 14713 product 18249 M 0
0 14733 14720 product 18256 M 0
0 14735 14722 product 18258 M 0
0 14736 14723 product 18259 M 0
0 14739 14726 product 18262 M 0
0 14741 14728 product 18264 M 0
0 14743 14730 product 18266 M 0
0 14800 14787 product 18323 M 0
0 14808 14795 product 18331 M 0
0 14819 14807 product 18342 M 0
0 14820 14808 product 18343 M 0
0 14830 14818 product 18353 M 0
0 14831 14819 product 18354 M 0
0 23254 23237 product 26777 M 0
0 23261 23244 product 26784 M 0
0 40507 39047 product 44030 M 0
0 79226 76377 product 82749 M 0
0 79227 76378 product 82750 M 0