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 (
    69618, 69616, 69615, 69459, 69449, 69401, 
    69350, 69507, 69506, 69505, 69503, 
    69447, 69410, 68998, 68698, 67810, 
    67809, 67808, 67807, 67806, 67805, 
    67804, 67803, 67802, 67801, 67800, 
    67799, 67798, 67797, 67796, 67795, 
    67794, 67793, 67792, 67791, 69107, 
    69432, 69348, 69005, 68836
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00100

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 VC_Hard_House_Anthems_Vol.8.jpg 1400 1400 70057 67791 product 73580 M 0 73580
0 VC_Hard_House_Anthems_Vol.8_s1eq-g1.jpg 1400 1400 70058 67792 product 73581 M 0 73581
0 VC_Hard_House_Anthems_Vol.8_qte2-zd.jpg 1400 1400 70059 67793 product 73582 M 0 73582
0 VC_Hard_House_Anthems_Vol.8_k94d-xs.jpg 1400 1400 70060 67794 product 73583 M 0 73583
0 VC_Hard_House_Anthems_Vol.8_8q0d-oa.jpg 1400 1400 70061 67795 product 73584 M 0 73584
0 VC_Hard_House_Anthems_Vol.8_ygn4-kw.jpg 1400 1400 70062 67796 product 73585 M 0 73585
0 VC_Hard_House_Anthems_Vol.8_gqao-ut.jpg 1400 1400 70063 67797 product 73586 M 0 73586
0 VC_Hard_House_Anthems_Vol.8_tgy3-ik.jpg 1400 1400 70064 67798 product 73587 M 0 73587
0 VC_Hard_House_Anthems_Vol.8_lyex-f6.jpg 1400 1400 70065 67799 product 73588 M 0 73588
0 VC_Hard_House_Anthems_Vol.8_4r3q-2e.jpg 1400 1400 70066 67800 product 73589 M 0 73589
0 VC_Hard_House_Anthems_Vol.8_bkqv-zi.jpg 1400 1400 70067 67801 product 73590 M 0 73590
0 VC_Hard_House_Anthems_Vol.8_v9po-za.jpg 1400 1400 70068 67802 product 73591 M 0 73591
0 VC_Hard_House_Anthems_Vol.8_5263-my.jpg 1400 1400 70069 67803 product 73592 M 0 73592
0 VC_Hard_House_Anthems_Vol.8_hard-69.jpg 1400 1400 70070 67804 product 73593 M 0 73593
0 VC_Hard_House_Anthems_Vol.8_5rbk-is.jpg 1400 1400 70071 67805 product 73594 M 0 73594
0 VC_Hard_House_Anthems_Vol.8_mg99-kt.jpg 1400 1400 70072 67806 product 73595 M 0 73595
0 VC_Hard_House_Anthems_Vol.8_8bkc-9w.jpg 1400 1400 70073 67807 product 73596 M 0 73596
0 VC_Hard_House_Anthems_Vol.8_56rk-36.jpg 1400 1400 70074 67808 product 73597 M 0 73597
0 VC_Hard_House_Anthems_Vol.8_nv20-su.jpg 1400 1400 70075 67809 product 73598 M 0 73598
0 VC_Hard_House_Anthems_Vol.8_gj55-dz.jpg 1400 1400 70076 67810 product 73599 M 0 73599
0 IOD060.jpg 900 900 70967 68698 product 74490 M 0 74490
0 5054283720860_objg-uq.jpg 1000 1000 71106 68836 product 74629 M 0 74629
0 35886967_10214835148063915_2117864071763066880_n.jpg 480 480 71268 68998 product 74791 M 0 74791
0 5054283742497.jpg 1000 1000 71276 69005 product 74799 M 0 74799
0 5054283753332.jpg 1000 1000 71378 69107 product 74901 M 0 74901
0 kaos-theory.jpg 800 800 71622 69348 product 75145 M 0 75145
0 5054283775259.jpg 1000 1000 71624 69350 product 75147 M 0 75147
0 TMP0109.png 1400 1400 71675 69401 product 75198 M 0 75198
0 HELL008_-_Betelgeuse.jpg 3600 3600 71707 69432 product 75230 M 0 75230
0 37209121_10214202222784108_18922174207229952_n.png 960 960 71722 69447 product 75245 M 0 75245
0 5054283781878.jpg 1000 1000 71724 69449 product 75247 M 0 75247
0 unleashed.jpg 800 800 71734 69459 product 75257 M 0 75257
0 37352028_10156393905201000_6047884972964970496_n.jpg 960 960 71778 69503 product 75301 M 0 75301
0 JAM025_Hard_Jeli___Dave_Owens_-_La_Chops.jpg 1400 1400 71780 69505 product 75303 M 0 75303
0 FF_057a_-_Damaged_Gudz_-_Tosser.jpg 2000 2000 71781 69506 product 75304 M 0 75304
0 FF_057b_-_Damaged_Gudz_-_Nailed_That.jpg 2000 2000 71782 69507 product 75305 M 0 75305
0 Found-You-Track-Artwork.png 2481 2481 71824 69410 product 75347 M 0 75347
0 Dan_Dyson_EP2.jpg 960 960 71891 69615 product 75414 M 0 75414
0 Dan_Dyson_EP2_phyh-n4.jpg 960 960 71892 69616 product 75415 M 0 75415
0 SSD034-Release-Artwork-2.jpg 3000 3000 71895 69618 product 75418 M 0 75418