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 (
    88127, 88126, 88125, 88124, 87662, 87418, 
    87417, 87416, 87415, 87414, 87413, 
    87412, 87411, 87410, 87409, 87363, 
    87362, 87158, 87157, 87659, 88123, 
    88122, 87708, 87707, 87676, 87675, 
    87475, 87169, 87083, 87082, 87081, 
    87067, 87024, 87854, 87853, 87852, 
    87713, 87712, 87711, 87710
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00149

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 5054285182154.jpg 1000 1000 89779 87024 product 93302 M 0 93302
0 5054285182987.jpg 1000 1000 89822 87067 product 93345 M 0 93345
0 5054285151600.jpg 1000 1000 89836 87081 product 93359 M 0 93359
0 5054285151600_stsz-ju.jpg 1000 1000 89837 87082 product 93360 M 0 93360
0 5054285151600_05ep-wu.jpg 1000 1000 89838 87083 product 93361 M 0 93361
0 5054285187814.jpg 1000 1000 89912 87157 product 93435 M 0 93435
0 5054285187814_f1bg-wh.jpg 1000 1000 89913 87158 product 93436 M 0 93436
0 5054285184707.jpg 1000 1000 89924 87169 product 93447 M 0 93447
0 5054285143391.jpg 1000 1000 90117 87362 product 93640 M 0 93640
0 5054285143391_hfxs-5p.jpg 1000 1000 90118 87363 product 93641 M 0 93641
0 5054285214961.jpg 1000 1000 90164 87409 product 93687 M 0 93687
0 5054285214961_fimm-35.jpg 1000 1000 90165 87410 product 93688 M 0 93688
0 5054285214961_owab-1x.jpg 1000 1000 90166 87411 product 93689 M 0 93689
0 5054285214961_0zkg-3y.jpg 1000 1000 90167 87412 product 93690 M 0 93690
0 5054285214961_4chx-4p.jpg 1000 1000 90168 87413 product 93691 M 0 93691
0 5054285214961_2tfg-u8.jpg 1000 1000 90169 87414 product 93692 M 0 93692
0 5054285214961_9j0f-6g.jpg 1000 1000 90170 87415 product 93693 M 0 93693
0 5054285214961_j09x-j7.jpg 1000 1000 90171 87416 product 93694 M 0 93694
0 5054285214961_oq7g-ow.jpg 1000 1000 90172 87417 product 93695 M 0 93695
0 5054285214961_w4q2-4c.jpg 1000 1000 90173 87418 product 93696 M 0 93696
0 5054285109397.jpg 1000 1000 90230 87475 product 93753 M 0 93753
0 5054285109373.jpg 1000 1000 90430 87659 product 93953 M 0 93953
0 5054285259054.jpg 1000 1000 90433 87662 product 93956 M 0 93956
0 5054285259153.jpg 1000 1000 90446 87675 product 93969 M 0 93969
0 5054285259153_y0is-28.jpg 1000 1000 90447 87676 product 93970 M 0 93970
0 5054285238097.jpg 1000 1000 90478 87707 product 94001 M 0 94001
0 5054285238097_qimq-pm.jpg 1000 1000 90479 87708 product 94002 M 0 94002
0 5054285241547.jpg 1000 1000 90481 87710 product 94004 M 0 94004
0 5054285241547_ui7s-eb.jpg 1000 1000 90482 87711 product 94005 M 0 94005
0 5054285241547_o8xl-hl.jpg 1000 1000 90483 87712 product 94006 M 0 94006
0 5054285241547_gk0w-q9.jpg 1000 1000 90484 87713 product 94007 M 0 94007
0 5054285241172.jpg 1000 1000 90623 87852 product 94146 M 0 94146
0 5054285241172_rh3m-jf.jpg 1000 1000 90624 87853 product 94147 M 0 94147
0 5054285241172_36b7-c7.jpg 1000 1000 90625 87854 product 94148 M 0 94148
0 5054285234846.jpg 1000 1000 90893 88122 product 94416 M 0 94416
0 5054285234846_g5uo-j8.jpg 1000 1000 90894 88123 product 94417 M 0 94417
0 5054285241189.jpg 1000 1000 90895 88124 product 94418 M 0 94418
0 5054285241189_jj95-e7.jpg 1000 1000 90896 88125 product 94419 M 0 94419
0 5054285241189_41j5-tx.jpg 1000 1000 90897 88126 product 94420 M 0 94420
0 5054285241189_klns-cg.jpg 1000 1000 90898 88127 product 94421 M 0 94421