SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    65838, 65888, 65889, 65890, 65891, 65892
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00076

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 29,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65838,65888,65889,65890,65891,65892)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["image_id"],
      "ref": ["cscart_migrate.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "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": ["cscart_migrate.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 = 'en' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result

pair_id object_id object_type image_id detailed_id type position image_type show_gallery gallery_category_id image_path alt image_x image_y images_image_id
72726 65838 product 0 84959 A 0 D 0 0 Ellington-LED-pendant-cord-16in-975-galvanized-creme-cloth-cord.jpg 16" Cassidy LED Globe Pendant, 975-Galvanized, Creme Cloth Cord 1000 1000 84959
72728 65888 product 0 84961 A 0 D 0 0 Ellington-LED-pendant-studio-12in-607-taupe-standard-white-cord.jpg 12" Cassidy LED Globe Studio Pendant, 607-Taupe, Standard White Cord 1000 1000 84961
72735 65889 product 0 84968 A 0 D 0 0 Ellington-LED-pendant-chain-12in-100-black-barn-red-swirl-cord.jpg 12" Cassidy LED Globe Chain Pendant, 100-Black, Barn Red & Black Swirl Cloth Cord 1000 1000 84968
72736 65889 product 0 84969 A 0 D 0 0 Ellington-LED-pendant-chain-16in-975-Galvanized-silver-cloth-cord.jpg 16" Cassidy LED Globe Chain Pendant, 975-Galvanized, Silver Cloth Cord 1000 1000 84969
72737 65889 product 0 84970 A 0 D 0 0 Ellington-LED-pendant-chain-12in-607-taupe-creme-cloth-cord.jpg 12" Cassidy LED Globe Chain Pendant, 607-Taupe, Creme Cloth Cord 1000 1000 84970
72738 65889 product 0 84971 A 0 D 0 0 Ellington-LED-pendant-chain-16in-206-matte-white-rust-cloth-cord.jpg 16" Cassidy LED Globe Chain Pendant, 206-Matte White, Rust Cloth Cord 1000 1000 84971
72743 65890 product 0 84976 A 0 D 0 0 Ellington-LED-pendant-stem-12in-607-Taupe.jpg 12" Cassidy LED Globe Stem Pendant, 607-Taupe 1000 1000 84976
72780 65891 product 0 85013 A 0 D 0 0 Ellington-LED-pendant-flush-12in-607-taupe.jpg 12" Cassidy LED Globe Flush Mount Light, 607-Taupe 1000 1000 85013
72781 65891 product 0 85014 A 0 D 0 0 Ellington-LED-pendant-flush-16in-206-matte-white.jpg 16" Cassidy LED Globe Flush Mount Light, 206-Matte White 1000 1000 85014
72782 65891 product 0 85015 A 0 D 0 0 Ellington-LED-pendant-flush-12in-100-black.jpg 12" Cassidy LED Globe Flush Mount Light 1000 1000 85015
72783 65891 product 0 85016 A 0 D 0 0 Ellington-LED-pendant-flush-16in-975-galvanized.jpg 16" Cassidy LED Globe Flush Mount Light, 975-Galvanized 1000 1000 85016
72785 65892 product 0 85018 A 0 D 0 0 Ellington-LED-gooseneck-16in-G22-630-Beige.jpg 16" Cassidy LED Globe Gooseneck Light, 630-Beige, G22 Gooseneck Arm, Decorative Backing Plate & Hex Cover 1000 1000 85018
72786 65892 product 0 85019 A 0 D 0 0 Ellington-LED-gooseneck-16in-G24-975-Galvanized.jpg 16" Cassidy LED Globe Gooseneck Light, 975-Galvanized, G24 Gooseneck Arm 1000 1000 85019
72793 65892 product 0 85026 A 0 D 0 0 Ellington-LED-gooseneck-16in-G12-206-matte-white.jpg 16" Cassidy LED Globe Gooseneck Light, 206-Matte White, G12 Gooseneck Arm 1000 1000 85026
72720 65838 product 0 84953 A 1 D 0 0 Ellington-LED-pendant-cord-12in-100-black-standard-black-cord.jpg 12" Cassidy LED Globe Pendant, 100-Black, Standard Black Cord 1000 1000 84953
72727 65888 product 0 84960 A 1 D 0 0 Ellington-LED-pendant-studio-12in-100-black-black-cloth-cord.jpg 12" Cassidy LED Globe Studio Pendant, 100-Black, Black Cloth Cord 1000 1000 84960
72794 65890 product 0 85027 A 1 D 0 0 Ellington-LED-pendant-stem-16in-206-matte-white.jpg 16" Cassidy LED Globe Stem Pendant, 206-Matte White 1000 1000 85027
72725 65838 product 0 84958 A 2 D 0 0 Ellington-LED-pendant-cord-16in-815-light-grey-rust-cloth-cord.jpg 16" Cassidy LED Globe Pendant, 815-Light Grey, Rust Cloth Cord 1000 1000 84958
72730 65888 product 0 84963 A 2 D 0 0 Ellington-LED-pendant-studio-16in-630-beige-rust-cloth-cord.jpg 16" Cassidy LED Globe Studio Pendant, 630-Beige, Rust Cloth Cord 1000 1000 84963
72746 65890 product 0 84979 A 2 D 0 0 Ellington-LED-pendant-stem-630-beige.jpg 16" Cassidy LED Globe Stem Pendant, 630-Beige 1000 1000 84979
72721 65838 product 0 84954 A 3 D 0 0 Ellington-LED-pendant-cord-12in-300-dark-green-emerald-green-cloth-cord.jpg 12" Cassidy LED Globe Pendant, 300-Dark Green, Emerald Green Cloth Cord 1000 1000 84954
72729 65888 product 0 84962 A 3 D 0 0 Ellington-LED-pendant-studio-16in-206-matte-white-creme-cloth-cord.jpg 16" Cassidy LED Globe Studio Pendant, 206-Matte White, Creme Cloth Cord 1000 1000 84962
72744 65890 product 0 84977 A 3 D 0 0 Ellington-LED-pendant-stem-16in-975-Galvanized.jpg 16" Cassidy LED Globe Stem Pendant, 975-Galvanized 1000 1000 84977
72724 65838 product 0 84957 A 4 D 0 0 Ellington-LED-pendant-cord-16in-630-beige-black-cloth-cord.jpg 16" Cassidy LED Globe Pendant, 630-Beige, Black Cloth Cord 1000 1000 84957
72722 65838 product 0 84955 A 5 D 0 0 Ellington-LED-pendant-cord-12in-380-chartreuse-standard-white-cord.jpg 12" Cassidy LED Globe Pendant, 380-Chartreuse, Standard White Cord, Mounting in 200-White 1000 1000 84955
72723 65838 product 0 84956 A 6 D 0 0 Ellington-LED-pendant-cord-16in-206-matte-white-standard-white-cord.jpg 16" Cassidy LED Globe Pendant, 206-Matte White, Standard White Cord 1000 1000 84956
72790 65838 product 0 85023 A 7 C 0 0 ellington-LED-pendant-cord-insetting-globe-700-navy-black-cloth-cord-on.jpg 16" Cassidy LED Globe Cord Pendant, 705-Navy, Black Cloth Cord 1000 1000 85023
72791 65838 product 0 85024 A 8 C 0 0 ellington-LED-pendant-cord-insetting-630-beige-rust-cloth-cord-on.jpg 12" Cassidy LED Globe Cord Pendant, 630-Beige, Rust Cloth Cord 1000 1000 85024
72792 65838 product 0 85025 A 9 C 0 0 Ellington-LED-pendant-cord-On.jpg 16" Cassidy LED Globe Cord Pendants, 200-White and 100-Black 1000 1000 85025