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 (
    88704, 88703, 88702, 88701, 88700, 88699, 
    88698, 88696, 88695, 88694, 88692, 
    88691, 88690, 88688, 88687, 88686, 
    88685, 88684, 89281, 102419
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00119

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 5054284659466.jpg 1000 1000 91483 88684 product 95006 M 0 95006
0 5054284659466_rltg-i9.jpg 1000 1000 91484 88685 product 95007 M 0 95007
0 5054284659466_vpfv-fp.jpg 1000 1000 91485 88686 product 95008 M 0 95008
0 5054284659466_qbdz-t9.jpg 1000 1000 91486 88687 product 95009 M 0 95009
0 5054284659466_e4i5-kw.jpg 1000 1000 91487 88688 product 95010 M 0 95010
0 5054284659466_wnvx-00.jpg 1000 1000 91489 88690 product 95012 M 0 95012
0 5054284659466_rkqf-xv.jpg 1000 1000 91490 88691 product 95013 M 0 95013
0 5054284659466_84ub-a5.jpg 1000 1000 91491 88692 product 95014 M 0 95014
0 5054284659466_t02s-0d.jpg 1000 1000 91493 88694 product 95016 M 0 95016
0 5054284659466_bljz-vj.jpg 1000 1000 91494 88695 product 95017 M 0 95017
0 5054284659466_p18c-94.jpg 1000 1000 91495 88696 product 95018 M 0 95018
0 5054284659466_q7h7-fr.jpg 1000 1000 91497 88698 product 95020 M 0 95020
0 5054284659466_vv3k-dx.jpg 1000 1000 91498 88699 product 95021 M 0 95021
0 5054284659466_6csk-1v.jpg 1000 1000 91499 88700 product 95022 M 0 95022
0 5054284659466_wv7s-6m.jpg 1000 1000 91500 88701 product 95023 M 0 95023
0 5054284659466_u1ha-42.jpg 1000 1000 91501 88702 product 95024 M 0 95024
0 5054284659466_nn8o-vf.jpg 1000 1000 91502 88703 product 95025 M 0 95025
0 5054284659466_ms1l-ln.jpg 1000 1000 91503 88704 product 95026 M 0 95026
0 5054285371350.jpg 1000 1000 92089 89281 product 95612 M 0 95612
0 5054286474951_9ibf-f0.jpg 1000 1000 105515 102419 product 109038 M 0 109038