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 (
    73240, 73116, 72858, 72857, 73405, 73404, 
    73403, 73155, 73115, 73351, 73350, 
    73349, 73348, 72836, 73284, 73111, 
    71691, 68825, 49338, 44239, 44238, 
    42033, 73271, 73270, 73252, 73239, 
    73237, 73217, 73156, 73119, 72856, 
    72855, 72852, 72032, 71703, 71486, 
    71485, 71484, 71483, 73020
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00132

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 twistedtraxx_tn5i-ku.jpg 960 960 43547 42033 product 47070 M 0 47070
0 twistedtraxx.jpg 960 960 45746 44238 product 49269 M 0 49269
0 twistedtraxx_dlnd-18.jpg 960 960 45747 44239 product 49270 M 0 49270
0 twistedtraxx.png 263 263 50843 49338 product 54366 M 0 54366
0 twistedtraxx_tn5i-ku.jpg 280 280 71095 68825 product 74618 M 0 74618
0 5054283914443.jpg 1000 1000 74290 71483 product 77813 M 0 77813
0 5054283914443_bjer-tz.jpg 1000 1000 74291 71484 product 77814 M 0 77814
0 5054283914443_xpx5-vf.jpg 1000 1000 74292 71485 product 77815 M 0 77815
0 5054283914443_ihyg-lw.jpg 1000 1000 74293 71486 product 77816 M 0 77816
0 5054283983111.jpg 1000 1000 74500 71691 product 78023 M 0 78023
0 5054283980301.jpg 1000 1000 74512 71703 product 78035 M 0 78035
0 5054283988840.jpg 1000 1000 74841 72032 product 78364 M 0 78364
0 5054283987652.jpg 1000 1000 75645 72836 product 79168 M 0 79168
0 Fireball_Recordings_304.jpg 1400 1400 75661 72852 product 79184 M 0 79184
0 Vicious_Circle_Recordings_272_Artwork.jpg 1400 1400 75664 72855 product 79187 M 0 79187
0 Vicious_Circle_Recordings_272r_Artwork.jpg 1400 1400 75665 72856 product 79188 M 0 79188
0 Vicious_Circle_Recordings_273_Artwork.jpg 1400 1400 75666 72857 product 79189 M 0 79189
0 Vicious_Circle_Recordings_273r_Artwork.jpg 1400 1400 75667 72858 product 79190 M 0 79190
0 5054283998917.jpg 1000 1000 75830 73020 product 79353 M 0 79353
0 5054284104461.jpg 1000 1000 75921 73111 product 79444 M 0 79444
0 5054284109268.jpg 1000 1000 75925 73115 product 79448 M 0 79448
0 Rock_The_House_Cover-1.jpg 2363 2363 75926 73116 product 79449 M 0 79449
0 arabian_nights_miss_detonate_ben_stevens_remix.jpg 480 480 75967 73155 product 79490 M 0 79490
0 Lucille-Artwork_1400x1400_.png 1400 1400 75968 73156 product 79491 M 0 79491
0 47447330_143245779892137_5726595649420394496_n.jpg 1600 1600 76029 73217 product 79552 M 0 79552
0 FR066_-_Random_But_Raw_-_Set_Time.jpg 2000 2000 76049 73237 product 79572 M 0 79572
0 TMP0117.png 1400 1400 76051 73239 product 79574 M 0 79574
0 TMP0118.png 1400 1400 76052 73240 product 79575 M 0 79575
0 dd143.jpg 1000 1000 76064 73252 product 79587 M 0 79587
0 420rekords_fojo-kp_famp-ve_5ls7-do.jpg 727 443 76082 73270 product 79605 M 0 79605
0 TURTLEDOG_LOGO_RGB.jpg 802 888 76083 73271 product 79606 M 0 79606
0 Kirk.jpg 800 800 76096 73284 product 79619 M 0 79619
0 Movin'_House_Logo_-_700x700.jpg 700 700 76160 73348 product 79683 M 0 79683
0 420rekords_fojo-kp_famp-ve_pe5t-2g.jpg 727 443 76161 73349 product 79684 M 0 79684
0 420rekords_fojo-kp_famp-ve_sd9y-bh.jpg 727 443 76162 73350 product 79685 M 0 79685
0 420rekords_fojo-kp_famp-ve_5zro-et.jpg 727 443 76163 73351 product 79686 M 0 79686
0 Happy_Hour.jpg 300 300 76215 73403 product 79738 M 0 79738
0 Feel_Good.jpg 312 330 76216 73404 product 79739 M 0 79739
0 Ones_and_Twos.jpg 312 330 76217 73405 product 79740 M 0 79740
0 03_HELIX_cover_HLXR049.jpg 1400 1400 98846 73119 product 102369 M 0 102369