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 (
    6978, 7272, 7266, 7265, 7096, 7279, 7498, 
    7492, 7491, 7807, 14126, 14115, 7802, 
    7987, 32993, 7997, 7993, 8290, 14266, 
    14265
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00074

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 5052653076098.jpg 1000 1000 6987 6978 product 10510 M 0 10510
0 5052653055550.jpg 1000 1000 7105 7096 product 10628 M 0 10628
0 505265306845113445980385024f0161ffe7.jpg 1000 1000 7274 7265 product 10797 M 0 10797
0 505265306845113445980415024f01921100.jpg 1000 1000 7275 7266 product 10798 M 0 10798
0 5052653070690.jpg 1000 1000 7281 7272 product 10804 M 0 10804
0 5052653061162.jpg 1000 1000 7288 7279 product 10811 M 0 10811
0 5052653046190.jpg 1000 1000 7500 7491 product 11023 M 0 11023
0 505265304619013446639755025f1a72c9fd.jpg 1000 1000 7501 7492 product 11024 M 0 11024
0 505265304619013446640215025f1d5e9382.jpg 1000 1000 7507 7498 product 11030 M 0 11030
0 5052653011341.jpg 1000 1000 7811 7802 product 11334 M 0 11334
0 5052653023498.jpg 1000 1000 7816 7807 product 11339 M 0 11339
0 5052653010580134483489150288d4bb6588.jpg 1000 1000 7998 7987 product 11521 M 0 11521
0 5055274106601134483502450288dd0cf51f.jpg 1000 1000 8004 7993 product 11527 M 0 11527
0 5055274106601134483507050288dfe79c93.jpg 1000 1000 8008 7997 product 11531 M 0 11531
0 5055274099255.jpg 1000 1000 8301 8290 product 11824 M 0 11824
0 502537551360813614232285125ab7c1a7ef.jpg 1000 1000 14128 14115 product 17651 M 0 17651
0 502537551360813614232475125ab8f85a11.jpg 1000 1000 14139 14126 product 17662 M 0 17662
0 502537551327113614247615125b1796d920.jpg 1000 1000 14278 14265 product 17801 M 0 17801
0 502537551327113614247635125b17b2385d.jpg 1000 1000 14279 14266 product 17802 M 0 17802
0 5052653010801_p66f-10.jpg 1000 1000 33010 32993 product 36533 M 0 36533