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 (
    89261, 89260, 89259, 89258, 89257, 89256, 
    89255, 89254, 89253, 89252, 89251, 
    89250, 89249, 89248, 89247, 89246, 
    89245, 89244, 89243, 89242, 89241, 
    89240, 89239, 89791, 89790, 89789, 
    89788, 89787, 89786, 89526, 89525, 
    89524, 89502, 89501, 89500, 89499, 
    89218, 89217, 89593, 89592
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00071

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 5054285366233.jpg 1000 1000 92020 89217 product 95543 M 0 95543
0 5054285366233_sc4n-mr.jpg 1000 1000 92021 89218 product 95544 M 0 95544
0 5054285355824.jpg 1000 1000 92042 89239 product 95565 M 0 95565
0 5054285355824_dy10-0q.jpg 1000 1000 92043 89240 product 95566 M 0 95566
0 5054285355824_tdoz-tk.jpg 1000 1000 92044 89241 product 95567 M 0 95567
0 5054285355824_vw4f-24.jpg 1000 1000 92045 89242 product 95568 M 0 95568
0 5054285355824_wsf4-4x.jpg 1000 1000 92046 89243 product 95569 M 0 95569
0 5054285355824_n16b-en.jpg 1000 1000 92047 89244 product 95570 M 0 95570
0 5054285355824_z6qw-9w.jpg 1000 1000 92048 89245 product 95571 M 0 95571
0 5054285355824_xbwz-sm.jpg 1000 1000 92049 89246 product 95572 M 0 95572
0 5054285355824_lx1w-70.jpg 1000 1000 92050 89247 product 95573 M 0 95573
0 5054285355824_v7f3-u0.jpg 1000 1000 92051 89248 product 95574 M 0 95574
0 5054285355824_o08o-n0.jpg 1000 1000 92052 89249 product 95575 M 0 95575
0 5054285355824_sswd-c8.jpg 1000 1000 92053 89250 product 95576 M 0 95576
0 5054285355824_wv52-ev.jpg 1000 1000 92054 89251 product 95577 M 0 95577
0 5054285355824_qljr-p5.jpg 1000 1000 92055 89252 product 95578 M 0 95578
0 5054285355824_96ws-sf.jpg 1000 1000 92056 89253 product 95579 M 0 95579
0 5054285355824_e1z4-h6.jpg 1000 1000 92057 89254 product 95580 M 0 95580
0 5054285355824_st60-lt.jpg 1000 1000 92058 89255 product 95581 M 0 95581
0 5054285355824_jiy6-de.jpg 1000 1000 92059 89256 product 95582 M 0 95582
0 5054285355824_bx4q-9d.jpg 1000 1000 92060 89257 product 95583 M 0 95583
0 5054285355824_4vrp-v6.jpg 1000 1000 92061 89258 product 95584 M 0 95584
0 5054285355824_wkel-ha.jpg 1000 1000 92062 89259 product 95585 M 0 95585
0 5054285355824_u3ch-r9.jpg 1000 1000 92063 89260 product 95586 M 0 95586
0 5054285355824_arja-fi.jpg 1000 1000 92064 89261 product 95587 M 0 95587
0 5054285391464.jpg 1000 1000 92322 89499 product 95845 M 0 95845
0 5054285391464_rgyx-lo.jpg 1000 1000 92323 89500 product 95846 M 0 95846
0 5054285391464_mhg6-f3.jpg 1000 1000 92324 89501 product 95847 M 0 95847
0 5054285391464_qatd-yp.jpg 1000 1000 92325 89502 product 95848 M 0 95848
0 5054285393956.jpg 1000 1000 92347 89524 product 95870 M 0 95870
0 5054285393956_4a47-ra.jpg 1000 1000 92348 89525 product 95871 M 0 95871
0 5054285393956_y3jy-co.jpg 1000 1000 92349 89526 product 95872 M 0 95872
0 5054285398807_80za-ku.jpg 1000 1000 92415 89592 product 95938 M 0 95938
0 5054285398807_rhhz-4z.jpg 1000 1000 92416 89593 product 95939 M 0 95939
0 5054285417126.jpg 1000 1000 92610 89786 product 96133 M 0 96133
0 5054285417126_050e-br.jpg 1000 1000 92611 89787 product 96134 M 0 96134
0 5054285417126_jqk6-bb.jpg 1000 1000 92612 89788 product 96135 M 0 96135
0 5054285417126_xn9y-s1.jpg 1000 1000 92613 89789 product 96136 M 0 96136
0 5054285417126_t39o-do.jpg 1000 1000 92614 89790 product 96137 M 0 96137
0 5054285417126_2dtr-x2.jpg 1000 1000 92615 89791 product 96138 M 0 96138