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 (
    88722, 88721, 88720, 88719, 88718, 88717, 
    88716, 88715, 88714, 88713, 88712, 
    88711, 88710, 88709, 88708, 88707, 
    88706, 89080, 89079, 89078, 88676, 
    88675, 88674, 88920, 88919, 88493, 
    89075, 88916, 88491, 89082, 89030, 
    89029, 89028, 88996, 88995, 88994, 
    88993, 88981, 88520, 88495
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00076

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 5054285315354.jpg 1000 1000 91289 88491 product 94812 M 0 94812
0 5054285317976.jpg 1000 1000 91291 88493 product 94814 M 0 94814
0 5054285248140.jpg 1000 1000 91293 88495 product 94816 M 0 94816
0 5054285310724.jpg 1000 1000 91318 88520 product 94841 M 0 94841
0 5054285266885.jpg 1000 1000 91473 88674 product 94996 M 0 94996
0 5054285266885_frbm-li.jpg 1000 1000 91474 88675 product 94997 M 0 94997
0 5054285284643.jpg 1000 1000 91475 88676 product 94998 M 0 94998
0 5054285248645.jpg 1000 1000 91505 88706 product 95028 M 0 95028
0 5054285248645_ie63-5z.jpg 1000 1000 91506 88707 product 95029 M 0 95029
0 5054285248645_wq9d-ep.jpg 1000 1000 91507 88708 product 95030 M 0 95030
0 5054285318812.jpg 1000 1000 91508 88709 product 95031 M 0 95031
0 5054285318812_4oym-xc.jpg 1000 1000 91509 88710 product 95032 M 0 95032
0 5054285318812_1szl-o0.jpg 1000 1000 91510 88711 product 95033 M 0 95033
0 5054285318812_dcl4-6w.jpg 1000 1000 91511 88712 product 95034 M 0 95034
0 5054285318812_2var-4l.jpg 1000 1000 91512 88713 product 95035 M 0 95035
0 5054285318812_wv3b-qk.jpg 1000 1000 91513 88714 product 95036 M 0 95036
0 5054285318812_hun8-94.jpg 1000 1000 91514 88715 product 95037 M 0 95037
0 5054285318812_ij52-tw.jpg 1000 1000 91515 88716 product 95038 M 0 95038
0 5054285318812_wtcw-pq.jpg 1000 1000 91516 88717 product 95039 M 0 95039
0 5054285318812_fp31-fa.jpg 1000 1000 91517 88718 product 95040 M 0 95040
0 5054285318812_h05o-k6.jpg 1000 1000 91518 88719 product 95041 M 0 95041
0 5054285318812_ggz7-kf.jpg 1000 1000 91519 88720 product 95042 M 0 95042
0 5054285318812_btaw-sh.jpg 1000 1000 91520 88721 product 95043 M 0 95043
0 5054285318812_bvhz-v7.jpg 1000 1000 91521 88722 product 95044 M 0 95044
0 5054285333129.jpg 1000 1000 91715 88916 product 95238 M 0 95238
0 5054285335437.jpg 1000 1000 91718 88919 product 95241 M 0 95241
0 5054285335437_o697-er.jpg 1000 1000 91719 88920 product 95242 M 0 95242
0 5054285347867.jpg 1000 1000 91782 88981 product 95305 M 0 95305
0 5054285347874.jpg 1000 1000 91794 88993 product 95317 M 0 95317
0 5054285347874_e25n-pw.jpg 1000 1000 91795 88994 product 95318 M 0 95318
0 5054285347874_pt8i-32.jpg 1000 1000 91796 88995 product 95319 M 0 95319
0 5054285347874_c32k-5t.jpg 1000 1000 91797 88996 product 95320 M 0 95320
0 5054285349397.jpg 1000 1000 91830 89028 product 95353 M 0 95353
0 5054285349397_mkpm-0o.jpg 1000 1000 91831 89029 product 95354 M 0 95354
0 5054285349397_xkmj-ay.jpg 1000 1000 91832 89030 product 95355 M 0 95355
0 5054285354025.jpg 1000 1000 91877 89075 product 95400 M 0 95400
0 5054285356036.jpg 1000 1000 91880 89078 product 95403 M 0 95403
0 5054285356036_17k2-lc.jpg 1000 1000 91881 89079 product 95404 M 0 95404
0 5054285356036_wdg5-fa.jpg 1000 1000 91882 89080 product 95405 M 0 95405
0 5054285353387.jpg 1000 1000 91884 89082 product 95407 M 0 95407