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 (
    49614, 49613, 49612, 49611, 49610, 49609, 
    49608, 49607, 49606, 49605, 49604, 
    49603, 49602, 49601, 49556, 49906, 
    49561, 49552, 49551, 49500, 49330, 
    49329, 49499, 49498, 50076, 49497, 
    49459, 49435, 49291, 49290, 49726, 
    49450, 49454, 49453, 49238, 49237, 
    49236, 49407, 49281, 49243, 49242, 
    49241, 49224, 49223, 49348, 49347, 
    49346, 49207, 49190, 49189, 49188, 
    49183, 49182, 49181, 49180, 49179, 
    49178, 49177, 49176, 49175, 49174, 
    49173, 49172, 49171, 49170, 49169, 
    49343, 49304, 49303, 49302, 49282, 
    49165, 49141, 49140, 49139, 49138, 
    49153, 49152, 49151, 49150
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00128

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 50641 49138 product 54164 M 0
0 50642 49139 product 54165 M 0
0 50643 49140 product 54166 M 0
0 50644 49141 product 54167 M 0
0 50653 49150 product 54176 M 0
0 50654 49151 product 54177 M 0
0 50655 49152 product 54178 M 0
0 50656 49153 product 54179 M 0
0 50668 49165 product 54191 M 0
0 50672 49169 product 54195 M 0
0 50673 49170 product 54196 M 0
0 50674 49171 product 54197 M 0
0 50675 49172 product 54198 M 0
0 50676 49173 product 54199 M 0
0 50677 49174 product 54200 M 0
0 50678 49175 product 54201 M 0
0 50679 49176 product 54202 M 0
0 50680 49177 product 54203 M 0
0 50681 49178 product 54204 M 0
0 50682 49179 product 54205 M 0
0 50683 49180 product 54206 M 0
0 50684 49181 product 54207 M 0
0 50685 49182 product 54208 M 0
0 50686 49183 product 54209 M 0
0 50691 49188 product 54214 M 0
0 50692 49189 product 54215 M 0
0 50693 49190 product 54216 M 0
0 50710 49207 product 54233 M 0
0 50726 49223 product 54249 M 0
0 50727 49224 product 54250 M 0
0 50739 49236 product 54262 M 0
0 50740 49237 product 54263 M 0
0 50741 49238 product 54264 M 0
0 50744 49241 product 54267 M 0
0 50745 49242 product 54268 M 0
0 50746 49243 product 54269 M 0
0 50784 49281 product 54307 M 0
0 50785 49282 product 54308 M 0
0 50793 49290 product 54316 M 0
0 50794 49291 product 54317 M 0
0 50805 49302 product 54328 M 0
0 50806 49303 product 54329 M 0
0 50807 49304 product 54330 M 0
0 50832 49329 product 54355 M 0
0 50833 49330 product 54356 M 0
0 50848 49343 product 54371 M 0
0 50851 49346 product 54374 M 0
0 50852 49347 product 54375 M 0
0 50853 49348 product 54376 M 0
0 50912 49407 product 54435 M 0
0 50940 49435 product 54463 M 0
0 50955 49450 product 54478 M 0
0 50958 49453 product 54481 M 0
0 50959 49454 product 54482 M 0
0 50964 49459 product 54487 M 0
0 51003 49497 product 54526 M 0
0 51004 49498 product 54527 M 0
0 51005 49499 product 54528 M 0
0 51006 49500 product 54529 M 0
0 51051 49551 product 54574 M 0
0 51052 49552 product 54575 M 0
0 51056 49556 product 54579 M 0
0 51061 49561 product 54584 M 0
0 51101 49601 product 54624 M 0
0 51102 49602 product 54625 M 0
0 51103 49603 product 54626 M 0
0 51104 49604 product 54627 M 0
0 51105 49605 product 54628 M 0
0 51106 49606 product 54629 M 0
0 51107 49607 product 54630 M 0
0 51108 49608 product 54631 M 0
0 51109 49609 product 54632 M 0
0 51110 49610 product 54633 M 0
0 51111 49611 product 54634 M 0
0 51112 49612 product 54635 M 0
0 51113 49613 product 54636 M 0
0 51114 49614 product 54637 M 0
0 51226 49726 product 54749 M 0
0 51406 49906 product 54929 M 0
0 51577 50076 product 55100 M 0