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 (
    31436, 31435, 31434, 31433, 31432, 31431, 
    31430, 31429, 31428, 31427, 31426, 
    31425, 31424, 31423, 14017, 13990, 
    13989, 13968, 13987, 13986, 13985, 
    13983, 13982, 13981, 13980, 13979, 
    13978, 13977, 13976, 13975, 13974, 
    13973, 13972, 13971, 13970, 13969, 
    16527, 13892, 13891, 13882
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00077

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 13895 13882 product 17418 M 0
0 13904 13891 product 17427 M 0
0 13905 13892 product 17428 M 0
0 13981 13968 product 17504 M 0
0 13982 13969 product 17505 M 0
0 13983 13970 product 17506 M 0
0 13984 13971 product 17507 M 0
0 13985 13972 product 17508 M 0
0 13986 13973 product 17509 M 0
0 13987 13974 product 17510 M 0
0 13988 13975 product 17511 M 0
0 13989 13976 product 17512 M 0
0 13990 13977 product 17513 M 0
0 13991 13978 product 17514 M 0
0 13992 13979 product 17515 M 0
0 13993 13980 product 17516 M 0
0 13994 13981 product 17517 M 0
0 13995 13982 product 17518 M 0
0 13996 13983 product 17519 M 0
0 13998 13985 product 17521 M 0
0 13999 13986 product 17522 M 0
0 14000 13987 product 17523 M 0
0 14002 13989 product 17525 M 0
0 14003 13990 product 17526 M 0
0 14030 14017 product 17553 M 0
0 16537 16527 product 20060 M 0
0 31440 31423 product 34963 M 0
0 31441 31424 product 34964 M 0
0 31442 31425 product 34965 M 0
0 31443 31426 product 34966 M 0
0 31444 31427 product 34967 M 0
0 31445 31428 product 34968 M 0
0 31446 31429 product 34969 M 0
0 31447 31430 product 34970 M 0
0 31448 31431 product 34971 M 0
0 31449 31432 product 34972 M 0
0 31450 31433 product 34973 M 0
0 31451 31434 product 34974 M 0
0 31452 31435 product 34975 M 0
0 31453 31436 product 34976 M 0