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 (
    52874, 52873, 52872, 52871, 52870, 52869, 
    52868, 52867, 52866, 52865, 52864, 
    52863, 52862, 52861, 52860, 52859, 
    52858, 52857, 52856, 52979, 52908, 
    52890, 52889, 52888, 52828, 52820, 
    52819, 53140, 53139, 52807, 52806, 
    52805, 52804, 53031, 53030, 52786, 
    52785, 52784, 53088, 52774, 52891, 
    52880, 52757, 52749, 52748, 52747, 
    52746, 52778, 52758, 52685, 52709, 
    52687, 52686, 52682, 52677, 52671, 
    52670, 52669, 52942, 52941, 52940, 
    52939, 52636, 52635, 52645, 52644, 
    52643, 52642, 52589, 52588, 52587, 
    52586, 52585, 59345, 52633, 52632, 
    52578, 52542, 52524, 52707
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00093

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 54055 52524 product 57578 M 0
0 54073 52542 product 57596 M 0
0 54109 52578 product 57632 M 0
0 54116 52585 product 57639 M 0
0 54117 52586 product 57640 M 0
0 54118 52587 product 57641 M 0
0 54119 52588 product 57642 M 0
0 54120 52589 product 57643 M 0
0 54163 52632 product 57686 M 0
0 54164 52633 product 57687 M 0
0 54166 52635 product 57689 M 0
0 54167 52636 product 57690 M 0
0 54173 52642 product 57696 M 0
0 54174 52643 product 57697 M 0
0 54175 52644 product 57698 M 0
0 54176 52645 product 57699 M 0
0 54200 52669 product 57723 M 0
0 54201 52670 product 57724 M 0
0 54202 52671 product 57725 M 0
0 54208 52677 product 57731 M 0
0 54213 52682 product 57736 M 0
0 54216 52685 product 57739 M 0
0 54217 52686 product 57740 M 0
0 54218 52687 product 57741 M 0
0 54238 52707 product 57761 M 0
0 54240 52709 product 57763 M 0
0 54277 52746 product 57800 M 0
0 54278 52747 product 57801 M 0
0 54279 52748 product 57802 M 0
0 54280 52749 product 57803 M 0
0 54288 52757 product 57811 M 0
0 54289 52758 product 57812 M 0
0 54304 52774 product 57827 M 0
0 54308 52778 product 57831 M 0
0 54314 52784 product 57837 M 0
0 54315 52785 product 57838 M 0
0 54316 52786 product 57839 M 0
0 54334 52804 product 57857 M 0
0 54335 52805 product 57858 M 0
0 54336 52806 product 57859 M 0
0 54337 52807 product 57860 M 0
0 54350 52819 product 57873 M 0
0 54351 52820 product 57874 M 0
0 54359 52828 product 57882 M 0
0 54388 52856 product 57911 M 0
0 54389 52857 product 57912 M 0
0 54390 52858 product 57913 M 0
0 54391 52859 product 57914 M 0
0 54392 52860 product 57915 M 0
0 54393 52861 product 57916 M 0
0 54394 52862 product 57917 M 0
0 54395 52863 product 57918 M 0
0 54396 52864 product 57919 M 0
0 54397 52865 product 57920 M 0
0 54398 52866 product 57921 M 0
0 54399 52867 product 57922 M 0
0 54400 52868 product 57923 M 0
0 54401 52869 product 57924 M 0
0 54402 52870 product 57925 M 0
0 54403 52871 product 57926 M 0
0 54404 52872 product 57927 M 0
0 54405 52873 product 57928 M 0
0 54406 52874 product 57929 M 0
0 54413 52880 product 57936 M 0
0 54421 52888 product 57944 M 0
0 54422 52889 product 57945 M 0
0 54423 52890 product 57946 M 0
0 54424 52891 product 57947 M 0
0 54441 52908 product 57964 M 0
0 54476 52939 product 57999 M 0
0 54477 52940 product 58000 M 0
0 54478 52941 product 58001 M 0
0 54479 52942 product 58002 M 0
0 54516 52979 product 58039 M 0
0 54567 53030 product 58090 M 0
0 54568 53031 product 58091 M 0
0 54625 53088 product 58148 M 0
0 54676 53139 product 58199 M 0
0 54677 53140 product 58200 M 0
0 60876 59345 product 64399 M 0