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 (
    80587, 80567, 80015, 80010, 80009, 80004, 
    80472, 103007, 80448, 80001, 80272, 
    80080, 80079, 80078, 80077, 80076, 
    80075, 80074, 80073, 80072
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00082

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 5054284552651.jpg 1000 1000 82900 80001 product 86423 M 0 86423
0 5054284479347.jpg 1000 1000 82903 80004 product 86426 M 0 86426
0 5054284479347_lqt5-dk.jpg 1000 1000 82908 80009 product 86431 M 0 86431
0 5054284479347_v4yu-sf.jpg 1000 1000 82909 80010 product 86432 M 0 86432
0 5054284479347_vywu-tp.jpg 1000 1000 82914 80015 product 86437 M 0 86437
0 5054284560465_tysm-z8.jpg 1000 1000 82973 80072 product 86496 M 0 86496
0 5054284560465_yjtb-fh.jpg 1000 1000 82974 80073 product 86497 M 0 86497
0 5054284560465_6txw-x2.jpg 1000 1000 82975 80074 product 86498 M 0 86498
0 5054284560465_a1mu-in.jpg 1000 1000 82976 80075 product 86499 M 0 86499
0 5054284560465_tdmd-a5.jpg 1000 1000 82977 80076 product 86500 M 0 86500
0 5054284560465_g448-q3.jpg 1000 1000 82978 80077 product 86501 M 0 86501
0 5054284560465_honb-02.jpg 1000 1000 82979 80078 product 86502 M 0 86502
0 5054284560465_t7wq-3t.jpg 1000 1000 82980 80079 product 86503 M 0 86503
0 5054284560465_tdvf-7e.jpg 1000 1000 82981 80080 product 86504 M 0 86504
0 5054284571362.jpg 1000 1000 83174 80272 product 86697 M 0 86697
0 5054284587127.jpg 1000 1000 83351 80448 product 86874 M 0 86874
0 5054284588872.jpg 1000 1000 83375 80472 product 86898 M 0 86898
0 5054284595610.jpg 1000 1000 83470 80567 product 86993 M 0 86993
0 5054284595634.jpg 1000 1000 83490 80587 product 87013 M 0 87013
0 5054286475002_o7fo-wy.jpg 1000 1000 106103 103007 product 109626 M 0 109626