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.detailed_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.00047

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.detailed_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 5054284371276.jpg 1000 1000 79707 76858 product 83230 M 0 83230
0 5054284402796.jpg 1000 1000 79749 76899 product 83272 M 0 83272
0 5054284402796_dotp-gs.jpg 1000 1000 79750 76900 product 83273 M 0 83273
0 5054284399669_1e5e-61.jpg 1000 1000 79759 76909 product 83282 M 0 83282
0 5054284142586_ke5x-m9.jpg 1000 1000 79786 76936 product 83309 M 0 83309
0 5054284142586_ikyz-ab.jpg 1000 1000 79788 76938 product 83311 M 0 83311
0 5054284410760.jpg 1000 1000 79879 77028 product 83402 M 0 83402
0 5054284427034.jpg 1000 1000 79956 77103 product 83479 M 0 83479
0 5054284442280.jpg 1000 1000 80163 77308 product 83686 M 0 83686
0 5054284442372.jpg 1000 1000 80168 77313 product 83691 M 0 83691
0 5054284442389.jpg 1000 1000 80171 77316 product 83694 M 0 83694
0 5054284442396.jpg 1000 1000 80206 77351 product 83729 M 0 83729
0 5054284442365.jpg 1000 1000 80207 77352 product 83730 M 0 83730
0 5054284442365_e3cc-02.jpg 1000 1000 80208 77353 product 83731 M 0 83731
0 5054284442419.jpg 1000 1000 80209 77354 product 83732 M 0 83732
0 5054284442419_f3ij-xv.jpg 1000 1000 80211 77356 product 83734 M 0 83734
0 5054284455501.jpg 1000 1000 80386 77528 product 83909 M 0 83909
0 5054284455495.jpg 1000 1000 80387 77529 product 83910 M 0 83910
0 5054284455518.jpg 1000 1000 80395 77537 product 83918 M 0 83918
0 5054284455518_15eg-ui.jpg 1000 1000 80396 77538 product 83919 M 0 83919