Sandbox

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 (
    13248, 
    13270, 
    13249, 
    13271, 
    13250, 
    13272, 
    13251, 
    13273, 
    13252, 
    13274, 
    13253, 
    13275, 
    13254, 
    13276, 
    13255, 
    13277, 
    13256, 
    13278, 
    13257, 
    13279, 
    13258, 
    13280, 
    13882, 
    13260, 
    13282, 
    13261, 
    13283, 
    13262, 
    13284, 
    13263, 
    13285, 
    13264, 
    13286, 
    13265, 
    13287, 
    13266, 
    13288, 
    13267, 
    13289, 
    13268, 
    13290, 
    13269, 
    13291, 
    15533, 
    15534, 
    15932, 
    15933, 
    19936, 
    19937, 
    19950, 
    19938, 
    19939, 
    19949, 
    19940, 
    19941, 
    19942, 
    19943, 
    19944, 
    19945, 
    19946, 
    19947, 
    23773, 
    23774, 
    23775, 
    23776, 
    23777, 
    23778, 
    23779, 
    23780, 
    23781, 
    23792, 
    23817, 
    14378, 
    14379, 
    14380, 
    14381, 
    14382, 
    14383, 
    14384, 
    14385, 
    14386, 
    14387, 
    14388, 
    14389, 
    14390, 
    14391, 
    14392, 
    14393, 
    14394, 
    14395, 
    14396, 
    14397, 
    14398, 
    20878, 
    20879, 
    20880, 
    20881, 
    20882, 
    20883, 
    20884, 
    20885, 
    20886, 
    20887, 
    20889, 
    20890, 
    20891, 
    20892, 
    20893, 
    20894, 
    20900, 
    20901, 
    20902, 
    20903, 
    20904, 
    20905, 
    20906, 
    20907, 
    20908, 
    20909, 
    20912, 
    20913, 
    20914, 
    20915, 
    20916, 
    23845, 
    23843, 
    23846, 
    23844, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    23821, 
    22881, 
    23822, 
    22883, 
    22884, 
    22885, 
    23823, 
    22890, 
    20620, 
    22930, 
    22926, 
    23994, 
    22920, 
    22933, 
    22932, 
    22931, 
    22929, 
    22928, 
    23995, 
    22924, 
    22923, 
    23996, 
    22922, 
    22921, 
    22934, 
    22935, 
    23991, 
    22937, 
    22938, 
    22939, 
    22940, 
    22941, 
    22942, 
    23992, 
    22944, 
    22945, 
    23993, 
    22946, 
    22947, 
    20596, 
    20597, 
    20598, 
    20599, 
    20600, 
    20601, 
    20602, 
    20603, 
    20604, 
    20605, 
    20606, 
    20607, 
    20608, 
    20609, 
    20610, 
    20611, 
    20612, 
    20613, 
    20614, 
    20615, 
    20616, 
    20617
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00445

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		209	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