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.detailed_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.00081

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.detailed_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 5054285170021.jpg 1000 1000 90449 87678 product 93972 M 0 93972
0 5054285261361.jpg 1000 1000 90499 87728 product 94022 M 0 94022
0 5054285261361_sico-ol.jpg 1000 1000 90500 87729 product 94023 M 0 94023
0 5054285261361_hl67-6x.jpg 1000 1000 90501 87730 product 94024 M 0 94024
0 5054285261361_t9sl-sd.jpg 1000 1000 90502 87731 product 94025 M 0 94025
0 5054285170045.jpg 1000 1000 90533 87762 product 94056 M 0 94056
0 5054285170090.jpg 1000 1000 90622 87851 product 94145 M 0 94145
0 5054285166017_gsvz-qz.jpg 1000 1000 90810 88039 product 94333 M 0 94333
0 5054285194911.jpg 1000 1000 90852 88081 product 94375 M 0 94375
0 5054285194911_jq0l-fb.jpg 1000 1000 90853 88082 product 94376 M 0 94376
0 5054285128589.jpg 1000 1000 90857 88086 product 94380 M 0 94380
0 5054285128589_4ukf-ci.jpg 1000 1000 90858 88087 product 94381 M 0 94381
0 5054285128589_my42-4m.jpg 1000 1000 90859 88088 product 94382 M 0 94382
0 5054285128589_hjny-y9.jpg 1000 1000 90860 88089 product 94383 M 0 94383
0 5054285128589_u3pv-0m.jpg 1000 1000 90861 88090 product 94384 M 0 94384
0 5054285128589_4b36-5e.jpg 1000 1000 90862 88091 product 94385 M 0 94385
0 5054285128589_45xt-rc.jpg 1000 1000 90863 88092 product 94386 M 0 94386
0 5054285128589_jk7q-q0.jpg 1000 1000 90864 88093 product 94387 M 0 94387
0 5054285128589_56ch-ht.jpg 1000 1000 90865 88094 product 94388 M 0 94388
0 5054285128589_ucrl-y9.jpg 1000 1000 90866 88095 product 94389 M 0 94389
0 5054285254424_3xjn-u6.jpg 1000 1000 90919 88149 product 94442 M 0 94442
0 5054285319925.jpg 1000 1000 91199 88401 product 94722 M 0 94722
0 5054285319925_vx7z-4p.jpg 1000 1000 91200 88402 product 94723 M 0 94723
0 5054285319918.jpg 1000 1000 91201 88403 product 94724 M 0 94724
0 5054285319918_tliy-ff.jpg 1000 1000 91202 88404 product 94725 M 0 94725
0 5054285319918_qfei-4w.jpg 1000 1000 91203 88405 product 94726 M 0 94726
0 5054285319918_oeb8-40.jpg 1000 1000 91204 88406 product 94727 M 0 94727
0 5054285318713.jpg 1000 1000 91328 88530 product 94851 M 0 94851
0 5054285318713_o27o-0t.jpg 1000 1000 91329 88531 product 94852 M 0 94852
0 5054285318713_b2m0-1e.jpg 1000 1000 91330 88532 product 94853 M 0 94853
0 5054285304785.jpg 1000 1000 91372 88573 product 94895 M 0 94895
0 5054285304785_pgdt-ql.jpg 1000 1000 91373 88574 product 94896 M 0 94896
0 5054285304785_m9gz-h7.jpg 1000 1000 91374 88575 product 94897 M 0 94897
0 5028386715634.jpg 1000 1000 91422 88623 product 94945 M 0 94945
0 5028386715634_bhg8-pv.jpg 1000 1000 91423 88624 product 94946 M 0 94946
0 5028386715634_bbw3-sf.jpg 1000 1000 91424 88625 product 94947 M 0 94947
0 5054285289785.jpg 1000 1000 91425 88626 product 94948 M 0 94948
0 5054285289785_fa34-e1.jpg 1000 1000 91426 88627 product 94949 M 0 94949
0 5054285289785_idx1-mh.jpg 1000 1000 91427 88628 product 94950 M 0 94950
0 5054285289785_yjid-kq.jpg 1000 1000 91428 88629 product 94951 M 0 94951