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 (
    18610, 18609, 18608, 18607, 18606, 18605, 
    18604, 18603, 18602, 18601, 18600, 
    4113, 36329, 36332, 36333, 36334, 36335, 
    36336, 36337, 36338, 36331, 36330, 
    36328, 36327, 36399, 36400, 36401, 
    36402, 36403, 36404, 36405, 36406, 
    36407, 36408, 36409, 36410, 36411, 
    36412, 36413, 36414, 36415, 36416, 
    48126, 48127, 48128, 48129, 48130, 
    48131, 48132, 48133, 48134
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.01287

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": 110,
              "filtered": 46.36363602,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (18610,18609,18608,18607,18606,18605,18604,18603,18602,18601,18600,4113,36329,36332,36333,36334,36335,36336,36337,36338,36331,36330,36328,36327,36399,36400,36401,36402,36403,36404,36405,36406,36407,36408,36409,36410,36411,36412,36413,36414,36415,36416,48126,48127,48128,48129,48130,48131,48132,48133,48134)"
            }
          }
        }
      },
      {
        "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 Hì€nh_F_y1ui-t4.jpg 1000 1000 N 2198615 18609 product 282274 M 0 282274
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