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 (
    95076, 94797, 94796, 94795, 94794, 94793, 
    94791, 94790, 94789, 94788, 94787, 
    94786, 94785, 94784, 94783, 94782, 
    94781, 94780, 94779, 94778, 96126, 
    96125, 96124, 96123, 96122, 95224, 
    94769, 94768, 94767, 94765, 94764, 
    94763, 94762, 94761, 94754, 94753, 
    94746, 94745, 94744, 94743
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00092

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_f6fx-xv.jpg 1000 1000 97631 94743 product 101154 M 0 101154
0 5054285623213_r1jl-k3.jpg 1000 1000 97632 94744 product 101155 M 0 101155
0 5054285623213_7cck-rn.jpg 1000 1000 97633 94745 product 101156 M 0 101156
0 5054285623213_yrys-52.jpg 1000 1000 97634 94746 product 101157 M 0 101157
0 5054285802755.jpg 1000 1000 97641 94753 product 101164 M 0 101164
0 5054285798270.jpg 1000 1000 97642 94754 product 101165 M 0 101165
0 5054285567302.jpg 1000 1000 97649 94761 product 101172 M 0 101172
0 5054285567302_i3rr-hd.jpg 1000 1000 97650 94762 product 101173 M 0 101173
0 5054285567302_655b-mq.jpg 1000 1000 97651 94763 product 101174 M 0 101174
0 5054285567302_s53c-eg.jpg 1000 1000 97652 94764 product 101175 M 0 101175
0 5054285567302_4kfa-mx.jpg 1000 1000 97653 94765 product 101176 M 0 101176
0 5054285801826.jpg 1000 1000 97655 94767 product 101178 M 0 101178
0 5054285801826_nvcc-hs.jpg 1000 1000 97656 94768 product 101179 M 0 101179
0 5054285798317.jpg 1000 1000 97657 94769 product 101180 M 0 101180
0 5054285573624.jpg 1000 1000 97666 94778 product 101189 M 0 101189
0 5054285573624_woio-l3.jpg 1000 1000 97667 94779 product 101190 M 0 101190
0 5054285573624_vb5o-kf.jpg 1000 1000 97668 94780 product 101191 M 0 101191
0 5054285573624_1jk2-9r.jpg 1000 1000 97669 94781 product 101192 M 0 101192
0 5054285573624_x8iu-li.jpg 1000 1000 97670 94782 product 101193 M 0 101193
0 5054285573624_oduz-hn.jpg 1000 1000 97671 94783 product 101194 M 0 101194
0 5054285573624_d2e7-3l.jpg 1000 1000 97672 94784 product 101195 M 0 101195
0 5054285573624_jldv-ii.jpg 1000 1000 97673 94785 product 101196 M 0 101196
0 5054285573624_g7uj-9a.jpg 1000 1000 97674 94786 product 101197 M 0 101197
0 5054285573624_nyab-bb.jpg 1000 1000 97675 94787 product 101198 M 0 101198
0 5054285573624_zsnb-x7.jpg 1000 1000 97676 94788 product 101199 M 0 101199
0 5054285573624_dxoo-5e.jpg 1000 1000 97677 94789 product 101200 M 0 101200
0 5054285573624_rjv3-dw.jpg 1000 1000 97678 94790 product 101201 M 0 101201
0 5054285573624_v8to-vj.jpg 1000 1000 97679 94791 product 101202 M 0 101202
0 5054285551974.jpg 1000 1000 97681 94793 product 101204 M 0 101204
0 5054285551974_skx8-mg.jpg 1000 1000 97682 94794 product 101205 M 0 101205
0 5054285551974_fj9z-hq.jpg 1000 1000 97683 94795 product 101206 M 0 101206
0 5054285755785.jpg 1000 1000 97684 94796 product 101207 M 0 101207
0 5054285755785_itji-pb.jpg 1000 1000 97685 94797 product 101208 M 0 101208
0 5054285840924.jpg 1000 1000 97968 95076 product 101491 M 0 101491
0 5028386717331.jpg 1000 1000 98120 95224 product 101643 M 0 101643
0 5054285906071.jpg 1000 1000 99098 96122 product 102621 M 0 102621
0 5054285906071_it8i-7f.jpg 1000 1000 99099 96123 product 102622 M 0 102622
0 5054285906071_tvue-un.jpg 1000 1000 99100 96124 product 102623 M 0 102623
0 5054285906071_0qr9-x4.jpg 1000 1000 99101 96125 product 102624 M 0 102624
0 5054285906071_ycjn-p5.jpg 1000 1000 99102 96126 product 102625 M 0 102625