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 (
    42487, 42577, 42576, 42575, 42574, 42573, 
    42572, 42478, 42787, 42817, 42638, 
    42589, 42493, 42492, 42491, 42630, 
    42629, 42518, 42568, 42422
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00055

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 5054281670990.jpg 1000 1000 43932 42422 product 47455 M 0 47455
0 5054281670372.jpg 1000 1000 43988 42478 product 47511 M 0 47511
0 5054281660847.jpg 1000 1000 43997 42487 product 47520 M 0 47520
0 5054281673793.jpg 1000 1000 44001 42491 product 47524 M 0 47524
0 5054281673793_zh8a-9m.jpg 1000 1000 44002 42492 product 47525 M 0 47525
0 5054281673793_ns8o-me.jpg 1000 1000 44003 42493 product 47526 M 0 47526
0 5054281678347.jpg 1000 1000 44028 42518 product 47551 M 0 47551
0 5054281689145.jpg 1000 1000 44078 42568 product 47601 M 0 47601
0 5054281689190.jpg 1000 1000 44082 42572 product 47605 M 0 47605
0 5054281689190_ulgt-xz.jpg 1000 1000 44083 42573 product 47606 M 0 47606
0 5054281689190_l3a9-nl.jpg 1000 1000 44084 42574 product 47607 M 0 47607
0 5054281689190_txbz-k1.jpg 1000 1000 44085 42575 product 47608 M 0 47608
0 5054281689190_o9pc-82.jpg 1000 1000 44086 42576 product 47609 M 0 47609
0 5054281689190_tl7n-jj.jpg 1000 1000 44087 42577 product 47610 M 0 47610
0 5054281687615.jpg 1000 1000 44099 42589 product 47622 M 0 47622
0 5054281694620.jpg 1000 1000 44139 42629 product 47662 M 0 47662
0 5054281694620_2nzb-he.jpg 1000 1000 44140 42630 product 47663 M 0 47663
0 5054281697379.jpg 1000 1000 44148 42638 product 47671 M 0 47671
0 5054281702189.jpg 1000 1000 44297 42787 product 47820 M 0 47820
0 5054281702257.jpg 1000 1000 44327 42817 product 47850 M 0 47850