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 (
    112329, 112328, 112327, 112321, 112287, 
    112286, 112285, 112284, 112283, 112282, 
    112281, 112280, 112279, 112278, 112277, 
    112276, 112275, 112274, 112273, 112272
  ) 
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 20 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 5054287008971_lcip-yb.jpg 1400 1400 115441 112272 product 118964 M 0 118964
0 5054287008971_b9qu-58.jpg 1400 1400 115442 112273 product 118965 M 0 118965
0 5054287008971_t4xs-ln.jpg 1400 1400 115443 112274 product 118966 M 0 118966
0 5054287008971_z3hd-5r.jpg 1400 1400 115444 112275 product 118967 M 0 118967
0 5054287008971_ncl1-bt.jpg 1400 1400 115445 112276 product 118968 M 0 118968
0 5054287008971_jzf4-51.jpg 1400 1400 115446 112277 product 118969 M 0 118969
0 5054287008971_isfo-lt.jpg 1400 1400 115447 112278 product 118970 M 0 118970
0 5054287008971_y6h0-gf.jpg 1400 1400 115448 112279 product 118971 M 0 118971
0 5054287008971_io61-7a.jpg 1400 1400 115449 112280 product 118972 M 0 118972
0 5054287008971_c05e-pt.jpg 1400 1400 115450 112281 product 118973 M 0 118973
0 5054287008971_858i-2f.jpg 1400 1400 115451 112282 product 118974 M 0 118974
0 5054287008971_gmfy-m6.jpg 1400 1400 115452 112283 product 118975 M 0 118975
0 5054287008971_wqmh-bb.jpg 1400 1400 115453 112284 product 118976 M 0 118976
0 5054287008971_qv92-eu.jpg 1400 1400 115454 112285 product 118977 M 0 118977
0 5054287008971_3z61-o6.jpg 1400 1400 115455 112286 product 118978 M 0 118978
0 5054287008971_sd96-19.jpg 1400 1400 115456 112287 product 118979 M 0 118979
0 5054287009732_9n26-o7.jpg 1400 1400 115490 112321 product 119013 M 0 119013
0 5054287009732_7fgo-id.jpg 1400 1400 115496 112327 product 119019 M 0 119019
0 5054287009732_uzbk-ed.jpg 1400 1400 115497 112328 product 119020 M 0 119020
0 5054287009732_nqfj-z3.jpg 1400 1400 115498 112329 product 119021 M 0 119021