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.detailed_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 (
    4643, 4641, 4371, 6277, 6210, 6313, 6283, 
    6284, 6205, 6204, 6203, 4973, 6206, 
    4956, 34983, 5183, 5511, 5657, 5368, 
    5364
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00069

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.detailed_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 50526532279021344125575501dba87e7952.jpg 1000 1000 4382 4371 product 7905 M 0 7905
0 50526532048041344128878501dc76eecd75.jpg 1000 1000 4652 4641 product 8175 M 0 8175
0 50526532048041344128892501dc77c1fb25.jpg 1000 1000 4654 4643 product 8177 M 0 8177
0 5052653200547.jpg 1000 1000 4967 4956 product 8490 M 0 8490
0 50526532047981344214907501f177bb243d.jpg 1000 1000 4984 4973 product 8507 M 0 8507
0 5052653173919.jpg 1000 1000 5194 5183 product 8717 M 0 8717
0 505265315038513443159415020a22505487.jpg 1000 1000 5375 5364 product 8898 M 0 8898
0 505265315038513443159585020a236a9e04.jpg 1000 1000 5379 5368 product 8902 M 0 8902
0 5052653171625.jpg 1000 1000 5522 5511 product 9045 M 0 9045
0 505265317327813443210375020b60d79012.jpg 1000 1000 5668 5657 product 9191 M 0 9191
0 5052653209168.jpg 1000 1000 6212 6203 product 9735 M 0 9735
0 50526532091681344440356502288249e9f7.jpg 1000 1000 6213 6204 product 9736 M 0 9736
0 505265320916813444403595022882783706.jpg 1000 1000 6214 6205 product 9737 M 0 9737
0 5052653200516.jpg 1000 1000 6215 6206 product 9738 M 0 9738
0 5052653216227.jpg 1000 1000 6219 6210 product 9742 M 0 9742
0 5052653218924.jpg 1000 1000 6286 6277 product 9809 M 0 9809
0 5052653216210.jpg 1000 1000 6292 6283 product 9815 M 0 9815
0 5052653207904.jpg 1000 1000 6293 6284 product 9816 M 0 9816
0 5052653218993.jpg 1000 1000 6322 6313 product 9845 M 0 9845
0 5054281092334.jpg 1000 1000 35027 34983 product 38550 M 0 38550