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 (
    46924, 46923, 46922, 46873, 46872, 46871, 
    46870, 46869, 46868, 46867, 46866, 
    46865, 46864, 46863, 46862, 46861, 
    46860, 46859, 46858, 46857, 46624, 
    46568, 46567, 46565, 46822, 46821, 
    46820, 46819, 46901, 46900, 46899, 
    46898, 46897, 46896, 46895, 46894, 
    46893, 46892, 46891, 46890, 46889, 
    46888, 46887, 46886, 46885, 46884, 
    46883, 46882, 46881, 46880, 46879, 
    46878, 46877, 46621, 46620, 46619, 
    46618, 46617, 46616, 46615, 46614, 
    46613, 46535, 46534, 46533, 46532, 
    46519, 46477, 46472, 46471, 46437, 
    46702, 46701, 46700, 46699, 46348, 
    46329, 46580, 46579, 46358
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00094

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 47837 46329 product 51360 M 0
0 47856 46348 product 51379 M 0
0 47866 46358 product 51389 M 0
0 47945 46437 product 51468 M 0
0 47979 46471 product 51502 M 0
0 47980 46472 product 51503 M 0
0 47985 46477 product 51508 M 0
0 48027 46519 product 51550 M 0
0 48040 46532 product 51563 M 0
0 48041 46533 product 51564 M 0
0 48042 46534 product 51565 M 0
0 48043 46535 product 51566 M 0
0 48073 46565 product 51596 M 0
0 48075 46567 product 51598 M 0
0 48076 46568 product 51599 M 0
0 48087 46579 product 51610 M 0
0 48088 46580 product 51611 M 0
0 48121 46613 product 51644 M 0
0 48122 46614 product 51645 M 0
0 48123 46615 product 51646 M 0
0 48124 46616 product 51647 M 0
0 48125 46617 product 51648 M 0
0 48126 46618 product 51649 M 0
0 48127 46619 product 51650 M 0
0 48128 46620 product 51651 M 0
0 48129 46621 product 51652 M 0
0 48132 46624 product 51655 M 0
0 48206 46699 product 51729 M 0
0 48207 46700 product 51730 M 0
0 48208 46701 product 51731 M 0
0 48209 46702 product 51732 M 0
0 48326 46819 product 51849 M 0
0 48327 46820 product 51850 M 0
0 48328 46821 product 51851 M 0
0 48329 46822 product 51852 M 0
0 48364 46857 product 51887 M 0
0 48365 46858 product 51888 M 0
0 48366 46859 product 51889 M 0
0 48367 46860 product 51890 M 0
0 48368 46861 product 51891 M 0
0 48369 46862 product 51892 M 0
0 48370 46863 product 51893 M 0
0 48371 46864 product 51894 M 0
0 48372 46865 product 51895 M 0
0 48373 46866 product 51896 M 0
0 48374 46867 product 51897 M 0
0 48375 46868 product 51898 M 0
0 48376 46869 product 51899 M 0
0 48377 46870 product 51900 M 0
0 48378 46871 product 51901 M 0
0 48379 46872 product 51902 M 0
0 48380 46873 product 51903 M 0
0 48384 46877 product 51907 M 0
0 48385 46878 product 51908 M 0
0 48386 46879 product 51909 M 0
0 48387 46880 product 51910 M 0
0 48388 46881 product 51911 M 0
0 48389 46882 product 51912 M 0
0 48390 46883 product 51913 M 0
0 48391 46884 product 51914 M 0
0 48392 46885 product 51915 M 0
0 48393 46886 product 51916 M 0
0 48394 46887 product 51917 M 0
0 48395 46888 product 51918 M 0
0 48396 46889 product 51919 M 0
0 48397 46890 product 51920 M 0
0 48398 46891 product 51921 M 0
0 48399 46892 product 51922 M 0
0 48400 46893 product 51923 M 0
0 48401 46894 product 51924 M 0
0 48402 46895 product 51925 M 0
0 48403 46896 product 51926 M 0
0 48404 46897 product 51927 M 0
0 48405 46898 product 51928 M 0
0 48406 46899 product 51929 M 0
0 48407 46900 product 51930 M 0
0 48408 46901 product 51931 M 0
0 48429 46922 product 51952 M 0
0 48430 46923 product 51953 M 0
0 48431 46924 product 51954 M 0