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 (
    88095, 88094, 88093, 88092, 88091, 88090, 
    88089, 88088, 88087, 88086, 88082, 
    88081, 87851, 87731, 87730, 87729, 
    87728, 88625, 88624, 88623, 88039, 
    88532, 88531, 88530, 88406, 88405, 
    88404, 88403, 88402, 88401, 87762, 
    87678, 88629, 88628, 88627, 88626, 
    88575, 88574, 88573, 88149
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00062

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 40 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 90449 87678 product 93972 M 0
0 90499 87728 product 94022 M 0
0 90500 87729 product 94023 M 0
0 90501 87730 product 94024 M 0
0 90502 87731 product 94025 M 0
0 90533 87762 product 94056 M 0
0 90622 87851 product 94145 M 0
0 90810 88039 product 94333 M 0
0 90852 88081 product 94375 M 0
0 90853 88082 product 94376 M 0
0 90857 88086 product 94380 M 0
0 90858 88087 product 94381 M 0
0 90859 88088 product 94382 M 0
0 90860 88089 product 94383 M 0
0 90861 88090 product 94384 M 0
0 90862 88091 product 94385 M 0
0 90863 88092 product 94386 M 0
0 90864 88093 product 94387 M 0
0 90865 88094 product 94388 M 0
0 90866 88095 product 94389 M 0
0 90919 88149 product 94442 M 0
0 91199 88401 product 94722 M 0
0 91200 88402 product 94723 M 0
0 91201 88403 product 94724 M 0
0 91202 88404 product 94725 M 0
0 91203 88405 product 94726 M 0
0 91204 88406 product 94727 M 0
0 91328 88530 product 94851 M 0
0 91329 88531 product 94852 M 0
0 91330 88532 product 94853 M 0
0 91372 88573 product 94895 M 0
0 91373 88574 product 94896 M 0
0 91374 88575 product 94897 M 0
0 91422 88623 product 94945 M 0
0 91423 88624 product 94946 M 0
0 91424 88625 product 94947 M 0
0 91425 88626 product 94948 M 0
0 91426 88627 product 94949 M 0
0 91427 88628 product 94950 M 0
0 91428 88629 product 94951 M 0