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 (
    48473, 48713, 48706, 48297, 48920, 48671, 
    48670, 48302, 48276, 48275, 48238, 
    48270, 48271, 48266, 48265, 48264, 
    48263, 48246, 48277, 48247, 48259, 
    48258, 48257, 48256, 48255, 48248, 
    48237, 48236, 48233, 48201, 48103, 
    48102, 48267, 48047, 48192, 48120, 
    48101, 48100, 48099, 48097, 47985, 
    47984, 48078, 48046, 48410, 48409, 
    48408, 48407, 48406, 48405, 48404, 
    48403, 48402, 48401, 48400, 48399, 
    48398, 48397, 48396, 48395, 48394, 
    48393, 48392, 48391, 48390, 48389, 
    48388, 48387, 48386, 48385, 48384, 
    48383, 48382, 48381, 48380, 48379, 
    48378, 48377, 48376, 48375
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00110

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 49491 47984 product 53014 M 0
0 49492 47985 product 53015 M 0
0 49552 48046 product 53075 M 0
0 49553 48047 product 53076 M 0
0 49584 48078 product 53107 M 0
0 49603 48097 product 53126 M 0
0 49605 48099 product 53128 M 0
0 49606 48100 product 53129 M 0
0 49607 48101 product 53130 M 0
0 49608 48102 product 53131 M 0
0 49609 48103 product 53132 M 0
0 49626 48120 product 53149 M 0
0 49698 48192 product 53221 M 0
0 49707 48201 product 53230 M 0
0 49739 48233 product 53262 M 0
0 49742 48236 product 53265 M 0
0 49743 48237 product 53266 M 0
0 49744 48238 product 53267 M 0
0 49752 48246 product 53275 M 0
0 49753 48247 product 53276 M 0
0 49754 48248 product 53277 M 0
0 49761 48255 product 53284 M 0
0 49762 48256 product 53285 M 0
0 49763 48257 product 53286 M 0
0 49764 48258 product 53287 M 0
0 49765 48259 product 53288 M 0
0 49769 48263 product 53292 M 0
0 49770 48264 product 53293 M 0
0 49771 48265 product 53294 M 0
0 49772 48266 product 53295 M 0
0 49773 48267 product 53296 M 0
0 49776 48270 product 53299 M 0
0 49777 48271 product 53300 M 0
0 49781 48275 product 53304 M 0
0 49782 48276 product 53305 M 0
0 49783 48277 product 53306 M 0
0 49803 48297 product 53326 M 0
0 49808 48302 product 53331 M 0
0 49881 48375 product 53404 M 0
0 49882 48376 product 53405 M 0
0 49883 48377 product 53406 M 0
0 49884 48378 product 53407 M 0
0 49885 48379 product 53408 M 0
0 49886 48380 product 53409 M 0
0 49887 48381 product 53410 M 0
0 49888 48382 product 53411 M 0
0 49889 48383 product 53412 M 0
0 49890 48384 product 53413 M 0
0 49891 48385 product 53414 M 0
0 49892 48386 product 53415 M 0
0 49893 48387 product 53416 M 0
0 49894 48388 product 53417 M 0
0 49895 48389 product 53418 M 0
0 49896 48390 product 53419 M 0
0 49897 48391 product 53420 M 0
0 49898 48392 product 53421 M 0
0 49899 48393 product 53422 M 0
0 49900 48394 product 53423 M 0
0 49901 48395 product 53424 M 0
0 49902 48396 product 53425 M 0
0 49903 48397 product 53426 M 0
0 49904 48398 product 53427 M 0
0 49905 48399 product 53428 M 0
0 49906 48400 product 53429 M 0
0 49907 48401 product 53430 M 0
0 49908 48402 product 53431 M 0
0 49909 48403 product 53432 M 0
0 49910 48404 product 53433 M 0
0 49911 48405 product 53434 M 0
0 49912 48406 product 53435 M 0
0 49913 48407 product 53436 M 0
0 49914 48408 product 53437 M 0
0 49915 48409 product 53438 M 0
0 49916 48410 product 53439 M 0
0 49979 48473 product 53502 M 0
0 50174 48670 product 53697 M 0
0 50175 48671 product 53698 M 0
0 50210 48706 product 53733 M 0
0 50217 48713 product 53740 M 0
0 50424 48920 product 53947 M 0