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 (
    47488, 47234, 47232, 51280, 47452, 47248, 
    47058, 51278, 47051, 47046, 47045, 
    47044, 47043, 47042, 47041, 47040, 
    47039, 47038, 47037, 47036, 47035, 
    47034, 47235, 47115, 47113, 47112, 
    47111, 47110, 47109, 47108, 47107, 
    47106, 47105, 47104, 47103, 47102, 
    47101, 46931, 46946, 46945, 46944, 
    47214, 47213, 47212, 47211, 47210, 
    47209, 47208, 47207, 47206, 47205, 
    47204, 47203, 47202, 47201, 47200, 
    47199, 47196, 46936, 46876, 46875, 
    46918, 46785, 46746, 46943, 46942, 
    46941, 46940, 46910, 46703, 47010, 
    47009, 47008, 46935, 46929, 46928, 
    46927, 46926, 46688, 46925
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00107

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 48196 46688 product 51719 M 0
0 48210 46703 product 51733 M 0
0 48253 46746 product 51776 M 0
0 48292 46785 product 51815 M 0
0 48382 46875 product 51905 M 0
0 48383 46876 product 51906 M 0
0 48417 46910 product 51940 M 0
0 48425 46918 product 51948 M 0
0 48432 46925 product 51955 M 0
0 48433 46926 product 51956 M 0
0 48434 46927 product 51957 M 0
0 48435 46928 product 51958 M 0
0 48436 46929 product 51959 M 0
0 48438 46931 product 51961 M 0
0 48442 46935 product 51965 M 0
0 48443 46936 product 51966 M 0
0 48447 46940 product 51970 M 0
0 48448 46941 product 51971 M 0
0 48449 46942 product 51972 M 0
0 48450 46943 product 51973 M 0
0 48451 46944 product 51974 M 0
0 48452 46945 product 51975 M 0
0 48453 46946 product 51976 M 0
0 48515 47008 product 52038 M 0
0 48516 47009 product 52039 M 0
0 48517 47010 product 52040 M 0
0 48541 47034 product 52064 M 0
0 48542 47035 product 52065 M 0
0 48543 47036 product 52066 M 0
0 48544 47037 product 52067 M 0
0 48545 47038 product 52068 M 0
0 48546 47039 product 52069 M 0
0 48547 47040 product 52070 M 0
0 48548 47041 product 52071 M 0
0 48549 47042 product 52072 M 0
0 48550 47043 product 52073 M 0
0 48551 47044 product 52074 M 0
0 48552 47045 product 52075 M 0
0 48553 47046 product 52076 M 0
0 48558 47051 product 52081 M 0
0 48565 47058 product 52088 M 0
0 48608 47101 product 52131 M 0
0 48609 47102 product 52132 M 0
0 48610 47103 product 52133 M 0
0 48611 47104 product 52134 M 0
0 48612 47105 product 52135 M 0
0 48613 47106 product 52136 M 0
0 48614 47107 product 52137 M 0
0 48615 47108 product 52138 M 0
0 48616 47109 product 52139 M 0
0 48617 47110 product 52140 M 0
0 48618 47111 product 52141 M 0
0 48619 47112 product 52142 M 0
0 48620 47113 product 52143 M 0
0 48622 47115 product 52145 M 0
0 48703 47196 product 52226 M 0
0 48706 47199 product 52229 M 0
0 48707 47200 product 52230 M 0
0 48708 47201 product 52231 M 0
0 48709 47202 product 52232 M 0
0 48710 47203 product 52233 M 0
0 48711 47204 product 52234 M 0
0 48712 47205 product 52235 M 0
0 48713 47206 product 52236 M 0
0 48714 47207 product 52237 M 0
0 48715 47208 product 52238 M 0
0 48716 47209 product 52239 M 0
0 48717 47210 product 52240 M 0
0 48718 47211 product 52241 M 0
0 48719 47212 product 52242 M 0
0 48720 47213 product 52243 M 0
0 48721 47214 product 52244 M 0
0 48739 47232 product 52262 M 0
0 48741 47234 product 52264 M 0
0 48742 47235 product 52265 M 0
0 48755 47248 product 52278 M 0
0 48959 47452 product 52482 M 0
0 48995 47488 product 52518 M 0
0 52795 51278 product 56318 M 0
0 52797 51280 product 56320 M 0