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 (
    106331, 106330, 106329, 106328, 106327, 
    106326, 106325, 106324, 106323, 106312, 
    106311, 106309, 106308, 106307, 106306, 
    106305, 106304, 106303, 106302, 106301
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00050

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 109436 106301 product 112959 M 0
0 109437 106302 product 112960 M 0
0 109438 106303 product 112961 M 0
0 109439 106304 product 112962 M 0
0 109440 106305 product 112963 M 0
0 109441 106306 product 112964 M 0
0 109442 106307 product 112965 M 0
0 109443 106308 product 112966 M 0
0 109444 106309 product 112967 M 0
0 109446 106311 product 112969 M 0
0 109447 106312 product 112970 M 0
0 109459 106323 product 112982 M 0
0 109460 106324 product 112983 M 0
0 109461 106325 product 112984 M 0
0 109462 106326 product 112985 M 0
0 109463 106327 product 112986 M 0
0 109464 106328 product 112987 M 0
0 109465 106329 product 112988 M 0
0 109466 106330 product 112989 M 0
0 109467 106331 product 112990 M 0