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 (
    21886, 
    21887, 
    24005, 
    24007, 
    24009, 
    22062, 
    22063, 
    22064, 
    22065, 
    22066, 
    22067, 
    22068, 
    22069, 
    22071, 
    22070, 
    22072, 
    22073, 
    22074, 
    22075, 
    22076, 
    22077, 
    22078, 
    22079, 
    22080, 
    22081, 
    22082, 
    22083, 
    22084, 
    22085, 
    22086, 
    22087, 
    22088, 
    22089, 
    22090, 
    22091, 
    22092, 
    22093, 
    22094, 
    22095, 
    22096, 
    22097, 
    22098, 
    22099, 
    22100, 
    22101, 
    22102, 
    22103, 
    22104, 
    22105, 
    22106, 
    22107, 
    22108, 
    22109, 
    22110, 
    22111, 
    22112, 
    22113, 
    22114, 
    22115, 
    22116, 
    22117, 
    22138, 
    22139, 
    22140, 
    22141, 
    22142, 
    22143, 
    18185, 
    18186, 
    18187, 
    15718, 
    15719, 
    15720, 
    15721, 
    15722, 
    15723, 
    15724, 
    15725, 
    15726, 
    15727, 
    15728, 
    15729, 
    15730, 
    15731, 
    15732, 
    15733, 
    15734, 
    15735, 
    15736, 
    15737, 
    15738, 
    20530, 
    23997, 
    23998, 
    23999, 
    24000, 
    24001, 
    24002, 
    24003, 
    19567, 
    19568, 
    19570, 
    19562, 
    19561, 
    19571, 
    19565, 
    20506, 
    20507, 
    20508, 
    20509, 
    20510, 
    20511, 
    20512, 
    20513, 
    20514, 
    20515, 
    20516, 
    20517, 
    20518, 
    20519, 
    20520, 
    20521, 
    20522, 
    20523, 
    20524, 
    20525, 
    20526, 
    20527, 
    21897, 
    21898, 
    21900, 
    21901, 
    21896, 
    21902, 
    21904, 
    21903, 
    21905, 
    21906, 
    21907, 
    21908, 
    21910, 
    21911, 
    21909, 
    21899
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00366

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 150 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
30399 21886 variant_image 25976 0 V 0 odv_rollo_alu.jpg 200 200 25976
30400 21887 variant_image 25977 0 V 0 odv_rollo_white.jpg 200 200 25977
30531 21897 variant_image 26108 0 V 0 odv_rollo_1028_ico.jpg 166 228 26108
30532 21898 variant_image 26109 0 V 0 odv_rollo_1086_ico.jpg 166 228 26109
30533 21900 variant_image 26110 0 V 0 odv_rollo_4069_ico.jpg 166 228 26110
30534 21901 variant_image 26111 0 V 0 odv_rollo_4155_ico.jpg 166 228 26111
30535 21896 variant_image 26112 0 V 0 odv_rollo_4161_ico.jpg 166 228 26112
30536 21902 variant_image 26113 0 V 0 odv_rollo_4162_ico.jpg 166 228 26113
30537 21904 variant_image 26114 0 V 0 odv_rollo_4163_ico.jpg 166 228 26114
30538 21903 variant_image 26115 0 V 0 odv_rollo_4164_ico.jpg 166 228 26115
30539 21905 variant_image 26116 0 V 0 odv_rollo_4165_ico.jpg 166 228 26116
30540 21906 variant_image 26117 0 V 0 odv_rollo_4166_ico.jpg 166 228 26117
30541 21907 variant_image 26118 0 V 0 odv_rollo_4167_ico.jpg 166 228 26118
30542 21899 variant_image 26119 0 V 0 odv_rollo_9050_ico.jpg 166 228 26119
30543 21908 variant_image 26120 0 V 0 odv_rollo_4168_ico.jpg 166 228 26120
30544 21910 variant_image 26121 0 V 0 odv_rollo_4169_ico.jpg 166 228 26121
30545 21911 variant_image 26122 0 V 0 odv_rollo_4170_ico.jpg 166 228 26122
30546 21909 variant_image 26123 0 V 0 odv_rollo_4171_ico.jpg 166 228 26123
30583 22138 variant_image 26160 0 V 0 fakro_ZRH1.png 250 250 26160
30584 22139 variant_image 26161 0 V 0 fakro_ZRH12.jpg 248 249 26161
30585 22140 variant_image 26162 0 V 0 fakro_ZWR7.jpg 248 176 26162
30586 22141 variant_image 26163 0 V 0 fakro_ZRS24.jpg 245 250 26163