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 (
    88313, 88312, 88311, 88310, 88261, 88260, 
    88259, 89141, 88890, 88747, 88679, 
    88678, 88336, 88392, 88206, 88205, 
    88204, 88203, 88202, 88201
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00060

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 5054285248393_v1ew-79.jpg 1000 1000 90971 88201 product 94494 M 0 94494
0 5054285248393_s917-kg.jpg 1000 1000 90972 88202 product 94495 M 0 94495
0 5054285248393_fh25-jj.jpg 1000 1000 90973 88203 product 94496 M 0 94496
0 5054285248393_79ka-8c.jpg 1000 1000 90974 88204 product 94497 M 0 94497
0 5054285248393_l5vk-8h.jpg 1000 1000 90975 88205 product 94498 M 0 94498
0 5054285248393_641i-h6.jpg 1000 1000 90976 88206 product 94499 M 0 94499
0 5054285147498.jpg 1000 1000 91031 88259 product 94554 M 0 94554
0 5054285147498_r67w-oo.jpg 1000 1000 91032 88260 product 94555 M 0 94555
0 5054285147498_hf2j-5n.jpg 1000 1000 91033 88261 product 94556 M 0 94556
0 5054285312995.jpg 1000 1000 91083 88310 product 94606 M 0 94606
0 5054285312995_nrbb-n2.jpg 1000 1000 91084 88311 product 94607 M 0 94607
0 5054285312995_ojma-g6.jpg 1000 1000 91085 88312 product 94608 M 0 94608
0 5054285312995_ifgz-ls.jpg 1000 1000 91086 88313 product 94609 M 0 94609
0 5054285323069.jpg 1000 1000 91110 88336 product 94633 M 0 94633
0 5054285322932.jpg 1000 1000 91190 88392 product 94713 M 0 94713
0 5054285330135.jpg 1000 1000 91477 88678 product 95000 M 0 95000
0 5054285330166.jpg 1000 1000 91478 88679 product 95001 M 0 95001
0 5054285331385.jpg 1000 1000 91546 88747 product 95069 M 0 95069
0 5054285337172.jpg 1000 1000 91689 88890 product 95212 M 0 95212
0 5054285358405.jpg 1000 1000 91944 89141 product 95467 M 0 95467