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.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 = 'ru' 
WHERE 
  cscart_images_links.object_type = 'feature_variant' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    1385, 1291, 1310, 1405, 1267, 1406, 1373, 
    1408, 1315, 1264, 1407, 1336, 1364, 
    1362, 1306, 1324, 1327, 1491, 1275, 
    1490, 1308, 1489, 1488, 1370, 1252, 
    1402, 1346, 1273, 1492, 1307, 1630, 
    1629, 1287, 1631, 1383, 1386, 1533, 
    1434, 1456, 1441, 1541, 1544, 1468, 
    1455, 1470, 1466, 1443, 1464, 1539, 
    1435, 1438, 1469, 1474, 1439, 1465, 
    1535, 1537, 1536, 1440, 1398, 1471, 
    1540, 1453, 1452, 1467, 1454, 1436, 
    1437, 1473, 1472, 1542, 1449, 1529, 
    1528, 1358, 1427, 1263, 1423, 1258, 
    1426, 1345, 1425, 1355, 1424, 1428, 
    1299, 1429, 1251, 1320, 1431, 1301, 
    1260, 1433, 1340, 1304, 1319, 1337
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00189

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": 97,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'feature_variant' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (1385,1291,1310,1405,1267,1406,1373,1408,1315,1264,1407,1336,1364,1362,1306,1324,1327,1491,1275,1490,1308,1489,1488,1370,1252,1402,1346,1273,1492,1307,1630,1629,1287,1631,1383,1386,1533,1434,1456,1441,1541,1544,1468,1455,1470,1466,1443,1464,1539,1435,1438,1469,1474,1439,1465,1535,1537,1536,1440,1398,1471,1540,1453,1452,1467,1454,1436,1437,1473,1472,1542,1449,1529,1528,1358,1427,1263,1423,1258,1426,1345,1425,1355,1424,1428,1299,1429,1251,1320,1431,1301,1260,1433,1340,1304,1319,1337)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["image_id"],
      "ref": ["noframes_kz_new.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["noframes_kz_new.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'ru' and trigcond(cscart_images.image_id is not null))"
    }
  }
}