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 (
    226434, 
    226438, 
    226435, 
    226436, 
    226437, 
    226439, 
    226443, 
    226440, 
    226441, 
    226442, 
    226485, 
    226455, 
    226457, 
    226462, 
    226481, 
    244281, 
    226465, 
    226466, 
    244282, 
    239948, 
    226470, 
    226472, 
    226474, 
    226477, 
    226478, 
    226483, 
    231662, 
    231633, 
    231634, 
    231635, 
    231636, 
    231656, 
    231637, 
    231638, 
    231639, 
    231640, 
    231641, 
    231642, 
    231643, 
    231644, 
    231645, 
    231646, 
    231647, 
    231648, 
    231649, 
    231651, 
    231652, 
    231653, 
    231654, 
    231655, 
    231657, 
    231658, 
    231659, 
    231660, 
    231692, 
    231663, 
    231664, 
    231665, 
    231666, 
    231686, 
    231667, 
    231668, 
    231669, 
    231670, 
    231671, 
    231672, 
    231673, 
    231674, 
    231675, 
    231676, 
    231677, 
    231678, 
    231679, 
    231681, 
    231682, 
    231683, 
    231684, 
    231685, 
    231687, 
    231688, 
    231689, 
    231690, 
    231719, 
    231720, 
    231721, 
    231722, 
    231723, 
    231724, 
    231725, 
    231726, 
    231727, 
    231728, 
    231729, 
    231730, 
    231766, 
    231731, 
    231732, 
    231733, 
    231734, 
    231735, 
    231736, 
    237242, 
    237243, 
    231737, 
    241357, 
    231738, 
    231739, 
    231740, 
    231741, 
    231742, 
    241358, 
    231743, 
    231744, 
    231745, 
    231746, 
    231747, 
    231748, 
    231749, 
    231750, 
    241359, 
    231751, 
    241360, 
    231752, 
    231753, 
    231754, 
    231755, 
    231756, 
    241361, 
    242553, 
    242554, 
    242555, 
    242556, 
    231767, 
    231768, 
    231769
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00292

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": 135,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (226434,226438,226435,226436,226437,226439,226443,226440,226441,226442,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,231662,231633,231634,231635,231636,231656,231637,231638,231639,231640,231641,231642,231643,231644,231645,231646,231647,231648,231649,231651,231652,231653,231654,231655,231657,231658,231659,231660,231692,231663,231664,231665,231666,231686,231667,231668,231669,231670,231671,231672,231673,231674,231675,231676,231677,231678,231679,231681,231682,231683,231684,231685,231687,231688,231689,231690,231719,231720,231721,231722,231723,231724,231725,231726,231727,231728,231729,231730,231766,231731,231732,231733,231734,231735,231736,237242,237243,231737,241357,231738,231739,231740,231741,231742,241358,231743,231744,231745,231746,231747,231748,231749,231750,241359,231751,241360,231752,231753,231754,231755,231756,241361,242553,242554,242555,242556,231767,231768,231769)"
        }
      }
    },
    "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