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 = 'de' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    7558, 
    7559, 
    7560, 
    7561, 
    7562, 
    7563, 
    7564, 
    7565, 
    7566, 
    7567, 
    7568, 
    7569, 
    7570, 
    7571, 
    7572, 
    7573, 
    7574, 
    7575, 
    7576, 
    7577, 
    7578, 
    7579, 
    7580, 
    7581, 
    7582, 
    7583, 
    7584, 
    7585, 
    7586, 
    7587, 
    7588, 
    7589, 
    7590, 
    7591, 
    7592, 
    7593, 
    7594, 
    7595, 
    7596, 
    7597, 
    7598, 
    7599, 
    7600, 
    7601, 
    7602, 
    7603, 
    7604, 
    7605, 
    7606, 
    7607, 
    7608, 
    7609, 
    7610, 
    7611, 
    7612, 
    7613, 
    7614, 
    7615, 
    7616, 
    7617, 
    7618, 
    7619, 
    7620, 
    7621, 
    7622, 
    7623, 
    7624, 
    7625, 
    7846, 
    7847, 
    7848, 
    7849, 
    7850, 
    7851, 
    7852, 
    7853, 
    7854, 
    7855, 
    7856, 
    7857, 
    7858, 
    7859, 
    7860, 
    7861, 
    7862, 
    7863, 
    7864, 
    7865, 
    7866, 
    7867, 
    7868, 
    7869, 
    7870, 
    7871, 
    7872, 
    7873, 
    7874, 
    7875, 
    7876, 
    7877, 
    7878, 
    7879, 
    7660, 
    7661, 
    7662, 
    7663, 
    7664, 
    15930, 
    7665, 
    7666, 
    7667, 
    15927, 
    15928, 
    15929, 
    23793, 
    23794, 
    23795, 
    23796, 
    23797, 
    23798, 
    23799, 
    23800, 
    23801, 
    23802, 
    23803, 
    23804, 
    23805, 
    23806, 
    14054, 
    14053, 
    14052, 
    14051, 
    14067, 
    14066, 
    14065, 
    14064, 
    14063, 
    14062, 
    14061, 
    14060, 
    14059, 
    14058, 
    14057, 
    14056, 
    14055, 
    7668, 
    7670, 
    7671, 
    7673, 
    7676, 
    11878, 
    11877, 
    19507, 
    15665, 
    15666, 
    15667, 
    15668, 
    15669, 
    15670, 
    15671, 
    7677, 
    7678, 
    7679, 
    7680, 
    7681, 
    7682, 
    7683, 
    7684
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.09202

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 168 Using index condition; 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