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 (
    67841, 68817, 67790, 67789, 67788, 67787, 
    67786, 67785, 67784, 67783, 67782, 
    67781, 67780, 67779, 67778, 67777, 
    67776, 67775, 67774, 67773, 67772, 
    67771, 68694, 68693, 68661, 68532, 
    68124, 68123, 68692, 68662, 68573, 
    68531, 68374, 68361, 68199, 67871, 
    67844, 67843, 67840, 68201
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00094

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.7.jpg 1400 1400 70037 67771 product 73560 M 0 73560
0 VC_Hard_House_Anthems_Vol.7_rws0-nm.jpg 1400 1400 70038 67772 product 73561 M 0 73561
0 VC_Hard_House_Anthems_Vol.7_95gq-hf.jpg 1400 1400 70039 67773 product 73562 M 0 73562
0 VC_Hard_House_Anthems_Vol.7_v5ez-dj.jpg 1400 1400 70040 67774 product 73563 M 0 73563
0 VC_Hard_House_Anthems_Vol.7_v0mi-ap.jpg 1400 1400 70041 67775 product 73564 M 0 73564
0 VC_Hard_House_Anthems_Vol.7_gdc5-z5.jpg 1400 1400 70042 67776 product 73565 M 0 73565
0 VC_Hard_House_Anthems_Vol.7_3fxx-fn.jpg 1400 1400 70043 67777 product 73566 M 0 73566
0 VC_Hard_House_Anthems_Vol.7_pctn-n2.jpg 1400 1400 70044 67778 product 73567 M 0 73567
0 VC_Hard_House_Anthems_Vol.7_ti83-i4.jpg 1400 1400 70045 67779 product 73568 M 0 73568
0 VC_Hard_House_Anthems_Vol.7_8zl5-49.jpg 1400 1400 70046 67780 product 73569 M 0 73569
0 VC_Hard_House_Anthems_Vol.7_rn4x-93.jpg 1400 1400 70047 67781 product 73570 M 0 73570
0 VC_Hard_House_Anthems_Vol.7_heib-gr.jpg 1400 1400 70048 67782 product 73571 M 0 73571
0 VC_Hard_House_Anthems_Vol.7_7cwl-ba.jpg 1400 1400 70049 67783 product 73572 M 0 73572
0 VC_Hard_House_Anthems_Vol.7_lhww-hu.jpg 1400 1400 70050 67784 product 73573 M 0 73573
0 VC_Hard_House_Anthems_Vol.7_5b4x-cd.jpg 1400 1400 70051 67785 product 73574 M 0 73574
0 VC_Hard_House_Anthems_Vol.7_56bs-pl.jpg 1400 1400 70052 67786 product 73575 M 0 73575
0 VC_Hard_House_Anthems_Vol.7_umjb-c0.jpg 1400 1400 70053 67787 product 73576 M 0 73576
0 VC_Hard_House_Anthems_Vol.7_m5a1-l7.jpg 1400 1400 70054 67788 product 73577 M 0 73577
0 VC_Hard_House_Anthems_Vol.7_26kf-r7.jpg 1400 1400 70055 67789 product 73578 M 0 73578
0 VC_Hard_House_Anthems_Vol.7_5j3x-jr.jpg 1400 1400 70056 67790 product 73579 M 0 73579
0 Vicious_Circle_Recordings_267a_Artwork.jpg 1400 1400 70106 67840 product 73629 M 0 73629
0 Vicious_Circle_Recordings_268_Artwork.jpg 1400 1400 70107 67841 product 73630 M 0 73630
0 dentology_remixed_ep4.jpg 1400 1400 70109 67843 product 73632 M 0 73632
0 dentology_remixed_ep4_ehim-mo.jpg 1400 1400 70110 67844 product 73633 M 0 73633
0 Fireball_Recordings_295.jpg 1400 1400 70137 67871 product 73660 M 0 73660
0 5054283661552.jpg 1000 1000 70391 68123 product 73914 M 0 73914
0 5054283661552_gvqj-ot.jpg 1000 1000 70392 68124 product 73915 M 0 73915
0 5054283636857.jpg 1000 1000 70468 68199 product 73991 M 0 73991
0 TMP0106.jpg 1400 1400 70470 68201 product 73993 M 0 73993
0 5054283685466.jpg 1000 1000 70644 68374 product 74167 M 0 74167
0 SS077.png 1400 1400 70801 68531 product 74324 M 0 74324
0 Drake_Liddell_-_Somebody.jpg 960 960 70802 68532 product 74325 M 0 74325
0 F4A003_-_Pluto_-_Open_Door.jpg 3000 3000 70843 68573 product 74366 M 0 74366
0 Paul_Batten_-_GroundandPound.jpg 1600 1600 70931 68661 product 74454 M 0 74454
0 34759049_10156290274541000_5846553866954342400_n.jpg 1600 1600 70932 68662 product 74455 M 0 74455
0 Orrible_noize_broken_cat_logo__1__-_Copy.jpg 2000 2000 70962 68692 product 74485 M 0 74485
0 IOD056.jpg 900 900 70963 68694 product 74486 M 0 74486
0 Orrible_noize_broken_cat_logo__1__-_Copy_yv42-84.jpg 2000 2000 70973 68693 product 74496 M 0 74496
0 dd135.jpg 1000 1000 71087 68817 product 74610 M 0 74610
0 FR056a_-_Slenderman_-_D.E.A.D..jpg 2000 2000 92224 68361 product 95747 M 0 95747