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 (
    93222, 93224, 93165, 92338, 92337, 93157, 
    93156, 93104, 93103, 93058, 93036, 
    92955, 92835, 92833, 92522, 92521, 
    92504, 92502, 92344, 92281
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00127

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 95135 92281 product 98658 M 0
0 95193 92337 product 98716 M 0
0 95194 92338 product 98717 M 0
0 95200 92344 product 98723 M 0
0 95360 92502 product 98883 M 0
0 95362 92504 product 98885 M 0
0 95379 92521 product 98902 M 0
0 95380 92522 product 98903 M 0
0 95692 92833 product 99215 M 0
0 95694 92835 product 99217 M 0
0 95872 92955 product 99395 M 0
0 95903 93036 product 99426 M 0
0 95925 93058 product 99448 M 0
0 95971 93103 product 99494 M 0
0 95972 93104 product 99495 M 0
0 96024 93157 product 99547 M 0
0 96025 93156 product 99548 M 0
0 96034 93165 product 99557 M 0
0 96091 93222 product 99614 M 0
0 96093 93224 product 99616 M 0