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.image_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 (
    51830, 51829, 59337, 52214, 51828, 51816, 
    51812, 51811, 51786, 51785, 51813, 
    51802, 51801, 51800, 51799, 51798, 
    51797, 51796, 51795, 51794, 51793, 
    51792, 51791, 51790, 51789, 51788, 
    51753, 51752, 51751, 51750, 51782, 
    51735, 91670, 91669, 91668, 51653, 
    51646, 51638, 51637, 51636, 51635, 
    111382, 51609, 51605, 51587, 51581, 
    51580, 51666, 51665, 51664, 51663, 
    51662, 51557, 51555, 51534, 51533, 
    51532, 51531, 51530, 51529, 51520, 
    51437, 51694, 51430, 51425, 51338, 
    51337, 51319, 51768, 51418, 51287, 
    51198, 51127, 51126, 51098, 51097, 
    51096, 51095, 51094, 51093
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00077

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 80 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.image_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 52610 51093 product 56133 M 0
0 52611 51094 product 56134 M 0
0 52612 51095 product 56135 M 0
0 52613 51096 product 56136 M 0
0 52614 51097 product 56137 M 0
0 52615 51098 product 56138 M 0
0 52643 51126 product 56166 M 0
0 52644 51127 product 56167 M 0
0 52715 51198 product 56238 M 0
0 52804 51287 product 56327 M 0
0 52836 51319 product 56359 M 0
0 52854 51337 product 56377 M 0
0 52855 51338 product 56378 M 0
0 52948 51418 product 56471 M 0
0 52955 51425 product 56478 M 0
0 52960 51430 product 56483 M 0
0 52967 51437 product 56490 M 0
0 53050 51520 product 56573 M 0
0 53059 51529 product 56582 M 0
0 53060 51530 product 56583 M 0
0 53061 51531 product 56584 M 0
0 53062 51532 product 56585 M 0
0 53063 51533 product 56586 M 0
0 53064 51534 product 56587 M 0
0 53085 51555 product 56608 M 0
0 53087 51557 product 56610 M 0
0 53109 51580 product 56632 M 0
0 53110 51581 product 56633 M 0
0 53116 51587 product 56639 M 0
0 53135 51605 product 56658 M 0
0 53139 51609 product 56662 M 0
0 53165 51635 product 56688 M 0
0 53166 51636 product 56689 M 0
0 53167 51637 product 56690 M 0
0 53168 51638 product 56691 M 0
0 53176 51646 product 56699 M 0
0 53183 51653 product 56706 M 0
0 53192 51662 product 56715 M 0
0 53193 51663 product 56716 M 0
0 53194 51664 product 56717 M 0
0 53195 51665 product 56718 M 0
0 53196 51666 product 56719 M 0
0 53224 51694 product 56747 M 0
0 53265 51735 product 56788 M 0
0 53280 51750 product 56803 M 0
0 53281 51751 product 56804 M 0
0 53282 51752 product 56805 M 0
0 53283 51753 product 56806 M 0
0 53298 51768 product 56821 M 0
0 53312 51782 product 56835 M 0
0 53315 51785 product 56838 M 0
0 53316 51786 product 56839 M 0
0 53318 51788 product 56841 M 0
0 53319 51789 product 56842 M 0
0 53320 51790 product 56843 M 0
0 53321 51791 product 56844 M 0
0 53322 51792 product 56845 M 0
0 53323 51793 product 56846 M 0
0 53324 51794 product 56847 M 0
0 53325 51795 product 56848 M 0
0 53326 51796 product 56849 M 0
0 53327 51797 product 56850 M 0
0 53328 51798 product 56851 M 0
0 53329 51799 product 56852 M 0
0 53330 51800 product 56853 M 0
0 53331 51801 product 56854 M 0
0 53332 51802 product 56855 M 0
0 53341 51811 product 56864 M 0
0 53342 51812 product 56865 M 0
0 53343 51813 product 56866 M 0
0 53347 51816 product 56870 M 0
0 53359 51828 product 56882 M 0
0 53360 51829 product 56883 M 0
0 53361 51830 product 56884 M 0
0 53744 52214 product 57267 M 0
0 60868 59337 product 64391 M 0
0 94514 91668 product 98037 M 0
0 94515 91669 product 98038 M 0
0 94516 91670 product 98039 M 0
0 114549 111382 product 118072 M 0