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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    220318, 
    215376, 
    215377, 
    225078, 
    225037, 
    225038, 
    225039, 
    225040, 
    225041, 
    225042, 
    225043, 
    225044, 
    225045, 
    225046, 
    225047, 
    225048, 
    225049, 
    225050, 
    225051, 
    225052, 
    225053, 
    237206, 
    237207, 
    225054, 
    242584, 
    225055, 
    225056, 
    225057, 
    225058, 
    225059, 
    242585, 
    225060, 
    225061, 
    225062, 
    225063, 
    225064, 
    225065, 
    225066, 
    225067, 
    242586, 
    225068, 
    242587, 
    225069, 
    225070, 
    225071, 
    225072, 
    242588, 
    225073, 
    225074, 
    225075, 
    225076, 
    225077, 
    225079, 
    225080, 
    238343, 
    225081, 
    225140, 
    225139, 
    225127, 
    225128, 
    225129, 
    225130, 
    225131, 
    225132, 
    225133, 
    225134, 
    225135, 
    225136, 
    225137, 
    225138, 
    225182, 
    225155, 
    225156, 
    225157, 
    225158, 
    225159, 
    225160, 
    225161, 
    237208, 
    237209, 
    225162, 
    242589, 
    225163, 
    225164, 
    225165, 
    225166, 
    225167, 
    242590, 
    225168, 
    225169, 
    225170, 
    225171, 
    225172, 
    225173, 
    225174, 
    225175, 
    242591, 
    225176, 
    242592, 
    225177, 
    225178, 
    225179, 
    225180, 
    225181, 
    242593, 
    240507, 
    240506, 
    240508, 
    240509, 
    240536, 
    240514, 
    240515, 
    240516, 
    240517, 
    240518, 
    240526, 
    240535, 
    240519, 
    240520, 
    240521, 
    240522, 
    240523, 
    240524, 
    240525, 
    240527, 
    240528, 
    240529, 
    240530, 
    240559, 
    240537, 
    240538, 
    240539, 
    240540, 
    240541, 
    240549, 
    240558, 
    240542, 
    240543, 
    240544, 
    240545, 
    240546, 
    240547, 
    240548, 
    240550, 
    240551, 
    240552, 
    240553, 
    240582, 
    240560, 
    240561, 
    240562, 
    240563, 
    240564, 
    240572, 
    240581, 
    240565, 
    240566, 
    240567, 
    240568, 
    240569, 
    240570, 
    240571, 
    240573, 
    240574, 
    240575, 
    240576
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00307

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": 166,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220318,215376,215377,225078,225037,225038,225039,225040,225041,225042,225043,225044,225045,225046,225047,225048,225049,225050,225051,225052,225053,237206,237207,225054,242584,225055,225056,225057,225058,225059,242585,225060,225061,225062,225063,225064,225065,225066,225067,242586,225068,242587,225069,225070,225071,225072,242588,225073,225074,225075,225076,225077,225079,225080,238343,225081,225140,225139,225127,225128,225129,225130,225131,225132,225133,225134,225135,225136,225137,225138,225182,225155,225156,225157,225158,225159,225160,225161,237208,237209,225162,242589,225163,225164,225165,225166,225167,242590,225168,225169,225170,225171,225172,225173,225174,225175,242591,225176,242592,225177,225178,225179,225180,225181,242593,240507,240506,240508,240509,240536,240514,240515,240516,240517,240518,240526,240535,240519,240520,240521,240522,240523,240524,240525,240527,240528,240529,240530,240559,240537,240538,240539,240540,240541,240549,240558,240542,240543,240544,240545,240546,240547,240548,240550,240551,240552,240553,240582,240560,240561,240562,240563,240564,240572,240581,240565,240566,240567,240568,240569,240570,240571,240573,240574,240575,240576)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["image_id"],
      "ref": ["cscart_migrate.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": ["cscart_migrate.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 = 'en' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result