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 (
    73214, 73213, 73212, 73211, 73210, 73209, 
    73208, 73207, 73206, 73205, 73204, 
    73203, 73202, 73201, 73200, 73199, 
    73198, 73197, 73196, 73195, 73623, 
    73622, 73621, 73620, 73619, 73618, 
    73617, 73616, 73615, 73614, 73613, 
    73612, 73509, 73285, 73241, 73408, 
    73402, 73401, 73337, 73336
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00069

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 5054283770667.jpg 1000 1000 76007 73195 product 79530 M 0 79530
0 5054283770667_22my-ai.jpg 1000 1000 76008 73196 product 79531 M 0 79531
0 5054283770667_19z4-py.jpg 1000 1000 76009 73197 product 79532 M 0 79532
0 5054283770667_at54-42.jpg 1000 1000 76010 73198 product 79533 M 0 79533
0 5054283770667_vl0f-x6.jpg 1000 1000 76011 73199 product 79534 M 0 79534
0 5054283770667_87zq-j1.jpg 1000 1000 76012 73200 product 79535 M 0 79535
0 5054283770667_5m4s-ke.jpg 1000 1000 76013 73201 product 79536 M 0 79536
0 5054283770667_amoa-rd.jpg 1000 1000 76014 73202 product 79537 M 0 79537
0 5054283770667_817d-5c.jpg 1000 1000 76015 73203 product 79538 M 0 79538
0 5054283770667_g1yg-hv.jpg 1000 1000 76016 73204 product 79539 M 0 79539
0 5054283770667_np3n-fm.jpg 1000 1000 76017 73205 product 79540 M 0 79540
0 5054283770667_ol9s-dt.jpg 1000 1000 76018 73206 product 79541 M 0 79541
0 5054283770667_7ogv-y7.jpg 1000 1000 76019 73207 product 79542 M 0 79542
0 5054283770667_979g-kf.jpg 1000 1000 76020 73208 product 79543 M 0 79543
0 5054283770667_s0gq-hx.jpg 1000 1000 76021 73209 product 79544 M 0 79544
0 5054283770667_m5np-s2.jpg 1000 1000 76022 73210 product 79545 M 0 79545
0 5054283770667_cgnl-91.jpg 1000 1000 76023 73211 product 79546 M 0 79546
0 5054283770667_ehpv-do.jpg 1000 1000 76024 73212 product 79547 M 0 79547
0 5054283770667_2mvb-3f.jpg 1000 1000 76025 73213 product 79548 M 0 79548
0 5054283770667_qvg7-my.jpg 1000 1000 76026 73214 product 79549 M 0 79549
0 Fireball_cover-1.jpg 2363 2363 76053 73241 product 79576 M 0 79576
0 GSR.jpg 800 800 76097 73285 product 79620 M 0 79620
0 Breathe-Artwork_1400x1400_.png 1400 1400 76148 73336 product 79671 M 0 79671
0 Fireball_Recordings_305.jpg 1400 1400 76149 73337 product 79672 M 0 79672
0 UNBND0013-1600x1600.jpg 1600 1600 76213 73401 product 79736 M 0 79736
0 FR067_-_Toffidge_-_Zig_Zag.jpg 2000 2000 76214 73402 product 79737 M 0 79737
0 JAM030_Hard_Jeli_-_D.N.A.jpg 1400 1400 76220 73408 product 79743 M 0 79743
0 FR068_-_Damaged_Gudz_-_Tosser__Random_But_Raw_Remix_.jpg 2000 2000 76321 73509 product 79844 M 0 79844
0 best-of-TB.jpg 1400 1400 76425 73612 product 79948 M 0 79948
0 best-of-TB_mu3s-w2.jpg 1400 1400 76426 73613 product 79949 M 0 79949
0 best-of-TB_kw0d-my.jpg 1400 1400 76427 73614 product 79950 M 0 79950
0 best-of-TB_74nv-pw.jpg 1400 1400 76428 73615 product 79951 M 0 79951
0 best-of-TB_kbjc-gw.jpg 1400 1400 76429 73616 product 79952 M 0 79952
0 best-of-TB_rcm1-o8.jpg 1400 1400 76430 73617 product 79953 M 0 79953
0 best-of-TB_kb3n-4z.jpg 1400 1400 76431 73618 product 79954 M 0 79954
0 best-of-TB_qovq-1h.jpg 1400 1400 76432 73619 product 79955 M 0 79955
0 best-of-TB_o8mc-4c.jpg 1400 1400 76433 73620 product 79956 M 0 79956
0 best-of-TB_8oos-14.jpg 1400 1400 76434 73621 product 79957 M 0 79957
0 best-of-TB_oshb-u5.jpg 1400 1400 76435 73622 product 79958 M 0 79958
0 best-of-TB_jegm-2l.jpg 1400 1400 76436 73623 product 79959 M 0 79959