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 (
    69285, 69284, 69283, 69282, 69281, 69280, 
    69279, 69278, 69277, 69276, 69275, 
    69274, 69273, 69272, 69271, 69270, 
    69269, 69268, 69267, 69266, 69265, 
    69264, 69263, 69262, 69261, 69260, 
    69259, 69258, 69128, 68673, 68672, 
    68671, 68670, 68669, 68668, 69121, 
    68664, 68460, 68380, 68611
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00108

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 5054283576290_uf80-c3.jpg 1000 1000 70650 68380 product 74173 M 0 74173
0 5054283696608.jpg 1000 1000 70730 68460 product 74253 M 0 74253
0 5054283713756.jpg 1000 1000 70881 68611 product 74404 M 0 74404
0 5054283715309.jpg 1000 1000 70934 68664 product 74457 M 0 74457
0 5054283684070.jpg 1000 1000 70938 68668 product 74461 M 0 74461
0 5054283684070_mzi7-76.jpg 1000 1000 70939 68669 product 74462 M 0 74462
0 5054283684070_kqa3-xl.jpg 1000 1000 70940 68670 product 74463 M 0 74463
0 5054283684070_kxfz-41.jpg 1000 1000 70941 68671 product 74464 M 0 74464
0 5054283684070_9e3g-3f.jpg 1000 1000 70942 68672 product 74465 M 0 74465
0 5054283684070_j94l-3m.jpg 1000 1000 70943 68673 product 74466 M 0 74466
0 5054283748499.jpg 1000 1000 71392 69121 product 74915 M 0 74915
0 5054283755121.jpg 1000 1000 71399 69128 product 74922 M 0 74922
0 5054283768220.jpg 1000 1000 71530 69258 product 75053 M 0 75053
0 5054283768220_xcvz-3r.jpg 1000 1000 71531 69259 product 75054 M 0 75054
0 5054283768220_lh3u-rs.jpg 1000 1000 71532 69260 product 75055 M 0 75055
0 5054283768220_g432-wl.jpg 1000 1000 71533 69261 product 75056 M 0 75056
0 5054283768220_ak86-k0.jpg 1000 1000 71534 69262 product 75057 M 0 75057
0 5054283768220_wnii-t6.jpg 1000 1000 71535 69263 product 75058 M 0 75058
0 5054283768220_arj5-qm.jpg 1000 1000 71536 69264 product 75059 M 0 75059
0 5054283768220_xc41-6v.jpg 1000 1000 71537 69265 product 75060 M 0 75060
0 5054283768220_tm0w-pw.jpg 1000 1000 71538 69266 product 75061 M 0 75061
0 5054283768220_h0hq-62.jpg 1000 1000 71539 69267 product 75062 M 0 75062
0 5054283768220_r2pa-lj.jpg 1000 1000 71540 69268 product 75063 M 0 75063
0 5054283768220_gwa0-10.jpg 1000 1000 71541 69269 product 75064 M 0 75064
0 5054283768220_nzcr-0j.jpg 1000 1000 71542 69270 product 75065 M 0 75065
0 5054283768220_nt6n-pv.jpg 1000 1000 71543 69271 product 75066 M 0 75066
0 5054283768220_k7v2-y2.jpg 1000 1000 71544 69272 product 75067 M 0 75067
0 5054283768220_4p5u-zr.jpg 1000 1000 71545 69273 product 75068 M 0 75068
0 5054283768220_dgnn-go.jpg 1000 1000 71546 69274 product 75069 M 0 75069
0 5054283768220_o3o1-uo.jpg 1000 1000 71547 69275 product 75070 M 0 75070
0 5054283768220_kihr-57.jpg 1000 1000 71548 69276 product 75071 M 0 75071
0 5054283768220_mpfi-sd.jpg 1000 1000 71549 69277 product 75072 M 0 75072
0 5054283768220_lw3q-q2.jpg 1000 1000 71550 69278 product 75073 M 0 75073
0 5054283768220_h3j4-rz.jpg 1000 1000 71551 69279 product 75074 M 0 75074
0 5054283768220_tf3h-gy.jpg 1000 1000 71552 69280 product 75075 M 0 75075
0 5054283768220_51gn-sm.jpg 1000 1000 71553 69281 product 75076 M 0 75076
0 5054283768220_vfca-y4.jpg 1000 1000 71554 69282 product 75077 M 0 75077
0 5054283768220_oj0r-9r.jpg 1000 1000 71555 69283 product 75078 M 0 75078
0 5054283768220_urud-vl.jpg 1000 1000 71556 69284 product 75079 M 0 75079
0 5054283768220_dp1g-6i.jpg 1000 1000 71557 69285 product 75080 M 0 75080