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 (
    84384, 84362, 84686, 84650, 84666, 84450, 
    84224, 84570, 84398, 84462, 84460, 
    84459, 84486, 84427, 84426, 84425, 
    84424, 84423, 84422, 84421
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00045

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 5054284901145.jpg 1000 1000 87146 84224 product 90669 M 0 90669
0 5054284585635_ogz0-u5.jpg 1000 1000 87286 84362 product 90809 M 0 90809
0 5054284901183.jpg 1000 1000 87308 84384 product 90831 M 0 90831
0 5054284914602.jpg 1000 1000 87322 84398 product 90845 M 0 90845
0 5054284933016_m3od-eg.jpg 1000 1000 87345 84421 product 90868 M 0 90868
0 5054284933016_qbqb-fa.jpg 1000 1000 87346 84422 product 90869 M 0 90869
0 5054284933016_eg2s-xz.jpg 1000 1000 87347 84423 product 90870 M 0 90870
0 5054284933016_75fl-fs.jpg 1000 1000 87348 84424 product 90871 M 0 90871
0 5054284933016_f7pv-t5.jpg 1000 1000 87349 84425 product 90872 M 0 90872
0 5054284933016_wg8k-tn.jpg 1000 1000 87350 84426 product 90873 M 0 90873
0 5054284933016_1kyr-ve.jpg 1000 1000 87351 84427 product 90874 M 0 90874
0 5054284929248.jpg 1000 1000 87374 84450 product 90897 M 0 90897
0 5054284940861.jpg 1000 1000 87383 84459 product 90906 M 0 90906
0 5054284940861_tx3e-12.jpg 1000 1000 87384 84460 product 90907 M 0 90907
0 5054284940861_i0j2-l5.jpg 1000 1000 87386 84462 product 90909 M 0 90909
0 5054284940793.jpg 1000 1000 87410 84486 product 90933 M 0 90933
0 5054284960531.jpg 1000 1000 87494 84570 product 91017 M 0 91017
0 5054284968797.jpg 1000 1000 87574 84650 product 91097 M 0 91097
0 5054284974590.jpg 1000 1000 87590 84666 product 91113 M 0 91113
0 5054284968896.jpg 1000 1000 87610 84686 product 91133 M 0 91133