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.image_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 = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    23288, 
    23289, 
    24187, 
    24184, 
    24185, 
    24186, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    24188, 
    24189, 
    24190, 
    24191, 
    15153, 
    15154, 
    15156, 
    23234, 
    23233, 
    23235, 
    23236, 
    23237, 
    23238, 
    15718, 
    15719, 
    15720, 
    15721, 
    15722, 
    15723, 
    15724, 
    15725, 
    15726, 
    15727, 
    15728, 
    15729, 
    15730, 
    15731, 
    15732, 
    15733, 
    15734, 
    15735, 
    15736, 
    15737, 
    15738, 
    20922, 
    20923, 
    23835, 
    20926, 
    20928, 
    20929, 
    20930, 
    20931, 
    20934, 
    20935, 
    20936, 
    20937, 
    20938, 
    20940, 
    20941, 
    22811, 
    22812, 
    22814, 
    22815, 
    22816, 
    22817, 
    22818, 
    22819, 
    22820, 
    22823, 
    22824, 
    22826, 
    22827, 
    21077, 
    21078, 
    21080, 
    21081, 
    21082, 
    21083, 
    21084, 
    21085, 
    21087, 
    21088, 
    21089, 
    21090, 
    21091, 
    21092, 
    23847, 
    21094, 
    21095, 
    23255, 
    23256, 
    23251, 
    23252, 
    23284, 
    23285, 
    23286, 
    23287, 
    23830, 
    22837, 
    23831, 
    22839, 
    22840, 
    22841, 
    22842, 
    22846, 
    17634, 
    23208, 
    23209, 
    23210, 
    23211, 
    23212, 
    23213, 
    23214, 
    23215, 
    23216, 
    23217, 
    23218, 
    23219, 
    23220, 
    23221, 
    23222, 
    23223, 
    23224, 
    23225, 
    23226, 
    23227, 
    23228, 
    23229, 
    23230, 
    23231, 
    23232, 
    23257, 
    23258, 
    23259, 
    23260, 
    23261, 
    23262, 
    23263, 
    23264, 
    23265, 
    23266, 
    23267, 
    23268, 
    23269, 
    23270, 
    23271, 
    23272, 
    23273, 
    23274, 
    23275, 
    23276, 
    23277, 
    23278, 
    23279, 
    23280, 
    23281
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00464

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 170 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.image_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
26151 15153 variant_image 21726 0 V 0 amz_089.png 89 89 21726
26152 15154 variant_image 21727 0 V 0 amz_090.png 97 97 21727
26157 15156 variant_image 21732 0 V 0 amz_092.png 98 98 21732
28333 17634 variant_image 23908 0 V 0 integra_krd_100_ifr.jpg 518 469 23908
30951 23233 variant_image 26529 0 V 0 roto-zrv-v02_ico_zgkj-mg.png 135 135 26529
30952 23234 variant_image 26530 0 V 0 roto-zrv-v01_ico_rq7h-ej.png 135 135 26530
30953 23235 variant_image 26531 0 V 0 roto-zrv-v03_ico_6f7w-zo.png 135 135 26531
30954 23236 variant_image 26532 0 V 0 roto-zrv-v04_ico_8h9p-v5.png 135 135 26532
30955 23237 variant_image 26533 0 V 0 roto-zrv-v05_ico_yqyk-fp.png 135 135 26533
30956 23238 variant_image 26534 0 V 0 roto-zrv-v06_ico_ge60-ys.png 135 135 26534