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 (
    66793, 66792, 66791, 66790, 66789, 67007, 
    66714, 66711, 66706, 66704, 66697, 
    66696, 66692, 66725, 66721, 66312, 
    66282, 66281, 66662, 66619, 66618, 
    66617, 66616, 66615, 66614, 66613, 
    66612, 66611, 66610, 66609, 66608, 
    66526, 66206, 66205, 66204, 66203, 
    66202, 66201, 66200, 66199
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00082

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 5054283391176_15hf-hj.jpg 1000 1000 68460 66199 product 71983 M 0 71983
0 5054283391176_7r9u-hx.jpg 1000 1000 68461 66200 product 71984 M 0 71984
0 5054283391176_3ypo-fr.jpg 1000 1000 68462 66201 product 71985 M 0 71985
0 5054283391176_rg1x-zm.jpg 1000 1000 68463 66202 product 71986 M 0 71986
0 5054283391176_nkvx-90.jpg 1000 1000 68464 66203 product 71987 M 0 71987
0 5054283391176_1a6j-qn.jpg 1000 1000 68465 66204 product 71988 M 0 71988
0 5054283391176_2yeb-sv.jpg 1000 1000 68466 66205 product 71989 M 0 71989
0 5054283391176_9wuz-la.jpg 1000 1000 68467 66206 product 71990 M 0 71990
0 5054283497908.jpg 1000 1000 68542 66281 product 72065 M 0 72065
0 5054283497908_y53s-hj.jpg 1000 1000 68543 66282 product 72066 M 0 72066
0 5054283503937.jpg 1000 1000 68573 66312 product 72096 M 0 72096
0 5054283530490.jpg 1000 1000 68789 66526 product 72312 M 0 72312
0 5054283547399.jpg 1000 1000 68871 66608 product 72394 M 0 72394
0 5054283547399_agos-cm.jpg 1000 1000 68872 66609 product 72395 M 0 72395
0 5054283547399_lvgr-uc.jpg 1000 1000 68873 66610 product 72396 M 0 72396
0 5054283547399_hml7-m8.jpg 1000 1000 68874 66611 product 72397 M 0 72397
0 5054283547399_l0kn-3i.jpg 1000 1000 68875 66612 product 72398 M 0 72398
0 5054283547399_pglb-46.jpg 1000 1000 68876 66613 product 72399 M 0 72399
0 5054283547399_cfn0-8z.jpg 1000 1000 68877 66614 product 72400 M 0 72400
0 5054283547399_nuv3-lp.jpg 1000 1000 68878 66615 product 72401 M 0 72401
0 5054283547399_f2c1-9y.jpg 1000 1000 68879 66616 product 72402 M 0 72402
0 5054283547399_9vyu-j2.jpg 1000 1000 68880 66617 product 72403 M 0 72403
0 5054283547399_c9ix-kn.jpg 1000 1000 68881 66618 product 72404 M 0 72404
0 5054283547399_4w2r-xa.jpg 1000 1000 68882 66619 product 72405 M 0 72405
0 5054283550399.jpg 1000 1000 68925 66662 product 72448 M 0 72448
0 5054283548594.jpg 1000 1000 68955 66692 product 72478 M 0 72478
0 5054283548594_ebp4-bi.jpg 1000 1000 68959 66696 product 72482 M 0 72482
0 5054283548594_k3i2-0b.jpg 1000 1000 68960 66697 product 72483 M 0 72483
0 5054283548594_4awi-hj.jpg 1000 1000 68967 66704 product 72490 M 0 72490
0 5054283548594_eepx-jr.jpg 1000 1000 68969 66706 product 72492 M 0 72492
0 5054283548594_kh89-es.jpg 1000 1000 68974 66711 product 72497 M 0 72497
0 5054283548594_era8-vi.jpg 1000 1000 68977 66714 product 72500 M 0 72500
0 5054283552072.jpg 1000 1000 68984 66721 product 72507 M 0 72507
0 5054283552096.jpg 1000 1000 68988 66725 product 72511 M 0 72511
0 5054283550658.jpg 1000 1000 69053 66789 product 72576 M 0 72576
0 5054283550658_qhrw-od.jpg 1000 1000 69054 66790 product 72577 M 0 72577
0 5054283550658_w4nq-4v.jpg 1000 1000 69055 66791 product 72578 M 0 72578
0 5054283550658_8efm-1h.jpg 1000 1000 69056 66792 product 72579 M 0 72579
0 5054283550658_ps1k-st.jpg 1000 1000 69057 66793 product 72580 M 0 72580
0 5054283577167.jpg 1000 1000 69271 67007 product 72794 M 0 72794