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 (
    21119, 2439, 46840, 46839, 46838, 46715, 
    47009, 47099, 26334, 26333, 26332, 
    26331, 26330, 26329, 26328, 26327, 
    26326, 26325, 222, 21085, 2457, 1356, 
    23379, 23380, 23381, 23382, 48768, 
    48772, 48773, 48774, 48775, 20806, 
    20805, 20804, 15461, 6114, 17724, 17723, 
    5152, 18599, 4116, 41334, 41333, 37498, 
    37494, 37499, 37500, 37501, 37502, 
    37503, 37504, 37505, 37506, 37507, 
    37508, 37509, 37510, 37512, 37513, 
    37514, 21121, 2437, 18380, 4304, 5629, 
    50679, 41420, 41447, 41448, 41449, 
    41450, 47152, 47148, 48212, 48213
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00153

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": 68.1818161,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (21119,2439,46840,46839,46838,46715,47009,47099,26334,26333,26332,26331,26330,26329,26328,26327,26326,26325,222,21085,2457,1356,23379,23380,23381,23382,48768,48772,48773,48774,48775,20806,20805,20804,15461,6114,17724,17723,5152,18599,4116,41334,41333,37498,37494,37499,37500,37501,37502,37503,37504,37505,37506,37507,37508,37509,37510,37512,37513,37514,21121,2437,18380,4304,5629,50679,41420,41447,41448,41449,41450,47152,47148,48212,48213)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}