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 (
    21785, 21784, 21783, 2133, 21026, 21025, 
    2508, 18261, 18260, 4438, 33747, 49405, 
    50103, 50104, 50105, 50106, 50107, 
    50108, 263, 50109, 18764, 3877, 14794, 
    6615, 21779, 21778, 21777, 2135, 15607, 
    6056, 32612, 21028, 21027, 2507, 50086, 
    50085, 2501, 19287, 19286, 19285, 3526, 
    16589, 16587, 16586, 18762, 3879, 18379, 
    4305, 23418, 23419, 23420, 23421, 23422, 
    23423, 23424, 23425, 31641, 31820, 
    31821, 21022, 21021, 2510, 400, 48217, 
    14949, 14948, 6533
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00169

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": 53.59999847,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (21785,21784,21783,2133,21026,21025,2508,18261,18260,4438,33747,49405,50103,50104,50105,50106,50107,50108,263,50109,18764,3877,14794,6615,21779,21778,21777,2135,15607,6056,32612,21028,21027,2507,50086,50085,2501,19287,19286,19285,3526,16589,16587,16586,18762,3879,18379,4305,23418,23419,23420,23421,23422,23423,23424,23425,31641,31820,31821,21022,21021,2510,400,48217,14949,14948,6533)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}