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 (
    14263, 14262, 8767, 8765, 8604, 8783, 
    14054, 14053, 14050, 79658, 79611, 
    79600, 79615, 79712, 79660, 79659, 
    79613, 79612, 14508, 14550
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00071

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 50552740819151344940263502a28e74d791.jpg 1000 1000 8615 8604 product 12138 M 0 12138
0 50552740875661344941388502a2d4cb31b6.jpg 1000 1000 8776 8765 product 12299 M 0 12299
0 50552740875661344941394502a2d52f1b74.jpg 1000 1000 8778 8767 product 12301 M 0 12301
0 50552740788161344941569502a2e01c6b3a.jpg 1000 1000 8794 8783 product 12317 M 0 12317
0 5025375513110.jpg 1000 1000 14063 14050 product 17586 M 0 17586
0 502537551311013614228125125a9dceed7e.jpg 1000 1000 14066 14053 product 17589 M 0 17589
0 502537551311013614228145125a9dea3b56.jpg 1000 1000 14067 14054 product 17590 M 0 17590
0 502537551327113614247565125b1748f31a.jpg 1000 1000 14275 14262 product 17798 M 0 17798
0 502537551327113614247585125b17632887.jpg 1000 1000 14276 14263 product 17799 M 0 17799
0 5052653544139.jpg 1000 1000 14521 14508 product 18044 M 0 18044
0 50253751017511362200543513187df0832f.jpg 1000 1000 14563 14550 product 18086 M 0 18086
0 5054284516929.jpg 1000 1000 82466 79600 product 85989 M 0 85989
0 5054284516943.jpg 1000 1000 82477 79611 product 86000 M 0 86000
0 5054284516981.jpg 1000 1000 82478 79612 product 86001 M 0 86001
0 5054284516981_jl2n-1c.jpg 1000 1000 82479 79613 product 86002 M 0 86002
0 5054284517254.jpg 1000 1000 82481 79615 product 86004 M 0 86004
0 5054284516967.jpg 1000 1000 82524 79658 product 86047 M 0 86047
0 5054284517032.jpg 1000 1000 82525 79659 product 86048 M 0 86048
0 5054284517032_kavp-lv.jpg 1000 1000 82526 79660 product 86049 M 0 86049
0 5054284528199.jpg 1000 1000 82579 79712 product 86102 M 0 86102