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 (
    22173, 22172, 1943, 38152, 38332, 38146, 
    38328, 38329, 38145, 38327, 286, 26467, 
    26468, 47152, 47148, 48212, 48213, 
    18277, 18276, 18275, 4389, 15613, 6049, 
    18271, 4393, 22513, 1850, 20844, 20843, 
    20842, 2626, 18272, 4392, 18270, 18269, 
    4394, 38141, 38326, 20837, 20836, 20835, 
    20834, 20833, 20832, 20831, 20830, 
    2628, 18274, 4390, 732, 38147, 38330, 
    21764, 2148, 22533, 22532, 22531, 22530, 
    1840, 22512, 22511, 22510, 1852, 20849, 
    20848, 20847, 20846, 20845, 2625
  ) 
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": 125,
              "filtered": 55.20000076,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (22173,22172,1943,38152,38332,38146,38328,38329,38145,38327,286,26467,26468,47152,47148,48212,48213,18277,18276,18275,4389,15613,6049,18271,4393,22513,1850,20844,20843,20842,2626,18272,4392,18270,18269,4394,38141,38326,20837,20836,20835,20834,20833,20832,20831,20830,2628,18274,4390,732,38147,38330,21764,2148,22533,22532,22531,22530,1840,22512,22511,22510,1852,20849,20848,20847,20846,20845,2625)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}