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 (
    106778, 106777, 106776, 106775, 106774, 
    106313, 106760, 106759, 106369, 106368, 
    106273, 106271, 106270, 106269, 106260, 
    106243, 106242, 106241, 106240, 106239
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00061

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 109374 106239 product 112897 M 0
0 109375 106240 product 112898 M 0
0 109376 106241 product 112899 M 0
0 109377 106242 product 112900 M 0
0 109378 106243 product 112901 M 0
0 109395 106260 product 112918 M 0
0 109404 106269 product 112927 M 0
0 109405 106270 product 112928 M 0
0 109406 106271 product 112929 M 0
0 109408 106273 product 112931 M 0
0 109448 106313 product 112971 M 0
0 109504 106368 product 113027 M 0
0 109505 106369 product 113028 M 0
0 109898 106759 product 113421 M 0
0 109899 106760 product 113422 M 0
0 109915 106774 product 113438 M 0
0 109916 106775 product 113439 M 0
0 109917 106776 product 113440 M 0
0 109918 106777 product 113441 M 0
0 109919 106778 product 113442 M 0