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 (
    86692, 86670, 86611, 86610, 86609, 86608, 
    87120, 86648, 87460, 87459, 87458, 
    87112, 86644, 86643, 86541, 87352, 
    87351, 87350, 87349, 87348, 87347, 
    87346, 87345, 87344, 87343, 87342, 
    87341, 87240, 87239, 87238, 87237, 
    87236, 87235, 87234, 87233, 87232, 
    87231, 87230, 87229, 87228
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00097

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 5054285103760.jpg 1000 1000 89273 86541 product 92796 M 0 92796
0 5054285138700.jpg 1000 1000 89341 86608 product 92864 M 0 92864
0 5054285138700_61da-1e.jpg 1000 1000 89342 86609 product 92865 M 0 92865
0 5054285138700_riwc-65.jpg 1000 1000 89343 86610 product 92866 M 0 92866
0 5054285138700_eia0-l4.jpg 1000 1000 89344 86611 product 92867 M 0 92867
0 5054285143117.jpg 1000 1000 89376 86643 product 92899 M 0 92899
0 5054285143117_ezx3-y2.jpg 1000 1000 89377 86644 product 92900 M 0 92900
0 5054285103777.jpg 1000 1000 89381 86648 product 92904 M 0 92904
0 5054285106341.jpg 1000 1000 89403 86670 product 92926 M 0 92926
0 5054285091142.jpg 1000 1000 89425 86692 product 92948 M 0 92948
0 5054285170304.jpg 1000 1000 89867 87112 product 93390 M 0 93390
0 5028386715337.jpg 1000 1000 89875 87120 product 93398 M 0 93398
0 5054285163511_3rjt-kx.jpg 1000 1000 89983 87228 product 93506 M 0 93506
0 5054285163511_dusj-39.jpg 1000 1000 89984 87229 product 93507 M 0 93507
0 5054285163511_4evq-br.jpg 1000 1000 89985 87230 product 93508 M 0 93508
0 5054285163511_ut10-f7.jpg 1000 1000 89986 87231 product 93509 M 0 93509
0 5054285163511_pmp4-hq.jpg 1000 1000 89987 87232 product 93510 M 0 93510
0 5054285163511_pjd9-ea.jpg 1000 1000 89988 87233 product 93511 M 0 93511
0 5054285163511_027z-vu.jpg 1000 1000 89989 87234 product 93512 M 0 93512
0 5054285163511_nd93-40.jpg 1000 1000 89990 87235 product 93513 M 0 93513
0 5054285163511_hmxv-kj.jpg 1000 1000 89991 87236 product 93514 M 0 93514
0 5054285163511_qjj8-1t.jpg 1000 1000 89992 87237 product 93515 M 0 93515
0 5054285163511_2xtg-u1.jpg 1000 1000 89993 87238 product 93516 M 0 93516
0 5054285163511_7ybh-rv.jpg 1000 1000 89994 87239 product 93517 M 0 93517
0 5054285163511_m29z-re.jpg 1000 1000 89995 87240 product 93518 M 0 93518
0 5054285197639.jpg 1000 1000 90096 87341 product 93619 M 0 93619
0 5054285197639_anaq-y9.jpg 1000 1000 90097 87342 product 93620 M 0 93620
0 5054285197639_hi4y-jh.jpg 1000 1000 90098 87343 product 93621 M 0 93621
0 5054285197639_g8bd-g4.jpg 1000 1000 90099 87344 product 93622 M 0 93622
0 5054285197639_398t-66.jpg 1000 1000 90100 87345 product 93623 M 0 93623
0 5054285197639_qxkh-gs.jpg 1000 1000 90101 87346 product 93624 M 0 93624
0 5054285197639_epww-yz.jpg 1000 1000 90102 87347 product 93625 M 0 93625
0 5054285197639_bec6-fq.jpg 1000 1000 90103 87348 product 93626 M 0 93626
0 5054285197639_t2bn-kw.jpg 1000 1000 90104 87349 product 93627 M 0 93627
0 5054285197639_f64n-15.jpg 1000 1000 90105 87350 product 93628 M 0 93628
0 5054285197639_qcqn-0q.jpg 1000 1000 90106 87351 product 93629 M 0 93629
0 5054285197639_jg3z-z9.jpg 1000 1000 90107 87352 product 93630 M 0 93630
0 5054285138694.jpg 1000 1000 90213 87458 product 93736 M 0 93736
0 5054285138694_yapi-xy.jpg 1000 1000 90214 87459 product 93737 M 0 93737
0 5054285138694_kyqf-wk.jpg 1000 1000 90215 87460 product 93738 M 0 93738