SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  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 = 'A' 
  AND cscart_images_links.object_id = 3320 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00068

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_images_links ref object_id object_id 81 const,const,const 4 Using index condition; Using where; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_id 1 Using where
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 mahm3t_cs443.cscart_images.image_id,const,const 1 Using where

Result

pair_id object_id object_type image_id detailed_id type position emo_md5 image_path alt image_x image_y images_image_id
28580 3320 product 0 24155 A 0 atr_mua_001_y04j-de.jpg 720 960 24155
28581 3320 product 0 24156 A 1 atr_mua_002_f3js-o9.jpg 567 570 24156
28583 3320 product 0 24158 A 2 Kids_MIR-preview.jpg 2000 1500 24158
28582 3320 product 0 24157 A 3 markiza_zewnetrzna_do_okien_dachowych_przeciwsloneczna_MIA_RoofLITE_na_okna_na_poddasze.jpg 1500 1500 24157
28584 3320 product 0 24159 A 4 markiza-roto-mir-do-okien-dachowych-8.jpg 933 700 24159
28585 3320 product 0 24160 A 5 markiza-roto-mir-do-okien-dachowych-6.jpg 933 700 24160
31316 3320 product 0 26894 A 6 markiza-roto-mir-do-okien-dachowych-14.jpg 933 700 26894
31317 3320 product 0 26895 A 7 markiza-roto-mir-do-okien-dachowych-1.jpg 933 700 26895
31318 3320 product 0 26896 A 8 markiza-rooflite-2.jpg 922 691 26896
31319 3320 product 0 26897 A 9 markiza-roto-mir-do-okien-dachowych-17.jpg 933 700 26897
31320 3320 product 0 26898 A 10 markiza-roto-mir-do-okien-dachowych-15.jpg 933 700 26898