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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    22807, 
    22808, 
    22809, 
    16015, 
    16003, 
    22741, 
    22742, 
    22743, 
    22744, 
    22745, 
    22746, 
    22747, 
    22748, 
    22749, 
    22750, 
    22751, 
    22752, 
    22753, 
    22754, 
    22755, 
    22756, 
    22757, 
    22758, 
    22759, 
    22760, 
    22761, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    15365, 
    15366, 
    15363, 
    15364, 
    15362, 
    15367, 
    15368, 
    22739, 
    22740, 
    14710, 
    14711, 
    15924, 
    14712, 
    14713, 
    14714, 
    14715, 
    14716, 
    14718, 
    22801, 
    22802, 
    22803, 
    22804, 
    22805, 
    22806, 
    15153, 
    15154, 
    15156, 
    15718, 
    15719, 
    15720, 
    15721, 
    15722, 
    15723, 
    15724, 
    15725, 
    15726, 
    15727, 
    15728, 
    15729, 
    15730, 
    15731, 
    15732, 
    15733, 
    15734, 
    15735, 
    15736, 
    15737, 
    15738, 
    17657, 
    17658, 
    17659, 
    17660, 
    17661, 
    17662, 
    17663, 
    17664, 
    17665, 
    17666, 
    17667, 
    17668, 
    17669, 
    17670, 
    17671, 
    17672, 
    17673, 
    17674, 
    17675, 
    17676, 
    17677, 
    17678, 
    19255, 
    19258, 
    19261, 
    19266, 
    19271, 
    19274, 
    21252, 
    23816, 
    21256, 
    21257, 
    21258, 
    21259, 
    21260, 
    21261, 
    21265, 
    21268, 
    21318, 
    21322, 
    21323, 
    21324, 
    21325, 
    21326, 
    21327, 
    23818, 
    15104, 
    15105, 
    15553, 
    15106, 
    15107, 
    15554, 
    15108, 
    15109, 
    15110, 
    15111, 
    15112, 
    15113, 
    15114, 
    15115, 
    22321, 
    22320, 
    22319, 
    22318, 
    22317, 
    22316, 
    22315, 
    22314, 
    22322, 
    22323, 
    22324, 
    22325, 
    22326, 
    22327, 
    22328, 
    22329, 
    22330, 
    22331, 
    22334, 
    22344, 
    22354, 
    22332, 
    22333, 
    22335, 
    22338, 
    22339, 
    22340, 
    22343, 
    22345, 
    22349, 
    22731, 
    22732, 
    22734, 
    22735, 
    24196
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00452

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		193	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	type	image_path	image_x	image_y	images_image_id
26151	15153	variant_image	21726	V	amz_089.png	89	89	21726
26152	15154	variant_image	21727	V	amz_090.png	97	97	21727
26157	15156	variant_image	21732	V	amz_092.png	98	98	21732
27932	16003	variant_image	23507	V	AUB-002.jpg	100	100	23507
27944	16015	variant_image	23519	V	AUB-014.jpg	100	100	23519
30735	22330	variant_image	26313	V	arf_1_051_5pf0-3p_nvzq-c5.jpg	800	600	26313
30736	22331	variant_image	26314	V	arf_1_052_auoz-09_oabr-3k.jpg	800	600	26314
30737	22332	variant_image	26315	V	arf_2_053_qihi-4o_fz7u-jr.jpg	800	600	26315
30738	22333	variant_image	26316	V	arf_2_054_i69z-1q_amvx-so.jpg	800	600	26316
30739	22334	variant_image	26317	V	arf_1_055_jfxi-jn_r71k-9b.jpg	800	600	26317
30740	22335	variant_image	26318	V	arf_2_056_wvbi-ua_fx6f-nj.jpg	800	600	26318
30743	22338	variant_image	26321	V	arf_2_059_mys3-hw_ho2c-lv.jpg	800	600	26321
30744	22339	variant_image	26322	V	arf_2_226_x0p1-9d_0d32-xd.jpg	800	600	26322
30745	22340	variant_image	26323	V	arf_2_227_n9ik-fc_edal-sx.jpg	800	600	26323
30748	22343	variant_image	26326	V	arf_2_233_w74j-oc_9zzc-bl.jpg	800	600	26326
30749	22344	variant_image	26327	V	arf_1_255_rl2c-gf_7cyb-ew.jpg	800	600	26327
30750	22345	variant_image	26328	V	arf_2_256_si7i-j7_os9y-d2.jpg	800	600	26328
30754	22349	variant_image	26332	V	arf_2_260_b6lj-hn_fyne-a1.jpg	800	600	26332
30759	22354	variant_image	26337	V	arf_1_265_zu14-jf_n8ta-m4.jpg	800	600	26337
30868	22731	variant_image	26446	V	atr_dua_4208_ico_9p55-2n.jpg	327	328	26446
30869	22732	variant_image	26447	V	atr_dua_4212_ico_h598-ik.jpg	335	335	26447
30871	22734	variant_image	26449	V	atr_dua_4217_ico_j6i0-v3.jpg	332	333	26449
30872	22735	variant_image	26450	V	atr_dua_4219_ico_dan4-gq.jpg	331	327	26450
32488	24196	variant_image	28066	V	atr_dua_4204_ico_6lba-42.jpg	332	333	28066