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 (
    94587, 94054, 94053, 94006, 94509, 94508, 
    94481, 94479, 94478, 94265, 94269, 
    98604, 93778, 93573, 94107, 94003, 
    93779, 93367, 93366, 93365
  ) 
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 5054285607138_t1v6-v4.jpg 1000 1000 96236 93365 product 99759 M 0 99759
0 5054285607138_9ksb-x8.jpg 1000 1000 96237 93366 product 99760 M 0 99760
0 5054285607138_fzjt-0d.jpg 1000 1000 96238 93367 product 99761 M 0 99761
0 5054285644744.jpg 1400 1400 96448 93573 product 99971 M 0 99971
0 5054285726617.jpg 1000 1000 96657 93778 product 100180 M 0 100180
0 5054285726389.jpg 1000 1000 96658 93779 product 100181 M 0 100181
0 5054285749500.jpg 1000 1000 96881 94003 product 100404 M 0 100404
0 5054285721599.jpg 1000 1000 96886 94006 product 100409 M 0 100409
0 5054285734506_hqqi-1q.jpg 1000 1000 96933 94053 product 100456 M 0 100456
0 5054285734506_bnoq-9t.jpg 1000 1000 96934 94054 product 100457 M 0 100457
0 5054285759288.jpg 1000 1000 96987 94107 product 100510 M 0 100510
0 5054285768990.jpg 1000 1000 97145 94265 product 100668 M 0 100668
0 5054285768686.jpg 1000 1000 97149 94269 product 100672 M 0 100672
0 5054285787373.jpg 1000 1000 97364 94478 product 100887 M 0 100887
0 5054285787373_ih2m-yz.jpg 1000 1000 97365 94479 product 100888 M 0 100888
0 5054285787977.jpg 1000 1000 97368 94481 product 100891 M 0 100891
0 5054285787700.jpg 1000 1000 97395 94508 product 100918 M 0 100918
0 5054285787700_dwbu-su.jpg 1000 1000 97396 94509 product 100919 M 0 100919
0 5054285800461.jpg 1000 1000 97475 94587 product 100998 M 0 100998
0 Mike_Crawley_-_Cereal_Killer-01.jpg 3553 3550 101643 98604 product 105166 M 0 105166