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 (
    47596, 47595, 47594, 47593, 47592, 47591, 
    47590, 47589, 47588, 47690, 47805, 
    47804, 47803, 47802, 47801, 47800, 
    47799, 47798, 47797, 47796, 47795, 
    47794, 47793, 47792, 47791, 47790, 
    47789, 47788, 47787, 47786, 47785, 
    47784, 47783, 47782, 47781, 47562, 
    47561, 47707, 47706, 47705, 47704, 
    47703, 47702, 47701, 47700, 51279, 
    47691, 47688, 47686, 47685, 47684, 
    47683, 47646, 47548, 47745, 47644, 
    47489, 47485, 47484, 47640, 47478, 
    47636, 47473, 47641, 47451, 47381, 
    47358, 47627, 47615, 47614, 47613, 
    47612, 47611, 47610, 47609, 47608, 
    47607, 47606, 47487, 47477
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00127

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 48865 47358 product 52388 M 0
0 48888 47381 product 52411 M 0
0 48958 47451 product 52481 M 0
0 48980 47473 product 52503 M 0
0 48983 47477 product 52506 M 0
0 48984 47478 product 52507 M 0
0 48990 47484 product 52513 M 0
0 48991 47485 product 52514 M 0
0 48993 47487 product 52516 M 0
0 48996 47489 product 52519 M 0
0 49054 47548 product 52577 M 0
0 49067 47561 product 52590 M 0
0 49068 47562 product 52591 M 0
0 49094 47588 product 52617 M 0
0 49095 47589 product 52618 M 0
0 49096 47590 product 52619 M 0
0 49097 47591 product 52620 M 0
0 49098 47592 product 52621 M 0
0 49099 47593 product 52622 M 0
0 49100 47594 product 52623 M 0
0 49101 47595 product 52624 M 0
0 49102 47596 product 52625 M 0
0 49112 47606 product 52635 M 0
0 49113 47607 product 52636 M 0
0 49114 47608 product 52637 M 0
0 49115 47609 product 52638 M 0
0 49116 47610 product 52639 M 0
0 49117 47611 product 52640 M 0
0 49118 47612 product 52641 M 0
0 49119 47613 product 52642 M 0
0 49120 47614 product 52643 M 0
0 49121 47615 product 52644 M 0
0 49133 47627 product 52656 M 0
0 49142 47636 product 52665 M 0
0 49146 47640 product 52669 M 0
0 49147 47641 product 52670 M 0
0 49150 47644 product 52673 M 0
0 49152 47646 product 52675 M 0
0 49189 47683 product 52712 M 0
0 49190 47684 product 52713 M 0
0 49191 47685 product 52714 M 0
0 49192 47686 product 52715 M 0
0 49194 47688 product 52717 M 0
0 49196 47690 product 52719 M 0
0 49197 47691 product 52720 M 0
0 49206 47700 product 52729 M 0
0 49207 47701 product 52730 M 0
0 49208 47702 product 52731 M 0
0 49209 47703 product 52732 M 0
0 49210 47704 product 52733 M 0
0 49211 47705 product 52734 M 0
0 49212 47706 product 52735 M 0
0 49213 47707 product 52736 M 0
0 49251 47745 product 52774 M 0
0 49287 47781 product 52810 M 0
0 49288 47782 product 52811 M 0
0 49289 47783 product 52812 M 0
0 49290 47784 product 52813 M 0
0 49291 47785 product 52814 M 0
0 49292 47786 product 52815 M 0
0 49293 47787 product 52816 M 0
0 49294 47788 product 52817 M 0
0 49295 47789 product 52818 M 0
0 49296 47790 product 52819 M 0
0 49297 47791 product 52820 M 0
0 49298 47792 product 52821 M 0
0 49299 47793 product 52822 M 0
0 49300 47794 product 52823 M 0
0 49301 47795 product 52824 M 0
0 49302 47796 product 52825 M 0
0 49303 47797 product 52826 M 0
0 49304 47798 product 52827 M 0
0 49305 47799 product 52828 M 0
0 49306 47800 product 52829 M 0
0 49307 47801 product 52830 M 0
0 49308 47802 product 52831 M 0
0 49309 47803 product 52832 M 0
0 49310 47804 product 52833 M 0
0 49311 47805 product 52834 M 0
0 52796 51279 product 56319 M 0