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 = 'vi' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    22404, 
    1893, 
    22686, 
    22685, 
    22684, 
    22683, 
    22682, 
    1773, 
    18610, 
    18608, 
    18607, 
    18606, 
    18605, 
    18604, 
    18603, 
    18602, 
    18601, 
    18600, 
    4113, 
    22183, 
    22178, 
    22177, 
    22176, 
    22175, 
    22174, 
    48503, 
    48509, 
    1946, 
    44946, 
    45163, 
    45166, 
    45169, 
    45172, 
    45175, 
    45178, 
    45181, 
    45161, 
    45162, 
    44994, 
    44943, 
    44988, 
    44991, 
    45006, 
    45003, 
    45000, 
    44997, 
    44986, 
    44987, 
    44944, 
    45117, 
    45120, 
    45123, 
    45126, 
    45129, 
    45132, 
    45135, 
    45115, 
    45116, 
    44947, 
    45186, 
    45189, 
    45192, 
    45195, 
    45198, 
    45201, 
    45204, 
    45184, 
    45185, 
    44945, 
    45140, 
    45143, 
    45146, 
    45149, 
    45152, 
    45155, 
    45158, 
    45138, 
    45139, 
    41429, 
    41478, 
    41479, 
    41480, 
    856, 
    24507, 
    42351, 
    41123, 
    36329, 
    36337, 
    43917, 
    43918, 
    43919, 
    6282, 
    43928, 
    43929, 
    6284, 
    41421, 
    41451, 
    41452, 
    41453, 
    41454, 
    1429, 
    23233, 
    23234, 
    23235, 
    23236, 
    23237, 
    23238, 
    23239, 
    6211, 
    47909, 
    47910, 
    47911, 
    47912, 
    47913, 
    47914, 
    18379, 
    4305, 
    33716, 
    33793, 
    33794, 
    33795, 
    18755, 
    18754, 
    51, 
    26620, 
    36339, 
    36349, 
    36347, 
    36345, 
    36343, 
    36341, 
    36340, 
    15612, 
    15611, 
    15610, 
    6050
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00899

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
            "table": {
              "table_name": "cscart_images_links",
              "access_type": "ALL",
              "possible_keys": ["object_id"],
              "rows": 125,
              "filtered": 100,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (22404,1893,22686,22685,22684,22683,22682,1773,18610,18608,18607,18606,18605,18604,18603,18602,18601,18600,4113,22183,22178,22177,22176,22175,22174,48503,48509,1946,44946,45163,45166,45169,45172,45175,45178,45181,45161,45162,44994,44943,44988,44991,45006,45003,45000,44997,44986,44987,44944,45117,45120,45123,45126,45129,45132,45135,45115,45116,44947,45186,45189,45192,45195,45198,45201,45204,45184,45185,44945,45140,45143,45146,45149,45152,45155,45158,45138,45139,41429,41478,41479,41480,856,24507,42351,41123,36329,36337,43917,43918,43919,6282,43928,43929,6284,41421,41451,41452,41453,41454,1429,23233,23234,23235,23236,23237,23238,23239,6211,47909,47910,47911,47912,47913,47914,18379,4305,33716,33793,33794,33795,18755,18754,51,26620,36339,36349,36347,36345,36343,36341,36340,15612,15611,15610,6050)"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "cscart_images",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["image_id"],
          "ref": ["dev_db.cscart_images_links.detailed_id"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "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": ["dev_db.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 = 'vi' and trigcond(cscart_images.image_id is not null))"
        }
      }
    ]
  }
}

Result

image_id image_path image_x image_y is_high_res pair_id object_id object_type detailed_id type position alt images_image_id
0 z5982992592675_fd3f26341bb2a2d79f585b91893fabc9-Photoroom.jpeg 2016 1512 N 2198600 18602 product 282259 M 0 282259
0 Glitter___Glow_2_ap0q-2v_ewm8-z0.png 1080 1080 N 2198601 18608 product 282260 M 0 282260
0 Light_Up_The_Night_3.png 1080 1080 N 2198608 18600 product 282267 M 0 282267
0 A_White_Christmas_3_d6k7-d4_vu28-b7.png 1080 1080 N 2198609 18601 product 282268 M 0 282268
0 A_Merry_Little_Christmas_3.png 1080 1080 N 2198610 18603 product 282269 M 0 282269
0 A_Christmas_Carol_2.png 1080 1080 N 2198611 18604 product 282270 M 0 282270
0 A_Warm_Embrace_4.png 1080 1080 N 2198612 18605 product 282271 M 0 282271
0 A_Bag_Of_Joy_2.png 1080 1080 N 2198613 18606 product 282272 M 0 282272
0 Cold_Nights,_Good_Vibes_4.png 1080 1080 N 2198614 18607 product 282273 M 0 282273
0 A_Christmas_Carol_2_odys-l5.png 1080 1080 N 2198616 18610 product 282275 M 0 282275
0 A_Bag_Of_Joy_2_p12u-x9.png 1080 1080 N 2198617 4113 product 282276 M 0 282276