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 (
    52244, 52243, 52242, 52241, 52240, 52239, 
    52238, 52237, 52236, 52268, 52576, 
    52163, 51992, 51991, 51988, 51990, 
    51989, 51933, 51932, 51931, 51930, 
    59344, 52572, 52571, 51899, 51892, 
    51891, 51888, 59349, 52575, 51879, 
    51878, 51877, 51876, 51875, 51874, 
    51873, 51872, 51871, 51870, 51869, 
    51868, 51867, 51866, 51865, 51864, 
    51863, 51862, 51861, 51860, 51859, 
    51858, 51857, 51856, 51855, 111374, 
    111373, 52569, 52568, 52567, 52566, 
    52565, 52564, 52563, 52562, 52561, 
    52560, 52559, 52558, 52557, 52556, 
    52555, 52554, 52553, 52552, 52551, 
    52550, 52549, 51834, 51831
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00109

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 53362 51831 product 56885 M 0
0 53365 51834 product 56888 M 0
0 53386 51855 product 56909 M 0
0 53387 51856 product 56910 M 0
0 53388 51857 product 56911 M 0
0 53389 51858 product 56912 M 0
0 53390 51859 product 56913 M 0
0 53391 51860 product 56914 M 0
0 53392 51861 product 56915 M 0
0 53393 51862 product 56916 M 0
0 53394 51863 product 56917 M 0
0 53395 51864 product 56918 M 0
0 53396 51865 product 56919 M 0
0 53397 51866 product 56920 M 0
0 53398 51867 product 56921 M 0
0 53399 51868 product 56922 M 0
0 53400 51869 product 56923 M 0
0 53401 51870 product 56924 M 0
0 53402 51871 product 56925 M 0
0 53403 51872 product 56926 M 0
0 53404 51873 product 56927 M 0
0 53405 51874 product 56928 M 0
0 53406 51875 product 56929 M 0
0 53407 51876 product 56930 M 0
0 53408 51877 product 56931 M 0
0 53409 51878 product 56932 M 0
0 53410 51879 product 56933 M 0
0 53419 51888 product 56942 M 0
0 53422 51891 product 56945 M 0
0 53423 51892 product 56946 M 0
0 53430 51899 product 56953 M 0
0 53461 51930 product 56984 M 0
0 53462 51931 product 56985 M 0
0 53463 51932 product 56986 M 0
0 53464 51933 product 56987 M 0
0 53519 51988 product 57042 M 0
0 53520 51989 product 57043 M 0
0 53521 51990 product 57044 M 0
0 53522 51991 product 57045 M 0
0 53523 51992 product 57046 M 0
0 53694 52163 product 57217 M 0
0 53766 52236 product 57289 M 0
0 53767 52237 product 57290 M 0
0 53768 52238 product 57291 M 0
0 53769 52239 product 57292 M 0
0 53770 52240 product 57293 M 0
0 53771 52241 product 57294 M 0
0 53772 52242 product 57295 M 0
0 53773 52243 product 57296 M 0
0 53774 52244 product 57297 M 0
0 53799 52268 product 57322 M 0
0 54080 52549 product 57603 M 0
0 54081 52550 product 57604 M 0
0 54082 52551 product 57605 M 0
0 54083 52552 product 57606 M 0
0 54084 52553 product 57607 M 0
0 54085 52554 product 57608 M 0
0 54086 52555 product 57609 M 0
0 54087 52556 product 57610 M 0
0 54088 52557 product 57611 M 0
0 54089 52558 product 57612 M 0
0 54090 52559 product 57613 M 0
0 54091 52560 product 57614 M 0
0 54092 52561 product 57615 M 0
0 54093 52562 product 57616 M 0
0 54094 52563 product 57617 M 0
0 54095 52564 product 57618 M 0
0 54096 52565 product 57619 M 0
0 54097 52566 product 57620 M 0
0 54098 52567 product 57621 M 0
0 54099 52568 product 57622 M 0
0 54100 52569 product 57623 M 0
0 54102 52571 product 57625 M 0
0 54103 52572 product 57626 M 0
0 54106 52575 product 57629 M 0
0 54107 52576 product 57630 M 0
0 60875 59344 product 64398 M 0
0 60880 59349 product 64403 M 0
0 114540 111373 product 118063 M 0
0 114541 111374 product 118064 M 0