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 (
    88618, 88617, 88616, 88615, 88614, 88613, 
    88612, 88611, 88610, 88609, 88608, 
    88607, 88606, 88605, 88604, 88603, 
    88602, 88601, 88600, 88599, 88598, 
    88597, 88596, 88595, 88650, 88571, 
    88957, 88956, 88955, 88593, 88592, 
    88172, 88169, 88762, 88761, 88543, 
    88542, 88487, 88486, 88449
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00074

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 90939 88169 product 94462 M 0
0 90942 88172 product 94465 M 0
0 91247 88449 product 94770 M 0
0 91284 88486 product 94807 M 0
0 91285 88487 product 94808 M 0
0 91341 88542 product 94864 M 0
0 91342 88543 product 94865 M 0
0 91370 88571 product 94893 M 0
0 91391 88592 product 94914 M 0
0 91392 88593 product 94915 M 0
0 91394 88595 product 94917 M 0
0 91395 88596 product 94918 M 0
0 91396 88597 product 94919 M 0
0 91397 88598 product 94920 M 0
0 91398 88599 product 94921 M 0
0 91399 88600 product 94922 M 0
0 91400 88601 product 94923 M 0
0 91401 88602 product 94924 M 0
0 91402 88603 product 94925 M 0
0 91403 88604 product 94926 M 0
0 91404 88605 product 94927 M 0
0 91405 88606 product 94928 M 0
0 91406 88607 product 94929 M 0
0 91407 88608 product 94930 M 0
0 91408 88609 product 94931 M 0
0 91409 88610 product 94932 M 0
0 91410 88611 product 94933 M 0
0 91411 88612 product 94934 M 0
0 91412 88613 product 94935 M 0
0 91413 88614 product 94936 M 0
0 91414 88615 product 94937 M 0
0 91415 88616 product 94938 M 0
0 91416 88617 product 94939 M 0
0 91417 88618 product 94940 M 0
0 91449 88650 product 94972 M 0
0 91560 88761 product 95083 M 0
0 91561 88762 product 95084 M 0
0 91756 88955 product 95279 M 0
0 91757 88956 product 95280 M 0
0 91758 88957 product 95281 M 0