SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 = 'ru' 
WHERE 
  cscart_images_links.object_type = 'blog' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    109, 107, 114, 115, 106, 105, 103, 104, 
    102, 101, 100, 99, 98, 97, 96
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00508

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 17,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'blog' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (109,107,114,115,106,105,103,104,102,101,100,99,98,97,96)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["image_id"],
      "ref": ["noframes_angrybeaver.cscart_images_links.image_id"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "108",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["noframes_angrybeaver.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'ru' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result

image_id image_path image_x image_y is_high_res transparent pair_id object_id object_type detailed_id type position alt images_image_id
30751 обложка_новостей_NF_6eel-mp.jpg 900 675 N N 25386 96 blog 0 M 0 30751
30752 KINGSMAN.jpg 900 675 N N 25387 97 blog 0 M 0 30752
30753 новость_алматы.jpg 885 663 N N 25388 98 blog 0 M 0 30753
30754 23_февраля_новость.jpg 900 675 N N 25389 99 blog 0 M 0 30754
30755 обложка_новостей_8_марта.jpg 900 675 N N 25390 100 blog 0 M 0 30755
30756 news1.jpg 900 1600 N N 25391 101 blog 0 M 0 30756
30757 обложка_оазис.jpg 900 675 N N 25392 102 blog 0 M 0 30757
30758 e0d1637e521f633b9a96eabdb6e826a9.jpg 305 245 N N 25393 103 blog 0 M 0 30758
30759 0d838b9bbc0908e3ad7580df063f343e.jpg 600 402 N N 25394 104 blog 0 M 0 30759
30760 обложка_новостей_итоги1.jpg 900 675 N N 25395 105 blog 0 M 0 30760
30761 новость_с_текстом.jpg 1237 1009 N N 25396 106 blog 0 M 0 30761
30762 обложка_8_марта.jpg 900 675 N N 25397 107 blog 0 M 0 30762
30764 обложка_новостей_Наурыз2_g56q-57.jpg 900 675 N N 25399 109 blog 0 M 0 30764
30769 обложка_новостей_НГ_КЗ.JPG 900 675 N N 25404 114 blog 0 M 0 30769
30770 independenceday.JPG 900 675 N N 25405 115 blog 0 M 0 30770