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.image_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.00090

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.image_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 89779 87024 product 93302 M 0
0 89822 87067 product 93345 M 0
0 89836 87081 product 93359 M 0
0 89837 87082 product 93360 M 0
0 89838 87083 product 93361 M 0
0 89912 87157 product 93435 M 0
0 89913 87158 product 93436 M 0
0 89924 87169 product 93447 M 0
0 90117 87362 product 93640 M 0
0 90118 87363 product 93641 M 0
0 90164 87409 product 93687 M 0
0 90165 87410 product 93688 M 0
0 90166 87411 product 93689 M 0
0 90167 87412 product 93690 M 0
0 90168 87413 product 93691 M 0
0 90169 87414 product 93692 M 0
0 90170 87415 product 93693 M 0
0 90171 87416 product 93694 M 0
0 90172 87417 product 93695 M 0
0 90173 87418 product 93696 M 0
0 90230 87475 product 93753 M 0
0 90430 87659 product 93953 M 0
0 90433 87662 product 93956 M 0
0 90446 87675 product 93969 M 0
0 90447 87676 product 93970 M 0
0 90478 87707 product 94001 M 0
0 90479 87708 product 94002 M 0
0 90481 87710 product 94004 M 0
0 90482 87711 product 94005 M 0
0 90483 87712 product 94006 M 0
0 90484 87713 product 94007 M 0
0 90623 87852 product 94146 M 0
0 90624 87853 product 94147 M 0
0 90625 87854 product 94148 M 0
0 90893 88122 product 94416 M 0
0 90894 88123 product 94417 M 0
0 90895 88124 product 94418 M 0
0 90896 88125 product 94419 M 0
0 90897 88126 product 94420 M 0
0 90898 88127 product 94421 M 0