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 (
    88461, 88412, 88396, 89357, 89198, 88514, 
    88484, 88483, 88482, 88463, 88462, 
    89197, 89196, 89013, 89012, 89011, 
    88992, 88991, 88990, 88989, 88988, 
    88987, 88986, 88985, 88984, 88983, 
    88982, 88952, 88951, 88950, 88949, 
    88948, 88947, 88946, 88841, 88840, 
    88831, 88830, 88829, 88828
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00078

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 40 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 5054285228821_5df8-xx.jpg 1000 1000 91194 88396 product 94717 M 0 94717
0 5054285300770.jpg 1000 1000 91210 88412 product 94733 M 0 94733
0 5054285325742.jpg 1400 1400 91259 88461 product 94782 M 0 94782
0 5054285296516.jpg 1000 1000 91260 88462 product 94783 M 0 94783
0 5054285296516_s14d-7g.jpg 1000 1000 91261 88463 product 94784 M 0 94784
0 5054285272824.jpg 1000 1000 91280 88482 product 94803 M 0 94803
0 5054285272824_3fp0-jk.jpg 1000 1000 91281 88483 product 94804 M 0 94804
0 5054285272824_s5hv-px.jpg 1000 1000 91282 88484 product 94805 M 0 94805
0 5054285289709.jpg 1000 1000 91312 88514 product 94835 M 0 94835
0 5054285325810_nj23-p1.jpg 1000 1000 91627 88828 product 95150 M 0 95150
0 5054285325810_euez-xe.jpg 1000 1000 91628 88829 product 95151 M 0 95151
0 5054285325810_0nul-4i.jpg 1000 1000 91629 88830 product 95152 M 0 95152
0 5054285325810_5xdw-5u.jpg 1000 1000 91630 88831 product 95153 M 0 95153
0 5054285325810_t6og-sz.jpg 1000 1000 91639 88840 product 95162 M 0 95162
0 5054285325810_z7po-18.jpg 1000 1000 91640 88841 product 95163 M 0 95163
0 5054285344828.jpg 1000 1000 91747 88946 product 95270 M 0 95270
0 5054285344828_1qws-ji.jpg 1000 1000 91748 88947 product 95271 M 0 95271
0 5054285344828_i6pf-xu.jpg 1000 1000 91749 88948 product 95272 M 0 95272
0 5054285344828_bp02-3t.jpg 1000 1000 91750 88949 product 95273 M 0 95273
0 5054285339220.jpg 1000 1000 91751 88950 product 95274 M 0 95274
0 5054285339220_tbh0-oq.jpg 1000 1000 91752 88951 product 95275 M 0 95275
0 5054285339220_1ygz-as.jpg 1000 1000 91753 88952 product 95276 M 0 95276
0 5054285347201.jpg 1000 1000 91783 88982 product 95306 M 0 95306
0 5054285347201_sr7d-lq.jpg 1000 1000 91784 88983 product 95307 M 0 95307
0 5054285347201_ol6k-j9.jpg 1000 1000 91785 88984 product 95308 M 0 95308
0 5054285347201_u3xa-he.jpg 1000 1000 91786 88985 product 95309 M 0 95309
0 5054285347201_hhel-dg.jpg 1000 1000 91787 88986 product 95310 M 0 95310
0 5054285347201_4de6-yo.jpg 1000 1000 91788 88987 product 95311 M 0 95311
0 5054285347201_s0fo-tt.jpg 1000 1000 91789 88988 product 95312 M 0 95312
0 5054285347201_hiz4-e6.jpg 1000 1000 91790 88989 product 95313 M 0 95313
0 5054285347201_ad7z-au.jpg 1000 1000 91791 88990 product 95314 M 0 95314
0 5054285347218.jpg 1000 1000 91792 88991 product 95315 M 0 95315
0 5054285347218_rf12-wa.jpg 1000 1000 91793 88992 product 95316 M 0 95316
0 5054285349311.jpg 1000 1000 91813 89011 product 95336 M 0 95336
0 5054285349311_40ba-5b.jpg 1000 1000 91814 89012 product 95337 M 0 95337
0 5054285349311_eqxw-va.jpg 1000 1000 91815 89013 product 95338 M 0 95338
0 5054285359013.jpg 1000 1000 91999 89196 product 95522 M 0 95522
0 5054285359013_pfgz-1k.jpg 1000 1000 92000 89197 product 95523 M 0 95523
0 5054285360170.jpg 1000 1000 92001 89198 product 95524 M 0 95524
0 5028386715931.jpg 1000 1000 92165 89357 product 95688 M 0 95688