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 (
    105602, 105601, 106552, 106551, 105974, 
    105973, 105972, 105971, 105595, 105543, 
    106354, 106322, 106192, 106191, 106190, 
    106189, 106188, 106187, 105542, 105505
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00075

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 5054286521884.jpg 1000 1000 108635 105505 product 112158 M 0 112158
0 5054286544517.jpg 1000 1000 108676 105542 product 112199 M 0 112199
0 5054286543343.jpg 1000 1000 108677 105543 product 112200 M 0 112200
0 5054286432098.jpg 1000 1000 108729 105595 product 112252 M 0 112252
0 5054286503026.jpg 1000 1000 108735 105601 product 112258 M 0 112258
0 5054286503026_zq5f-9a.jpg 1000 1000 108736 105602 product 112259 M 0 112259
0 5054286565710.jpg 1000 1000 109105 105971 product 112628 M 0 112628
0 5054286565710_fw2t-ir.jpg 1000 1000 109106 105972 product 112629 M 0 112629
0 5054286565710_ooqb-qq.jpg 1000 1000 109107 105973 product 112630 M 0 112630
0 5054286565710_8jwb-02.jpg 1000 1000 109108 105974 product 112631 M 0 112631
0 5054286489009.jpg 1000 1000 109323 106187 product 112846 M 0 112846
0 5054286489009_1e5j-td.jpg 1000 1000 109324 106188 product 112847 M 0 112847
0 5054286489009_je4c-mg.jpg 1000 1000 109325 106189 product 112848 M 0 112848
0 5054286489009_bpra-a5.jpg 1000 1000 109326 106190 product 112849 M 0 112849
0 5054286489009_sp5s-cz.jpg 1000 1000 109327 106191 product 112850 M 0 112850
0 5054286489009_fhy4-4f.jpg 1000 1000 109328 106192 product 112851 M 0 112851
0 5054286606307.jpg 1000 1000 109458 106322 product 112981 M 0 112981
0 5054286606338.jpg 1000 1000 109490 106354 product 113013 M 0 113013
0 5054286581147.jpg 1000 1000 109688 106551 product 113211 M 0 113211
0 5054286581147_x1db-6c.jpg 1000 1000 109689 106552 product 113212 M 0 113212