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 (
    87627, 87626, 87625, 87624, 87623, 87622, 
    87621, 87620, 88579, 88170, 87964, 
    87680, 88790, 88789, 88788, 87400, 
    87316, 87315, 87314, 87313
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 5054285157152_24f4-3i.jpg 1000 1000 90068 87313 product 93591 M 0 93591
0 5054285157152_gv5s-1i.jpg 1000 1000 90069 87314 product 93592 M 0 93592
0 5054285157152_n9z8-qk.jpg 1000 1000 90070 87315 product 93593 M 0 93593
0 5054285157152_yjus-su.jpg 1000 1000 90071 87316 product 93594 M 0 93594
0 5054285217009.jpg 1000 1000 90155 87400 product 93678 M 0 93678
0 5054285240991.jpg 1000 1000 90391 87620 product 93914 M 0 93914
0 5054285240991_ki76-dc.jpg 1000 1000 90392 87621 product 93915 M 0 93915
0 5054285240991_oh6o-4o.jpg 1000 1000 90393 87622 product 93916 M 0 93916
0 5054285240991_dq5a-pj.jpg 1000 1000 90394 87623 product 93917 M 0 93917
0 5054285240991_j88a-sl.jpg 1000 1000 90395 87624 product 93918 M 0 93918
0 5054285240991_weup-2c.jpg 1000 1000 90396 87625 product 93919 M 0 93919
0 5054285240991_9fyi-qz.jpg 1000 1000 90397 87626 product 93920 M 0 93920
0 5054285240991_6m32-3v.jpg 1000 1000 90398 87627 product 93921 M 0 93921
0 5054285250099.jpg 1000 1000 90451 87680 product 93974 M 0 93974
0 5054284594453_eppb-rq.jpg 1000 1000 90735 87964 product 94258 M 0 94258
0 5054285271315.jpg 1000 1000 90940 88170 product 94463 M 0 94463
0 5054285283905.jpg 1000 1000 91378 88579 product 94901 M 0 94901
0 5054285241318.jpg 1000 1000 91587 88788 product 95110 M 0 95110
0 5054285241318_g1xy-lc.jpg 1000 1000 91588 88789 product 95111 M 0 95111
0 5054285241318_gb11-xs.jpg 1000 1000 91589 88790 product 95112 M 0 95112