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 (
    93232, 1645, 93574, 93526, 93067, 93064, 
    93063, 93003, 93002, 93001, 93000, 
    92999, 92998, 92997, 92996, 92995, 
    92994, 92993, 92992, 92991
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00070

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 twistedtraxx_hzya-6b.png 263 263 72249 1645 product 75772 M 0 75772
0 5054285441435_qzse-33.jpg 1000 1000 95855 92991 product 99378 M 0 99378
0 5054285441435_hn0m-dq.jpg 1000 1000 95856 92992 product 99379 M 0 99379
0 5054285441435_c3ji-ex.jpg 1000 1000 95857 92993 product 99380 M 0 99380
0 5054285441435_kaqx-ss.jpg 1000 1000 95858 92994 product 99381 M 0 99381
0 5054285441435_kl8h-ig.jpg 1000 1000 95859 92995 product 99382 M 0 99382
0 5054285441435_pcvs-0r.jpg 1000 1000 95860 92996 product 99383 M 0 99383
0 5054285441435_pt7u-97.jpg 1000 1000 95861 92997 product 99384 M 0 99384
0 5054285441435_8vvj-dt.jpg 1000 1000 95862 92998 product 99385 M 0 99385
0 5054285441435_a99l-vr.jpg 1000 1000 95863 92999 product 99386 M 0 99386
0 5054285441435_etnk-2o.jpg 1000 1000 95864 93000 product 99387 M 0 99387
0 5054285441435_p2tg-qy.jpg 1000 1000 95865 93001 product 99388 M 0 99388
0 5054285441435_hwon-z6.jpg 1000 1000 95866 93002 product 99389 M 0 99389
0 5054285441435_5pu5-r5.jpg 1000 1000 95867 93003 product 99390 M 0 99390
0 5054285545966_gh61-zw.jpg 1000 1000 95930 93063 product 99453 M 0 99453
0 5054285545966_owch-xo.jpg 1000 1000 95931 93064 product 99454 M 0 99454
0 5054285626580.jpg 1000 1000 95934 93067 product 99457 M 0 99457
0 5054285632055.jpg 1000 1000 96101 93232 product 99624 M 0 99624
0 5054285707807.jpg 1000 1000 96401 93526 product 99924 M 0 99924
0 5054285713464.jpg 1000 1000 96449 93574 product 99972 M 0 99972