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 (
    41428, 41475, 41476, 41477, 22676, 22675, 
    22674, 22673, 22672, 1775, 37665, 37666, 
    26662, 26663, 2248, 16802, 16801, 16800, 
    16799, 16798, 16797, 5467, 35733, 35879, 
    35880, 16826, 16825, 16824, 16823, 
    16822, 5448, 43546, 951, 18331, 18330, 
    18329, 18328, 18327, 4363, 26842, 26843, 
    2256, 18421, 18420, 18419, 18418, 18417, 
    18416, 18415, 4268, 18428, 18427, 18426, 
    18425, 18424, 18423, 18422, 4267, 26658, 
    26659, 2247, 41596, 41616, 26668, 26669, 
    2251, 37535, 37545, 37550, 37555, 37560, 
    37564, 37570, 37574, 37579, 37584, 
    37586, 37594, 37599, 37604, 37546, 
    45282, 45662, 45663, 45664, 45665, 
    45666, 45667, 41203, 41224, 41225, 
    41226, 16831, 16830, 16829, 16828, 
    16827, 5447
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00216

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": 78.40000153,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (41428,41475,41476,41477,22676,22675,22674,22673,22672,1775,37665,37666,26662,26663,2248,16802,16801,16800,16799,16798,16797,5467,35733,35879,35880,16826,16825,16824,16823,16822,5448,43546,951,18331,18330,18329,18328,18327,4363,26842,26843,2256,18421,18420,18419,18418,18417,18416,18415,4268,18428,18427,18426,18425,18424,18423,18422,4267,26658,26659,2247,41596,41616,26668,26669,2251,37535,37545,37550,37555,37560,37564,37570,37574,37579,37584,37586,37594,37599,37604,37546,45282,45662,45663,45664,45665,45666,45667,41203,41224,41225,41226,16831,16830,16829,16828,16827,5447)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}