SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    617, 616, 625, 606, 622, 609, 603, 638, 
    608, 627, 620, 619, 601, 9480, 624, 605, 
    9476, 642, 604, 644, 602, 630, 632, 640, 
    629, 646, 635, 641, 631, 636
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00161

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 30 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_id 1 Using where
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 mahm3t_cs443.cscart_images.image_id,const,const 1 Using where

Result

pair_id object_id object_type image_id detailed_id type position emo_md5 image_path alt image_x image_y images_image_id
1653 609 product 0 1598 M 0 mdm_vaxo_00s_000.jpg Ecran de sous-toiture VAXO 331 225 1598
1658 601 product 0 1603 M 0 ventia_iron.png 800 800 1603
1659 602 product 0 1604 M 0 ventia_bronze.png 800 800 1604
1660 603 product 0 1605 M 0 ventia_gold.png 800 800 1605
1661 604 product 0 1606 M 0 ventia_cobalt_plus.png 800 800 1606
1662 605 product 0 1607 M 0 ventia_titanium.png 800 800 1607
1663 606 product 0 1608 M 0 Titanium_.JPG 400 473 1608
1665 608 product 0 1610 M 0 ventia_metal.jpg 600 600 1610
1666 616 product 0 1611 M 0 verso_top.jpg 800 800 1611
1667 617 product 0 1612 M 0 ventia_vb_reflex.png 800 800 1612
1668 622 product 0 1613 M 0 ventroll_00.png 800 800 1613
1670 619 product 0 1615 M 0 ventalrespiro_00.png 800 800 1615
1671 624 product 0 1616 M 0 wywietrznik_ze_szczotka.jpg 600 600 1616
1672 625 product 0 1617 M 0 wywietrznik_gont.jpg 600 600 1617
1673 620 product 0 1618 M 0 aluminiowa_00.png 800 800 1618
1682 627 product 0 1627 M 0 lawa.jpg 600 600 1627
1684 629 product 0 1629 M 0 Steigtritt_neu.png 367 359 1629
1685 630 product 0 1630 M 0 mocownik_laty.jpg 600 600 1630
1686 631 product 0 1631 M 0 wspornik_u.jpg 600 600 1631
1687 632 product 0 1632 M 0 wspornik_dbdc.jpg 600 600 1632
1690 635 product 0 1635 M 0 wspornik_przyscienny.jpg 600 600 1635
1691 636 product 0 1636 M 0 lacznik_lawy.jpg 600 600 1636
1693 638 product 0 1638 M 0 plotek_przeciwsniegowy.jpg 600 600 1638
1695 640 product 0 1640 M 0 lacznik_plotka_przeciwsniegowego.jpg 600 600 1640
1696 641 product 0 1641 M 0 uchwyt_plotka_u.jpg 600 600 1641
1697 642 product 0 1642 M 0 uchwyt_plotka_dbdc.jpg 600 600 1642
1699 644 product 0 1644 M 0 konsol_bd.PNG 293 204 1644
1701 646 product 0 1646 M 0 uchwyt_bala_dbdc.jpg 600 600 1646
12805 9476 product 0 8718 M 0 ventia_q.png 800 800 8718
12809 9480 product 0 8722 M 0 vaxo_vb_reflex_90.png 800 800 8722