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 (
    94625, 94624, 94623, 94622, 94621, 94620, 
    94619, 94618, 94617, 94616, 94615, 
    94614, 94613, 94612, 94611, 94610, 
    94609, 94608, 94607, 94606, 94605, 
    94604, 94603, 94602, 94601, 94600, 
    94599, 94598, 94597, 94596, 94595, 
    94594, 94593, 95222, 95221, 95220, 
    95219, 94863, 94862, 94697
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00072

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 5054285694596.jpg 1000 1000 97481 94593 product 101004 M 0 101004
0 5054285694596_cumj-7l.jpg 1000 1000 97482 94594 product 101005 M 0 101005
0 5054285694596_886m-k5.jpg 1000 1000 97483 94595 product 101006 M 0 101006
0 5054285694596_6upv-zr.jpg 1000 1000 97484 94596 product 101007 M 0 101007
0 5054285694596_yzsb-fk.jpg 1000 1000 97485 94597 product 101008 M 0 101008
0 5054285694596_we4f-s6.jpg 1000 1000 97486 94598 product 101009 M 0 101009
0 5054285694596_uf2d-fx.jpg 1000 1000 97487 94599 product 101010 M 0 101010
0 5054285694596_wooo-kq.jpg 1000 1000 97488 94600 product 101011 M 0 101011
0 5054285694596_940k-ha.jpg 1000 1000 97489 94601 product 101012 M 0 101012
0 5054285694596_frm8-tx.jpg 1000 1000 97490 94602 product 101013 M 0 101013
0 5054285694596_dmjd-3c.jpg 1000 1000 97491 94603 product 101014 M 0 101014
0 5054285694596_35m8-99.jpg 1000 1000 97492 94604 product 101015 M 0 101015
0 5054285694596_o7i0-y9.jpg 1000 1000 97493 94605 product 101016 M 0 101016
0 5054285694596_iyj8-4y.jpg 1000 1000 97494 94606 product 101017 M 0 101017
0 5054285694596_xn7b-ta.jpg 1000 1000 97495 94607 product 101018 M 0 101018
0 5054285694596_0hn2-7f.jpg 1000 1000 97496 94608 product 101019 M 0 101019
0 5054285694596_du6d-pf.jpg 1000 1000 97497 94609 product 101020 M 0 101020
0 5054285694596_u16p-x1.jpg 1000 1000 97498 94610 product 101021 M 0 101021
0 5054285694596_0gi0-6h.jpg 1000 1000 97499 94611 product 101022 M 0 101022
0 5054285694596_xvji-kh.jpg 1000 1000 97500 94612 product 101023 M 0 101023
0 5054285694596_274k-hq.jpg 1000 1000 97501 94613 product 101024 M 0 101024
0 5054285694596_j3dj-6o.jpg 1000 1000 97502 94614 product 101025 M 0 101025
0 5054285694596_inqc-cr.jpg 1000 1000 97503 94615 product 101026 M 0 101026
0 5054285694596_oeyz-zk.jpg 1000 1000 97504 94616 product 101027 M 0 101027
0 5054285694596_1515-76.jpg 1000 1000 97505 94617 product 101028 M 0 101028
0 5054285694596_h192-ub.jpg 1000 1000 97506 94618 product 101029 M 0 101029
0 5054285694596_4y77-7b.jpg 1000 1000 97507 94619 product 101030 M 0 101030
0 5054285694596_vd6g-xi.jpg 1000 1000 97508 94620 product 101031 M 0 101031
0 5054285694596_ofwt-hr.jpg 1000 1000 97509 94621 product 101032 M 0 101032
0 5054285694596_pqq2-9w.jpg 1000 1000 97510 94622 product 101033 M 0 101033
0 5054285694596_qpdg-6t.jpg 1000 1000 97511 94623 product 101034 M 0 101034
0 5054285694596_0s35-7v.jpg 1000 1000 97512 94624 product 101035 M 0 101035
0 5054285694596_b2uo-ih.jpg 1000 1000 97513 94625 product 101036 M 0 101036
0 5054285808054_6j9r-h2.jpg 1000 1000 97585 94697 product 101108 M 0 101108
0 5054285820520.jpg 1000 1000 97754 94862 product 101277 M 0 101277
0 5054285820520_mxeh-57.jpg 1000 1000 97755 94863 product 101278 M 0 101278
0 5054285856178.jpg 1000 1000 98115 95219 product 101638 M 0 101638
0 5054285856178_8j7c-tw.jpg 1000 1000 98116 95220 product 101639 M 0 101639
0 5054285856178_rile-ry.jpg 1000 1000 98117 95221 product 101640 M 0 101640
0 5054285856178_ptae-vf.jpg 1000 1000 98118 95222 product 101641 M 0 101641