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, 
    43652, 43808, 43809, 43810, 43811, 
    43812, 33723, 34142, 34159, 34176, 
    34193, 34133, 34132, 34131, 34130, 
    34129, 34128, 34127, 34126, 34125, 
    34124, 34123, 34122, 34121, 34120, 
    34119, 34118, 19557, 19556, 3286, 18777, 
    18776, 18775, 18774, 18773, 3872, 855, 
    24508, 24509, 24510, 24511, 24512, 
    854, 24513, 24514, 24515, 35176, 35243, 
    35172, 35239, 35731, 35847, 35851, 
    35844, 35845, 35846, 1413, 23261, 23262, 
    23263, 46990, 46989, 46988, 46987, 
    46986, 46982, 464, 25550, 25551, 41429, 
    41478, 41479, 41480, 33724, 34226, 
    34243, 34202, 34203, 34204, 34205, 
    34206, 34207, 34208, 34209, 34210, 
    34211, 34212, 34213, 34214, 34215, 
    34216, 34217, 856, 24507, 34053, 34054, 
    34056, 34059, 34062, 34065, 34068, 
    34071, 34074, 34076, 34079, 34082, 
    34085, 34088, 34091, 34094, 34097, 
    34100
  ) 
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": 94.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,43652,43808,43809,43810,43811,43812,33723,34142,34159,34176,34193,34133,34132,34131,34130,34129,34128,34127,34126,34125,34124,34123,34122,34121,34120,34119,34118,19557,19556,3286,18777,18776,18775,18774,18773,3872,855,24508,24509,24510,24511,24512,854,24513,24514,24515,35176,35243,35172,35239,35731,35847,35851,35844,35845,35846,1413,23261,23262,23263,46990,46989,46988,46987,46986,46982,464,25550,25551,41429,41478,41479,41480,33724,34226,34243,34202,34203,34204,34205,34206,34207,34208,34209,34210,34211,34212,34213,34214,34215,34216,34217,856,24507,34053,34054,34056,34059,34062,34065,34068,34071,34074,34076,34079,34082,34085,34088,34091,34094,34097,34100)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}