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 (
    68534, 68533, 68459, 68363, 68362, 68360, 
    68358, 68357, 68135, 68065, 68064, 
    67902, 67896, 67685, 67684, 66983, 
    68359, 67955, 68319, 68312, 67848, 
    67845, 67839, 67686, 67683, 66841, 
    66840, 66839, 67958, 68200, 67770, 
    67769, 67768, 67767, 67766, 67765, 
    67764, 67763, 67762, 67761
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00098

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 tom_berry_ep.jpg 2000 2000 69103 66839 product 72626 M 0 72626
0 tom_berry_ep_gbki-e1.jpg 2000 2000 69104 66840 product 72627 M 0 72627
0 tom_berry_ep_rrn8-qv.jpg 2000 2000 69105 66841 product 72628 M 0 72628
0 XX_5a2o-fc.jpg 1458 1458 69948 67683 product 73471 M 0 73471
0 XX_li8k-a3.jpg 1458 1458 69949 67684 product 73472 M 0 73472
0 XX_4h72-vt.jpg 1458 1458 69950 67685 product 73473 M 0 73473
0 XX_ooxj-t1.jpg 1458 1458 69951 67686 product 73474 M 0 73474
0 VC_Hard_House_Anthems_Vol.6_m2n9-2k.jpg 1400 1400 70027 67761 product 73550 M 0 73550
0 VC_Hard_House_Anthems_Vol.6_oz6m-yn.jpg 1400 1400 70028 67762 product 73551 M 0 73551
0 VC_Hard_House_Anthems_Vol.6_7ta0-y9.jpg 1400 1400 70029 67763 product 73552 M 0 73552
0 VC_Hard_House_Anthems_Vol.6_u5a0-vi.jpg 1400 1400 70030 67764 product 73553 M 0 73553
0 VC_Hard_House_Anthems_Vol.6_t9r1-9w.jpg 1400 1400 70031 67765 product 73554 M 0 73554
0 VC_Hard_House_Anthems_Vol.6_m6fg-x0.jpg 1400 1400 70032 67766 product 73555 M 0 73555
0 VC_Hard_House_Anthems_Vol.6_58uz-qa.jpg 1400 1400 70033 67767 product 73556 M 0 73556
0 VC_Hard_House_Anthems_Vol.6_jxx4-oc.jpg 1400 1400 70034 67768 product 73557 M 0 73557
0 VC_Hard_House_Anthems_Vol.6_kcdl-nq.jpg 1400 1400 70035 67769 product 73558 M 0 73558
0 VC_Hard_House_Anthems_Vol.6_a9t2-8w.jpg 1400 1400 70036 67770 product 73559 M 0 73559
0 Vicious_Circle_Recordings_266_Artwork.jpg 1400 1400 70105 67839 product 73628 M 0 73628
0 Fireball_Recordings_294.jpg 1400 1400 70111 67845 product 73634 M 0 73634
0 5054283633771.jpg 1000 1000 70114 67848 product 73637 M 0 73637
0 5054283633795.jpg 1000 1000 70162 67896 product 73685 M 0 73685
0 5054283596694.jpg 1000 1000 70168 67902 product 73691 M 0 73691
0 5054283644364.jpg 1000 1000 70221 67955 product 73744 M 0 73744
0 5054283642629.jpg 1000 1000 70224 67958 product 73747 M 0 73747
0 5054283661521.jpg 1000 1000 70332 68064 product 73855 M 0 73855
0 5054283661521_lwor-ni.jpg 1000 1000 70333 68065 product 73856 M 0 73856
0 Joe_Longbottom___Ben_Diesel_-_Snatch_My_Pig_Up.jpg 960 960 70403 68135 product 73926 M 0 73926
0 TMP0105.jpg 1400 1400 70469 68200 product 73992 M 0 73992
0 JAM023_Binty_-_Feel_The_Fire_Burn.jpg 1400 1400 70581 68312 product 74104 M 0 74104
0 F4A002_-_Bry_Randall_-_Rude_Bitch.jpg 3000 3000 70588 68319 product 74111 M 0 74111
0 18553189_10158532622375391_1755366587_o.jpg 1400 1400 70626 68357 product 74149 M 0 74149
0 I_HAVE_A_DREAM.jpg 2000 2000 70627 68358 product 74150 M 0 74150
0 dd134.jpg 1000 1000 70628 68359 product 74151 M 0 74151
0 33159065_10213831548117473_7486318607576596480_n.png 960 960 70630 68360 product 74153 M 0 74153
0 UNBND0015-1600x1600.jpg 1600 1600 70632 68362 product 74155 M 0 74155
0 SSD032-Release-Artwork.jpg 3000 3000 70633 68363 product 74156 M 0 74156
0 Bezerk.jpg 300 300 70729 68459 product 74252 M 0 74252
0 420rekords.jpg 727 443 70803 68533 product 74326 M 0 74326
0 420rekords_5ygi-m9.jpg 727 443 70804 68534 product 74327 M 0 74327
0 GMIX__2_.png 2560 2560 100708 66983 product 104231 M 0 104231