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 (
    74072, 74071, 74056, 73996, 73977, 73815, 
    73673, 73599, 73598, 73821, 73994, 
    73976, 73740, 73734, 73880, 73819, 
    73484, 73483, 73820, 73874, 73626, 
    73873, 73872, 73871, 73870, 73869, 
    73868, 73867, 73866, 73865, 73864, 
    73863, 73862, 73861, 73860, 73859, 
    73858, 73857, 73856, 73855
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00085

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 5054283990379.jpg 1000 1000 76295 73483 product 79818 M 0 79818
0 5054283990379_j2ue-bh.jpg 1000 1000 76296 73484 product 79819 M 0 79819
0 Vicious_Circle_Recordings_276_Artwork.jpg 1400 1400 76410 73598 product 79933 M 0 79933
0 Vicious_Circle_Recordings_276r_Artwork.jpg 1400 1400 76411 73599 product 79934 M 0 79934
0 5054284155531.jpg 1000 1000 76439 73626 product 79962 M 0 79962
0 5054284163611.jpg 1000 1000 76487 73673 product 80010 M 0 80010
0 Ant_Hornsby_-_Elevate.jpg 1600 1600 76548 73734 product 80071 M 0 80071
0 5054284169842.jpg 1000 1000 76554 73740 product 80077 M 0 80077
0 DS024.jpg 960 960 76630 73815 product 80153 M 0 80153
0 IMG_1380.JPG 1185 1185 76634 73819 product 80157 M 0 80157
0 IOD68.jpg 480 480 76635 73820 product 80158 M 0 80158
0 IOD069.jpg 480 480 76636 73821 product 80159 M 0 80159
0 FBRB2018.jpg 600 600 76669 73855 product 80192 M 0 80192
0 FBRB2018_osz9-si.jpg 600 600 76670 73856 product 80193 M 0 80193
0 FBRB2018_u7l9-3d.jpg 600 600 76671 73857 product 80194 M 0 80194
0 FBRB2018_7s2m-zq.jpg 600 600 76672 73858 product 80195 M 0 80195
0 FBRB2018_26rr-vb.jpg 600 600 76673 73859 product 80196 M 0 80196
0 FBRB2018_4hie-m4.jpg 600 600 76674 73860 product 80197 M 0 80197
0 FBRB2018_uodz-y5.jpg 600 600 76675 73861 product 80198 M 0 80198
0 FBRB2018_lyau-ek.jpg 600 600 76676 73862 product 80199 M 0 80199
0 FBRB2018_nsr4-b5.jpg 600 600 76677 73863 product 80200 M 0 80200
0 FBRB2018_i6va-nu.jpg 600 600 76678 73864 product 80201 M 0 80201
0 FBRB2018_avg2-4p.jpg 600 600 76679 73865 product 80202 M 0 80202
0 FBRB2018_ln61-oy.jpg 600 600 76680 73866 product 80203 M 0 80203
0 FBRB2018_nj59-s8.jpg 600 600 76681 73867 product 80204 M 0 80204
0 FBRB2018_h3z4-8x.jpg 600 600 76682 73868 product 80205 M 0 80205
0 FBRB2018_nvfe-ma.jpg 600 600 76683 73869 product 80206 M 0 80206
0 FBRB2018_q880-3n.jpg 600 600 76684 73870 product 80207 M 0 80207
0 FBRB2018_94iu-h4.jpg 600 600 76685 73871 product 80208 M 0 80208
0 FBRB2018_s8qs-nf.jpg 600 600 76686 73872 product 80209 M 0 80209
0 FBRB2018_mugw-hb.jpg 600 600 76687 73873 product 80210 M 0 80210
0 dd144.jpg 1000 1000 76688 73874 product 80211 M 0 80211
0 OFITR__1_.jpg 800 800 76728 73880 product 80251 M 0 80251
0 NITROX101_-_Kumite_-_Cannonball_Run_-_Nitrox.jpg 3600 3600 76790 73976 product 80313 M 0 80313
0 FR069_-_Manik_-_Simplicity.jpg 2000 2000 76791 73977 product 80314 M 0 80314
0 TMP0119.png 1400 1400 76808 73994 product 80331 M 0 80331
0 Different_Forever_Whatever_-Artwork_1400x1400_.png 1400 1400 76810 73996 product 80333 M 0 80333
0 Fireball-Recordings-308.jpg 1400 1400 76871 74056 product 80394 M 0 80394
0 TT_Best_of_Vol1.jpg 2000 2000 76886 74071 product 80409 M 0 80409
0 TT_Best_of_Vol1_o3kc-ti.jpg 2000 2000 76887 74072 product 80410 M 0 80410