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 (
    94857, 94814, 95739, 95696, 95695, 89230, 
    95546, 95200, 94865, 94683, 93093, 
    92916, 95501, 95500, 95499, 95498, 
    95497, 95496, 95495, 95494
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00054

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 20 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 95780 92916 product 99303 M 0
0 95960 93093 product 99483 M 0
0 97570 94683 product 101093 M 0
0 97704 94814 product 101227 M 0
0 97749 94857 product 101272 M 0
0 97757 94865 product 101280 M 0
0 98094 95200 product 101617 M 0
0 98416 95494 product 101939 M 0
0 98417 95495 product 101940 M 0
0 98418 95496 product 101941 M 0
0 98420 95498 product 101943 M 0
0 98421 95499 product 101944 M 0
0 98422 95497 product 101945 M 0
0 98423 95500 product 101946 M 0
0 98424 95501 product 101947 M 0
0 98468 95546 product 101991 M 0
0 98617 95695 product 102140 M 0
0 98618 95696 product 102141 M 0
0 98661 95739 product 102184 M 0
0 98723 89230 product 102246 M 0