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 (
    33725, 48023, 48020, 48017, 48016, 48015, 
    33723, 34142, 34159, 34176, 34193, 
    34133, 34132, 34131, 34130, 34129, 
    34128, 34127, 34126, 34125, 34124, 
    34123, 34122, 34121, 34120, 34119, 
    34118, 33724, 34226, 34243, 34202, 
    34203, 34204, 34205, 34206, 34207, 
    34208, 34209, 34210, 34211, 34212, 
    34213, 34214, 34215, 34216, 34217, 
    34053, 34054, 34056, 34059, 34062, 
    34065, 34068, 34071, 34074, 34076, 
    34079, 34082, 34085, 34088, 34091, 
    34094, 34097, 34100, 50468, 50461, 
    50462, 50463, 50464, 50465, 50466, 
    50444, 50467, 50469, 50470, 50471, 
    50472, 50473, 50474, 50475, 50476, 
    33727, 34335, 34336, 34337, 34338, 
    34339, 34340, 34341, 34342, 34343, 
    34344, 34345, 34346, 34347, 34348, 
    34349, 34350
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00304

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 (33725,48023,48020,48017,48016,48015,33723,34142,34159,34176,34193,34133,34132,34131,34130,34129,34128,34127,34126,34125,34124,34123,34122,34121,34120,34119,34118,33724,34226,34243,34202,34203,34204,34205,34206,34207,34208,34209,34210,34211,34212,34213,34214,34215,34216,34217,34053,34054,34056,34059,34062,34065,34068,34071,34074,34076,34079,34082,34085,34088,34091,34094,34097,34100,50468,50461,50462,50463,50464,50465,50466,50444,50467,50469,50470,50471,50472,50473,50474,50475,50476,33727,34335,34336,34337,34338,34339,34340,34341,34342,34343,34344,34345,34346,34347,34348,34349,34350)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}