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 (
    50522, 50521, 50520, 50519, 50518, 50517, 
    50516, 50515, 51281, 50485, 50484, 
    50462, 50461, 50103, 50447, 50408, 
    50465, 50464, 50463, 50393, 50389, 
    50388, 50387, 50072, 50267, 50234, 
    50233, 50232, 50231, 50230, 50229, 
    50228, 50227, 50226, 50225, 50224, 
    50223, 50067, 50066, 50065, 50064, 
    50275, 50274, 50269, 50265, 50039, 
    50001, 88490, 88489, 50040, 50034, 
    50033, 50025, 50152, 50151, 50124, 
    50123, 50122, 49944, 50110, 50107, 
    49954, 49953, 49952, 49951, 49950, 
    50219, 50218, 50217, 50216, 50215, 
    50214, 50213, 50212, 50211, 50210, 
    50209, 50208, 50207, 50206
  ) 
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 51444 49944 product 54967 M 0
0 51450 49950 product 54973 M 0
0 51451 49951 product 54974 M 0
0 51452 49952 product 54975 M 0
0 51453 49953 product 54976 M 0
0 51454 49954 product 54977 M 0
0 51502 50001 product 55025 M 0
0 51526 50025 product 55049 M 0
0 51534 50033 product 55057 M 0
0 51535 50034 product 55058 M 0
0 51540 50039 product 55063 M 0
0 51541 50040 product 55064 M 0
0 51565 50064 product 55088 M 0
0 51566 50065 product 55089 M 0
0 51567 50066 product 55090 M 0
0 51568 50067 product 55091 M 0
0 51573 50072 product 55096 M 0
0 51605 50103 product 55128 M 0
0 51609 50107 product 55132 M 0
0 51612 50110 product 55135 M 0
0 51624 50122 product 55147 M 0
0 51625 50123 product 55148 M 0
0 51626 50124 product 55149 M 0
0 51653 50151 product 55176 M 0
0 51654 50152 product 55177 M 0
0 51708 50206 product 55231 M 0
0 51709 50207 product 55232 M 0
0 51710 50208 product 55233 M 0
0 51711 50209 product 55234 M 0
0 51712 50210 product 55235 M 0
0 51713 50211 product 55236 M 0
0 51714 50212 product 55237 M 0
0 51715 50213 product 55238 M 0
0 51716 50214 product 55239 M 0
0 51717 50215 product 55240 M 0
0 51718 50216 product 55241 M 0
0 51719 50217 product 55242 M 0
0 51720 50218 product 55243 M 0
0 51721 50219 product 55244 M 0
0 51725 50223 product 55248 M 0
0 51726 50224 product 55249 M 0
0 51727 50225 product 55250 M 0
0 51728 50226 product 55251 M 0
0 51729 50227 product 55252 M 0
0 51730 50228 product 55253 M 0
0 51731 50229 product 55254 M 0
0 51732 50230 product 55255 M 0
0 51733 50231 product 55256 M 0
0 51734 50232 product 55257 M 0
0 51735 50233 product 55258 M 0
0 51736 50234 product 55259 M 0
0 51767 50265 product 55290 M 0
0 51769 50267 product 55292 M 0
0 51771 50269 product 55294 M 0
0 51776 50274 product 55299 M 0
0 51777 50275 product 55300 M 0
0 51890 50387 product 55413 M 0
0 51891 50388 product 55414 M 0
0 51892 50389 product 55415 M 0
0 51896 50393 product 55419 M 0
0 51908 50408 product 55431 M 0
0 51947 50447 product 55470 M 0
0 51961 50461 product 55484 M 0
0 51962 50462 product 55485 M 0
0 51963 50463 product 55486 M 0
0 51964 50464 product 55487 M 0
0 51965 50465 product 55488 M 0
0 51987 50484 product 55510 M 0
0 51988 50485 product 55511 M 0
0 52018 50515 product 55541 M 0
0 52019 50516 product 55542 M 0
0 52020 50517 product 55543 M 0
0 52021 50518 product 55544 M 0
0 52022 50519 product 55545 M 0
0 52023 50520 product 55546 M 0
0 52024 50521 product 55547 M 0
0 52025 50522 product 55548 M 0
0 52798 51281 product 56321 M 0
0 91287 88489 product 94810 M 0
0 91288 88490 product 94811 M 0