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 (
    14784, 14785, 14704, 14484, 14477, 18813, 
    14406, 14472, 14466, 14462, 14460, 
    13991, 13928, 13890, 13798, 13781, 
    18826, 18825, 13545, 13746
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00068

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 5052653520942.jpg 1000 1000 13557 13545 product 17080 M 0 17080
0 thumpers_black_bag1360094939511166db3640c.jpg 1821 1805 13759 13746 product 17282 M 0 17282
0 5052653529280.jpg 1000 1000 13794 13781 product 17317 M 0 17317
0 5052653517126.jpg 1000 1000 13811 13798 product 17334 M 0 17334
0 5052653522366.jpg 1000 1000 13903 13890 product 17426 M 0 17426
0 5052653533232.jpg 1000 1000 13941 13928 product 17464 M 0 17464
0 5052653535809.jpg 1000 1000 14004 13991 product 17527 M 0 17527
0 5052653534888.jpg 1000 1000 14419 14406 product 17942 M 0 17942
0 thumpers_black_bag1361904337512d02d1d47ba.jpg 1821 1805 14473 14460 product 17996 M 0 17996
0 12_inch_thumpin_hard_cover_11361904465512d035101e64.jpg 1821 1805 14475 14462 product 17998 M 0 17998
0 thumpers_black_bag1361905161512d0609bc4e0.jpg 1821 1805 14479 14466 product 18002 M 0 18002
0 thumpers_black_bag1361905632512d07e06c943.jpg 1821 1805 14485 14472 product 18008 M 0 18008
0 5052653497916.jpg 1000 1000 14490 14477 product 18013 M 0 18013
0 5052653547185.jpg 1000 1000 14497 14484 product 18020 M 0 18020
0 5052653555982.jpg 1000 1000 14717 14704 product 18240 M 0 18240
0 5052653561235.jpg 1000 1000 14797 14784 product 18320 M 0 18320
0 5052653567763.jpg 1000 1000 14798 14785 product 18321 M 0 18321
0 5052653899147.jpg 1000 1000 18820 18813 product 22343 M 0 22343
0 5052653899116.jpg 1000 1000 18832 18825 product 22355 M 0 22355
0 50526538991161385269221529187e5376d4.jpg 1000 1000 18833 18826 product 22356 M 0 22356