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 (
    94742, 94741, 94740, 94739, 94738, 94737, 
    94736, 94735, 94734, 94733, 94732, 
    94731, 94730, 94729, 94728, 94727, 
    95619, 95618, 95617, 95616, 95615, 
    95614, 95613, 95612, 95611, 95610, 
    95609, 95608, 95607, 95606, 95605, 
    95604, 95603, 95602, 95601, 95600, 
    95599, 95598, 95597, 95596
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00106

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 5054285623213.jpg 1000 1000 97615 94727 product 101138 M 0 101138
0 5054285623213_wb3d-o1.jpg 1000 1000 97616 94728 product 101139 M 0 101139
0 5054285623213_jb7g-fv.jpg 1000 1000 97617 94729 product 101140 M 0 101140
0 5054285623213_6tck-5u.jpg 1000 1000 97618 94730 product 101141 M 0 101141
0 5054285623213_mvq5-s6.jpg 1000 1000 97619 94731 product 101142 M 0 101142
0 5054285623213_o3os-1z.jpg 1000 1000 97620 94732 product 101143 M 0 101143
0 5054285623213_p415-89.jpg 1000 1000 97621 94733 product 101144 M 0 101144
0 5054285623213_0muc-lj.jpg 1000 1000 97622 94734 product 101145 M 0 101145
0 5054285623213_2oew-c4.jpg 1000 1000 97623 94735 product 101146 M 0 101146
0 5054285623213_5fqb-rp.jpg 1000 1000 97624 94736 product 101147 M 0 101147
0 5054285623213_rnx3-m4.jpg 1000 1000 97625 94737 product 101148 M 0 101148
0 5054285623213_h7sd-ot.jpg 1000 1000 97626 94738 product 101149 M 0 101149
0 5054285623213_7r18-5h.jpg 1000 1000 97627 94739 product 101150 M 0 101150
0 5054285623213_1ftl-g5.jpg 1000 1000 97628 94740 product 101151 M 0 101151
0 5054285623213_ha8f-dw.jpg 1000 1000 97629 94741 product 101152 M 0 101152
0 5054285623213_o6ya-p4.jpg 1000 1000 97630 94742 product 101153 M 0 101153
0 5054285880173_fv6i-2u.jpg 1000 1000 98518 95596 product 102041 M 0 102041
0 5054285880173_d951-bf.jpg 1000 1000 98519 95597 product 102042 M 0 102042
0 5054285880173_9yes-38.jpg 1000 1000 98520 95598 product 102043 M 0 102043
0 5054285880173_j1ub-er.jpg 1000 1000 98521 95599 product 102044 M 0 102044
0 5054285880173_he97-5w.jpg 1000 1000 98522 95600 product 102045 M 0 102045
0 5054285880173_zvym-5b.jpg 1000 1000 98523 95601 product 102046 M 0 102046
0 5054285880173_dfqf-gb.jpg 1000 1000 98524 95602 product 102047 M 0 102047
0 5054285880173_g78f-bz.jpg 1000 1000 98525 95603 product 102048 M 0 102048
0 5054285880173_ibb4-ve.jpg 1000 1000 98526 95604 product 102049 M 0 102049
0 5054285880173_klbx-rp.jpg 1000 1000 98527 95605 product 102050 M 0 102050
0 5054285880173_cw0w-mf.jpg 1000 1000 98528 95606 product 102051 M 0 102051
0 5054285880173_vigk-7l.jpg 1000 1000 98529 95607 product 102052 M 0 102052
0 5054285880173_2aqw-ua.jpg 1000 1000 98530 95608 product 102053 M 0 102053
0 5054285880173_jlru-4d.jpg 1000 1000 98531 95609 product 102054 M 0 102054
0 5054285880173_4h53-cm.jpg 1000 1000 98532 95610 product 102055 M 0 102055
0 5054285880173_pyea-hb.jpg 1000 1000 98533 95611 product 102056 M 0 102056
0 5054285880173_gswa-3h.jpg 1000 1000 98534 95612 product 102057 M 0 102057
0 5054285880173_8dr5-fw.jpg 1000 1000 98535 95613 product 102058 M 0 102058
0 5054285880173_9j9b-uf.jpg 1000 1000 98536 95614 product 102059 M 0 102059
0 5054285880173_b6zd-z1.jpg 1000 1000 98537 95615 product 102060 M 0 102060
0 5054285880173_kx90-c7.jpg 1000 1000 98538 95616 product 102061 M 0 102061
0 5054285880173_awqx-h6.jpg 1000 1000 98539 95617 product 102062 M 0 102062
0 5054285880173_lzvv-aa.jpg 1000 1000 98540 95618 product 102063 M 0 102063
0 5054285880173_4cb9-7q.jpg 1000 1000 98541 95619 product 102064 M 0 102064